https://newdelruss.wmcrm.ru/news/novosti_19.html

Query Metrics

59 Database Queries
11 Different statements
39.28 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
16.98 ms
(43.24%)
30
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
]
5.02 ms
(12.78%)
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
]
3.65 ms
(9.30%)
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
]
3.05 ms
(7.76%)
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"
]
3.04 ms
(7.73%)
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
]
2.55 ms
(6.50%)
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.id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  "19"
]
1.26 ms
(3.20%)
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_News_Widget ON t0.id = WM_News_Widget.widget_id WHERE WM_News_Widget.news_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.priority ASC
Parameters:
[
  19
]
1.25 ms
(3.18%)
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
]
1.04 ms
(2.64%)
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
]
0.82 ms
(2.09%)
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.62 ms
(1.57%)
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:
[
  40
]

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\News No errors.
App\Entity\NewsCategory No errors.
App\Entity\File No errors.
App\Entity\SeoInfo No errors.
App\Entity\Menu No errors.
App\Entity\Setting No errors.
App\Entity\Block No errors.
App\Entity\Template No errors.
App\Entity\Partner No errors.