Query Metrics
73
Database Queries
7
Different statements
30.97 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
15.16 ms (48.95%) |
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
]
|
|
9.26 ms (29.89%) |
24 |
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.23 ms (7.20%) |
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.63 ms (5.27%) |
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
]
|
|
1.35 ms (4.35%) |
1 |
SELECT r0_.id AS id_0, r0_.uuid AS uuid_1, r0_.created AS created_2, r0_.enabled AS enabled_3, r0_.name AS name_4, r0_.image AS image_5, r0_.heading AS heading_6, r0_.slug AS slug_7, r0_.for_sale_slug AS for_sale_slug_8, r0_.path AS path_9, r0_.description AS description_10, r0_.schema_description AS schema_description_11, r0_.for_sale_description AS for_sale_description_12, r0_.for_sale_seo_page_title AS for_sale_seo_page_title_13, r0_.for_sale_seo_page_description AS for_sale_seo_page_description_14, r0_.for_sale_seo_page_keywords AS for_sale_seo_page_keywords_15, r0_.for_sale_html_head AS for_sale_html_head_16, r0_.seo_page_title AS seo_page_title_17, r0_.seo_page_description AS seo_page_description_18, r0_.seo_page_keywords AS seo_page_keywords_19, r0_.html_head AS html_head_20, r0_.parent_id AS parent_id_21, r0_.trainer_id AS trainer_id_22, r0_.website_enquiry_booking_centre_id AS website_enquiry_booking_centre_id_23 FROM regions_region r0_ LEFT JOIN trainers_trainerregion t1_ ON r0_.id = t1_.region_id WHERE r0_.for_sale_slug = ? AND r0_.enabled = ? LIMIT 1
Parameters:
[ "hull" 1 ] |
|
0.74 ms (2.38%) |
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.61 ms (1.96%) |
1 |
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.region_id = ?
Parameters:
[
44
]
|
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\Regions\Region | No errors. |
| App\Entity\Trainers\TrainerRegion | No errors. |
| App\Entity\Trainers\Trainer | No errors. |
| App\Entity\Trainers\BookingCentre | No errors. |
| App\Entity\Regions\Postcode | No errors. |
| App\Entity\Regions\Town | No errors. |
| App\Entity\Content\Pages\Page | No errors. |
| App\Entity\Content\Menus\Menu | No errors. |
| App\Entity\Content\Menus\MenuItem | No errors. |
| App\Entity\Content\Pages\Block | No errors. |