GET https://hellocolis.com/shop/front_souscategorie/2/liste

Query Metrics

9 Database Queries
9 Different statements
17.72 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
13.49 ms
(76.13%)
1
SELECT t0.id AS id_1, t0.designation AS designation_2 FROM shop_categorie t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
0.79 ms
(4.46%)
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
Parameters:
[]
0.64 ms
(3.63%)
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 (?, ?, ?)
Parameters:
[
  1
  2
  3
]
0.58 ms
(3.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 = ?
Parameters:
[
  2
]
0.56 ms
(3.17%)
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
Parameters:
[]
0.50 ms
(2.80%)
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
Parameters:
[]
0.47 ms
(2.66%)
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
Parameters:
[
  1
]
0.38 ms
(2.17%)
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 = ?
Parameters:
[
  2
]
0.30 ms
(1.71%)
1
SELECT t0.id AS id_1, t0.designation AS designation_2 FROM shop_categorie t0
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.