Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.type AS type_3,
  t0.description AS description_4,
  t0.stay_start_at AS stay_start_at_5,
  t0.stay_end_at AS stay_end_at_6,
  t0.booking_start_at AS booking_start_at_7,
  t0.booking_end_at AS booking_end_at_8,
  t0.reference AS reference_9,
  t0.min_nights AS min_nights_10,
  t0.max_nights AS max_nights_11,
  t0.early_booking_days AS early_booking_days_12,
  t0.apply_to_all_rooms AS apply_to_all_rooms_13,
  t0.discount AS discount_14,
  t0.combinable AS combinable_15,
  t0.combinable_discount AS combinable_discount_16,
  t0.active AS active_17,
  t0.extras_discount AS extras_discount_18,
  t0.priority AS priority_19,
  t0.discount_kids1 AS discount_kids1_20,
  t0.discount_kids2 AS discount_kids2_21,
  t0.discount_kids3 AS discount_kids3_22,
  t0.hotel_id AS hotel_id_23
FROM
  offers t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.type AS type_3, t0.description AS description_4, t0.stay_start_at AS stay_start_at_5, t0.stay_end_at AS stay_end_at_6, t0.booking_start_at AS booking_start_at_7, t0.booking_end_at AS booking_end_at_8, t0.reference AS reference_9, t0.min_nights AS min_nights_10, t0.max_nights AS max_nights_11, t0.early_booking_days AS early_booking_days_12, t0.apply_to_all_rooms AS apply_to_all_rooms_13, t0.discount AS discount_14, t0.combinable AS combinable_15, t0.combinable_discount AS combinable_discount_16, t0.active AS active_17, t0.extras_discount AS extras_discount_18, t0.priority AS priority_19, t0.discount_kids1 AS discount_kids1_20, t0.discount_kids2 AS discount_kids2_21, t0.discount_kids3 AS discount_kids3_22, t0.hotel_id AS hotel_id_23 FROM offers t0 WHERE t0.hotel_id = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.adult_extra AS adult_extra_4,
  t0.baby_extra AS baby_extra_5,
  t0.child_extra AS child_extra_6,
  t0.teen_extra AS teen_extra_7,
  t0.stay_started_at AS stay_started_at_8,
  t0.stay_ended_at AS stay_ended_at_9,
  t0.is_active AS is_active_10,
  t0.is_mandatory AS is_mandatory_11,
  t0.min_nights AS min_nights_12,
  t0.hotel_id AS hotel_id_13
FROM
  extra_charges t0
WHERE
  t0.hotel_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 WHERE t0.hotel_id = 1;

SELECT
  s0_.id AS id_0,
  s0_.start_at AS start_at_1,
  s0_.end_at AS end_at_2,
  r1_.id AS id_3,
  r1_.name AS name_4,
  r1_.description AS description_5,
  r1_.active AS active_6,
  r1_.created_at AS created_at_7,
  r1_.updated_at AS updated_at_8,
  r1_.featured_image AS featured_image_9,
  r1_.services AS services_10,
  r1_.slug AS slug_11,
  s0_.room_id AS room_id_12,
  r1_.hotel_id AS hotel_id_13
FROM
  stop_sales s0_
  LEFT JOIN rooms r1_ ON s0_.room_id = r1_.id
WHERE
  (
    s0_.start_at <= ?
    AND s0_.end_at >= ?
  )
ORDER BY
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, r1_.id AS id_3, r1_.name AS name_4, r1_.description AS description_5, r1_.active AS active_6, r1_.created_at AS created_at_7, r1_.updated_at AS updated_at_8, r1_.featured_image AS featured_image_9, r1_.services AS services_10, r1_.slug AS slug_11, s0_.room_id AS room_id_12, r1_.hotel_id AS hotel_id_13 FROM stop_sales s0_ LEFT JOIN rooms r1_ ON s0_.room_id = r1_.id WHERE (s0_.start_at <= '2024-12-26 23:59:00' AND s0_.end_at >= '2024-12-22 00:00:00') ORDER BY s0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.adult_extra AS adult_extra_4,
  t0.baby_extra AS baby_extra_5,
  t0.child_extra AS child_extra_6,
  t0.teen_extra AS teen_extra_7,
  t0.stay_started_at AS stay_started_at_8,
  t0.stay_ended_at AS stay_ended_at_9,
  t0.is_active AS is_active_10,
  t0.is_mandatory AS is_mandatory_11,
  t0.min_nights AS min_nights_12,
  t0.hotel_id AS hotel_id_13
FROM
  extra_charges t0
  INNER JOIN offers_extras_discounted ON t0.id = offers_extras_discounted.extra_charges_id
WHERE
  offers_extras_discounted.offers_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 INNER JOIN offers_extras_discounted ON t0.id = offers_extras_discounted.extra_charges_id WHERE offers_extras_discounted.offers_id = 28;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.adult_extra AS adult_extra_4,
  t0.baby_extra AS baby_extra_5,
  t0.child_extra AS child_extra_6,
  t0.teen_extra AS teen_extra_7,
  t0.stay_started_at AS stay_started_at_8,
  t0.stay_ended_at AS stay_ended_at_9,
  t0.is_active AS is_active_10,
  t0.is_mandatory AS is_mandatory_11,
  t0.min_nights AS min_nights_12,
  t0.hotel_id AS hotel_id_13
FROM
  extra_charges t0
  INNER JOIN offers_extra_charges ON t0.id = offers_extra_charges.extra_charges_id
WHERE
  offers_extra_charges.offers_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.adult_extra AS adult_extra_4, t0.baby_extra AS baby_extra_5, t0.child_extra AS child_extra_6, t0.teen_extra AS teen_extra_7, t0.stay_started_at AS stay_started_at_8, t0.stay_ended_at AS stay_ended_at_9, t0.is_active AS is_active_10, t0.is_mandatory AS is_mandatory_11, t0.min_nights AS min_nights_12, t0.hotel_id AS hotel_id_13 FROM extra_charges t0 INNER JOIN offers_extra_charges ON t0.id = offers_extra_charges.extra_charges_id WHERE offers_extra_charges.offers_id = 28;

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.description AS description_2,
  h0_.website AS website_3,
  h0_.stars AS stars_4,
  h0_.youtube_video_id AS youtube_video_id_5,
  h0_.phone AS phone_6,
  h0_.email AS email_7,
  h0_.active AS active_8,
  h0_.gmap_url AS gmap_url_9,
  h0_.zone AS zone_10,
  h0_.created_at AS created_at_11,
  h0_.updated_at AS updated_at_12,
  h0_.address AS address_13,
  h0_.check_in_time AS check_in_time_14,
  h0_.check_out_time AS check_out_time_15,
  h0_.baby_age_max AS baby_age_max_16,
  h0_.child_age_max AS child_age_max_17,
  h0_.teen_age_max AS teen_age_max_18,
  h0_.featured_image AS featured_image_19,
  h0_.highlighted AS highlighted_20,
  h0_.services AS services_21,
  h0_.hl_start_at AS hl_start_at_22,
  h0_.hl_end_at AS hl_end_at_23,
  h0_.slug AS slug_24,
  r1_.id AS id_25,
  r1_.name AS name_26,
  r1_.description AS description_27,
  r1_.active AS active_28,
  r1_.created_at AS created_at_29,
  r1_.updated_at AS updated_at_30,
  r1_.featured_image AS featured_image_31,
  r1_.services AS services_32,
  r1_.slug AS slug_33,
  r2_.id AS id_34,
  r2_.title AS title_35,
  r2_.quantity AS quantity_36,
  r2_.stay_started_at AS stay_started_at_37,
  r2_.stay_ended_at AS stay_ended_at_38,
  r2_.sale_started_at AS sale_started_at_39,
  r2_.sale_ended_at AS sale_ended_at_40,
  r2_.min_nights AS min_nights_41,
  r2_.double_occupancy AS double_occupancy_42,
  r2_.single_occupancy AS single_occupancy_43,
  r2_.triple_occupancy AS triple_occupancy_44,
  r2_.active AS active_45,
  r2_.extra_baby AS extra_baby_46,
  r2_.extra_child AS extra_child_47,
  r2_.extra_teen AS extra_teen_48,
  r2_.default_extra_label AS default_extra_label_49,
  g3_.id AS id_50,
  g3_.title AS title_51,
  g4_.id AS id_52,
  g4_.title AS title_53,
  r1_.hotel_id AS hotel_id_54,
  r2_.room_id AS room_id_55,
  g3_.hotel_id AS hotel_id_56,
  g3_.room_id AS room_id_57,
  g4_.hotel_id AS hotel_id_58,
  g4_.room_id AS room_id_59
FROM
  hotels h0_
  LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id
  LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id
  LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id
  LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id
WHERE
  h0_.active = 1
  AND r1_.active = 1
  AND r2_.active = 1
  AND h0_.id IN (12)
  AND (
    r2_.stay_started_at <= ?
    AND r2_.stay_ended_at >= ?
  )
ORDER BY
  h0_.name ASC,
  r2_.stay_started_at ASC
LIMIT
  500

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id IN (12) AND (r2_.stay_started_at <= '2024-12-26 23:59:00' AND r2_.stay_ended_at >= '2024-12-22 00:00:00') ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.website AS website_4,
  t0.stars AS stars_5,
  t0.youtube_video_id AS youtube_video_id_6,
  t0.phone AS phone_7,
  t0.email AS email_8,
  t0.active AS active_9,
  t0.gmap_url AS gmap_url_10,
  t0.zone AS zone_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.address AS address_14,
  t0.check_in_time AS check_in_time_15,
  t0.check_out_time AS check_out_time_16,
  t0.baby_age_max AS baby_age_max_17,
  t0.child_age_max AS child_age_max_18,
  t0.teen_age_max AS teen_age_max_19,
  t0.featured_image AS featured_image_20,
  t0.highlighted AS highlighted_21,
  t0.services AS services_22,
  t0.hl_start_at AS hl_start_at_23,
  t0.hl_end_at AS hl_end_at_24,
  t0.slug AS slug_25,
  t26.id AS id_27,
  t26.title AS title_28,
  t26.hotel_id AS hotel_id_29,
  t26.room_id AS room_id_30
FROM
  hotels t0
  LEFT JOIN galleries t26 ON t26.hotel_id = t0.id
WHERE
  t0.zone IN (?, ?, ?)
  AND t0.active = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.website AS website_4, t0.stars AS stars_5, t0.youtube_video_id AS youtube_video_id_6, t0.phone AS phone_7, t0.email AS email_8, t0.active AS active_9, t0.gmap_url AS gmap_url_10, t0.zone AS zone_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.address AS address_14, t0.check_in_time AS check_in_time_15, t0.check_out_time AS check_out_time_16, t0.baby_age_max AS baby_age_max_17, t0.child_age_max AS child_age_max_18, t0.teen_age_max AS teen_age_max_19, t0.featured_image AS featured_image_20, t0.highlighted AS highlighted_21, t0.services AS services_22, t0.hl_start_at AS hl_start_at_23, t0.hl_end_at AS hl_end_at_24, t0.slug AS slug_25, t26.id AS id_27, t26.title AS title_28, t26.hotel_id AS hotel_id_29, t26.room_id AS room_id_30 FROM hotels t0 LEFT JOIN galleries t26 ON t26.hotel_id = t0.id WHERE t0.zone IN ('ouest', 'nord-ouest', 'sud-ouest') AND t0.active = 1;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.description AS description_2,
  r0_.active AS active_3,
  r0_.created_at AS created_at_4,
  r0_.updated_at AS updated_at_5,
  r0_.featured_image AS featured_image_6,
  r0_.services AS services_7,
  r0_.slug AS slug_8,
  r1_.id AS id_9,
  r1_.adults AS adults_10,
  r1_.teens AS teens_11,
  r1_.children AS children_12,
  r1_.babies AS babies_13,
  r1_.is_default_config AS is_default_config_14,
  r0_.hotel_id AS hotel_id_15,
  r1_.room_id AS room_id_16
FROM
  rooms r0_
  LEFT JOIN room_capacities r1_ ON r0_.id = r1_.room_id
WHERE
  r0_.id IN (
    66, 75, 67, 68, 74, 69, 70, 65, 71, 73, 72
  )

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.description AS description_2, r0_.active AS active_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.featured_image AS featured_image_6, r0_.services AS services_7, r0_.slug AS slug_8, r1_.id AS id_9, r1_.adults AS adults_10, r1_.teens AS teens_11, r1_.children AS children_12, r1_.babies AS babies_13, r1_.is_default_config AS is_default_config_14, r0_.hotel_id AS hotel_id_15, r1_.room_id AS room_id_16 FROM rooms r0_ LEFT JOIN room_capacities r1_ ON r0_.id = r1_.room_id WHERE r0_.id IN (66, 75, 67, 68, 74, 69, 70, 65, 71, 73, 72);

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.description AS description_2,
  h0_.website AS website_3,
  h0_.stars AS stars_4,
  h0_.youtube_video_id AS youtube_video_id_5,
  h0_.phone AS phone_6,
  h0_.email AS email_7,
  h0_.active AS active_8,
  h0_.gmap_url AS gmap_url_9,
  h0_.zone AS zone_10,
  h0_.created_at AS created_at_11,
  h0_.updated_at AS updated_at_12,
  h0_.address AS address_13,
  h0_.check_in_time AS check_in_time_14,
  h0_.check_out_time AS check_out_time_15,
  h0_.baby_age_max AS baby_age_max_16,
  h0_.child_age_max AS child_age_max_17,
  h0_.teen_age_max AS teen_age_max_18,
  h0_.featured_image AS featured_image_19,
  h0_.highlighted AS highlighted_20,
  h0_.services AS services_21,
  h0_.hl_start_at AS hl_start_at_22,
  h0_.hl_end_at AS hl_end_at_23,
  h0_.slug AS slug_24,
  r1_.id AS id_25,
  r1_.name AS name_26,
  r1_.description AS description_27,
  r1_.active AS active_28,
  r1_.created_at AS created_at_29,
  r1_.updated_at AS updated_at_30,
  r1_.featured_image AS featured_image_31,
  r1_.services AS services_32,
  r1_.slug AS slug_33,
  r2_.id AS id_34,
  r2_.title AS title_35,
  r2_.quantity AS quantity_36,
  r2_.stay_started_at AS stay_started_at_37,
  r2_.stay_ended_at AS stay_ended_at_38,
  r2_.sale_started_at AS sale_started_at_39,
  r2_.sale_ended_at AS sale_ended_at_40,
  r2_.min_nights AS min_nights_41,
  r2_.double_occupancy AS double_occupancy_42,
  r2_.single_occupancy AS single_occupancy_43,
  r2_.triple_occupancy AS triple_occupancy_44,
  r2_.active AS active_45,
  r2_.extra_baby AS extra_baby_46,
  r2_.extra_child AS extra_child_47,
  r2_.extra_teen AS extra_teen_48,
  r2_.default_extra_label AS default_extra_label_49,
  g3_.id AS id_50,
  g3_.title AS title_51,
  g4_.id AS id_52,
  g4_.title AS title_53,
  r1_.hotel_id AS hotel_id_54,
  r2_.room_id AS room_id_55,
  g3_.hotel_id AS hotel_id_56,
  g3_.room_id AS room_id_57,
  g4_.hotel_id AS hotel_id_58,
  g4_.room_id AS room_id_59
FROM
  hotels h0_
  LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id
  LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id
  LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id
  LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id
WHERE
  h0_.active = 1
  AND r1_.active = 1
  AND r2_.active = 1
  AND h0_.id IN (23, 26)
  AND (
    r2_.stay_started_at <= ?
    AND r2_.stay_ended_at >= ?
  )
ORDER BY
  h0_.name ASC,
  r2_.stay_started_at ASC
LIMIT
  500

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id IN (23, 26) AND (r2_.stay_started_at <= '2024-12-26 23:59:00' AND r2_.stay_ended_at >= '2024-12-22 00:00:00') ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500;

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.description AS description_2,
  h0_.website AS website_3,
  h0_.stars AS stars_4,
  h0_.youtube_video_id AS youtube_video_id_5,
  h0_.phone AS phone_6,
  h0_.email AS email_7,
  h0_.active AS active_8,
  h0_.gmap_url AS gmap_url_9,
  h0_.zone AS zone_10,
  h0_.created_at AS created_at_11,
  h0_.updated_at AS updated_at_12,
  h0_.address AS address_13,
  h0_.check_in_time AS check_in_time_14,
  h0_.check_out_time AS check_out_time_15,
  h0_.baby_age_max AS baby_age_max_16,
  h0_.child_age_max AS child_age_max_17,
  h0_.teen_age_max AS teen_age_max_18,
  h0_.featured_image AS featured_image_19,
  h0_.highlighted AS highlighted_20,
  h0_.services AS services_21,
  h0_.hl_start_at AS hl_start_at_22,
  h0_.hl_end_at AS hl_end_at_23,
  h0_.slug AS slug_24,
  r1_.id AS id_25,
  r1_.name AS name_26,
  r1_.description AS description_27,
  r1_.active AS active_28,
  r1_.created_at AS created_at_29,
  r1_.updated_at AS updated_at_30,
  r1_.featured_image AS featured_image_31,
  r1_.services AS services_32,
  r1_.slug AS slug_33,
  r2_.id AS id_34,
  r2_.title AS title_35,
  r2_.quantity AS quantity_36,
  r2_.stay_started_at AS stay_started_at_37,
  r2_.stay_ended_at AS stay_ended_at_38,
  r2_.sale_started_at AS sale_started_at_39,
  r2_.sale_ended_at AS sale_ended_at_40,
  r2_.min_nights AS min_nights_41,
  r2_.double_occupancy AS double_occupancy_42,
  r2_.single_occupancy AS single_occupancy_43,
  r2_.triple_occupancy AS triple_occupancy_44,
  r2_.active AS active_45,
  r2_.extra_baby AS extra_baby_46,
  r2_.extra_child AS extra_child_47,
  r2_.extra_teen AS extra_teen_48,
  r2_.default_extra_label AS default_extra_label_49,
  g3_.id AS id_50,
  g3_.title AS title_51,
  g4_.id AS id_52,
  g4_.title AS title_53,
  r1_.hotel_id AS hotel_id_54,
  r2_.room_id AS room_id_55,
  g3_.hotel_id AS hotel_id_56,
  g3_.room_id AS room_id_57,
  g4_.hotel_id AS hotel_id_58,
  g4_.room_id AS room_id_59
FROM
  hotels h0_
  LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id
  LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id
  LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id
  LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id
WHERE
  h0_.active = 1
  AND r1_.active = 1
  AND r2_.active = 1
  AND h0_.id IN (17)
  AND (
    r2_.stay_started_at <= ?
    AND r2_.stay_ended_at >= ?
  )
ORDER BY
  h0_.name ASC,
  r2_.stay_started_at ASC
LIMIT
  500

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.description AS description_2, h0_.website AS website_3, h0_.stars AS stars_4, h0_.youtube_video_id AS youtube_video_id_5, h0_.phone AS phone_6, h0_.email AS email_7, h0_.active AS active_8, h0_.gmap_url AS gmap_url_9, h0_.zone AS zone_10, h0_.created_at AS created_at_11, h0_.updated_at AS updated_at_12, h0_.address AS address_13, h0_.check_in_time AS check_in_time_14, h0_.check_out_time AS check_out_time_15, h0_.baby_age_max AS baby_age_max_16, h0_.child_age_max AS child_age_max_17, h0_.teen_age_max AS teen_age_max_18, h0_.featured_image AS featured_image_19, h0_.highlighted AS highlighted_20, h0_.services AS services_21, h0_.hl_start_at AS hl_start_at_22, h0_.hl_end_at AS hl_end_at_23, h0_.slug AS slug_24, r1_.id AS id_25, r1_.name AS name_26, r1_.description AS description_27, r1_.active AS active_28, r1_.created_at AS created_at_29, r1_.updated_at AS updated_at_30, r1_.featured_image AS featured_image_31, r1_.services AS services_32, r1_.slug AS slug_33, r2_.id AS id_34, r2_.title AS title_35, r2_.quantity AS quantity_36, r2_.stay_started_at AS stay_started_at_37, r2_.stay_ended_at AS stay_ended_at_38, r2_.sale_started_at AS sale_started_at_39, r2_.sale_ended_at AS sale_ended_at_40, r2_.min_nights AS min_nights_41, r2_.double_occupancy AS double_occupancy_42, r2_.single_occupancy AS single_occupancy_43, r2_.triple_occupancy AS triple_occupancy_44, r2_.active AS active_45, r2_.extra_baby AS extra_baby_46, r2_.extra_child AS extra_child_47, r2_.extra_teen AS extra_teen_48, r2_.default_extra_label AS default_extra_label_49, g3_.id AS id_50, g3_.title AS title_51, g4_.id AS id_52, g4_.title AS title_53, r1_.hotel_id AS hotel_id_54, r2_.room_id AS room_id_55, g3_.hotel_id AS hotel_id_56, g3_.room_id AS room_id_57, g4_.hotel_id AS hotel_id_58, g4_.room_id AS room_id_59 FROM hotels h0_ LEFT JOIN rooms r1_ ON h0_.id = r1_.hotel_id LEFT JOIN room_prices r2_ ON r1_.id = r2_.room_id LEFT JOIN galleries g3_ ON h0_.id = g3_.hotel_id LEFT JOIN galleries g4_ ON r1_.id = g4_.room_id WHERE h0_.active = 1 AND r1_.active = 1 AND r2_.active = 1 AND h0_.id IN (17) AND (r2_.stay_started_at <= '2024-12-26 23:59:00' AND r2_.stay_ended_at >= '2024-12-22 00:00:00') ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500;