Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.block AS block_2,
  t0.position AS position_3
FROM
  block_order_item t0

SELECT t0.id AS id_1, t0.block AS block_2, t0.position AS position_3 FROM block_order_item t0;

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

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 = 1 LIMIT 1;

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

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;

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

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 = 1 LIMIT 1;

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

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 = 1 LIMIT 1;

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

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;

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

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;

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

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 >= 4416600 AND l0_.price <= 6556500 AND l0_.area_total >= 43 AND l0_.area_total <= 71 AND l0_.id IN (43, 41) ORDER BY l0_.price ASC;

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

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 = '/request/trade-in-layout-modal/8' LIMIT 1;

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

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;

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

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 = 1 LIMIT 1;

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

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;

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 <= ?

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 >= 4416600 AND l0_.price <= 6556500 AND l0_.area_total >= 43 AND l0_.area_total <= 71;

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

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;

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

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 = 1 LIMIT 1;

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

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;

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

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;

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

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 >= 4416600 AND l0_.price <= 6556500 AND l0_.area_total >= 43 AND l0_.area_total <= 71 ORDER BY l0_.price ASC LIMIT 7;

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

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 = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.ui_type AS ui_type_2
FROM
  advantage_settings t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ui_type AS ui_type_2 FROM advantage_settings t0 WHERE t0.id = 1 LIMIT 1;

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

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;

SELECT
  t0.id AS id_1,
  t0.payment_name AS payment_name_2,
  t0.payment_text AS payment_text_3
FROM
  payment t0

SELECT t0.id AS id_1, t0.payment_name AS payment_name_2, t0.payment_text AS payment_text_3 FROM payment t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  construction_progress_album t0

SELECT t0.id AS id_1, t0.name AS name_2 FROM construction_progress_album t0;