https://askepott.giaever.online/properties/RMH1-2/ics/unclean

Query Metrics

3 Database Queries
3 Different statements
1.84 ms Query time
1 Invalid entities

Queries

Group similar statements

# 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
  • The association App\Entity\DoorLockCodeSlot#code refers to the inverse side field App\Entity\DoorLockCode#codeSlot which does not exist.