| 1 |
309.77 ms |
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
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;
|