Query Metrics
77
Database Queries
6
Different statements
3.83 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.96 ms (77.25%) |
67 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.static_path AS static_path_3, t0.var_pattern AS var_pattern_4, t0.path AS path_5, t0.host AS host_6, t0.schemes AS schemes_7, t0.methods AS methods_8, t0.defaults AS defaults_9, t0.options AS options_10, t0.requirements AS requirements_11, t0.`condition` AS condition_12, t0.priority AS priority_13, t0.active AS active_14 FROM route t0 INNER JOIN menu_item_route_map ON t0.id = menu_item_route_map.route_id WHERE menu_item_route_map.item_id = ?
Parameters:
[
27
]
|
0.34 ms (9.00%) |
1 |
SELECT t1.id AS id_2, t1.section AS section_3, t0.value AS value_4, t1.type FROM setting_string t0 INNER JOIN setting t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
"meta.index_title"
]
|
0.26 ms (6.81%) |
6 |
SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.type AS type_2, m0_.position AS position_3, m0_.template AS template_4, m0_.menu_type AS menu_type_5, m0_.params AS params_6, m0_.cache AS cache_7, m0_.cache_type AS cache_type_8, m0_.state AS state_9, m0_.ordering AS ordering_10 FROM module m0_ WHERE m0_.position = ? ORDER BY m0_.ordering ASC
Parameters:
[
"sg-left-top"
]
|
0.14 ms (3.65%) |
1 |
SELECT m0_.id AS id_0, m0_.alias AS alias_1, m0_.name AS name_2, m0_.type AS type_3, m0_.lft AS lft_4, m0_.rgt AS rgt_5, m0_.depth AS depth_6, m0_.state AS state_7, m0_.content_count AS content_count_8, m0_.params AS params_9, m0_.menu_id AS menu_id_10, m0_.parent_id AS parent_id_11 FROM menu_item m0_ INNER JOIN menu_item_route_map m2_ ON m0_.id = m2_.item_id INNER JOIN route r1_ ON r1_.id = m2_.route_id WHERE m0_.depth > 0 AND m0_.type IN (?, ?, ?) ORDER BY m0_.lft ASC
Parameters:
[ "content.list" "content.single" "content.clear" ] |
0.07 ms (1.82%) |
1 |
SELECT m0_.id AS id_0, m0_.alias AS alias_1, m0_.name AS name_2, m0_.type AS type_3, m0_.lft AS lft_4, m0_.rgt AS rgt_5, m0_.depth AS depth_6, m0_.state AS state_7, m0_.content_count AS content_count_8, m0_.params AS params_9, m0_.menu_id AS menu_id_10, m0_.parent_id AS parent_id_11 FROM menu_item m0_ INNER JOIN menu_item_route_map m2_ ON m0_.id = m2_.item_id INNER JOIN route r1_ ON r1_.id = m2_.route_id WHERE r1_.name = ? LIMIT 1
Parameters:
[
"index"
]
|
0.06 ms (1.46%) |
1 |
SELECT t1.id AS id_2, t1.section AS section_3, t0.value AS value_4, t1.type FROM setting_int t0 INNER JOIN setting t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
"pagination.offset"
]
|
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\Route | No errors. |
App\Entity\Settings\Setting | No errors. |
App\Entity\Settings\StringSetting | No errors. |
App\Entity\Category\Category | No errors. |
App\Entity\Image | No errors. |
App\Entity\Menu\Item | No errors. |
App\Entity\Menu\Menu | No errors. |
App\Entity\Module\Module | No errors. |
App\Entity\Settings\IntSetting | No errors. |
App\Entity\Shop\DeliveryMethod | No errors. |
App\Entity\Shop\PaymentMethod | No errors. |
App\Entity\CustomField\CustomFieldValue | No errors. |