Query Metrics
3
Database Queries
3
Different statements
1.84 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.14 ms |
SELECT t0.id AS id_1, t0.section AS section_2, t0.address AS address_3, t0.entry_description AS entry_description_4, t0.checkin_time AS checkin_time_5, t0.checkout_time AS checkout_time_6, t0.cal AS cal_7, t0.notes AS notes_8, t0.disabled AS disabled_9, t0.cleaning_duration AS cleaning_duration_10, t0.guests AS guests_11, t0.double_bedrooms AS double_bedrooms_12, t0.single_rooms AS single_rooms_13, t0.driving_duration AS driving_duration_14, t0.created_at AS created_at_15, t0.base_fee_cleaning AS base_fee_cleaning_16, t0.vat_registered AS vat_registered_17, t0.host_share AS host_share_18, t0.project_id AS project_id_19, t0.import_attempt AS import_attempt_20, t0.responsible_id AS responsible_id_21, t0.owner_id AS owner_id_22, t23.id AS id_24, t23.place_id AS place_id_25, t23.data AS data_26, t23.property_id AS property_id_27 FROM property t0 LEFT JOIN property_address t23 ON t23.property_id = t0.id WHERE t0.id = ?
Parameters:
[
"RMH1-2"
]
|
| 2 | 0.47 ms |
SELECT t0.id AS id_1, t0.section AS section_2, t0.address AS address_3, t0.entry_description AS entry_description_4, t0.checkin_time AS checkin_time_5, t0.checkout_time AS checkout_time_6, t0.cal AS cal_7, t0.notes AS notes_8, t0.disabled AS disabled_9, t0.cleaning_duration AS cleaning_duration_10, t0.guests AS guests_11, t0.double_bedrooms AS double_bedrooms_12, t0.single_rooms AS single_rooms_13, t0.driving_duration AS driving_duration_14, t0.created_at AS created_at_15, t0.base_fee_cleaning AS base_fee_cleaning_16, t0.vat_registered AS vat_registered_17, t0.host_share AS host_share_18, t0.project_id AS project_id_19, t0.import_attempt AS import_attempt_20, t0.responsible_id AS responsible_id_21, t0.owner_id AS owner_id_22, t23.id AS id_24, t23.place_id AS place_id_25, t23.data AS data_26, t23.property_id AS property_id_27 FROM property t0 LEFT JOIN property_address t23 ON t23.property_id = t0.id WHERE t0.section = ? LIMIT 1
Parameters:
[
"RMH1-2"
]
|
| 3 | 1.23 ms |
SELECT t0.id AS id_1, t0.booking_number AS booking_number_2, t0.checkin AS checkin_3, t0.checkout AS checkout_4, t0.guests AS guests_5, t0.cal_identifier AS cal_identifier_6, t0.cal_src AS cal_src_7, t0.double_bedrooms AS double_bedrooms_8, t0.single_bedrooms AS single_bedrooms_9, t0.bedrooms AS bedrooms_10, t0.rating AS rating_11, t0.manual AS manual_12, t0.blocking AS blocking_13, t0.billed AS billed_14, t0.notify_responsible AS notify_responsible_15, t0.time_start AS time_start_16, t0.time_usage AS time_usage_17, t0.driving_time_usage AS driving_time_usage_18, t0.notes AS notes_19, t0.employee_note AS employee_note_20, t0.checked_in_at AS checked_in_at_21, t0.cancelled_at AS cancelled_at_22, t0.property_id AS property_id_23, t0.responsible_id AS responsible_id_24, t0.code_slot_id AS code_slot_id_25 FROM booking t0 WHERE ((t0.blocking != ? AND (t0.time_start IS NULL OR t0.time_usage IS NULL) AND t0.checkout <= ?) AND t0.property_id = ?) ORDER BY t0.checkin ASC
Parameters:
[ 1 "2025-12-10 23:59:59" 39 ] |
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\Property | No errors. |
| App\Entity\Booking | No errors. |
| App\Entity\User | No errors. |
| App\Entity\PropertyOwner | No errors. |
| App\Entity\PropertyAddress | No errors. |
| App\Entity\Invoice | No errors. |
| App\Entity\MqttDoorLock | No errors. |
| App\Entity\BookingProvider | No errors. |
| App\Entity\DoorLockCodeSlot |
|