Query Metrics

21 Database Queries
8 Different statements
388.27 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 13.22 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 152.53 ms
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.created AS created_2, p0_.enabled AS enabled_3, p0_.is_main AS is_main_4, p0_.anons AS anons_5, p0_.content AS content_6, p0_.seo_title AS seo_title_7, p0_.seo_description AS seo_description_8, p0_.seo_keywords AS seo_keywords_9, p0_.updated AS updated_10, p0_.image AS image_11, p0_.preview AS preview_12, p0_.video_link AS video_link_13, p0_.link AS link_14, p0_.slug AS slug_15, p0_.video AS video_16, p0_.image_alt AS image_alt_17, p0_.category_id AS category_id_18, p0_.parent_id AS parent_id_19, p0_.local_project_id AS local_project_id_20 FROM publication p0_ WHERE p0_.enabled = 1 AND p0_.category_id = ? AND (p0_.anons LIKE ? OR p0_.content LIKE ?) ORDER BY p0_.created DESC
Parameters:
[
  1
  "%директор%"
  "%директор%"
]
3 27.40 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
]
4 7.02 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"
]
5 7.37 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"
]
6 7.70 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"
]
7 7.50 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"
]
8 7.78 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"
]
9 5.56 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"
]
10 5.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:
[
  11
]
11 7.06 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
]
12 7.24 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
]
13 7.12 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
]
14 5.42 ms
SELECT DATABASE()
Parameters:
[]
15 6.72 ms
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "mos_portal"
]
16 3.76 ms
SELECT DATABASE()
Parameters:
[]
17 10.18 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 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "presentForm"
]
18 57.41 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 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "emailSuccess"
]
19 9.47 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 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "formSuccess"
]
20 27.93 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 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "formS"
]
21 4.79 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 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "formS2"
]

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.
App\Entity\ProjectDistict No errors.
App\Entity\LocalProjectImage No errors.
App\Entity\Project No errors.
App\Entity\Review No errors.
App\Entity\ServiceCompany No errors.
App\Entity\JukService No errors.
App\Entity\Smi No errors.
App\Entity\Chart No errors.
App\Entity\ProjectRezident No errors.
App\Entity\Document No errors.
App\Entity\Setting No errors.
App\Entity\DocumentGroup No errors.
App\Entity\User No errors.
App\Entity\Itog No errors.
App\Entity\Gallery No errors.
App\Entity\Subscribtion No errors.
App\Entity\JukIcon No errors.
App\Entity\Person No errors.
App\Entity\Map No errors.
App\Entity\Order No errors.
App\Entity\ProjectItemImage No errors.
App\Entity\UserOrder No errors.
App\Entity\PersonCategory No errors.
App\Entity\JukSmi No errors.
App\Entity\PriceIndex No errors.
App\Entity\GalleryItem No errors.
App\Entity\ProjectItem No errors.
App\Entity\ProjectContentGroup No errors.
App\Entity\ChartValue No errors.
App\Entity\PriceIndexItem No errors.
App\Entity\Partner No errors.
Vich\UploaderBundle\Entity\File No errors.