2.54 ms (16.34%)
|
9 |
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM faq_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.question AS question_2, t0.answer AS answer_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM faq_translation t0 WHERE t0.translatable_id = 1;
|
1.75 ms (11.29%)
|
6 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM slider_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM slider_translation t0 WHERE t0.translatable_id = 7;
|
1.60 ms (10.30%)
|
4 |
SELECT t0.id AS id_1, t0.city AS city_2, t0.popup_image_name AS popup_image_name_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.post_code AS post_code_6, t0.street AS street_7, t0.phone AS phone_8, t0.email AS email_9, t0.instagram_url AS instagram_url_10, t0.minimum_booking_notice_hours AS minimum_booking_notice_hours_11 FROM place t0
SELECT t0.id AS id_1, t0.city AS city_2, t0.popup_image_name AS popup_image_name_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.post_code AS post_code_6, t0.street AS street_7, t0.phone AS phone_8, t0.email AS email_9, t0.instagram_url AS instagram_url_10, t0.minimum_booking_notice_hours AS minimum_booking_notice_hours_11 FROM place t0;
|
1.30 ms (8.38%)
|
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM room_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.short_description AS short_description_3, t0.description AS description_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM room_translation t0 WHERE t0.translatable_id = 1;
|
1.28 ms (8.23%)
|
4 |
SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.adults AS adults_2, o0_.phone AS phone_3, o0_.email AS email_4, o0_.state AS state_5, o0_.price AS price_6, o0_.buyer_name AS buyer_name_7, o0_.uuid AS uuid_8, o0_.payment_method AS payment_method_9, o0_.room_id AS room_id_10 FROM `order` o0_ WHERE (o0_.date BETWEEN ? AND ?) AND o0_.room_id = ?
Parameters: [
"2026-03-16 07:41:58"
"2026-03-22 07:41:58"
1
]
SELECT o0_.id AS id_0, o0_.date AS date_1, o0_.adults AS adults_2, o0_.phone AS phone_3, o0_.email AS email_4, o0_.state AS state_5, o0_.price AS price_6, o0_.buyer_name AS buyer_name_7, o0_.uuid AS uuid_8, o0_.payment_method AS payment_method_9, o0_.room_id AS room_id_10 FROM `order` o0_ WHERE (o0_.date BETWEEN '2026-03-16 07:41:58' AND '2026-03-22 07:41:58') AND o0_.room_id = 1;
|
1.27 ms (8.19%)
|
4 |
SELECT c0_.id AS id_0, c0_.day AS day_1, c0_.type AS type_2, c0_.start AS start_3, c0_.end AS end_4, c0_.room_id AS room_id_5 FROM calendar c0_ WHERE (c0_.day BETWEEN ? AND ?) AND c0_.room_id = ?
Parameters: [
"2026-03-16 07:41:58"
"2026-03-22 07:41:58"
1
]
SELECT c0_.id AS id_0, c0_.day AS day_1, c0_.type AS type_2, c0_.start AS start_3, c0_.end AS end_4, c0_.room_id AS room_id_5 FROM calendar c0_ WHERE (c0_.day BETWEEN '2026-03-16 07:41:58' AND '2026-03-22 07:41:58') AND c0_.room_id = 1;
|
0.84 ms (5.39%)
|
1 |
SELECT t0.id AS id_1, t0.city AS city_2, t0.popup_image_name AS popup_image_name_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.post_code AS post_code_6, t0.street AS street_7, t0.phone AS phone_8, t0.email AS email_9, t0.instagram_url AS instagram_url_10, t0.minimum_booking_notice_hours AS minimum_booking_notice_hours_11 FROM place t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.city AS city_2, t0.popup_image_name AS popup_image_name_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.post_code AS post_code_6, t0.street AS street_7, t0.phone AS phone_8, t0.email AS email_9, t0.instagram_url AS instagram_url_10, t0.minimum_booking_notice_hours AS minimum_booking_notice_hours_11 FROM place t0 WHERE t0.id = 2;
|
0.83 ms (5.37%)
|
2 |
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.position AS position_2, a0_.target_url AS target_url_3, a0_.click_count AS click_count_4, a0_.is_active AS is_active_5, a0_.display_order AS display_order_6, a0_.desktop_image_name AS desktop_image_name_7, a0_.tablet_image_name AS tablet_image_name_8, a0_.mobile_image_name AS mobile_image_name_9, a0_.updated_at AS updated_at_10, a0_.place_id AS place_id_11 FROM ad_box a0_ WHERE a0_.place_id = ? AND a0_.position = ? AND a0_.is_active = ? ORDER BY a0_.display_order ASC
Parameters: [
2
"between_features_rooms"
1
]
SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.position AS position_2, a0_.target_url AS target_url_3, a0_.click_count AS click_count_4, a0_.is_active AS is_active_5, a0_.display_order AS display_order_6, a0_.desktop_image_name AS desktop_image_name_7, a0_.tablet_image_name AS tablet_image_name_8, a0_.mobile_image_name AS mobile_image_name_9, a0_.updated_at AS updated_at_10, a0_.place_id AS place_id_11 FROM ad_box a0_ WHERE a0_.place_id = 2 AND a0_.position = 'between_features_rooms' AND a0_.is_active = 1 ORDER BY a0_.display_order ASC;
|
0.67 ms (4.30%)
|
1 |
SELECT t0.id AS id_1, t0.price1 AS price1_2, t0.price2 AS price2_3, t0.price3 AS price3_4, t0.price4 AS price4_5, t0.price5 AS price5_6, t0.price6 AS price6_7, t0.image AS image_8, t0.open_hour_monday AS open_hour_monday_9, t0.close_hour_monday AS close_hour_monday_10, t0.open_hour_tuesday AS open_hour_tuesday_11, t0.close_hour_tuesday AS close_hour_tuesday_12, t0.open_hour_wednesday AS open_hour_wednesday_13, t0.close_hour_wednesday AS close_hour_wednesday_14, t0.open_hour_thursday AS open_hour_thursday_15, t0.close_hour_thursday AS close_hour_thursday_16, t0.open_hour_friday AS open_hour_friday_17, t0.close_hour_friday AS close_hour_friday_18, t0.open_hour_saturday AS open_hour_saturday_19, t0.close_hour_saturday AS close_hour_saturday_20, t0.open_hour_sunday AS open_hour_sunday_21, t0.close_hour_sunday AS close_hour_sunday_22, t0.place_id AS place_id_23 FROM room t0 WHERE t0.place_id = ?
SELECT t0.id AS id_1, t0.price1 AS price1_2, t0.price2 AS price2_3, t0.price3 AS price3_4, t0.price4 AS price4_5, t0.price5 AS price5_6, t0.price6 AS price6_7, t0.image AS image_8, t0.open_hour_monday AS open_hour_monday_9, t0.close_hour_monday AS close_hour_monday_10, t0.open_hour_tuesday AS open_hour_tuesday_11, t0.close_hour_tuesday AS close_hour_tuesday_12, t0.open_hour_wednesday AS open_hour_wednesday_13, t0.close_hour_wednesday AS close_hour_wednesday_14, t0.open_hour_thursday AS open_hour_thursday_15, t0.close_hour_thursday AS close_hour_thursday_16, t0.open_hour_friday AS open_hour_friday_17, t0.close_hour_friday AS close_hour_friday_18, t0.open_hour_saturday AS open_hour_saturday_19, t0.close_hour_saturday AS close_hour_saturday_20, t0.open_hour_sunday AS open_hour_sunday_21, t0.close_hour_sunday AS close_hour_sunday_22, t0.place_id AS place_id_23 FROM room t0 WHERE t0.place_id = 2;
|
0.66 ms (4.26%)
|
2 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM static_text_translation t0 WHERE t0.translatable_id = ?
SELECT t0.id AS id_1, t0.value AS value_2, t0.description AS description_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM static_text_translation t0 WHERE t0.translatable_id = 1;
|
0.62 ms (3.97%)
|
1 |
SELECT t0.id AS id_1, t0.cash AS cash_2, t0.full AS full_3, t0.advance AS advance_4, t0.voucher AS voucher_5, t0.regulations_name AS regulations_name_6, t0.privacy_policy_name AS privacy_policy_name_7, t0.updated_at AS updated_at_8, t0.facebook_url AS facebook_url_9, t0.instagram_url AS instagram_url_10, t0.tiktok_url AS tiktok_url_11, t0.youtube_url AS youtube_url_12, t0.admin_email AS admin_email_13, t0.place_id AS place_id_14 FROM configuration t0 WHERE t0.place_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.cash AS cash_2, t0.full AS full_3, t0.advance AS advance_4, t0.voucher AS voucher_5, t0.regulations_name AS regulations_name_6, t0.privacy_policy_name AS privacy_policy_name_7, t0.updated_at AS updated_at_8, t0.facebook_url AS facebook_url_9, t0.instagram_url AS instagram_url_10, t0.tiktok_url AS tiktok_url_11, t0.youtube_url AS youtube_url_12, t0.admin_email AS admin_email_13, t0.place_id AS place_id_14 FROM configuration t0 WHERE t0.place_id = 2 LIMIT 1;
|
0.48 ms (3.11%)
|
1 |
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.image_name AS image_name_2, s0_.updated_at AS updated_at_3, s0_.link AS link_4, s0_.place_id AS place_id_5 FROM slider s0_ WHERE s0_.place_id = ? ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.image_name AS image_name_2, s0_.updated_at AS updated_at_3, s0_.link AS link_4, s0_.place_id AS place_id_5 FROM slider s0_ WHERE s0_.place_id = 2 ORDER BY s0_.position ASC;
|
0.47 ms (3.01%)
|
1 |
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.icon_name AS icon_name_2, f0_.updated_at AS updated_at_3, f0_.place_id AS place_id_4 FROM feature f0_ WHERE f0_.place_id = ? ORDER BY f0_.position ASC
SELECT f0_.id AS id_0, f0_.position AS position_1, f0_.icon_name AS icon_name_2, f0_.updated_at AS updated_at_3, f0_.place_id AS place_id_4 FROM feature f0_ WHERE f0_.place_id = 2 ORDER BY f0_.position ASC;
|
0.43 ms (2.76%)
|
1 |
SELECT f0_.id AS id_0, f0_.position AS position_1 FROM faq f0_ ORDER BY f0_.position ASC
SELECT f0_.id AS id_0, f0_.position AS position_1 FROM faq f0_ ORDER BY f0_.position ASC;
|
0.42 ms (2.73%)
|
1 |
SELECT t0.id AS id_1, t0.text_key AS text_key_2 FROM static_text t0
SELECT t0.id AS id_1, t0.text_key AS text_key_2 FROM static_text t0;
|
0.37 ms (2.36%)
|
1 |
SELECT t0.id AS id_1, t0.cash AS cash_2, t0.full AS full_3, t0.advance AS advance_4, t0.voucher AS voucher_5, t0.regulations_name AS regulations_name_6, t0.privacy_policy_name AS privacy_policy_name_7, t0.updated_at AS updated_at_8, t0.facebook_url AS facebook_url_9, t0.instagram_url AS instagram_url_10, t0.tiktok_url AS tiktok_url_11, t0.youtube_url AS youtube_url_12, t0.admin_email AS admin_email_13, t0.place_id AS place_id_14 FROM configuration t0 WHERE t0.place_id IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.cash AS cash_2, t0.full AS full_3, t0.advance AS advance_4, t0.voucher AS voucher_5, t0.regulations_name AS regulations_name_6, t0.privacy_policy_name AS privacy_policy_name_7, t0.updated_at AS updated_at_8, t0.facebook_url AS facebook_url_9, t0.instagram_url AS instagram_url_10, t0.tiktok_url AS tiktok_url_11, t0.youtube_url AS youtube_url_12, t0.admin_email AS admin_email_13, t0.place_id AS place_id_14 FROM configuration t0 WHERE t0.place_id IS NULL LIMIT 1;
|