Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.country AS country_3
FROM
  iata_city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.country AS country_3 FROM iata_city t0 WHERE t0.id = 'MRU';

SELECT
  t0.id AS id_1,
  t0.iso_code AS iso_code_2,
  t0.name AS name_3,
  t0.country AS country_4,
  t0.active AS active_5,
  t0.display_home AS display_home_6,
  t0.sort AS sort_7,
  t0.city_id AS city_id_8,
  t0.zone_id AS zone_id_9,
  t0.main_image_id AS main_image_id_10,
  t0.gallery_id AS gallery_id_11
FROM
  country t0
WHERE
  t0.city_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.iso_code AS iso_code_2, t0.name AS name_3, t0.country AS country_4, t0.active AS active_5, t0.display_home AS display_home_6, t0.sort AS sort_7, t0.city_id AS city_id_8, t0.zone_id AS zone_id_9, t0.main_image_id AS main_image_id_10, t0.gallery_id AS gallery_id_11 FROM country t0 WHERE t0.city_id = 'MRU' LIMIT 1;

SELECT
  h0_.id AS id_0,
  h0_.type AS type_1,
  h0_.type_event AS type_event_2,
  h0_.ref AS ref_3,
  h0_.name AS name_4,
  h0_.description AS description_5,
  h0_.website AS website_6,
  h0_.stars AS stars_7,
  h0_.you_tube_video_id AS you_tube_video_id_8,
  h0_.phone AS phone_9,
  h0_.email AS email_10,
  h0_.reservation_email AS reservation_email_11,
  h0_.accompanist_email AS accompanist_email_12,
  h0_.trip_advisor_widget AS trip_advisor_widget_13,
  h0_.min_nights AS min_nights_14,
  h0_.google_map_url AS google_map_url_15,
  h0_.check_in_time AS check_in_time_16,
  h0_.check_out_time AS check_out_time_17,
  h0_.teen_age_max AS teen_age_max_18,
  h0_.child_age_max AS child_age_max_19,
  h0_.baby_age_max AS baby_age_max_20,
  h0_.margin AS margin_21,
  h0_.free_for_children_sharing_room AS free_for_children_sharing_room_22,
  h0_.free_age_min AS free_age_min_23,
  h0_.free_age_max AS free_age_max_24,
  h0_.strict_departure_countries AS strict_departure_countries_25,
  h0_.hotel_only_disable AS hotel_only_disable_26,
  h0_.active AS active_27,
  h0_.created_uid AS created_uid_28,
  h0_.updated_uid AS updated_uid_29,
  h0_.created_at AS created_at_30,
  h0_.updated_at AS updated_at_31,
  h0_.contact_name AS contact_name_32,
  h0_.contact_email AS contact_email_33,
  h0_.contact_phone AS contact_phone_34,
  h0_.contact_role AS contact_role_35,
  h0_.address_line_1 AS address_line_1_36,
  h0_.address_line_2 AS address_line_2_37,
  h0_.address_postal_code AS address_postal_code_38,
  h0_.address_city AS address_city_39,
  h0_.address_country AS address_country_40,
  m1_.name AS name_41,
  m1_.description AS description_42,
  m1_.enabled AS enabled_43,
  m1_.provider_name AS provider_name_44,
  m1_.provider_status AS provider_status_45,
  m1_.provider_reference AS provider_reference_46,
  m1_.provider_metadata AS provider_metadata_47,
  m1_.width AS width_48,
  m1_.height AS height_49,
  m1_.length AS length_50,
  m1_.content_type AS content_type_51,
  m1_.content_size AS content_size_52,
  m1_.copyright AS copyright_53,
  m1_.author_name AS author_name_54,
  m1_.context AS context_55,
  m1_.cdn_is_flushable AS cdn_is_flushable_56,
  m1_.cdn_flush_identifier AS cdn_flush_identifier_57,
  m1_.cdn_flush_at AS cdn_flush_at_58,
  m1_.cdn_status AS cdn_status_59,
  m1_.updated_at AS updated_at_60,
  m1_.created_at AS created_at_61,
  m1_.id AS id_62,
  m2_.name AS name_63,
  m2_.context AS context_64,
  m2_.default_format AS default_format_65,
  m2_.enabled AS enabled_66,
  m2_.updated_at AS updated_at_67,
  m2_.created_at AS created_at_68,
  m2_.id AS id_69,
  m2_.for_tag_id AS for_tag_id_70,
  h0_.pension_type_id AS pension_type_id_71,
  h0_.default_formule_id AS default_formule_id_72,
  h0_.default_supplement_id AS default_supplement_id_73,
  h0_.booking_fee_id AS booking_fee_id_74,
  h0_.country_id AS country_id_75,
  h0_.home_image_id AS home_image_id_76,
  h0_.main_image_id AS main_image_id_77,
  h0_.gallery_id AS gallery_id_78
FROM
  hotel h0_
  INNER JOIN country c3_ ON h0_.country_id = c3_.id
  LEFT JOIN media__media m1_ ON h0_.main_image_id = m1_.id
  LEFT JOIN media__gallery m2_ ON h0_.gallery_id = m2_.id
WHERE
  c3_.city_id = ?
  AND h0_.active = 1
  AND c3_.active = 1
ORDER BY
  h0_.name ASC

SELECT h0_.id AS id_0, h0_.type AS type_1, h0_.type_event AS type_event_2, h0_.ref AS ref_3, h0_.name AS name_4, h0_.description AS description_5, h0_.website AS website_6, h0_.stars AS stars_7, h0_.you_tube_video_id AS you_tube_video_id_8, h0_.phone AS phone_9, h0_.email AS email_10, h0_.reservation_email AS reservation_email_11, h0_.accompanist_email AS accompanist_email_12, h0_.trip_advisor_widget AS trip_advisor_widget_13, h0_.min_nights AS min_nights_14, h0_.google_map_url AS google_map_url_15, h0_.check_in_time AS check_in_time_16, h0_.check_out_time AS check_out_time_17, h0_.teen_age_max AS teen_age_max_18, h0_.child_age_max AS child_age_max_19, h0_.baby_age_max AS baby_age_max_20, h0_.margin AS margin_21, h0_.free_for_children_sharing_room AS free_for_children_sharing_room_22, h0_.free_age_min AS free_age_min_23, h0_.free_age_max AS free_age_max_24, h0_.strict_departure_countries AS strict_departure_countries_25, h0_.hotel_only_disable AS hotel_only_disable_26, h0_.active AS active_27, h0_.created_uid AS created_uid_28, h0_.updated_uid AS updated_uid_29, h0_.created_at AS created_at_30, h0_.updated_at AS updated_at_31, h0_.contact_name AS contact_name_32, h0_.contact_email AS contact_email_33, h0_.contact_phone AS contact_phone_34, h0_.contact_role AS contact_role_35, h0_.address_line_1 AS address_line_1_36, h0_.address_line_2 AS address_line_2_37, h0_.address_postal_code AS address_postal_code_38, h0_.address_city AS address_city_39, h0_.address_country AS address_country_40, m1_.name AS name_41, m1_.description AS description_42, m1_.enabled AS enabled_43, m1_.provider_name AS provider_name_44, m1_.provider_status AS provider_status_45, m1_.provider_reference AS provider_reference_46, m1_.provider_metadata AS provider_metadata_47, m1_.width AS width_48, m1_.height AS height_49, m1_.length AS length_50, m1_.content_type AS content_type_51, m1_.content_size AS content_size_52, m1_.copyright AS copyright_53, m1_.author_name AS author_name_54, m1_.context AS context_55, m1_.cdn_is_flushable AS cdn_is_flushable_56, m1_.cdn_flush_identifier AS cdn_flush_identifier_57, m1_.cdn_flush_at AS cdn_flush_at_58, m1_.cdn_status AS cdn_status_59, m1_.updated_at AS updated_at_60, m1_.created_at AS created_at_61, m1_.id AS id_62, m2_.name AS name_63, m2_.context AS context_64, m2_.default_format AS default_format_65, m2_.enabled AS enabled_66, m2_.updated_at AS updated_at_67, m2_.created_at AS created_at_68, m2_.id AS id_69, m2_.for_tag_id AS for_tag_id_70, h0_.pension_type_id AS pension_type_id_71, h0_.default_formule_id AS default_formule_id_72, h0_.default_supplement_id AS default_supplement_id_73, h0_.booking_fee_id AS booking_fee_id_74, h0_.country_id AS country_id_75, h0_.home_image_id AS home_image_id_76, h0_.main_image_id AS main_image_id_77, h0_.gallery_id AS gallery_id_78 FROM hotel h0_ INNER JOIN country c3_ ON h0_.country_id = c3_.id LEFT JOIN media__media m1_ ON h0_.main_image_id = m1_.id LEFT JOIN media__gallery m2_ ON h0_.gallery_id = m2_.id WHERE c3_.city_id = 'MRU' AND h0_.active = 1 AND c3_.active = 1 ORDER BY h0_.name ASC;

SELECT
  h0_.id AS id_0,
  m1_.name AS name_1,
  m1_.description AS description_2,
  m1_.enabled AS enabled_3,
  m1_.provider_name AS provider_name_4,
  m1_.provider_status AS provider_status_5,
  m1_.provider_reference AS provider_reference_6,
  m1_.provider_metadata AS provider_metadata_7,
  m1_.width AS width_8,
  m1_.height AS height_9,
  m1_.length AS length_10,
  m1_.content_type AS content_type_11,
  m1_.content_size AS content_size_12,
  m1_.copyright AS copyright_13,
  m1_.author_name AS author_name_14,
  m1_.context AS context_15,
  m1_.cdn_is_flushable AS cdn_is_flushable_16,
  m1_.cdn_flush_identifier AS cdn_flush_identifier_17,
  m1_.cdn_flush_at AS cdn_flush_at_18,
  m1_.cdn_status AS cdn_status_19,
  m1_.updated_at AS updated_at_20,
  m1_.created_at AS created_at_21,
  m1_.id AS id_22,
  h0_.pension_type_id AS pension_type_id_23,
  h0_.default_formule_id AS default_formule_id_24,
  h0_.default_supplement_id AS default_supplement_id_25,
  h0_.booking_fee_id AS booking_fee_id_26,
  h0_.country_id AS country_id_27,
  h0_.home_image_id AS home_image_id_28,
  h0_.main_image_id AS main_image_id_29,
  h0_.gallery_id AS gallery_id_30
FROM
  hotel h0_
  LEFT JOIN media__media m1_ ON h0_.main_image_id = m1_.id
WHERE
  h0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

SELECT h0_.id AS id_0, m1_.name AS name_1, m1_.description AS description_2, m1_.enabled AS enabled_3, m1_.provider_name AS provider_name_4, m1_.provider_status AS provider_status_5, m1_.provider_reference AS provider_reference_6, m1_.provider_metadata AS provider_metadata_7, m1_.width AS width_8, m1_.height AS height_9, m1_.length AS length_10, m1_.content_type AS content_type_11, m1_.content_size AS content_size_12, m1_.copyright AS copyright_13, m1_.author_name AS author_name_14, m1_.context AS context_15, m1_.cdn_is_flushable AS cdn_is_flushable_16, m1_.cdn_flush_identifier AS cdn_flush_identifier_17, m1_.cdn_flush_at AS cdn_flush_at_18, m1_.cdn_status AS cdn_status_19, m1_.updated_at AS updated_at_20, m1_.created_at AS created_at_21, m1_.id AS id_22, h0_.pension_type_id AS pension_type_id_23, h0_.default_formule_id AS default_formule_id_24, h0_.default_supplement_id AS default_supplement_id_25, h0_.booking_fee_id AS booking_fee_id_26, h0_.country_id AS country_id_27, h0_.home_image_id AS home_image_id_28, h0_.main_image_id AS main_image_id_29, h0_.gallery_id AS gallery_id_30 FROM hotel h0_ LEFT JOIN media__media m1_ ON h0_.main_image_id = m1_.id WHERE h0_.id IN (4, 202, 233, 234, 9, 231, 218, 273, 261, 40, 15, 249, 203, 212, 19, 259, 204, 48, 51, 62, 37, 69, 253, 217, 277, 269, 22, 11, 54, 221, 268, 13, 239, 70, 275, 66, 50, 24, 23, 205, 201, 10, 49, 12, 228, 213, 262, 214, 216, 17, 20, 14);

SELECT
  h0_.id AS id_0,
  m1_.name AS name_1,
  m1_.context AS context_2,
  m1_.default_format AS default_format_3,
  m1_.enabled AS enabled_4,
  m1_.updated_at AS updated_at_5,
  m1_.created_at AS created_at_6,
  m1_.id AS id_7,
  m1_.for_tag_id AS for_tag_id_8,
  h0_.pension_type_id AS pension_type_id_9,
  h0_.default_formule_id AS default_formule_id_10,
  h0_.default_supplement_id AS default_supplement_id_11,
  h0_.booking_fee_id AS booking_fee_id_12,
  h0_.country_id AS country_id_13,
  h0_.home_image_id AS home_image_id_14,
  h0_.main_image_id AS main_image_id_15,
  h0_.gallery_id AS gallery_id_16
FROM
  hotel h0_
  LEFT JOIN media__gallery m1_ ON h0_.gallery_id = m1_.id
WHERE
  h0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )

SELECT h0_.id AS id_0, m1_.name AS name_1, m1_.context AS context_2, m1_.default_format AS default_format_3, m1_.enabled AS enabled_4, m1_.updated_at AS updated_at_5, m1_.created_at AS created_at_6, m1_.id AS id_7, m1_.for_tag_id AS for_tag_id_8, h0_.pension_type_id AS pension_type_id_9, h0_.default_formule_id AS default_formule_id_10, h0_.default_supplement_id AS default_supplement_id_11, h0_.booking_fee_id AS booking_fee_id_12, h0_.country_id AS country_id_13, h0_.home_image_id AS home_image_id_14, h0_.main_image_id AS main_image_id_15, h0_.gallery_id AS gallery_id_16 FROM hotel h0_ LEFT JOIN media__gallery m1_ ON h0_.gallery_id = m1_.id WHERE h0_.id IN (4, 202, 233, 234, 9, 231, 218, 273, 261, 40, 15, 249, 203, 212, 19, 259, 204, 48, 51, 62, 37, 69, 253, 217, 277, 269, 22, 11, 54, 221, 268, 13, 239, 70, 275, 66, 50, 24, 23, 205, 201, 10, 49, 12, 228, 213, 262, 214, 216, 17, 20, 14);

SELECT
  m0_.id AS id_0,
  m1_.position AS position_1,
  m1_.enabled AS enabled_2,
  m1_.updated_at AS updated_at_3,
  m1_.created_at AS created_at_4,
  m1_.id AS id_5,
  m2_.name AS name_6,
  m2_.description AS description_7,
  m2_.enabled AS enabled_8,
  m2_.provider_name AS provider_name_9,
  m2_.provider_status AS provider_status_10,
  m2_.provider_reference AS provider_reference_11,
  m2_.provider_metadata AS provider_metadata_12,
  m2_.width AS width_13,
  m2_.height AS height_14,
  m2_.length AS length_15,
  m2_.content_type AS content_type_16,
  m2_.content_size AS content_size_17,
  m2_.copyright AS copyright_18,
  m2_.author_name AS author_name_19,
  m2_.context AS context_20,
  m2_.cdn_is_flushable AS cdn_is_flushable_21,
  m2_.cdn_flush_identifier AS cdn_flush_identifier_22,
  m2_.cdn_flush_at AS cdn_flush_at_23,
  m2_.cdn_status AS cdn_status_24,
  m2_.updated_at AS updated_at_25,
  m2_.created_at AS created_at_26,
  m2_.id AS id_27,
  m1_.gallery_id AS gallery_id_28,
  m1_.media_id AS media_id_29
FROM
  media__gallery m0_
  LEFT JOIN media__gallery_item m1_ ON m0_.id = m1_.gallery_id
  LEFT JOIN media__media m2_ ON m1_.media_id = m2_.id
WHERE
  m0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )
ORDER BY
  m1_.position ASC

SELECT m0_.id AS id_0, m1_.position AS position_1, m1_.enabled AS enabled_2, m1_.updated_at AS updated_at_3, m1_.created_at AS created_at_4, m1_.id AS id_5, m2_.name AS name_6, m2_.description AS description_7, m2_.enabled AS enabled_8, m2_.provider_name AS provider_name_9, m2_.provider_status AS provider_status_10, m2_.provider_reference AS provider_reference_11, m2_.provider_metadata AS provider_metadata_12, m2_.width AS width_13, m2_.height AS height_14, m2_.length AS length_15, m2_.content_type AS content_type_16, m2_.content_size AS content_size_17, m2_.copyright AS copyright_18, m2_.author_name AS author_name_19, m2_.context AS context_20, m2_.cdn_is_flushable AS cdn_is_flushable_21, m2_.cdn_flush_identifier AS cdn_flush_identifier_22, m2_.cdn_flush_at AS cdn_flush_at_23, m2_.cdn_status AS cdn_status_24, m2_.updated_at AS updated_at_25, m2_.created_at AS created_at_26, m2_.id AS id_27, m1_.gallery_id AS gallery_id_28, m1_.media_id AS media_id_29 FROM media__gallery m0_ LEFT JOIN media__gallery_item m1_ ON m0_.id = m1_.gallery_id LEFT JOIN media__media m2_ ON m1_.media_id = m2_.id WHERE m0_.id IN (512, 562, 582, 583, 514, 580, 572, 911, 859, 532, 520, 792, 563, 567, 523, 834, 564, 538, 541, 547, 531, 551, 808, 571, 939, 892, 526, 516, 544, 575, 888, 518, 728, 552, 930, 549, 540, 528, 527, 565, 561, 515, 539, 517, 578, 568, 866, 569, 570, 521, 524, 519) ORDER BY m1_.position ASC;

SELECT
  h0_.id AS id_0,
  r1_.id AS id_1,
  r1_.name AS name_2,
  r1_.description AS description_3,
  r1_.has_separate_bedroom AS has_separate_bedroom_4,
  r1_.services AS services_5,
  r1_.active AS active_6,
  r1_.position AS position_7,
  h0_.pension_type_id AS pension_type_id_8,
  h0_.default_formule_id AS default_formule_id_9,
  h0_.default_supplement_id AS default_supplement_id_10,
  h0_.booking_fee_id AS booking_fee_id_11,
  h0_.country_id AS country_id_12,
  h0_.home_image_id AS home_image_id_13,
  h0_.main_image_id AS main_image_id_14,
  h0_.gallery_id AS gallery_id_15,
  r1_.hotel_id AS hotel_id_16,
  r1_.main_image_id AS main_image_id_17,
  r1_.gallery_id AS gallery_id_18
FROM
  hotel h0_
  LEFT JOIN room r1_ ON h0_.id = r1_.hotel_id
WHERE
  h0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )
ORDER BY
  r1_.position ASC

SELECT h0_.id AS id_0, r1_.id AS id_1, r1_.name AS name_2, r1_.description AS description_3, r1_.has_separate_bedroom AS has_separate_bedroom_4, r1_.services AS services_5, r1_.active AS active_6, r1_.position AS position_7, h0_.pension_type_id AS pension_type_id_8, h0_.default_formule_id AS default_formule_id_9, h0_.default_supplement_id AS default_supplement_id_10, h0_.booking_fee_id AS booking_fee_id_11, h0_.country_id AS country_id_12, h0_.home_image_id AS home_image_id_13, h0_.main_image_id AS main_image_id_14, h0_.gallery_id AS gallery_id_15, r1_.hotel_id AS hotel_id_16, r1_.main_image_id AS main_image_id_17, r1_.gallery_id AS gallery_id_18 FROM hotel h0_ LEFT JOIN room r1_ ON h0_.id = r1_.hotel_id WHERE h0_.id IN (4, 202, 233, 234, 9, 231, 218, 273, 261, 40, 15, 249, 203, 212, 19, 259, 204, 48, 51, 62, 37, 69, 253, 217, 277, 269, 22, 11, 54, 221, 268, 13, 239, 70, 275, 66, 50, 24, 23, 205, 201, 10, 49, 12, 228, 213, 262, 214, 216, 17, 20, 14) ORDER BY r1_.position ASC;

SELECT
  h0_.id AS id_0,
  p1_.id AS id_1,
  p1_.type AS type_2,
  p1_.label AS label_3,
  p1_.description AS description_4,
  p1_.stay_start AS stay_start_5,
  p1_.stay_end AS stay_end_6,
  p1_.sale_start AS sale_start_7,
  p1_.sale_end AS sale_end_8,
  p1_.min_nights AS min_nights_9,
  p1_.max_nights AS max_nights_10,
  p1_.early_booking_amount_of_days AS early_booking_amount_of_days_11,
  p1_.discount AS discount_12,
  p1_.apply_to_all_rooms AS apply_to_all_rooms_13,
  p1_.combinable AS combinable_14,
  p1_.sort AS sort_15,
  p1_.active AS active_16,
  p1_.validation_condition AS validation_condition_17,
  p1_.display_in_honey_moon AS display_in_honey_moon_18,
  p1_.apply_to_all_supplements AS apply_to_all_supplements_19,
  p1_.created_at AS created_at_20,
  p1_.updated_at AS updated_at_21,
  h0_.pension_type_id AS pension_type_id_22,
  h0_.default_formule_id AS default_formule_id_23,
  h0_.default_supplement_id AS default_supplement_id_24,
  h0_.booking_fee_id AS booking_fee_id_25,
  h0_.country_id AS country_id_26,
  h0_.home_image_id AS home_image_id_27,
  h0_.main_image_id AS main_image_id_28,
  h0_.gallery_id AS gallery_id_29,
  p1_.hotel_id AS hotel_id_30
FROM
  hotel h0_
  LEFT JOIN promotion p1_ ON h0_.id = p1_.hotel_id
WHERE
  h0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p1_.sort ASC

SELECT h0_.id AS id_0, p1_.id AS id_1, p1_.type AS type_2, p1_.label AS label_3, p1_.description AS description_4, p1_.stay_start AS stay_start_5, p1_.stay_end AS stay_end_6, p1_.sale_start AS sale_start_7, p1_.sale_end AS sale_end_8, p1_.min_nights AS min_nights_9, p1_.max_nights AS max_nights_10, p1_.early_booking_amount_of_days AS early_booking_amount_of_days_11, p1_.discount AS discount_12, p1_.apply_to_all_rooms AS apply_to_all_rooms_13, p1_.combinable AS combinable_14, p1_.sort AS sort_15, p1_.active AS active_16, p1_.validation_condition AS validation_condition_17, p1_.display_in_honey_moon AS display_in_honey_moon_18, p1_.apply_to_all_supplements AS apply_to_all_supplements_19, p1_.created_at AS created_at_20, p1_.updated_at AS updated_at_21, h0_.pension_type_id AS pension_type_id_22, h0_.default_formule_id AS default_formule_id_23, h0_.default_supplement_id AS default_supplement_id_24, h0_.booking_fee_id AS booking_fee_id_25, h0_.country_id AS country_id_26, h0_.home_image_id AS home_image_id_27, h0_.main_image_id AS main_image_id_28, h0_.gallery_id AS gallery_id_29, p1_.hotel_id AS hotel_id_30 FROM hotel h0_ LEFT JOIN promotion p1_ ON h0_.id = p1_.hotel_id WHERE h0_.id IN (4, 202, 233, 234, 9, 231, 218, 273, 261, 40, 15, 249, 203, 212, 19, 259, 204, 48, 51, 62, 37, 69, 253, 217, 277, 269, 22, 11, 54, 221, 268, 13, 239, 70, 275, 66, 50, 24, 23, 205, 201, 10, 49, 12, 228, 213, 262, 214, 216, 17, 20, 14) ORDER BY p1_.sort ASC;

SELECT
  r0_.id AS id_0,
  m1_.name AS name_1,
  m1_.description AS description_2,
  m1_.enabled AS enabled_3,
  m1_.provider_name AS provider_name_4,
  m1_.provider_status AS provider_status_5,
  m1_.provider_reference AS provider_reference_6,
  m1_.provider_metadata AS provider_metadata_7,
  m1_.width AS width_8,
  m1_.height AS height_9,
  m1_.length AS length_10,
  m1_.content_type AS content_type_11,
  m1_.content_size AS content_size_12,
  m1_.copyright AS copyright_13,
  m1_.author_name AS author_name_14,
  m1_.context AS context_15,
  m1_.cdn_is_flushable AS cdn_is_flushable_16,
  m1_.cdn_flush_identifier AS cdn_flush_identifier_17,
  m1_.cdn_flush_at AS cdn_flush_at_18,
  m1_.cdn_status AS cdn_status_19,
  m1_.updated_at AS updated_at_20,
  m1_.created_at AS created_at_21,
  m1_.id AS id_22,
  r0_.hotel_id AS hotel_id_23,
  r0_.main_image_id AS main_image_id_24,
  r0_.gallery_id AS gallery_id_25
FROM
  room r0_
  LEFT JOIN media__media m1_ ON r0_.main_image_id = m1_.id
WHERE
  r0_.id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )