265.91 ms
23
SELECT t0 . id AS id_1 , t0 . adults AS adults_2 , t0 . teens AS teens_3 , t0 . children AS children_4 , t0 . babies AS babies_5 , t0 . is_default_config AS is_default_config_6 , t0 . room_id AS room_id_7 FROM room_capacities t0 WHERE t0 . room_id = ?
SELECT t0 . id AS id_1 , t0 . adults AS adults_2 , t0 . teens AS teens_3 , t0 . children AS children_4 , t0 . babies AS babies_5 , t0 . is_default_config AS is_default_config_6 , t0 . room_id AS room_id_7 FROM room_capacities t0 WHERE t0 . room_id = 22 ; Copy
60.19 ms
5
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 ; Copy
59.46 ms
5
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 ; Copy
48.64 ms
4
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
Parameters :
[
"2024-12-08 23:59:00 "
"2024-12-01 00:00:00 "
]
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-08 23:59:00' AND s0_ . end_at > = '2024-12-01 00:00:00' ) ORDER BY s0_ . id ASC ; Copy
48.13 ms
4
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 = 4 ; Copy
47.60 ms
4
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 = 4 ; Copy
45.34 ms
4
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . hotel_id AS hotel_id_3 , t0 . room_id AS room_id_4 FROM galleries t0 WHERE t0 . hotel_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . hotel_id AS hotel_id_3 , t0 . room_id AS room_id_4 FROM galleries t0 WHERE t0 . hotel_id = 4 ; Copy
24.73 ms
1
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 = 13 AND (r2_ . stay_started_at < = ? AND r2_ . stay_ended_at > = ? ) ORDER BY h0_ . name ASC , r2_ . stay_started_at ASC LIMIT 500
Parameters :
[
"2024-12-06 23:59:00 "
"2024-11-29 00:00:00 "
]
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 = 13
AND (
r2_ . stay_started_at < = ?
AND r2_ . stay_ended_at > = ?
)
ORDER BY
h0_ . name ASC ,
r2_ . stay_started_at ASC
LIMIT
500 Copy
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 = 13 AND (r2_ . stay_started_at < = '2024-12-06 23:59:00' AND r2_ . stay_ended_at > = '2024-11-29 00:00:00' ) ORDER BY h0_ . name ASC , r2_ . stay_started_at ASC LIMIT 500 ; Copy
14.80 ms
1
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 = 17 AND (r2_ . stay_started_at < = ? AND r2_ . stay_ended_at > = ? ) ORDER BY h0_ . name ASC , r2_ . stay_started_at ASC LIMIT 500
Parameters :
[
"2024-11-06 23:59:00 "
"2024-10-30 00:00:00 "
]
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 = 17
AND (
r2_ . stay_started_at < = ?
AND r2_ . stay_ended_at > = ?
)
ORDER BY
h0_ . name ASC ,
r2_ . stay_started_at ASC
LIMIT
500 Copy
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 = 17 AND (r2_ . stay_started_at < = '2024-11-06 23:59:00' AND r2_ . stay_ended_at > = '2024-10-30 00:00:00' ) ORDER BY h0_ . name ASC , r2_ . stay_started_at ASC LIMIT 500 ; Copy
14.62 ms
1
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 = 26 AND (r2_ . stay_started_at < = ? AND r2_ . stay_ended_at > = ? ) ORDER BY h0_ . name ASC , r2_ . stay_started_at ASC LIMIT 500
Parameters :
[
"2024-11-24 23:59:00 "
"2024-11-20 00:00:00 "
]
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 = 26
AND (
r2_ . stay_started_at < = ?
AND r2_ . stay_ended_at > = ?
)
ORDER BY
h0_ . name ASC ,
r2_ . stay_started_at ASC
LIMIT
500 Copy
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 = 26 AND (r2_ . stay_started_at < = '2024-11-24 23:59:00' AND r2_ . stay_ended_at > = '2024-11-20 00:00:00' ) ORDER BY h0_ . name ASC , r2_ . stay_started_at ASC LIMIT 500 ; Copy
12.59 ms
1
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 = 4 AND (r2_ . stay_started_at < = ? AND r2_ . stay_ended_at > = ? ) ORDER BY h0_ . name ASC , r2_ . stay_started_at ASC LIMIT 500
Parameters :
[
"2024-12-08 23:59:00 "
"2024-12-01 00:00:00 "
]
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 = 4
AND (
r2_ . stay_started_at < = ?
AND r2_ . stay_ended_at > = ?
)
ORDER BY
h0_ . name ASC ,
r2_ . stay_started_at ASC
LIMIT
500 Copy
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 = 4 AND (r2_ . stay_started_at < = '2024-12-08 23:59:00' AND r2_ . stay_ended_at > = '2024-12-01 00:00:00' ) ORDER BY h0_ . name ASC , r2_ . stay_started_at ASC LIMIT 500 ; Copy
12.13 ms
1
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . keywords AS keywords_4 , t0 . content AS content_5 , t0 . featured_image AS featured_image_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . uploaded_at AS uploaded_at_9 , t0 . is_highlighted AS is_highlighted_10 , t0 . is_active AS is_active_11 , t0 . popular AS popular_12 , t0 . users_id AS users_id_13 , t0 . categories_id AS categories_id_14 FROM posts t0 WHERE t0 . is_highlighted = ? ORDER BY t0 . id DESC LIMIT 1
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . keywords AS keywords_4 , t0 . content AS content_5 , t0 . featured_image AS featured_image_6 , t0 . created_at AS created_at_7 , t0 . updated_at AS updated_at_8 , t0 . uploaded_at AS uploaded_at_9 , t0 . is_highlighted AS is_highlighted_10 , t0 . is_active AS is_active_11 , t0 . popular AS popular_12 , t0 . users_id AS users_id_13 , t0 . categories_id AS categories_id_14 FROM posts t0 WHERE t0 . is_highlighted = 1 ORDER BY t0 . id DESC LIMIT 1 ; Copy
12.05 ms
1
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 FROM hotels h0_ WHERE h0_ . active = 1 AND h0_ . highlighted = 1 LIMIT 10
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 FROM hotels h0_ WHERE h0_ . active = 1 AND h0_ . highlighted = 1 LIMIT 10 ; Copy
11.61 ms
1
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 = ?
Parameters :
[
"POST_BANNER_HOME "
]
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 = 'POST_BANNER_HOME' ; Copy
11.58 ms
1
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . active AS active_4 FROM faq t0 WHERE t0 . active = ? ORDER BY t0 . id ASC
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . active AS active_4 FROM faq t0 WHERE t0 . active = 1 ORDER BY t0 . id ASC ; Copy