Symfony Profiler

Query Metrics

105 Database Queries
32 Different statements
1303.51 ms Query time
0 Invalid entities
Queries


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.active = ? AND t0.stars = ?
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 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 (2, 18) AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500
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 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 (3, 21, 24, 25, 26) AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500
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 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 (5) AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500
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 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 (10) AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500
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 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 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 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 (13) AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500
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 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 (16) AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500
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 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 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 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 (19, 22) AND (r2_.stay_started_at <= ? AND r2_.stay_ended_at >= ?) ORDER BY h0_.name ASC, r2_.stay_started_at ASC LIMIT 500
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 (112, 118, 117, 111, 116, 113, 115, 107, 110, 108, 114, 109)
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 (4, 12, 11, 10, 9, 8, 7, 6, 5)
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 (13, 14, 15, 16, 18, 19)
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 (155, 156, 157, 158, 159, 160)
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 (132, 131, 130, 129)
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 (150, 151, 149, 148, 147)
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 (161, 162, 163, 164, 165)
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 (26, 28, 30, 31, 228, 229)
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 (56, 57, 58, 59)
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 (65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75)
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 (76, 77, 78, 79, 80)
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 (91, 92, 93, 94, 95, 96, 97)
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 (98, 99, 100, 101, 102, 103, 104, 105, 106)
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 (119, 120, 121, 122)
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 (135, 136, 137)
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.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.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_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_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_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 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 = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.featured_image AS featured_image_7, t0.services AS services_8, t0.slug AS slug_9, t0.hotel_id AS hotel_id_10, t11.id AS id_12, t11.title AS title_13, t11.hotel_id AS hotel_id_14, t11.room_id AS room_id_15 FROM rooms t0 LEFT JOIN galleries t11 ON t11.room_id = t0.id INNER JOIN offers_rooms ON t0.id = offers_rooms.rooms_id WHERE offers_rooms.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 = ?
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.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.featured_image AS featured_image_7, t0.services AS services_8, t0.slug AS slug_9, t0.hotel_id AS hotel_id_10, t11.id AS id_12, t11.title AS title_13, t11.hotel_id AS hotel_id_14, t11.room_id AS room_id_15 FROM rooms t0 LEFT JOIN galleries t11 ON t11.room_id = t0.id INNER JOIN offers_rooms ON t0.id = offers_rooms.rooms_id WHERE offers_rooms.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 = ?
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.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.featured_image AS featured_image_7, t0.services AS services_8, t0.slug AS slug_9, t0.hotel_id AS hotel_id_10, t11.id AS id_12, t11.title AS title_13, t11.hotel_id AS hotel_id_14, t11.room_id AS room_id_15 FROM rooms t0 LEFT JOIN galleries t11 ON t11.room_id = t0.id INNER JOIN offers_rooms ON t0.id = offers_rooms.rooms_id WHERE offers_rooms.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 = ?
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 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 = ?
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_extras_discounted ON t0.id = offers_extras_discounted.extra_charges_id WHERE offers_extras_discounted.offers_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.featured_image AS featured_image_7, t0.services AS services_8, t0.slug AS slug_9, t0.hotel_id AS hotel_id_10, t11.id AS id_12, t11.title AS title_13, t11.hotel_id AS hotel_id_14, t11.room_id AS room_id_15 FROM rooms t0 LEFT JOIN galleries t11 ON t11.room_id = t0.id INNER JOIN offers_rooms ON t0.id = offers_rooms.rooms_id WHERE offers_rooms.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 = ?
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 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 = ?
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_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 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 = ?
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_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 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 = ?
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_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 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 = ?
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_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 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 = ?
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_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 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 = ?
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.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.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.featured_image AS featured_image_7, t0.services AS services_8, t0.slug AS slug_9, t0.hotel_id AS hotel_id_10, t11.id AS id_12, t11.title AS title_13, t11.hotel_id AS hotel_id_14, t11.room_id AS room_id_15 FROM rooms t0 LEFT JOIN galleries t11 ON t11.room_id = t0.id INNER JOIN offers_rooms ON t0.id = offers_rooms.rooms_id WHERE offers_rooms.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 = ?
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.name AS name_2, t0.description AS description_3, t0.active AS active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.featured_image AS featured_image_7, t0.services AS services_8, t0.slug AS slug_9, t0.hotel_id AS hotel_id_10, t11.id AS id_12, t11.title AS title_13, t11.hotel_id AS hotel_id_14, t11.room_id AS room_id_15 FROM rooms t0 LEFT JOIN galleries t11 ON t11.room_id = t0.id INNER JOIN offers_rooms ON t0.id = offers_rooms.rooms_id WHERE offers_rooms.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 = ?
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 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 = ?
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.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.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_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 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 = ?
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_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 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 = ?
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.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.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_extras_discounted ON t0.id = offers_extras_discounted.extra_charges_id WHERE offers_extras_discounted.offers_id = ?
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.btn_label AS btn_label_3, s0_.btn_link AS btn_link_4, s0_.bg_image AS bg_image_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.active AS active_8, s0_.hook AS hook_9 FROM slides s0_ WHERE s0_.active = 1 AND s0_.hook IS NULL ORDER BY s0_.id ASC LIMIT 10
Database Connections

Name	Service
default	doctrine.dbal.default_connection
Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
Second Level Cache

Second Level Cache is not enabled.
Entities Mapping

Class	Mapping errors
App\Entity\Hotels	No errors.
App\Entity\Galleries	No errors.
App\Entity\Rooms	No errors.
App\Entity\ExtraCharges	No errors.
App\Entity\Offers	No errors.
App\Entity\Images	No errors.
App\Entity\StopSales	No errors.
App\Entity\RoomPrices	No errors.
App\Entity\RoomCapacities	No errors.
App\Entity\Slides	No errors.
App\Entity\Insurances	No errors.
App\Entity\Posts	No errors.
App\Entity\Orders	No errors.
App\Entity\Transfers	No errors.
App\Entity\Categories	No errors.
App\Entity\Users	No errors.
App\Entity\Faq	No errors.
Vich\UploaderBundle\Entity\File	No errors.
Symfony Profiler

GET http://vps-b29a5976.vps.ovh.net/voyage-hotels/etoiles-5

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
