Query Metrics
44
Database Queries
16
Different statements
89.32 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 4.99 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 | 1.63 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.mkad AS mkad_4, t0.area AS area_5, t0.created AS created_6, t0.map_script AS map_script_7, t0.main_settings AS main_settings_8, t0.content AS content_9, t0.presentation AS presentation_10, t0.updated AS updated_11, t0.distict_id AS distict_id_12, t0.gallery_id AS gallery_id_13 FROM project t0 WHERE t0.id = ? AND t0.enabled = ? LIMIT 1
Parameters:
[ 1 1 ] |
| 3 | 2.79 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.area AS area_4, t0.type AS type_5, t0.map AS map_6, t0.image AS image_7, t0.content AS content_8, t0.description AS description_9, t0.updated AS updated_10, t0.vri AS vri_11, t0.kadastr AS kadastr_12, t0.price_gk AS price_gk_13, t0.d_title1 AS d_title1_14, t0.d_title2 AS d_title2_15, t0.d_title3 AS d_title3_16, t0.d_title4 AS d_title4_17, t0.d_content1 AS d_content1_18, t0.d_content2 AS d_content2_19, t0.d_content3 AS d_content3_20, t0.d_content4 AS d_content4_21, t0.adrs AS adrs_22, t0.status AS status_23, t0.presentation AS presentation_24, t0.project_id AS project_id_25 FROM project_item t0 WHERE t0.project_id = ? AND t0.type = ?
Parameters:
[ 1 "0" ] |
| 4 | 2.14 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.area AS area_4, t0.type AS type_5, t0.map AS map_6, t0.image AS image_7, t0.content AS content_8, t0.description AS description_9, t0.updated AS updated_10, t0.vri AS vri_11, t0.kadastr AS kadastr_12, t0.price_gk AS price_gk_13, t0.d_title1 AS d_title1_14, t0.d_title2 AS d_title2_15, t0.d_title3 AS d_title3_16, t0.d_title4 AS d_title4_17, t0.d_content1 AS d_content1_18, t0.d_content2 AS d_content2_19, t0.d_content3 AS d_content3_20, t0.d_content4 AS d_content4_21, t0.adrs AS adrs_22, t0.status AS status_23, t0.presentation AS presentation_24, t0.project_id AS project_id_25 FROM project_item t0 WHERE t0.project_id = ? AND t0.type = ?
Parameters:
[ 1 "0" ] |
| 5 | 3.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.area AS area_4, t0.type AS type_5, t0.map AS map_6, t0.image AS image_7, t0.content AS content_8, t0.description AS description_9, t0.updated AS updated_10, t0.vri AS vri_11, t0.kadastr AS kadastr_12, t0.price_gk AS price_gk_13, t0.d_title1 AS d_title1_14, t0.d_title2 AS d_title2_15, t0.d_title3 AS d_title3_16, t0.d_title4 AS d_title4_17, t0.d_content1 AS d_content1_18, t0.d_content2 AS d_content2_19, t0.d_content3 AS d_content3_20, t0.d_content4 AS d_content4_21, t0.adrs AS adrs_22, t0.status AS status_23, t0.presentation AS presentation_24, t0.project_id AS project_id_25 FROM project_item t0 WHERE t0.project_id = ? AND t0.type = ?
Parameters:
[ 1 "1" ] |
| 6 | 2.92 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.area AS area_4, t0.type AS type_5, t0.map AS map_6, t0.image AS image_7, t0.content AS content_8, t0.description AS description_9, t0.updated AS updated_10, t0.vri AS vri_11, t0.kadastr AS kadastr_12, t0.price_gk AS price_gk_13, t0.d_title1 AS d_title1_14, t0.d_title2 AS d_title2_15, t0.d_title3 AS d_title3_16, t0.d_title4 AS d_title4_17, t0.d_content1 AS d_content1_18, t0.d_content2 AS d_content2_19, t0.d_content3 AS d_content3_20, t0.d_content4 AS d_content4_21, t0.adrs AS adrs_22, t0.status AS status_23, t0.presentation AS presentation_24, t0.project_id AS project_id_25 FROM project_item t0 WHERE t0.project_id = ? AND t0.type = ?
Parameters:
[ 1 "1" ] |
| 7 | 1.59 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"
]
|
| 8 | 1.57 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
]
|
| 9 | 3.84 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.price AS price_3, t0.area AS area_4, t0.type AS type_5, t0.map AS map_6, t0.image AS image_7, t0.content AS content_8, t0.description AS description_9, t0.updated AS updated_10, t0.vri AS vri_11, t0.kadastr AS kadastr_12, t0.price_gk AS price_gk_13, t0.d_title1 AS d_title1_14, t0.d_title2 AS d_title2_15, t0.d_title3 AS d_title3_16, t0.d_title4 AS d_title4_17, t0.d_content1 AS d_content1_18, t0.d_content2 AS d_content2_19, t0.d_content3 AS d_content3_20, t0.d_content4 AS d_content4_21, t0.adrs AS adrs_22, t0.status AS status_23, t0.presentation AS presentation_24, t0.project_id AS project_id_25 FROM project_item t0 WHERE t0.project_id = ?
Parameters:
[
1
]
|
| 10 | 5.62 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
]
|
| 11 | 5.12 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"
]
|
| 12 | 1.93 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"
]
|
| 13 | 1.35 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"
]
|
| 14 | 1.01 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"
]
|
| 15 | 0.90 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"
]
|
| 16 | 0.89 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"
]
|
| 17 | 1.07 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
]
|
| 18 | 2.41 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
]
|
| 19 | 1.43 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
]
|
| 20 | 1.54 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
]
|
| 21 | 2.35 ms |
SELECT DATABASE()
Parameters:
[] |
| 22 | 3.15 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"mos_portal"
]
|
| 23 | 0.76 ms |
SELECT DATABASE()
Parameters:
[] |
| 24 | 2.26 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.preview AS preview_3, t0.image AS image_4, t0.updated AS updated_5, t0.project_id AS project_id_6 FROM project_rezident t0 WHERE t0.project_id = ?
Parameters:
[
1
]
|
| 25 | 1.14 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.enabled AS enabled_3 FROM gallery t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 26 | 1.06 ms |
SELECT t0.id AS id_1, t0.updated AS updated_2, t0.image AS image_3, t0.image_alt AS image_alt_4, t0.title AS title_5, t0.gallery_id AS gallery_id_6 FROM gallery_item t0 WHERE t0.gallery_id = ?
Parameters:
[
1
]
|
| 27 | 1.05 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.project_id AS project_id_4, t0.setting_project_id AS setting_project_id_5 FROM project_content_group t0 WHERE t0.project_id = ?
Parameters:
[
1
]
|
| 28 | 1.24 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.project_id AS project_id_4, t0.setting_project_id AS setting_project_id_5 FROM project_content_group t0 WHERE t0.setting_project_id = ?
Parameters:
[
1
]
|
| 29 | 1.09 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
21
]
|
| 30 | 0.85 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
22
]
|
| 31 | 1.16 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
38
]
|
| 32 | 1.03 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
40
]
|
| 33 | 2.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
43
]
|
| 34 | 1.20 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
44
]
|
| 35 | 2.15 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
49
]
|
| 36 | 1.01 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
50
]
|
| 37 | 0.80 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
52
]
|
| 38 | 6.69 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
53
]
|
| 39 | 1.12 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
54
]
|
| 40 | 1.05 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
55
]
|
| 41 | 1.05 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.contact AS contact_4, t0.updated AS updated_5, t0.image AS image_6 FROM service_company t0 INNER JOIN project_content_group_service_company ON t0.id = project_content_group_service_company.service_company_id WHERE project_content_group_service_company.project_content_group_id = ?
Parameters:
[
56
]
|
| 42 | 3.75 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"
]
|
| 43 | 1.67 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"
]
|
| 44 | 1.58 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"
]
|
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\Project | No errors. |
| App\Entity\ProjectDistict | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\ProjectRezident | No errors. |
| App\Entity\ProjectItem | No errors. |
| App\Entity\ProjectContentGroup | No errors. |
| App\Entity\ProjectItemImage | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\LocalProject | No errors. |
| App\Entity\GalleryItem | No errors. |
| App\Entity\ServiceCompany | No errors. |
| App\Entity\LocalProjectImage | No errors. |
| App\Entity\Publication | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\JukService | No errors. |
| App\Entity\Smi | No errors. |
| App\Entity\Chart | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\Setting | No errors. |
| App\Entity\PublicationCategory | No errors. |
| App\Entity\DocumentGroup | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Itog | 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\UserOrder | No errors. |
| App\Entity\PublicationImage | No errors. |
| App\Entity\PersonCategory | No errors. |
| App\Entity\JukSmi | No errors. |
| App\Entity\PriceIndex | No errors. |
| App\Entity\ChartValue | No errors. |
| App\Entity\PriceIndexItem | No errors. |
| App\Entity\Partner | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |