Symfony Profiler

Query Metrics

6 Database Queries

3 Different statements

3.80 ms Query time

3 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.84 ms (48.43%)	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: [] View formatted query View runnable query Explain query 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_ 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_;
1.37 ms (36.00%)	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`] View formatted query View runnable query Explain query 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) ) 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 = 1192 AND ((t0.deleted_at IS NULL));
0.59 ms (15.57%)	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`] View formatted query View runnable query Explain query 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 = ? 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 = 1;

Time▼

Count

Info

1.84 ms
(48.43%)

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:

[]

View formatted query View runnable query Explain query

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_

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_;

1.37 ms
(36.00%)

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
]

View formatted query View runnable query Explain query

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)
  )

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 = 1192 AND ((t0.deleted_at IS NULL));

0.59 ms
(15.57%)

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
]

View formatted query View runnable query Explain query

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 = ?

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 = 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

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	The association App\Entity\TblPrelevements#attachementFacturer refers to the inverse side field App\Entity\TblAttachement#tblPrelevement which does not exist.
App\Entity\TblIdentificationMateriaux	No errors.
App\Entity\EssaisSpeciaux\TblEssaisSpeciaux	The association App\Entity\EssaisSpeciaux\TblEssaisSpeciaux#attachementFacturer refers to the inverse side field App\Entity\TblAttachement#tblEssaisSpeciaux which does not exist. The association App\Entity\EssaisSpeciaux\TblEssaisSpeciaux#refTypeEmplacement refers to the inverse side field App\Entity\IdentificationMateriaux\RefTypeEmplacement#essaisSpeciaux which does not exist.
App\Entity\TblCompactage	The association App\Entity\TblCompactage#attachementFacturer refers to the inverse side field App\Entity\TblAttachement#tblCompactages which does not exist.
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.

Symfony Profiler

GET https://laboest-uij9r.labcorpbtp.com/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping