GET https://hellocolis.com/shop

Query Metrics

10 Database Queries
7 Different statements
14.77 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 10.41 ms
SELECT t0.id AS id_1, t0.designation AS designation_2 FROM shop_categorie t0
Parameters:
[]
2 1.05 ms
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:
[]
3 0.76 ms
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:
[]
4 0.36 ms
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:
[]
5 0.52 ms
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
]
6 0.38 ms
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
]
7 0.21 ms
SELECT t0.id AS id_1, t0.designation AS designation_2 FROM shop_categorie t0
Parameters:
[]
8 0.46 ms
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:
[
  1
]
9 0.33 ms
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
]
10 0.30 ms
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:
[
  3
]

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.