Query Metrics
81
Database Queries
17
Different statements
163.61 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
42.93 ms (26.24%) |
46 |
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
]
|
13.12 ms (8.02%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.annotation AS annotation_4, t0.description AS description_5, t0.is_draft AS is_draft_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.import_id AS import_id_10, t0.is_active AS is_active_11, t0.priority AS priority_12, t0.category_id AS category_id_13, t0.picture_id AS picture_id_14, t0.seo_info_id AS seo_info_id_15 FROM WM_News t0 WHERE t0.category_id = ? AND t0.is_active = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.created_at DESC LIMIT 6
Parameters:
[ 1 1 ] |
12.70 ms (7.76%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.is_active AS is_active_4, t0.type AS type_5, t0.options AS options_6, t0.is_sidebar AS is_sidebar_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM WM_Widget t0 WHERE t0.is_active = ? AND t0.is_sidebar = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.priority ASC
Parameters:
[ 1 1 ] |
12.66 ms (7.74%) |
1 |
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.alias AS alias_2, w0_.annotation AS annotation_3, w0_.description AS description_4, w0_.is_draft AS is_draft_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7, w0_.deleted_at AS deleted_at_8, w0_.import_id AS import_id_9, w0_.is_active AS is_active_10, w0_.priority AS priority_11, w0_.category_id AS category_id_12, w0_.picture_id AS picture_id_13, w0_.seo_info_id AS seo_info_id_14 FROM WM_News w0_ WHERE (w0_.is_active = 1 AND w0_.is_draft = 0 AND w0_.created_at >= ? AND w0_.category_id = ?) AND (w0_.deleted_at IS NULL) ORDER BY w0_.created_at ASC LIMIT 3
Parameters:
[ "2024-10-11 15:06:51" 2 ] |
12.19 ms (7.45%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_draft AS is_draft_4, t0.period AS period_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.is_active AS is_active_9, t0.picture_id AS picture_id_10, t0.file_id AS file_id_11 FROM WM_Periodical t0 WHERE t0.is_active = ? AND t0.is_draft = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.created_at DESC LIMIT 6
Parameters:
[ 1 0 ] |
11.38 ms (6.95%) |
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 ] |
8.91 ms (5.45%) |
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 ] |
8.55 ms (5.23%) |
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"
]
|
7.61 ms (4.65%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3 FROM WM_Template t0 WHERE t0.id = ?
Parameters:
[
3
]
|
5.82 ms (3.56%) |
1 |
SELECT w0_.id AS id_0, w0_.type AS type_1, w0_.external AS external_2, w0_.name AS name_3, w0_.alias AS alias_4, w0_.route AS route_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7, w0_.deleted_at AS deleted_at_8, w0_.priority AS priority_9, w0_.is_active AS is_active_10, w0_.lft AS lft_11, w0_.lvl AS lvl_12, w0_.rgt AS rgt_13, w0_.template_id AS template_id_14, w0_.seo_info_id AS seo_info_id_15, w0_.parent_id AS parent_id_16, w0_.root_id AS root_id_17 FROM WM_Page w0_ WHERE (w0_.route = ?) AND (w0_.deleted_at IS NULL)
Parameters:
[
"ru"
]
|
5.47 ms (3.34%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.alias AS alias_3, t0.import_id AS import_id_4, t0.is_active AS is_active_5, t0.priority AS priority_6, t0.deleted_at AS deleted_at_7, t0.pictureId AS pictureId_8 FROM WM_News_Category t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
5.30 ms (3.24%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.is_active AS is_active_4, t0.type AS type_5, t0.options AS options_6, t0.is_sidebar AS is_sidebar_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10 FROM WM_Widget t0 INNER JOIN WM_Page_Widget ON t0.id = WM_Page_Widget.widget_id WHERE WM_Page_Widget.page_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.priority ASC
Parameters:
[
1
]
|
4.92 ms (3.00%) |
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
]
|
4.85 ms (2.97%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.is_target_blank AS is_target_blank_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, t0.picture_id AS picture_id_10 FROM WM_Partner t0 WHERE t0.is_active = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.created_at ASC
Parameters:
[
1
]
|
4.68 ms (2.86%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.keywords AS keywords_3, t0.description AS description_4, t0.open_graph AS open_graph_5, t0.deleted_at AS deleted_at_6 FROM WM_Seo_Info t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
1
]
|
1.60 ms (0.98%) |
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.93 ms (0.57%) |
1 |
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.is_active = ? AND t0.route IN (?) AND ((t0.deleted_at IS NULL))
Parameters:
[ 1 "ru" ] |
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\Page | No errors. |
App\Entity\Widget | No errors. |
App\Entity\Template | No errors. |
App\Entity\SeoInfo | No errors. |
App\Entity\Menu | No errors. |
App\Entity\File | No errors. |
App\Entity\Setting | No errors. |
App\Entity\Block | No errors. |
App\Entity\News | No errors. |
App\Entity\NewsCategory | No errors. |
App\Entity\Periodical | No errors. |
App\Entity\Partner | No errors. |