Query Metrics
18
Database Queries
8
Different statements
24.67 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
5.33 ms (21.62%) |
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"
]
|
|
3.55 ms (14.38%) |
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 (14.29%) |
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.27 ms (13.28%) |
2 |
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.14 ms (12.72%) |
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 (12.47%) |
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 (6.34%) |
2 |
SELECT DATABASE()
Parameters:
[] |
|
1.21 ms (4.90%) |
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. |