Query Metrics
27
Database Queries
11
Different statements
14.78 ms
Query time
1
Invalid entities
46
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.95 ms |
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:
[] |
| 2 | 0.67 ms |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.time_submitted AS time_submitted_3, c0_.submitted AS submitted_4, c0_.passed AS passed_5, c0_.pass_rate AS pass_rate_6, c0_.user_id AS user_id_7, c0_.admission_id AS admission_id_8, c0_.assessment_id AS assessment_id_9 FROM clients_userassessments c0_ WHERE c0_.user_id IS NULL AND c0_.submitted = ? LIMIT 1
Parameters:
[
0
]
|
| 3 | 0.72 ms |
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_.project_id AS project_id_14 FROM content_pages_page c0_ WHERE c0_.path = ? LIMIT 1
Parameters:
[
"login"
]
|
| 4 | 0.53 ms |
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:
[
45
]
|
| 5 | 0.39 ms |
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:
[
46
]
|
| 6 | 0.64 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.domain AS domain_5, t0.logo AS logo_6, t0.publish_on_shop AS publish_on_shop_7, t0.display_order AS display_order_8, t0.code_head AS code_head_9, t0.code_body AS code_body_10 FROM projects_project t0 WHERE t0.domain = ? LIMIT 1
Parameters:
[
"srnb.penguin-dev.co.uk"
]
|
| 7 | 0.60 ms |
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, c0_.project_id AS project_id_8 FROM content_menus_menu c0_ WHERE c0_.identifier = ? AND c0_.project_id IS NULL LIMIT 1
Parameters:
[
"primary"
]
|
| 8 | 0.61 ms |
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:
[
1
]
|
| 9 | 0.70 ms |
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.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 10 | 0.66 ms |
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:
[
3
]
|
| 11 | 0.44 ms |
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.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
34
]
|
| 12 | 0.56 ms |
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:
[
50
]
|
| 13 | 0.50 ms |
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:
[
61
]
|
| 14 | 0.41 ms |
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.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 15 | 0.46 ms |
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:
[
53
]
|
| 16 | 0.40 ms |
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.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
38
]
|
| 17 | 0.45 ms |
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:
[
60
]
|
| 18 | 0.39 ms |
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:
[] |
| 19 | 0.60 ms |
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:
[] |
| 20 | 0.46 ms |
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, c0_.project_id AS project_id_8 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
"footer"
]
|
| 21 | 0.54 ms |
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, c0_.project_id AS project_id_8 FROM content_menus_menu c0_ WHERE c0_.identifier = ? AND c0_.project_id IS NULL LIMIT 1
Parameters:
[
"footer"
]
|
| 22 | 0.60 ms |
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:
[
2
]
|
| 23 | 0.59 ms |
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:
[
1
]
|
| 24 | 0.46 ms |
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.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 25 | 0.51 ms |
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:
[
6
]
|
| 26 | 0.46 ms |
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.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters:
[
28
]
|
| 27 | 0.48 ms |
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:
[
42
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\System\Config | 26 |
| App\Entity\Content\Menus\MenuItem | 8 |
| App\Entity\Content\Pages\Page | 7 |
| App\Entity\Content\Pages\Block | 2 |
| App\Entity\Content\Menus\Menu | 2 |
| App\Entity\Content\Tags\Tag | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\System\Config | No errors. |
| App\Entity\Clients\UserAssessment | No errors. |
| App\Entity\Clients\User | No errors. |
| App\Entity\Clients\Admission | No errors. |
| App\Entity\Assessments\Assessment | No errors. |
| App\Entity\Content\Pages\Page | No errors. |
| App\Entity\Projects\Project |
|
| App\Entity\Content\Pages\Block | No errors. |
| App\Entity\Content\Menus\Menu | No errors. |
| App\Entity\Content\Menus\MenuItem | No errors. |
| App\Entity\Content\Tags\Tag | No errors. |