| 1 |
0.24 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0;
|
| 2 |
0.20 ms |
SELECT e0_.id AS id_0, e0_.designation AS designation_1, e0_.description AS description_2, e0_.adresse AS adresse_3, e0_.tel AS tel_4, e0_.email AS email_5, e0_.urlsiteweb AS urlsiteweb_6, e0_.is_actif AS is_actif_7, e0_.en_description AS en_description_8 FROM entiteeconomique e0_ WHERE e0_.is_actif = ? ORDER BY e0_.id DESC LIMIT 5
SELECT e0_.id AS id_0, e0_.designation AS designation_1, e0_.description AS description_2, e0_.adresse AS adresse_3, e0_.tel AS tel_4, e0_.email AS email_5, e0_.urlsiteweb AS urlsiteweb_6, e0_.is_actif AS is_actif_7, e0_.en_description AS en_description_8 FROM entiteeconomique e0_ WHERE e0_.is_actif = 1 ORDER BY e0_.id DESC LIMIT 5;
|
| 3 |
0.31 ms |
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM entiteeconomique e0_ LEFT JOIN categorie_entiteeconomique c2_ ON e0_.id = c2_.entiteeconomique_id LEFT JOIN categorie c1_ ON c1_.id = c2_.categorie_id LEFT JOIN entiteeconomique_front_ile e4_ ON e0_.id = e4_.entiteeconomique_id LEFT JOIN front_ile f3_ ON f3_.id = e4_.front_ile_id WHERE e0_.is_actif = ? AND c1_.id = ?
SELECT count(DISTINCT e0_.id) AS sclr_0 FROM entiteeconomique e0_ LEFT JOIN categorie_entiteeconomique c2_ ON e0_.id = c2_.entiteeconomique_id LEFT JOIN categorie c1_ ON c1_.id = c2_.categorie_id LEFT JOIN entiteeconomique_front_ile e4_ ON e0_.id = e4_.entiteeconomique_id LEFT JOIN front_ile f3_ ON f3_.id = e4_.front_ile_id WHERE e0_.is_actif = 1 AND c1_.id = '21';
|
| 4 |
0.25 ms |
SELECT DISTINCT e0_.id AS id_0, e0_.designation AS designation_1 FROM entiteeconomique e0_ LEFT JOIN categorie_entiteeconomique c2_ ON e0_.id = c2_.entiteeconomique_id LEFT JOIN categorie c1_ ON c1_.id = c2_.categorie_id LEFT JOIN entiteeconomique_front_ile e4_ ON e0_.id = e4_.entiteeconomique_id LEFT JOIN front_ile f3_ ON f3_.id = e4_.front_ile_id WHERE e0_.is_actif = ? AND c1_.id = ? ORDER BY e0_.designation ASC LIMIT 12
SELECT DISTINCT e0_.id AS id_0, e0_.designation AS designation_1 FROM entiteeconomique e0_ LEFT JOIN categorie_entiteeconomique c2_ ON e0_.id = c2_.entiteeconomique_id LEFT JOIN categorie c1_ ON c1_.id = c2_.categorie_id LEFT JOIN entiteeconomique_front_ile e4_ ON e0_.id = e4_.entiteeconomique_id LEFT JOIN front_ile f3_ ON f3_.id = e4_.front_ile_id WHERE e0_.is_actif = 1 AND c1_.id = '21' ORDER BY e0_.designation ASC LIMIT 12;
|
| 5 |
0.16 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = 1;
|
| 6 |
0.12 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = 2;
|
| 7 |
0.11 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = 3;
|
| 8 |
0.10 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = 4;
|
| 9 |
0.09 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.link AS link_3 FROM front_rubrique t0 WHERE t0.id = 5;
|
| 10 |
0.19 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = 1;
|
| 11 |
0.18 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = 2;
|
| 12 |
0.17 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = 3;
|
| 13 |
0.18 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = 4;
|
| 14 |
0.16 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.routename AS routename_3, t0.is_inmaintenance AS is_inmaintenance_4, t0.description AS description_5, t0.contenu AS contenu_6, t0.image_name AS image_name_7, t0.image_size AS image_size_8, t0.updated_at AS updated_at_9, t0.rubrique_id AS rubrique_id_10 FROM front_page t0 WHERE t0.rubrique_id = 5;
|
| 15 |
0.34 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = 99;
|
| 16 |
0.20 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = 99;
|
| 17 |
0.16 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = 98;
|
| 18 |
0.17 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = 98;
|
| 19 |
0.17 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.is_actif AS is_actif_3, t0.is_thumb AS is_thumb_4, t0.linked_to AS linked_to_5, t0.image_name AS image_name_6, t0.updated_at AS updated_at_7, t0.entiteeconomique_id AS entiteeconomique_id_8 FROM entiteeconomique_image t0 WHERE t0.entiteeconomique_id = 97;
|
| 20 |
0.21 ms |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.en_designation AS en_designation_3 FROM categorie t0 INNER JOIN categorie_entiteeconomique ON t0.id = categorie_entiteeconomique.categorie_id WHERE categorie_entiteeconomique.entiteeconomique_id = 97;
|