| 1 |
13.40 ms |
SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.slug AS slug_2, r0_.name AS name_3, r0_.coords AS coords_4, d1_.id AS id_5, d1_.code AS code_6, d1_.slug AS slug_7, d1_.name AS name_8, c2_.id AS id_9, c2_.name AS name_10, e3_.id AS id_11, e3_.nom AS nom_12, e3_.adresse AS adresse_13, e3_.latitude AS latitude_14, e3_.longitude AS longitude_15, e3_.contact AS contact_16, e3_.ao AS ao_17, e3_.chef AS chef_18, e3_.description AS description_19, e3_.photos AS photos_20, e3_.type AS type_21, e3_.whatsapp AS whatsapp_22, e3_.facebook AS facebook_23, e3_.photo1 AS photo1_24, f4_.id AS id_25, f4_.code AS code_26, f4_.name AS name_27, f4_.slug AS slug_28, m5_.id AS id_29, m5_.code AS code_30, m5_.slug AS slug_31, m5_.name AS name_32, m5_.sigle AS sigle_33, m5_.fichier AS fichier_34, m5_.updated_at AS updated_at_35, s6_.id AS id_36, s6_.code AS code_37, s6_.name AS name_38, s6_.slug AS slug_39, d1_.region_id AS region_id_40, c2_.district_id AS district_id_41, c2_.region_id AS region_id_42, e3_.district_id AS district_id_43, e3_.commune_id AS commune_id_44, f4_.sector_id AS sector_id_45, m5_.filiere_id AS filiere_id_46 FROM region r0_ LEFT JOIN district d1_ ON r0_.id = d1_.region_id LEFT JOIN commune c2_ ON d1_.id = c2_.district_id LEFT JOIN etablissements e3_ ON c2_.id = e3_.commune_id LEFT JOIN etablissements_filiere e7_ ON e3_.id = e7_.etablissements_id LEFT JOIN filiere f4_ ON f4_.id = e7_.filiere_id LEFT JOIN metier m5_ ON f4_.id = m5_.filiere_id LEFT JOIN sector s6_ ON f4_.sector_id = s6_.id ORDER BY r0_.name ASC, d1_.name ASC, c2_.name ASC, e3_.nom ASC
SELECT
r0_.id AS id_0,
r0_.code AS code_1,
r0_.slug AS slug_2,
r0_.name AS name_3,
r0_.coords AS coords_4,
d1_.id AS id_5,
d1_.code AS code_6,
d1_.slug AS slug_7,
d1_.name AS name_8,
c2_.id AS id_9,
c2_.name AS name_10,
e3_.id AS id_11,
e3_.nom AS nom_12,
e3_.adresse AS adresse_13,
e3_.latitude AS latitude_14,
e3_.longitude AS longitude_15,
e3_.contact AS contact_16,
e3_.ao AS ao_17,
e3_.chef AS chef_18,
e3_.description AS description_19,
e3_.photos AS photos_20,
e3_.type AS type_21,
e3_.whatsapp AS whatsapp_22,
e3_.facebook AS facebook_23,
e3_.photo1 AS photo1_24,
f4_.id AS id_25,
f4_.code AS code_26,
f4_.name AS name_27,
f4_.slug AS slug_28,
m5_.id AS id_29,
m5_.code AS code_30,
m5_.slug AS slug_31,
m5_.name AS name_32,
m5_.sigle AS sigle_33,
m5_.fichier AS fichier_34,
m5_.updated_at AS updated_at_35,
s6_.id AS id_36,
s6_.code AS code_37,
s6_.name AS name_38,
s6_.slug AS slug_39,
d1_.region_id AS region_id_40,
c2_.district_id AS district_id_41,
c2_.region_id AS region_id_42,
e3_.district_id AS district_id_43,
e3_.commune_id AS commune_id_44,
f4_.sector_id AS sector_id_45,
m5_.filiere_id AS filiere_id_46
FROM
region r0_
LEFT JOIN district d1_ ON r0_.id = d1_.region_id
LEFT JOIN commune c2_ ON d1_.id = c2_.district_id
LEFT JOIN etablissements e3_ ON c2_.id = e3_.commune_id
LEFT JOIN etablissements_filiere e7_ ON e3_.id = e7_.etablissements_id
LEFT JOIN filiere f4_ ON f4_.id = e7_.filiere_id
LEFT JOIN metier m5_ ON f4_.id = m5_.filiere_id
LEFT JOIN sector s6_ ON f4_.sector_id = s6_.id
ORDER BY
r0_.name ASC,
d1_.name ASC,
c2_.name ASC,
e3_.nom ASC
SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.slug AS slug_2, r0_.name AS name_3, r0_.coords AS coords_4, d1_.id AS id_5, d1_.code AS code_6, d1_.slug AS slug_7, d1_.name AS name_8, c2_.id AS id_9, c2_.name AS name_10, e3_.id AS id_11, e3_.nom AS nom_12, e3_.adresse AS adresse_13, e3_.latitude AS latitude_14, e3_.longitude AS longitude_15, e3_.contact AS contact_16, e3_.ao AS ao_17, e3_.chef AS chef_18, e3_.description AS description_19, e3_.photos AS photos_20, e3_.type AS type_21, e3_.whatsapp AS whatsapp_22, e3_.facebook AS facebook_23, e3_.photo1 AS photo1_24, f4_.id AS id_25, f4_.code AS code_26, f4_.name AS name_27, f4_.slug AS slug_28, m5_.id AS id_29, m5_.code AS code_30, m5_.slug AS slug_31, m5_.name AS name_32, m5_.sigle AS sigle_33, m5_.fichier AS fichier_34, m5_.updated_at AS updated_at_35, s6_.id AS id_36, s6_.code AS code_37, s6_.name AS name_38, s6_.slug AS slug_39, d1_.region_id AS region_id_40, c2_.district_id AS district_id_41, c2_.region_id AS region_id_42, e3_.district_id AS district_id_43, e3_.commune_id AS commune_id_44, f4_.sector_id AS sector_id_45, m5_.filiere_id AS filiere_id_46 FROM region r0_ LEFT JOIN district d1_ ON r0_.id = d1_.region_id LEFT JOIN commune c2_ ON d1_.id = c2_.district_id LEFT JOIN etablissements e3_ ON c2_.id = e3_.commune_id LEFT JOIN etablissements_filiere e7_ ON e3_.id = e7_.etablissements_id LEFT JOIN filiere f4_ ON f4_.id = e7_.filiere_id LEFT JOIN metier m5_ ON f4_.id = m5_.filiere_id LEFT JOIN sector s6_ ON f4_.sector_id = s6_.id ORDER BY r0_.name ASC, d1_.name ASC, c2_.name ASC, e3_.nom ASC;
|
| 2 |
0.26 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 2;
|
| 3 |
0.23 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 24;
|
| 4 |
0.16 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 3;
|
| 5 |
0.21 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 1;
|
| 6 |
0.23 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 6;
|
| 7 |
0.20 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 8;
|
| 8 |
0.20 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 7;
|
| 9 |
0.19 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 4;
|
| 10 |
0.15 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 5;
|
| 11 |
0.13 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 9;
|
| 12 |
0.13 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 10;
|
| 13 |
0.13 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 11;
|
| 14 |
0.15 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 12;
|
| 15 |
0.18 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 13;
|
| 16 |
0.14 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 14;
|
| 17 |
0.13 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 15;
|
| 18 |
0.14 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 16;
|
| 19 |
0.16 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 17;
|
| 20 |
0.13 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 18;
|
| 21 |
0.11 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 19;
|
| 22 |
0.14 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 20;
|
| 23 |
0.13 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 21;
|
| 24 |
0.13 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 22;
|
| 25 |
0.18 ms |
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = ?
SELECT t0.id AS id_1, t0.abr AS abr_2, t0.libelle AS libelle_3, t0.adresse AS adresse_4, t0.email AS email_5, t0.contact AS contact_6, t0.region_id AS region_id_7 FROM direction_regionale t0 WHERE t0.region_id = 23;
|
| 26 |
0.33 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.abr AS abr_3, t0.direction_regionale_id AS direction_regionale_id_4 FROM service_dr t0 WHERE t0.direction_regionale_id = ?
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.abr AS abr_3, t0.direction_regionale_id AS direction_regionale_id_4 FROM service_dr t0 WHERE t0.direction_regionale_id = 1;
|