Query Metrics

19 Database Queries
8 Different statements
26.58 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
5.33 ms
(20.07%)
6
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.18 ms
(19.51%)
3
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"
]
3.55 ms
(13.34%)
1
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
]
3.53 ms
(13.27%)
1
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:
[]
3.14 ms
(11.80%)
4
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
]
3.08 ms
(11.58%)
1
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "mos_portal"
]
1.56 ms
(5.89%)
2
SELECT DATABASE()
Parameters:
[]
1.21 ms
(4.55%)
1
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 = ? AND t0.enabled = ? LIMIT 1
Parameters:
[
  "policy"
  1
]

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\Page No errors.
App\Entity\Menu No errors.
App\Entity\ProjectDistict 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\LocalProject No errors.
App\Entity\ProjectRezident No errors.
App\Entity\Document No errors.
App\Entity\Setting No errors.
App\Entity\PublicationCategory No errors.
App\Entity\Publication 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\LocalProjectImage No errors.
App\Entity\PublicationImage No errors.
App\Entity\PersonCategory No errors.
App\Entity\JukSmi No errors.
App\Entity\PriceIndex No errors.
App\Entity\GalleryItem No errors.
App\Entity\Project 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.