Query Metrics
36
Database Queries
23
Different statements
17.58 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.06 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/41"
]
|
2 | 1.36 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.54 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.48 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.37 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.53 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.86 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.32 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.38 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.26 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.40 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.18 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.22 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 | 1.72 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 | 1.00 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.58 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.32 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.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:
[] |
19 | 0.28 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.22 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.22 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.22 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.20 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.75 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.42 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.89 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 44 41 ] |
27 | 0.43 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.35 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.23 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.74 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.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM construction_progress_album t0
Parameters:
[] |
33 | 0.15 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.27 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.16 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.77 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. |