GET http://dev.lacaserne-juniville.fr/la-boutique?category=2

Query Metrics

12 Database Queries
8 Different statements
18.77 ms Query time
0 Invalid entities
86 Cache hits
7 Cache misses
9 Cache puts

Queries

Group similar statements

# Time Info
1 3.31 ms
SELECT t0.id AS id_1, t0.logo_name AS logo_name_2, t0.updated_at AS updated_at_3, t0.address AS address_4, t0.phone_1 AS phone_1_5, t0.phone_2 AS phone_2_6, t0.mail AS mail_7, t0.form_file_name AS form_file_name_8, t0.rgpd_file_name AS rgpd_file_name_9, t0.site_main_title AS site_main_title_10, t0.site_main_description AS site_main_description_11, t0.facebook AS facebook_12, t0.instagram AS instagram_13, t0.linkedin AS linkedin_14, t0.home_page_id AS home_page_id_15, t0.contact_page_id AS contact_page_id_16, t0.planning_page_id AS planning_page_id_17, t0.shop_page_id AS shop_page_id_18, t0.event_page_id AS event_page_id_19, t0.intervention_page_id AS intervention_page_id_20, t0.subscription_page_id AS subscription_page_id_21 FROM settings t0 LIMIT 1
Parameters:
[]
2 1.59 ms
SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.header_image_name AS header_image_name_6, t0.content_title AS content_title_7, t0.content_subtitle AS content_subtitle_8, t0.content AS content_9, t0.content_image_name AS content_image_name_10, t0.meta_description AS meta_description_11, t0.slug AS slug_12, t0.banner_title AS banner_title_13, t0.banner_secondary_title AS banner_secondary_title_14, t0.banner_content AS banner_content_15, t0.banner_image_name AS banner_image_name_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
  9
]
3 1.38 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
]
4 4.36 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:
[
  2
]
5 0.65 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:
[
  2
]
6 1.21 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:
[
  2
  2
  5
  6
  7
  9
]
7 1.99 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM menu t0 WHERE t0.position = ? LIMIT 1
Parameters:
[
  "primary"
]
8 2.08 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
]
9 0.57 ms
SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.header_image_name AS header_image_name_6, t0.content_title AS content_title_7, t0.content_subtitle AS content_subtitle_8, t0.content AS content_9, t0.content_image_name AS content_image_name_10, t0.meta_description AS meta_description_11, t0.slug AS slug_12, t0.banner_title AS banner_title_13, t0.banner_secondary_title AS banner_secondary_title_14, t0.banner_content AS banner_content_15, t0.banner_image_name AS banner_image_name_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.53 ms
SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.header_image_name AS header_image_name_6, t0.content_title AS content_title_7, t0.content_subtitle AS content_subtitle_8, t0.content AS content_9, t0.content_image_name AS content_image_name_10, t0.meta_description AS meta_description_11, t0.slug AS slug_12, t0.banner_title AS banner_title_13, t0.banner_secondary_title AS banner_secondary_title_14, t0.banner_content AS banner_content_15, t0.banner_image_name AS banner_image_name_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
  6
]
11 0.51 ms
SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.header_image_name AS header_image_name_6, t0.content_title AS content_title_7, t0.content_subtitle AS content_subtitle_8, t0.content AS content_9, t0.content_image_name AS content_image_name_10, t0.meta_description AS meta_description_11, t0.slug AS slug_12, t0.banner_title AS banner_title_13, t0.banner_secondary_title AS banner_secondary_title_14, t0.banner_content AS banner_content_15, t0.banner_image_name AS banner_image_name_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
  7
]
12 0.58 ms
SELECT t0.id AS id_1, t0.page_name AS page_name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.title AS title_5, t0.header_image_name AS header_image_name_6, t0.content_title AS content_title_7, t0.content_subtitle AS content_subtitle_8, t0.content AS content_9, t0.content_image_name AS content_image_name_10, t0.meta_description AS meta_description_11, t0.slug AS slug_12, t0.banner_title AS banner_title_13, t0.banner_secondary_title AS banner_secondary_title_14, t0.banner_content AS banner_content_15, t0.banner_image_name AS banner_image_name_16 FROM page t0 WHERE t0.id = ?
Parameters:
[
  10
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

86 Hits
7 Misses
9 Puts

Number of cache hits

Region Hits
app_entity_category 6
app_entity_settings 78
app_entity_menu 2

Number of cache misses

Region Misses
app_entity_settings 1
app_entity_page 5
app_entity_menu 1

Number of cache puts

Region Puts
app_entity_settings 2
app_entity_page 5
app_entity_menu 2

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.