GET https://bb-uk.penguin-dev.co.uk/featured-dog-breeds

Query Metrics

76 Database Queries
11 Different statements
36.48 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
11.11 ms
(30.44%)
38
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters:
[
  17
]
8.47 ms
(23.21%)
1
SELECT AVG(r0_.feedback_experience_rating) AS sclr_0 FROM reviews_review r0_ WHERE r0_.status IN (2, 3, 4)
Parameters:
[]
6.01 ms
(16.48%)
23
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.content AS content_5, t0.slug AS slug_6, t0.path AS path_7, t0.primary_image AS primary_image_8, t0.seo_page_title AS seo_page_title_9, t0.seo_description AS seo_description_10, t0.seo_keywords AS seo_keywords_11, t0.html_head AS html_head_12, t0.display_order AS display_order_13, t0.parent_id AS parent_id_14, t0.region_id AS region_id_15, t0.trainer_id AS trainer_id_16 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
  4
]
5.23 ms
(14.34%)
1
SELECT COUNT(r0_.id) AS sclr_0 FROM reviews_review r0_ WHERE r0_.status IN (?, ?, ?)
Parameters:
[
  2
  3
  4
]
1.68 ms
(4.59%)
5
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.modified AS modified_3, c0_.identifier AS identifier_4, c0_.name AS name_5, c0_.is_locked AS is_locked_6, c0_.disable_child_items AS disable_child_items_7 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
  "primary"
]
1.20 ms
(3.28%)
3
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.menu_id = ? ORDER BY t0.display_order ASC
Parameters:
[
  5
]
0.94 ms
(2.57%)
1
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.name AS name_3, c0_.content AS content_4, c0_.slug AS slug_5, c0_.path AS path_6, c0_.primary_image AS primary_image_7, c0_.seo_page_title AS seo_page_title_8, c0_.seo_description AS seo_description_9, c0_.seo_keywords AS seo_keywords_10, c0_.html_head AS html_head_11, c0_.display_order AS display_order_12, c0_.parent_id AS parent_id_13, c0_.region_id AS region_id_14, c0_.trainer_id AS trainer_id_15 FROM content_pages_page c0_ WHERE c0_.path = ? LIMIT 1
Parameters:
[
  "featured-dog-breeds"
]
0.75 ms
(2.06%)
1
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.`key` AS key_4, t0.value AS value_5 FROM system_config t0
Parameters:
[]
0.45 ms
(1.23%)
1
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.block_name AS block_name_3, c0_.is_visible AS is_visible_4, c0_.data AS data_5, c0_.page_id AS page_id_6 FROM content_pages_block c0_ WHERE c0_.id = ? LIMIT 1
Parameters:
[
  279
]
0.42 ms
(1.16%)
1
SELECT d0_.id AS id_0, d0_.uuid AS uuid_1, d0_.created AS created_2, d0_.title AS title_3, d0_.description AS description_4, d0_.image AS image_5, d0_.slug AS slug_6, d0_.display_order AS display_order_7, d0_.seo_page_title AS seo_page_title_8, d0_.seo_page_description AS seo_page_description_9, d0_.seo_page_keywords AS seo_page_keywords_10, d0_.html_head AS html_head_11, d0_.schema_description AS schema_description_12, d0_.date AS date_13, d0_.type_id AS type_id_14 FROM dynamiccontent_item d0_ WHERE d0_.date < ? AND d0_.type_id = ? ORDER BY d0_.display_order ASC
Parameters:
[
  "2026-02-07 00:00:00"
  1
]
0.24 ms
(0.65%)
1
SELECT d0_.id AS id_0, d0_.uuid AS uuid_1, d0_.created AS created_2, d0_.name AS name_3, d0_.slug AS slug_4, d0_.featured_item_id AS featured_item_id_5 FROM dynamiccontent_type d0_ LIMIT 1
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.