Symfony Profiler

SELECT
  w0_.host AS host_0,
  w0_.schemes AS schemes_1,
  w0_.methods AS methods_2,
  w0_.defaults AS defaults_3,
  w0_.requirements AS requirements_4,
  w0_.options AS options_5,
  w0_.condition_expr AS condition_expr_6,
  w0_.variable_pattern AS variable_pattern_7,
  w0_.staticPrefix AS staticPrefix_8,
  w0_.id AS id_9,
  w0_.name AS name_10,
  w0_.position AS position_11,
  w0_.canonical_name AS canonical_name_12,
  w0_.tag AS tag_13,
  w0_.sitemapeable AS sitemapeable_14,
  w0_.type AS type_15,
  w0_.seo_meta_data AS seo_meta_data_16,
  w0_.content_class AS content_class_17,
  w0_.content_id AS content_id_18,
  w0_.redirect_target AS redirect_target_19,
  w0_.autoRoute AS autoRoute_20
FROM
  wam_routing_route w0_
WHERE
  (
    w0_.canonical_name = ?
    AND w0_.type = ?
  )
  AND w0_.autoRoute IN ('0', '1')

SELECT w0_.host AS host_0, w0_.schemes AS schemes_1, w0_.methods AS methods_2, w0_.defaults AS defaults_3, w0_.requirements AS requirements_4, w0_.options AS options_5, w0_.condition_expr AS condition_expr_6, w0_.variable_pattern AS variable_pattern_7, w0_.staticPrefix AS staticPrefix_8, w0_.id AS id_9, w0_.name AS name_10, w0_.position AS position_11, w0_.canonical_name AS canonical_name_12, w0_.tag AS tag_13, w0_.sitemapeable AS sitemapeable_14, w0_.type AS type_15, w0_.seo_meta_data AS seo_meta_data_16, w0_.content_class AS content_class_17, w0_.content_id AS content_id_18, w0_.redirect_target AS redirect_target_19, w0_.autoRoute AS autoRoute_20 FROM wam_routing_route w0_ WHERE (w0_.canonical_name = 'wam_routing_url_1' AND w0_.type = 'cmf_routing_auto.primary') AND w0_.autoRoute IN ('0', '1');

SELECT
  t0.reference AS reference_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.parent_id AS parent_id_5,
  t0.category_id AS category_id_6,
  t0.thumbnail_id AS thumbnail_id_7,
  t0.dtype,
  t0.mime_type AS mime_type_8,
  t0.original_format AS original_format_9
FROM
  app_media_media t0
WHERE
  t0.id = ?
  AND t0.dtype IN (
    'media', 'file', 'vimeovideo', 'youtubevideo'
  )

SELECT t0.reference AS reference_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.parent_id AS parent_id_5, t0.category_id AS category_id_6, t0.thumbnail_id AS thumbnail_id_7, t0.dtype, t0.mime_type AS mime_type_8, t0.original_format AS original_format_9 FROM app_media_media t0 WHERE t0.id = 1702 AND t0.dtype IN ('media', 'file', 'vimeovideo', 'youtubevideo');

SELECT
  t0.title AS title_1,
  t0.menu_title AS menu_title_2,
  t0.header_title AS header_title_3,
  t0.block_title1 AS block_title1_4,
  t0.block_anchor1 AS block_anchor1_5,
  t0.block_anchor2 AS block_anchor2_6,
  t0.block_anchor3 AS block_anchor3_7,
  t0.block_anchor4 AS block_anchor4_8,
  t0.downloads_anchor AS downloads_anchor_9,
  t0.block_content1 AS block_content1_10,
  t0.block_title2 AS block_title2_11,
  t0.block_content2 AS block_content2_12,
  t0.block_title3 AS block_title3_13,
  t0.block_content3 AS block_content3_14,
  t0.block_title4 AS block_title4_15,
  t0.block_content4 AS block_content4_16,
  t0.downloadable_item AS downloadable_item_17,
  t0.cta_link_title AS cta_link_title_18,
  t0.cta_link_url AS cta_link_url_19,
  t0.cta_text AS cta_text_20,
  t0.cta_file_title1 AS cta_file_title1_21,
  t0.cta_file_title2 AS cta_file_title2_22,
  t0.cta_file_title3 AS cta_file_title3_23,
  t0.cta_file_title4 AS cta_file_title4_24,
  t0.second_cta_file_title1 AS second_cta_file_title1_25,
  t0.second_cta_file_title2 AS second_cta_file_title2_26,
  t0.second_cta_file_title3 AS second_cta_file_title3_27,
  t0.second_cta_file_title4 AS second_cta_file_title4_28,
  t0.third_cta_file_title1 AS third_cta_file_title1_29,
  t0.third_cta_file_title2 AS third_cta_file_title2_30,
  t0.third_cta_file_title3 AS third_cta_file_title3_31,
  t0.third_cta_file_title4 AS third_cta_file_title4_32,
  t0.pop_up_title1 AS pop_up_title1_33,
  t0.pop_up_title2 AS pop_up_title2_34,
  t0.pop_up_title3 AS pop_up_title3_35,
  t0.pop_up_title4 AS pop_up_title4_36,
  t0.second_pop_up_title1 AS second_pop_up_title1_37,
  t0.second_pop_up_title2 AS second_pop_up_title2_38,
  t0.second_pop_up_title3 AS second_pop_up_title3_39,
  t0.second_pop_up_title4 AS second_pop_up_title4_40,
  t0.third_pop_up_title1 AS third_pop_up_title1_41,
  t0.third_pop_up_title2 AS third_pop_up_title2_42,
  t0.third_pop_up_title3 AS third_pop_up_title3_43,
  t0.third_pop_up_title4 AS third_pop_up_title4_44,
  t0.cta_link_title1 AS cta_link_title1_45,
  t0.cta_link_title2 AS cta_link_title2_46,
  t0.cta_link_title3 AS cta_link_title3_47,
  t0.cta_link_title4 AS cta_link_title4_48,
  t0.cta_link1 AS cta_link1_49,
  t0.cta_link2 AS cta_link2_50,
  t0.cta_link3 AS cta_link3_51,
  t0.cta_link4 AS cta_link4_52,
  t0.second_cta_link_title1 AS second_cta_link_title1_53,
  t0.second_cta_link_title2 AS second_cta_link_title2_54,
  t0.second_cta_link_title3 AS second_cta_link_title3_55,
  t0.second_cta_link_title4 AS second_cta_link_title4_56,
  t0.second_cta_link1 AS second_cta_link1_57,
  t0.second_cta_link2 AS second_cta_link2_58,
  t0.second_cta_link3 AS second_cta_link3_59,
  t0.second_cta_link4 AS second_cta_link4_60,
  t0.third_cta_link_title1 AS third_cta_link_title1_61,
  t0.third_cta_link_title2 AS third_cta_link_title2_62,
  t0.third_cta_link_title3 AS third_cta_link_title3_63,
  t0.third_cta_link_title4 AS third_cta_link_title4_64,
  t0.third_cta_link1 AS third_cta_link1_65,
  t0.third_cta_link2 AS third_cta_link2_66,
  t0.third_cta_link3 AS third_cta_link3_67,
  t0.third_cta_link4 AS third_cta_link4_68,
  t0.form_title AS form_title_69,
  t0.form_intro AS form_intro_70,
  t0.form_html AS form_html_71,
  t0.locale AS locale_72,
  t0.id AS id_73,
  t0.slug AS slug_74,
  t0.cta_file1_id AS cta_file1_id_75,
  t0.cta_file2_id AS cta_file2_id_76,
  t0.cta_file3_id AS cta_file3_id_77,
  t0.cta_file4_id AS cta_file4_id_78,
  t0.second_cta_file1_id AS second_cta_file1_id_79,
  t0.second_cta_file2_id AS second_cta_file2_id_80,
  t0.second_cta_file3_id AS second_cta_file3_id_81,
  t0.second_cta_file4_id AS second_cta_file4_id_82,
  t0.third_cta_file1_id AS third_cta_file1_id_83,
  t0.third_cta_file2_id AS third_cta_file2_id_84,
  t0.third_cta_file3_id AS third_cta_file3_id_85,
  t0.third_cta_file4_id AS third_cta_file4_id_86,
  t0.translatable_id AS translatable_id_87
FROM
  app_experience_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.title AS title_1, t0.menu_title AS menu_title_2, t0.header_title AS header_title_3, t0.block_title1 AS block_title1_4, t0.block_anchor1 AS block_anchor1_5, t0.block_anchor2 AS block_anchor2_6, t0.block_anchor3 AS block_anchor3_7, t0.block_anchor4 AS block_anchor4_8, t0.downloads_anchor AS downloads_anchor_9, t0.block_content1 AS block_content1_10, t0.block_title2 AS block_title2_11, t0.block_content2 AS block_content2_12, t0.block_title3 AS block_title3_13, t0.block_content3 AS block_content3_14, t0.block_title4 AS block_title4_15, t0.block_content4 AS block_content4_16, t0.downloadable_item AS downloadable_item_17, t0.cta_link_title AS cta_link_title_18, t0.cta_link_url AS cta_link_url_19, t0.cta_text AS cta_text_20, t0.cta_file_title1 AS cta_file_title1_21, t0.cta_file_title2 AS cta_file_title2_22, t0.cta_file_title3 AS cta_file_title3_23, t0.cta_file_title4 AS cta_file_title4_24, t0.second_cta_file_title1 AS second_cta_file_title1_25, t0.second_cta_file_title2 AS second_cta_file_title2_26, t0.second_cta_file_title3 AS second_cta_file_title3_27, t0.second_cta_file_title4 AS second_cta_file_title4_28, t0.third_cta_file_title1 AS third_cta_file_title1_29, t0.third_cta_file_title2 AS third_cta_file_title2_30, t0.third_cta_file_title3 AS third_cta_file_title3_31, t0.third_cta_file_title4 AS third_cta_file_title4_32, t0.pop_up_title1 AS pop_up_title1_33, t0.pop_up_title2 AS pop_up_title2_34, t0.pop_up_title3 AS pop_up_title3_35, t0.pop_up_title4 AS pop_up_title4_36, t0.second_pop_up_title1 AS second_pop_up_title1_37, t0.second_pop_up_title2 AS second_pop_up_title2_38, t0.second_pop_up_title3 AS second_pop_up_title3_39, t0.second_pop_up_title4 AS second_pop_up_title4_40, t0.third_pop_up_title1 AS third_pop_up_title1_41, t0.third_pop_up_title2 AS third_pop_up_title2_42, t0.third_pop_up_title3 AS third_pop_up_title3_43, t0.third_pop_up_title4 AS third_pop_up_title4_44, t0.cta_link_title1 AS cta_link_title1_45, t0.cta_link_title2 AS cta_link_title2_46, t0.cta_link_title3 AS cta_link_title3_47, t0.cta_link_title4 AS cta_link_title4_48, t0.cta_link1 AS cta_link1_49, t0.cta_link2 AS cta_link2_50, t0.cta_link3 AS cta_link3_51, t0.cta_link4 AS cta_link4_52, t0.second_cta_link_title1 AS second_cta_link_title1_53, t0.second_cta_link_title2 AS second_cta_link_title2_54, t0.second_cta_link_title3 AS second_cta_link_title3_55, t0.second_cta_link_title4 AS second_cta_link_title4_56, t0.second_cta_link1 AS second_cta_link1_57, t0.second_cta_link2 AS second_cta_link2_58, t0.second_cta_link3 AS second_cta_link3_59, t0.second_cta_link4 AS second_cta_link4_60, t0.third_cta_link_title1 AS third_cta_link_title1_61, t0.third_cta_link_title2 AS third_cta_link_title2_62, t0.third_cta_link_title3 AS third_cta_link_title3_63, t0.third_cta_link_title4 AS third_cta_link_title4_64, t0.third_cta_link1 AS third_cta_link1_65, t0.third_cta_link2 AS third_cta_link2_66, t0.third_cta_link3 AS third_cta_link3_67, t0.third_cta_link4 AS third_cta_link4_68, t0.form_title AS form_title_69, t0.form_intro AS form_intro_70, t0.form_html AS form_html_71, t0.locale AS locale_72, t0.id AS id_73, t0.slug AS slug_74, t0.cta_file1_id AS cta_file1_id_75, t0.cta_file2_id AS cta_file2_id_76, t0.cta_file3_id AS cta_file3_id_77, t0.cta_file4_id AS cta_file4_id_78, t0.second_cta_file1_id AS second_cta_file1_id_79, t0.second_cta_file2_id AS second_cta_file2_id_80, t0.second_cta_file3_id AS second_cta_file3_id_81, t0.second_cta_file4_id AS second_cta_file4_id_82, t0.third_cta_file1_id AS third_cta_file1_id_83, t0.third_cta_file2_id AS third_cta_file2_id_84, t0.third_cta_file3_id AS third_cta_file3_id_85, t0.third_cta_file4_id AS third_cta_file4_id_86, t0.translatable_id AS translatable_id_87 FROM app_experience_translation t0 WHERE t0.translatable_id = 8;

SELECT
  a0_.prominent AS prominent_0,
  a0_.is_prominent_text_up_on_banner AS is_prominent_text_up_on_banner_1,
  a0_.is_prominent_text_up_on_cta AS is_prominent_text_up_on_cta_2,
  a0_.selected_locale AS selected_locale_3,
  a0_.id AS id_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.date_start AS date_start_7,
  a0_.date_end AS date_end_8,
  a0_.status AS status_9,
  a0_.author_id AS author_id_10,
  a0_.image_id AS image_id_11,
  a0_.cta_image_banner_id AS cta_image_banner_id_12,
  a0_.cta_image_id AS cta_image_id_13,
  a0_.category_id AS category_id_14
FROM
  app_news_post a0_
  INNER JOIN app_news_post_translation a1_ ON a0_.id = a1_.translatable_id
WHERE
  a0_.status = ?
  AND a0_.date_start <= ?
  AND (
    (
      a0_.date_end > ?
      OR a0_.date_end IS NULL
    )
  )
  AND a1_.locale = ?
ORDER BY
  a0_.date_start DESC
LIMIT
  5

SELECT a0_.prominent AS prominent_0, a0_.is_prominent_text_up_on_banner AS is_prominent_text_up_on_banner_1, a0_.is_prominent_text_up_on_cta AS is_prominent_text_up_on_cta_2, a0_.selected_locale AS selected_locale_3, a0_.id AS id_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.date_start AS date_start_7, a0_.date_end AS date_end_8, a0_.status AS status_9, a0_.author_id AS author_id_10, a0_.image_id AS image_id_11, a0_.cta_image_banner_id AS cta_image_banner_id_12, a0_.cta_image_id AS cta_image_id_13, a0_.category_id AS category_id_14 FROM app_news_post a0_ INNER JOIN app_news_post_translation a1_ ON a0_.id = a1_.translatable_id WHERE a0_.status = 'PUBLISHED' AND a0_.date_start <= '2024-11-15 13:51:05' AND ((a0_.date_end > '2024-11-15 13:51:05' OR a0_.date_end IS NULL)) AND a1_.locale = 'es' ORDER BY a0_.date_start DESC LIMIT 5;

SELECT
  a0_.sku AS sku_0,
  a0_.price AS price_1,
  a0_.base_purchasable AS base_purchasable_2,
  a0_.id AS id_3,
  a0_.shipping_cost AS shipping_cost_4,
  a0_.stock AS stock_5,
  a0_.stock_enabled AS stock_enabled_6,
  a0_.date_start AS date_start_7,
  a0_.date_end AS date_end_8,
  a0_.status AS status_9,
  a0_.promoted AS promoted_10,
  a0_.sales AS sales_11,
  a0_.contact_email AS contact_email_12,
  a0_.contact_phone AS contact_phone_13,
  a0_.title_color AS title_color_14,
  a0_.short_text_color AS short_text_color_15,
  a0_.purchasable_type AS purchasable_type_16,
  a0_.tax_id AS tax_id_17,
  a0_.image_id AS image_id_18,
  a0_.hotel_id AS hotel_id_19,
  a0_.gallery_id AS gallery_id_20
FROM
  app_ecommerce_purchasable a0_
WHERE
  (
    a0_.status = ?
    AND a0_.date_start <= ?
    AND (
      (
        a0_.date_end > ?
        OR a0_.date_end IS NULL
      )
    )
  )
  AND a0_.purchasable_type IN ('GIF')
ORDER BY
  a0_.sales DESC
LIMIT
  5

SELECT a0_.sku AS sku_0, a0_.price AS price_1, a0_.base_purchasable AS base_purchasable_2, a0_.id AS id_3, a0_.shipping_cost AS shipping_cost_4, a0_.stock AS stock_5, a0_.stock_enabled AS stock_enabled_6, a0_.date_start AS date_start_7, a0_.date_end AS date_end_8, a0_.status AS status_9, a0_.promoted AS promoted_10, a0_.sales AS sales_11, a0_.contact_email AS contact_email_12, a0_.contact_phone AS contact_phone_13, a0_.title_color AS title_color_14, a0_.short_text_color AS short_text_color_15, a0_.purchasable_type AS purchasable_type_16, a0_.tax_id AS tax_id_17, a0_.image_id AS image_id_18, a0_.hotel_id AS hotel_id_19, a0_.gallery_id AS gallery_id_20 FROM app_ecommerce_purchasable a0_ WHERE (a0_.status = 'PUBLISHED' AND a0_.date_start <= '2024-11-15 13:51:05' AND ((a0_.date_end > '2024-11-15 13:51:05' OR a0_.date_end IS NULL))) AND a0_.purchasable_type IN ('GIF') ORDER BY a0_.sales DESC LIMIT 5;

SELECT
  a0_.locale AS locale_0,
  a0_.author_name AS author_name_1,
  a0_.title AS title_2,
  a0_.body AS body_3,
  a0_.publication_place AS publication_place_4,
  a0_.location AS location_5,
  a0_.stars AS stars_6,
  a0_.landing AS landing_7,
  a0_.id AS id_8,
  a0_.created_at AS created_at_9,
  a0_.updated_at AS updated_at_10,
  a0_.position AS position_11,
  a0_.date_start AS date_start_12,
  a0_.date_end AS date_end_13,
  a0_.status AS status_14,
  a0_.category_id AS category_id_15,
  a0_.hotel_id AS hotel_id_16,
  a0_.author_image_id AS author_image_id_17
FROM
  app_web_content_review a0_
WHERE
  a0_.status = ?
  AND a0_.date_start <= ?
  AND (
    (
      a0_.date_end > ?
      OR a0_.date_end IS NULL
    )
  )
  AND a0_.locale = ?
ORDER BY
  a0_.position ASC

SELECT a0_.locale AS locale_0, a0_.author_name AS author_name_1, a0_.title AS title_2, a0_.body AS body_3, a0_.publication_place AS publication_place_4, a0_.location AS location_5, a0_.stars AS stars_6, a0_.landing AS landing_7, a0_.id AS id_8, a0_.created_at AS created_at_9, a0_.updated_at AS updated_at_10, a0_.position AS position_11, a0_.date_start AS date_start_12, a0_.date_end AS date_end_13, a0_.status AS status_14, a0_.category_id AS category_id_15, a0_.hotel_id AS hotel_id_16, a0_.author_image_id AS author_image_id_17 FROM app_web_content_review a0_ WHERE a0_.status = 'PUBLISHED' AND a0_.date_start <= '2024-11-15 13:51:05' AND ((a0_.date_end > '2024-11-15 13:51:05' OR a0_.date_end IS NULL)) AND a0_.locale = 'es' ORDER BY a0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.canonical_name AS canonical_name_2,
  t0.name AS name_3,
  t0.hidden AS hidden_4,
  t0.webmaker_template AS webmaker_template_5,
  t0.use_custom_html AS use_custom_html_6,
  t0.attributes AS attributes_7,
  t0.block_type_for_filter AS block_type_for_filter_8,
  t0.blockType,
  t0.image_id AS image_id_9,
  t0.gallery_id AS gallery_id_10,
  t0.menu_zone AS menu_zone_11,
  t0.banner_zone AS banner_zone_12,
  t0.facebook_name AS facebook_name_13,
  t0.facebook_url AS facebook_url_14,
  t0.twitter_name AS twitter_name_15,
  t0.twitter_url AS twitter_url_16,
  t0.instagram_name AS instagram_name_17,
  t0.instagram_url AS instagram_url_18,
  t0.google_plus_name AS google_plus_name_19,
  t0.google_plus_url AS google_plus_url_20,
  t0.linkedin_name AS linkedin_name_21,
  t0.linkedin_url AS linkedin_url_22,
  t0.youtube_name AS youtube_name_23,
  t0.youtube_url AS youtube_url_24,
  t0.image_id AS image_id_25,
  t0.orderDirection AS orderDirection_26,
  t0.orderField AS orderField_27,
  t0.entity AS entity_28,
  t0.limitNumber AS limitNumber_29,
  t0.criteria AS criteria_30,
  t0.icon_class AS icon_class_31,
  t0.image_id AS image_id_32,
  t0.icon_image_id AS icon_image_id_33,
  t0.canonical_route_name AS canonical_route_name_34,
  t0.latitude AS latitude_35,
  t0.longitude AS longitude_36,
  t0.canonical_route_name AS canonical_route_name_37,
  t0.image_id AS image_id_38,
  t0.css AS css_39,
  t0.js AS js_40,
  t0.download_document AS download_document_41,
  t0.document_id AS document_id_42,
  t0.graph_type AS graph_type_43,
  t0.graph_color AS graph_color_44,
  t0.graph_data AS graph_data_45,
  t0.header_type AS header_type_46,
  t0.advanced_header_gallery_id AS advanced_header_gallery_id_47,
  t0.advanced_header_image_id AS advanced_header_image_id_48,
  t0.place_holder_image_id AS place_holder_image_id_49,
  t0.mp4_id AS mp4_id_50,
  t0.ogv_id AS ogv_id_51,
  t0.webm_id AS webm_id_52,
  t0.height AS height_53,
  t0.entity_class AS entity_class_54,
  t0.limit_value AS limit_value_55,
  t0.offset_value AS offset_value_56,
  t0.layout AS layout_57,
  t0.order_fields AS order_fields_58,
  t0.filter_fields AS filter_fields_59,
  t0.paginated AS paginated_60,
  t0.form AS form_61,
  t0.canonical_route_name AS canonical_route_name_62,
  t0.svg AS svg_63,
  t0.image2_id AS image2_id_64,
  t0.date AS date_65,
  t0.video_start AS video_start_66,
  t0.video_poster_id AS video_poster_id_67,
  t0.gallery_id AS gallery_id_68,
  t0.downloadable_item_id AS downloadable_item_id_69
FROM
  wam_block_block t0
WHERE
  t0.canonical_name = ?
  AND t0.blockType IN (
    'baseBlock', 'simpleTextBlock', 'multiple4SimpleTextBlock',
    'richTextBlock', 'completeTextBlock',
    'completeTextImageBlock', 'galleryBlock',
    'menuBlock', 'bannerBlock', 'socialBlock',
    'hubspotFormBlock', 'headerBlock',
    'customHtmlBlock', 'collectionBlock',
    'keySellingPointBlock', 'ctaBlock',
    'mapBlock', 'imageBlock', 'customCssBlock',
    'customJsBlock', 'documentBlock',
    'graphBlock', 'advancedHeaderBlock',
    'spacerBlock', 'mappedCollectionBlock',
    'containerBlock', 'customFormBlock',
    'linkBlock', 'breadcrumbBlock',
    'pardotFormBlock', 'embedBlock',
    'imageTextBlock', 'svgBlock', 'borderSpacerBlock',
    'doubleImageBlock', 'headerWithVideoBlock',
    'headerWithVideoOnTopBlock', 'ctaWithDescriptionAndPriceBlock',
    'ctaWithGalleryBlock', 'containerExperiencesBlock',
    'completeTextWithTranslatableImageBlock',
    'downloadableBlock'
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.canonical_name AS canonical_name_2, t0.name AS name_3, t0.hidden AS hidden_4, t0.webmaker_template AS webmaker_template_5, t0.use_custom_html AS use_custom_html_6, t0.attributes AS attributes_7, t0.block_type_for_filter AS block_type_for_filter_8, t0.blockType, t0.image_id AS image_id_9, t0.gallery_id AS gallery_id_10, t0.menu_zone AS menu_zone_11, t0.banner_zone AS banner_zone_12, t0.facebook_name AS facebook_name_13, t0.facebook_url AS facebook_url_14, t0.twitter_name AS twitter_name_15, t0.twitter_url AS twitter_url_16, t0.instagram_name AS instagram_name_17, t0.instagram_url AS instagram_url_18, t0.google_plus_name AS google_plus_name_19, t0.google_plus_url AS google_plus_url_20, t0.linkedin_name AS linkedin_name_21, t0.linkedin_url AS linkedin_url_22, t0.youtube_name AS youtube_name_23, t0.youtube_url AS youtube_url_24, t0.image_id AS image_id_25, t0.orderDirection AS orderDirection_26, t0.orderField AS orderField_27, t0.entity AS entity_28, t0.limitNumber AS limitNumber_29, t0.criteria AS criteria_30, t0.icon_class AS icon_class_31, t0.image_id AS image_id_32, t0.icon_image_id AS icon_image_id_33, t0.canonical_route_name AS canonical_route_name_34, t0.latitude AS latitude_35, t0.longitude AS longitude_36, t0.canonical_route_name AS canonical_route_name_37, t0.image_id AS image_id_38, t0.css AS css_39, t0.js AS js_40, t0.download_document AS download_document_41, t0.document_id AS document_id_42, t0.graph_type AS graph_type_43, t0.graph_color AS graph_color_44, t0.graph_data AS graph_data_45, t0.header_type AS header_type_46, t0.advanced_header_gallery_id AS advanced_header_gallery_id_47, t0.advanced_header_image_id AS advanced_header_image_id_48, t0.place_holder_image_id AS place_holder_image_id_49, t0.mp4_id AS mp4_id_50, t0.ogv_id AS ogv_id_51, t0.webm_id AS webm_id_52, t0.height AS height_53, t0.entity_class AS entity_class_54, t0.limit_value AS limit_value_55, t0.offset_value AS offset_value_56, t0.layout AS layout_57, t0.order_fields AS order_fields_58, t0.filter_fields AS filter_fields_59, t0.paginated AS paginated_60, t0.form AS form_61, t0.canonical_route_name AS canonical_route_name_62, t0.svg AS svg_63, t0.image2_id AS image2_id_64, t0.date AS date_65, t0.video_start AS video_start_66, t0.video_poster_id AS video_poster_id_67, t0.gallery_id AS gallery_id_68, t0.downloadable_item_id AS downloadable_item_id_69 FROM wam_block_block t0 WHERE t0.canonical_name = 'home.banner_top.block' AND t0.blockType IN ('baseBlock', 'simpleTextBlock', 'multiple4SimpleTextBlock', 'richTextBlock', 'completeTextBlock', 'completeTextImageBlock', 'galleryBlock', 'menuBlock', 'bannerBlock', 'socialBlock', 'hubspotFormBlock', 'headerBlock', 'customHtmlBlock', 'collectionBlock', 'keySellingPointBlock', 'ctaBlock', 'mapBlock', 'imageBlock', 'customCssBlock', 'customJsBlock', 'documentBlock', 'graphBlock', 'advancedHeaderBlock', 'spacerBlock', 'mappedCollectionBlock', 'containerBlock', 'customFormBlock', 'linkBlock', 'breadcrumbBlock', 'pardotFormBlock', 'embedBlock', 'imageTextBlock', 'svgBlock', 'borderSpacerBlock', 'doubleImageBlock', 'headerWithVideoBlock', 'headerWithVideoOnTopBlock', 'ctaWithDescriptionAndPriceBlock', 'ctaWithGalleryBlock', 'containerExperiencesBlock', 'completeTextWithTranslatableImageBlock', 'downloadableBlock') LIMIT 1;

SELECT
  t0.text AS text_1,
  t0.description AS description_2,
  t0.link AS link_3,
  t0.route_link AS route_link_4,
  t0.locale AS locale_5,
  t0.id AS id_6,
  t0.translatable_id AS translatable_id_7
FROM
  app_web_content_menu_item_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.text AS text_1, t0.description AS description_2, t0.link AS link_3, t0.route_link AS route_link_4, t0.locale AS locale_5, t0.id AS id_6, t0.translatable_id AS translatable_id_7 FROM app_web_content_menu_item_translation t0 WHERE t0.translatable_id = 34;

SELECT
  t0.id AS id_1,
  t0.city AS city_2,
  t0.show_advantages AS show_advantages_3,
  t0.hotel_class AS hotel_class_4,
  t0.simple_name AS simple_name_5,
  t0.hotel_header_video AS hotel_header_video_6,
  t0.rooms_header_video AS rooms_header_video_7,
  t0.google_url AS google_url_8,
  t0.review_pro_script1 AS review_pro_script1_9,
  t0.review_pro_script2 AS review_pro_script2_10,
  t0.review_pro_script3 AS review_pro_script3_11,
  t0.review_pro_script4 AS review_pro_script4_12,
  t0.review_pro_script5 AS review_pro_script5_13,
  t0.review_pro_script6 AS review_pro_script6_14,
  t0.enabled AS enabled_15,
  t0.enabled_picking_up AS enabled_picking_up_16,
  t0.mirai_hotel_id AS mirai_hotel_id_17,
  t0.happy_force_hierarchy_id AS happy_force_hierarchy_id_18,
  t0.left_icons AS left_icons_19,
  t0.right_icons AS right_icons_20,
  t0.right_script1 AS right_script1_21,
  t0.right_script2 AS right_script2_22,
  t0.right_script3 AS right_script3_23,
  t0.right_script4 AS right_script4_24,
  t0.right_script5 AS right_script5_25,
  t0.right_script6 AS right_script6_26,
  t0.is_apartment AS is_apartment_27,
  t0.direction AS direction_28,
  t0.phone AS phone_29,
  t0.email AS email_30,
  t0.address_line1 AS address_line1_31,
  t0.address_line2 AS address_line2_32,
  t0.latitude AS latitude_33,
  t0.longitude AS longitude_34,
  t0.centered_latitude AS centered_latitude_35,
  t0.centered_longitude AS centered_longitude_36,
  t0.location_id AS location_id_37,
  t0.gallery_certifications_id AS gallery_certifications_id_38,
  t0.city_gallery_id AS city_gallery_id_39,
  t0.how_to_get_there_image_id AS how_to_get_there_image_id_40,
  t0.main_image_id AS main_image_id_41,
  t0.header_image_id AS header_image_id_42,
  t0.rooms_header_image_id AS rooms_header_image_id_43,
  t0.cta_image_id AS cta_image_id_44,
  t0.gallery1_id AS gallery1_id_45,
  t0.gallery2_id AS gallery2_id_46,
  t0.vertical_main_image_id AS vertical_main_image_id_47
FROM
  app_hotel t0

SELECT t0.id AS id_1, t0.city AS city_2, t0.show_advantages AS show_advantages_3, t0.hotel_class AS hotel_class_4, t0.simple_name AS simple_name_5, t0.hotel_header_video AS hotel_header_video_6, t0.rooms_header_video AS rooms_header_video_7, t0.google_url AS google_url_8, t0.review_pro_script1 AS review_pro_script1_9, t0.review_pro_script2 AS review_pro_script2_10, t0.review_pro_script3 AS review_pro_script3_11, t0.review_pro_script4 AS review_pro_script4_12, t0.review_pro_script5 AS review_pro_script5_13, t0.review_pro_script6 AS review_pro_script6_14, t0.enabled AS enabled_15, t0.enabled_picking_up AS enabled_picking_up_16, t0.mirai_hotel_id AS mirai_hotel_id_17, t0.happy_force_hierarchy_id AS happy_force_hierarchy_id_18, t0.left_icons AS left_icons_19, t0.right_icons AS right_icons_20, t0.right_script1 AS right_script1_21, t0.right_script2 AS right_script2_22, t0.right_script3 AS right_script3_23, t0.right_script4 AS right_script4_24, t0.right_script5 AS right_script5_25, t0.right_script6 AS right_script6_26, t0.is_apartment AS is_apartment_27, t0.direction AS direction_28, t0.phone AS phone_29, t0.email AS email_30, t0.address_line1 AS address_line1_31, t0.address_line2 AS address_line2_32, t0.latitude AS latitude_33, t0.longitude AS longitude_34, t0.centered_latitude AS centered_latitude_35, t0.centered_longitude AS centered_longitude_36, t0.location_id AS location_id_37, t0.gallery_certifications_id AS gallery_certifications_id_38, t0.city_gallery_id AS city_gallery_id_39, t0.how_to_get_there_image_id AS how_to_get_there_image_id_40, t0.main_image_id AS main_image_id_41, t0.header_image_id AS header_image_id_42, t0.rooms_header_image_id AS rooms_header_image_id_43, t0.cta_image_id AS cta_image_id_44, t0.gallery1_id AS gallery1_id_45, t0.gallery2_id AS gallery2_id_46, t0.vertical_main_image_id AS vertical_main_image_id_47 FROM app_hotel t0;

SELECT
  t0.id AS id_1,
  t0.header_youtube_url AS header_youtube_url_2,
  t0.position AS position_3,
  t0.show_image_background AS show_image_background_4,
  t0.show_advantages1 AS show_advantages1_5,
  t0.form_enabled AS form_enabled_6,
  t0.form_anchor AS form_anchor_7,
  t0.header_image_id AS header_image_id_8,
  t0.hotel_id AS hotel_id_9,
  t0.block_gallery1_id AS block_gallery1_id_10,
  t0.block_image2_id AS block_image2_id_11,
  t0.block_gallery3_id AS block_gallery3_id_12,
  t0.block_image4_id AS block_image4_id_13,
  t0.cta_image_id AS cta_image_id_14,
  t0.pop_up_gallery1_id AS pop_up_gallery1_id_15,
  t0.pop_up_gallery2_id AS pop_up_gallery2_id_16,
  t0.pop_up_gallery3_id AS pop_up_gallery3_id_17,
  t0.pop_up_gallery4_id AS pop_up_gallery4_id_18,
  t0.second_pop_up_gallery1_id AS second_pop_up_gallery1_id_19,
  t0.second_pop_up_gallery2_id AS second_pop_up_gallery2_id_20,
  t0.second_pop_up_gallery3_id AS second_pop_up_gallery3_id_21,
  t0.second_pop_up_gallery4_id AS second_pop_up_gallery4_id_22,
  t0.third_pop_up_gallery1_id AS third_pop_up_gallery1_id_23,
  t0.third_pop_up_gallery2_id AS third_pop_up_gallery2_id_24,
  t0.third_pop_up_gallery3_id AS third_pop_up_gallery3_id_25,
  t0.third_pop_up_gallery4_id AS third_pop_up_gallery4_id_26,
  t0.advantages_background_image_id AS advantages_background_image_id_27
FROM
  app_experience t0
WHERE
  t0.hotel_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.header_youtube_url AS header_youtube_url_2, t0.position AS position_3, t0.show_image_background AS show_image_background_4, t0.show_advantages1 AS show_advantages1_5, t0.form_enabled AS form_enabled_6, t0.form_anchor AS form_anchor_7, t0.header_image_id AS header_image_id_8, t0.hotel_id AS hotel_id_9, t0.block_gallery1_id AS block_gallery1_id_10, t0.block_image2_id AS block_image2_id_11, t0.block_gallery3_id AS block_gallery3_id_12, t0.block_image4_id AS block_image4_id_13, t0.cta_image_id AS cta_image_id_14, t0.pop_up_gallery1_id AS pop_up_gallery1_id_15, t0.pop_up_gallery2_id AS pop_up_gallery2_id_16, t0.pop_up_gallery3_id AS pop_up_gallery3_id_17, t0.pop_up_gallery4_id AS pop_up_gallery4_id_18, t0.second_pop_up_gallery1_id AS second_pop_up_gallery1_id_19, t0.second_pop_up_gallery2_id AS second_pop_up_gallery2_id_20, t0.second_pop_up_gallery3_id AS second_pop_up_gallery3_id_21, t0.second_pop_up_gallery4_id AS second_pop_up_gallery4_id_22, t0.third_pop_up_gallery1_id AS third_pop_up_gallery1_id_23, t0.third_pop_up_gallery2_id AS third_pop_up_gallery2_id_24, t0.third_pop_up_gallery3_id AS third_pop_up_gallery3_id_25, t0.third_pop_up_gallery4_id AS third_pop_up_gallery4_id_26, t0.advantages_background_image_id AS advantages_background_image_id_27 FROM app_experience t0 WHERE t0.hotel_id = 1 ORDER BY t0.position ASC;

SELECT
  a0_.name AS name_0,
  a0_.open_new_window AS open_new_window_1,
  a0_.enabled AS enabled_2,
  a0_.no_follow AS no_follow_3,
  a0_.menu AS menu_4,
  a0_.route AS route_5,
  a0_.is_separated AS is_separated_6,
  a0_.icon_class AS icon_class_7,
  a0_.id AS id_8,
  a0_.position AS position_9,
  a0_.date_start AS date_start_10,
  a0_.date_end AS date_end_11,
  a0_.status AS status_12,
  a0_.parent_id AS parent_id_13,
  a0_.image_id AS image_id_14
FROM
  app_web_content_menu_item a0_
WHERE
  a0_.status = ?
  AND a0_.date_start <= ?
  AND (
    (
      a0_.date_end > ?
      OR a0_.date_end IS NULL
    )
  )
  AND a0_.parent_id IS NULL
  AND a0_.menu = ?
  AND a0_.enabled = 1
ORDER BY
  a0_.position ASC

SELECT a0_.name AS name_0, a0_.open_new_window AS open_new_window_1, a0_.enabled AS enabled_2, a0_.no_follow AS no_follow_3, a0_.menu AS menu_4, a0_.route AS route_5, a0_.is_separated AS is_separated_6, a0_.icon_class AS icon_class_7, a0_.id AS id_8, a0_.position AS position_9, a0_.date_start AS date_start_10, a0_.date_end AS date_end_11, a0_.status AS status_12, a0_.parent_id AS parent_id_13, a0_.image_id AS image_id_14 FROM app_web_content_menu_item a0_ WHERE a0_.status = 'PUBLISHED' AND a0_.date_start <= '2024-11-15 13:51:05' AND ((a0_.date_end > '2024-11-15 13:51:05' OR a0_.date_end IS NULL)) AND a0_.parent_id IS NULL AND a0_.menu = 'TOP' AND a0_.enabled = 1 ORDER BY a0_.position ASC;

SELECT
  t0.name AS name_1,
  t0.controller AS controller_2,
  t0.template AS template_3,
  t0.id AS id_4,
  t0.attributes AS attributes_5,
  t0.host_id AS host_id_6
FROM
  app_routing_url t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.controller AS controller_2, t0.template AS template_3, t0.id AS id_4, t0.attributes AS attributes_5, t0.host_id AS host_id_6 FROM app_routing_url t0 WHERE t0.id = 1;