Symfony Profiler

[
  "route" => "front_apartments_show"
  "route_parameters" => [
    "_route" => "front_apartments_show"
    "_controller" => "App\Controller\Front\RoomController::show"
    "categorySlug" => "apartment"
    "locationSlug" => "koscielisko-15f"
    "apartmentSlug" => "apartament-5-widokowka"
  ]
  "request_uri" => "https://za.redroxcms.com/oferty/apartment/koscielisko-15f/apartament-5-widokowka"
  "method" => "GET"
]

[
  "params" => [
    "use_savepoints" => true
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "54.36.174.179"
    "port" => 3310
    "user" => "zakopaneapartamenty"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "zakopaneapartamenty"
    "serverVersion" => "10.10.6-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "/oferty/apartment/koscielisko-15f/apartament-5-widokowka"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#666
      +name: "BOOLEAN"
    }
  ]
]

[
  "firewall_name" => "main"
  "authenticators" => 2
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "sql" => "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"
  "params" => [
    1 => "koscielisko-15f"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "default"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#663
      +name: "STRING"
    }
  ]
]

[
  "sql" => "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"
]