Query Metrics
9
Database Queries
7
Different statements
9.77 ms
Query time
2
Invalid entities
26
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.58 ms (36.67%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"srnb"
]
|
|
1.49 ms (15.27%) |
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:
[] |
|
1.35 ms (13.86%) |
2 |
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
]
|
|
1.16 ms (11.83%) |
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_.project_id AS project_id_14 FROM content_pages_page c0_ WHERE c0_.path = ? AND c0_.project_id IS NULL LIMIT 1
Parameters:
[
"robots.txt"
]
|
|
0.85 ms (8.73%) |
1 |
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"
]
|
|
0.76 ms (7.83%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
0.57 ms (5.80%) |
1 |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.path AS path_3, c0_.destination AS destination_4 FROM content_redirects_redirect c0_ WHERE c0_.path = ? LIMIT 1
Parameters:
[
"/robots.txt"
]
|
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 |