Query Metrics
26
Database Queries
7
Different statements
11.80 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
9.05 ms (76.68%) |
1 |
(SELECT *, MATCH (title,content) AGAINST ('') as score FROM `WM_SearchIndexTable` WHERE MATCH (title,content) AGAINST ('"" @8' IN BOOLEAN MODE) ORDER BY score DESC)
Parameters:
[] |
0.72 ms (6.10%) |
8 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.is_active AS is_active_8, t0.priority AS priority_9 FROM WM_Block t0 WHERE t0.alias = ? AND t0.is_active = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[ "head-meta" 1 ] |
0.64 ms (5.43%) |
5 |
SELECT t0.id AS id_1, t0.context AS context_2, t0.type AS type_3, t0.label AS label_4, t0.name AS name_5, t0.value AS value_6 FROM WM_Setting t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"site_name"
]
|
0.56 ms (4.76%) |
6 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.external AS external_3, t0.name AS name_4, t0.alias AS alias_5, t0.route AS route_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.priority AS priority_10, t0.is_active AS is_active_11, t0.lft AS lft_12, t0.lvl AS lvl_13, t0.rgt AS rgt_14, t0.template_id AS template_id_15, t0.seo_info_id AS seo_info_id_16, t0.parent_id AS parent_id_17, t0.root_id AS root_id_18 FROM WM_Page t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
2
]
|
0.54 ms (4.54%) |
4 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.alias AS alias_4, t0.link AS link_5, t0.add_to_header AS add_to_header_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.is_active AS is_active_10, t0.priority AS priority_11, t0.lft AS lft_12, t0.lvl AS lvl_13, t0.rgt AS rgt_14, t0.page_id AS page_id_15, t0.parent_id AS parent_id_16, t0.root_id AS root_id_17 FROM WM_Menu t0 WHERE t0.alias = ? AND t0.is_active = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
Parameters:
[ "header-menu" 1 ] |
0.19 ms (1.61%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.alias AS alias_4, t0.link AS link_5, t0.add_to_header AS add_to_header_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.is_active AS is_active_10, t0.priority AS priority_11, t0.lft AS lft_12, t0.lvl AS lvl_13, t0.rgt AS rgt_14, t0.page_id AS page_id_15, t0.parent_id AS parent_id_16, t0.root_id AS root_id_17 FROM WM_Menu t0 WHERE t0.parent_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.lft ASC, t0.priority ASC
Parameters:
[
2
]
|
0.10 ms (0.88%) |
1 |
SELECT t0.id AS id_1, t0.context AS context_2, t0.name AS name_3, t0.uniqid AS uniqid_4, t0.path AS path_5, t0.extension AS extension_6, t0.size AS size_7, t0.use_count AS use_count_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.deleted_at AS deleted_at_11, t0.is_active AS is_active_12 FROM WM_File t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
770
]
|
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\Menu | No errors. |
App\Entity\File | No errors. |
App\Entity\Setting | No errors. |
App\Entity\Block | No errors. |
App\Entity\Page | No errors. |
App\Entity\Template | No errors. |
App\Entity\SeoInfo | No errors. |
App\Entity\Widget | No errors. |