Query Metrics
81
Database Queries
14
Different statements
47.55 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
13.02 ms (27.38%) |
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.39 ms (17.64%) |
1 |
SELECT COUNT(r0_.id) AS sclr_0 FROM reviews_review r0_ WHERE r0_.status IN (?, ?, ?)
Parameters:
[ 2 3 4 ] |
|
8.32 ms (17.50%) |
1 |
SELECT AVG(r0_.feedback_experience_rating) AS sclr_0 FROM reviews_review r0_ WHERE r0_.status IN (2, 3, 4)
Parameters:
[] |
|
7.36 ms (15.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
]
|
|
2.16 ms (4.54%) |
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.62 ms (3.41%) |
1 |
SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.created AS created_2, a0_.display_order AS display_order_3, a0_.is_featured AS is_featured_4, a0_.date AS date_5, a0_.title AS title_6, a0_.slug AS slug_7, a0_.image AS image_8, a0_.content AS content_9, a0_.seo_page_title AS seo_page_title_10, a0_.seo_page_description AS seo_page_description_11, a0_.seo_page_keywords AS seo_page_keywords_12, a0_.html_head AS html_head_13, a0_.enable_rss AS enable_rss_14 FROM articles_article a0_ WHERE a0_.date < ? AND a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY a0_.is_featured DESC, a0_.display_order DESC
Parameters:
[ "2026-02-07 00:00:00" 89 88 87 86 85 83 82 81 80 78 77 76 ] |
|
1.44 ms (3.02%) |
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 (1.98%) |
1 |
SELECT DISTINCT a0_.id AS id_0, a0_.is_featured AS is_featured_1, a0_.display_order AS display_order_2 FROM articles_article a0_ WHERE a0_.date < ? ORDER BY a0_.is_featured DESC, a0_.display_order DESC LIMIT 12 OFFSET 24
Parameters:
[
"2026-02-07 00:00:00"
]
|
|
0.83 ms (1.75%) |
2 |
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:
[
14
]
|
|
0.81 ms (1.69%) |
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.75 ms (1.58%) |
2 |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.tag AS tag_3, c0_.replacement AS replacement_4 FROM content_tags_tag c0_
Parameters:
[] |
|
0.69 ms (1.46%) |
1 |
SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM articles_article a0_ WHERE a0_.date < ?
Parameters:
[
"2026-02-07 00:00:00"
]
|
|
0.64 ms (1.34%) |
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:
[
"dog-training-tips"
]
|
|
0.58 ms (1.22%) |
1 |
SELECT a0_.id AS id_0, a0_.uuid AS uuid_1, a0_.created AS created_2, a0_.name AS name_3, a0_.slug AS slug_4 FROM articles_category a0_
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\System\Config | No errors. |
| App\Entity\Content\Pages\Page | No errors. |
| App\Entity\Regions\Region | No errors. |
| App\Entity\Trainers\Trainer | No errors. |
| App\Entity\Content\Pages\Block | No errors. |
| App\Entity\Articles\Category | No errors. |
| App\Entity\Articles\Article | No errors. |
| App\Entity\Reviews\Review | No errors. |
| App\Entity\Content\Menus\Menu | No errors. |
| App\Entity\Content\Menus\MenuItem | No errors. |
| App\Entity\Content\Tags\Tag | No errors. |