Query Metrics
7
Database Queries
4
Different statements
4.34 ms
Query time
5
Invalid entities
11
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.83 ms (42.03%) |
4 |
SELECT t0_.param_nom AS param_nom_0, t0_.param_etat AS param_etat_1, t0_.param_value AS param_value_2 FROM tbl_param t0_
Parameters:
[] |
|
1.30 ms (29.92%) |
1 |
SELECT t0.file_id AS file_id_1, t0.file_name AS file_name_2, t0.file_ext AS file_ext_3, t0.file_size AS file_size_4, t0.origin_name AS origin_name_5, t0.file_path AS file_path_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.is_upload_graph AS is_upload_graph_10, t0.is_secured AS is_secured_11, t0.is_optimized AS is_optimized_12, t0.prelevement_id AS prelevement_id_13, t0.updated_by AS updated_by_14, t0.created_by AS created_by_15, t0.deleted_by AS deleted_by_16, t0.identification_materiaux_id AS identification_materiaux_id_17, t0.pieces_identification_id AS pieces_identification_id_18, t0.essais_speciaux_id AS essais_speciaux_id_19, t0.pieces_essais_speciaux_id AS pieces_essais_speciaux_id_20, t0.rapport_final_prelevement_id AS rapport_final_prelevement_id_21, t0.rapport_final_compactage_id AS rapport_final_compactage_id_22, t0.reglement_id AS reglement_id_23, t0.tbl_compactge_id AS tbl_compactge_id_24, t0.pieces_compactage_id AS pieces_compactage_id_25, t0.tbl_dossier_id AS tbl_dossier_id_26, t27.id AS id_28, t27.raison_social AS raison_social_29, t27.adresse AS adresse_30, t27.code_postal AS code_postal_31, t27.pays AS pays_32, t27.departement AS departement_33, t27.devise_principale AS devise_principale_34, t27.telephone AS telephone_35, t27.fax AS fax_36, t27.email AS email_37, t27.web AS web_38, t27.note AS note_39, t27.nom_contact AS nom_contact_40, t27.prenom_contact AS prenom_contact_41, t27.phone_contact AS phone_contact_42, t27.created_at AS created_at_43, t27.updated_at AS updated_at_44, t27.deleted_at AS deleted_at_45, t27.ice AS ice_46, t27.cnss AS cnss_47, t27.patente AS patente_48, t27.identifiant_fiscale AS identifiant_fiscale_49, t27.registre_commerce AS registre_commerce_50, t27.ville AS ville_51, t27.logo_societe_id AS logo_societe_id_52, t27.image_header_id AS image_header_id_53, t27.image_footer_id AS image_footer_id_54, t27.created_by AS created_by_55, t27.updated_by AS updated_by_56, t27.deleted_by AS deleted_by_57, t27.banque_id AS banque_id_58, t59.id AS id_60, t59.raison_social AS raison_social_61, t59.adresse AS adresse_62, t59.code_postal AS code_postal_63, t59.pays AS pays_64, t59.departement AS departement_65, t59.devise_principale AS devise_principale_66, t59.telephone AS telephone_67, t59.fax AS fax_68, t59.email AS email_69, t59.web AS web_70, t59.note AS note_71, t59.nom_contact AS nom_contact_72, t59.prenom_contact AS prenom_contact_73, t59.phone_contact AS phone_contact_74, t59.created_at AS created_at_75, t59.updated_at AS updated_at_76, t59.deleted_at AS deleted_at_77, t59.ice AS ice_78, t59.cnss AS cnss_79, t59.patente AS patente_80, t59.identifiant_fiscale AS identifiant_fiscale_81, t59.registre_commerce AS registre_commerce_82, t59.ville AS ville_83, t59.logo_societe_id AS logo_societe_id_84, t59.image_header_id AS image_header_id_85, t59.image_footer_id AS image_footer_id_86, t59.created_by AS created_by_87, t59.updated_by AS updated_by_88, t59.deleted_by AS deleted_by_89, t59.banque_id AS banque_id_90, t91.id AS id_92, t91.raison_social AS raison_social_93, t91.adresse AS adresse_94, t91.code_postal AS code_postal_95, t91.pays AS pays_96, t91.departement AS departement_97, t91.devise_principale AS devise_principale_98, t91.telephone AS telephone_99, t91.fax AS fax_100, t91.email AS email_101, t91.web AS web_102, t91.note AS note_103, t91.nom_contact AS nom_contact_104, t91.prenom_contact AS prenom_contact_105, t91.phone_contact AS phone_contact_106, t91.created_at AS created_at_107, t91.updated_at AS updated_at_108, t91.deleted_at AS deleted_at_109, t91.ice AS ice_110, t91.cnss AS cnss_111, t91.patente AS patente_112, t91.identifiant_fiscale AS identifiant_fiscale_113, t91.registre_commerce AS registre_commerce_114, t91.ville AS ville_115, t91.logo_societe_id AS logo_societe_id_116, t91.image_header_id AS image_header_id_117, t91.image_footer_id AS image_footer_id_118, t91.created_by AS created_by_119, t91.updated_by AS updated_by_120, t91.deleted_by AS deleted_by_121, t91.banque_id AS banque_id_122, t123.formation_id AS formation_id_124, t123.formation_lib AS formation_lib_125, t123.formation_lib_court AS formation_lib_court_126, t123.created_at AS created_at_127, t123.updated_at AS updated_at_128, t123.deleted_at AS deleted_at_129, t123.formation_file_id AS formation_file_id_130, t123.created_by AS created_by_131, t123.updated_by AS updated_by_132, t123.deleted_by AS deleted_by_133, t134.user_id AS user_id_135, t134.username AS username_136, t134.password AS password_137, t134.email AS email_138, t134.tel AS tel_139, t134.date_naissance AS date_naissance_140, t134.first_name AS first_name_141, t134.last_name AS last_name_142, t134.is_associe AS is_associe_143, t134.username_court AS username_court_144, t134.nbr_conncetion AS nbr_conncetion_145, t134.last_connection AS last_connection_146, t134.current_session_token AS current_session_token_147, t134.cin AS cin_148, t134.actif AS actif_149, t134.code_user AS code_user_150, t134.roles AS roles_151, t134.action_permission AS action_permission_152, t134.action_permission_technique AS action_permission_technique_153, t134.action_permission_excluded AS action_permission_excluded_154, t134.is_admin_permissions_technique AS is_admin_permissions_technique_155, t134.is_admin_editique AS is_admin_editique_156, t134.is_admin_session AS is_admin_session_157, t134.is_reviseur AS is_reviseur_158, t134.is_qualite AS is_qualite_159, t134.is_gestionnaire_equipement AS is_gestionnaire_equipement_160, t134.signature_user_id AS signature_user_id_161, t134.cachet_image_id AS cachet_image_id_162, t134.photo_id AS photo_id_163, t164.user_id AS user_id_165, t164.username AS username_166, t164.password AS password_167, t164.email AS email_168, t164.tel AS tel_169, t164.date_naissance AS date_naissance_170, t164.first_name AS first_name_171, t164.last_name AS last_name_172, t164.is_associe AS is_associe_173, t164.username_court AS username_court_174, t164.nbr_conncetion AS nbr_conncetion_175, t164.last_connection AS last_connection_176, t164.current_session_token AS current_session_token_177, t164.cin AS cin_178, t164.actif AS actif_179, t164.code_user AS code_user_180, t164.roles AS roles_181, t164.action_permission AS action_permission_182, t164.action_permission_technique AS action_permission_technique_183, t164.action_permission_excluded AS action_permission_excluded_184, t164.is_admin_permissions_technique AS is_admin_permissions_technique_185, t164.is_admin_editique AS is_admin_editique_186, t164.is_admin_session AS is_admin_session_187, t164.is_reviseur AS is_reviseur_188, t164.is_qualite AS is_qualite_189, t164.is_gestionnaire_equipement AS is_gestionnaire_equipement_190, t164.signature_user_id AS signature_user_id_191, t164.cachet_image_id AS cachet_image_id_192, t164.photo_id AS photo_id_193, t0.lnk_dossier_files_id AS lnk_dossier_files_id_194 FROM tbl_file t0 LEFT JOIN tbl_societe t27 ON t27.logo_societe_id = t0.file_id LEFT JOIN tbl_societe t59 ON t59.image_header_id = t0.file_id LEFT JOIN tbl_societe t91 ON t91.image_footer_id = t0.file_id LEFT JOIN ref_formation t123 ON t123.formation_file_id = t0.file_id LEFT JOIN user t134 ON t134.signature_user_id = t0.file_id LEFT JOIN user t164 ON t164.cachet_image_id = t0.file_id WHERE t0.file_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1192
]
|
|
0.68 ms (15.73%) |
1 |
SELECT t0.devis_id AS devis_id_1, t0.designation_devis AS designation_devis_2, t0.montant_ht AS montant_ht_3, t0.montant_ttc AS montant_ttc_4, t0.montant_tva AS montant_tva_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.num_devis AS num_devis_8, t0.num_count AS num_count_9, t0.annee_numero AS annee_numero_10, t0.num_devis_last_version AS num_devis_last_version_11, t0.op_number AS op_number_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.ancienne_version AS ancienne_version_16, t0.is_archive AS is_archive_17, t0.remarques AS remarques_18, t0.infos_particuliere AS infos_particuliere_19, t0.valide AS valide_20, t0.montant_retenue_is AS montant_retenue_is_21, t0.retenue_source_tva AS retenue_source_tva_22, t0.montant_retenue_tva AS montant_retenue_tva_23, t0.is_retenue_source_tva AS is_retenue_source_tva_24, t0.montant_acompte AS montant_acompte_25, t0.reste_a_paye_retenue_source AS reste_a_paye_retenue_source_26, t0.etat_id AS etat_id_27, t0.client_id AS client_id_28, t0.chantier_id AS chantier_id_29, t0.type_devis_id AS type_devis_id_30, t0.created_by AS created_by_31, t0.updated_by AS updated_by_32, t0.deleted_by AS deleted_by_33, t0.banque_id AS banque_id_34, t0.mode_reglement_id AS mode_reglement_id_35, t0.condition_reglement_id AS condition_reglement_id_36, t0.valider_par AS valider_par_37, t0.ref_retenue_source_id AS ref_retenue_source_id_38, t0.etat_devis_id AS etat_devis_id_39 FROM tbl_devis t0 WHERE t0.devis_id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[
"515"
]
|
|
0.54 ms (12.32%) |
1 |
SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.adresse AS adresse_3, t0.code_postal AS code_postal_4, t0.pays AS pays_5, t0.departement AS departement_6, t0.devise_principale AS devise_principale_7, t0.telephone AS telephone_8, t0.fax AS fax_9, t0.email AS email_10, t0.web AS web_11, t0.note AS note_12, t0.nom_contact AS nom_contact_13, t0.prenom_contact AS prenom_contact_14, t0.phone_contact AS phone_contact_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.deleted_at AS deleted_at_18, t0.ice AS ice_19, t0.cnss AS cnss_20, t0.patente AS patente_21, t0.identifiant_fiscale AS identifiant_fiscale_22, t0.registre_commerce AS registre_commerce_23, t0.ville AS ville_24, t0.logo_societe_id AS logo_societe_id_25, t0.image_header_id AS image_header_id_26, t0.image_footer_id AS image_footer_id_27, t0.created_by AS created_by_28, t0.updated_by AS updated_by_29, t0.deleted_by AS deleted_by_30, t0.banque_id AS banque_id_31 FROM tbl_societe t0 WHERE t0.id = ?
Parameters:
[
1
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\TblSociete | 1 |
| App\Entity\RefVille | 1 |
| App\Entity\TblFile | 1 |
| App\Entity\User | 1 |
| App\Entity\TblDevis | 1 |
| App\Entity\TblClient | 1 |
| App\Entity\TblChantiers | 1 |
| App\Entity\RefTypeDevis | 1 |
| App\Entity\RefModeReglement | 1 |
| App\Entity\RefConditionReglement | 1 |
| App\Entity\RefEtatDevis | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\TblParam | No errors. |
| App\Entity\TblSociete | No errors. |
| App\Entity\RefVille | No errors. |
| App\Entity\TblFile | No errors. |
| App\Entity\User | No errors. |
| App\Entity\RefBanque | No errors. |
| App\Entity\RefAccreditation | No errors. |
| App\Entity\TblPrelevements |
|
| App\Entity\TblIdentificationMateriaux | No errors. |
| App\Entity\EssaisSpeciaux\TblEssaisSpeciaux |
|
| App\Entity\TblCompactage |
|
| App\Entity\TblReglement | No errors. |
| App\Entity\TblDossier | No errors. |
| App\Entity\RefFormation | No errors. |
| App\Entity\LnkDossierFiles | No errors. |
| App\Entity\IdentificationMateriaux\LnkIdentificationMateriauxFiles | No errors. |
| App\Entity\LnkQuestionsFiles | No errors. |
| App\Entity\LnkDocumentationFiles | No errors. |
| App\Entity\TblDevis |
|
| App\Entity\RefEtat | No errors. |
| App\Entity\TblClient |
|
| App\Entity\TblChantiers | No errors. |
| App\Entity\RefTypeDevis | No errors. |
| App\Entity\RefModeReglement | No errors. |
| App\Entity\RefConditionReglement | No errors. |
| App\Entity\RefRetenueSource | No errors. |
| App\Entity\RefEtatDevis | No errors. |
| App\Entity\RefEssai | No errors. |
| App\Entity\TblDetailDevis | No errors. |
| App\Entity\TblClassementDetailsDevis | No errors. |