Symfony Profiler

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

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 = '/oferty/apartament/zakopane/apartament-bystra-woda' AND t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.lead AS lead_5,
  t0.country AS country_6,
  t0.city AS city_7,
  t0.center_lat AS center_lat_8,
  t0.center_lng AS center_lng_9,
  t0.image_path AS image_path_10,
  t0.image_variants AS image_variants_11,
  t0.featured AS featured_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.meta_title AS meta_title_15,
  t0.meta_description AS meta_description_16,
  t0.canonical_url AS canonical_url_17,
  t0.robots AS robots_18,
  t0.og_title AS og_title_19,
  t0.og_description AS og_description_20,
  t0.og_image AS og_image_21
FROM
  locations t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.lead AS lead_5, t0.country AS country_6, t0.city AS city_7, t0.center_lat AS center_lat_8, t0.center_lng AS center_lng_9, t0.image_path AS image_path_10, t0.image_variants AS image_variants_11, t0.featured AS featured_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.meta_title AS meta_title_15, t0.meta_description AS meta_description_16, t0.canonical_url AS canonical_url_17, t0.robots AS robots_18, t0.og_title AS og_title_19, t0.og_description AS og_description_20, t0.og_image AS og_image_21 FROM locations t0 WHERE t0.slug = 'zakopane' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.position AS position_4
FROM
  room_type_categories t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.position AS position_4 FROM room_type_categories t0 WHERE t0.slug = 'apartament' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type_id AS type_id_2,
  t0.oid AS oid_3,
  t0.title AS title_4,
  t0.advert AS advert_5,
  t0.single_beds AS single_beds_6,
  t0.double_beds AS double_beds_7,
  t0.sofa_beds AS sofa_beds_8,
  t0.sofa_single_beds AS sofa_single_beds_9,
  t0.fold_out_armchairs AS fold_out_armchairs_10,
  t0.extra_beds AS extra_beds_11,
  t0.area AS area_12,
  t0.bedroom_count AS bedroom_count_13,
  t0.bathroom_count AS bathroom_count_14,
  t0.rooms_count AS rooms_count_15,
  t0.floor AS floor_16,
  t0.floor_display AS floor_display_17,
  t0.distance_from_center AS distance_from_center_18,
  t0.tourist_tax AS tourist_tax_19,
  t0.deposit AS deposit_20,
  t0.has_balcony_terrace AS has_balcony_terrace_21,
  t0.exposure AS exposure_22,
  t0.check_in_out_hours AS check_in_out_hours_23,
  t0.garage AS garage_24,
  t0.vat_invoice AS vat_invoice_25,
  t0.price_from AS price_from_26,
  t0.address AS address_27,
  t0.contact_phone AS contact_phone_28,
  t0.city AS city_29,
  t0.zip AS zip_30,
  t0.google_x AS google_x_31,
  t0.google_y AS google_y_32,
  t0.yt_url AS yt_url_33,
  t0.panorama_iframe_html AS panorama_iframe_html_34,
  t0.page_custom_css AS page_custom_css_35,
  t0.page_custom_js AS page_custom_js_36,
  t0.photo AS photo_37,
  t0.photo_s AS photo_s_38,
  t0.category AS category_39,
  t0.tags AS tags_40,
  t0.niceurl AS niceurl_41,
  t0.extrainfo AS extrainfo_42,
  t0.promo AS promo_43,
  t0.description AS description_44,
  t0.instructions AS instructions_45,
  t0.meta_title AS meta_title_46,
  t0.meta_description AS meta_description_47,
  t0.is_active AS is_active_48,
  t0.listing_sort_order AS listing_sort_order_49,
  t0.discount AS discount_50,
  t0.show_discount AS show_discount_51,
  t0.listing_badge_new AS listing_badge_new_52,
  t0.listing_badge_recommend AS listing_badge_recommend_53,
  t0.listing_badge_highlight AS listing_badge_highlight_54,
  t0.pin_home_featured AS pin_home_featured_55,
  t0.pin_home_day_offer AS pin_home_day_offer_56,
  t0.pin_home_recent AS pin_home_recent_57,
  t0.home_featured_sort_order AS home_featured_sort_order_58,
  t0.home_day_offer_sort_order AS home_day_offer_sort_order_59,
  t0.home_recent_sort_order AS home_recent_sort_order_60,
  t0.home_tile_variant AS home_tile_variant_61,
  t0.photos AS photos_62,
  t0.raw_data AS raw_data_63,
  t0.created_at AS created_at_64,
  t0.updated_at AS updated_at_65,
  t0.hotres_account_id AS hotres_account_id_66,
  t0.location_id AS location_id_67,
  t0.category_id AS category_id_68
FROM
  hotres_room_types t0
WHERE
  t0.location_id = ?
  AND t0.niceurl = ?
  AND t0.category_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.type_id AS type_id_2, t0.oid AS oid_3, t0.title AS title_4, t0.advert AS advert_5, t0.single_beds AS single_beds_6, t0.double_beds AS double_beds_7, t0.sofa_beds AS sofa_beds_8, t0.sofa_single_beds AS sofa_single_beds_9, t0.fold_out_armchairs AS fold_out_armchairs_10, t0.extra_beds AS extra_beds_11, t0.area AS area_12, t0.bedroom_count AS bedroom_count_13, t0.bathroom_count AS bathroom_count_14, t0.rooms_count AS rooms_count_15, t0.floor AS floor_16, t0.floor_display AS floor_display_17, t0.distance_from_center AS distance_from_center_18, t0.tourist_tax AS tourist_tax_19, t0.deposit AS deposit_20, t0.has_balcony_terrace AS has_balcony_terrace_21, t0.exposure AS exposure_22, t0.check_in_out_hours AS check_in_out_hours_23, t0.garage AS garage_24, t0.vat_invoice AS vat_invoice_25, t0.price_from AS price_from_26, t0.address AS address_27, t0.contact_phone AS contact_phone_28, t0.city AS city_29, t0.zip AS zip_30, t0.google_x AS google_x_31, t0.google_y AS google_y_32, t0.yt_url AS yt_url_33, t0.panorama_iframe_html AS panorama_iframe_html_34, t0.page_custom_css AS page_custom_css_35, t0.page_custom_js AS page_custom_js_36, t0.photo AS photo_37, t0.photo_s AS photo_s_38, t0.category AS category_39, t0.tags AS tags_40, t0.niceurl AS niceurl_41, t0.extrainfo AS extrainfo_42, t0.promo AS promo_43, t0.description AS description_44, t0.instructions AS instructions_45, t0.meta_title AS meta_title_46, t0.meta_description AS meta_description_47, t0.is_active AS is_active_48, t0.listing_sort_order AS listing_sort_order_49, t0.discount AS discount_50, t0.show_discount AS show_discount_51, t0.listing_badge_new AS listing_badge_new_52, t0.listing_badge_recommend AS listing_badge_recommend_53, t0.listing_badge_highlight AS listing_badge_highlight_54, t0.pin_home_featured AS pin_home_featured_55, t0.pin_home_day_offer AS pin_home_day_offer_56, t0.pin_home_recent AS pin_home_recent_57, t0.home_featured_sort_order AS home_featured_sort_order_58, t0.home_day_offer_sort_order AS home_day_offer_sort_order_59, t0.home_recent_sort_order AS home_recent_sort_order_60, t0.home_tile_variant AS home_tile_variant_61, t0.photos AS photos_62, t0.raw_data AS raw_data_63, t0.created_at AS created_at_64, t0.updated_at AS updated_at_65, t0.hotres_account_id AS hotres_account_id_66, t0.location_id AS location_id_67, t0.category_id AS category_id_68 FROM hotres_room_types t0 WHERE t0.location_id = 4 AND t0.niceurl = 'apartament-bystra-woda' AND t0.category_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_active AS is_active_3,
  t0.auth_code AS auth_code_4,
  t0.api_key AS api_key_5,
  t0.webhook_secret AS webhook_secret_6,
  t0.last_synced_at AS last_synced_at_7,
  t0.last_sync_status AS last_sync_status_8,
  t0.last_sync_message AS last_sync_message_9,
  t0.last_object_data AS last_object_data_10,
  t0.last_room_types_data AS last_room_types_data_11,
  t0.last_room_type_details_data AS last_room_type_details_data_12,
  t0.last_facilities_definitions_data AS last_facilities_definitions_data_13,
  t0.last_rates_data AS last_rates_data_14,
  t0.default_address AS default_address_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.default_location_id AS default_location_id_18
FROM
  hotres_accounts t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.auth_code AS auth_code_4, t0.api_key AS api_key_5, t0.webhook_secret AS webhook_secret_6, t0.last_synced_at AS last_synced_at_7, t0.last_sync_status AS last_sync_status_8, t0.last_sync_message AS last_sync_message_9, t0.last_object_data AS last_object_data_10, t0.last_room_types_data AS last_room_types_data_11, t0.last_room_type_details_data AS last_room_type_details_data_12, t0.last_facilities_definitions_data AS last_facilities_definitions_data_13, t0.last_rates_data AS last_rates_data_14, t0.default_address AS default_address_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.default_location_id AS default_location_id_18 FROM hotres_accounts t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.alt AS alt_3,
  t0.position AS position_4,
  t0.is_main AS is_main_5,
  t0.source_type AS source_type_6,
  t0.source_url AS source_url_7,
  t0.variants AS variants_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.room_type_id AS room_type_id_11
FROM
  hotres_room_type_images t0
WHERE
  t0.room_type_id = ?
ORDER BY
  t0.position ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.position AS position_4, t0.is_main AS is_main_5, t0.source_type AS source_type_6, t0.source_url AS source_url_7, t0.variants AS variants_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.room_type_id AS room_type_id_11 FROM hotres_room_type_images t0 WHERE t0.room_type_id = 119 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.is_global AS is_global_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.apartment_id AS apartment_id_8,
  t0.complex_id AS complex_id_9,
  t0.room_type_id AS room_type_id_10,
  t0.location_id AS location_id_11,
  t0.residence_id AS residence_id_12
FROM
  faq_items t0
WHERE
  t0.room_type_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.is_global AS is_global_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.apartment_id AS apartment_id_8, t0.complex_id AS complex_id_9, t0.room_type_id AS room_type_id_10, t0.location_id AS location_id_11, t0.residence_id AS residence_id_12 FROM faq_items t0 WHERE t0.room_type_id = 119 ORDER BY t0.position ASC, t0.id ASC;

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:apartments:show:119' LIMIT 1;

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 = 75 ORDER BY t0.position ASC, t0.id ASC;

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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.category AS category_4,
  t0.lead AS lead_5,
  t0.description AS description_6,
  t0.is_active AS is_active_7,
  t0.image AS image_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.meta_title AS meta_title_13,
  t0.meta_description AS meta_description_14,
  t0.canonical_url AS canonical_url_15,
  t0.robots AS robots_16,
  t0.og_title AS og_title_17,
  t0.og_description AS og_description_18,
  t0.og_image AS og_image_19,
  t0.location_id AS location_id_20
FROM
  attractions t0
WHERE
  t0.location_id = ?
  AND t0.is_active = ?
ORDER BY
  t0.id DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.category AS category_4, t0.lead AS lead_5, t0.description AS description_6, t0.is_active AS is_active_7, t0.image AS image_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.canonical_url AS canonical_url_15, t0.robots AS robots_16, t0.og_title AS og_title_17, t0.og_description AS og_description_18, t0.og_image AS og_image_19, t0.location_id AS location_id_20 FROM attractions t0 WHERE t0.location_id = 4 AND t0.is_active = 1 ORDER BY t0.id DESC LIMIT 4;