2.14 ms (32.77%)
|
1 |
SELECT t0.id AS id_1, t0.designation AS designation_2 FROM shop_categorie t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2 FROM shop_categorie t0 WHERE t0.id = '3';
|
0.92 ms (14.08%)
|
1 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.forhome AS forhome_3, t0.image_name AS image_name_4, t0.image_namev2 AS image_namev2_5, t0.updated_at AS updated_at_6, t0.shopcategorie_id AS shopcategorie_id_7 FROM shop_souscategorie t0 WHERE t0.shopcategorie_id = ?
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.forhome AS forhome_3, t0.image_name AS image_name_4, t0.image_namev2 AS image_namev2_5, t0.updated_at AS updated_at_6, t0.shopcategorie_id AS shopcategorie_id_7 FROM shop_souscategorie t0 WHERE t0.shopcategorie_id = 3;
|
0.69 ms (10.56%)
|
1 |
SELECT s0_.id AS id_0, s0_.designation AS designation_1, s0_.prix AS prix_2, s0_.description AS description_3, s0_.marque AS marque_4, s0_.contenu AS contenu_5, s0_.disponible AS disponible_6, s0_.created_at AS created_at_7, s0_.private AS private_8, s0_.etat AS etat_9, s0_.owner_id AS owner_id_10, s0_.boutique_id AS boutique_id_11 FROM shop_article s0_ LEFT JOIN shop_article_shop_souscategorie s2_ ON s0_.id = s2_.shop_article_id LEFT JOIN shop_souscategorie s1_ ON s1_.id = s2_.shop_souscategorie_id WHERE s0_.id IN (?, ?, ?)
SELECT s0_.id AS id_0, s0_.designation AS designation_1, s0_.prix AS prix_2, s0_.description AS description_3, s0_.marque AS marque_4, s0_.contenu AS contenu_5, s0_.disponible AS disponible_6, s0_.created_at AS created_at_7, s0_.private AS private_8, s0_.etat AS etat_9, s0_.owner_id AS owner_id_10, s0_.boutique_id AS boutique_id_11 FROM shop_article s0_ LEFT JOIN shop_article_shop_souscategorie s2_ ON s0_.id = s2_.shop_article_id LEFT JOIN shop_souscategorie s1_ ON s1_.id = s2_.shop_souscategorie_id WHERE s0_.id IN (1, 2, 3);
|
0.62 ms (9.51%)
|
1 |
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM shop_article s0_ LEFT JOIN shop_article_shop_souscategorie s2_ ON s0_.id = s2_.shop_article_id LEFT JOIN shop_souscategorie s1_ ON s1_.id = s2_.shop_souscategorie_id
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM shop_article s0_ LEFT JOIN shop_article_shop_souscategorie s2_ ON s0_.id = s2_.shop_article_id LEFT JOIN shop_souscategorie s1_ ON s1_.id = s2_.shop_souscategorie_id;
|
0.50 ms (7.62%)
|
1 |
SELECT r0_.id AS id_0, r0_.designation AS designation_1, r0_.actif AS actif_2, r0_.url AS url_3 FROM reseausocial r0_ WHERE r0_.actif = ? ORDER BY r0_.id ASC
SELECT r0_.id AS id_0, r0_.designation AS designation_1, r0_.actif AS actif_2, r0_.url AS url_3 FROM reseausocial r0_ WHERE r0_.actif = 1 ORDER BY r0_.id ASC;
|
0.48 ms (7.28%)
|
1 |
SELECT s0_.id AS id_0, s0_.designation AS designation_1, s0_.forhome AS forhome_2, s0_.image_name AS image_name_3, s0_.image_namev2 AS image_namev2_4, s0_.updated_at AS updated_at_5, s0_.shopcategorie_id AS shopcategorie_id_6 FROM shop_souscategorie s0_ WHERE s0_.image_namev2 IS NOT NULL AND s0_.shopcategorie_id = ?
SELECT s0_.id AS id_0, s0_.designation AS designation_1, s0_.forhome AS forhome_2, s0_.image_name AS image_name_3, s0_.image_namev2 AS image_namev2_4, s0_.updated_at AS updated_at_5, s0_.shopcategorie_id AS shopcategorie_id_6 FROM shop_souscategorie s0_ WHERE s0_.image_namev2 IS NOT NULL AND s0_.shopcategorie_id = 3;
|
0.47 ms (7.26%)
|
1 |
SELECT DISTINCT s0_.id AS id_0 FROM shop_article s0_ LEFT JOIN shop_article_shop_souscategorie s2_ ON s0_.id = s2_.shop_article_id LEFT JOIN shop_souscategorie s1_ ON s1_.id = s2_.shop_souscategorie_id LIMIT 12
SELECT DISTINCT s0_.id AS id_0 FROM shop_article s0_ LEFT JOIN shop_article_shop_souscategorie s2_ ON s0_.id = s2_.shop_article_id LEFT JOIN shop_souscategorie s1_ ON s1_.id = s2_.shop_souscategorie_id LIMIT 12;
|
0.37 ms (5.70%)
|
1 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.forhome AS forhome_3, t0.image_name AS image_name_4, t0.image_namev2 AS image_namev2_5, t0.updated_at AS updated_at_6, t0.shopcategorie_id AS shopcategorie_id_7 FROM shop_souscategorie t0
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.forhome AS forhome_3, t0.image_name AS image_name_4, t0.image_namev2 AS image_namev2_5, t0.updated_at AS updated_at_6, t0.shopcategorie_id AS shopcategorie_id_7 FROM shop_souscategorie t0;
|
0.34 ms (5.23%)
|
1 |
SELECT t0.id AS id_1, t0.designation AS designation_2 FROM shop_categorie t0
SELECT t0.id AS id_1, t0.designation AS designation_2 FROM shop_categorie t0;
|