0.74 ms (23.03%)
|
5 |
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;
|
0.57 ms (17.53%)
|
5 |
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;
|
0.40 ms (12.26%)
|
3 |
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;
|
0.39 ms (12.07%)
|
3 |
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;
|
0.34 ms (10.71%)
|
1 |
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;
|
0.31 ms (9.68%)
|
1 |
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 = '19';
|
0.25 ms (7.69%)
|
1 |
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;
|
0.23 ms (7.01%)
|
1 |
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 = '19' ORDER BY e0_.designation ASC LIMIT 12;
|