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 = 'app_experience_4' 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', 'vimeovideo', 'file', '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 = 1930 AND t0.dtype IN ('media', 'vimeovideo', 'file', '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 = 4;

SELECT
  t0.id AS id_1,
  t0.icon_class AS icon_class_2,
  t0.show_link AS show_link_3,
  t0.show_popup AS show_popup_4,
  t0.anchor_to_advantages_block AS anchor_to_advantages_block_5,
  t0.location_id AS location_id_6
FROM
  app_advantage t0
  INNER JOIN app_experiences_advantages ON t0.id = app_experiences_advantages.advantage_id
WHERE
  app_experiences_advantages.experience_id = ?

SELECT t0.id AS id_1, t0.icon_class AS icon_class_2, t0.show_link AS show_link_3, t0.show_popup AS show_popup_4, t0.anchor_to_advantages_block AS anchor_to_advantages_block_5, t0.location_id AS location_id_6 FROM app_advantage t0 INNER JOIN app_experiences_advantages ON t0.id = app_experiences_advantages.advantage_id WHERE app_experiences_advantages.experience_id = 4;

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-17 15:58:37' AND ((a0_.date_end > '2024-11-17 15:58:37' 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.title AS title_1,
  t0.link AS link_2,
  t0.content AS content_3,
  t0.short_text AS short_text_4,
  t0.locale AS locale_5,
  t0.id AS id_6,
  t0.translatable_id AS translatable_id_7
FROM
  app_advantage_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.title AS title_1, t0.link AS link_2, t0.content AS content_3, t0.short_text AS short_text_4, t0.locale AS locale_5, t0.id AS id_6, t0.translatable_id AS translatable_id_7 FROM app_advantage_translation t0 WHERE t0.translatable_id = 21;

SELECT
  t0.enabled AS enabled_1,
  t0.position AS position_2,
  t0.id AS id_3,
  t0.media_id AS media_id_4,
  t0.gallery_id AS gallery_id_5
FROM
  app_media_gallery_has_media t0
WHERE
  t0.gallery_id = ?
ORDER BY
  t0.position ASC

SELECT t0.enabled AS enabled_1, t0.position AS position_2, t0.id AS id_3, t0.media_id AS media_id_4, t0.gallery_id AS gallery_id_5 FROM app_media_gallery_has_media t0 WHERE t0.gallery_id = 51 ORDER BY t0.position ASC;

SELECT
  t0.title AS title_1,
  t0.description AS description_2,
  t0.locale AS locale_3,
  t0.id AS id_4,
  t0.translatable_id AS translatable_id_5,
  t0.dtype,
  t0.alt AS alt_6
FROM
  app_media_media_translation t0
WHERE
  t0.translatable_id = ?
  AND t0.dtype IN (
    'mediatranslation', 'vimeovideotranslation',
    'filetranslation', 'youtubevideotranslation'
  )

SELECT t0.title AS title_1, t0.description AS description_2, t0.locale AS locale_3, t0.id AS id_4, t0.translatable_id AS translatable_id_5, t0.dtype, t0.alt AS alt_6 FROM app_media_media_translation t0 WHERE t0.translatable_id = 1930 AND t0.dtype IN ('mediatranslation', 'vimeovideotranslation', 'filetranslation', 'youtubevideotranslation');

SELECT
  t0.name AS name_1,
  t0.enabled AS enabled_2,
  t0.id AS id_3,
  t0.date_start AS date_start_4,
  t0.date_end AS date_end_5,
  t0.status AS status_6
FROM
  app_media_gallery t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.enabled AS enabled_2, t0.id AS id_3, t0.date_start AS date_start_4, t0.date_end AS date_end_5, t0.status AS status_6 FROM app_media_gallery t0 WHERE t0.id = 51;

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.id = ?

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.id = 4;

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.experience_id AS experience_id_2,
  t3.id AS id_4,
  t3.header_youtube_url AS header_youtube_url_5,
  t3.position AS position_6,
  t3.show_image_background AS show_image_background_7,
  t3.show_advantages1 AS show_advantages1_8,
  t3.form_enabled AS form_enabled_9,
  t3.form_anchor AS form_anchor_10,
  t3.header_image_id AS header_image_id_11,
  t3.hotel_id AS hotel_id_12,
  t3.block_gallery1_id AS block_gallery1_id_13,
  t3.block_image2_id AS block_image2_id_14,
  t3.block_gallery3_id AS block_gallery3_id_15,
  t3.block_image4_id AS block_image4_id_16,
  t3.cta_image_id AS cta_image_id_17,
  t3.pop_up_gallery1_id AS pop_up_gallery1_id_18,
  t3.pop_up_gallery2_id AS pop_up_gallery2_id_19,
  t3.pop_up_gallery3_id AS pop_up_gallery3_id_20,
  t3.pop_up_gallery4_id AS pop_up_gallery4_id_21,
  t3.second_pop_up_gallery1_id AS second_pop_up_gallery1_id_22,
  t3.second_pop_up_gallery2_id AS second_pop_up_gallery2_id_23,
  t3.second_pop_up_gallery3_id AS second_pop_up_gallery3_id_24,
  t3.second_pop_up_gallery4_id AS second_pop_up_gallery4_id_25,
  t3.third_pop_up_gallery1_id AS third_pop_up_gallery1_id_26,
  t3.third_pop_up_gallery2_id AS third_pop_up_gallery2_id_27,
  t3.third_pop_up_gallery3_id AS third_pop_up_gallery3_id_28,
  t3.third_pop_up_gallery4_id AS third_pop_up_gallery4_id_29,
  t3.advantages_background_image_id AS advantages_background_image_id_30,
  t0.downloadableItem_id AS downloadableItem_id_31,
  t32.id AS id_33,
  t32.name AS name_34,
  t32.image_id AS image_id_35
FROM
  app_experience_has_downloadableItem t0
  LEFT JOIN app_experience t3 ON t0.experience_id = t3.id
  LEFT JOIN app_downloadableItem t32 ON t0.downloadableItem_id = t32.id
WHERE
  t0.experience_id = ?

SELECT t0.id AS id_1, t0.experience_id AS experience_id_2, t3.id AS id_4, t3.header_youtube_url AS header_youtube_url_5, t3.position AS position_6, t3.show_image_background AS show_image_background_7, t3.show_advantages1 AS show_advantages1_8, t3.form_enabled AS form_enabled_9, t3.form_anchor AS form_anchor_10, t3.header_image_id AS header_image_id_11, t3.hotel_id AS hotel_id_12, t3.block_gallery1_id AS block_gallery1_id_13, t3.block_image2_id AS block_image2_id_14, t3.block_gallery3_id AS block_gallery3_id_15, t3.block_image4_id AS block_image4_id_16, t3.cta_image_id AS cta_image_id_17, t3.pop_up_gallery1_id AS pop_up_gallery1_id_18, t3.pop_up_gallery2_id AS pop_up_gallery2_id_19, t3.pop_up_gallery3_id AS pop_up_gallery3_id_20, t3.pop_up_gallery4_id AS pop_up_gallery4_id_21, t3.second_pop_up_gallery1_id AS second_pop_up_gallery1_id_22, t3.second_pop_up_gallery2_id AS second_pop_up_gallery2_id_23, t3.second_pop_up_gallery3_id AS second_pop_up_gallery3_id_24, t3.second_pop_up_gallery4_id AS second_pop_up_gallery4_id_25, t3.third_pop_up_gallery1_id AS third_pop_up_gallery1_id_26, t3.third_pop_up_gallery2_id AS third_pop_up_gallery2_id_27, t3.third_pop_up_gallery3_id AS third_pop_up_gallery3_id_28, t3.third_pop_up_gallery4_id AS third_pop_up_gallery4_id_29, t3.advantages_background_image_id AS advantages_background_image_id_30, t0.downloadableItem_id AS downloadableItem_id_31, t32.id AS id_33, t32.name AS name_34, t32.image_id AS image_id_35 FROM app_experience_has_downloadableItem t0 LEFT JOIN app_experience t3 ON t0.experience_id = t3.id LEFT JOIN app_downloadableItem t32 ON t0.downloadableItem_id = t32.id WHERE t0.experience_id = 4;

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
WHERE
  t0.id = ?

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 WHERE t0.id = 4;

SELECT
  t0.title AS title_1,
  t0.introduction_title AS introduction_title_2,
  t0.rooms_header_title AS rooms_header_title_3,
  t0.introduction AS introduction_4,
  t0.cta_text AS cta_text_5,
  t0.cta_button_text AS cta_button_text_6,
  t0.cta_button_url AS cta_button_url_7,
  t0.content AS content_8,
  t0.advantages_title AS advantages_title_9,
  t0.advantages_subtitle AS advantages_subtitle_10,
  t0.room_section_title AS room_section_title_11,
  t0.room_section_link_title AS room_section_link_title_12,
  t0.room_section_content AS room_section_content_13,
  t0.how_to_get_there AS how_to_get_there_14,
  t0.review_pro_title AS review_pro_title_15,
  t0.review_pro_iframe AS review_pro_iframe_16,
  t0.review_pro_testimonials_iframe AS review_pro_testimonials_iframe_17,
  t0.google_structured_code AS google_structured_code_18,
  t0.instagram_script AS instagram_script_19,
  t0.city_title AS city_title_20,
  t0.city_description AS city_description_21,
  t0.subtitle AS subtitle_22,
  t0.locale AS locale_23,
  t0.id AS id_24,
  t0.slug AS slug_25,
  t0.translatable_id AS translatable_id_26
FROM
  app_hotel_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.title AS title_1, t0.introduction_title AS introduction_title_2, t0.rooms_header_title AS rooms_header_title_3, t0.introduction AS introduction_4, t0.cta_text AS cta_text_5, t0.cta_button_text AS cta_button_text_6, t0.cta_button_url AS cta_button_url_7, t0.content AS content_8, t0.advantages_title AS advantages_title_9, t0.advantages_subtitle AS advantages_subtitle_10, t0.room_section_title AS room_section_title_11, t0.room_section_link_title AS room_section_link_title_12, t0.room_section_content AS room_section_content_13, t0.how_to_get_there AS how_to_get_there_14, t0.review_pro_title AS review_pro_title_15, t0.review_pro_iframe AS review_pro_iframe_16, t0.review_pro_testimonials_iframe AS review_pro_testimonials_iframe_17, t0.google_structured_code AS google_structured_code_18, t0.instagram_script AS instagram_script_19, t0.city_title AS city_title_20, t0.city_description AS city_description_21, t0.subtitle AS subtitle_22, t0.locale AS locale_23, t0.id AS id_24, t0.slug AS slug_25, t0.translatable_id AS translatable_id_26 FROM app_hotel_translation t0 WHERE t0.translatable_id = 4;

SELECT
  t0.host AS host_1,
  t0.schemes AS schemes_2,
  t0.methods AS methods_3,
  t0.defaults AS defaults_4,
  t0.requirements AS requirements_5,
  t0.options AS options_6,
  t0.condition_expr AS condition_expr_7,
  t0.variable_pattern AS variable_pattern_8,
  t0.staticPrefix AS staticPrefix_9,
  t0.id AS id_10,
  t0.name AS name_11,
  t0.position AS position_12,
  t0.canonical_name AS canonical_name_13,
  t0.tag AS tag_14,
  t0.sitemapeable AS sitemapeable_15,
  t0.type AS type_16,
  t0.seo_meta_data AS seo_meta_data_17,
  t0.content_class AS content_class_18,
  t0.content_id AS content_id_19,
  t0.redirect_target AS redirect_target_20,
  t0.autoRoute
FROM
  wam_routing_route t0
WHERE
  t0.name = ?
  AND t0.autoRoute IN ('1')
LIMIT
  1

SELECT t0.host AS host_1, t0.schemes AS schemes_2, t0.methods AS methods_3, t0.defaults AS defaults_4, t0.requirements AS requirements_5, t0.options AS options_6, t0.condition_expr AS condition_expr_7, t0.variable_pattern AS variable_pattern_8, t0.staticPrefix AS staticPrefix_9, t0.id AS id_10, t0.name AS name_11, t0.position AS position_12, t0.canonical_name AS canonical_name_13, t0.tag AS tag_14, t0.sitemapeable AS sitemapeable_15, t0.type AS type_16, t0.seo_meta_data AS seo_meta_data_17, t0.content_class AS content_class_18, t0.content_id AS content_id_19, t0.redirect_target AS redirect_target_20, t0.autoRoute FROM wam_routing_route t0 WHERE t0.name = 'home' AND t0.autoRoute IN ('1') LIMIT 1;

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.name = ?
LIMIT
  1

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.name = 'home' LIMIT 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_.staticPrefix = ?
    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_.staticPrefix = '/en/artiem-madrid/restaurants.html' AND w0_.type = 'cmf_routing_auto.redirect') AND w0_.autoRoute IN ('0', '1');