Symfony Profiler

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;

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

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 = 1 AND a0_.position = 'between_features_rooms' AND a0_.is_active = 1 ORDER BY a0_.display_order ASC;

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 = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  feature_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM feature_translation t0 WHERE t0.translatable_id = 5;

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;

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 = 5;

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 = ?

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 10:35:00' AND '2026-03-22 10:35:00') AND o0_.room_id = 5;

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 = ?

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 10:35:00' AND '2026-03-22 10:35:00') AND c0_.room_id = 5;

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 = 1;

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;

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 = 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 = 1 ORDER BY s0_.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 = ?
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 = 1 ORDER BY f0_.position ASC;

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;

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;

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 = 1 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

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;