Query Metrics
20
Database Queries
10
Different statements
11.97 ms
Query time
0
Invalid entities
19
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
3.32 ms (27.74%) |
5 |
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 = ?
Parameters:
[
52
]
|
||||||||||||||||||||||||||||||
|
2.07 ms (17.29%) |
5 |
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 = ?
Parameters:
[
52
]
|
||||||||||||||||||||||||||||||
|
1.80 ms (15.07%) |
3 |
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.property_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.86 ms (7.23%) |
1 |
SELECT COUNT(i0_.id) AS sclr_0 FROM intervention i0_ INNER JOIN property p1_ ON i0_.property_id = p1_.id WHERE p1_.owner_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.81 ms (6.74%) |
1 |
SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ INNER JOIN property p1_ ON r0_.property_id = p1_.id WHERE p1_.owner_id = ? AND r0_.status = ?
Parameters:
[ 1 "confirmed" ]
|
||||||||||||||||||||||||||||||
|
0.76 ms (6.38%) |
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, p1_.id AS id_11, p1_.name AS name_12, p1_.slug AS slug_13, p1_.address AS address_14, p1_.zip_code AS zip_code_15, p1_.city AS city_16, p1_.country AS country_17, p1_.latitude AS latitude_18, p1_.longitude AS longitude_19, p1_.capacity AS capacity_20, p1_.bedrooms AS bedrooms_21, p1_.bathrooms AS bathrooms_22, p1_.surface AS surface_23, p1_.nightly_rate AS nightly_rate_24, p1_.included_guests AS included_guests_25, p1_.extra_guest_fee AS extra_guest_fee_26, p1_.cleaning_fee AS cleaning_fee_27, p1_.nearby_place1 AS nearby_place1_28, p1_.nearby_place1_time AS nearby_place1_time_29, p1_.nearby_place2 AS nearby_place2_30, p1_.nearby_place2_time AS nearby_place2_time_31, p1_.nearby_place3 AS nearby_place3_32, p1_.nearby_place3_time AS nearby_place3_time_33, p1_.nearby_place4 AS nearby_place4_34, p1_.nearby_place4_time AS nearby_place4_time_35, p1_.arrival_time AS arrival_time_36, p1_.departure_time AS departure_time_37, p1_.minimum_nights AS minimum_nights_38, p1_.maximum_nights AS maximum_nights_39, p1_.minimum_booking_notice_days AS minimum_booking_notice_days_40, p1_.maximum_booking_advance_days AS maximum_booking_advance_days_41, p1_.cancellation_policy AS cancellation_policy_42, p1_.custom_cancellation_policy AS custom_cancellation_policy_43, p1_.ical_export_token AS ical_export_token_44, p1_.ical_export_enabled AS ical_export_enabled_45, p1_.active AS active_46, p1_.created_at AS created_at_47, p1_.updated_at AS updated_at_48, c2_.id AS id_49, c2_.name AS name_50, c2_.url AS url_51, c2_.enabled AS enabled_52, c2_.last_sync_status AS last_sync_status_53, c2_.last_sync_error AS last_sync_error_54, c2_.last_synced_at AS last_synced_at_55, c2_.created_at AS created_at_56, r0_.property_id AS property_id_57, r0_.calendar_source_id AS calendar_source_id_58, p1_.owner_id AS owner_id_59, c2_.property_id AS property_id_60 FROM reservation r0_ INNER JOIN property p1_ ON r0_.property_id = p1_.id LEFT JOIN calendar_source c2_ ON r0_.calendar_source_id = c2_.id WHERE p1_.owner_id = ? AND r0_.status = ? AND r0_.starts_at >= ? ORDER BY r0_.starts_at ASC, p1_.name ASC LIMIT 5
Parameters:
[ 1 "confirmed" "2026-08-12 00:00:00" ]
|
||||||||||||||||||||||||||||||
|
0.63 ms (5.30%) |
1 |
SELECT i0_.id AS id_0, i0_.business_date AS business_date_1, i0_.status AS status_2, i0_.exit_on_time AS exit_on_time_3, i0_.instructions_respected AS instructions_respected_4, i0_.exit_comment AS exit_comment_5, i0_.check_bed_made AS check_bed_made_6, i0_.check_floor_clean AS check_floor_clean_7, i0_.check_bathroom_ok AS check_bathroom_ok_8, i0_.check_kitchen_ok AS check_kitchen_ok_9, i0_.check_linen_changed AS check_linen_changed_10, i0_.cleaning_comment AS cleaning_comment_11, i0_.created_at AS created_at_12, i0_.updated_at AS updated_at_13, i0_.started_at AS started_at_14, i0_.confirmed_at AS confirmed_at_15, i0_.cancelled_at AS cancelled_at_16, p1_.id AS id_17, p1_.name AS name_18, p1_.slug AS slug_19, p1_.address AS address_20, p1_.zip_code AS zip_code_21, p1_.city AS city_22, p1_.country AS country_23, p1_.latitude AS latitude_24, p1_.longitude AS longitude_25, p1_.capacity AS capacity_26, p1_.bedrooms AS bedrooms_27, p1_.bathrooms AS bathrooms_28, p1_.surface AS surface_29, p1_.nightly_rate AS nightly_rate_30, p1_.included_guests AS included_guests_31, p1_.extra_guest_fee AS extra_guest_fee_32, p1_.cleaning_fee AS cleaning_fee_33, p1_.nearby_place1 AS nearby_place1_34, p1_.nearby_place1_time AS nearby_place1_time_35, p1_.nearby_place2 AS nearby_place2_36, p1_.nearby_place2_time AS nearby_place2_time_37, p1_.nearby_place3 AS nearby_place3_38, p1_.nearby_place3_time AS nearby_place3_time_39, p1_.nearby_place4 AS nearby_place4_40, p1_.nearby_place4_time AS nearby_place4_time_41, p1_.arrival_time AS arrival_time_42, p1_.departure_time AS departure_time_43, p1_.minimum_nights AS minimum_nights_44, p1_.maximum_nights AS maximum_nights_45, p1_.minimum_booking_notice_days AS minimum_booking_notice_days_46, p1_.maximum_booking_advance_days AS maximum_booking_advance_days_47, p1_.cancellation_policy AS cancellation_policy_48, p1_.custom_cancellation_policy AS custom_cancellation_policy_49, p1_.ical_export_token AS ical_export_token_50, p1_.ical_export_enabled AS ical_export_enabled_51, p1_.active AS active_52, p1_.created_at AS created_at_53, p1_.updated_at AS updated_at_54, i0_.property_id AS property_id_55, i0_.reservation_id AS reservation_id_56, i0_.assigned_worker_id AS assigned_worker_id_57, p1_.owner_id AS owner_id_58 FROM intervention i0_ INNER JOIN property p1_ ON i0_.property_id = p1_.id WHERE p1_.owner_id = ? ORDER BY i0_.updated_at DESC LIMIT 5
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.61 ms (5.09%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.last_login_at AS last_login_at_8, t0.google_id AS google_id_9, t0.facebook_id AS facebook_id_10, t0.avatar AS avatar_11, t0.avatar_source AS avatar_source_12, t13.id AS id_14, t13.first_name AS first_name_15, t13.last_name AS last_name_16, t13.phone AS phone_17, t13.email AS email_18, t13.access_token AS access_token_19, t13.created_at AS created_at_20, t13.user_id AS user_id_21, t22.id AS id_23, t22.first_name AS first_name_24, t22.last_name AS last_name_25, t22.phone AS phone_26, t22.trade_name AS trade_name_27, t22.legal_name AS legal_name_28, t22.siret AS siret_29, t22.vat_number AS vat_number_30, t22.address AS address_31, t22.zip_code AS zip_code_32, t22.city AS city_33, t22.country AS country_34, t22.lws_contact_id AS lws_contact_id_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.user_id AS user_id_38, t39.id AS id_40, t39.notify_reservations AS notify_reservations_41, t39.notify_interventions AS notify_interventions_42, t39.notify_checkins AS notify_checkins_43, t39.notify_ical_errors AS notify_ical_errors_44, t39.ical_sync_interval AS ical_sync_interval_45, t39.language AS language_46, t39.timezone AS timezone_47, t39.date_format AS date_format_48, t39.time_format AS time_format_49, t39.stripe_enabled AS stripe_enabled_50, t39.paypal_enabled AS paypal_enabled_51, t39.account_enabled AS account_enabled_52, t39.created_at AS created_at_53, t39.updated_at AS updated_at_54, t39.user_id AS user_id_55 FROM user t0 LEFT JOIN worker t13 ON t13.user_id = t0.id LEFT JOIN owner_profile t22 ON t22.user_id = t0.id LEFT JOIN owner_settings t39 ON t39.user_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.59 ms (4.96%) |
1 |
SELECT COUNT(p0_.id) AS sclr_0 FROM property p0_ WHERE p0_.owner_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
0.50 ms (4.21%) |
1 |
SELECT COUNT(r0_.id) AS sclr_0 FROM reservation r0_ INNER JOIN property p1_ ON r0_.property_id = p1_.id WHERE p1_.owner_id = ? AND r0_.status = ? AND r0_.starts_at >= ?
Parameters:
[ 1 "confirmed" "2026-08-12 00:00:00" ]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Reservation | 5 |
| App\Entity\CalendarSource | 4 |
| App\Entity\Property | 3 |
| App\Entity\User | 1 |
| App\Entity\OwnerProfile | 1 |
| App\Entity\PropertyWebsite | 1 |
| App\Entity\WebsiteTheme | 1 |
| App\Entity\Domain | 1 |
| App\Entity\Intervention | 1 |
| App\Entity\Worker | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\User | No errors. |
| App\Entity\Worker | No errors. |
| App\Entity\OwnerProfile | No errors. |
| App\Entity\OwnerSettings | No errors. |
| App\Entity\Property | No errors. |
| App\Entity\WorkerInvitation | No errors. |
| App\Entity\Intervention | No errors. |
| App\Entity\Reservation | No errors. |
| App\Entity\CalendarSource | No errors. |
| App\Entity\ReservationDetails | No errors. |
| App\Entity\PropertyWebsite | No errors. |
| App\Entity\WebsiteTheme | No errors. |
| App\Entity\Domain | No errors. |
| App\Entity\WebsiteKeyword | No errors. |
| App\Entity\WebsiteBookingChannel | No errors. |
| App\Entity\Amenity | No errors. |
| App\Entity\PropertyMedia | No errors. |
| App\Entity\InterventionPhoto | No errors. |