Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.language AS language_6,
  t0.password_hash AS password_hash_7,
  t0.auth_key AS auth_key_8,
  t0.confirmed_at AS confirmed_at_9,
  t0.unconfirmed_email AS unconfirmed_email_10,
  t0.blocked_at AS blocked_at_11,
  t0.registration_ip AS registration_ip_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.flags AS flags_15,
  t0.last_login_at AS last_login_at_16,
  t0.icon_uri_id AS icon_uri_id_17,
  t0.role_id AS role_id_18
FROM
  user t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.language AS language_6, t0.password_hash AS password_hash_7, t0.auth_key AS auth_key_8, t0.confirmed_at AS confirmed_at_9, t0.unconfirmed_email AS unconfirmed_email_10, t0.blocked_at AS blocked_at_11, t0.registration_ip AS registration_ip_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.flags AS flags_15, t0.last_login_at AS last_login_at_16, t0.icon_uri_id AS icon_uri_id_17, t0.role_id AS role_id_18 FROM user t0 WHERE t0.email = 'a.tyazhkorob@poetica.com.ua' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  user_roles t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM user_roles t0 WHERE t0.id = 4;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.id AS id_1
FROM
  placement p0_
  INNER JOIN complex c1_ ON p0_.complex_id = c1_.id
  INNER JOIN user_complex_permission u3_ ON c1_.id = u3_.complex_id
  INNER JOIN user u2_ ON u2_.id = u3_.user_id
WHERE
  u2_.id = ?
ORDER BY
  p0_.id ASC
LIMIT
  120

SELECT DISTINCT p0_.id AS id_0, p0_.id AS id_1 FROM placement p0_ INNER JOIN complex c1_ ON p0_.complex_id = c1_.id INNER JOIN user_complex_permission u3_ ON c1_.id = u3_.complex_id INNER JOIN user u2_ ON u2_.id = u3_.user_id WHERE u2_.id = 192 ORDER BY p0_.id ASC LIMIT 120;

SELECT
  p0_.id AS id_0,
  p0_.status_update_time AS status_update_time_1,
  p0_.status_update_event_name AS status_update_event_name_2,
  p0_.amo_deals AS amo_deals_3,
  p0_.numeration AS numeration_4,
  p0_.rooms AS rooms_5,
  p0_.price_per_sq_m AS price_per_sq_m_6,
  p0_.one_es_id AS one_es_id_7,
  p0_.best_spinner_stops AS best_spinner_stops_8,
  p0_.urls AS urls_9,
  p0_.bedrooms AS bedrooms_10,
  p0_.bathrooms AS bathrooms_11,
  p0_.living_area AS living_area_12,
  p0_.balcony_area AS balcony_area_13,
  p0_.total_area AS total_area_14,
  p0_.total_price AS total_price_15,
  p0_.total_price_alternative AS total_price_alternative_16,
  p0_.price_per_sq_m_alternative AS price_per_sq_m_alternative_17,
  p0_.note AS note_18,
  p0_.tag AS tag_19,
  p0_.row0 AS row0_20,
  p0_.row1 AS row1_21,
  p0_.row2 AS row2_22,
  p0_.row3 AS row3_23,
  p0_.row4 AS row4_24,
  p0_.row5 AS row5_25,
  p0_.row6 AS row6_26,
  p0_.row7 AS row7_27,
  p0_.row9 AS row9_28,
  p0_.row8 AS row8_29,
  p0_.planning_type AS planning_type_30,
  p0_.variation AS variation_31,
  p0_.is_sync_maxify AS is_sync_maxify_32,
  p0_.additional_condition AS additional_condition_33,
  p0_.sold_price AS sold_price_34,
  p0_.gallery_images_transform AS gallery_images_transform_35,
  p0_.drawed AS drawed_36,
  p0_.spinner AS spinner_37,
  p0_.spinner_svg AS spinner_svg_38,
  p0_.spinner_stops_props AS spinner_stops_props_39,
  p0_.spinner_mtime AS spinner_mtime_40,
  p0_.update_time AS update_time_41,
  p0_.status_id AS status_id_42,
  p0_.status_updated_by_user_id AS status_updated_by_user_id_43,
  p0_.house_id AS house_id_44,
  p0_.section_id AS section_id_45,
  p0_.type_id AS type_id_46,
  p0_.complex_id AS complex_id_47
FROM
  placement p0_
  INNER JOIN complex c1_ ON p0_.complex_id = c1_.id
  INNER JOIN user_complex_permission u3_ ON c1_.id = u3_.complex_id
  INNER JOIN user u2_ ON u2_.id = u3_.user_id
WHERE
  u2_.id = ?
  AND p0_.id IN (?)
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.status_update_time AS status_update_time_1, p0_.status_update_event_name AS status_update_event_name_2, p0_.amo_deals AS amo_deals_3, p0_.numeration AS numeration_4, p0_.rooms AS rooms_5, p0_.price_per_sq_m AS price_per_sq_m_6, p0_.one_es_id AS one_es_id_7, p0_.best_spinner_stops AS best_spinner_stops_8, p0_.urls AS urls_9, p0_.bedrooms AS bedrooms_10, p0_.bathrooms AS bathrooms_11, p0_.living_area AS living_area_12, p0_.balcony_area AS balcony_area_13, p0_.total_area AS total_area_14, p0_.total_price AS total_price_15, p0_.total_price_alternative AS total_price_alternative_16, p0_.price_per_sq_m_alternative AS price_per_sq_m_alternative_17, p0_.note AS note_18, p0_.tag AS tag_19, p0_.row0 AS row0_20, p0_.row1 AS row1_21, p0_.row2 AS row2_22, p0_.row3 AS row3_23, p0_.row4 AS row4_24, p0_.row5 AS row5_25, p0_.row6 AS row6_26, p0_.row7 AS row7_27, p0_.row9 AS row9_28, p0_.row8 AS row8_29, p0_.planning_type AS planning_type_30, p0_.variation AS variation_31, p0_.is_sync_maxify AS is_sync_maxify_32, p0_.additional_condition AS additional_condition_33, p0_.sold_price AS sold_price_34, p0_.gallery_images_transform AS gallery_images_transform_35, p0_.drawed AS drawed_36, p0_.spinner AS spinner_37, p0_.spinner_svg AS spinner_svg_38, p0_.spinner_stops_props AS spinner_stops_props_39, p0_.spinner_mtime AS spinner_mtime_40, p0_.update_time AS update_time_41, p0_.status_id AS status_id_42, p0_.status_updated_by_user_id AS status_updated_by_user_id_43, p0_.house_id AS house_id_44, p0_.section_id AS section_id_45, p0_.type_id AS type_id_46, p0_.complex_id AS complex_id_47 FROM placement p0_ INNER JOIN complex c1_ ON p0_.complex_id = c1_.id INNER JOIN user_complex_permission u3_ ON c1_.id = u3_.complex_id INNER JOIN user u2_ ON u2_.id = u3_.user_id WHERE u2_.id = 192 AND p0_.id IN (4713, 4714, 4715, 4716, 4717, 4718, 4719, 4720, 4721, 4722, 4723, 4724, 4725, 4726, 4727, 4728, 4729, 4730, 4731, 4732, 4733, 4734, 4735, 4736, 4737, 4738, 4739, 4740, 4741, 4742, 4743, 4744, 4745, 4746, 4747, 4748, 4749, 4750, 4751, 4752, 4753, 4754, 4755, 4756, 4757, 4758, 4759, 4760, 4761, 4762, 4763, 4764, 4765, 4766, 4767, 4768, 4769, 4770, 4771, 4772, 4773, 4774, 4775, 4776, 4777, 4778, 4779, 4780, 4781, 4782, 4783, 4784, 4785, 4786, 4787, 4788, 4789, 4790, 4791, 4792, 4793, 4794, 4795, 4796, 4797, 4798, 4799, 4800, 4801, 4802, 4803, 4804, 4805, 4806, 4807, 4808, 4809, 4810, 4811, 4812, 4813, 4814, 4815, 4816, 4817, 4818, 4819, 4820, 4821, 4822, 4823, 4824, 4825, 4826, 4827, 4828, 4829, 4830, 4831, 4832) ORDER BY p0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.module_name AS module_name_3,
  t0.crosstable_name AS crosstable_name_4,
  t0.color AS color_5,
  t0.show_in_module AS show_in_module_6,
  t0.can_be_set AS can_be_set_7,
  t0.can_be_changed AS can_be_changed_8,
  t0.temporary_type AS temporary_type_9,
  t0.update_time_interval AS update_time_interval_10,
  t0.amo_can_be_set_for_deal AS amo_can_be_set_for_deal_11,
  t0.amo_status_on_zero_deals AS amo_status_on_zero_deals_12,
  t0.amo_only_one_deal_placement AS amo_only_one_deal_placement_13,
  t0.amo_deal_status_priority AS amo_deal_status_priority_14,
  t0.crosstable_color AS crosstable_color_15,
  t0.amo_unlink_deals_of_status_with_lower_priority AS amo_unlink_deals_of_status_with_lower_priority_16,
  t0.amo_unlink_deals_of_status_with_higher_priority AS amo_unlink_deals_of_status_with_higher_priority_17,
  t0.maxify_status AS maxify_status_18,
  t0.is_sold AS is_sold_19,
  t0.lun_status AS lun_status_20,
  t0.complex_id AS complex_id_21,
  t0.created_by_id AS created_by_id_22,
  t0.updated_by AS updated_by_23,
  t24.id AS id_25,
  t24.complex_id AS complex_id_26,
  t24.placement_status_id AS placement_status_id_27
FROM
  placement_status t0
  LEFT JOIN net_hunt_on_empty_opportunities_placement_status t24 ON t24.placement_status_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.module_name AS module_name_3, t0.crosstable_name AS crosstable_name_4, t0.color AS color_5, t0.show_in_module AS show_in_module_6, t0.can_be_set AS can_be_set_7, t0.can_be_changed AS can_be_changed_8, t0.temporary_type AS temporary_type_9, t0.update_time_interval AS update_time_interval_10, t0.amo_can_be_set_for_deal AS amo_can_be_set_for_deal_11, t0.amo_status_on_zero_deals AS amo_status_on_zero_deals_12, t0.amo_only_one_deal_placement AS amo_only_one_deal_placement_13, t0.amo_deal_status_priority AS amo_deal_status_priority_14, t0.crosstable_color AS crosstable_color_15, t0.amo_unlink_deals_of_status_with_lower_priority AS amo_unlink_deals_of_status_with_lower_priority_16, t0.amo_unlink_deals_of_status_with_higher_priority AS amo_unlink_deals_of_status_with_higher_priority_17, t0.maxify_status AS maxify_status_18, t0.is_sold AS is_sold_19, t0.lun_status AS lun_status_20, t0.complex_id AS complex_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by AS updated_by_23, t24.id AS id_25, t24.complex_id AS complex_id_26, t24.placement_status_id AS placement_status_id_27 FROM placement_status t0 LEFT JOIN net_hunt_on_empty_opportunities_placement_status t24 ON t24.placement_status_id = t0.id WHERE t0.id = 27;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.username AS username_5,
  t0.language AS language_6,
  t0.password_hash AS password_hash_7,
  t0.auth_key AS auth_key_8,
  t0.confirmed_at AS confirmed_at_9,
  t0.unconfirmed_email AS unconfirmed_email_10,
  t0.blocked_at AS blocked_at_11,
  t0.registration_ip AS registration_ip_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.flags AS flags_15,
  t0.last_login_at AS last_login_at_16,
  t0.icon_uri_id AS icon_uri_id_17,
  t0.role_id AS role_id_18
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.username AS username_5, t0.language AS language_6, t0.password_hash AS password_hash_7, t0.auth_key AS auth_key_8, t0.confirmed_at AS confirmed_at_9, t0.unconfirmed_email AS unconfirmed_email_10, t0.blocked_at AS blocked_at_11, t0.registration_ip AS registration_ip_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.flags AS flags_15, t0.last_login_at AS last_login_at_16, t0.icon_uri_id AS icon_uri_id_17, t0.role_id AS role_id_18 FROM user t0 WHERE t0.id = 133;

SELECT
  t0.id AS id_1,
  t0.uri AS uri_2,
  t0.usage_count AS usage_count_3
FROM
  uri_manager t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uri AS uri_2, t0.usage_count AS usage_count_3 FROM uri_manager t0 WHERE t0.id = 116;

SELECT
  t0.id AS id_1,
  t0.numeration AS numeration_2,
  t0.crosstable_sequence AS crosstable_sequence_3,
  t0.maxify_house_id AS maxify_house_id_4,
  t0.description AS description_5,
  t0.queue AS queue_6,
  t0.spinner AS spinner_7,
  t0.spinner_svg AS spinner_svg_8,
  t0.spinner_stops_props AS spinner_stops_props_9,
  t0.spinner_mtime AS spinner_mtime_10,
  t0.spinner_alt AS spinner_alt_11,
  t0.spinner_svg_alt AS spinner_svg_alt_12,
  t0.spinner_stops_props_alt AS spinner_stops_props_alt_13,
  t0.spinner_mtime_alt AS spinner_mtime_alt_14,
  t0.full_floor AS full_floor_15,
  t0.markup_img_url AS markup_img_url_16,
  t0.markup_svg_data AS markup_svg_data_17,
  t0.best_spinner_stops AS best_spinner_stops_18,
  t0.entity_options AS entity_options_19,
  t0.spinner3d AS spinner3d_20,
  t0.map_transform AS map_transform_21,
  t0.complex_id AS complex_id_22
FROM
  house t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numeration AS numeration_2, t0.crosstable_sequence AS crosstable_sequence_3, t0.maxify_house_id AS maxify_house_id_4, t0.description AS description_5, t0.queue AS queue_6, t0.spinner AS spinner_7, t0.spinner_svg AS spinner_svg_8, t0.spinner_stops_props AS spinner_stops_props_9, t0.spinner_mtime AS spinner_mtime_10, t0.spinner_alt AS spinner_alt_11, t0.spinner_svg_alt AS spinner_svg_alt_12, t0.spinner_stops_props_alt AS spinner_stops_props_alt_13, t0.spinner_mtime_alt AS spinner_mtime_alt_14, t0.full_floor AS full_floor_15, t0.markup_img_url AS markup_img_url_16, t0.markup_svg_data AS markup_svg_data_17, t0.best_spinner_stops AS best_spinner_stops_18, t0.entity_options AS entity_options_19, t0.spinner3d AS spinner3d_20, t0.map_transform AS map_transform_21, t0.complex_id AS complex_id_22 FROM house t0 WHERE t0.id = 28;

SELECT
  t0.id AS id_1,
  t0.numeration AS numeration_2,
  t0.crosstable_sequence AS crosstable_sequence_3,
  t0.queue AS queue_4,
  t0.spinner AS spinner_5,
  t0.spinner_svg AS spinner_svg_6,
  t0.spinner_stops_props AS spinner_stops_props_7,
  t0.spinner_mtime AS spinner_mtime_8,
  t0.spinner_alt AS spinner_alt_9,
  t0.spinner_svg_alt AS spinner_svg_alt_10,
  t0.spinner_stops_props_alt AS spinner_stops_props_alt_11,
  t0.spinner_mtime_alt AS spinner_mtime_alt_12,
  t0.best_spinner_stops AS best_spinner_stops_13,
  t0.entity_options AS entity_options_14,
  t0.spinner3d AS spinner3d_15,
  t0.complex_id AS complex_id_16,
  t0.house_id AS house_id_17
FROM
  section t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.numeration AS numeration_2, t0.crosstable_sequence AS crosstable_sequence_3, t0.queue AS queue_4, t0.spinner AS spinner_5, t0.spinner_svg AS spinner_svg_6, t0.spinner_stops_props AS spinner_stops_props_7, t0.spinner_mtime AS spinner_mtime_8, t0.spinner_alt AS spinner_alt_9, t0.spinner_svg_alt AS spinner_svg_alt_10, t0.spinner_stops_props_alt AS spinner_stops_props_alt_11, t0.spinner_mtime_alt AS spinner_mtime_alt_12, t0.best_spinner_stops AS best_spinner_stops_13, t0.entity_options AS entity_options_14, t0.spinner3d AS spinner3d_15, t0.complex_id AS complex_id_16, t0.house_id AS house_id_17 FROM section t0 WHERE t0.id = 108;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.module_view_types_sort_order AS module_view_types_sort_order_3,
  t0.crosstable_view_types_sort_order AS crosstable_view_types_sort_order_4,
  t0.is_show_in_module AS is_show_in_module_5,
  t0.is_show_in_crosstable AS is_show_in_crosstable_6,
  t0.filter_config AS filter_config_7,
  t0.filter_info_config AS filter_info_config_8,
  t0.pop_up_info_config AS pop_up_info_config_9,
  t0.placement_info_config AS placement_info_config_10,
  t0.placement_grouped_tile_config AS placement_grouped_tile_config_11,
  t0.placement_grouped_info_config AS placement_grouped_info_config_12,
  t0.hover_pop_up_short_info AS hover_pop_up_short_info_13,
  t0.crosstable_filter_info_config AS crosstable_filter_info_config_14,
  t0.crosstable_pop_up_info_config AS crosstable_pop_up_info_config_15,
  t0.crosstable_placement_info_config AS crosstable_placement_info_config_16,
  t0.crosstable_placement_grouped_tile_config AS crosstable_placement_grouped_tile_config_17,
  t0.crosstable_placement_grouped_info_config AS crosstable_placement_grouped_info_config_18,
  t0.crosstable_hover_pop_up_short_info AS crosstable_hover_pop_up_short_info_19,
  t0.crosstable_filter_config AS crosstable_filter_config_20,
  t0.group_by AS group_by_21,
  t0.sequence AS sequence_22,
  t0.complex_id AS complex_id_23,
  t0.front_config_id AS front_config_id_24
FROM
  placement_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.module_view_types_sort_order AS module_view_types_sort_order_3, t0.crosstable_view_types_sort_order AS crosstable_view_types_sort_order_4, t0.is_show_in_module AS is_show_in_module_5, t0.is_show_in_crosstable AS is_show_in_crosstable_6, t0.filter_config AS filter_config_7, t0.filter_info_config AS filter_info_config_8, t0.pop_up_info_config AS pop_up_info_config_9, t0.placement_info_config AS placement_info_config_10, t0.placement_grouped_tile_config AS placement_grouped_tile_config_11, t0.placement_grouped_info_config AS placement_grouped_info_config_12, t0.hover_pop_up_short_info AS hover_pop_up_short_info_13, t0.crosstable_filter_info_config AS crosstable_filter_info_config_14, t0.crosstable_pop_up_info_config AS crosstable_pop_up_info_config_15, t0.crosstable_placement_info_config AS crosstable_placement_info_config_16, t0.crosstable_placement_grouped_tile_config AS crosstable_placement_grouped_tile_config_17, t0.crosstable_placement_grouped_info_config AS crosstable_placement_grouped_info_config_18, t0.crosstable_hover_pop_up_short_info AS crosstable_hover_pop_up_short_info_19, t0.crosstable_filter_config AS crosstable_filter_config_20, t0.group_by AS group_by_21, t0.sequence AS sequence_22, t0.complex_id AS complex_id_23, t0.front_config_id AS front_config_id_24 FROM placement_type t0 WHERE t0.id = 22;

SELECT
  t0.id AS id_1,
  t0.language AS language_2,
  t0.title AS title_3,
  t0.show_in_crosstable AS show_in_crosstable_4,
  t0.currency AS currency_5,
  t0.secondary_languages AS secondary_languages_6,
  t0.address AS address_7,
  t0.complex_short_name AS complex_short_name_8,
  t0.module_language AS module_language_9,
  t0.crosstable_language AS crosstable_language_10,
  t0.module_secondary_languages AS module_secondary_languages_11,
  t0.crosstable_secondary_languages AS crosstable_secondary_languages_12,
  t0.spinner AS spinner_13,
  t0.spinner_svg AS spinner_svg_14,
  t0.spinner_stops_props AS spinner_stops_props_15,
  t0.spinner_mtime AS spinner_mtime_16,
  t0.spinner_alt AS spinner_alt_17,
  t0.spinner_svg_alt AS spinner_svg_alt_18,
  t0.spinner_stops_props_alt AS spinner_stops_props_alt_19,
  t0.spinner_mtime_alt AS spinner_mtime_alt_20,
  t0.entity_options AS entity_options_21,
  t0.spinner3d AS spinner3d_22,
  t0.markup_img_url AS markup_img_url_23,
  t0.markup_svg_data AS markup_svg_data_24,
  t0.map_first_floor_level AS map_first_floor_level_25,
  t0.preview_uri_id AS preview_uri_id_26,
  t0.logo_uri_id AS logo_uri_id_27,
  t28.id AS id_29,
  t28.maxify_login_key AS maxify_login_key_30,
  t28.maxify_password_secret AS maxify_password_secret_31,
  t28.primary_color AS primary_color_32,
  t28.module_short_name AS module_short_name_33,
  t28.primary_color_light AS primary_color_light_34,
  t28.placeholder_color AS placeholder_color_35,
  t28.grey_color AS grey_color_36,
  t28.text_color AS text_color_37,
  t28.container_color AS container_color_38,
  t28.placement_gallery_complex_spinner_position AS placement_gallery_complex_spinner_position_39,
  t28.placement_gallery_house_spinner_position AS placement_gallery_house_spinner_position_40,
  t28.placement_gallery_section_spinner_position AS placement_gallery_section_spinner_position_41,
  t28.placement_gallery_floor_spinner_position AS placement_gallery_floor_spinner_position_42,
  t28.placement_gallery_placement_spinner_position AS placement_gallery_placement_spinner_position_43,
  t28.placement_gallery_complex_spinner_preview_url AS placement_gallery_complex_spinner_preview_url_44,
  t28.placement_gallery_house_spinner_preview_url AS placement_gallery_house_spinner_preview_url_45,
  t28.placement_gallery_section_spinner_preview_url AS placement_gallery_section_spinner_preview_url_46,
  t28.placement_gallery_floor_spinner_preview_url AS placement_gallery_floor_spinner_preview_url_47,
  t28.placement_gallery_placement_spinner_preview_url AS placement_gallery_placement_spinner_preview_url_48,
  t28.placement_gallery_playcanvas_preview_url AS placement_gallery_playcanvas_preview_url_49,
  t28.placement_gallery_complex_panorama_position AS placement_gallery_complex_panorama_position_50,
  t28.placement_gallery_house_panorama_position AS placement_gallery_house_panorama_position_51,
  t28.placement_gallery_section_panorama_position AS placement_gallery_section_panorama_position_52,
  t28.placement_gallery_floor_panorama_position AS placement_gallery_floor_panorama_position_53,
  t28.placement_gallery_placement_panorama_position AS placement_gallery_placement_panorama_position_54,
  t28.placement_gallery_complex_panorama_preview_url AS placement_gallery_complex_panorama_preview_url_55,
  t28.placement_gallery_house_panorama_preview_url AS placement_gallery_house_panorama_preview_url_56,
  t28.placement_gallery_section_panorama_preview_url AS placement_gallery_section_panorama_preview_url_57,
  t28.placement_gallery_floor_panorama_preview_url AS placement_gallery_floor_panorama_preview_url_58,
  t28.placement_gallery_placement_panorama_preview_url AS placement_gallery_placement_panorama_preview_url_59,
  t28.filter_favorites AS filter_favorites_60,
  t28.filter_call AS filter_call_61,
  t28.filter_menu AS filter_menu_62,
  t28.filter_share AS filter_share_63,
  t28.mode_spinner AS mode_spinner_64,
  t28.mode_layout AS mode_layout_65,
  t28.mode_floors AS mode_floors_66,
  t28.mode_panorama AS mode_panorama_67,
  t28.mode_map AS mode_map_68,
  t28.mode_crosstable AS mode_crosstable_69,
  t28.placement_request_call AS placement_request_call_70,
  t28.placement_floor_placing AS placement_floor_placing_71,
  t28.placement_section_markup_placing AS placement_section_markup_placing_72,
  t28.infrastructure_button AS infrastructure_button_73,
  t28.infrastructure_active AS infrastructure_active_74,
  t28.infrastructure_show_header_in_hover_popup AS infrastructure_show_header_in_hover_popup_75,
  t28.start_view_full_screen AS start_view_full_screen_76,
  t28.show_spinners_rotation_buttons_desktop AS show_spinners_rotation_buttons_desktop_77,
  t28.show_spinners_zoom_button_desktop AS show_spinners_zoom_button_desktop_78,
  t28.show_placement_gallery_spinners_rotation_buttons_desktop AS show_placement_gallery_spinners_rotation_buttons_desktop_79,
  t28.show_placement_gallery_spinners_zoom_button_desktop AS show_placement_gallery_spinners_zoom_button_desktop_80,
  t28.show_spinners_rotation_buttons_mobile AS show_spinners_rotation_buttons_mobile_81,
  t28.show_spinners_zoom_button_mobile AS show_spinners_zoom_button_mobile_82,
  t28.show_placement_gallery_spinners_rotation_buttons_mobile AS show_placement_gallery_spinners_rotation_buttons_mobile_83,
  t28.show_placement_gallery_spinners_zoom_button_mobile AS show_placement_gallery_spinners_zoom_button_mobile_84,
  t28.favicon_url AS favicon_url_85,
  t28.ringo AS ringo_86,
  t28.fullscreen_pano AS fullscreen_pano_87,
  t28.complex_spinner_disable_filter AS complex_spinner_disable_filter_88,
  t28.house_spinner_disable_filter AS house_spinner_disable_filter_89,
  t28.section_spinner_disable_filter AS section_spinner_disable_filter_90,
  t28.floor_spinner_disable_filter AS floor_spinner_disable_filter_91,
  t28.tile_img_parent_padding AS tile_img_parent_padding_92,
  t28.enable_hover_pop_up_short_info AS enable_hover_pop_up_short_info_93,
  t28.show_client_logo AS show_client_logo_94,
  t28.show_prefilter_placement_type_selector AS show_prefilter_placement_type_selector_95,
  t28.enable_hover_text_polygon_light_up AS enable_hover_text_polygon_light_up_96,
  t28.show_filter_counter AS show_filter_counter_97,
  t28.google_id AS google_id_98,
  t28.root_url AS root_url_99,
  t28.preloader_color AS preloader_color_100,
  t28.filter_background_color AS filter_background_color_101,
  t28.show_flat_show_logo AS show_flat_show_logo_102,
  t28.enable_polygon_status_colors AS enable_polygon_status_colors_103,
  t28.ringo_class_name AS ringo_class_name_104,
  t28.section_markup_show_section_numeration AS section_markup_show_section_numeration_105,
  t28.section_markup_show_house_numeration AS section_markup_show_house_numeration_106,
  t28.is_show_prices_in_module AS is_show_prices_in_module_107,
  t28.form_default_country AS form_default_country_108,
  t28.is_pre_highlight_polygons_in_module AS is_pre_highlight_polygons_in_module_109,
  t28.complex_id AS complex_id_110,
  t111.id AS id_112,
  t111.black AS black_113,
  t111.white AS white_114,
  t111.colored AS colored_115,
  t111.use_it AS use_it_116,
  t111.black_mobile AS black_mobile_117,
  t111.white_mobile AS white_mobile_118,
  t111.colored_mobile AS colored_mobile_119,
  t111.use_it_mobile AS use_it_mobile_120,
  t111.complex_id AS complex_id_121,
  t0.creator_user_id AS creator_user_id_122,
  t123.id AS id_124,
  t123.static_body_color AS static_body_color_125,
  t123.static_body_opacity AS static_body_opacity_126,
  t123.static_border_color AS static_border_color_127,
  t123.hover_body_color AS hover_body_color_128,
  t123.hover_body_opacity AS hover_body_opacity_129,
  t123.hover_border_color AS hover_border_color_130,
  t123.clicked_body_color AS clicked_body_color_131,
  t123.clicked_body_opacity AS clicked_body_opacity_132,
  t123.clicked_border_color AS clicked_border_color_133,
  t123.global_border_width AS global_border_width_134,
  t123.trigger_event AS trigger_event_135,
  t123.is_pre_highlight_polygons_in_module AS is_pre_highlight_polygons_in_module_136,
  t123.complex_id AS complex_id_137,
  t138.id AS id_139,
  t138.class AS class_140,
  t138.el_id AS el_id_141,
  t138.event AS event_142,
  t138.use_for_module AS use_for_module_143,
  t138.complex_id AS complex_id_144,
  t145.id AS id_146,
  t145.group_buttons_style AS group_buttons_style_147,
  t145.logo_uri AS logo_uri_148,
  t145.complex_id AS complex_id_149,
  t150.id AS id_151,
  t150.complex_id AS complex_id_152,
  t150.placement_status_id AS placement_status_id_153,
  t0.front_config_id AS front_config_id_154
FROM
  complex t0
  LEFT JOIN client_module_config t28 ON t28.complex_id = t0.id
  LEFT JOIN client_module_logos t111 ON t111.complex_id = t0.id
  LEFT JOIN polygon_global_config t123 ON t123.complex_id = t0.id
  LEFT JOIN client_module_by_attributes_contact_form t138 ON t138.complex_id = t0.id
  LEFT JOIN client_module_panorama_config t145 ON t145.complex_id = t0.id
  LEFT JOIN net_hunt_on_empty_opportunities_placement_status t150 ON t150.complex_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.language AS language_2, t0.title AS title_3, t0.show_in_crosstable AS show_in_crosstable_4, t0.currency AS currency_5, t0.secondary_languages AS secondary_languages_6, t0.address AS address_7, t0.complex_short_name AS complex_short_name_8, t0.module_language AS module_language_9, t0.crosstable_language AS crosstable_language_10, t0.module_secondary_languages AS module_secondary_languages_11, t0.crosstable_secondary_languages AS crosstable_secondary_languages_12, t0.spinner AS spinner_13, t0.spinner_svg AS spinner_svg_14, t0.spinner_stops_props AS spinner_stops_props_15, t0.spinner_mtime AS spinner_mtime_16, t0.spinner_alt AS spinner_alt_17, t0.spinner_svg_alt AS spinner_svg_alt_18, t0.spinner_stops_props_alt AS spinner_stops_props_alt_19, t0.spinner_mtime_alt AS spinner_mtime_alt_20, t0.entity_options AS entity_options_21, t0.spinner3d AS spinner3d_22, t0.markup_img_url AS markup_img_url_23, t0.markup_svg_data AS markup_svg_data_24, t0.map_first_floor_level AS map_first_floor_level_25, t0.preview_uri_id AS preview_uri_id_26, t0.logo_uri_id AS logo_uri_id_27, t28.id AS id_29, t28.maxify_login_key AS maxify_login_key_30, t28.maxify_password_secret AS maxify_password_secret_31, t28.primary_color AS primary_color_32, t28.module_short_name AS module_short_name_33, t28.primary_color_light AS primary_color_light_34, t28.placeholder_color AS placeholder_color_35, t28.grey_color AS grey_color_36, t28.text_color AS text_color_37, t28.container_color AS container_color_38, t28.placement_gallery_complex_spinner_position AS placement_gallery_complex_spinner_position_39, t28.placement_gallery_house_spinner_position AS placement_gallery_house_spinner_position_40, t28.placement_gallery_section_spinner_position AS placement_gallery_section_spinner_position_41, t28.placement_gallery_floor_spinner_position AS placement_gallery_floor_spinner_position_42, t28.placement_gallery_placement_spinner_position AS placement_gallery_placement_spinner_position_43, t28.placement_gallery_complex_spinner_preview_url AS placement_gallery_complex_spinner_preview_url_44, t28.placement_gallery_house_spinner_preview_url AS placement_gallery_house_spinner_preview_url_45, t28.placement_gallery_section_spinner_preview_url AS placement_gallery_section_spinner_preview_url_46, t28.placement_gallery_floor_spinner_preview_url AS placement_gallery_floor_spinner_preview_url_47, t28.placement_gallery_placement_spinner_preview_url AS placement_gallery_placement_spinner_preview_url_48, t28.placement_gallery_playcanvas_preview_url AS placement_gallery_playcanvas_preview_url_49, t28.placement_gallery_complex_panorama_position AS placement_gallery_complex_panorama_position_50, t28.placement_gallery_house_panorama_position AS placement_gallery_house_panorama_position_51, t28.placement_gallery_section_panorama_position AS placement_gallery_section_panorama_position_52, t28.placement_gallery_floor_panorama_position AS placement_gallery_floor_panorama_position_53, t28.placement_gallery_placement_panorama_position AS placement_gallery_placement_panorama_position_54, t28.placement_gallery_complex_panorama_preview_url AS placement_gallery_complex_panorama_preview_url_55, t28.placement_gallery_house_panorama_preview_url AS placement_gallery_house_panorama_preview_url_56, t28.placement_gallery_section_panorama_preview_url AS placement_gallery_section_panorama_preview_url_57, t28.placement_gallery_floor_panorama_preview_url AS placement_gallery_floor_panorama_preview_url_58, t28.placement_gallery_placement_panorama_preview_url AS placement_gallery_placement_panorama_preview_url_59, t28.filter_favorites AS filter_favorites_60, t28.filter_call AS filter_call_61, t28.filter_menu AS filter_menu_62, t28.filter_share AS filter_share_63, t28.mode_spinner AS mode_spinner_64, t28.mode_layout AS mode_layout_65, t28.mode_floors AS mode_floors_66, t28.mode_panorama AS mode_panorama_67, t28.mode_map AS mode_map_68, t28.mode_crosstable AS mode_crosstable_69, t28.placement_request_call AS placement_request_call_70, t28.placement_floor_placing AS placement_floor_placing_71, t28.placement_section_markup_placing AS placement_section_markup_placing_72, t28.infrastructure_button AS infrastructure_button_73, t28.infrastructure_active AS infrastructure_active_74, t28.infrastructure_show_header_in_hover_popup AS infrastructure_show_header_in_hover_popup_75, t28.start_view_full_screen AS start_view_full_screen_76, t28.show_spinners_rotation_buttons_desktop AS show_spinners_rotation_buttons_desktop_77, t28.show_spinners_zoom_button_desktop AS show_spinners_zoom_button_desktop_78, t28.show_placement_gallery_spinners_rotation_buttons_desktop AS show_placement_gallery_spinners_rotation_buttons_desktop_79, t28.show_placement_gallery_spinners_zoom_button_desktop AS show_placement_gallery_spinners_zoom_button_desktop_80, t28.show_spinners_rotation_buttons_mobile AS show_spinners_rotation_buttons_mobile_81, t28.show_spinners_zoom_button_mobile AS show_spinners_zoom_button_mobile_82, t28.show_placement_gallery_spinners_rotation_buttons_mobile AS show_placement_gallery_spinners_rotation_buttons_mobile_83, t28.show_placement_gallery_spinners_zoom_button_mobile AS show_placement_gallery_spinners_zoom_button_mobile_84, t28.favicon_url AS favicon_url_85, t28.ringo AS ringo_86, t28.fullscreen_pano AS fullscreen_pano_87, t28.complex_spinner_disable_filter AS complex_spinner_disable_filter_88, t28.house_spinner_disable_filter AS house_spinner_disable_filter_89, t28.section_spinner_disable_filter AS section_spinner_disable_filter_90, t28.floor_spinner_disable_filter AS floor_spinner_disable_filter_91, t28.tile_img_parent_padding AS tile_img_parent_padding_92, t28.enable_hover_pop_up_short_info AS enable_hover_pop_up_short_info_93, t28.show_client_logo AS show_client_logo_94, t28.show_prefilter_placement_type_selector AS show_prefilter_placement_type_selector_95, t28.enable_hover_text_polygon_light_up AS enable_hover_text_polygon_light_up_96, t28.show_filter_counter AS show_filter_counter_97, t28.google_id AS google_id_98, t28.root_url AS root_url_99, t28.preloader_color AS preloader_color_100, t28.filter_background_color AS filter_background_color_101, t28.show_flat_show_logo AS show_flat_show_logo_102, t28.enable_polygon_status_colors AS enable_polygon_status_colors_103, t28.ringo_class_name AS ringo_class_name_104, t28.section_markup_show_section_numeration AS section_markup_show_section_numeration_105, t28.section_markup_show_house_numeration AS section_markup_show_house_numeration_106, t28.is_show_prices_in_module AS is_show_prices_in_module_107, t28.form_default_country AS form_default_country_108, t28.is_pre_highlight_polygons_in_module AS is_pre_highlight_polygons_in_module_109, t28.complex_id AS complex_id_110, t111.id AS id_112, t111.black AS black_113, t111.white AS white_114, t111.colored AS colored_115, t111.use_it AS use_it_116, t111.black_mobile AS black_mobile_117, t111.white_mobile AS white_mobile_118, t111.colored_mobile AS colored_mobile_119, t111.use_it_mobile AS use_it_mobile_120, t111.complex_id AS complex_id_121, t0.creator_user_id AS creator_user_id_122, t123.id AS id_124, t123.static_body_color AS static_body_color_125, t123.static_body_opacity AS static_body_opacity_126, t123.static_border_color AS static_border_color_127, t123.hover_body_color AS hover_body_color_128, t123.hover_body_opacity AS hover_body_opacity_129, t123.hover_border_color AS hover_border_color_130, t123.clicked_body_color AS clicked_body_color_131, t123.clicked_body_opacity AS clicked_body_opacity_132, t123.clicked_border_color AS clicked_border_color_133, t123.global_border_width AS global_border_width_134, t123.trigger_event AS trigger_event_135, t123.is_pre_highlight_polygons_in_module AS is_pre_highlight_polygons_in_module_136, t123.complex_id AS complex_id_137, t138.id AS id_139, t138.class AS class_140, t138.el_id AS el_id_141, t138.event AS event_142, t138.use_for_module AS use_for_module_143, t138.complex_id AS complex_id_144, t145.id AS id_146, t145.group_buttons_style AS group_buttons_style_147, t145.logo_uri AS logo_uri_148, t145.complex_id AS complex_id_149, t150.id AS id_151, t150.complex_id AS complex_id_152, t150.placement_status_id AS placement_status_id_153, t0.front_config_id AS front_config_id_154 FROM complex t0 LEFT JOIN client_module_config t28 ON t28.complex_id = t0.id LEFT JOIN client_module_logos t111 ON t111.complex_id = t0.id LEFT JOIN polygon_global_config t123 ON t123.complex_id = t0.id LEFT JOIN client_module_by_attributes_contact_form t138 ON t138.complex_id = t0.id LEFT JOIN client_module_panorama_config t145 ON t145.complex_id = t0.id LEFT JOIN net_hunt_on_empty_opportunities_placement_status t150 ON t150.complex_id = t0.id WHERE t0.id = 19;

SELECT
  t0.id AS id_1,
  t0.numeration AS numeration_2,
  t0.spinner AS spinner_3,
  t0.spinner_svg AS spinner_svg_4,
  t0.spinner_stops_props AS spinner_stops_props_5,
  t0.spinner_mtime AS spinner_mtime_6,
  t0.best_spinner_stops AS best_spinner_stops_7,
  t0.entity_options AS entity_options_8,
  t0.complex_id AS complex_id_9,
  t0.section_id AS section_id_10,
  t0.house_id AS house_id_11
FROM
  floor t0
  INNER JOIN placement_floor_mtm ON t0.id = placement_floor_mtm.floor_id
WHERE
  placement_floor_mtm.placement_id = ?

SELECT t0.id AS id_1, t0.numeration AS numeration_2, t0.spinner AS spinner_3, t0.spinner_svg AS spinner_svg_4, t0.spinner_stops_props AS spinner_stops_props_5, t0.spinner_mtime AS spinner_mtime_6, t0.best_spinner_stops AS best_spinner_stops_7, t0.entity_options AS entity_options_8, t0.complex_id AS complex_id_9, t0.section_id AS section_id_10, t0.house_id AS house_id_11 FROM floor t0 INNER JOIN placement_floor_mtm ON t0.id = placement_floor_mtm.floor_id WHERE placement_floor_mtm.placement_id = 4713;

SELECT
  t0.id AS id_1,
  t0.bitrix_external_deal_id AS bitrix_external_deal_id_2,
  t0.bitrix_external_stage_id AS bitrix_external_stage_id_3,
  t0.opportunity_price AS opportunity_price_4,
  t0.bitrix_deal_client_id AS bitrix_deal_client_id_5,
  t0.responsible_user_id AS responsible_user_id_6,
  t0.placement_id AS placement_id_7,
  t0.bitrix_stage_id AS bitrix_stage_id_8,
  t0.bitrix_project_id AS bitrix_project_id_9
FROM
  bitrix_deal t0
WHERE
  t0.placement_id = ?

SELECT t0.id AS id_1, t0.bitrix_external_deal_id AS bitrix_external_deal_id_2, t0.bitrix_external_stage_id AS bitrix_external_stage_id_3, t0.opportunity_price AS opportunity_price_4, t0.bitrix_deal_client_id AS bitrix_deal_client_id_5, t0.responsible_user_id AS responsible_user_id_6, t0.placement_id AS placement_id_7, t0.bitrix_stage_id AS bitrix_stage_id_8, t0.bitrix_project_id AS bitrix_project_id_9 FROM bitrix_deal t0 WHERE t0.placement_id = 4713;