Query Metrics
52
Database Queries
20
Different statements
244.64 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.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
Parameters:
[] |
| 2 | 1.12 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.count_company AS count_company_3, t0.count_workplace AS count_workplace_4, t0.count_invest AS count_invest_5 FROM itog t0 ORDER BY t0.title DESC
Parameters:
[] |
| 3 | 80.46 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
Parameters:
[
1
]
|
| 4 | 2.88 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.enabled = ?
Parameters:
[
1
]
|
| 5 | 5.13 ms |
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.image AS image_2, l0_.preview AS preview_3, l0_.ph1 AS ph1_4, l0_.ph2 AS ph2_5, l0_.amount_investment AS amount_investment_6, l0_.work_place AS work_place_7, l0_.enabled AS enabled_8, l0_.created AS created_9, l0_.updated AS updated_10, l0_.content AS content_11, l0_.implementation_period AS implementation_period_12, l0_.fact1_title AS fact1_title_13, l0_.fact1_value AS fact1_value_14, l0_.fact2_title AS fact2_title_15, l0_.fact2_value AS fact2_value_16, l0_.fact3_title AS fact3_title_17, l0_.fact3_value AS fact3_value_18, l0_.content2 AS content2_19, l0_.map_string AS map_string_20, l0_.location AS location_21, l0_.sort AS sort_22, l0_.loc_x AS loc_x_23, l0_.loc_y AS loc_y_24, l0_.seo_title AS seo_title_25, l0_.seo_description AS seo_description_26, l0_.seo_keywords AS seo_keywords_27, l0_.distict_id AS distict_id_28 FROM local_project l0_ WHERE l0_.enabled = 1 ORDER BY l0_.sort ASC LIMIT 4
Parameters:
[] |
| 6 | 1.39 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.preview AS preview_4, t0.ph1 AS ph1_5, t0.ph2 AS ph2_6, t0.amount_investment AS amount_investment_7, t0.work_place AS work_place_8, t0.enabled AS enabled_9, t0.created AS created_10, t0.updated AS updated_11, t0.content AS content_12, t0.implementation_period AS implementation_period_13, t0.fact1_title AS fact1_title_14, t0.fact1_value AS fact1_value_15, t0.fact2_title AS fact2_title_16, t0.fact2_value AS fact2_value_17, t0.fact3_title AS fact3_title_18, t0.fact3_value AS fact3_value_19, t0.content2 AS content2_20, t0.map_string AS map_string_21, t0.location AS location_22, t0.sort AS sort_23, t0.loc_x AS loc_x_24, t0.loc_y AS loc_y_25, t0.seo_title AS seo_title_26, t0.seo_description AS seo_description_27, t0.seo_keywords AS seo_keywords_28, t0.distict_id AS distict_id_29 FROM local_project t0 WHERE t0.enabled = ?
Parameters:
[
1
]
|
| 7 | 1.48 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.created AS created_3, t0.updated AS updated_4, t0.enabled AS enabled_5, t0.image AS image_6, t0.site AS site_7 FROM partner t0 WHERE t0.enabled = ?
Parameters:
[
1
]
|
| 8 | 1.11 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
]
|
| 9 | 29.87 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 6
Parameters:
[ 1 1 ] |
| 10 | 1.45 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.is_main = ? AND t0.category_id = ? ORDER BY t0.created DESC LIMIT 6
Parameters:
[ 1 1 2 ] |
| 11 | 1.53 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.is_main = ? AND t0.category_id = ? ORDER BY t0.created DESC LIMIT 6
Parameters:
[ 1 1 3 ] |
| 12 | 4.81 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.is_main = ? AND t0.category_id = ? ORDER BY t0.created DESC LIMIT 6
Parameters:
[ 1 1 4 ] |
| 13 | 6.90 ms |
SELECT t0.id AS id_1, t0.company_image AS company_image_2, t0.person_image AS person_image_3, t0.person_title AS person_title_4, t0.persont_post AS persont_post_5, t0.content AS content_6, t0.created AS created_7, t0.updated AS updated_8 FROM review t0
Parameters:
[] |
| 14 | 1.20 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:
[
"main"
]
|
| 15 | 5.72 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:
[
7
]
|
| 16 | 2.50 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.remoteness AS remoteness_4, t0.square AS square_5, t0.content AS content_6, t0.infrastructure AS infrastructure_7, t0.location AS location_8, t0.created AS created_9, t0.updated AS updated_10, t0.logo AS logo_11, t0.image AS image_12 FROM price_index t0 WHERE t0.type = ? ORDER BY t0.id DESC
Parameters:
[
"home"
]
|
| 17 | 1.28 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
16
]
|
| 18 | 1.16 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
11
]
|
| 19 | 1.16 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
10
]
|
| 20 | 1.31 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
9
]
|
| 21 | 2.12 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.remoteness AS remoteness_4, t0.square AS square_5, t0.content AS content_6, t0.infrastructure AS infrastructure_7, t0.location AS location_8, t0.created AS created_9, t0.updated AS updated_10, t0.logo AS logo_11, t0.image AS image_12 FROM price_index t0 WHERE t0.type = ? ORDER BY t0.id DESC
Parameters:
[
"area"
]
|
| 22 | 1.68 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
14
]
|
| 23 | 1.35 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
13
]
|
| 24 | 3.25 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
8
]
|
| 25 | 1.95 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
7
]
|
| 26 | 1.89 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
5
]
|
| 27 | 2.36 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
4
]
|
| 28 | 2.16 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
3
]
|
| 29 | 5.58 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
2
]
|
| 30 | 1.23 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.price AS price_3, t0.price_index_id AS price_index_id_4 FROM price_index_item t0 WHERE t0.price_index_id = ? ORDER BY t0.date DESC
Parameters:
[
1
]
|
| 31 | 1.67 ms |
SELECT MONTH(p0_.date) AS sclr_0, AVG(p0_.price) AS sclr_1 FROM price_index_item p0_ LEFT JOIN price_index p1_ ON p0_.price_index_id = p1_.id WHERE p1_.type = ? GROUP BY sclr_0 ORDER BY p0_.date ASC LIMIT 6
Parameters:
[
"home"
]
|
| 32 | 1.98 ms |
SELECT MONTH(p0_.date) AS sclr_0, AVG(p0_.price) AS sclr_1 FROM price_index_item p0_ LEFT JOIN price_index p1_ ON p0_.price_index_id = p1_.id WHERE p1_.type = ? GROUP BY sclr_0 ORDER BY p0_.date ASC LIMIT 6
Parameters:
[
"area"
]
|
| 33 | 1.91 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
]
|
| 34 | 1.27 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"
]
|
| 35 | 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:
[
"project"
]
|
| 36 | 1.18 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"
]
|
| 37 | 0.86 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"
]
|
| 38 | 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:
[
"contacts"
]
|
| 39 | 0.74 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"
]
|
| 40 | 0.81 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
]
|
| 41 | 0.86 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
]
|
| 42 | 5.87 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
]
|
| 43 | 9.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:
[
12
]
|
| 44 | 6.53 ms |
SELECT DATABASE()
Parameters:
[] |
| 45 | 7.74 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"mos_portal"
]
|
| 46 | 10.16 ms |
SELECT DATABASE()
Parameters:
[] |
| 47 | 1.55 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"
]
|
| 48 | 1.76 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"
]
|
| 49 | 1.57 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"
]
|
| 50 | 1.60 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"
]
|
| 51 | 4.26 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"
]
|
| 52 | 1.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 WHERE t0.name = ? LIMIT 1
Parameters:
[
"subscriberSuccess"
]
|
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\Itog | No errors. |
| App\Entity\Publication | No errors. |
| App\Entity\PublicationCategory | No errors. |
| App\Entity\LocalProject | No errors. |
| App\Entity\PublicationImage | 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\Partner | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\PriceIndex | No errors. |
| App\Entity\PriceIndexItem | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\LocalProjectImage | No errors. |
| App\Entity\GalleryItem | No errors. |
| App\Entity\ProjectItemImage | No errors. |
| App\Entity\ServiceCompany | 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\DocumentGroup | No errors. |
| App\Entity\User | 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\PersonCategory | No errors. |
| App\Entity\JukSmi | No errors. |
| App\Entity\ChartValue | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |