https://newdelruss.wmcrm.ru/arkhiv/2017

Query Metrics

86 Database Queries
14 Different statements
32.11 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
12.21 ms
(38.02%)
40
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
]
6.45 ms
(20.07%)
18
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
]
2.61 ms
(8.14%)
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
]
2.16 ms
(6.73%)
5
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
]
1.87 ms
(5.82%)
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"
]
1.40 ms
(4.36%)
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/arkhiv/2017"
]
1.07 ms
(3.32%)
2
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.87 ms
(2.71%)
1
SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.description AS description_2, w0_.is_draft AS is_draft_3, w0_.period AS period_4, w0_.created_at AS created_at_5, w0_.updated_at AS updated_at_6, w0_.deleted_at AS deleted_at_7, w0_.is_active AS is_active_8, w0_.picture_id AS picture_id_9, w0_.file_id AS file_id_10 FROM WM_Periodical w0_ WHERE (w0_.is_active = 1 AND w0_.is_draft = 0 AND (w0_.created_at BETWEEN ? AND ?)) AND (w0_.deleted_at IS NULL) ORDER BY w0_.created_at DESC LIMIT 11
Parameters:
[
  "2017-01-01 00:00:00"
  "2017-12-31 23:59:59"
]
0.73 ms
(2.28%)
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
]
0.62 ms
(1.92%)
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"
  "ru/arkhiv"
  "ru/arkhiv/2017"
]
0.61 ms
(1.91%)
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.61 ms
(1.90%)
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:
[
  17
]
0.50 ms
(1.57%)
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:
[
  1
]
0.40 ms
(1.25%)
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:
[
  25
]

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\Periodical No errors.
App\Entity\Partner No errors.