GET http://51.77.230.96/_partial?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CHomeController%253A%253ArenderHeadingSlider

Response
200 OK
Browse referrer URL
IP
18.119.113.79
Profiled on
Token
5f8366

Query Metrics

67 Database Queries
26 Different statements
1129.10 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 32.32 ms 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.website AS website_4, t0.stars AS stars_5, t0.youtube_video_id AS youtube_video_id_6, t0.phone AS phone_7, t0.email AS email_8, t0.active AS active_9, t0.gmap_url AS gmap_url_10, t0.zone AS zone_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.address AS address_14, t0.check_in_time AS check_in_time_15, t0.check_out_time AS check_out_time_16, t0.baby_age_max AS baby_age_max_17, t0.child_age_max AS child_age_max_18, t0.teen_age_max AS teen_age_max_19, t0.featured_image AS featured_image_20, t0.highlighted AS highlighted_21, t0.services AS services_22, t0.hl_start_at AS hl_start_at_23, t0.hl_end_at AS hl_end_at_24, t0.slug AS slug_25, t26.id AS id_27, t26.title AS title_28, t26.hotel_id AS hotel_id_29, t26.room_id AS room_id_30 FROM hotels t0 LEFT JOIN galleries t26 ON t26.hotel_id = t0.id WHERE t0.zone IN (?, ?, ?) AND t0.active = ?
Parameters: 
[
  "nord"
  "nord-est"
  "nord-ouest"
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
2 16.48 ms 
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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
3 18.03 ms 
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 (9, 10) 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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
4 16.21 ms 
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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 18.05 ms 
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 (11) 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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 16.31 ms 
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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 17.86 ms 
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
Parameters: 
[
  "2024-12-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 15.99 ms 
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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 35.77 ms 
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 (15, 18) 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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 16.29 ms 
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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 18.53 ms 
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
Parameters: 
[
  "2024-12-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 16.32 ms 
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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 18.39 ms 
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
Parameters: 
[
  "2024-12-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 15.99 ms 
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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 17.38 ms 
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) 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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 16.33 ms 
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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 18.00 ms 
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 (21, 24) 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-26 23:59:00"
  "2024-12-22 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 16.45 ms 
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 (52, 53, 54)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
19 15.93 ms 
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)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
20 16.56 ms 
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 (60, 61, 62, 63, 64)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
21 16.73 ms 
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)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
22 15.98 ms 
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 (108, 112, 113, 111, 110, 114, 109, 115, 107, 116, 117, 118)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
23 16.11 ms 
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 (224, 223, 90, 89, 88, 87, 86)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
24 15.94 ms 
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)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
25 16.61 ms 
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 (99, 106, 100, 101, 105, 102, 98, 103, 104)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
26 16.16 ms 
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)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
27 16.02 ms 
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 (130, 131, 132, 129)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
28 16.55 ms 
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 (147, 148, 151, 149, 150)
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
29 16.46 ms 
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 = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
30 16.00 ms 
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 = ?
Parameters: 
[
  9
]
View formatted query    View runnable query    Explain query    View query backtrace
31 15.70 ms 
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 = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
32 15.72 ms 
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 = ?
Parameters: 
[
  10
]
View formatted query    View runnable query    Explain query    View query backtrace
33 15.71 ms 
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 = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
34 15.78 ms 
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 = ?
Parameters: 
[
  11
]
View formatted query    View runnable query    Explain query    View query backtrace
35 15.84 ms 
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 = ?
Parameters: 
[
  126
]
View formatted query    View runnable query    Explain query    View query backtrace
36 16.20 ms 
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 = ?
Parameters: 
[
  126
]
View formatted query    View runnable query    Explain query    View query backtrace
37 15.86 ms 
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 = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query    View query backtrace
38 16.36 ms 
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 = ?
Parameters: 
[
  13
]
View formatted query    View runnable query    Explain query    View query backtrace
39 16.36 ms 
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 = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query    View query backtrace
40 15.90 ms 
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 = ?
Parameters: 
[
  18
]
View formatted query    View runnable query    Explain query    View query backtrace
41 17.73 ms 
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 = ?
Parameters: 
[
  124
]
View formatted query    View runnable query    Explain query    View query backtrace
42 16.23 ms 
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 = ?
Parameters: 
[
  124
]
View formatted query    View runnable query    Explain query    View query backtrace
43 16.09 ms 
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 = ?
Parameters: 
[
  176
]
View formatted query    View runnable query    Explain query    View query backtrace
44 16.12 ms 
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 = ?
Parameters: 
[
  176
]
View formatted query    View runnable query    Explain query    View query backtrace
45 15.88 ms 
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 = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
46 15.70 ms 
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 = ?
Parameters: 
[
  15
]
View formatted query    View runnable query    Explain query    View query backtrace
47 15.76 ms 
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 = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
48 15.76 ms 
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 = ?
Parameters: 
[
  16
]
View formatted query    View runnable query    Explain query    View query backtrace
49 15.97 ms 
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 = ?
Parameters: 
[
  59
]
View formatted query    View runnable query    Explain query    View query backtrace
50 16.00 ms 
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 = ?
Parameters: 
[
  59
]
View formatted query    View runnable query    Explain query    View query backtrace
51 15.91 ms 
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 = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query    View query backtrace
52 15.96 ms 
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 = ?
Parameters: 
[
  17
]
View formatted query    View runnable query    Explain query    View query backtrace
53 15.91 ms 
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 = ?
Parameters: 
[
  62
]
View formatted query    View runnable query    Explain query    View query backtrace
54 15.98 ms 
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 = ?
Parameters: 
[
  62
]
View formatted query    View runnable query    Explain query    View query backtrace
55 15.97 ms 
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 = ?
Parameters: 
[
  63
]
View formatted query    View runnable query    Explain query    View query backtrace
56 15.88 ms 
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 = ?
Parameters: 
[
  63
]
View formatted query    View runnable query    Explain query    View query backtrace
57 15.67 ms 
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 = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query    View query backtrace
58 15.87 ms 
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 = ?
Parameters: 
[
  19
]
View formatted query    View runnable query    Explain query    View query backtrace
59 15.92 ms 
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 = ?
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query    View query backtrace
60 16.05 ms 
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 = ?
Parameters: 
[
  21
]
View formatted query    View runnable query    Explain query    View query backtrace
61 16.19 ms 
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 = ?
Parameters: 
[
  131
]
View formatted query    View runnable query    Explain query    View query backtrace
62 16.09 ms 
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 = ?
Parameters: 
[
  131
]
View formatted query    View runnable query    Explain query    View query backtrace
63 16.00 ms 
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 = ?
Parameters: 
[
  24
]
View formatted query    View runnable query    Explain query    View query backtrace
64 16.46 ms 
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 = ?
Parameters: 
[
  24
]
View formatted query    View runnable query    Explain query    View query backtrace
65 16.26 ms 
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 = ?
Parameters: 
[
  157
]
View formatted query    View runnable query    Explain query    View query backtrace
66 16.37 ms 
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 = ?
Parameters: 
[
  157
]
View formatted query    View runnable query    Explain query    View query backtrace
67 16.17 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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.