| 1 |
0.67 ms |
SELECT t0.id AS id_1, t0.source_path AS source_path_2, t0.target_url AS target_url_3, t0.status_code AS status_code_4, t0.hits_count AS hits_count_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM redirect_rules t0 WHERE t0.source_path = ? AND t0.is_active = ? LIMIT 1
Parameters: [
"/kompleksy"
1
]
SELECT t0.id AS id_1, t0.source_path AS source_path_2, t0.target_url AS target_url_3, t0.status_code AS status_code_4, t0.hits_count AS hits_count_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM redirect_rules t0 WHERE t0.source_path = '/kompleksy' AND t0.is_active = 1 LIMIT 1;
|
| 2 |
0.48 ms |
SELECT t0.id AS id_1, t0.page_key AS page_key_2, t0.created_at AS created_at_3 FROM seo_page_auto_exclusions t0
SELECT t0.id AS id_1, t0.page_key AS page_key_2, t0.created_at AS created_at_3 FROM seo_page_auto_exclusions t0;
|
| 3 |
1.42 ms |
SELECT s0_.id AS id_0, s0_.page_key AS page_key_1, s0_.slug AS slug_2, s0_.path AS path_3, s0_.title AS title_4, s0_.front_module AS front_module_5, s0_.content AS content_6, s0_.content_edit_mode AS content_edit_mode_7, s0_.cms_intro_headings AS cms_intro_headings_8, s0_.faq_content AS faq_content_9, s0_.custom_css AS custom_css_10, s0_.custom_js AS custom_js_11, s0_.is_published AS is_published_12, s0_.is_system AS is_system_13, s0_.hero_slides AS hero_slides_14, s0_.popup_enabled AS popup_enabled_15, s0_.popup_content AS popup_content_16, s0_.popup_position AS popup_position_17, s0_.popup_delay_seconds AS popup_delay_seconds_18, s0_.popup_starts_at AS popup_starts_at_19, s0_.popup_ends_at AS popup_ends_at_20, s0_.listing_default_arrival AS listing_default_arrival_21, s0_.listing_default_departure AS listing_default_departure_22, s0_.listing_offers_enabled AS listing_offers_enabled_23, s0_.listing_guests_min AS listing_guests_min_24, s0_.listing_path_suffix AS listing_path_suffix_25, s0_.special_offer_home_promoted AS special_offer_home_promoted_26, s0_.special_offer_home_sort_order AS special_offer_home_sort_order_27, s0_.special_offer_list_sort AS special_offer_list_sort_28, s0_.special_offer_tile_image AS special_offer_tile_image_29, s0_.special_offer_tile_variants AS special_offer_tile_variants_30, s0_.created_at AS created_at_31, s0_.updated_at AS updated_at_32, s0_.meta_title AS meta_title_33, s0_.meta_description AS meta_description_34, s0_.canonical_url AS canonical_url_35, s0_.robots AS robots_36, s0_.og_title AS og_title_37, s0_.og_description AS og_description_38, s0_.og_image AS og_image_39, s0_.listing_category_id AS listing_category_id_40, s0_.listing_location_id AS listing_location_id_41, s0_.listing_residence_id AS listing_residence_id_42 FROM seo_pages s0_ WHERE s0_.page_key LIKE ?
SELECT
s0_.id AS id_0,
s0_.page_key AS page_key_1,
s0_.slug AS slug_2,
s0_.path AS path_3,
s0_.title AS title_4,
s0_.front_module AS front_module_5,
s0_.content AS content_6,
s0_.content_edit_mode AS content_edit_mode_7,
s0_.cms_intro_headings AS cms_intro_headings_8,
s0_.faq_content AS faq_content_9,
s0_.custom_css AS custom_css_10,
s0_.custom_js AS custom_js_11,
s0_.is_published AS is_published_12,
s0_.is_system AS is_system_13,
s0_.hero_slides AS hero_slides_14,
s0_.popup_enabled AS popup_enabled_15,
s0_.popup_content AS popup_content_16,
s0_.popup_position AS popup_position_17,
s0_.popup_delay_seconds AS popup_delay_seconds_18,
s0_.popup_starts_at AS popup_starts_at_19,
s0_.popup_ends_at AS popup_ends_at_20,
s0_.listing_default_arrival AS listing_default_arrival_21,
s0_.listing_default_departure AS listing_default_departure_22,
s0_.listing_offers_enabled AS listing_offers_enabled_23,
s0_.listing_guests_min AS listing_guests_min_24,
s0_.listing_path_suffix AS listing_path_suffix_25,
s0_.special_offer_home_promoted AS special_offer_home_promoted_26,
s0_.special_offer_home_sort_order AS special_offer_home_sort_order_27,
s0_.special_offer_list_sort AS special_offer_list_sort_28,
s0_.special_offer_tile_image AS special_offer_tile_image_29,
s0_.special_offer_tile_variants AS special_offer_tile_variants_30,
s0_.created_at AS created_at_31,
s0_.updated_at AS updated_at_32,
s0_.meta_title AS meta_title_33,
s0_.meta_description AS meta_description_34,
s0_.canonical_url AS canonical_url_35,
s0_.robots AS robots_36,
s0_.og_title AS og_title_37,
s0_.og_description AS og_description_38,
s0_.og_image AS og_image_39,
s0_.listing_category_id AS listing_category_id_40,
s0_.listing_location_id AS listing_location_id_41,
s0_.listing_residence_id AS listing_residence_id_42
FROM
seo_pages s0_
WHERE
s0_.page_key LIKE ?
SELECT s0_.id AS id_0, s0_.page_key AS page_key_1, s0_.slug AS slug_2, s0_.path AS path_3, s0_.title AS title_4, s0_.front_module AS front_module_5, s0_.content AS content_6, s0_.content_edit_mode AS content_edit_mode_7, s0_.cms_intro_headings AS cms_intro_headings_8, s0_.faq_content AS faq_content_9, s0_.custom_css AS custom_css_10, s0_.custom_js AS custom_js_11, s0_.is_published AS is_published_12, s0_.is_system AS is_system_13, s0_.hero_slides AS hero_slides_14, s0_.popup_enabled AS popup_enabled_15, s0_.popup_content AS popup_content_16, s0_.popup_position AS popup_position_17, s0_.popup_delay_seconds AS popup_delay_seconds_18, s0_.popup_starts_at AS popup_starts_at_19, s0_.popup_ends_at AS popup_ends_at_20, s0_.listing_default_arrival AS listing_default_arrival_21, s0_.listing_default_departure AS listing_default_departure_22, s0_.listing_offers_enabled AS listing_offers_enabled_23, s0_.listing_guests_min AS listing_guests_min_24, s0_.listing_path_suffix AS listing_path_suffix_25, s0_.special_offer_home_promoted AS special_offer_home_promoted_26, s0_.special_offer_home_sort_order AS special_offer_home_sort_order_27, s0_.special_offer_list_sort AS special_offer_list_sort_28, s0_.special_offer_tile_image AS special_offer_tile_image_29, s0_.special_offer_tile_variants AS special_offer_tile_variants_30, s0_.created_at AS created_at_31, s0_.updated_at AS updated_at_32, s0_.meta_title AS meta_title_33, s0_.meta_description AS meta_description_34, s0_.canonical_url AS canonical_url_35, s0_.robots AS robots_36, s0_.og_title AS og_title_37, s0_.og_description AS og_description_38, s0_.og_image AS og_image_39, s0_.listing_category_id AS listing_category_id_40, s0_.listing_location_id AS listing_location_id_41, s0_.listing_residence_id AS listing_residence_id_42 FROM seo_pages s0_ WHERE s0_.page_key LIKE 'auto:%';
|
| 4 |
0.46 ms |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2, l0_.description AS description_3, l0_.lead AS lead_4, l0_.country AS country_5, l0_.city AS city_6, l0_.center_lat AS center_lat_7, l0_.center_lng AS center_lng_8, l0_.image_path AS image_path_9, l0_.image_variants AS image_variants_10, l0_.featured AS featured_11, l0_.created_at AS created_at_12, l0_.updated_at AS updated_at_13, l0_.meta_title AS meta_title_14, l0_.meta_description AS meta_description_15, l0_.canonical_url AS canonical_url_16, l0_.robots AS robots_17, l0_.og_title AS og_title_18, l0_.og_description AS og_description_19, l0_.og_image AS og_image_20 FROM locations l0_ ORDER BY l0_.name ASC
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2, l0_.description AS description_3, l0_.lead AS lead_4, l0_.country AS country_5, l0_.city AS city_6, l0_.center_lat AS center_lat_7, l0_.center_lng AS center_lng_8, l0_.image_path AS image_path_9, l0_.image_variants AS image_variants_10, l0_.featured AS featured_11, l0_.created_at AS created_at_12, l0_.updated_at AS updated_at_13, l0_.meta_title AS meta_title_14, l0_.meta_description AS meta_description_15, l0_.canonical_url AS canonical_url_16, l0_.robots AS robots_17, l0_.og_title AS og_title_18, l0_.og_description AS og_description_19, l0_.og_image AS og_image_20 FROM locations l0_ ORDER BY l0_.name ASC;
|
| 5 |
60.55 ms |
SELECT h0_.id AS id_0, h0_.type_id AS type_id_1, h0_.oid AS oid_2, h0_.title AS title_3, h0_.advert AS advert_4, h0_.single_beds AS single_beds_5, h0_.double_beds AS double_beds_6, h0_.sofa_beds AS sofa_beds_7, h0_.sofa_single_beds AS sofa_single_beds_8, h0_.fold_out_armchairs AS fold_out_armchairs_9, h0_.extra_beds AS extra_beds_10, h0_.area AS area_11, h0_.bedroom_count AS bedroom_count_12, h0_.bathroom_count AS bathroom_count_13, h0_.rooms_count AS rooms_count_14, h0_.floor AS floor_15, h0_.floor_display AS floor_display_16, h0_.distance_from_center AS distance_from_center_17, h0_.tourist_tax AS tourist_tax_18, h0_.deposit AS deposit_19, h0_.has_balcony_terrace AS has_balcony_terrace_20, h0_.exposure AS exposure_21, h0_.check_in_out_hours AS check_in_out_hours_22, h0_.garage AS garage_23, h0_.vat_invoice AS vat_invoice_24, h0_.price_from AS price_from_25, h0_.address AS address_26, h0_.contact_phone AS contact_phone_27, h0_.city AS city_28, h0_.zip AS zip_29, h0_.google_x AS google_x_30, h0_.google_y AS google_y_31, h0_.yt_url AS yt_url_32, h0_.panorama_iframe_html AS panorama_iframe_html_33, h0_.page_custom_css AS page_custom_css_34, h0_.page_custom_js AS page_custom_js_35, h0_.photo AS photo_36, h0_.photo_s AS photo_s_37, h0_.category AS category_38, h0_.tags AS tags_39, h0_.niceurl AS niceurl_40, h0_.extrainfo AS extrainfo_41, h0_.promo AS promo_42, h0_.description AS description_43, h0_.instructions AS instructions_44, h0_.meta_title AS meta_title_45, h0_.meta_description AS meta_description_46, h0_.is_active AS is_active_47, h0_.listing_sort_order AS listing_sort_order_48, h0_.discount AS discount_49, h0_.show_discount AS show_discount_50, h0_.listing_badge_new AS listing_badge_new_51, h0_.listing_badge_recommend AS listing_badge_recommend_52, h0_.listing_badge_highlight AS listing_badge_highlight_53, h0_.pin_home_featured AS pin_home_featured_54, h0_.pin_home_day_offer AS pin_home_day_offer_55, h0_.pin_home_recent AS pin_home_recent_56, h0_.home_featured_sort_order AS home_featured_sort_order_57, h0_.home_day_offer_sort_order AS home_day_offer_sort_order_58, h0_.home_recent_sort_order AS home_recent_sort_order_59, h0_.home_tile_variant AS home_tile_variant_60, h0_.photos AS photos_61, h0_.raw_data AS raw_data_62, h0_.created_at AS created_at_63, h0_.updated_at AS updated_at_64, r1_.id AS id_65, r1_.name AS name_66, r1_.slug AS slug_67, r1_.position AS position_68, l2_.id AS id_69, l2_.name AS name_70, l2_.slug AS slug_71, l2_.description AS description_72, l2_.lead AS lead_73, l2_.country AS country_74, l2_.city AS city_75, l2_.center_lat AS center_lat_76, l2_.center_lng AS center_lng_77, l2_.image_path AS image_path_78, l2_.image_variants AS image_variants_79, l2_.featured AS featured_80, l2_.created_at AS created_at_81, l2_.updated_at AS updated_at_82, l2_.meta_title AS meta_title_83, l2_.meta_description AS meta_description_84, l2_.canonical_url AS canonical_url_85, l2_.robots AS robots_86, l2_.og_title AS og_title_87, l2_.og_description AS og_description_88, l2_.og_image AS og_image_89, h0_.hotres_account_id AS hotres_account_id_90, h0_.location_id AS location_id_91, h0_.category_id AS category_id_92 FROM hotres_room_types h0_ INNER JOIN hotres_accounts h3_ ON h0_.hotres_account_id = h3_.id LEFT JOIN room_type_categories r1_ ON h0_.category_id = r1_.id LEFT JOIN locations l2_ ON h0_.location_id = l2_.id WHERE h3_.is_active = 1 ORDER BY h0_.id ASC
SELECT
h0_.id AS id_0,
h0_.type_id AS type_id_1,
h0_.oid AS oid_2,
h0_.title AS title_3,
h0_.advert AS advert_4,
h0_.single_beds AS single_beds_5,
h0_.double_beds AS double_beds_6,
h0_.sofa_beds AS sofa_beds_7,
h0_.sofa_single_beds AS sofa_single_beds_8,
h0_.fold_out_armchairs AS fold_out_armchairs_9,
h0_.extra_beds AS extra_beds_10,
h0_.area AS area_11,
h0_.bedroom_count AS bedroom_count_12,
h0_.bathroom_count AS bathroom_count_13,
h0_.rooms_count AS rooms_count_14,
h0_.floor AS floor_15,
h0_.floor_display AS floor_display_16,
h0_.distance_from_center AS distance_from_center_17,
h0_.tourist_tax AS tourist_tax_18,
h0_.deposit AS deposit_19,
h0_.has_balcony_terrace AS has_balcony_terrace_20,
h0_.exposure AS exposure_21,
h0_.check_in_out_hours AS check_in_out_hours_22,
h0_.garage AS garage_23,
h0_.vat_invoice AS vat_invoice_24,
h0_.price_from AS price_from_25,
h0_.address AS address_26,
h0_.contact_phone AS contact_phone_27,
h0_.city AS city_28,
h0_.zip AS zip_29,
h0_.google_x AS google_x_30,
h0_.google_y AS google_y_31,
h0_.yt_url AS yt_url_32,
h0_.panorama_iframe_html AS panorama_iframe_html_33,
h0_.page_custom_css AS page_custom_css_34,
h0_.page_custom_js AS page_custom_js_35,
h0_.photo AS photo_36,
h0_.photo_s AS photo_s_37,
h0_.category AS category_38,
h0_.tags AS tags_39,
h0_.niceurl AS niceurl_40,
h0_.extrainfo AS extrainfo_41,
h0_.promo AS promo_42,
h0_.description AS description_43,
h0_.instructions AS instructions_44,
h0_.meta_title AS meta_title_45,
h0_.meta_description AS meta_description_46,
h0_.is_active AS is_active_47,
h0_.listing_sort_order AS listing_sort_order_48,
h0_.discount AS discount_49,
h0_.show_discount AS show_discount_50,
h0_.listing_badge_new AS listing_badge_new_51,
h0_.listing_badge_recommend AS listing_badge_recommend_52,
h0_.listing_badge_highlight AS listing_badge_highlight_53,
h0_.pin_home_featured AS pin_home_featured_54,
h0_.pin_home_day_offer AS pin_home_day_offer_55,
h0_.pin_home_recent AS pin_home_recent_56,
h0_.home_featured_sort_order AS home_featured_sort_order_57,
h0_.home_day_offer_sort_order AS home_day_offer_sort_order_58,
h0_.home_recent_sort_order AS home_recent_sort_order_59,
h0_.home_tile_variant AS home_tile_variant_60,
h0_.photos AS photos_61,
h0_.raw_data AS raw_data_62,
h0_.created_at AS created_at_63,
h0_.updated_at AS updated_at_64,
r1_.id AS id_65,
r1_.name AS name_66,
r1_.slug AS slug_67,
r1_.position AS position_68,
l2_.id AS id_69,
l2_.name AS name_70,
l2_.slug AS slug_71,
l2_.description AS description_72,
l2_.lead AS lead_73,
l2_.country AS country_74,
l2_.city AS city_75,
l2_.center_lat AS center_lat_76,
l2_.center_lng AS center_lng_77,
l2_.image_path AS image_path_78,
l2_.image_variants AS image_variants_79,
l2_.featured AS featured_80,
l2_.created_at AS created_at_81,
l2_.updated_at AS updated_at_82,
l2_.meta_title AS meta_title_83,
l2_.meta_description AS meta_description_84,
l2_.canonical_url AS canonical_url_85,
l2_.robots AS robots_86,
l2_.og_title AS og_title_87,
l2_.og_description AS og_description_88,
l2_.og_image AS og_image_89,
h0_.hotres_account_id AS hotres_account_id_90,
h0_.location_id AS location_id_91,
h0_.category_id AS category_id_92
FROM
hotres_room_types h0_
INNER JOIN hotres_accounts h3_ ON h0_.hotres_account_id = h3_.id
LEFT JOIN room_type_categories r1_ ON h0_.category_id = r1_.id
LEFT JOIN locations l2_ ON h0_.location_id = l2_.id
WHERE
h3_.is_active = 1
ORDER BY
h0_.id ASC
SELECT h0_.id AS id_0, h0_.type_id AS type_id_1, h0_.oid AS oid_2, h0_.title AS title_3, h0_.advert AS advert_4, h0_.single_beds AS single_beds_5, h0_.double_beds AS double_beds_6, h0_.sofa_beds AS sofa_beds_7, h0_.sofa_single_beds AS sofa_single_beds_8, h0_.fold_out_armchairs AS fold_out_armchairs_9, h0_.extra_beds AS extra_beds_10, h0_.area AS area_11, h0_.bedroom_count AS bedroom_count_12, h0_.bathroom_count AS bathroom_count_13, h0_.rooms_count AS rooms_count_14, h0_.floor AS floor_15, h0_.floor_display AS floor_display_16, h0_.distance_from_center AS distance_from_center_17, h0_.tourist_tax AS tourist_tax_18, h0_.deposit AS deposit_19, h0_.has_balcony_terrace AS has_balcony_terrace_20, h0_.exposure AS exposure_21, h0_.check_in_out_hours AS check_in_out_hours_22, h0_.garage AS garage_23, h0_.vat_invoice AS vat_invoice_24, h0_.price_from AS price_from_25, h0_.address AS address_26, h0_.contact_phone AS contact_phone_27, h0_.city AS city_28, h0_.zip AS zip_29, h0_.google_x AS google_x_30, h0_.google_y AS google_y_31, h0_.yt_url AS yt_url_32, h0_.panorama_iframe_html AS panorama_iframe_html_33, h0_.page_custom_css AS page_custom_css_34, h0_.page_custom_js AS page_custom_js_35, h0_.photo AS photo_36, h0_.photo_s AS photo_s_37, h0_.category AS category_38, h0_.tags AS tags_39, h0_.niceurl AS niceurl_40, h0_.extrainfo AS extrainfo_41, h0_.promo AS promo_42, h0_.description AS description_43, h0_.instructions AS instructions_44, h0_.meta_title AS meta_title_45, h0_.meta_description AS meta_description_46, h0_.is_active AS is_active_47, h0_.listing_sort_order AS listing_sort_order_48, h0_.discount AS discount_49, h0_.show_discount AS show_discount_50, h0_.listing_badge_new AS listing_badge_new_51, h0_.listing_badge_recommend AS listing_badge_recommend_52, h0_.listing_badge_highlight AS listing_badge_highlight_53, h0_.pin_home_featured AS pin_home_featured_54, h0_.pin_home_day_offer AS pin_home_day_offer_55, h0_.pin_home_recent AS pin_home_recent_56, h0_.home_featured_sort_order AS home_featured_sort_order_57, h0_.home_day_offer_sort_order AS home_day_offer_sort_order_58, h0_.home_recent_sort_order AS home_recent_sort_order_59, h0_.home_tile_variant AS home_tile_variant_60, h0_.photos AS photos_61, h0_.raw_data AS raw_data_62, h0_.created_at AS created_at_63, h0_.updated_at AS updated_at_64, r1_.id AS id_65, r1_.name AS name_66, r1_.slug AS slug_67, r1_.position AS position_68, l2_.id AS id_69, l2_.name AS name_70, l2_.slug AS slug_71, l2_.description AS description_72, l2_.lead AS lead_73, l2_.country AS country_74, l2_.city AS city_75, l2_.center_lat AS center_lat_76, l2_.center_lng AS center_lng_77, l2_.image_path AS image_path_78, l2_.image_variants AS image_variants_79, l2_.featured AS featured_80, l2_.created_at AS created_at_81, l2_.updated_at AS updated_at_82, l2_.meta_title AS meta_title_83, l2_.meta_description AS meta_description_84, l2_.canonical_url AS canonical_url_85, l2_.robots AS robots_86, l2_.og_title AS og_title_87, l2_.og_description AS og_description_88, l2_.og_image AS og_image_89, h0_.hotres_account_id AS hotres_account_id_90, h0_.location_id AS location_id_91, h0_.category_id AS category_id_92 FROM hotres_room_types h0_ INNER JOIN hotres_accounts h3_ ON h0_.hotres_account_id = h3_.id LEFT JOIN room_type_categories r1_ ON h0_.category_id = r1_.id LEFT JOIN locations l2_ ON h0_.location_id = l2_.id WHERE h3_.is_active = 1 ORDER BY h0_.id ASC;
|
| 6 |
0.72 ms |
SELECT s0_.page_key AS page_key_0, s0_.slug AS slug_1 FROM seo_pages s0_ WHERE s0_.slug IS NOT NULL AND s0_.slug <> ?
SELECT s0_.page_key AS page_key_0, s0_.slug AS slug_1 FROM seo_pages s0_ WHERE s0_.slug IS NOT NULL AND s0_.slug <> '';
|
| 7 |
0.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.postal_code AS postal_code_5, t0.lead AS lead_6, t0.description AS description_7, t0.tile_highlights AS tile_highlights_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.pin_home_slider AS pin_home_slider_11, t0.show_contact_form AS show_contact_form_12, t0.map_lat AS map_lat_13, t0.map_lng AS map_lng_14, t0.map_embed_url AS map_embed_url_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.canonical_url AS canonical_url_20, t0.robots AS robots_21, t0.og_title AS og_title_22, t0.og_description AS og_description_23, t0.og_image AS og_image_24, t0.location_id AS location_id_25 FROM residences t0 ORDER BY t0.position ASC, t0.id ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.postal_code AS postal_code_5, t0.lead AS lead_6, t0.description AS description_7, t0.tile_highlights AS tile_highlights_8, t0.position AS position_9, t0.is_active AS is_active_10, t0.pin_home_slider AS pin_home_slider_11, t0.show_contact_form AS show_contact_form_12, t0.map_lat AS map_lat_13, t0.map_lng AS map_lng_14, t0.map_embed_url AS map_embed_url_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.canonical_url AS canonical_url_20, t0.robots AS robots_21, t0.og_title AS og_title_22, t0.og_description AS og_description_23, t0.og_image AS og_image_24, t0.location_id AS location_id_25 FROM residences t0 ORDER BY t0.position ASC, t0.id ASC;
|
| 8 |
1.53 ms |
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2, l0_.description AS description_3, l0_.lead AS lead_4, l0_.country AS country_5, l0_.city AS city_6, l0_.center_lat AS center_lat_7, l0_.center_lng AS center_lng_8, l0_.image_path AS image_path_9, l0_.image_variants AS image_variants_10, l0_.featured AS featured_11, l0_.created_at AS created_at_12, l0_.updated_at AS updated_at_13, l0_.meta_title AS meta_title_14, l0_.meta_description AS meta_description_15, l0_.canonical_url AS canonical_url_16, l0_.robots AS robots_17, l0_.og_title AS og_title_18, l0_.og_description AS og_description_19, l0_.og_image AS og_image_20, r1_.id AS id_21, r1_.path AS path_22, r1_.alt AS alt_23, r1_.position AS position_24, r1_.is_main AS is_main_25, r1_.variants AS variants_26, r1_.created_at AS created_at_27, r1_.updated_at AS updated_at_28, h2_.id AS id_29, h2_.type_id AS type_id_30, h2_.oid AS oid_31, h2_.title AS title_32, h2_.advert AS advert_33, h2_.single_beds AS single_beds_34, h2_.double_beds AS double_beds_35, h2_.sofa_beds AS sofa_beds_36, h2_.sofa_single_beds AS sofa_single_beds_37, h2_.fold_out_armchairs AS fold_out_armchairs_38, h2_.extra_beds AS extra_beds_39, h2_.area AS area_40, h2_.bedroom_count AS bedroom_count_41, h2_.bathroom_count AS bathroom_count_42, h2_.rooms_count AS rooms_count_43, h2_.floor AS floor_44, h2_.floor_display AS floor_display_45, h2_.distance_from_center AS distance_from_center_46, h2_.tourist_tax AS tourist_tax_47, h2_.deposit AS deposit_48, h2_.has_balcony_terrace AS has_balcony_terrace_49, h2_.exposure AS exposure_50, h2_.check_in_out_hours AS check_in_out_hours_51, h2_.garage AS garage_52, h2_.vat_invoice AS vat_invoice_53, h2_.price_from AS price_from_54, h2_.address AS address_55, h2_.contact_phone AS contact_phone_56, h2_.city AS city_57, h2_.zip AS zip_58, h2_.google_x AS google_x_59, h2_.google_y AS google_y_60, h2_.yt_url AS yt_url_61, h2_.panorama_iframe_html AS panorama_iframe_html_62, h2_.page_custom_css AS page_custom_css_63, h2_.page_custom_js AS page_custom_js_64, h2_.photo AS photo_65, h2_.photo_s AS photo_s_66, h2_.category AS category_67, h2_.tags AS tags_68, h2_.niceurl AS niceurl_69, h2_.extrainfo AS extrainfo_70, h2_.promo AS promo_71, h2_.description AS description_72, h2_.instructions AS instructions_73, h2_.meta_title AS meta_title_74, h2_.meta_description AS meta_description_75, h2_.is_active AS is_active_76, h2_.listing_sort_order AS listing_sort_order_77, h2_.discount AS discount_78, h2_.show_discount AS show_discount_79, h2_.listing_badge_new AS listing_badge_new_80, h2_.listing_badge_recommend AS listing_badge_recommend_81, h2_.listing_badge_highlight AS listing_badge_highlight_82, h2_.pin_home_featured AS pin_home_featured_83, h2_.pin_home_day_offer AS pin_home_day_offer_84, h2_.pin_home_recent AS pin_home_recent_85, h2_.home_featured_sort_order AS home_featured_sort_order_86, h2_.home_day_offer_sort_order AS home_day_offer_sort_order_87, h2_.home_recent_sort_order AS home_recent_sort_order_88, h2_.home_tile_variant AS home_tile_variant_89, h2_.photos AS photos_90, h2_.raw_data AS raw_data_91, h2_.created_at AS created_at_92, h2_.updated_at AS updated_at_93, r3_.id AS id_94, r3_.name AS name_95, r3_.slug AS slug_96, r3_.address AS address_97, r3_.postal_code AS postal_code_98, r3_.lead AS lead_99, r3_.description AS description_100, r3_.tile_highlights AS tile_highlights_101, r3_.position AS position_102, r3_.is_active AS is_active_103, r3_.pin_home_slider AS pin_home_slider_104, r3_.show_contact_form AS show_contact_form_105, r3_.map_lat AS map_lat_106, r3_.map_lng AS map_lng_107, r3_.map_embed_url AS map_embed_url_108, r3_.created_at AS created_at_109, r3_.updated_at AS updated_at_110, r3_.meta_title AS meta_title_111, r3_.meta_description AS meta_description_112, r3_.canonical_url AS canonical_url_113, r3_.robots AS robots_114, r3_.og_title AS og_title_115, r3_.og_description AS og_description_116, r3_.og_image AS og_image_117, l0_.id AS id_118, l0_.name AS name_119, l0_.slug AS slug_120, l0_.description AS description_121, l0_.lead AS lead_122, l0_.country AS country_123, l0_.city AS city_124, l0_.center_lat AS center_lat_125, l0_.center_lng AS center_lng_126, l0_.image_path AS image_path_127, l0_.image_variants AS image_variants_128, l0_.featured AS featured_129, l0_.created_at AS created_at_130, l0_.updated_at AS updated_at_131, l0_.meta_title AS meta_title_132, l0_.meta_description AS meta_description_133, l0_.canonical_url AS canonical_url_134, l0_.robots AS robots_135, l0_.og_title AS og_title_136, l0_.og_description AS og_description_137, l0_.og_image AS og_image_138, r1_.id AS id_139, r1_.path AS path_140, r1_.alt AS alt_141, r1_.position AS position_142, r1_.is_main AS is_main_143, r1_.variants AS variants_144, r1_.created_at AS created_at_145, r1_.updated_at AS updated_at_146, h2_.id AS id_147, h2_.type_id AS type_id_148, h2_.oid AS oid_149, h2_.title AS title_150, h2_.advert AS advert_151, h2_.single_beds AS single_beds_152, h2_.double_beds AS double_beds_153, h2_.sofa_beds AS sofa_beds_154, h2_.sofa_single_beds AS sofa_single_beds_155, h2_.fold_out_armchairs AS fold_out_armchairs_156, h2_.extra_beds AS extra_beds_157, h2_.area AS area_158, h2_.bedroom_count AS bedroom_count_159, h2_.bathroom_count AS bathroom_count_160, h2_.rooms_count AS rooms_count_161, h2_.floor AS floor_162, h2_.floor_display AS floor_display_163, h2_.distance_from_center AS distance_from_center_164, h2_.tourist_tax AS tourist_tax_165, h2_.deposit AS deposit_166, h2_.has_balcony_terrace AS has_balcony_terrace_167, h2_.exposure AS exposure_168, h2_.check_in_out_hours AS check_in_out_hours_169, h2_.garage AS garage_170, h2_.vat_invoice AS vat_invoice_171, h2_.price_from AS price_from_172, h2_.address AS address_173, h2_.contact_phone AS contact_phone_174, h2_.city AS city_175, h2_.zip AS zip_176, h2_.google_x AS google_x_177, h2_.google_y AS google_y_178, h2_.yt_url AS yt_url_179, h2_.panorama_iframe_html AS panorama_iframe_html_180, h2_.page_custom_css AS page_custom_css_181, h2_.page_custom_js AS page_custom_js_182, h2_.photo AS photo_183, h2_.photo_s AS photo_s_184, h2_.category AS category_185, h2_.tags AS tags_186, h2_.niceurl AS niceurl_187, h2_.extrainfo AS extrainfo_188, h2_.promo AS promo_189, h2_.description AS description_190, h2_.instructions AS instructions_191, h2_.meta_title AS meta_title_192, h2_.meta_description AS meta_description_193, h2_.is_active AS is_active_194, h2_.listing_sort_order AS listing_sort_order_195, h2_.discount AS discount_196, h2_.show_discount AS show_discount_197, h2_.listing_badge_new AS listing_badge_new_198, h2_.listing_badge_recommend AS listing_badge_recommend_199, h2_.listing_badge_highlight AS listing_badge_highlight_200, h2_.pin_home_featured AS pin_home_featured_201, h2_.pin_home_day_offer AS pin_home_day_offer_202, h2_.pin_home_recent AS pin_home_recent_203, h2_.home_featured_sort_order AS home_featured_sort_order_204, h2_.home_day_offer_sort_order AS home_day_offer_sort_order_205, h2_.home_recent_sort_order AS home_recent_sort_order_206, h2_.home_tile_variant AS home_tile_variant_207, h2_.photos AS photos_208, h2_.raw_data AS raw_data_209, h2_.created_at AS created_at_210, h2_.updated_at AS updated_at_211, r1_.residence_id AS residence_id_212, h2_.hotres_account_id AS hotres_account_id_213, h2_.location_id AS location_id_214, h2_.category_id AS category_id_215, r3_.location_id AS location_id_216 FROM residences r3_ LEFT JOIN locations l0_ ON r3_.location_id = l0_.id LEFT JOIN residence_images r1_ ON r3_.id = r1_.residence_id LEFT JOIN residence_room_types r4_ ON r3_.id = r4_.residence_id LEFT JOIN hotres_room_types h2_ ON h2_.id = r4_.hotres_room_type_id WHERE r3_.is_active = ? ORDER BY r3_.position ASC, r3_.name ASC, r1_.position ASC, r1_.id ASC, h2_.id ASC
SELECT
l0_.id AS id_0,
l0_.name AS name_1,
l0_.slug AS slug_2,
l0_.description AS description_3,
l0_.lead AS lead_4,
l0_.country AS country_5,
l0_.city AS city_6,
l0_.center_lat AS center_lat_7,
l0_.center_lng AS center_lng_8,
l0_.image_path AS image_path_9,
l0_.image_variants AS image_variants_10,
l0_.featured AS featured_11,
l0_.created_at AS created_at_12,
l0_.updated_at AS updated_at_13,
l0_.meta_title AS meta_title_14,
l0_.meta_description AS meta_description_15,
l0_.canonical_url AS canonical_url_16,
l0_.robots AS robots_17,
l0_.og_title AS og_title_18,
l0_.og_description AS og_description_19,
l0_.og_image AS og_image_20,
r1_.id AS id_21,
r1_.path AS path_22,
r1_.alt AS alt_23,
r1_.position AS position_24,
r1_.is_main AS is_main_25,
r1_.variants AS variants_26,
r1_.created_at AS created_at_27,
r1_.updated_at AS updated_at_28,
h2_.id AS id_29,
h2_.type_id AS type_id_30,
h2_.oid AS oid_31,
h2_.title AS title_32,
h2_.advert AS advert_33,
h2_.single_beds AS single_beds_34,
h2_.double_beds AS double_beds_35,
h2_.sofa_beds AS sofa_beds_36,
h2_.sofa_single_beds AS sofa_single_beds_37,
h2_.fold_out_armchairs AS fold_out_armchairs_38,
h2_.extra_beds AS extra_beds_39,
h2_.area AS area_40,
h2_.bedroom_count AS bedroom_count_41,
h2_.bathroom_count AS bathroom_count_42,
h2_.rooms_count AS rooms_count_43,
h2_.floor AS floor_44,
h2_.floor_display AS floor_display_45,
h2_.distance_from_center AS distance_from_center_46,
h2_.tourist_tax AS tourist_tax_47,
h2_.deposit AS deposit_48,
h2_.has_balcony_terrace AS has_balcony_terrace_49,
h2_.exposure AS exposure_50,
h2_.check_in_out_hours AS check_in_out_hours_51,
h2_.garage AS garage_52,
h2_.vat_invoice AS vat_invoice_53,
h2_.price_from AS price_from_54,
h2_.address AS address_55,
h2_.contact_phone AS contact_phone_56,
h2_.city AS city_57,
h2_.zip AS zip_58,
h2_.google_x AS google_x_59,
h2_.google_y AS google_y_60,
h2_.yt_url AS yt_url_61,
h2_.panorama_iframe_html AS panorama_iframe_html_62,
h2_.page_custom_css AS page_custom_css_63,
h2_.page_custom_js AS page_custom_js_64,
h2_.photo AS photo_65,
h2_.photo_s AS photo_s_66,
h2_.category AS category_67,
h2_.tags AS tags_68,
h2_.niceurl AS niceurl_69,
h2_.extrainfo AS extrainfo_70,
h2_.promo AS promo_71,
h2_.description AS description_72,
h2_.instructions AS instructions_73,
h2_.meta_title AS meta_title_74,
h2_.meta_description AS meta_description_75,
h2_.is_active AS is_active_76,
h2_.listing_sort_order AS listing_sort_order_77,
h2_.discount AS discount_78,
h2_.show_discount AS show_discount_79,
h2_.listing_badge_new AS listing_badge_new_80,
h2_.listing_badge_recommend AS listing_badge_recommend_81,
h2_.listing_badge_highlight AS listing_badge_highlight_82,
h2_.pin_home_featured AS pin_home_featured_83,
h2_.pin_home_day_offer AS pin_home_day_offer_84,
h2_.pin_home_recent AS pin_home_recent_85,
h2_.home_featured_sort_order AS home_featured_sort_order_86,
h2_.home_day_offer_sort_order AS home_day_offer_sort_order_87,
h2_.home_recent_sort_order AS home_recent_sort_order_88,
h2_.home_tile_variant AS home_tile_variant_89,
h2_.photos AS photos_90,
h2_.raw_data AS raw_data_91,
h2_.created_at AS created_at_92,
h2_.updated_at AS updated_at_93,
r3_.id AS id_94,
r3_.name AS name_95,
r3_.slug AS slug_96,
r3_.address AS address_97,
r3_.postal_code AS postal_code_98,
r3_.lead AS lead_99,
r3_.description AS description_100,
r3_.tile_highlights AS tile_highlights_101,
r3_.position AS position_102,
r3_.is_active AS is_active_103,
r3_.pin_home_slider AS pin_home_slider_104,
r3_.show_contact_form AS show_contact_form_105,
r3_.map_lat AS map_lat_106,
r3_.map_lng AS map_lng_107,
r3_.map_embed_url AS map_embed_url_108,
r3_.created_at AS created_at_109,
r3_.updated_at AS updated_at_110,
r3_.meta_title AS meta_title_111,
r3_.meta_description AS meta_description_112,
r3_.canonical_url AS canonical_url_113,
r3_.robots AS robots_114,
r3_.og_title AS og_title_115,
r3_.og_description AS og_description_116,
r3_.og_image AS og_image_117,
l0_.id AS id_118,
l0_.name AS name_119,
l0_.slug AS slug_120,
l0_.description AS description_121,
l0_.lead AS lead_122,
l0_.country AS country_123,
l0_.city AS city_124,
l0_.center_lat AS center_lat_125,
l0_.center_lng AS center_lng_126,
l0_.image_path AS image_path_127,
l0_.image_variants AS image_variants_128,
l0_.featured AS featured_129,
l0_.created_at AS created_at_130,
l0_.updated_at AS updated_at_131,
l0_.meta_title AS meta_title_132,
l0_.meta_description AS meta_description_133,
l0_.canonical_url AS canonical_url_134,
l0_.robots AS robots_135,
l0_.og_title AS og_title_136,
l0_.og_description AS og_description_137,
l0_.og_image AS og_image_138,
r1_.id AS id_139,
r1_.path AS path_140,
r1_.alt AS alt_141,
r1_.position AS position_142,
r1_.is_main AS is_main_143,
r1_.variants AS variants_144,
r1_.created_at AS created_at_145,
r1_.updated_at AS updated_at_146,
h2_.id AS id_147,
h2_.type_id AS type_id_148,
h2_.oid AS oid_149,
h2_.title AS title_150,
h2_.advert AS advert_151,
h2_.single_beds AS single_beds_152,
h2_.double_beds AS double_beds_153,
h2_.sofa_beds AS sofa_beds_154,
h2_.sofa_single_beds AS sofa_single_beds_155,
h2_.fold_out_armchairs AS fold_out_armchairs_156,
h2_.extra_beds AS extra_beds_157,
h2_.area AS area_158,
h2_.bedroom_count AS bedroom_count_159,
h2_.bathroom_count AS bathroom_count_160,
h2_.rooms_count AS rooms_count_161,
h2_.floor AS floor_162,
h2_.floor_display AS floor_display_163,
h2_.distance_from_center AS distance_from_center_164,
h2_.tourist_tax AS tourist_tax_165,
h2_.deposit AS deposit_166,
h2_.has_balcony_terrace AS has_balcony_terrace_167,
h2_.exposure AS exposure_168,
h2_.check_in_out_hours AS check_in_out_hours_169,
h2_.garage AS garage_170,
h2_.vat_invoice AS vat_invoice_171,
h2_.price_from AS price_from_172,
h2_.address AS address_173,
h2_.contact_phone AS contact_phone_174,
h2_.city AS city_175,
h2_.zip AS zip_176,
h2_.google_x AS google_x_177,
h2_.google_y AS google_y_178,
h2_.yt_url AS yt_url_179,
h2_.panorama_iframe_html AS panorama_iframe_html_180,
h2_.page_custom_css AS page_custom_css_181,
h2_.page_custom_js AS page_custom_js_182,
h2_.photo AS photo_183,
h2_.photo_s AS photo_s_184,
h2_.category AS category_185,
h2_.tags AS tags_186,
h2_.niceurl AS niceurl_187,
h2_.extrainfo AS extrainfo_188,
h2_.promo AS promo_189,
h2_.description AS description_190,
h2_.instructions AS instructions_191,
h2_.meta_title AS meta_title_192,
h2_.meta_description AS meta_description_193,
h2_.is_active AS is_active_194,
h2_.listing_sort_order AS listing_sort_order_195,
h2_.discount AS discount_196,
h2_.show_discount AS show_discount_197,
h2_.listing_badge_new AS listing_badge_new_198,
h2_.listing_badge_recommend AS listing_badge_recommend_199,
h2_.listing_badge_highlight AS listing_badge_highlight_200,
h2_.pin_home_featured AS pin_home_featured_201,
h2_.pin_home_day_offer AS pin_home_day_offer_202,
h2_.pin_home_recent AS pin_home_recent_203,
h2_.home_featured_sort_order AS home_featured_sort_order_204,
h2_.home_day_offer_sort_order AS home_day_offer_sort_order_205,
h2_.home_recent_sort_order AS home_recent_sort_order_206,
h2_.home_tile_variant AS home_tile_variant_207,
h2_.photos AS photos_208,
h2_.raw_data AS raw_data_209,
h2_.created_at AS created_at_210,
h2_.updated_at AS updated_at_211,
r1_.residence_id AS residence_id_212,
h2_.hotres_account_id AS hotres_account_id_213,
h2_.location_id AS location_id_214,
h2_.category_id AS category_id_215,
r3_.location_id AS location_id_216
FROM
residences r3_
LEFT JOIN locations l0_ ON r3_.location_id = l0_.id
LEFT JOIN residence_images r1_ ON r3_.id = r1_.residence_id
LEFT JOIN residence_room_types r4_ ON r3_.id = r4_.residence_id
LEFT JOIN hotres_room_types h2_ ON h2_.id = r4_.hotres_room_type_id
WHERE
r3_.is_active = ?
ORDER BY
r3_.position ASC,
r3_.name ASC,
r1_.position ASC,
r1_.id ASC,
h2_.id ASC
SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.slug AS slug_2, l0_.description AS description_3, l0_.lead AS lead_4, l0_.country AS country_5, l0_.city AS city_6, l0_.center_lat AS center_lat_7, l0_.center_lng AS center_lng_8, l0_.image_path AS image_path_9, l0_.image_variants AS image_variants_10, l0_.featured AS featured_11, l0_.created_at AS created_at_12, l0_.updated_at AS updated_at_13, l0_.meta_title AS meta_title_14, l0_.meta_description AS meta_description_15, l0_.canonical_url AS canonical_url_16, l0_.robots AS robots_17, l0_.og_title AS og_title_18, l0_.og_description AS og_description_19, l0_.og_image AS og_image_20, r1_.id AS id_21, r1_.path AS path_22, r1_.alt AS alt_23, r1_.position AS position_24, r1_.is_main AS is_main_25, r1_.variants AS variants_26, r1_.created_at AS created_at_27, r1_.updated_at AS updated_at_28, h2_.id AS id_29, h2_.type_id AS type_id_30, h2_.oid AS oid_31, h2_.title AS title_32, h2_.advert AS advert_33, h2_.single_beds AS single_beds_34, h2_.double_beds AS double_beds_35, h2_.sofa_beds AS sofa_beds_36, h2_.sofa_single_beds AS sofa_single_beds_37, h2_.fold_out_armchairs AS fold_out_armchairs_38, h2_.extra_beds AS extra_beds_39, h2_.area AS area_40, h2_.bedroom_count AS bedroom_count_41, h2_.bathroom_count AS bathroom_count_42, h2_.rooms_count AS rooms_count_43, h2_.floor AS floor_44, h2_.floor_display AS floor_display_45, h2_.distance_from_center AS distance_from_center_46, h2_.tourist_tax AS tourist_tax_47, h2_.deposit AS deposit_48, h2_.has_balcony_terrace AS has_balcony_terrace_49, h2_.exposure AS exposure_50, h2_.check_in_out_hours AS check_in_out_hours_51, h2_.garage AS garage_52, h2_.vat_invoice AS vat_invoice_53, h2_.price_from AS price_from_54, h2_.address AS address_55, h2_.contact_phone AS contact_phone_56, h2_.city AS city_57, h2_.zip AS zip_58, h2_.google_x AS google_x_59, h2_.google_y AS google_y_60, h2_.yt_url AS yt_url_61, h2_.panorama_iframe_html AS panorama_iframe_html_62, h2_.page_custom_css AS page_custom_css_63, h2_.page_custom_js AS page_custom_js_64, h2_.photo AS photo_65, h2_.photo_s AS photo_s_66, h2_.category AS category_67, h2_.tags AS tags_68, h2_.niceurl AS niceurl_69, h2_.extrainfo AS extrainfo_70, h2_.promo AS promo_71, h2_.description AS description_72, h2_.instructions AS instructions_73, h2_.meta_title AS meta_title_74, h2_.meta_description AS meta_description_75, h2_.is_active AS is_active_76, h2_.listing_sort_order AS listing_sort_order_77, h2_.discount AS discount_78, h2_.show_discount AS show_discount_79, h2_.listing_badge_new AS listing_badge_new_80, h2_.listing_badge_recommend AS listing_badge_recommend_81, h2_.listing_badge_highlight AS listing_badge_highlight_82, h2_.pin_home_featured AS pin_home_featured_83, h2_.pin_home_day_offer AS pin_home_day_offer_84, h2_.pin_home_recent AS pin_home_recent_85, h2_.home_featured_sort_order AS home_featured_sort_order_86, h2_.home_day_offer_sort_order AS home_day_offer_sort_order_87, h2_.home_recent_sort_order AS home_recent_sort_order_88, h2_.home_tile_variant AS home_tile_variant_89, h2_.photos AS photos_90, h2_.raw_data AS raw_data_91, h2_.created_at AS created_at_92, h2_.updated_at AS updated_at_93, r3_.id AS id_94, r3_.name AS name_95, r3_.slug AS slug_96, r3_.address AS address_97, r3_.postal_code AS postal_code_98, r3_.lead AS lead_99, r3_.description AS description_100, r3_.tile_highlights AS tile_highlights_101, r3_.position AS position_102, r3_.is_active AS is_active_103, r3_.pin_home_slider AS pin_home_slider_104, r3_.show_contact_form AS show_contact_form_105, r3_.map_lat AS map_lat_106, r3_.map_lng AS map_lng_107, r3_.map_embed_url AS map_embed_url_108, r3_.created_at AS created_at_109, r3_.updated_at AS updated_at_110, r3_.meta_title AS meta_title_111, r3_.meta_description AS meta_description_112, r3_.canonical_url AS canonical_url_113, r3_.robots AS robots_114, r3_.og_title AS og_title_115, r3_.og_description AS og_description_116, r3_.og_image AS og_image_117, l0_.id AS id_118, l0_.name AS name_119, l0_.slug AS slug_120, l0_.description AS description_121, l0_.lead AS lead_122, l0_.country AS country_123, l0_.city AS city_124, l0_.center_lat AS center_lat_125, l0_.center_lng AS center_lng_126, l0_.image_path AS image_path_127, l0_.image_variants AS image_variants_128, l0_.featured AS featured_129, l0_.created_at AS created_at_130, l0_.updated_at AS updated_at_131, l0_.meta_title AS meta_title_132, l0_.meta_description AS meta_description_133, l0_.canonical_url AS canonical_url_134, l0_.robots AS robots_135, l0_.og_title AS og_title_136, l0_.og_description AS og_description_137, l0_.og_image AS og_image_138, r1_.id AS id_139, r1_.path AS path_140, r1_.alt AS alt_141, r1_.position AS position_142, r1_.is_main AS is_main_143, r1_.variants AS variants_144, r1_.created_at AS created_at_145, r1_.updated_at AS updated_at_146, h2_.id AS id_147, h2_.type_id AS type_id_148, h2_.oid AS oid_149, h2_.title AS title_150, h2_.advert AS advert_151, h2_.single_beds AS single_beds_152, h2_.double_beds AS double_beds_153, h2_.sofa_beds AS sofa_beds_154, h2_.sofa_single_beds AS sofa_single_beds_155, h2_.fold_out_armchairs AS fold_out_armchairs_156, h2_.extra_beds AS extra_beds_157, h2_.area AS area_158, h2_.bedroom_count AS bedroom_count_159, h2_.bathroom_count AS bathroom_count_160, h2_.rooms_count AS rooms_count_161, h2_.floor AS floor_162, h2_.floor_display AS floor_display_163, h2_.distance_from_center AS distance_from_center_164, h2_.tourist_tax AS tourist_tax_165, h2_.deposit AS deposit_166, h2_.has_balcony_terrace AS has_balcony_terrace_167, h2_.exposure AS exposure_168, h2_.check_in_out_hours AS check_in_out_hours_169, h2_.garage AS garage_170, h2_.vat_invoice AS vat_invoice_171, h2_.price_from AS price_from_172, h2_.address AS address_173, h2_.contact_phone AS contact_phone_174, h2_.city AS city_175, h2_.zip AS zip_176, h2_.google_x AS google_x_177, h2_.google_y AS google_y_178, h2_.yt_url AS yt_url_179, h2_.panorama_iframe_html AS panorama_iframe_html_180, h2_.page_custom_css AS page_custom_css_181, h2_.page_custom_js AS page_custom_js_182, h2_.photo AS photo_183, h2_.photo_s AS photo_s_184, h2_.category AS category_185, h2_.tags AS tags_186, h2_.niceurl AS niceurl_187, h2_.extrainfo AS extrainfo_188, h2_.promo AS promo_189, h2_.description AS description_190, h2_.instructions AS instructions_191, h2_.meta_title AS meta_title_192, h2_.meta_description AS meta_description_193, h2_.is_active AS is_active_194, h2_.listing_sort_order AS listing_sort_order_195, h2_.discount AS discount_196, h2_.show_discount AS show_discount_197, h2_.listing_badge_new AS listing_badge_new_198, h2_.listing_badge_recommend AS listing_badge_recommend_199, h2_.listing_badge_highlight AS listing_badge_highlight_200, h2_.pin_home_featured AS pin_home_featured_201, h2_.pin_home_day_offer AS pin_home_day_offer_202, h2_.pin_home_recent AS pin_home_recent_203, h2_.home_featured_sort_order AS home_featured_sort_order_204, h2_.home_day_offer_sort_order AS home_day_offer_sort_order_205, h2_.home_recent_sort_order AS home_recent_sort_order_206, h2_.home_tile_variant AS home_tile_variant_207, h2_.photos AS photos_208, h2_.raw_data AS raw_data_209, h2_.created_at AS created_at_210, h2_.updated_at AS updated_at_211, r1_.residence_id AS residence_id_212, h2_.hotres_account_id AS hotres_account_id_213, h2_.location_id AS location_id_214, h2_.category_id AS category_id_215, r3_.location_id AS location_id_216 FROM residences r3_ LEFT JOIN locations l0_ ON r3_.location_id = l0_.id LEFT JOIN residence_images r1_ ON r3_.id = r1_.residence_id LEFT JOIN residence_room_types r4_ ON r3_.id = r4_.residence_id LEFT JOIN hotres_room_types h2_ ON h2_.id = r4_.hotres_room_type_id WHERE r3_.is_active = 1 ORDER BY r3_.position ASC, r3_.name ASC, r1_.position ASC, r1_.id ASC, h2_.id ASC;
|
| 9 |
0.38 ms |
SELECT t0.id AS id_1, t0.page_key AS page_key_2, t0.slug AS slug_3, t0.path AS path_4, t0.title AS title_5, t0.front_module AS front_module_6, t0.content AS content_7, t0.content_edit_mode AS content_edit_mode_8, t0.cms_intro_headings AS cms_intro_headings_9, t0.faq_content AS faq_content_10, t0.custom_css AS custom_css_11, t0.custom_js AS custom_js_12, t0.is_published AS is_published_13, t0.is_system AS is_system_14, t0.hero_slides AS hero_slides_15, t0.popup_enabled AS popup_enabled_16, t0.popup_content AS popup_content_17, t0.popup_position AS popup_position_18, t0.popup_delay_seconds AS popup_delay_seconds_19, t0.popup_starts_at AS popup_starts_at_20, t0.popup_ends_at AS popup_ends_at_21, t0.listing_default_arrival AS listing_default_arrival_22, t0.listing_default_departure AS listing_default_departure_23, t0.listing_offers_enabled AS listing_offers_enabled_24, t0.listing_guests_min AS listing_guests_min_25, t0.listing_path_suffix AS listing_path_suffix_26, t0.special_offer_home_promoted AS special_offer_home_promoted_27, t0.special_offer_home_sort_order AS special_offer_home_sort_order_28, t0.special_offer_list_sort AS special_offer_list_sort_29, t0.special_offer_tile_image AS special_offer_tile_image_30, t0.special_offer_tile_variants AS special_offer_tile_variants_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.meta_title AS meta_title_34, t0.meta_description AS meta_description_35, t0.canonical_url AS canonical_url_36, t0.robots AS robots_37, t0.og_title AS og_title_38, t0.og_description AS og_description_39, t0.og_image AS og_image_40, t0.listing_category_id AS listing_category_id_41, t0.listing_location_id AS listing_location_id_42, t0.listing_residence_id AS listing_residence_id_43 FROM seo_pages t0 WHERE t0.page_key = ? LIMIT 1
Parameters: [
"auto:residences:index"
]
SELECT
t0.id AS id_1,
t0.page_key AS page_key_2,
t0.slug AS slug_3,
t0.path AS path_4,
t0.title AS title_5,
t0.front_module AS front_module_6,
t0.content AS content_7,
t0.content_edit_mode AS content_edit_mode_8,
t0.cms_intro_headings AS cms_intro_headings_9,
t0.faq_content AS faq_content_10,
t0.custom_css AS custom_css_11,
t0.custom_js AS custom_js_12,
t0.is_published AS is_published_13,
t0.is_system AS is_system_14,
t0.hero_slides AS hero_slides_15,
t0.popup_enabled AS popup_enabled_16,
t0.popup_content AS popup_content_17,
t0.popup_position AS popup_position_18,
t0.popup_delay_seconds AS popup_delay_seconds_19,
t0.popup_starts_at AS popup_starts_at_20,
t0.popup_ends_at AS popup_ends_at_21,
t0.listing_default_arrival AS listing_default_arrival_22,
t0.listing_default_departure AS listing_default_departure_23,
t0.listing_offers_enabled AS listing_offers_enabled_24,
t0.listing_guests_min AS listing_guests_min_25,
t0.listing_path_suffix AS listing_path_suffix_26,
t0.special_offer_home_promoted AS special_offer_home_promoted_27,
t0.special_offer_home_sort_order AS special_offer_home_sort_order_28,
t0.special_offer_list_sort AS special_offer_list_sort_29,
t0.special_offer_tile_image AS special_offer_tile_image_30,
t0.special_offer_tile_variants AS special_offer_tile_variants_31,
t0.created_at AS created_at_32,
t0.updated_at AS updated_at_33,
t0.meta_title AS meta_title_34,
t0.meta_description AS meta_description_35,
t0.canonical_url AS canonical_url_36,
t0.robots AS robots_37,
t0.og_title AS og_title_38,
t0.og_description AS og_description_39,
t0.og_image AS og_image_40,
t0.listing_category_id AS listing_category_id_41,
t0.listing_location_id AS listing_location_id_42,
t0.listing_residence_id AS listing_residence_id_43
FROM
seo_pages t0
WHERE
t0.page_key = ?
LIMIT
1
SELECT t0.id AS id_1, t0.page_key AS page_key_2, t0.slug AS slug_3, t0.path AS path_4, t0.title AS title_5, t0.front_module AS front_module_6, t0.content AS content_7, t0.content_edit_mode AS content_edit_mode_8, t0.cms_intro_headings AS cms_intro_headings_9, t0.faq_content AS faq_content_10, t0.custom_css AS custom_css_11, t0.custom_js AS custom_js_12, t0.is_published AS is_published_13, t0.is_system AS is_system_14, t0.hero_slides AS hero_slides_15, t0.popup_enabled AS popup_enabled_16, t0.popup_content AS popup_content_17, t0.popup_position AS popup_position_18, t0.popup_delay_seconds AS popup_delay_seconds_19, t0.popup_starts_at AS popup_starts_at_20, t0.popup_ends_at AS popup_ends_at_21, t0.listing_default_arrival AS listing_default_arrival_22, t0.listing_default_departure AS listing_default_departure_23, t0.listing_offers_enabled AS listing_offers_enabled_24, t0.listing_guests_min AS listing_guests_min_25, t0.listing_path_suffix AS listing_path_suffix_26, t0.special_offer_home_promoted AS special_offer_home_promoted_27, t0.special_offer_home_sort_order AS special_offer_home_sort_order_28, t0.special_offer_list_sort AS special_offer_list_sort_29, t0.special_offer_tile_image AS special_offer_tile_image_30, t0.special_offer_tile_variants AS special_offer_tile_variants_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.meta_title AS meta_title_34, t0.meta_description AS meta_description_35, t0.canonical_url AS canonical_url_36, t0.robots AS robots_37, t0.og_title AS og_title_38, t0.og_description AS og_description_39, t0.og_image AS og_image_40, t0.listing_category_id AS listing_category_id_41, t0.listing_location_id AS listing_location_id_42, t0.listing_residence_id AS listing_residence_id_43 FROM seo_pages t0 WHERE t0.page_key = 'auto:residences:index' LIMIT 1;
|
| 10 |
0.49 ms |
SELECT t0.id AS id_1, t0.default_height_px AS default_height_px_2, t0.default_height_unit AS default_height_unit_3, t0.default_height_mobile AS default_height_mobile_4, t0.default_height_mobile_unit AS default_height_mobile_unit_5, t0.default_autoplay_sec AS default_autoplay_sec_6, t0.crop_ref_width_desktop AS crop_ref_width_desktop_7, t0.crop_ref_width_tablet AS crop_ref_width_tablet_8, t0.crop_ref_width_mobile AS crop_ref_width_mobile_9 FROM slider_global_settings t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.default_height_px AS default_height_px_2, t0.default_height_unit AS default_height_unit_3, t0.default_height_mobile AS default_height_mobile_4, t0.default_height_mobile_unit AS default_height_mobile_unit_5, t0.default_autoplay_sec AS default_autoplay_sec_6, t0.crop_ref_width_desktop AS crop_ref_width_desktop_7, t0.crop_ref_width_tablet AS crop_ref_width_tablet_8, t0.crop_ref_width_mobile AS crop_ref_width_mobile_9 FROM slider_global_settings t0 WHERE t0.id = 1;
|
| 11 |
0.50 ms |
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.position AS position_4, t0.seo_page_id AS seo_page_id_5 FROM seo_page_faq_items t0 WHERE t0.seo_page_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.position AS position_4, t0.seo_page_id AS seo_page_id_5 FROM seo_page_faq_items t0 WHERE t0.seo_page_id = 4 ORDER BY t0.position ASC, t0.id ASC;
|
| 12 |
0.91 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.seo_page_id AS seo_page_id_3, t0.hero_slider_id AS hero_slider_id_4 FROM seo_page_hero_sliders t0 WHERE t0.seo_page_id = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.id AS id_1, t0.position AS position_2, t0.seo_page_id AS seo_page_id_3, t0.hero_slider_id AS hero_slider_id_4 FROM seo_page_hero_sliders t0 WHERE t0.seo_page_id = 4 ORDER BY t0.position ASC, t0.id ASC;
|
| 13 |
1.20 ms |
SELECT t0.id AS id_1, t0.position AS position_2, t0.seo_page_id AS seo_page_id_3, t0.slide_id AS slide_id_4 FROM page_slides t0 WHERE t0.seo_page_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.position AS position_2, t0.seo_page_id AS seo_page_id_3, t0.slide_id AS slide_id_4 FROM page_slides t0 WHERE t0.seo_page_id = 4 ORDER BY t0.position ASC;
|
| 14 |
0.63 ms |
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.site_name AS site_name_3, t0.site_tagline AS site_tagline_4, t0.homepage_headline AS homepage_headline_5, t0.homepage_subheadline AS homepage_subheadline_6, t0.homepage_intro_html AS homepage_intro_html_7, t0.apartment_card_teaser_lines AS apartment_card_teaser_lines_8, t0.primary_cta_text AS primary_cta_text_9, t0.primary_cta_url AS primary_cta_url_10, t0.secondary_cta_text AS secondary_cta_text_11, t0.secondary_cta_url AS secondary_cta_url_12, t0.newsletter_signup_url AS newsletter_signup_url_13, t0.contact_email AS contact_email_14, t0.contact_phone AS contact_phone_15, t0.address_line AS address_line_16, t0.company_name AS company_name_17, t0.nip AS nip_18, t0.bank_account_number AS bank_account_number_19, t0.iban AS iban_20, t0.bic_swift AS bic_swift_21, t0.bank_name_and_address AS bank_name_and_address_22, t0.reservation_hours AS reservation_hours_23, t0.transfer_title AS transfer_title_24, t0.facebook_url AS facebook_url_25, t0.instagram_url AS instagram_url_26, t0.youtube_url AS youtube_url_27, t0.linkedin_url AS linkedin_url_28, t0.x_url AS x_url_29, t0.tiktok_url AS tiktok_url_30, t0.logo_path AS logo_path_31, t0.meta_title AS meta_title_32, t0.meta_description AS meta_description_33, t0.meta_keywords AS meta_keywords_34, t0.og_title AS og_title_35, t0.og_description AS og_description_36, t0.og_image AS og_image_37, t0.favicon_path AS favicon_path_38, t0.canonical_base_url AS canonical_base_url_39, t0.footer_copyright AS footer_copyright_40, t0.contact_page_slug AS contact_page_slug_41, t0.terms_page_slug AS terms_page_slug_42, t0.privacy_page_slug AS privacy_page_slug_43, t0.layout_max_width AS layout_max_width_44, t0.page_preloader_enabled AS page_preloader_enabled_45, t0.page_preloader_variant AS page_preloader_variant_46, t0.page_preloader_min_ms AS page_preloader_min_ms_47, t0.page_preloader_fade_ms AS page_preloader_fade_ms_48, t0.page_preloader_max_wait_ms AS page_preloader_max_wait_ms_49, t0.page_preloader_bg_color AS page_preloader_bg_color_50, t0.page_preloader_accent_color AS page_preloader_accent_color_51, t0.page_preloader_text AS page_preloader_text_52, t0.page_preloader_mode AS page_preloader_mode_53, t0.page_preloader_respect_reduced_motion AS page_preloader_respect_reduced_motion_54, t0.manifest_name AS manifest_name_55, t0.manifest_short_name AS manifest_short_name_56, t0.manifest_theme_color AS manifest_theme_color_57, t0.manifest_background_color AS manifest_background_color_58, t0.manifest_display AS manifest_display_59, t0.manifest_custom_json AS manifest_custom_json_60, t0.theme_color_bg AS theme_color_bg_61, t0.theme_color_surface AS theme_color_surface_62, t0.theme_color_surface_soft AS theme_color_surface_soft_63, t0.theme_color_surface_strong AS theme_color_surface_strong_64, t0.theme_color_border AS theme_color_border_65, t0.theme_color_text AS theme_color_text_66, t0.theme_color_text_muted AS theme_color_text_muted_67, t0.theme_color_primary AS theme_color_primary_68, t0.theme_color_primary_hover AS theme_color_primary_hover_69, t0.theme_color_secondary AS theme_color_secondary_70, t0.theme_color_footer_bg AS theme_color_footer_bg_71, t0.theme_color_footer_text AS theme_color_footer_text_72, t0.theme_color_footer_muted AS theme_color_footer_muted_73, t0.theme_color_footer_border AS theme_color_footer_border_74, t0.theme_color_footer_input_bg AS theme_color_footer_input_bg_75, t0.theme_color_header_bg AS theme_color_header_bg_76, t0.theme_color_header_border AS theme_color_header_border_77, t0.theme_color_brand_text AS theme_color_brand_text_78, t0.theme_color_nav_link AS theme_color_nav_link_79, t0.theme_color_nav_link_hover AS theme_color_nav_link_hover_80, t0.theme_color_nav_link_active AS theme_color_nav_link_active_81, t0.theme_color_nav_link_active_bg AS theme_color_nav_link_active_bg_82, t0.theme_color_nav_hamburger AS theme_color_nav_hamburger_83, t0.theme_color_mobile_nav_bg AS theme_color_mobile_nav_bg_84, t0.theme_color_mobile_nav_border AS theme_color_mobile_nav_border_85, t0.theme_color_mobile_nav_link AS theme_color_mobile_nav_link_86, t0.theme_color_mobile_nav_link_hover AS theme_color_mobile_nav_link_hover_87, t0.theme_color_submenu_bg AS theme_color_submenu_bg_88, t0.theme_color_trust_strip_bg AS theme_color_trust_strip_bg_89, t0.theme_color_trust_strip_text AS theme_color_trust_strip_text_90, t0.theme_color_link AS theme_color_link_91, t0.theme_color_link_hover AS theme_color_link_hover_92, t0.theme_color_on_primary AS theme_color_on_primary_93, t0.theme_color_heading AS theme_color_heading_94, t0.theme_color_h1 AS theme_color_h1_95, t0.theme_color_h2 AS theme_color_h2_96, t0.theme_color_h3 AS theme_color_h3_97, t0.theme_color_nav_link_active_bar AS theme_color_nav_link_active_bar_98, t0.theme_color_on_secondary AS theme_color_on_secondary_99, t0.theme_color_footer_social_fg AS theme_color_footer_social_fg_100, t0.admin_panel_primary_color AS admin_panel_primary_color_101, t0.admin_panel_brand_name AS admin_panel_brand_name_102, t0.theme_font_family_base AS theme_font_family_base_103, t0.theme_font_family_heading AS theme_font_family_heading_104, t0.theme_google_font_css_url AS theme_google_font_css_url_105, t0.theme_font_size_base AS theme_font_size_base_106, t0.theme_font_size_sm AS theme_font_size_sm_107, t0.theme_font_size_lead AS theme_font_size_lead_108, t0.theme_font_size_h1 AS theme_font_size_h1_109, t0.theme_font_size_h2 AS theme_font_size_h2_110, t0.theme_font_size_h3 AS theme_font_size_h3_111, t0.theme_font_size_h4 AS theme_font_size_h4_112, t0.theme_font_weight_body AS theme_font_weight_body_113, t0.theme_font_weight_heading AS theme_font_weight_heading_114, t0.theme_line_height_body AS theme_line_height_body_115, t0.theme_letter_spacing_heading AS theme_letter_spacing_heading_116, t0.theme_layout_border_radius AS theme_layout_border_radius_117, t0.theme_layout_minimal AS theme_layout_minimal_118, t0.mailer_use_custom_smtp AS mailer_use_custom_smtp_119, t0.smtp_host AS smtp_host_120, t0.smtp_port AS smtp_port_121, t0.smtp_username AS smtp_username_122, t0.smtp_password AS smtp_password_123, t0.smtp_encryption AS smtp_encryption_124, t0.mailer_from_address AS mailer_from_address_125, t0.mailer_from_name AS mailer_from_name_126, t0.recaptcha_site_key AS recaptcha_site_key_127, t0.recaptcha_secret_key AS recaptcha_secret_key_128, t0.recaptcha_min_score AS recaptcha_min_score_129, t0.openai_api_key AS openai_api_key_130, t0.openai_model AS openai_model_131, t0.external_scripts_head AS external_scripts_head_132, t0.external_scripts_body_start AS external_scripts_body_start_133, t0.external_scripts_body_end AS external_scripts_body_end_134, t0.created_at AS created_at_135, t0.updated_at AS updated_at_136 FROM site_settings t0 WHERE t0.settings_key = ? LIMIT 1
Parameters: [
"default"
]
SELECT
t0.id AS id_1,
t0.settings_key AS settings_key_2,
t0.site_name AS site_name_3,
t0.site_tagline AS site_tagline_4,
t0.homepage_headline AS homepage_headline_5,
t0.homepage_subheadline AS homepage_subheadline_6,
t0.homepage_intro_html AS homepage_intro_html_7,
t0.apartment_card_teaser_lines AS apartment_card_teaser_lines_8,
t0.primary_cta_text AS primary_cta_text_9,
t0.primary_cta_url AS primary_cta_url_10,
t0.secondary_cta_text AS secondary_cta_text_11,
t0.secondary_cta_url AS secondary_cta_url_12,
t0.newsletter_signup_url AS newsletter_signup_url_13,
t0.contact_email AS contact_email_14,
t0.contact_phone AS contact_phone_15,
t0.address_line AS address_line_16,
t0.company_name AS company_name_17,
t0.nip AS nip_18,
t0.bank_account_number AS bank_account_number_19,
t0.iban AS iban_20,
t0.bic_swift AS bic_swift_21,
t0.bank_name_and_address AS bank_name_and_address_22,
t0.reservation_hours AS reservation_hours_23,
t0.transfer_title AS transfer_title_24,
t0.facebook_url AS facebook_url_25,
t0.instagram_url AS instagram_url_26,
t0.youtube_url AS youtube_url_27,
t0.linkedin_url AS linkedin_url_28,
t0.x_url AS x_url_29,
t0.tiktok_url AS tiktok_url_30,
t0.logo_path AS logo_path_31,
t0.meta_title AS meta_title_32,
t0.meta_description AS meta_description_33,
t0.meta_keywords AS meta_keywords_34,
t0.og_title AS og_title_35,
t0.og_description AS og_description_36,
t0.og_image AS og_image_37,
t0.favicon_path AS favicon_path_38,
t0.canonical_base_url AS canonical_base_url_39,
t0.footer_copyright AS footer_copyright_40,
t0.contact_page_slug AS contact_page_slug_41,
t0.terms_page_slug AS terms_page_slug_42,
t0.privacy_page_slug AS privacy_page_slug_43,
t0.layout_max_width AS layout_max_width_44,
t0.page_preloader_enabled AS page_preloader_enabled_45,
t0.page_preloader_variant AS page_preloader_variant_46,
t0.page_preloader_min_ms AS page_preloader_min_ms_47,
t0.page_preloader_fade_ms AS page_preloader_fade_ms_48,
t0.page_preloader_max_wait_ms AS page_preloader_max_wait_ms_49,
t0.page_preloader_bg_color AS page_preloader_bg_color_50,
t0.page_preloader_accent_color AS page_preloader_accent_color_51,
t0.page_preloader_text AS page_preloader_text_52,
t0.page_preloader_mode AS page_preloader_mode_53,
t0.page_preloader_respect_reduced_motion AS page_preloader_respect_reduced_motion_54,
t0.manifest_name AS manifest_name_55,
t0.manifest_short_name AS manifest_short_name_56,
t0.manifest_theme_color AS manifest_theme_color_57,
t0.manifest_background_color AS manifest_background_color_58,
t0.manifest_display AS manifest_display_59,
t0.manifest_custom_json AS manifest_custom_json_60,
t0.theme_color_bg AS theme_color_bg_61,
t0.theme_color_surface AS theme_color_surface_62,
t0.theme_color_surface_soft AS theme_color_surface_soft_63,
t0.theme_color_surface_strong AS theme_color_surface_strong_64,
t0.theme_color_border AS theme_color_border_65,
t0.theme_color_text AS theme_color_text_66,
t0.theme_color_text_muted AS theme_color_text_muted_67,
t0.theme_color_primary AS theme_color_primary_68,
t0.theme_color_primary_hover AS theme_color_primary_hover_69,
t0.theme_color_secondary AS theme_color_secondary_70,
t0.theme_color_footer_bg AS theme_color_footer_bg_71,
t0.theme_color_footer_text AS theme_color_footer_text_72,
t0.theme_color_footer_muted AS theme_color_footer_muted_73,
t0.theme_color_footer_border AS theme_color_footer_border_74,
t0.theme_color_footer_input_bg AS theme_color_footer_input_bg_75,
t0.theme_color_header_bg AS theme_color_header_bg_76,
t0.theme_color_header_border AS theme_color_header_border_77,
t0.theme_color_brand_text AS theme_color_brand_text_78,
t0.theme_color_nav_link AS theme_color_nav_link_79,
t0.theme_color_nav_link_hover AS theme_color_nav_link_hover_80,
t0.theme_color_nav_link_active AS theme_color_nav_link_active_81,
t0.theme_color_nav_link_active_bg AS theme_color_nav_link_active_bg_82,
t0.theme_color_nav_hamburger AS theme_color_nav_hamburger_83,
t0.theme_color_mobile_nav_bg AS theme_color_mobile_nav_bg_84,
t0.theme_color_mobile_nav_border AS theme_color_mobile_nav_border_85,
t0.theme_color_mobile_nav_link AS theme_color_mobile_nav_link_86,
t0.theme_color_mobile_nav_link_hover AS theme_color_mobile_nav_link_hover_87,
t0.theme_color_submenu_bg AS theme_color_submenu_bg_88,
t0.theme_color_trust_strip_bg AS theme_color_trust_strip_bg_89,
t0.theme_color_trust_strip_text AS theme_color_trust_strip_text_90,
t0.theme_color_link AS theme_color_link_91,
t0.theme_color_link_hover AS theme_color_link_hover_92,
t0.theme_color_on_primary AS theme_color_on_primary_93,
t0.theme_color_heading AS theme_color_heading_94,
t0.theme_color_h1 AS theme_color_h1_95,
t0.theme_color_h2 AS theme_color_h2_96,
t0.theme_color_h3 AS theme_color_h3_97,
t0.theme_color_nav_link_active_bar AS theme_color_nav_link_active_bar_98,
t0.theme_color_on_secondary AS theme_color_on_secondary_99,
t0.theme_color_footer_social_fg AS theme_color_footer_social_fg_100,
t0.admin_panel_primary_color AS admin_panel_primary_color_101,
t0.admin_panel_brand_name AS admin_panel_brand_name_102,
t0.theme_font_family_base AS theme_font_family_base_103,
t0.theme_font_family_heading AS theme_font_family_heading_104,
t0.theme_google_font_css_url AS theme_google_font_css_url_105,
t0.theme_font_size_base AS theme_font_size_base_106,
t0.theme_font_size_sm AS theme_font_size_sm_107,
t0.theme_font_size_lead AS theme_font_size_lead_108,
t0.theme_font_size_h1 AS theme_font_size_h1_109,
t0.theme_font_size_h2 AS theme_font_size_h2_110,
t0.theme_font_size_h3 AS theme_font_size_h3_111,
t0.theme_font_size_h4 AS theme_font_size_h4_112,
t0.theme_font_weight_body AS theme_font_weight_body_113,
t0.theme_font_weight_heading AS theme_font_weight_heading_114,
t0.theme_line_height_body AS theme_line_height_body_115,
t0.theme_letter_spacing_heading AS theme_letter_spacing_heading_116,
t0.theme_layout_border_radius AS theme_layout_border_radius_117,
t0.theme_layout_minimal AS theme_layout_minimal_118,
t0.mailer_use_custom_smtp AS mailer_use_custom_smtp_119,
t0.smtp_host AS smtp_host_120,
t0.smtp_port AS smtp_port_121,
t0.smtp_username AS smtp_username_122,
t0.smtp_password AS smtp_password_123,
t0.smtp_encryption AS smtp_encryption_124,
t0.mailer_from_address AS mailer_from_address_125,
t0.mailer_from_name AS mailer_from_name_126,
t0.recaptcha_site_key AS recaptcha_site_key_127,
t0.recaptcha_secret_key AS recaptcha_secret_key_128,
t0.recaptcha_min_score AS recaptcha_min_score_129,
t0.openai_api_key AS openai_api_key_130,
t0.openai_model AS openai_model_131,
t0.external_scripts_head AS external_scripts_head_132,
t0.external_scripts_body_start AS external_scripts_body_start_133,
t0.external_scripts_body_end AS external_scripts_body_end_134,
t0.created_at AS created_at_135,
t0.updated_at AS updated_at_136
FROM
site_settings t0
WHERE
t0.settings_key = ?
LIMIT
1
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.site_name AS site_name_3, t0.site_tagline AS site_tagline_4, t0.homepage_headline AS homepage_headline_5, t0.homepage_subheadline AS homepage_subheadline_6, t0.homepage_intro_html AS homepage_intro_html_7, t0.apartment_card_teaser_lines AS apartment_card_teaser_lines_8, t0.primary_cta_text AS primary_cta_text_9, t0.primary_cta_url AS primary_cta_url_10, t0.secondary_cta_text AS secondary_cta_text_11, t0.secondary_cta_url AS secondary_cta_url_12, t0.newsletter_signup_url AS newsletter_signup_url_13, t0.contact_email AS contact_email_14, t0.contact_phone AS contact_phone_15, t0.address_line AS address_line_16, t0.company_name AS company_name_17, t0.nip AS nip_18, t0.bank_account_number AS bank_account_number_19, t0.iban AS iban_20, t0.bic_swift AS bic_swift_21, t0.bank_name_and_address AS bank_name_and_address_22, t0.reservation_hours AS reservation_hours_23, t0.transfer_title AS transfer_title_24, t0.facebook_url AS facebook_url_25, t0.instagram_url AS instagram_url_26, t0.youtube_url AS youtube_url_27, t0.linkedin_url AS linkedin_url_28, t0.x_url AS x_url_29, t0.tiktok_url AS tiktok_url_30, t0.logo_path AS logo_path_31, t0.meta_title AS meta_title_32, t0.meta_description AS meta_description_33, t0.meta_keywords AS meta_keywords_34, t0.og_title AS og_title_35, t0.og_description AS og_description_36, t0.og_image AS og_image_37, t0.favicon_path AS favicon_path_38, t0.canonical_base_url AS canonical_base_url_39, t0.footer_copyright AS footer_copyright_40, t0.contact_page_slug AS contact_page_slug_41, t0.terms_page_slug AS terms_page_slug_42, t0.privacy_page_slug AS privacy_page_slug_43, t0.layout_max_width AS layout_max_width_44, t0.page_preloader_enabled AS page_preloader_enabled_45, t0.page_preloader_variant AS page_preloader_variant_46, t0.page_preloader_min_ms AS page_preloader_min_ms_47, t0.page_preloader_fade_ms AS page_preloader_fade_ms_48, t0.page_preloader_max_wait_ms AS page_preloader_max_wait_ms_49, t0.page_preloader_bg_color AS page_preloader_bg_color_50, t0.page_preloader_accent_color AS page_preloader_accent_color_51, t0.page_preloader_text AS page_preloader_text_52, t0.page_preloader_mode AS page_preloader_mode_53, t0.page_preloader_respect_reduced_motion AS page_preloader_respect_reduced_motion_54, t0.manifest_name AS manifest_name_55, t0.manifest_short_name AS manifest_short_name_56, t0.manifest_theme_color AS manifest_theme_color_57, t0.manifest_background_color AS manifest_background_color_58, t0.manifest_display AS manifest_display_59, t0.manifest_custom_json AS manifest_custom_json_60, t0.theme_color_bg AS theme_color_bg_61, t0.theme_color_surface AS theme_color_surface_62, t0.theme_color_surface_soft AS theme_color_surface_soft_63, t0.theme_color_surface_strong AS theme_color_surface_strong_64, t0.theme_color_border AS theme_color_border_65, t0.theme_color_text AS theme_color_text_66, t0.theme_color_text_muted AS theme_color_text_muted_67, t0.theme_color_primary AS theme_color_primary_68, t0.theme_color_primary_hover AS theme_color_primary_hover_69, t0.theme_color_secondary AS theme_color_secondary_70, t0.theme_color_footer_bg AS theme_color_footer_bg_71, t0.theme_color_footer_text AS theme_color_footer_text_72, t0.theme_color_footer_muted AS theme_color_footer_muted_73, t0.theme_color_footer_border AS theme_color_footer_border_74, t0.theme_color_footer_input_bg AS theme_color_footer_input_bg_75, t0.theme_color_header_bg AS theme_color_header_bg_76, t0.theme_color_header_border AS theme_color_header_border_77, t0.theme_color_brand_text AS theme_color_brand_text_78, t0.theme_color_nav_link AS theme_color_nav_link_79, t0.theme_color_nav_link_hover AS theme_color_nav_link_hover_80, t0.theme_color_nav_link_active AS theme_color_nav_link_active_81, t0.theme_color_nav_link_active_bg AS theme_color_nav_link_active_bg_82, t0.theme_color_nav_hamburger AS theme_color_nav_hamburger_83, t0.theme_color_mobile_nav_bg AS theme_color_mobile_nav_bg_84, t0.theme_color_mobile_nav_border AS theme_color_mobile_nav_border_85, t0.theme_color_mobile_nav_link AS theme_color_mobile_nav_link_86, t0.theme_color_mobile_nav_link_hover AS theme_color_mobile_nav_link_hover_87, t0.theme_color_submenu_bg AS theme_color_submenu_bg_88, t0.theme_color_trust_strip_bg AS theme_color_trust_strip_bg_89, t0.theme_color_trust_strip_text AS theme_color_trust_strip_text_90, t0.theme_color_link AS theme_color_link_91, t0.theme_color_link_hover AS theme_color_link_hover_92, t0.theme_color_on_primary AS theme_color_on_primary_93, t0.theme_color_heading AS theme_color_heading_94, t0.theme_color_h1 AS theme_color_h1_95, t0.theme_color_h2 AS theme_color_h2_96, t0.theme_color_h3 AS theme_color_h3_97, t0.theme_color_nav_link_active_bar AS theme_color_nav_link_active_bar_98, t0.theme_color_on_secondary AS theme_color_on_secondary_99, t0.theme_color_footer_social_fg AS theme_color_footer_social_fg_100, t0.admin_panel_primary_color AS admin_panel_primary_color_101, t0.admin_panel_brand_name AS admin_panel_brand_name_102, t0.theme_font_family_base AS theme_font_family_base_103, t0.theme_font_family_heading AS theme_font_family_heading_104, t0.theme_google_font_css_url AS theme_google_font_css_url_105, t0.theme_font_size_base AS theme_font_size_base_106, t0.theme_font_size_sm AS theme_font_size_sm_107, t0.theme_font_size_lead AS theme_font_size_lead_108, t0.theme_font_size_h1 AS theme_font_size_h1_109, t0.theme_font_size_h2 AS theme_font_size_h2_110, t0.theme_font_size_h3 AS theme_font_size_h3_111, t0.theme_font_size_h4 AS theme_font_size_h4_112, t0.theme_font_weight_body AS theme_font_weight_body_113, t0.theme_font_weight_heading AS theme_font_weight_heading_114, t0.theme_line_height_body AS theme_line_height_body_115, t0.theme_letter_spacing_heading AS theme_letter_spacing_heading_116, t0.theme_layout_border_radius AS theme_layout_border_radius_117, t0.theme_layout_minimal AS theme_layout_minimal_118, t0.mailer_use_custom_smtp AS mailer_use_custom_smtp_119, t0.smtp_host AS smtp_host_120, t0.smtp_port AS smtp_port_121, t0.smtp_username AS smtp_username_122, t0.smtp_password AS smtp_password_123, t0.smtp_encryption AS smtp_encryption_124, t0.mailer_from_address AS mailer_from_address_125, t0.mailer_from_name AS mailer_from_name_126, t0.recaptcha_site_key AS recaptcha_site_key_127, t0.recaptcha_secret_key AS recaptcha_secret_key_128, t0.recaptcha_min_score AS recaptcha_min_score_129, t0.openai_api_key AS openai_api_key_130, t0.openai_model AS openai_model_131, t0.external_scripts_head AS external_scripts_head_132, t0.external_scripts_body_start AS external_scripts_body_start_133, t0.external_scripts_body_end AS external_scripts_body_end_134, t0.created_at AS created_at_135, t0.updated_at AS updated_at_136 FROM site_settings t0 WHERE t0.settings_key = 'default' LIMIT 1;
|
| 15 |
0.61 ms |
SELECT s0_.id AS id_0, s0_.page_key AS page_key_1, s0_.slug AS slug_2, s0_.path AS path_3, s0_.title AS title_4, s0_.front_module AS front_module_5, s0_.content AS content_6, s0_.content_edit_mode AS content_edit_mode_7, s0_.cms_intro_headings AS cms_intro_headings_8, s0_.faq_content AS faq_content_9, s0_.custom_css AS custom_css_10, s0_.custom_js AS custom_js_11, s0_.is_published AS is_published_12, s0_.is_system AS is_system_13, s0_.hero_slides AS hero_slides_14, s0_.popup_enabled AS popup_enabled_15, s0_.popup_content AS popup_content_16, s0_.popup_position AS popup_position_17, s0_.popup_delay_seconds AS popup_delay_seconds_18, s0_.popup_starts_at AS popup_starts_at_19, s0_.popup_ends_at AS popup_ends_at_20, s0_.listing_default_arrival AS listing_default_arrival_21, s0_.listing_default_departure AS listing_default_departure_22, s0_.listing_offers_enabled AS listing_offers_enabled_23, s0_.listing_guests_min AS listing_guests_min_24, s0_.listing_path_suffix AS listing_path_suffix_25, s0_.special_offer_home_promoted AS special_offer_home_promoted_26, s0_.special_offer_home_sort_order AS special_offer_home_sort_order_27, s0_.special_offer_list_sort AS special_offer_list_sort_28, s0_.special_offer_tile_image AS special_offer_tile_image_29, s0_.special_offer_tile_variants AS special_offer_tile_variants_30, s0_.created_at AS created_at_31, s0_.updated_at AS updated_at_32, s0_.meta_title AS meta_title_33, s0_.meta_description AS meta_description_34, s0_.canonical_url AS canonical_url_35, s0_.robots AS robots_36, s0_.og_title AS og_title_37, s0_.og_description AS og_description_38, s0_.og_image AS og_image_39, m1_.id AS id_40, m1_.label AS label_41, m1_.link_type AS link_type_42, m1_.route_name AS route_name_43, m1_.route_params AS route_params_44, m1_.url AS url_45, m1_.placements AS placements_46, m1_.position AS position_47, m1_.is_active AS is_active_48, m1_.open_in_new_tab AS open_in_new_tab_49, m1_.subtitle AS subtitle_50, m1_.icon_tabler AS icon_tabler_51, m1_.floating_corner AS floating_corner_52, m1_.handler_key AS handler_key_53, m1_.show_favorites_badge AS show_favorites_badge_54, m1_.created_at AS created_at_55, m1_.updated_at AS updated_at_56, m2_.id AS id_57, m2_.label AS label_58, m2_.link_type AS link_type_59, m2_.route_name AS route_name_60, m2_.route_params AS route_params_61, m2_.url AS url_62, m2_.placements AS placements_63, m2_.position AS position_64, m2_.is_active AS is_active_65, m2_.open_in_new_tab AS open_in_new_tab_66, m2_.subtitle AS subtitle_67, m2_.icon_tabler AS icon_tabler_68, m2_.floating_corner AS floating_corner_69, m2_.handler_key AS handler_key_70, m2_.show_favorites_badge AS show_favorites_badge_71, m2_.created_at AS created_at_72, m2_.updated_at AS updated_at_73, s0_.id AS id_74, s0_.page_key AS page_key_75, s0_.slug AS slug_76, s0_.path AS path_77, s0_.title AS title_78, s0_.front_module AS front_module_79, s0_.content AS content_80, s0_.content_edit_mode AS content_edit_mode_81, s0_.cms_intro_headings AS cms_intro_headings_82, s0_.faq_content AS faq_content_83, s0_.custom_css AS custom_css_84, s0_.custom_js AS custom_js_85, s0_.is_published AS is_published_86, s0_.is_system AS is_system_87, s0_.hero_slides AS hero_slides_88, s0_.popup_enabled AS popup_enabled_89, s0_.popup_content AS popup_content_90, s0_.popup_position AS popup_position_91, s0_.popup_delay_seconds AS popup_delay_seconds_92, s0_.popup_starts_at AS popup_starts_at_93, s0_.popup_ends_at AS popup_ends_at_94, s0_.listing_default_arrival AS listing_default_arrival_95, s0_.listing_default_departure AS listing_default_departure_96, s0_.listing_offers_enabled AS listing_offers_enabled_97, s0_.listing_guests_min AS listing_guests_min_98, s0_.listing_path_suffix AS listing_path_suffix_99, s0_.special_offer_home_promoted AS special_offer_home_promoted_100, s0_.special_offer_home_sort_order AS special_offer_home_sort_order_101, s0_.special_offer_list_sort AS special_offer_list_sort_102, s0_.special_offer_tile_image AS special_offer_tile_image_103, s0_.special_offer_tile_variants AS special_offer_tile_variants_104, s0_.created_at AS created_at_105, s0_.updated_at AS updated_at_106, s0_.meta_title AS meta_title_107, s0_.meta_description AS meta_description_108, s0_.canonical_url AS canonical_url_109, s0_.robots AS robots_110, s0_.og_title AS og_title_111, s0_.og_description AS og_description_112, s0_.og_image AS og_image_113, m1_.id AS id_114, m1_.label AS label_115, m1_.link_type AS link_type_116, m1_.route_name AS route_name_117, m1_.route_params AS route_params_118, m1_.url AS url_119, m1_.placements AS placements_120, m1_.position AS position_121, m1_.is_active AS is_active_122, m1_.open_in_new_tab AS open_in_new_tab_123, m1_.subtitle AS subtitle_124, m1_.icon_tabler AS icon_tabler_125, m1_.floating_corner AS floating_corner_126, m1_.handler_key AS handler_key_127, m1_.show_favorites_badge AS show_favorites_badge_128, m1_.created_at AS created_at_129, m1_.updated_at AS updated_at_130, s0_.listing_category_id AS listing_category_id_131, s0_.listing_location_id AS listing_location_id_132, s0_.listing_residence_id AS listing_residence_id_133, m1_.seo_page_id AS seo_page_id_134, m1_.parent_id AS parent_id_135, m2_.seo_page_id AS seo_page_id_136, m2_.parent_id AS parent_id_137 FROM menu_items m2_ LEFT JOIN seo_pages s0_ ON m2_.seo_page_id = s0_.id LEFT JOIN menu_items m1_ ON m2_.parent_id = m1_.id WHERE m2_.is_active = 1 ORDER BY m2_.position ASC, m2_.id ASC
SELECT
s0_.id AS id_0,
s0_.page_key AS page_key_1,
s0_.slug AS slug_2,
s0_.path AS path_3,
s0_.title AS title_4,
s0_.front_module AS front_module_5,
s0_.content AS content_6,
s0_.content_edit_mode AS content_edit_mode_7,
s0_.cms_intro_headings AS cms_intro_headings_8,
s0_.faq_content AS faq_content_9,
s0_.custom_css AS custom_css_10,
s0_.custom_js AS custom_js_11,
s0_.is_published AS is_published_12,
s0_.is_system AS is_system_13,
s0_.hero_slides AS hero_slides_14,
s0_.popup_enabled AS popup_enabled_15,
s0_.popup_content AS popup_content_16,
s0_.popup_position AS popup_position_17,
s0_.popup_delay_seconds AS popup_delay_seconds_18,
s0_.popup_starts_at AS popup_starts_at_19,
s0_.popup_ends_at AS popup_ends_at_20,
s0_.listing_default_arrival AS listing_default_arrival_21,
s0_.listing_default_departure AS listing_default_departure_22,
s0_.listing_offers_enabled AS listing_offers_enabled_23,
s0_.listing_guests_min AS listing_guests_min_24,
s0_.listing_path_suffix AS listing_path_suffix_25,
s0_.special_offer_home_promoted AS special_offer_home_promoted_26,
s0_.special_offer_home_sort_order AS special_offer_home_sort_order_27,
s0_.special_offer_list_sort AS special_offer_list_sort_28,
s0_.special_offer_tile_image AS special_offer_tile_image_29,
s0_.special_offer_tile_variants AS special_offer_tile_variants_30,
s0_.created_at AS created_at_31,
s0_.updated_at AS updated_at_32,
s0_.meta_title AS meta_title_33,
s0_.meta_description AS meta_description_34,
s0_.canonical_url AS canonical_url_35,
s0_.robots AS robots_36,
s0_.og_title AS og_title_37,
s0_.og_description AS og_description_38,
s0_.og_image AS og_image_39,
m1_.id AS id_40,
m1_.label AS label_41,
m1_.link_type AS link_type_42,
m1_.route_name AS route_name_43,
m1_.route_params AS route_params_44,
m1_.url AS url_45,
m1_.placements AS placements_46,
m1_.position AS position_47,
m1_.is_active AS is_active_48,
m1_.open_in_new_tab AS open_in_new_tab_49,
m1_.subtitle AS subtitle_50,
m1_.icon_tabler AS icon_tabler_51,
m1_.floating_corner AS floating_corner_52,
m1_.handler_key AS handler_key_53,
m1_.show_favorites_badge AS show_favorites_badge_54,
m1_.created_at AS created_at_55,
m1_.updated_at AS updated_at_56,
m2_.id AS id_57,
m2_.label AS label_58,
m2_.link_type AS link_type_59,
m2_.route_name AS route_name_60,
m2_.route_params AS route_params_61,
m2_.url AS url_62,
m2_.placements AS placements_63,
m2_.position AS position_64,
m2_.is_active AS is_active_65,
m2_.open_in_new_tab AS open_in_new_tab_66,
m2_.subtitle AS subtitle_67,
m2_.icon_tabler AS icon_tabler_68,
m2_.floating_corner AS floating_corner_69,
m2_.handler_key AS handler_key_70,
m2_.show_favorites_badge AS show_favorites_badge_71,
m2_.created_at AS created_at_72,
m2_.updated_at AS updated_at_73,
s0_.id AS id_74,
s0_.page_key AS page_key_75,
s0_.slug AS slug_76,
s0_.path AS path_77,
s0_.title AS title_78,
s0_.front_module AS front_module_79,
s0_.content AS content_80,
s0_.content_edit_mode AS content_edit_mode_81,
s0_.cms_intro_headings AS cms_intro_headings_82,
s0_.faq_content AS faq_content_83,
s0_.custom_css AS custom_css_84,
s0_.custom_js AS custom_js_85,
s0_.is_published AS is_published_86,
s0_.is_system AS is_system_87,
s0_.hero_slides AS hero_slides_88,
s0_.popup_enabled AS popup_enabled_89,
s0_.popup_content AS popup_content_90,
s0_.popup_position AS popup_position_91,
s0_.popup_delay_seconds AS popup_delay_seconds_92,
s0_.popup_starts_at AS popup_starts_at_93,
s0_.popup_ends_at AS popup_ends_at_94,
s0_.listing_default_arrival AS listing_default_arrival_95,
s0_.listing_default_departure AS listing_default_departure_96,
s0_.listing_offers_enabled AS listing_offers_enabled_97,
s0_.listing_guests_min AS listing_guests_min_98,
s0_.listing_path_suffix AS listing_path_suffix_99,
s0_.special_offer_home_promoted AS special_offer_home_promoted_100,
s0_.special_offer_home_sort_order AS special_offer_home_sort_order_101,
s0_.special_offer_list_sort AS special_offer_list_sort_102,
s0_.special_offer_tile_image AS special_offer_tile_image_103,
s0_.special_offer_tile_variants AS special_offer_tile_variants_104,
s0_.created_at AS created_at_105,
s0_.updated_at AS updated_at_106,
s0_.meta_title AS meta_title_107,
s0_.meta_description AS meta_description_108,
s0_.canonical_url AS canonical_url_109,
s0_.robots AS robots_110,
s0_.og_title AS og_title_111,
s0_.og_description AS og_description_112,
s0_.og_image AS og_image_113,
m1_.id AS id_114,
m1_.label AS label_115,
m1_.link_type AS link_type_116,
m1_.route_name AS route_name_117,
m1_.route_params AS route_params_118,
m1_.url AS url_119,
m1_.placements AS placements_120,
m1_.position AS position_121,
m1_.is_active AS is_active_122,
m1_.open_in_new_tab AS open_in_new_tab_123,
m1_.subtitle AS subtitle_124,
m1_.icon_tabler AS icon_tabler_125,
m1_.floating_corner AS floating_corner_126,
m1_.handler_key AS handler_key_127,
m1_.show_favorites_badge AS show_favorites_badge_128,
m1_.created_at AS created_at_129,
m1_.updated_at AS updated_at_130,
s0_.listing_category_id AS listing_category_id_131,
s0_.listing_location_id AS listing_location_id_132,
s0_.listing_residence_id AS listing_residence_id_133,
m1_.seo_page_id AS seo_page_id_134,
m1_.parent_id AS parent_id_135,
m2_.seo_page_id AS seo_page_id_136,
m2_.parent_id AS parent_id_137
FROM
menu_items m2_
LEFT JOIN seo_pages s0_ ON m2_.seo_page_id = s0_.id
LEFT JOIN menu_items m1_ ON m2_.parent_id = m1_.id
WHERE
m2_.is_active = 1
ORDER BY
m2_.position ASC,
m2_.id ASC
SELECT s0_.id AS id_0, s0_.page_key AS page_key_1, s0_.slug AS slug_2, s0_.path AS path_3, s0_.title AS title_4, s0_.front_module AS front_module_5, s0_.content AS content_6, s0_.content_edit_mode AS content_edit_mode_7, s0_.cms_intro_headings AS cms_intro_headings_8, s0_.faq_content AS faq_content_9, s0_.custom_css AS custom_css_10, s0_.custom_js AS custom_js_11, s0_.is_published AS is_published_12, s0_.is_system AS is_system_13, s0_.hero_slides AS hero_slides_14, s0_.popup_enabled AS popup_enabled_15, s0_.popup_content AS popup_content_16, s0_.popup_position AS popup_position_17, s0_.popup_delay_seconds AS popup_delay_seconds_18, s0_.popup_starts_at AS popup_starts_at_19, s0_.popup_ends_at AS popup_ends_at_20, s0_.listing_default_arrival AS listing_default_arrival_21, s0_.listing_default_departure AS listing_default_departure_22, s0_.listing_offers_enabled AS listing_offers_enabled_23, s0_.listing_guests_min AS listing_guests_min_24, s0_.listing_path_suffix AS listing_path_suffix_25, s0_.special_offer_home_promoted AS special_offer_home_promoted_26, s0_.special_offer_home_sort_order AS special_offer_home_sort_order_27, s0_.special_offer_list_sort AS special_offer_list_sort_28, s0_.special_offer_tile_image AS special_offer_tile_image_29, s0_.special_offer_tile_variants AS special_offer_tile_variants_30, s0_.created_at AS created_at_31, s0_.updated_at AS updated_at_32, s0_.meta_title AS meta_title_33, s0_.meta_description AS meta_description_34, s0_.canonical_url AS canonical_url_35, s0_.robots AS robots_36, s0_.og_title AS og_title_37, s0_.og_description AS og_description_38, s0_.og_image AS og_image_39, m1_.id AS id_40, m1_.label AS label_41, m1_.link_type AS link_type_42, m1_.route_name AS route_name_43, m1_.route_params AS route_params_44, m1_.url AS url_45, m1_.placements AS placements_46, m1_.position AS position_47, m1_.is_active AS is_active_48, m1_.open_in_new_tab AS open_in_new_tab_49, m1_.subtitle AS subtitle_50, m1_.icon_tabler AS icon_tabler_51, m1_.floating_corner AS floating_corner_52, m1_.handler_key AS handler_key_53, m1_.show_favorites_badge AS show_favorites_badge_54, m1_.created_at AS created_at_55, m1_.updated_at AS updated_at_56, m2_.id AS id_57, m2_.label AS label_58, m2_.link_type AS link_type_59, m2_.route_name AS route_name_60, m2_.route_params AS route_params_61, m2_.url AS url_62, m2_.placements AS placements_63, m2_.position AS position_64, m2_.is_active AS is_active_65, m2_.open_in_new_tab AS open_in_new_tab_66, m2_.subtitle AS subtitle_67, m2_.icon_tabler AS icon_tabler_68, m2_.floating_corner AS floating_corner_69, m2_.handler_key AS handler_key_70, m2_.show_favorites_badge AS show_favorites_badge_71, m2_.created_at AS created_at_72, m2_.updated_at AS updated_at_73, s0_.id AS id_74, s0_.page_key AS page_key_75, s0_.slug AS slug_76, s0_.path AS path_77, s0_.title AS title_78, s0_.front_module AS front_module_79, s0_.content AS content_80, s0_.content_edit_mode AS content_edit_mode_81, s0_.cms_intro_headings AS cms_intro_headings_82, s0_.faq_content AS faq_content_83, s0_.custom_css AS custom_css_84, s0_.custom_js AS custom_js_85, s0_.is_published AS is_published_86, s0_.is_system AS is_system_87, s0_.hero_slides AS hero_slides_88, s0_.popup_enabled AS popup_enabled_89, s0_.popup_content AS popup_content_90, s0_.popup_position AS popup_position_91, s0_.popup_delay_seconds AS popup_delay_seconds_92, s0_.popup_starts_at AS popup_starts_at_93, s0_.popup_ends_at AS popup_ends_at_94, s0_.listing_default_arrival AS listing_default_arrival_95, s0_.listing_default_departure AS listing_default_departure_96, s0_.listing_offers_enabled AS listing_offers_enabled_97, s0_.listing_guests_min AS listing_guests_min_98, s0_.listing_path_suffix AS listing_path_suffix_99, s0_.special_offer_home_promoted AS special_offer_home_promoted_100, s0_.special_offer_home_sort_order AS special_offer_home_sort_order_101, s0_.special_offer_list_sort AS special_offer_list_sort_102, s0_.special_offer_tile_image AS special_offer_tile_image_103, s0_.special_offer_tile_variants AS special_offer_tile_variants_104, s0_.created_at AS created_at_105, s0_.updated_at AS updated_at_106, s0_.meta_title AS meta_title_107, s0_.meta_description AS meta_description_108, s0_.canonical_url AS canonical_url_109, s0_.robots AS robots_110, s0_.og_title AS og_title_111, s0_.og_description AS og_description_112, s0_.og_image AS og_image_113, m1_.id AS id_114, m1_.label AS label_115, m1_.link_type AS link_type_116, m1_.route_name AS route_name_117, m1_.route_params AS route_params_118, m1_.url AS url_119, m1_.placements AS placements_120, m1_.position AS position_121, m1_.is_active AS is_active_122, m1_.open_in_new_tab AS open_in_new_tab_123, m1_.subtitle AS subtitle_124, m1_.icon_tabler AS icon_tabler_125, m1_.floating_corner AS floating_corner_126, m1_.handler_key AS handler_key_127, m1_.show_favorites_badge AS show_favorites_badge_128, m1_.created_at AS created_at_129, m1_.updated_at AS updated_at_130, s0_.listing_category_id AS listing_category_id_131, s0_.listing_location_id AS listing_location_id_132, s0_.listing_residence_id AS listing_residence_id_133, m1_.seo_page_id AS seo_page_id_134, m1_.parent_id AS parent_id_135, m2_.seo_page_id AS seo_page_id_136, m2_.parent_id AS parent_id_137 FROM menu_items m2_ LEFT JOIN seo_pages s0_ ON m2_.seo_page_id = s0_.id LEFT JOIN menu_items m1_ ON m2_.parent_id = m1_.id WHERE m2_.is_active = 1 ORDER BY m2_.position ASC, m2_.id ASC;
|