GET https://dev.lacaserne-juniville.fr/la-boutique?category=3

Query Metrics

5 Database Queries
5 Different statements
3.66 ms Query time
0 Invalid entities
95 Cache hits
0 Cache misses
0 Cache puts

Queries

Group similar statements

# Time Info
1 1.31 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.content_type AS content_type_3, t0.content_title AS content_title_4, t0.content_sub_title AS content_sub_title_5, t0.content_description AS content_description_6, t0.page_id AS page_id_7 FROM page_block t0 WHERE t0.page_id = ?
Parameters:
[
  9
]
2 0.72 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id = ?
Parameters:
[
  3
]
3 0.45 ms
SELECT DISTINCT p0_.id AS id_0 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id = ? LIMIT 8
Parameters:
[
  3
]
4 0.70 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.image_name AS image_name_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5 FROM product p0_ INNER JOIN product_category p2_ ON p0_.id = p2_.product_id INNER JOIN category c1_ ON c1_.id = p2_.category_id WHERE c1_.id = ? AND p0_.id IN (?)
Parameters:
[
  3
  7
]
5 0.48 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.target AS target_4, t0.menu_id AS menu_id_5, t0.page_id AS page_id_6 FROM menu_item t0 WHERE t0.menu_id = ?
Parameters:
[
  8
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

95 Hits
0 Misses
0 Puts

Number of cache hits

Region Hits
app_entity_settings 80
app_entity_page 5
app_entity_category 6
app_entity_menu 4

Entities Mapping

Class Mapping errors
App\Entity\Settings No errors.
App\Entity\Page No errors.
App\Entity\PageBlock No errors.
App\Entity\Category No errors.
App\Entity\Product No errors.
App\Entity\Menu No errors.
App\Entity\MenuItem No errors.