Query Metrics

17 Database Queries
8 Different statements
131.88 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 12.65 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.name AS name_3, t0.content AS content_4, t0.module AS module_5, t0.menu_title AS menu_title_6, t0.in_menu AS in_menu_7 FROM page_block t0
Parameters:
[]
2 15.21 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.enabled AS enabled_4, t0.is_main AS is_main_5, t0.anons AS anons_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.updated AS updated_11, t0.image AS image_12, t0.preview AS preview_13, t0.video_link AS video_link_14, t0.link AS link_15, t0.slug AS slug_16, t0.video AS video_17, t0.image_alt AS image_alt_18, t0.category_id AS category_id_19, t0.parent_id AS parent_id_20, t0.local_project_id AS local_project_id_21 FROM publication t0 WHERE t0.slug = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "корея-заинтересована-в-сотрудничестве-с-московской-областью"
  1
]
3 12.83 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.slug AS slug_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6 FROM publication_category t0 WHERE t0.enabled = ?
Parameters:
[
  1
]
4 41.12 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.enabled AS enabled_4, t0.is_main AS is_main_5, t0.anons AS anons_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.updated AS updated_11, t0.image AS image_12, t0.preview AS preview_13, t0.video_link AS video_link_14, t0.link AS link_15, t0.slug AS slug_16, t0.video AS video_17, t0.image_alt AS image_alt_18, t0.category_id AS category_id_19, t0.parent_id AS parent_id_20, t0.local_project_id AS local_project_id_21 FROM publication t0 WHERE t0.enabled = ? ORDER BY t0.created DESC LIMIT 20
Parameters:
[
  1
]
5 5.72 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.enabled AS enabled_4, t0.is_main AS is_main_5, t0.anons AS anons_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.updated AS updated_11, t0.image AS image_12, t0.preview AS preview_13, t0.video_link AS video_link_14, t0.link AS link_15, t0.slug AS slug_16, t0.video AS video_17, t0.image_alt AS image_alt_18, t0.category_id AS category_id_19, t0.parent_id AS parent_id_20, t0.local_project_id AS local_project_id_21 FROM publication t0 WHERE t0.enabled = ? AND t0.category_id = ? ORDER BY t0.created DESC LIMIT 3
Parameters:
[
  1
  2
]
6 1.74 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.enabled AS enabled_4, t0.is_main AS is_main_5, t0.anons AS anons_6, t0.content AS content_7, t0.seo_title AS seo_title_8, t0.seo_description AS seo_description_9, t0.seo_keywords AS seo_keywords_10, t0.updated AS updated_11, t0.image AS image_12, t0.preview AS preview_13, t0.video_link AS video_link_14, t0.link AS link_15, t0.slug AS slug_16, t0.video AS video_17, t0.image_alt AS image_alt_18, t0.category_id AS category_id_19, t0.parent_id AS parent_id_20, t0.local_project_id AS local_project_id_21 FROM publication t0 WHERE t0.enabled = ? AND t0.category_id = ? ORDER BY t0.created DESC LIMIT 3
Parameters:
[
  1
  3
]
7 1.27 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.enabled AS enabled_4, t0.sort AS sort_5, t0.parent_id AS parent_id_6 FROM menu t0 WHERE t0.enabled = ? AND t0.parent_id IS NULL ORDER BY t0.sort ASC
Parameters:
[
  1
]
8 1.76 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.content AS content_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.slug AS slug_8 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "about"
]
9 0.95 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.content AS content_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.slug AS slug_8 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "project"
]
10 0.76 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.content AS content_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.slug AS slug_8 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "korolev"
]
11 1.45 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.content AS content_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.slug AS slug_8 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "publications"
]
12 4.44 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.content AS content_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.slug AS slug_8 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "contacts"
]
13 26.38 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.content AS content_4, t0.seo_title AS seo_title_5, t0.seo_description AS seo_description_6, t0.seo_keywords AS seo_keywords_7, t0.slug AS slug_8 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "o-regione"
]
14 1.28 ms
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.page_id AS page_id_3, t0.block_id AS block_id_4 FROM page_page_block t0 WHERE t0.page_id = ? ORDER BY t0.sort ASC
Parameters:
[
  11
]
15 2.23 ms
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.page_id AS page_id_3, t0.block_id AS block_id_4 FROM page_page_block t0 WHERE t0.page_id = ? ORDER BY t0.sort ASC
Parameters:
[
  10
]
16 1.08 ms
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.page_id AS page_id_3, t0.block_id AS block_id_4 FROM page_page_block t0 WHERE t0.page_id = ? ORDER BY t0.sort ASC
Parameters:
[
  8
]
17 1.01 ms
SELECT t0.id AS id_1, t0.sort AS sort_2, t0.page_id AS page_id_3, t0.block_id AS block_id_4 FROM page_page_block t0 WHERE t0.page_id = ? ORDER BY t0.sort ASC
Parameters:
[
  12
]

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\PageBlock No errors.
App\Entity\PagePageBlock No errors.
App\Entity\Publication No errors.
App\Entity\PublicationCategory No errors.
App\Entity\LocalProject No errors.
App\Entity\PublicationImage No errors.
App\Entity\Menu No errors.
App\Entity\Page No errors.