Query Metrics
45
Database Queries
9
Different statements
26.22 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.03 ms (30.64%) |
15 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.version AS version_4, t0.name AS name_5, t0.content AS content_6, t0.slug AS slug_7, t0.path AS path_8, t0.enable_group_restrictions AS enable_group_restrictions_9, t0.enable_role_restrictions AS enable_role_restrictions_10, t0.status AS status_11, t0.primary_image AS primary_image_12, t0.seo_page_title AS seo_page_title_13, t0.seo_description AS seo_description_14, t0.seo_keywords AS seo_keywords_15, t0.og_title AS og_title_16, t0.og_description AS og_description_17, t0.og_image AS og_image_18, t0.og_type AS og_type_19, t0.og_url AS og_url_20, t0.twitter_card AS twitter_card_21, t0.twitter_site AS twitter_site_22, t0.type_id AS type_id_23, t0.parent_id AS parent_id_24, t0.language_id AS language_id_25 FROM content_item t0 WHERE t0.id = ?
Parameters:
[
17
]
|
|
7.91 ms (30.17%) |
16 |
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.menu_id AS menu_id_10, t0.item_id AS item_id_11, t0.parent_id AS parent_id_12 FROM content_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters:
[
24
]
|
|
2.14 ms (8.14%) |
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.menu_id AS menu_id_10, t0.item_id AS item_id_11, t0.parent_id AS parent_id_12 FROM content_menuitem t0 WHERE t0.menu_id = ? ORDER BY t0.display_order ASC
Parameters:
[
1
]
|
|
1.72 ms (6.58%) |
3 |
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.created AS created_2, s0_.modified AS modified_3, s0_.locale AS locale_4, s0_.name AS name_5, s0_.icon AS icon_6, s0_.is_locked AS is_locked_7 FROM settings_language s0_
Parameters:
[] |
|
1.55 ms (5.90%) |
1 |
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.version AS version_3, c0_.name AS name_4, c0_.content AS content_5, c0_.slug AS slug_6, c0_.path AS path_7, c0_.enable_group_restrictions AS enable_group_restrictions_8, c0_.enable_role_restrictions AS enable_role_restrictions_9, c0_.status AS status_10, c0_.primary_image AS primary_image_11, c0_.seo_page_title AS seo_page_title_12, c0_.seo_description AS seo_description_13, c0_.seo_keywords AS seo_keywords_14, c0_.og_title AS og_title_15, c0_.og_description AS og_description_16, c0_.og_image AS og_image_17, c0_.og_type AS og_type_18, c0_.og_url AS og_url_19, c0_.twitter_card AS twitter_card_20, c0_.twitter_site AS twitter_site_21, c0_.type_id AS type_id_22, c0_.parent_id AS parent_id_23, c0_.language_id AS language_id_24 FROM content_item c0_ WHERE (c0_.language_id = ? OR c0_.language_id IS NULL) AND c0_.path = ? AND c0_.status = ? LIMIT 1
Parameters:
[ 2 "news/apollo-fleet-how-will-you-use-it" "published" ] |
|
1.54 ms (5.87%) |
3 |
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_.language_id AS language_id_8 FROM content_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters:
[
"main"
]
|
|
1.44 ms (5.50%) |
2 |
SELECT s0_.id AS id_0, s0_.uuid AS uuid_1, s0_.created AS created_2, s0_.modified AS modified_3, s0_.locale AS locale_4, s0_.name AS name_5, s0_.icon AS icon_6, s0_.is_locked AS is_locked_7 FROM settings_language s0_ WHERE s0_.id = ? LIMIT 1
Parameters:
[
"2"
]
|
|
1.06 ms (4.04%) |
1 |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.`key` AS key_5, t0.value AS value_6, t0.label AS label_7 FROM system_config t0
Parameters:
[] |
|
0.83 ms (3.15%) |
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_.data AS data_4, c0_.restrictions AS restrictions_5, c0_.item_id AS item_id_6 FROM content_block c0_ WHERE c0_.id = ? LIMIT 1
Parameters:
[
168
]
|
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\Settings\Language | No errors. |
| App\Entity\Settings\Phrase | No errors. |
| App\Entity\Content\Item | No errors. |
| App\Entity\Content\Type | No errors. |
| App\Entity\Content\Block | No errors. |
| App\Entity\Users\Group | No errors. |
| App\Entity\Users\Role | No errors. |
| App\Entity\Content\Revision | No errors. |
| App\Entity\Content\Menu | No errors. |
| App\Entity\Content\MenuItem | No errors. |