Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

309.77 ms Query time

0 Invalid entities

3276 Managed entities

Grouped Statements

Show all queries

Time▼	Count	Info
309.77 ms (100.00%)	1	SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1, t0_.state AS state_2, t0_.volume AS volume_3, t0_.categorie AS categorie_4, t0_.synonyme AS synonyme_5, t0_.code AS code_6, t0_.precisionn AS precisionn_7, t0_.comment AS comment_8, t0_.file AS file_9, t0_.is_privilege AS is_privilege_10, t0_.rapid_delivery AS rapid_delivery_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, c1_.id AS id_14, c1_.active AS active_15, c2_.id AS id_16, c2_.delai AS delai_17, c2_.prix AS prix_18, c2_.techniquep AS techniquep_19, c2_.types AS types_20, u3_.id AS id_21, u3_.username AS username_22, u3_.roles AS roles_23, u3_.nom_complet AS nom_complet_24, u3_.email AS email_25, u3_.tel_fix AS tel_fix_26, u3_.valid AS valid_27, u3_.deleted AS deleted_28, u3_.password AS password_29, u3_.admin AS admin_30, u3_.address AS address_31, u3_.logo AS logo_32, u3_.image AS image_33, u3_.patente AS patente_34, u3_.updated_at AS updated_at_35, u3_.labo_name AS labo_name_36, u3_.ville AS ville_37, u3_.gouvernorat AS gouvernorat_38, u3_.postal_code AS postal_code_39, u3_.forme_juridique AS forme_juridique_40, u3_.num_matricule_fiscale AS num_matricule_fiscale_41, u3_.denomination_sociale AS denomination_sociale_42, u3_.nom_gerant AS nom_gerant_43, u3_.subscription_type AS subscription_type_44, u3_.subscription_period AS subscription_period_45, u3_.code AS code_46, u3_.external_id AS external_id_47, u3_.quota AS quota_48, u3_.switcher AS switcher_49, u3_.date_debut AS date_debut_50, u3_.date_fin AS date_fin_51, u3_.priceab AS priceab_52, u3_.contract AS contract_53, u3_.quotainit AS quotainit_54, u3_.sitcher_show AS sitcher_show_55, u3_.is_sendmail AS is_sendmail_56, u3_.is_privilege AS is_privilege_57, u3_.has_group AS has_group_58, u3_.is_super_agent AS is_super_agent_59, u3_.latitude AS latitude_60, u3_.longitude AS longitude_61, u3_.is_analyse_mod AS is_analyse_mod_62, u3_.firstname AS firstname_63, u3_.lastname AS lastname_64, u3_.tel_mobile AS tel_mobile_65, u3_.gender AS gender_66, u3_.distance_calc AS distance_calc_67, u3_.see_only_one_lab AS see_only_one_lab_68, u3_.enable_login_tracking AS enable_login_tracking_69, u4_.id AS id_70, u4_.username AS username_71, u4_.roles AS roles_72, u4_.nom_complet AS nom_complet_73, u4_.email AS email_74, u4_.tel_fix AS tel_fix_75, u4_.valid AS valid_76, u4_.deleted AS deleted_77, u4_.password AS password_78, u4_.admin AS admin_79, u4_.address AS address_80, u4_.logo AS logo_81, u4_.image AS image_82, u4_.patente AS patente_83, u4_.updated_at AS updated_at_84, u4_.labo_name AS labo_name_85, u4_.ville AS ville_86, u4_.gouvernorat AS gouvernorat_87, u4_.postal_code AS postal_code_88, u4_.forme_juridique AS forme_juridique_89, u4_.num_matricule_fiscale AS num_matricule_fiscale_90, u4_.denomination_sociale AS denomination_sociale_91, u4_.nom_gerant AS nom_gerant_92, u4_.subscription_type AS subscription_type_93, u4_.subscription_period AS subscription_period_94, u4_.code AS code_95, u4_.external_id AS external_id_96, u4_.quota AS quota_97, u4_.switcher AS switcher_98, u4_.date_debut AS date_debut_99, u4_.date_fin AS date_fin_100, u4_.priceab AS priceab_101, u4_.contract AS contract_102, u4_.quotainit AS quotainit_103, u4_.sitcher_show AS sitcher_show_104, u4_.is_sendmail AS is_sendmail_105, u4_.is_privilege AS is_privilege_106, u4_.has_group AS has_group_107, u4_.is_super_agent AS is_super_agent_108, u4_.latitude AS latitude_109, u4_.longitude AS longitude_110, u4_.is_analyse_mod AS is_analyse_mod_111, u4_.firstname AS firstname_112, u4_.lastname AS lastname_113, u4_.tel_mobile AS tel_mobile_114, u4_.gender AS gender_115, u4_.distance_calc AS distance_calc_116, u4_.see_only_one_lab AS see_only_one_lab_117, u4_.enable_login_tracking AS enable_login_tracking_118, d5_.id AS id_119, d5_.prix AS prix_120, t6_.id AS id_121, t6_.libelle AS libelle_122, p7_.id AS id_123, p7_.preleve AS preleve_124, t8_.id AS id_125, t8_.temp AS temp_126, c1_.traitant_id AS traitant_id_127, c1_.type_analyse_id AS type_analyse_id_128, c2_.catalogue_id AS catalogue_id_129, u3_.userby_id AS userby_id_130, u3_.catalogue_id AS catalogue_id_131, u4_.userby_id AS userby_id_132, u4_.catalogue_id AS catalogue_id_133, d5_.analyse_id AS analyse_id_134, d5_.technique_id AS technique_id_135, d5_.delai_id AS delai_id_136 FROM type_analyse t0_ LEFT JOIN catalogue c1_ ON t0_.id = c1_.type_analyse_id LEFT JOIN catalogue_detail_analyse c2_ ON c1_.id = c2_.catalogue_id LEFT JOIN user u3_ ON c1_.id = u3_.catalogue_id LEFT JOIN user u4_ ON c1_.traitant_id = u4_.id LEFT JOIN detail_analyse d5_ ON t0_.id = d5_.analyse_id LEFT JOIN technique_prelev t6_ ON d5_.technique_id = t6_.id LEFT JOIN detail_analyse_preleve d9_ ON d5_.id = d9_.detail_analyse_id LEFT JOIN preleve p7_ ON p7_.id = d9_.preleve_id LEFT JOIN type_analyse_temperature t10_ ON t0_.id = t10_.type_analyse_id LEFT JOIN temperature t8_ ON t8_.id = t10_.temperature_id ORDER BY t0_.name ASC Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1, t0_.state AS state_2, t0_.volume AS volume_3, t0_.categorie AS categorie_4, t0_.synonyme AS synonyme_5, t0_.code AS code_6, t0_.precisionn AS precisionn_7, t0_.comment AS comment_8, t0_.file AS file_9, t0_.is_privilege AS is_privilege_10, t0_.rapid_delivery AS rapid_delivery_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, c1_.id AS id_14, c1_.active AS active_15, c2_.id AS id_16, c2_.delai AS delai_17, c2_.prix AS prix_18, c2_.techniquep AS techniquep_19, c2_.types AS types_20, u3_.id AS id_21, u3_.username AS username_22, u3_.roles AS roles_23, u3_.nom_complet AS nom_complet_24, u3_.email AS email_25, u3_.tel_fix AS tel_fix_26, u3_.valid AS valid_27, u3_.deleted AS deleted_28, u3_.password AS password_29, u3_.admin AS admin_30, u3_.address AS address_31, u3_.logo AS logo_32, u3_.image AS image_33, u3_.patente AS patente_34, u3_.updated_at AS updated_at_35, u3_.labo_name AS labo_name_36, u3_.ville AS ville_37, u3_.gouvernorat AS gouvernorat_38, u3_.postal_code AS postal_code_39, u3_.forme_juridique AS forme_juridique_40, u3_.num_matricule_fiscale AS num_matricule_fiscale_41, u3_.denomination_sociale AS denomination_sociale_42, u3_.nom_gerant AS nom_gerant_43, u3_.subscription_type AS subscription_type_44, u3_.subscription_period AS subscription_period_45, u3_.code AS code_46, u3_.external_id AS external_id_47, u3_.quota AS quota_48, u3_.switcher AS switcher_49, u3_.date_debut AS date_debut_50, u3_.date_fin AS date_fin_51, u3_.priceab AS priceab_52, u3_.contract AS contract_53, u3_.quotainit AS quotainit_54, u3_.sitcher_show AS sitcher_show_55, u3_.is_sendmail AS is_sendmail_56, u3_.is_privilege AS is_privilege_57, u3_.has_group AS has_group_58, u3_.is_super_agent AS is_super_agent_59, u3_.latitude AS latitude_60, u3_.longitude AS longitude_61, u3_.is_analyse_mod AS is_analyse_mod_62, u3_.firstname AS firstname_63, u3_.lastname AS lastname_64, u3_.tel_mobile AS tel_mobile_65, u3_.gender AS gender_66, u3_.distance_calc AS distance_calc_67, u3_.see_only_one_lab AS see_only_one_lab_68, u3_.enable_login_tracking AS enable_login_tracking_69, u4_.id AS id_70, u4_.username AS username_71, u4_.roles AS roles_72, u4_.nom_complet AS nom_complet_73, u4_.email AS email_74, u4_.tel_fix AS tel_fix_75, u4_.valid AS valid_76, u4_.deleted AS deleted_77, u4_.password AS password_78, u4_.admin AS admin_79, u4_.address AS address_80, u4_.logo AS logo_81, u4_.image AS image_82, u4_.patente AS patente_83, u4_.updated_at AS updated_at_84, u4_.labo_name AS labo_name_85, u4_.ville AS ville_86, u4_.gouvernorat AS gouvernorat_87, u4_.postal_code AS postal_code_88, u4_.forme_juridique AS forme_juridique_89, u4_.num_matricule_fiscale AS num_matricule_fiscale_90, u4_.denomination_sociale AS denomination_sociale_91, u4_.nom_gerant AS nom_gerant_92, u4_.subscription_type AS subscription_type_93, u4_.subscription_period AS subscription_period_94, u4_.code AS code_95, u4_.external_id AS external_id_96, u4_.quota AS quota_97, u4_.switcher AS switcher_98, u4_.date_debut AS date_debut_99, u4_.date_fin AS date_fin_100, u4_.priceab AS priceab_101, u4_.contract AS contract_102, u4_.quotainit AS quotainit_103, u4_.sitcher_show AS sitcher_show_104, u4_.is_sendmail AS is_sendmail_105, u4_.is_privilege AS is_privilege_106, u4_.has_group AS has_group_107, u4_.is_super_agent AS is_super_agent_108, u4_.latitude AS latitude_109, u4_.longitude AS longitude_110, u4_.is_analyse_mod AS is_analyse_mod_111, u4_.firstname AS firstname_112, u4_.lastname AS lastname_113, u4_.tel_mobile AS tel_mobile_114, u4_.gender AS gender_115, u4_.distance_calc AS distance_calc_116, u4_.see_only_one_lab AS see_only_one_lab_117, u4_.enable_login_tracking AS enable_login_tracking_118, d5_.id AS id_119, d5_.prix AS prix_120, t6_.id AS id_121, t6_.libelle AS libelle_122, p7_.id AS id_123, p7_.preleve AS preleve_124, t8_.id AS id_125, t8_.temp AS temp_126, c1_.traitant_id AS traitant_id_127, c1_.type_analyse_id AS type_analyse_id_128, c2_.catalogue_id AS catalogue_id_129, u3_.userby_id AS userby_id_130, u3_.catalogue_id AS catalogue_id_131, u4_.userby_id AS userby_id_132, u4_.catalogue_id AS catalogue_id_133, d5_.analyse_id AS analyse_id_134, d5_.technique_id AS technique_id_135, d5_.delai_id AS delai_id_136 FROM type_analyse t0_ LEFT JOIN catalogue c1_ ON t0_.id = c1_.type_analyse_id LEFT JOIN catalogue_detail_analyse c2_ ON c1_.id = c2_.catalogue_id LEFT JOIN user u3_ ON c1_.id = u3_.catalogue_id LEFT JOIN user u4_ ON c1_.traitant_id = u4_.id LEFT JOIN detail_analyse d5_ ON t0_.id = d5_.analyse_id LEFT JOIN technique_prelev t6_ ON d5_.technique_id = t6_.id LEFT JOIN detail_analyse_preleve d9_ ON d5_.id = d9_.detail_analyse_id LEFT JOIN preleve p7_ ON p7_.id = d9_.preleve_id LEFT JOIN type_analyse_temperature t10_ ON t0_.id = t10_.type_analyse_id LEFT JOIN temperature t8_ ON t8_.id = t10_.temperature_id ORDER BY t0_.name ASC SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1, t0_.state AS state_2, t0_.volume AS volume_3, t0_.categorie AS categorie_4, t0_.synonyme AS synonyme_5, t0_.code AS code_6, t0_.precisionn AS precisionn_7, t0_.comment AS comment_8, t0_.file AS file_9, t0_.is_privilege AS is_privilege_10, t0_.rapid_delivery AS rapid_delivery_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, c1_.id AS id_14, c1_.active AS active_15, c2_.id AS id_16, c2_.delai AS delai_17, c2_.prix AS prix_18, c2_.techniquep AS techniquep_19, c2_.types AS types_20, u3_.id AS id_21, u3_.username AS username_22, u3_.roles AS roles_23, u3_.nom_complet AS nom_complet_24, u3_.email AS email_25, u3_.tel_fix AS tel_fix_26, u3_.valid AS valid_27, u3_.deleted AS deleted_28, u3_.password AS password_29, u3_.admin AS admin_30, u3_.address AS address_31, u3_.logo AS logo_32, u3_.image AS image_33, u3_.patente AS patente_34, u3_.updated_at AS updated_at_35, u3_.labo_name AS labo_name_36, u3_.ville AS ville_37, u3_.gouvernorat AS gouvernorat_38, u3_.postal_code AS postal_code_39, u3_.forme_juridique AS forme_juridique_40, u3_.num_matricule_fiscale AS num_matricule_fiscale_41, u3_.denomination_sociale AS denomination_sociale_42, u3_.nom_gerant AS nom_gerant_43, u3_.subscription_type AS subscription_type_44, u3_.subscription_period AS subscription_period_45, u3_.code AS code_46, u3_.external_id AS external_id_47, u3_.quota AS quota_48, u3_.switcher AS switcher_49, u3_.date_debut AS date_debut_50, u3_.date_fin AS date_fin_51, u3_.priceab AS priceab_52, u3_.contract AS contract_53, u3_.quotainit AS quotainit_54, u3_.sitcher_show AS sitcher_show_55, u3_.is_sendmail AS is_sendmail_56, u3_.is_privilege AS is_privilege_57, u3_.has_group AS has_group_58, u3_.is_super_agent AS is_super_agent_59, u3_.latitude AS latitude_60, u3_.longitude AS longitude_61, u3_.is_analyse_mod AS is_analyse_mod_62, u3_.firstname AS firstname_63, u3_.lastname AS lastname_64, u3_.tel_mobile AS tel_mobile_65, u3_.gender AS gender_66, u3_.distance_calc AS distance_calc_67, u3_.see_only_one_lab AS see_only_one_lab_68, u3_.enable_login_tracking AS enable_login_tracking_69, u4_.id AS id_70, u4_.username AS username_71, u4_.roles AS roles_72, u4_.nom_complet AS nom_complet_73, u4_.email AS email_74, u4_.tel_fix AS tel_fix_75, u4_.valid AS valid_76, u4_.deleted AS deleted_77, u4_.password AS password_78, u4_.admin AS admin_79, u4_.address AS address_80, u4_.logo AS logo_81, u4_.image AS image_82, u4_.patente AS patente_83, u4_.updated_at AS updated_at_84, u4_.labo_name AS labo_name_85, u4_.ville AS ville_86, u4_.gouvernorat AS gouvernorat_87, u4_.postal_code AS postal_code_88, u4_.forme_juridique AS forme_juridique_89, u4_.num_matricule_fiscale AS num_matricule_fiscale_90, u4_.denomination_sociale AS denomination_sociale_91, u4_.nom_gerant AS nom_gerant_92, u4_.subscription_type AS subscription_type_93, u4_.subscription_period AS subscription_period_94, u4_.code AS code_95, u4_.external_id AS external_id_96, u4_.quota AS quota_97, u4_.switcher AS switcher_98, u4_.date_debut AS date_debut_99, u4_.date_fin AS date_fin_100, u4_.priceab AS priceab_101, u4_.contract AS contract_102, u4_.quotainit AS quotainit_103, u4_.sitcher_show AS sitcher_show_104, u4_.is_sendmail AS is_sendmail_105, u4_.is_privilege AS is_privilege_106, u4_.has_group AS has_group_107, u4_.is_super_agent AS is_super_agent_108, u4_.latitude AS latitude_109, u4_.longitude AS longitude_110, u4_.is_analyse_mod AS is_analyse_mod_111, u4_.firstname AS firstname_112, u4_.lastname AS lastname_113, u4_.tel_mobile AS tel_mobile_114, u4_.gender AS gender_115, u4_.distance_calc AS distance_calc_116, u4_.see_only_one_lab AS see_only_one_lab_117, u4_.enable_login_tracking AS enable_login_tracking_118, d5_.id AS id_119, d5_.prix AS prix_120, t6_.id AS id_121, t6_.libelle AS libelle_122, p7_.id AS id_123, p7_.preleve AS preleve_124, t8_.id AS id_125, t8_.temp AS temp_126, c1_.traitant_id AS traitant_id_127, c1_.type_analyse_id AS type_analyse_id_128, c2_.catalogue_id AS catalogue_id_129, u3_.userby_id AS userby_id_130, u3_.catalogue_id AS catalogue_id_131, u4_.userby_id AS userby_id_132, u4_.catalogue_id AS catalogue_id_133, d5_.analyse_id AS analyse_id_134, d5_.technique_id AS technique_id_135, d5_.delai_id AS delai_id_136 FROM type_analyse t0_ LEFT JOIN catalogue c1_ ON t0_.id = c1_.type_analyse_id LEFT JOIN catalogue_detail_analyse c2_ ON c1_.id = c2_.catalogue_id LEFT JOIN user u3_ ON c1_.id = u3_.catalogue_id LEFT JOIN user u4_ ON c1_.traitant_id = u4_.id LEFT JOIN detail_analyse d5_ ON t0_.id = d5_.analyse_id LEFT JOIN technique_prelev t6_ ON d5_.technique_id = t6_.id LEFT JOIN detail_analyse_preleve d9_ ON d5_.id = d9_.detail_analyse_id LEFT JOIN preleve p7_ ON p7_.id = d9_.preleve_id LEFT JOIN type_analyse_temperature t10_ ON t0_.id = t10_.type_analyse_id LEFT JOIN temperature t8_ ON t8_.id = t10_.temperature_id ORDER BY t0_.name ASC;

Time▼

Count

Info

309.77 ms
(100.00%)

SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1, t0_.state AS state_2, t0_.volume AS volume_3, t0_.categorie AS categorie_4, t0_.synonyme AS synonyme_5, t0_.code AS code_6, t0_.precisionn AS precisionn_7, t0_.comment AS comment_8, t0_.file AS file_9, t0_.is_privilege AS is_privilege_10, t0_.rapid_delivery AS rapid_delivery_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, c1_.id AS id_14, c1_.active AS active_15, c2_.id AS id_16, c2_.delai AS delai_17, c2_.prix AS prix_18, c2_.techniquep AS techniquep_19, c2_.types AS types_20, u3_.id AS id_21, u3_.username AS username_22, u3_.roles AS roles_23, u3_.nom_complet AS nom_complet_24, u3_.email AS email_25, u3_.tel_fix AS tel_fix_26, u3_.valid AS valid_27, u3_.deleted AS deleted_28, u3_.password AS password_29, u3_.admin AS admin_30, u3_.address AS address_31, u3_.logo AS logo_32, u3_.image AS image_33, u3_.patente AS patente_34, u3_.updated_at AS updated_at_35, u3_.labo_name AS labo_name_36, u3_.ville AS ville_37, u3_.gouvernorat AS gouvernorat_38, u3_.postal_code AS postal_code_39, u3_.forme_juridique AS forme_juridique_40, u3_.num_matricule_fiscale AS num_matricule_fiscale_41, u3_.denomination_sociale AS denomination_sociale_42, u3_.nom_gerant AS nom_gerant_43, u3_.subscription_type AS subscription_type_44, u3_.subscription_period AS subscription_period_45, u3_.code AS code_46, u3_.external_id AS external_id_47, u3_.quota AS quota_48, u3_.switcher AS switcher_49, u3_.date_debut AS date_debut_50, u3_.date_fin AS date_fin_51, u3_.priceab AS priceab_52, u3_.contract AS contract_53, u3_.quotainit AS quotainit_54, u3_.sitcher_show AS sitcher_show_55, u3_.is_sendmail AS is_sendmail_56, u3_.is_privilege AS is_privilege_57, u3_.has_group AS has_group_58, u3_.is_super_agent AS is_super_agent_59, u3_.latitude AS latitude_60, u3_.longitude AS longitude_61, u3_.is_analyse_mod AS is_analyse_mod_62, u3_.firstname AS firstname_63, u3_.lastname AS lastname_64, u3_.tel_mobile AS tel_mobile_65, u3_.gender AS gender_66, u3_.distance_calc AS distance_calc_67, u3_.see_only_one_lab AS see_only_one_lab_68, u3_.enable_login_tracking AS enable_login_tracking_69, u4_.id AS id_70, u4_.username AS username_71, u4_.roles AS roles_72, u4_.nom_complet AS nom_complet_73, u4_.email AS email_74, u4_.tel_fix AS tel_fix_75, u4_.valid AS valid_76, u4_.deleted AS deleted_77, u4_.password AS password_78, u4_.admin AS admin_79, u4_.address AS address_80, u4_.logo AS logo_81, u4_.image AS image_82, u4_.patente AS patente_83, u4_.updated_at AS updated_at_84, u4_.labo_name AS labo_name_85, u4_.ville AS ville_86, u4_.gouvernorat AS gouvernorat_87, u4_.postal_code AS postal_code_88, u4_.forme_juridique AS forme_juridique_89, u4_.num_matricule_fiscale AS num_matricule_fiscale_90, u4_.denomination_sociale AS denomination_sociale_91, u4_.nom_gerant AS nom_gerant_92, u4_.subscription_type AS subscription_type_93, u4_.subscription_period AS subscription_period_94, u4_.code AS code_95, u4_.external_id AS external_id_96, u4_.quota AS quota_97, u4_.switcher AS switcher_98, u4_.date_debut AS date_debut_99, u4_.date_fin AS date_fin_100, u4_.priceab AS priceab_101, u4_.contract AS contract_102, u4_.quotainit AS quotainit_103, u4_.sitcher_show AS sitcher_show_104, u4_.is_sendmail AS is_sendmail_105, u4_.is_privilege AS is_privilege_106, u4_.has_group AS has_group_107, u4_.is_super_agent AS is_super_agent_108, u4_.latitude AS latitude_109, u4_.longitude AS longitude_110, u4_.is_analyse_mod AS is_analyse_mod_111, u4_.firstname AS firstname_112, u4_.lastname AS lastname_113, u4_.tel_mobile AS tel_mobile_114, u4_.gender AS gender_115, u4_.distance_calc AS distance_calc_116, u4_.see_only_one_lab AS see_only_one_lab_117, u4_.enable_login_tracking AS enable_login_tracking_118, d5_.id AS id_119, d5_.prix AS prix_120, t6_.id AS id_121, t6_.libelle AS libelle_122, p7_.id AS id_123, p7_.preleve AS preleve_124, t8_.id AS id_125, t8_.temp AS temp_126, c1_.traitant_id AS traitant_id_127, c1_.type_analyse_id AS type_analyse_id_128, c2_.catalogue_id AS catalogue_id_129, u3_.userby_id AS userby_id_130, u3_.catalogue_id AS catalogue_id_131, u4_.userby_id AS userby_id_132, u4_.catalogue_id AS catalogue_id_133, d5_.analyse_id AS analyse_id_134, d5_.technique_id AS technique_id_135, d5_.delai_id AS delai_id_136 FROM type_analyse t0_ LEFT JOIN catalogue c1_ ON t0_.id = c1_.type_analyse_id LEFT JOIN catalogue_detail_analyse c2_ ON c1_.id = c2_.catalogue_id LEFT JOIN user u3_ ON c1_.id = u3_.catalogue_id LEFT JOIN user u4_ ON c1_.traitant_id = u4_.id LEFT JOIN detail_analyse d5_ ON t0_.id = d5_.analyse_id LEFT JOIN technique_prelev t6_ ON d5_.technique_id = t6_.id LEFT JOIN detail_analyse_preleve d9_ ON d5_.id = d9_.detail_analyse_id LEFT JOIN preleve p7_ ON p7_.id = d9_.preleve_id LEFT JOIN type_analyse_temperature t10_ ON t0_.id = t10_.type_analyse_id LEFT JOIN temperature t8_ ON t8_.id = t10_.temperature_id ORDER BY t0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.state AS state_2,
  t0_.volume AS volume_3,
  t0_.categorie AS categorie_4,
  t0_.synonyme AS synonyme_5,
  t0_.code AS code_6,
  t0_.precisionn AS precisionn_7,
  t0_.comment AS comment_8,
  t0_.file AS file_9,
  t0_.is_privilege AS is_privilege_10,
  t0_.rapid_delivery AS rapid_delivery_11,
  t0_.created_at AS created_at_12,
  t0_.updated_at AS updated_at_13,
  c1_.id AS id_14,
  c1_.active AS active_15,
  c2_.id AS id_16,
  c2_.delai AS delai_17,
  c2_.prix AS prix_18,
  c2_.techniquep AS techniquep_19,
  c2_.types AS types_20,
  u3_.id AS id_21,
  u3_.username AS username_22,
  u3_.roles AS roles_23,
  u3_.nom_complet AS nom_complet_24,
  u3_.email AS email_25,
  u3_.tel_fix AS tel_fix_26,
  u3_.valid AS valid_27,
  u3_.deleted AS deleted_28,
  u3_.password AS password_29,
  u3_.admin AS admin_30,
  u3_.address AS address_31,
  u3_.logo AS logo_32,
  u3_.image AS image_33,
  u3_.patente AS patente_34,
  u3_.updated_at AS updated_at_35,
  u3_.labo_name AS labo_name_36,
  u3_.ville AS ville_37,
  u3_.gouvernorat AS gouvernorat_38,
  u3_.postal_code AS postal_code_39,
  u3_.forme_juridique AS forme_juridique_40,
  u3_.num_matricule_fiscale AS num_matricule_fiscale_41,
  u3_.denomination_sociale AS denomination_sociale_42,
  u3_.nom_gerant AS nom_gerant_43,
  u3_.subscription_type AS subscription_type_44,
  u3_.subscription_period AS subscription_period_45,
  u3_.code AS code_46,
  u3_.external_id AS external_id_47,
  u3_.quota AS quota_48,
  u3_.switcher AS switcher_49,
  u3_.date_debut AS date_debut_50,
  u3_.date_fin AS date_fin_51,
  u3_.priceab AS priceab_52,
  u3_.contract AS contract_53,
  u3_.quotainit AS quotainit_54,
  u3_.sitcher_show AS sitcher_show_55,
  u3_.is_sendmail AS is_sendmail_56,
  u3_.is_privilege AS is_privilege_57,
  u3_.has_group AS has_group_58,
  u3_.is_super_agent AS is_super_agent_59,
  u3_.latitude AS latitude_60,
  u3_.longitude AS longitude_61,
  u3_.is_analyse_mod AS is_analyse_mod_62,
  u3_.firstname AS firstname_63,
  u3_.lastname AS lastname_64,
  u3_.tel_mobile AS tel_mobile_65,
  u3_.gender AS gender_66,
  u3_.distance_calc AS distance_calc_67,
  u3_.see_only_one_lab AS see_only_one_lab_68,
  u3_.enable_login_tracking AS enable_login_tracking_69,
  u4_.id AS id_70,
  u4_.username AS username_71,
  u4_.roles AS roles_72,
  u4_.nom_complet AS nom_complet_73,
  u4_.email AS email_74,
  u4_.tel_fix AS tel_fix_75,
  u4_.valid AS valid_76,
  u4_.deleted AS deleted_77,
  u4_.password AS password_78,
  u4_.admin AS admin_79,
  u4_.address AS address_80,
  u4_.logo AS logo_81,
  u4_.image AS image_82,
  u4_.patente AS patente_83,
  u4_.updated_at AS updated_at_84,
  u4_.labo_name AS labo_name_85,
  u4_.ville AS ville_86,
  u4_.gouvernorat AS gouvernorat_87,
  u4_.postal_code AS postal_code_88,
  u4_.forme_juridique AS forme_juridique_89,
  u4_.num_matricule_fiscale AS num_matricule_fiscale_90,
  u4_.denomination_sociale AS denomination_sociale_91,
  u4_.nom_gerant AS nom_gerant_92,
  u4_.subscription_type AS subscription_type_93,
  u4_.subscription_period AS subscription_period_94,
  u4_.code AS code_95,
  u4_.external_id AS external_id_96,
  u4_.quota AS quota_97,
  u4_.switcher AS switcher_98,
  u4_.date_debut AS date_debut_99,
  u4_.date_fin AS date_fin_100,
  u4_.priceab AS priceab_101,
  u4_.contract AS contract_102,
  u4_.quotainit AS quotainit_103,
  u4_.sitcher_show AS sitcher_show_104,
  u4_.is_sendmail AS is_sendmail_105,
  u4_.is_privilege AS is_privilege_106,
  u4_.has_group AS has_group_107,
  u4_.is_super_agent AS is_super_agent_108,
  u4_.latitude AS latitude_109,
  u4_.longitude AS longitude_110,
  u4_.is_analyse_mod AS is_analyse_mod_111,
  u4_.firstname AS firstname_112,
  u4_.lastname AS lastname_113,
  u4_.tel_mobile AS tel_mobile_114,
  u4_.gender AS gender_115,
  u4_.distance_calc AS distance_calc_116,
  u4_.see_only_one_lab AS see_only_one_lab_117,
  u4_.enable_login_tracking AS enable_login_tracking_118,
  d5_.id AS id_119,
  d5_.prix AS prix_120,
  t6_.id AS id_121,
  t6_.libelle AS libelle_122,
  p7_.id AS id_123,
  p7_.preleve AS preleve_124,
  t8_.id AS id_125,
  t8_.temp AS temp_126,
  c1_.traitant_id AS traitant_id_127,
  c1_.type_analyse_id AS type_analyse_id_128,
  c2_.catalogue_id AS catalogue_id_129,
  u3_.userby_id AS userby_id_130,
  u3_.catalogue_id AS catalogue_id_131,
  u4_.userby_id AS userby_id_132,
  u4_.catalogue_id AS catalogue_id_133,
  d5_.analyse_id AS analyse_id_134,
  d5_.technique_id AS technique_id_135,
  d5_.delai_id AS delai_id_136
FROM
  type_analyse t0_
  LEFT JOIN catalogue c1_ ON t0_.id = c1_.type_analyse_id
  LEFT JOIN catalogue_detail_analyse c2_ ON c1_.id = c2_.catalogue_id
  LEFT JOIN user u3_ ON c1_.id = u3_.catalogue_id
  LEFT JOIN user u4_ ON c1_.traitant_id = u4_.id
  LEFT JOIN detail_analyse d5_ ON t0_.id = d5_.analyse_id
  LEFT JOIN technique_prelev t6_ ON d5_.technique_id = t6_.id
  LEFT JOIN detail_analyse_preleve d9_ ON d5_.id = d9_.detail_analyse_id
  LEFT JOIN preleve p7_ ON p7_.id = d9_.preleve_id
  LEFT JOIN type_analyse_temperature t10_ ON t0_.id = t10_.type_analyse_id
  LEFT JOIN temperature t8_ ON t8_.id = t10_.temperature_id
ORDER BY
  t0_.name ASC

SELECT DISTINCT t0_.id AS id_0, t0_.name AS name_1, t0_.state AS state_2, t0_.volume AS volume_3, t0_.categorie AS categorie_4, t0_.synonyme AS synonyme_5, t0_.code AS code_6, t0_.precisionn AS precisionn_7, t0_.comment AS comment_8, t0_.file AS file_9, t0_.is_privilege AS is_privilege_10, t0_.rapid_delivery AS rapid_delivery_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, c1_.id AS id_14, c1_.active AS active_15, c2_.id AS id_16, c2_.delai AS delai_17, c2_.prix AS prix_18, c2_.techniquep AS techniquep_19, c2_.types AS types_20, u3_.id AS id_21, u3_.username AS username_22, u3_.roles AS roles_23, u3_.nom_complet AS nom_complet_24, u3_.email AS email_25, u3_.tel_fix AS tel_fix_26, u3_.valid AS valid_27, u3_.deleted AS deleted_28, u3_.password AS password_29, u3_.admin AS admin_30, u3_.address AS address_31, u3_.logo AS logo_32, u3_.image AS image_33, u3_.patente AS patente_34, u3_.updated_at AS updated_at_35, u3_.labo_name AS labo_name_36, u3_.ville AS ville_37, u3_.gouvernorat AS gouvernorat_38, u3_.postal_code AS postal_code_39, u3_.forme_juridique AS forme_juridique_40, u3_.num_matricule_fiscale AS num_matricule_fiscale_41, u3_.denomination_sociale AS denomination_sociale_42, u3_.nom_gerant AS nom_gerant_43, u3_.subscription_type AS subscription_type_44, u3_.subscription_period AS subscription_period_45, u3_.code AS code_46, u3_.external_id AS external_id_47, u3_.quota AS quota_48, u3_.switcher AS switcher_49, u3_.date_debut AS date_debut_50, u3_.date_fin AS date_fin_51, u3_.priceab AS priceab_52, u3_.contract AS contract_53, u3_.quotainit AS quotainit_54, u3_.sitcher_show AS sitcher_show_55, u3_.is_sendmail AS is_sendmail_56, u3_.is_privilege AS is_privilege_57, u3_.has_group AS has_group_58, u3_.is_super_agent AS is_super_agent_59, u3_.latitude AS latitude_60, u3_.longitude AS longitude_61, u3_.is_analyse_mod AS is_analyse_mod_62, u3_.firstname AS firstname_63, u3_.lastname AS lastname_64, u3_.tel_mobile AS tel_mobile_65, u3_.gender AS gender_66, u3_.distance_calc AS distance_calc_67, u3_.see_only_one_lab AS see_only_one_lab_68, u3_.enable_login_tracking AS enable_login_tracking_69, u4_.id AS id_70, u4_.username AS username_71, u4_.roles AS roles_72, u4_.nom_complet AS nom_complet_73, u4_.email AS email_74, u4_.tel_fix AS tel_fix_75, u4_.valid AS valid_76, u4_.deleted AS deleted_77, u4_.password AS password_78, u4_.admin AS admin_79, u4_.address AS address_80, u4_.logo AS logo_81, u4_.image AS image_82, u4_.patente AS patente_83, u4_.updated_at AS updated_at_84, u4_.labo_name AS labo_name_85, u4_.ville AS ville_86, u4_.gouvernorat AS gouvernorat_87, u4_.postal_code AS postal_code_88, u4_.forme_juridique AS forme_juridique_89, u4_.num_matricule_fiscale AS num_matricule_fiscale_90, u4_.denomination_sociale AS denomination_sociale_91, u4_.nom_gerant AS nom_gerant_92, u4_.subscription_type AS subscription_type_93, u4_.subscription_period AS subscription_period_94, u4_.code AS code_95, u4_.external_id AS external_id_96, u4_.quota AS quota_97, u4_.switcher AS switcher_98, u4_.date_debut AS date_debut_99, u4_.date_fin AS date_fin_100, u4_.priceab AS priceab_101, u4_.contract AS contract_102, u4_.quotainit AS quotainit_103, u4_.sitcher_show AS sitcher_show_104, u4_.is_sendmail AS is_sendmail_105, u4_.is_privilege AS is_privilege_106, u4_.has_group AS has_group_107, u4_.is_super_agent AS is_super_agent_108, u4_.latitude AS latitude_109, u4_.longitude AS longitude_110, u4_.is_analyse_mod AS is_analyse_mod_111, u4_.firstname AS firstname_112, u4_.lastname AS lastname_113, u4_.tel_mobile AS tel_mobile_114, u4_.gender AS gender_115, u4_.distance_calc AS distance_calc_116, u4_.see_only_one_lab AS see_only_one_lab_117, u4_.enable_login_tracking AS enable_login_tracking_118, d5_.id AS id_119, d5_.prix AS prix_120, t6_.id AS id_121, t6_.libelle AS libelle_122, p7_.id AS id_123, p7_.preleve AS preleve_124, t8_.id AS id_125, t8_.temp AS temp_126, c1_.traitant_id AS traitant_id_127, c1_.type_analyse_id AS type_analyse_id_128, c2_.catalogue_id AS catalogue_id_129, u3_.userby_id AS userby_id_130, u3_.catalogue_id AS catalogue_id_131, u4_.userby_id AS userby_id_132, u4_.catalogue_id AS catalogue_id_133, d5_.analyse_id AS analyse_id_134, d5_.technique_id AS technique_id_135, d5_.delai_id AS delai_id_136 FROM type_analyse t0_ LEFT JOIN catalogue c1_ ON t0_.id = c1_.type_analyse_id LEFT JOIN catalogue_detail_analyse c2_ ON c1_.id = c2_.catalogue_id LEFT JOIN user u3_ ON c1_.id = u3_.catalogue_id LEFT JOIN user u4_ ON c1_.traitant_id = u4_.id LEFT JOIN detail_analyse d5_ ON t0_.id = d5_.analyse_id LEFT JOIN technique_prelev t6_ ON d5_.technique_id = t6_.id LEFT JOIN detail_analyse_preleve d9_ ON d5_.id = d9_.detail_analyse_id LEFT JOIN preleve p7_ ON p7_.id = d9_.preleve_id LEFT JOIN type_analyse_temperature t10_ ON t0_.id = t10_.type_analyse_id LEFT JOIN temperature t8_ ON t8_.id = t10_.temperature_id ORDER BY t0_.name ASC;

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\CatalogueDetailAnalyse	1265
App\Entity\Catalogue	1243
App\Entity\DetailAnalyse	385
App\Entity\TypeAnalyse	263
App\Entity\TechniquePrelev	51
App\Entity\Preleve	32
App\Entity\User	22
App\Entity\Delai	12
App\Entity\Temperature	3

Entities Mapping

Class	Mapping errors
App\Entity\TypeAnalyse	No errors.
App\Entity\Catalogue	No errors.
App\Entity\CatalogueDetailAnalyse	No errors.
App\Entity\User	No errors.
App\Entity\DetailAnalyse	No errors.
App\Entity\TechniquePrelev	No errors.
App\Entity\Preleve	No errors.
App\Entity\Temperature	No errors.
App\Entity\Delai	No errors.
App\Entity\Addedinformation	No errors.
App\Entity\Analyse	No errors.
App\Entity\Demande	No errors.
App\Entity\Notification	No errors.
App\Entity\DemandeNote	No errors.
App\Entity\Result	No errors.
App\Entity\Facture	No errors.
App\Entity\CoolerAffectation	No errors.
App\Entity\Convention	No errors.
App\Entity\Facturation	No errors.
App\Entity\Abonnement	No errors.
App\Entity\HistoriqueAgent	No errors.
App\Entity\DemandeLivraison	No errors.
App\Entity\Feedback	No errors.
App\Entity\UserLoginHistory	No errors.

Symfony Profiler

GET https://dev.pl.linkivia.com/fr/api/v1/marketplace/get-analysis

Configuration Settings

Theme

Page Width