Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.business_date AS business_date_2,
  t0.status AS status_3,
  t0.exit_on_time AS exit_on_time_4,
  t0.instructions_respected AS instructions_respected_5,
  t0.exit_comment AS exit_comment_6,
  t0.check_bed_made AS check_bed_made_7,
  t0.check_floor_clean AS check_floor_clean_8,
  t0.check_bathroom_ok AS check_bathroom_ok_9,
  t0.check_kitchen_ok AS check_kitchen_ok_10,
  t0.check_linen_changed AS check_linen_changed_11,
  t0.cleaning_comment AS cleaning_comment_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.started_at AS started_at_15,
  t0.confirmed_at AS confirmed_at_16,
  t0.cancelled_at AS cancelled_at_17,
  t0.property_id AS property_id_18,
  t0.reservation_id AS reservation_id_19,
  t0.assigned_worker_id AS assigned_worker_id_20
FROM
  intervention t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.business_date AS business_date_2, t0.status AS status_3, t0.exit_on_time AS exit_on_time_4, t0.instructions_respected AS instructions_respected_5, t0.exit_comment AS exit_comment_6, t0.check_bed_made AS check_bed_made_7, t0.check_floor_clean AS check_floor_clean_8, t0.check_bathroom_ok AS check_bathroom_ok_9, t0.check_kitchen_ok AS check_kitchen_ok_10, t0.check_linen_changed AS check_linen_changed_11, t0.cleaning_comment AS cleaning_comment_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.started_at AS started_at_15, t0.confirmed_at AS confirmed_at_16, t0.cancelled_at AS cancelled_at_17, t0.property_id AS property_id_18, t0.reservation_id AS reservation_id_19, t0.assigned_worker_id AS assigned_worker_id_20 FROM intervention t0 WHERE t0.reservation_id = 13;

SELECT
  t0.id AS id_1,
  t0.adults AS adults_2,
  t0.children AS children_3,
  t0.babies AS babies_4,
  t0.details AS details_5,
  t0.confirmed_at AS confirmed_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.reservation_id AS reservation_id_9
FROM
  reservation_details t0
WHERE
  t0.reservation_id = ?

SELECT t0.id AS id_1, t0.adults AS adults_2, t0.children AS children_3, t0.babies AS babies_4, t0.details AS details_5, t0.confirmed_at AS confirmed_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.reservation_id AS reservation_id_9 FROM reservation_details t0 WHERE t0.reservation_id = 13;

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.slug AS slug_3,
  t0.hero_eyebrow AS hero_eyebrow_4,
  t0.headline AS headline_5,
  t0.property_eyebrow AS property_eyebrow_6,
  t0.property_title AS property_title_7,
  t0.property_introduction AS property_introduction_8,
  t0.description AS description_9,
  t0.gallery_eyebrow AS gallery_eyebrow_10,
  t0.gallery_title AS gallery_title_11,
  t0.gallery_introduction AS gallery_introduction_12,
  t0.location_eyebrow AS location_eyebrow_13,
  t0.location_title AS location_title_14,
  t0.location_description AS location_description_15,
  t0.contact_email AS contact_email_16,
  t0.contact_phone AS contact_phone_17,
  t0.contact_address AS contact_address_18,
  t0.primary_color AS primary_color_19,
  t0.secondary_color AS secondary_color_20,
  t0.seo_title AS seo_title_21,
  t0.seo_description AS seo_description_22,
  t0.direct_booking_enabled AS direct_booking_enabled_23,
  t0.published AS published_24,
  t0.published_at AS published_at_25,
  t0.preview_image AS preview_image_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.property_id AS property_id_29,
  t0.theme_id AS theme_id_30,
  t31.id AS id_32,
  t31.domain_name AS domain_name_33,
  t31.mode AS mode_34,
  t31.registrar AS registrar_35,
  t31.status AS status_36,
  t31.registrar_domain_id AS registrar_domain_id_37,
  t31.dns_configured AS dns_configured_38,
  t31.ssl_enabled AS ssl_enabled_39,
  t31.auto_renew AS auto_renew_40,
  t31.transfer_auth_code AS transfer_auth_code_41,
  t31.last_error AS last_error_42,
  t31.registered_at AS registered_at_43,
  t31.expires_at AS expires_at_44,
  t31.activated_at AS activated_at_45,
  t31.created_at AS created_at_46,
  t31.updated_at AS updated_at_47,
  t31.website_id AS website_id_48
FROM
  property_website t0
  LEFT JOIN domain t31 ON t31.website_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.slug AS slug_3, t0.hero_eyebrow AS hero_eyebrow_4, t0.headline AS headline_5, t0.property_eyebrow AS property_eyebrow_6, t0.property_title AS property_title_7, t0.property_introduction AS property_introduction_8, t0.description AS description_9, t0.gallery_eyebrow AS gallery_eyebrow_10, t0.gallery_title AS gallery_title_11, t0.gallery_introduction AS gallery_introduction_12, t0.location_eyebrow AS location_eyebrow_13, t0.location_title AS location_title_14, t0.location_description AS location_description_15, t0.contact_email AS contact_email_16, t0.contact_phone AS contact_phone_17, t0.contact_address AS contact_address_18, t0.primary_color AS primary_color_19, t0.secondary_color AS secondary_color_20, t0.seo_title AS seo_title_21, t0.seo_description AS seo_description_22, t0.direct_booking_enabled AS direct_booking_enabled_23, t0.published AS published_24, t0.published_at AS published_at_25, t0.preview_image AS preview_image_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.property_id AS property_id_29, t0.theme_id AS theme_id_30, t31.id AS id_32, t31.domain_name AS domain_name_33, t31.mode AS mode_34, t31.registrar AS registrar_35, t31.status AS status_36, t31.registrar_domain_id AS registrar_domain_id_37, t31.dns_configured AS dns_configured_38, t31.ssl_enabled AS ssl_enabled_39, t31.auto_renew AS auto_renew_40, t31.transfer_auth_code AS transfer_auth_code_41, t31.last_error AS last_error_42, t31.registered_at AS registered_at_43, t31.expires_at AS expires_at_44, t31.activated_at AS activated_at_45, t31.created_at AS created_at_46, t31.updated_at AS updated_at_47, t31.website_id AS website_id_48 FROM property_website t0 LEFT JOIN domain t31 ON t31.website_id = t0.id WHERE t0.slug = 'gite-au-bois-du-prince' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address AS address_4,
  t0.zip_code AS zip_code_5,
  t0.city AS city_6,
  t0.country AS country_7,
  t0.latitude AS latitude_8,
  t0.longitude AS longitude_9,
  t0.capacity AS capacity_10,
  t0.bedrooms AS bedrooms_11,
  t0.bathrooms AS bathrooms_12,
  t0.surface AS surface_13,
  t0.nightly_rate AS nightly_rate_14,
  t0.included_guests AS included_guests_15,
  t0.extra_guest_fee AS extra_guest_fee_16,
  t0.cleaning_fee AS cleaning_fee_17,
  t0.nearby_place1 AS nearby_place1_18,
  t0.nearby_place1_time AS nearby_place1_time_19,
  t0.nearby_place2 AS nearby_place2_20,
  t0.nearby_place2_time AS nearby_place2_time_21,
  t0.nearby_place3 AS nearby_place3_22,
  t0.nearby_place3_time AS nearby_place3_time_23,
  t0.nearby_place4 AS nearby_place4_24,
  t0.nearby_place4_time AS nearby_place4_time_25,
  t0.arrival_time AS arrival_time_26,
  t0.departure_time AS departure_time_27,
  t0.minimum_nights AS minimum_nights_28,
  t0.maximum_nights AS maximum_nights_29,
  t0.minimum_booking_notice_days AS minimum_booking_notice_days_30,
  t0.maximum_booking_advance_days AS maximum_booking_advance_days_31,
  t0.cancellation_policy AS cancellation_policy_32,
  t0.custom_cancellation_policy AS custom_cancellation_policy_33,
  t0.ical_export_token AS ical_export_token_34,
  t0.ical_export_enabled AS ical_export_enabled_35,
  t0.active AS active_36,
  t0.created_at AS created_at_37,
  t0.updated_at AS updated_at_38,
  t0.owner_id AS owner_id_39,
  t40.id AS id_41,
  t40.site_name AS site_name_42,
  t40.slug AS slug_43,
  t40.hero_eyebrow AS hero_eyebrow_44,
  t40.headline AS headline_45,
  t40.property_eyebrow AS property_eyebrow_46,
  t40.property_title AS property_title_47,
  t40.property_introduction AS property_introduction_48,
  t40.description AS description_49,
  t40.gallery_eyebrow AS gallery_eyebrow_50,
  t40.gallery_title AS gallery_title_51,
  t40.gallery_introduction AS gallery_introduction_52,
  t40.location_eyebrow AS location_eyebrow_53,
  t40.location_title AS location_title_54,
  t40.location_description AS location_description_55,
  t40.contact_email AS contact_email_56,
  t40.contact_phone AS contact_phone_57,
  t40.contact_address AS contact_address_58,
  t40.primary_color AS primary_color_59,
  t40.secondary_color AS secondary_color_60,
  t40.seo_title AS seo_title_61,
  t40.seo_description AS seo_description_62,
  t40.direct_booking_enabled AS direct_booking_enabled_63,
  t40.published AS published_64,
  t40.published_at AS published_at_65,
  t40.preview_image AS preview_image_66,
  t40.created_at AS created_at_67,
  t40.updated_at AS updated_at_68,
  t40.property_id AS property_id_69,
  t40.theme_id AS theme_id_70
FROM
  property t0
  LEFT JOIN property_website t40 ON t40.property_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.zip_code AS zip_code_5, t0.city AS city_6, t0.country AS country_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.capacity AS capacity_10, t0.bedrooms AS bedrooms_11, t0.bathrooms AS bathrooms_12, t0.surface AS surface_13, t0.nightly_rate AS nightly_rate_14, t0.included_guests AS included_guests_15, t0.extra_guest_fee AS extra_guest_fee_16, t0.cleaning_fee AS cleaning_fee_17, t0.nearby_place1 AS nearby_place1_18, t0.nearby_place1_time AS nearby_place1_time_19, t0.nearby_place2 AS nearby_place2_20, t0.nearby_place2_time AS nearby_place2_time_21, t0.nearby_place3 AS nearby_place3_22, t0.nearby_place3_time AS nearby_place3_time_23, t0.nearby_place4 AS nearby_place4_24, t0.nearby_place4_time AS nearby_place4_time_25, t0.arrival_time AS arrival_time_26, t0.departure_time AS departure_time_27, t0.minimum_nights AS minimum_nights_28, t0.maximum_nights AS maximum_nights_29, t0.minimum_booking_notice_days AS minimum_booking_notice_days_30, t0.maximum_booking_advance_days AS maximum_booking_advance_days_31, t0.cancellation_policy AS cancellation_policy_32, t0.custom_cancellation_policy AS custom_cancellation_policy_33, t0.ical_export_token AS ical_export_token_34, t0.ical_export_enabled AS ical_export_enabled_35, t0.active AS active_36, t0.created_at AS created_at_37, t0.updated_at AS updated_at_38, t0.owner_id AS owner_id_39, t40.id AS id_41, t40.site_name AS site_name_42, t40.slug AS slug_43, t40.hero_eyebrow AS hero_eyebrow_44, t40.headline AS headline_45, t40.property_eyebrow AS property_eyebrow_46, t40.property_title AS property_title_47, t40.property_introduction AS property_introduction_48, t40.description AS description_49, t40.gallery_eyebrow AS gallery_eyebrow_50, t40.gallery_title AS gallery_title_51, t40.gallery_introduction AS gallery_introduction_52, t40.location_eyebrow AS location_eyebrow_53, t40.location_title AS location_title_54, t40.location_description AS location_description_55, t40.contact_email AS contact_email_56, t40.contact_phone AS contact_phone_57, t40.contact_address AS contact_address_58, t40.primary_color AS primary_color_59, t40.secondary_color AS secondary_color_60, t40.seo_title AS seo_title_61, t40.seo_description AS seo_description_62, t40.direct_booking_enabled AS direct_booking_enabled_63, t40.published AS published_64, t40.published_at AS published_at_65, t40.preview_image AS preview_image_66, t40.created_at AS created_at_67, t40.updated_at AS updated_at_68, t40.property_id AS property_id_69, t40.theme_id AS theme_id_70 FROM property t0 LEFT JOIN property_website t40 ON t40.property_id = t0.id WHERE t0.id = 1;

SELECT
  r0_.id AS id_0,
  r0_.uid AS uid_1,
  r0_.recurrence_id AS recurrence_id_2,
  r0_.starts_at AS starts_at_3,
  r0_.ends_at AS ends_at_4,
  r0_.status AS status_5,
  r0_.sequence AS sequence_6,
  r0_.last_seen_at AS last_seen_at_7,
  r0_.raw_hash AS raw_hash_8,
  r0_.created_at AS created_at_9,
  r0_.updated_at AS updated_at_10,
  r0_.property_id AS property_id_11,
  r0_.calendar_source_id AS calendar_source_id_12
FROM
  reservation r0_
WHERE
  r0_.property_id = ?
  AND r0_.status = ?
  AND r0_.starts_at < ?
  AND r0_.ends_at > ?
ORDER BY
  r0_.starts_at ASC

SELECT r0_.id AS id_0, r0_.uid AS uid_1, r0_.recurrence_id AS recurrence_id_2, r0_.starts_at AS starts_at_3, r0_.ends_at AS ends_at_4, r0_.status AS status_5, r0_.sequence AS sequence_6, r0_.last_seen_at AS last_seen_at_7, r0_.raw_hash AS raw_hash_8, r0_.created_at AS created_at_9, r0_.updated_at AS updated_at_10, r0_.property_id AS property_id_11, r0_.calendar_source_id AS calendar_source_id_12 FROM reservation r0_ WHERE r0_.property_id = 1 AND r0_.status = 'confirmed' AND r0_.starts_at < '2028-08-11 00:00:00' AND r0_.ends_at > '2026-08-12 00:00:00' ORDER BY r0_.starts_at ASC;