Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.iso_code AS iso_code_1,
  c0_.name AS name_2,
  c0_.country AS country_3,
  c0_.active AS active_4,
  c0_.display_home AS display_home_5,
  c0_.sort AS sort_6,
  i1_.id AS id_7,
  i1_.nom AS nom_8,
  i1_.country AS country_9,
  c0_.city_id AS city_id_10,
  c0_.zone_id AS zone_id_11,
  c0_.main_image_id AS main_image_id_12,
  c0_.gallery_id AS gallery_id_13
FROM
  country c0_
  INNER JOIN iata_city i1_ ON c0_.city_id = i1_.id
WHERE
  c0_.display_home = 1
ORDER BY
  c0_.sort DESC

SELECT c0_.id AS id_0, c0_.iso_code AS iso_code_1, c0_.name AS name_2, c0_.country AS country_3, c0_.active AS active_4, c0_.display_home AS display_home_5, c0_.sort AS sort_6, i1_.id AS id_7, i1_.nom AS nom_8, i1_.country AS country_9, c0_.city_id AS city_id_10, c0_.zone_id AS zone_id_11, c0_.main_image_id AS main_image_id_12, c0_.gallery_id AS gallery_id_13 FROM country c0_ INNER JOIN iata_city i1_ ON c0_.city_id = i1_.id WHERE c0_.display_home = 1 ORDER BY c0_.sort DESC;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 527;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 1962;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 401;

SELECT
  t0.id AS id_1,
  t0.admin_email AS admin_email_2,
  t0.offer_start AS offer_start_3,
  t0.tour_admin_email AS tour_admin_email_4,
  t0.offer_amount_of_nights AS offer_amount_of_nights_5,
  t0.sakifo_start AS sakifo_start_6,
  t0.sakifo_end AS sakifo_end_7,
  t0.contact_form_subjects AS contact_form_subjects_8,
  t0.know_us_how AS know_us_how_9,
  t0.hero_title AS hero_title_10,
  t0.hero_subtitle AS hero_subtitle_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.featured_hotel_id AS featured_hotel_id_14,
  t0.featured_tour_id AS featured_tour_id_15,
  t0.sakifo_thumbnail_id AS sakifo_thumbnail_id_16,
  t0.sakifo_banner_id AS sakifo_banner_id_17
FROM
  setting t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.admin_email AS admin_email_2, t0.offer_start AS offer_start_3, t0.tour_admin_email AS tour_admin_email_4, t0.offer_amount_of_nights AS offer_amount_of_nights_5, t0.sakifo_start AS sakifo_start_6, t0.sakifo_end AS sakifo_end_7, t0.contact_form_subjects AS contact_form_subjects_8, t0.know_us_how AS know_us_how_9, t0.hero_title AS hero_title_10, t0.hero_subtitle AS hero_subtitle_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.featured_hotel_id AS featured_hotel_id_14, t0.featured_tour_id AS featured_tour_id_15, t0.sakifo_thumbnail_id AS sakifo_thumbnail_id_16, t0.sakifo_banner_id AS sakifo_banner_id_17 FROM setting t0 WHERE t0.id = 'default';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.active AS active_3,
  t0.created_uid AS created_uid_4,
  t0.updated_uid AS updated_uid_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.promotion_offer_id AS promotion_offer_id_8,
  t0.tour_id AS tour_id_9
FROM
  home_offer t0
WHERE
  t0.active = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.active AS active_3, t0.created_uid AS created_uid_4, t0.updated_uid AS updated_uid_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.promotion_offer_id AS promotion_offer_id_8, t0.tour_id AS tour_id_9 FROM home_offer t0 WHERE t0.active = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.stay_start AS stay_start_2,
  t0.amount_of_nights AS amount_of_nights_3,
  t0.amount_of_adults AS amount_of_adults_4,
  t0.active AS active_5,
  t0.created_uid AS created_uid_6,
  t0.updated_uid AS updated_uid_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.promotion_id AS promotion_id_10,
  t0.room_id AS room_id_11
FROM
  promotion_offer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.stay_start AS stay_start_2, t0.amount_of_nights AS amount_of_nights_3, t0.amount_of_adults AS amount_of_adults_4, t0.active AS active_5, t0.created_uid AS created_uid_6, t0.updated_uid AS updated_uid_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.promotion_id AS promotion_id_10, t0.room_id AS room_id_11 FROM promotion_offer t0 WHERE t0.id = 13;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.stay_start AS stay_start_5,
  t0.stay_end AS stay_end_6,
  t0.sale_start AS sale_start_7,
  t0.sale_end AS sale_end_8,
  t0.min_nights AS min_nights_9,
  t0.max_nights AS max_nights_10,
  t0.early_booking_amount_of_days AS early_booking_amount_of_days_11,
  t0.discount AS discount_12,
  t0.apply_to_all_rooms AS apply_to_all_rooms_13,
  t0.combinable AS combinable_14,
  t0.sort AS sort_15,
  t0.active AS active_16,
  t0.validation_condition AS validation_condition_17,
  t0.display_in_honey_moon AS display_in_honey_moon_18,
  t0.apply_to_all_supplements AS apply_to_all_supplements_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.hotel_id AS hotel_id_22
FROM
  promotion t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.label AS label_3, t0.description AS description_4, t0.stay_start AS stay_start_5, t0.stay_end AS stay_end_6, t0.sale_start AS sale_start_7, t0.sale_end AS sale_end_8, t0.min_nights AS min_nights_9, t0.max_nights AS max_nights_10, t0.early_booking_amount_of_days AS early_booking_amount_of_days_11, t0.discount AS discount_12, t0.apply_to_all_rooms AS apply_to_all_rooms_13, t0.combinable AS combinable_14, t0.sort AS sort_15, t0.active AS active_16, t0.validation_condition AS validation_condition_17, t0.display_in_honey_moon AS display_in_honey_moon_18, t0.apply_to_all_supplements AS apply_to_all_supplements_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.hotel_id AS hotel_id_22 FROM promotion t0 WHERE t0.id = 2211;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.has_separate_bedroom AS has_separate_bedroom_4,
  t0.services AS services_5,
  t0.active AS active_6,
  t0.position AS position_7,
  t0.hotel_id AS hotel_id_8,
  t0.main_image_id AS main_image_id_9,
  t0.gallery_id AS gallery_id_10
FROM
  room t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.has_separate_bedroom AS has_separate_bedroom_4, t0.services AS services_5, t0.active AS active_6, t0.position AS position_7, t0.hotel_id AS hotel_id_8, t0.main_image_id AS main_image_id_9, t0.gallery_id AS gallery_id_10 FROM room t0 WHERE t0.id = 21;

SELECT
  t0.id AS id_1,
  t0.debut AS debut_2,
  t0.fin AS fin_3,
  t0.hotel_id AS hotel_id_4,
  t0.chambre_id AS chambre_id_5
FROM
  stop_sale t0
WHERE
  t0.chambre_id = ?

SELECT t0.id AS id_1, t0.debut AS debut_2, t0.fin AS fin_3, t0.hotel_id AS hotel_id_4, t0.chambre_id AS chambre_id_5 FROM stop_sale t0 WHERE t0.chambre_id = 21;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.stay_start AS stay_start_3,
  t0.stay_end AS stay_end_4,
  t0.sale_start AS sale_start_5,
  t0.sale_end AS sale_end_6,
  t0.double_occupancy AS double_occupancy_7,
  t0.single_occupancy AS single_occupancy_8,
  t0.triple_occupancy AS triple_occupancy_9,
  t0.different_extra_charge_per_child AS different_extra_charge_per_child_10,
  t0.extra_charge_child_1 AS extra_charge_child_1_11,
  t0.extra_charge_child_2 AS extra_charge_child_2_12,
  t0.extra_charge_child_3 AS extra_charge_child_3_13,
  t0.extra_charge_child_4 AS extra_charge_child_4_14,
  t0.extra_charge_teen AS extra_charge_teen_15,
  t0.separate_room_different_extra_charge_per_child AS separate_room_different_extra_charge_per_child_16,
  t0.separate_room_extra_charge_child_1 AS separate_room_extra_charge_child_1_17,
  t0.separate_room_extra_charge_child_2 AS separate_room_extra_charge_child_2_18,
  t0.separate_room_extra_charge_child_3 AS separate_room_extra_charge_child_3_19,
  t0.separate_room_extra_charge_child_4 AS separate_room_extra_charge_child_4_20,
  t0.separate_room_extra_charge_teen AS separate_room_extra_charge_teen_21,
  t0.active AS active_22,
  t0.stock AS stock_23,
  t0.min_nights AS min_nights_24,
  t0.room_id AS room_id_25
FROM
  room_rate t0
WHERE
  t0.room_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.stay_start AS stay_start_3, t0.stay_end AS stay_end_4, t0.sale_start AS sale_start_5, t0.sale_end AS sale_end_6, t0.double_occupancy AS double_occupancy_7, t0.single_occupancy AS single_occupancy_8, t0.triple_occupancy AS triple_occupancy_9, t0.different_extra_charge_per_child AS different_extra_charge_per_child_10, t0.extra_charge_child_1 AS extra_charge_child_1_11, t0.extra_charge_child_2 AS extra_charge_child_2_12, t0.extra_charge_child_3 AS extra_charge_child_3_13, t0.extra_charge_child_4 AS extra_charge_child_4_14, t0.extra_charge_teen AS extra_charge_teen_15, t0.separate_room_different_extra_charge_per_child AS separate_room_different_extra_charge_per_child_16, t0.separate_room_extra_charge_child_1 AS separate_room_extra_charge_child_1_17, t0.separate_room_extra_charge_child_2 AS separate_room_extra_charge_child_2_18, t0.separate_room_extra_charge_child_3 AS separate_room_extra_charge_child_3_19, t0.separate_room_extra_charge_child_4 AS separate_room_extra_charge_child_4_20, t0.separate_room_extra_charge_teen AS separate_room_extra_charge_teen_21, t0.active AS active_22, t0.stock AS stock_23, t0.min_nights AS min_nights_24, t0.room_id AS room_id_25 FROM room_rate t0 WHERE t0.room_id = 21;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.type_event AS type_event_3,
  t0.ref AS ref_4,
  t0.name AS name_5,
  t0.description AS description_6,
  t0.website AS website_7,
  t0.stars AS stars_8,
  t0.you_tube_video_id AS you_tube_video_id_9,
  t0.phone AS phone_10,
  t0.email AS email_11,
  t0.reservation_email AS reservation_email_12,
  t0.accompanist_email AS accompanist_email_13,
  t0.trip_advisor_widget AS trip_advisor_widget_14,
  t0.min_nights AS min_nights_15,
  t0.google_map_url AS google_map_url_16,
  t0.check_in_time AS check_in_time_17,
  t0.check_out_time AS check_out_time_18,
  t0.teen_age_max AS teen_age_max_19,
  t0.child_age_max AS child_age_max_20,
  t0.baby_age_max AS baby_age_max_21,
  t0.margin AS margin_22,
  t0.free_for_children_sharing_room AS free_for_children_sharing_room_23,
  t0.free_age_min AS free_age_min_24,
  t0.free_age_max AS free_age_max_25,
  t0.strict_departure_countries AS strict_departure_countries_26,
  t0.hotel_only_disable AS hotel_only_disable_27,
  t0.active AS active_28,
  t0.created_uid AS created_uid_29,
  t0.updated_uid AS updated_uid_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.contact_name AS contact_name_33,
  t0.contact_email AS contact_email_34,
  t0.contact_phone AS contact_phone_35,
  t0.contact_role AS contact_role_36,
  t0.address_line_1 AS address_line_1_37,
  t0.address_line_2 AS address_line_2_38,
  t0.address_postal_code AS address_postal_code_39,
  t0.address_city AS address_city_40,
  t0.address_country AS address_country_41,
  t0.pension_type_id AS pension_type_id_42,
  t0.default_formule_id AS default_formule_id_43,
  t0.default_supplement_id AS default_supplement_id_44,
  t0.booking_fee_id AS booking_fee_id_45,
  t0.country_id AS country_id_46,
  t0.home_image_id AS home_image_id_47,
  t0.main_image_id AS main_image_id_48,
  t0.gallery_id AS gallery_id_49
FROM
  hotel t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.type_event AS type_event_3, t0.ref AS ref_4, t0.name AS name_5, t0.description AS description_6, t0.website AS website_7, t0.stars AS stars_8, t0.you_tube_video_id AS you_tube_video_id_9, t0.phone AS phone_10, t0.email AS email_11, t0.reservation_email AS reservation_email_12, t0.accompanist_email AS accompanist_email_13, t0.trip_advisor_widget AS trip_advisor_widget_14, t0.min_nights AS min_nights_15, t0.google_map_url AS google_map_url_16, t0.check_in_time AS check_in_time_17, t0.check_out_time AS check_out_time_18, t0.teen_age_max AS teen_age_max_19, t0.child_age_max AS child_age_max_20, t0.baby_age_max AS baby_age_max_21, t0.margin AS margin_22, t0.free_for_children_sharing_room AS free_for_children_sharing_room_23, t0.free_age_min AS free_age_min_24, t0.free_age_max AS free_age_max_25, t0.strict_departure_countries AS strict_departure_countries_26, t0.hotel_only_disable AS hotel_only_disable_27, t0.active AS active_28, t0.created_uid AS created_uid_29, t0.updated_uid AS updated_uid_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.contact_name AS contact_name_33, t0.contact_email AS contact_email_34, t0.contact_phone AS contact_phone_35, t0.contact_role AS contact_role_36, t0.address_line_1 AS address_line_1_37, t0.address_line_2 AS address_line_2_38, t0.address_postal_code AS address_postal_code_39, t0.address_city AS address_city_40, t0.address_country AS address_country_41, t0.pension_type_id AS pension_type_id_42, t0.default_formule_id AS default_formule_id_43, t0.default_supplement_id AS default_supplement_id_44, t0.booking_fee_id AS booking_fee_id_45, t0.country_id AS country_id_46, t0.home_image_id AS home_image_id_47, t0.main_image_id AS main_image_id_48, t0.gallery_id AS gallery_id_49 FROM hotel t0 WHERE t0.id = 9;

SELECT
  t0.id AS id_1,
  t0.max_adults AS max_adults_2,
  t0.max_teens AS max_teens_3,
  t0.max_children AS max_children_4,
  t0.max_babies AS max_babies_5,
  t0.room_id AS room_id_6
FROM
  capacity t0
WHERE
  t0.room_id = ?

SELECT t0.id AS id_1, t0.max_adults AS max_adults_2, t0.max_teens AS max_teens_3, t0.max_children AS max_children_4, t0.max_babies AS max_babies_5, t0.room_id AS room_id_6 FROM capacity t0 WHERE t0.room_id = 21;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.label AS label_3,
  t0.description AS description_4,
  t0.stay_start AS stay_start_5,
  t0.stay_end AS stay_end_6,
  t0.sale_start AS sale_start_7,
  t0.sale_end AS sale_end_8,
  t0.min_nights AS min_nights_9,
  t0.max_nights AS max_nights_10,
  t0.early_booking_amount_of_days AS early_booking_amount_of_days_11,
  t0.discount AS discount_12,
  t0.apply_to_all_rooms AS apply_to_all_rooms_13,
  t0.combinable AS combinable_14,
  t0.sort AS sort_15,
  t0.active AS active_16,
  t0.validation_condition AS validation_condition_17,
  t0.display_in_honey_moon AS display_in_honey_moon_18,
  t0.apply_to_all_supplements AS apply_to_all_supplements_19,
  t0.created_at AS created_at_20,
  t0.updated_at AS updated_at_21,
  t0.hotel_id AS hotel_id_22
FROM
  promotion t0
WHERE
  (
    (
      (
        (
          (
            (
              (
                (
                  t0.active = ?
                  AND t0.sale_start <= ?
                )
                AND t0.sale_end >= ?
              )
              AND (
                t0.min_nights IS NULL
                OR t0.min_nights <= ?
              )
            )
            AND (
              t0.max_nights IS NULL
              OR t0.max_nights >= ?
            )
          )
          AND (
            (
              t0.validation_condition = ?
              AND (
                t0.stay_start IS NULL
                OR t0.stay_start <= ?
              )
              AND (
                t0.stay_end IS NULL
                OR t0.stay_end >= ?
              )
            )
            OR (
              t0.validation_condition = ?
              AND (
                (
                  t0.stay_start <= ?
                  AND t0.stay_end >= ?
                )
                OR (
                  t0.stay_start <= ?
                  AND t0.stay_end >= ?
                )
              )
            )
          )
        )
        AND t0.display_in_honey_moon = ?
      )
      AND (
        t0.early_booking_amount_of_days IS NULL
        OR t0.early_booking_amount_of_days <= ?
      )
    )
    AND t0.hotel_id = ?
  )
ORDER BY
  t0.sort ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.label AS label_3, t0.description AS description_4, t0.stay_start AS stay_start_5, t0.stay_end AS stay_end_6, t0.sale_start AS sale_start_7, t0.sale_end AS sale_end_8, t0.min_nights AS min_nights_9, t0.max_nights AS max_nights_10, t0.early_booking_amount_of_days AS early_booking_amount_of_days_11, t0.discount AS discount_12, t0.apply_to_all_rooms AS apply_to_all_rooms_13, t0.combinable AS combinable_14, t0.sort AS sort_15, t0.active AS active_16, t0.validation_condition AS validation_condition_17, t0.display_in_honey_moon AS display_in_honey_moon_18, t0.apply_to_all_supplements AS apply_to_all_supplements_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.hotel_id AS hotel_id_22 FROM promotion t0 WHERE ((((((((t0.active = 1 AND t0.sale_start <= '2026-09-25') AND t0.sale_end >= '2026-09-25') AND (t0.min_nights IS NULL OR t0.min_nights <= 4)) AND (t0.max_nights IS NULL OR t0.max_nights >= 4)) AND ((t0.validation_condition = 'SEJOUR_IN_VALIDITE_STRICT' AND (t0.stay_start IS NULL OR t0.stay_start <= '2026-10-02') AND (t0.stay_end IS NULL OR t0.stay_end >= '2026-10-06')) OR (t0.validation_condition = 'SEJOUR_IN_VALIDITE' AND ((t0.stay_start <= '2026-10-02' AND t0.stay_end >= '2026-10-02') OR (t0.stay_start <= '2026-10-06' AND t0.stay_end >= '2026-10-06'))))) AND t0.display_in_honey_moon = 0) AND (t0.early_booking_amount_of_days IS NULL OR t0.early_booking_amount_of_days <= 7)) AND t0.hotel_id = 9) ORDER BY t0.sort ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.has_separate_bedroom AS has_separate_bedroom_4,
  t0.services AS services_5,
  t0.active AS active_6,
  t0.position AS position_7,
  t0.hotel_id AS hotel_id_8,
  t0.main_image_id AS main_image_id_9,
  t0.gallery_id AS gallery_id_10
FROM
  room t0
  INNER JOIN promotion_selected_room ON t0.id = promotion_selected_room.room_id
WHERE
  promotion_selected_room.promotion_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.has_separate_bedroom AS has_separate_bedroom_4, t0.services AS services_5, t0.active AS active_6, t0.position AS position_7, t0.hotel_id AS hotel_id_8, t0.main_image_id AS main_image_id_9, t0.gallery_id AS gallery_id_10 FROM room t0 INNER JOIN promotion_selected_room ON t0.id = promotion_selected_room.room_id WHERE promotion_selected_room.promotion_id = 2211;

SELECT
  c0_.id AS id_0,
  c0_.iso_code AS iso_code_1,
  c0_.name AS name_2,
  c0_.country AS country_3,
  c0_.active AS active_4,
  c0_.display_home AS display_home_5,
  c0_.sort AS sort_6,
  c0_.city_id AS city_id_7,
  c0_.zone_id AS zone_id_8,
  c0_.main_image_id AS main_image_id_9,
  c0_.gallery_id AS gallery_id_10
FROM
  country c0_
WHERE
  c0_.active = 1
  AND c0_.display_home = 1
ORDER BY
  c0_.sort DESC

SELECT c0_.id AS id_0, c0_.iso_code AS iso_code_1, c0_.name AS name_2, c0_.country AS country_3, c0_.active AS active_4, c0_.display_home AS display_home_5, c0_.sort AS sort_6, c0_.city_id AS city_id_7, c0_.zone_id AS zone_id_8, c0_.main_image_id AS main_image_id_9, c0_.gallery_id AS gallery_id_10 FROM country c0_ WHERE c0_.active = 1 AND c0_.display_home = 1 ORDER BY c0_.sort DESC;

SELECT
  t0.name AS name_1,
  t0.description AS description_2,
  t0.enabled AS enabled_3,
  t0.provider_name AS provider_name_4,
  t0.provider_status AS provider_status_5,
  t0.provider_reference AS provider_reference_6,
  t0.provider_metadata AS provider_metadata_7,
  t0.width AS width_8,
  t0.height AS height_9,
  t0.length AS length_10,
  t0.content_type AS content_type_11,
  t0.content_size AS content_size_12,
  t0.copyright AS copyright_13,
  t0.author_name AS author_name_14,
  t0.context AS context_15,
  t0.cdn_is_flushable AS cdn_is_flushable_16,
  t0.cdn_flush_identifier AS cdn_flush_identifier_17,
  t0.cdn_flush_at AS cdn_flush_at_18,
  t0.cdn_status AS cdn_status_19,
  t0.updated_at AS updated_at_20,
  t0.created_at AS created_at_21,
  t0.id AS id_22
FROM
  media__media t0
WHERE
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.enabled AS enabled_3, t0.provider_name AS provider_name_4, t0.provider_status AS provider_status_5, t0.provider_reference AS provider_reference_6, t0.provider_metadata AS provider_metadata_7, t0.width AS width_8, t0.height AS height_9, t0.length AS length_10, t0.content_type AS content_type_11, t0.content_size AS content_size_12, t0.copyright AS copyright_13, t0.author_name AS author_name_14, t0.context AS context_15, t0.cdn_is_flushable AS cdn_is_flushable_16, t0.cdn_flush_identifier AS cdn_flush_identifier_17, t0.cdn_flush_at AS cdn_flush_at_18, t0.cdn_status AS cdn_status_19, t0.updated_at AS updated_at_20, t0.created_at AS created_at_21, t0.id AS id_22 FROM media__media t0 WHERE t0.id = 5188;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3
FROM
  pension_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3 FROM pension_type t0 WHERE t0.id = 'demi_pension';

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.content AS content_3,
  t0.adult_rate AS adult_rate_4,
  t0.teen_rate AS teen_rate_5,
  t0.child_rate AS child_rate_6,
  t0.baby_rate AS baby_rate_7,
  t0.active AS active_8,
  t0.margin AS margin_9,
  t0.stay_start AS stay_start_10,
  t0.stay_end AS stay_end_11,
  t0.min_nights AS min_nights_12,
  t0.max_nights AS max_nights_13,
  t0.mandatory AS mandatory_14,
  t0.all_inclusive AS all_inclusive_15,
  t0.group_rate AS group_rate_16,
  t0.full_stay_rate AS full_stay_rate_17,
  t0.type AS type_18,
  t0.validation_condition AS validation_condition_19,
  t0.sale_start AS sale_start_20,
  t0.sale_end AS sale_end_21,
  t0.created_uid AS created_uid_22,
  t0.updated_uid AS updated_uid_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.hotel_id AS hotel_id_26
FROM
  supplement t0
WHERE
  (
    t0.type = ?
    AND t0.hotel_id = ?
  )
ORDER BY
  t0.adult_rate ASC,
  t0.label ASC

SELECT t0.id AS id_1, t0.label AS label_2, t0.content AS content_3, t0.adult_rate AS adult_rate_4, t0.teen_rate AS teen_rate_5, t0.child_rate AS child_rate_6, t0.baby_rate AS baby_rate_7, t0.active AS active_8, t0.margin AS margin_9, t0.stay_start AS stay_start_10, t0.stay_end AS stay_end_11, t0.min_nights AS min_nights_12, t0.max_nights AS max_nights_13, t0.mandatory AS mandatory_14, t0.all_inclusive AS all_inclusive_15, t0.group_rate AS group_rate_16, t0.full_stay_rate AS full_stay_rate_17, t0.type AS type_18, t0.validation_condition AS validation_condition_19, t0.sale_start AS sale_start_20, t0.sale_end AS sale_end_21, t0.created_uid AS created_uid_22, t0.updated_uid AS updated_uid_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.hotel_id AS hotel_id_26 FROM supplement t0 WHERE (t0.type = 'formule' AND t0.hotel_id = 9) ORDER BY t0.adult_rate ASC, t0.label ASC;

SELECT
  i0_.id AS id_0,
  i0_.position AS position_1,
  i0_.type AS type_2,
  i0_.post_url AS post_url_3,
  i0_.is_active AS is_active_4,
  i0_.cta_text AS cta_text_5,
  i0_.cta_link AS cta_link_6,
  i0_.social_label AS social_label_7,
  i0_.created_at AS created_at_8,
  i0_.updated_at AS updated_at_9,
  i0_.media_id AS media_id_10,
  i0_.background_media_id AS background_media_id_11
FROM
  instagram_feed i0_
WHERE
  i0_.is_active = ?
ORDER BY
  i0_.position ASC
LIMIT
  7