https://domureki2.kssk.ru/request/trade-in-layout-modal/38

Query Metrics

36 Database Queries
23 Different statements
15.25 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.86 ms
SELECT t0.url AS url_1, t0.id AS id_2, t0.title AS title_3, t0.keywords AS keywords_4, t0.description AS description_5 FROM url_seo t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
  "/request/trade-in-layout-modal/38"
]
2 1.19 ms
SELECT t0.id AS id_1, t0.phone AS phone_2, t0.email AS email_3, t0.favorites_link AS favorites_link_4, t0.project_name AS project_name_5, t0.vk AS vk_6, t0.yt AS yt_7, t0.tg AS tg_8, t0.address AS address_9, t0.address_lat AS address_lat_10, t0.address_lng AS address_lng_11, t0.week_days AS week_days_12, t0.week_ends AS week_ends_13, t0.policy AS policy_14, t0.webcam AS webcam_15, t0.image_name AS image_name_16, t0.form_title AS form_title_17, t0.form_subtitle AS form_subtitle_18, t0.button_text AS button_text_19, t0.counters_body AS counters_body_20, t0.counters_head AS counters_head_21, t0.favicon_tags AS favicon_tags_22, t0.success_goal AS success_goal_23, t0.success_layout_goal AS success_layout_goal_24, t0.success_popup_goal AS success_popup_goal_25, t0.click_form_goal AS click_form_goal_26, t0.click_layout_form_goal AS click_layout_form_goal_27, t0.click_phone_goal AS click_phone_goal_28, t0.fav_goal AS fav_goal_29, t0.hero_button_goal AS hero_button_goal_30, t0.filter_goal AS filter_goal_31, t0.trade_in_click_goal AS trade_in_click_goal_32, t0.trade_in_submit_goal AS trade_in_submit_goal_33, t0.success_all_lead AS success_all_lead_34, t0.import_name AS import_name_35, t0.second_annotation AS second_annotation_36, t0.updated_at AS updated_at_37 FROM settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
3 0.72 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_white_name AS image_white_name_3, t0.image_pattern_name AS image_pattern_name_4, t0.uitype AS uitype_5, t0.color_main01 AS color_main01_6, t0.color_grey01 AS color_grey01_7, t0.color_grey02 AS color_grey02_8, t0.color_grey03 AS color_grey03_9, t0.color_add01 AS color_add01_10, t0.color_add04 AS color_add04_11, t0.color_add06 AS color_add06_12, t0.color_add07 AS color_add07_13, t0.color_add08 AS color_add08_14, t0.updated_at AS updated_at_15 FROM view_settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
4 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.action_hint_text AS action_hint_text_4, t0.icon_bg AS icon_bg_5, t0.image_icon_name AS image_icon_name_6, t0.active AS active_7, t0.updated_at AS updated_at_8 FROM action_link_settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
5 0.27 ms
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.image_white_name AS image_white_name_3, t0.image_pattern_name AS image_pattern_name_4, t0.uitype AS uitype_5, t0.color_main01 AS color_main01_6, t0.color_grey01 AS color_grey01_7, t0.color_grey02 AS color_grey02_8, t0.color_grey03 AS color_grey03_9, t0.color_add01 AS color_add01_10, t0.color_add04 AS color_add04_11, t0.color_add06 AS color_add06_12, t0.color_add07 AS color_add07_13, t0.color_add08 AS color_add08_14, t0.updated_at AS updated_at_15 FROM view_settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
6 0.50 ms
SELECT t0.id AS id_1, t0.ui_type AS ui_type_2, t0.title AS title_3, t0.description AS description_4, t0.developer AS developer_5, t0.hide_logo AS hide_logo_6, t0.address AS address_7, t0.address_in_list AS address_in_list_8, t0.deadline_title AS deadline_title_9, t0.deadline AS deadline_10, t0.district AS district_11, t0.number_of_floors AS number_of_floors_12, t0.flats_area AS flats_area_13, t0.video_link AS video_link_14, t0.video_title AS video_title_15, t0.video_preview_image_name AS video_preview_image_name_16, t0.logo_image_name AS logo_image_name_17, t0.updated_at AS updated_at_18 FROM hero_settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
7 0.69 ms
SELECT t0.id AS id_1, t0.project AS project_2, t0.genplan AS genplan_3, t0.plannings AS plannings_4, t0.advantages AS advantages_5, t0.infrastructure AS infrastructure_6, t0.construct AS construct_7, t0.payment AS payment_8 FROM block_title_settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
8 0.37 ms
SELECT t0.id AS id_1, t0.block AS block_2, t0.position AS position_3 FROM block_order_item t0
Parameters:
[]
9 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.title AS title_3, t0.position AS position_4 FROM project_item t0
Parameters:
[]
10 0.25 ms
SELECT t0.id AS id_1, t0.block AS block_2, t0.position AS position_3 FROM block_order_item t0
Parameters:
[]
11 0.42 ms
SELECT t0.id AS id_1, t0.genplan_type AS genplan_type_2, t0.building_view_type AS building_view_type_3, t0.show_filter_quarter AS show_filter_quarter_4, t0.show_filter_building AS show_filter_building_5, t0.default_filter_building AS default_filter_building_6, t0.show_filter_area AS show_filter_area_7, t0.show_filter_section AS show_filter_section_8, t0.realty_view_type AS realty_view_type_9, t0.pager_limit AS pager_limit_10, t0.genplan_is_hidden AS genplan_is_hidden_11, t0.plannings_is_hidden AS plannings_is_hidden_12 FROM genplan_settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
12 0.23 ms
SELECT t0.id AS id_1, t0.block AS block_2, t0.position AS position_3 FROM block_order_item t0
Parameters:
[]
13 0.25 ms
SELECT t0.id AS id_1, t0.genplan_type AS genplan_type_2, t0.building_view_type AS building_view_type_3, t0.show_filter_quarter AS show_filter_quarter_4, t0.show_filter_building AS show_filter_building_5, t0.default_filter_building AS default_filter_building_6, t0.show_filter_area AS show_filter_area_7, t0.show_filter_section AS show_filter_section_8, t0.realty_view_type AS realty_view_type_9, t0.pager_limit AS pager_limit_10, t0.genplan_is_hidden AS genplan_is_hidden_11, t0.plannings_is_hidden AS plannings_is_hidden_12 FROM genplan_settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
14 0.89 ms
SELECT l0_.rooms AS rooms_0, l0_.is_studio AS is_studio_1 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL GROUP BY l0_.rooms, l0_.is_studio ORDER BY l0_.rooms ASC
Parameters:
[]
15 0.48 ms
SELECT DISTINCT a0_.floor AS floor_0, a0_.floor AS floor_1 FROM layout l1_ INNER JOIN apartment a2_ ON l1_.id = a2_.layout_id INNER JOIN apartment a0_ ON l1_.id = a0_.layout_id WHERE a2_.id IS NOT NULL AND a0_.floor IS NOT NULL ORDER BY a0_.floor ASC
Parameters:
[]
16 0.46 ms
SELECT MIN(l0_.price) AS sclr_0 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL
Parameters:
[]
17 0.39 ms
SELECT MAX(l0_.price) AS sclr_0 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL
Parameters:
[]
18 0.37 ms
SELECT MIN(l0_.area_total) AS sclr_0 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL
Parameters:
[]
19 0.27 ms
SELECT MAX(l0_.area_total) AS sclr_0 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL
Parameters:
[]
20 0.26 ms
SELECT MIN(l0_.price) AS sclr_0 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL
Parameters:
[]
21 0.24 ms
SELECT MAX(l0_.price) AS sclr_0 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL
Parameters:
[]
22 0.28 ms
SELECT MIN(l0_.area_total) AS sclr_0 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL
Parameters:
[]
23 0.25 ms
SELECT MAX(l0_.area_total) AS sclr_0 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL
Parameters:
[]
24 0.49 ms
SELECT count(DISTINCT l0_.id) AS sclr_0 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL AND l0_.price >= ? AND l0_.price <= ? AND l0_.area_total >= ? AND l0_.area_total <= ?
Parameters:
[
  4416600
  6556500
  43
  71
]
25 0.45 ms
SELECT DISTINCT l0_.id AS id_0, l0_.price AS price_1 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL AND l0_.price >= ? AND l0_.price <= ? AND l0_.area_total >= ? AND l0_.area_total <= ? ORDER BY l0_.price ASC LIMIT 7
Parameters:
[
  4416600
  6556500
  43
  71
]
26 0.67 ms
SELECT l0_.id AS id_0, l0_.outer_key AS outer_key_1, l0_.name AS name_2, l0_.full_name AS full_name_3, l0_.type AS type_4, l0_.rooms AS rooms_5, l0_.is_studio AS is_studio_6, l0_.area_total AS area_total_7, l0_.area_living AS area_living_8, l0_.area_kitchen AS area_kitchen_9, l0_.floors_verbose AS floors_verbose_10, l0_.renovations_verbose AS renovations_verbose_11, l0_.price AS price_12, l0_.article AS article_13, l0_.last_sync_at AS last_sync_at_14, l0_.image_name AS image_name_15, l0_.image_hash AS image_hash_16, l0_.slug AS slug_17, l0_.section AS section_18, l0_.image_plan_name AS image_plan_name_19, l0_.image_furniture_name AS image_furniture_name_20, l0_.action_name AS action_name_21, l0_.url AS url_22, l0_.action_hint_text AS action_hint_text_23, l0_.icon_bg AS icon_bg_24, l0_.image_icon_name AS image_icon_name_25, l0_.active AS active_26, l0_.updated_at AS updated_at_27, l0_.building_id AS building_id_28 FROM layout l0_ INNER JOIN apartment a1_ ON l0_.id = a1_.layout_id WHERE a1_.id IS NOT NULL AND l0_.price >= ? AND l0_.price <= ? AND l0_.area_total >= ? AND l0_.area_total <= ? AND l0_.id IN (?, ?) ORDER BY l0_.price ASC
Parameters:
[
  4416600
  6556500
  43
  71
  43
  41
]
27 0.36 ms
SELECT t0.id AS id_1, t0.block AS block_2, t0.position AS position_3 FROM block_order_item t0
Parameters:
[]
28 0.34 ms
SELECT t0.id AS id_1, t0.ui_type AS ui_type_2 FROM advantage_settings t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
29 0.22 ms
SELECT t0.id AS id_1, t0.block AS block_2, t0.position AS position_3 FROM block_order_item t0
Parameters:
[]
30 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.way_type AS way_type_3, t0.time AS time_4, t0.distance AS distance_5, t0.image_name AS image_name_6, t0.address AS address_7, t0.address_lat AS address_lat_8, t0.address_lng AS address_lng_9, t0.updated_at AS updated_at_10, t0.type_id AS type_id_11 FROM infrastructure_item t0
Parameters:
[]
31 0.21 ms
SELECT t0.id AS id_1, t0.block AS block_2, t0.position AS position_3 FROM block_order_item t0
Parameters:
[]
32 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM construction_progress_album t0
Parameters:
[]
33 0.20 ms
SELECT t0.id AS id_1, t0.block AS block_2, t0.position AS position_3 FROM block_order_item t0
Parameters:
[]
34 0.39 ms
SELECT t0.id AS id_1, t0.payment_name AS payment_name_2, t0.payment_text AS payment_text_3 FROM payment t0
Parameters:
[]
35 0.24 ms
SELECT t0.id AS id_1, t0.block AS block_2, t0.position AS position_3 FROM block_order_item t0
Parameters:
[]
36 0.65 ms
SELECT t0.id AS id_1, t0.document_name AS document_name_2, t0.name AS name_3, t0.position AS position_4, t0.updated_at AS updated_at_5 FROM document t0 ORDER BY t0.position ASC
Parameters:
[]

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\Main\Entity\ViewSettings No errors.
App\Main\Entity\ActionLinkSettings No errors.
App\Main\Entity\BlockTitleSettings No errors.
App\Realty\Entity\GenplanSettings No errors.
App\Admin\Entity\AdminColumn No errors.
App\User\Entity\User No errors.
App\Main\Entity\Settings No errors.
App\Main\Entity\BlockOrderItem No errors.
App\Content\Entity\Project\ProjectItem No errors.
App\Realty\Entity\Layout No errors.
App\Realty\Entity\Quarter No errors.
App\Realty\Entity\Building No errors.
App\Content\Entity\Advantage\AdvantageSettings No errors.
App\Content\Entity\Infrastructure\InfrastructureItem No errors.
App\Content\Entity\ConstructionProgress\ConstructionProgressAlbum No errors.
App\Content\Entity\Payment No errors.
App\Content\Entity\Hero\HeroSettings No errors.
App\Content\Entity\Infrastructure\InfrastructureSettings No errors.
App\Content\Entity\Document No errors.
App\Content\Entity\MortgageSettings No errors.
App\Realty\Entity\Apartment No errors.
App\Main\Entity\Popup No errors.
App\Seo\Entity\UrlSeo No errors.
App\Leads\Entity\TradeInLayoutRecall No errors.
App\Content\Entity\Hero\HeroSlide No errors.
App\Content\Entity\Hero\HeroAddress No errors.
App\Content\Entity\Project\ProjectTab No errors.
App\Realty\Entity\FloorGroupPlace No errors.
App\Content\Entity\Advantage\Advantage No errors.
App\Content\Entity\Infrastructure\InfrastructureType No errors.
App\Leads\Entity\Recall No errors.