Query Metrics
1318
Database Queries
24
Different statements
67.80 ms
Query time
0
Invalid entities
721
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
21.67 ms (31.96%) |
2 |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||||||||||
|
10.34 ms (15.24%) |
305 |
SELECT b0_.id AS id_0, b0_.room_id AS room_id_1, b0_.room_name AS room_name_2, b0_.unit_id AS unit_id_3, b0_.unit_name AS unit_name_4, b0_.is_auto_created AS is_auto_created_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.property_id AS property_id_8 FROM beds24_property_item b0_ INNER JOIN beds24_property b1_ ON b0_.property_id = b1_.id WHERE b1_.beds24_property_id = ? AND b0_.room_id = ? AND b0_.unit_id = ?
Parameters:
[ "148132" "329148" "1" ] |
||||||||||||||||||||||||||||||||||||||
|
6.43 ms (9.49%) |
2 |
SELECT MAX(b0_.beds24_modified_at) AS sclr_0 FROM beds24_booking b0_ INNER JOIN beds24_property_item b1_ ON b0_.property_item_id = b1_.id INNER JOIN beds24_property b2_ ON b1_.property_id = b2_.id WHERE b2_.account_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||||||
|
5.54 ms (8.17%) |
216 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.loxone_uuid AS loxone_uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.account_id AS account_id_6 FROM loxone_group t0 INNER JOIN loxone_config_loxone_group ON t0.id = loxone_config_loxone_group.loxone_group_id WHERE loxone_config_loxone_group.loxone_config_id = ?
Parameters:
[
9785
]
|
||||||||||||||||||||||||||||||||||||||
|
3.40 ms (5.01%) |
108 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.property_item_id AS property_item_id_4, t0.loxone_group_id AS loxone_group_id_5 FROM beds24_loxone_mapping t0 WHERE t0.property_item_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||||||
|
2.93 ms (4.32%) |
111 |
SELECT t0.id AS id_1, t0.access_code AS access_code_2, t0.valid_from AS valid_from_3, t0.valid_until AS valid_until_4, t0.manual_valid_from AS manual_valid_from_5, t0.manual_valid_until AS manual_valid_until_6, t0.validity_derived_from_arrival_date AS validity_derived_from_arrival_date_7, t0.validity_derived_from_departure_date AS validity_derived_from_departure_date_8, t0.locked AS locked_9, t0.do_not_send AS do_not_send_10, t0.do_not_sync AS do_not_sync_11, t0.code_sent_at AS code_sent_at_12, t0.beds24_info_item_id AS beds24_info_item_id_13, t0.last_sync_at AS last_sync_at_14, t0.last_error AS last_error_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.booking_id AS booking_id_18, t0.loxone_user_id AS loxone_user_id_19 FROM loxone_config t0 WHERE t0.booking_id = ?
Parameters:
[
15713
]
|
||||||||||||||||||||||||||||||||||||||
|
2.72 ms (4.01%) |
108 |
SELECT t0.id AS id_1, t0.beds24_booking_id AS beds24_booking_id_2, t0.beds24_master_id AS beds24_master_id_3, t0.guest_name AS guest_name_4, t0.arrival_date AS arrival_date_5, t0.departure_date AS departure_date_6, t0.status AS status_7, t0.beds24_created_at AS beds24_created_at_8, t0.beds24_modified_at AS beds24_modified_at_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.property_item_id AS property_item_id_12, t13.id AS id_14, t13.access_code AS access_code_15, t13.valid_from AS valid_from_16, t13.valid_until AS valid_until_17, t13.manual_valid_from AS manual_valid_from_18, t13.manual_valid_until AS manual_valid_until_19, t13.validity_derived_from_arrival_date AS validity_derived_from_arrival_date_20, t13.validity_derived_from_departure_date AS validity_derived_from_departure_date_21, t13.locked AS locked_22, t13.do_not_send AS do_not_send_23, t13.do_not_sync AS do_not_sync_24, t13.code_sent_at AS code_sent_at_25, t13.beds24_info_item_id AS beds24_info_item_id_26, t13.last_sync_at AS last_sync_at_27, t13.last_error AS last_error_28, t13.created_at AS created_at_29, t13.updated_at AS updated_at_30, t13.booking_id AS booking_id_31, t13.loxone_user_id AS loxone_user_id_32 FROM beds24_booking t0 LEFT JOIN loxone_config t13 ON t13.booking_id = t0.id WHERE t0.id = ?
Parameters:
[
7962
]
|
||||||||||||||||||||||||||||||||||||||
|
2.58 ms (3.80%) |
108 |
SELECT t0.id AS id_1, t0.access_code AS access_code_2, t0.valid_from AS valid_from_3, t0.valid_until AS valid_until_4, t0.manual_valid_from AS manual_valid_from_5, t0.manual_valid_until AS manual_valid_until_6, t0.validity_derived_from_arrival_date AS validity_derived_from_arrival_date_7, t0.validity_derived_from_departure_date AS validity_derived_from_departure_date_8, t0.locked AS locked_9, t0.do_not_send AS do_not_send_10, t0.do_not_sync AS do_not_sync_11, t0.code_sent_at AS code_sent_at_12, t0.beds24_info_item_id AS beds24_info_item_id_13, t0.last_sync_at AS last_sync_at_14, t0.last_error AS last_error_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.booking_id AS booking_id_18, t0.loxone_user_id AS loxone_user_id_19 FROM loxone_config t0 WHERE t0.booking_id = ? LIMIT 1
Parameters:
[
7962
]
|
||||||||||||||||||||||||||||||||||||||
|
2.49 ms (3.67%) |
108 |
SELECT t0.id AS id_1, t0.access_code AS access_code_2, t0.valid_from AS valid_from_3, t0.valid_until AS valid_until_4, t0.manual_valid_from AS manual_valid_from_5, t0.manual_valid_until AS manual_valid_until_6, t0.validity_derived_from_arrival_date AS validity_derived_from_arrival_date_7, t0.validity_derived_from_departure_date AS validity_derived_from_departure_date_8, t0.locked AS locked_9, t0.do_not_send AS do_not_send_10, t0.do_not_sync AS do_not_sync_11, t0.code_sent_at AS code_sent_at_12, t0.beds24_info_item_id AS beds24_info_item_id_13, t0.last_sync_at AS last_sync_at_14, t0.last_error AS last_error_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.booking_id AS booking_id_18, t0.loxone_user_id AS loxone_user_id_19 FROM loxone_config t0 WHERE t0.access_code = ? LIMIT 1
Parameters:
[
"9399"
]
|
||||||||||||||||||||||||||||||||||||||
|
2.32 ms (3.42%) |
23 |
UPDATE beds24_booking SET beds24_created_at = ?, beds24_modified_at = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-10-22 14:44:14" "2026-10-23 08:02:53" "2026-10-23 13:30:03" 15713 ]
|
||||||||||||||||||||||||||||||||||||||
|
1.78 ms (2.63%) |
92 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.loxone_uuid AS loxone_uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.account_id AS account_id_6 FROM loxone_user t0 WHERE t0.id = ?
Parameters:
[
10209
]
|
||||||||||||||||||||||||||||||||||||||
|
1.45 ms (2.14%) |
23 |
SELECT b0_.id AS id_0, b0_.beds24_booking_id AS beds24_booking_id_1, b0_.beds24_master_id AS beds24_master_id_2, b0_.guest_name AS guest_name_3, b0_.arrival_date AS arrival_date_4, b0_.departure_date AS departure_date_5, b0_.status AS status_6, b0_.beds24_created_at AS beds24_created_at_7, b0_.beds24_modified_at AS beds24_modified_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.property_item_id AS property_item_id_11 FROM beds24_booking b0_ INNER JOIN beds24_property_item b1_ ON b0_.property_item_id = b1_.id INNER JOIN beds24_property b2_ ON b1_.property_id = b2_.id WHERE b0_.beds24_booking_id = ? AND b2_.account_id = ? ORDER BY b0_.id ASC LIMIT 1
Parameters:
[ "95086607" 1 ] |
||||||||||||||||||||||||||||||||||||||
|
1.37 ms (2.03%) |
63 |
SELECT t0.id AS id_1, t0.room_id AS room_id_2, t0.room_name AS room_name_3, t0.unit_id AS unit_id_4, t0.unit_name AS unit_name_5, t0.is_auto_created AS is_auto_created_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.property_id AS property_id_9 FROM beds24_property_item t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||||||
|
0.63 ms (0.93%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.loxone_uuid AS loxone_uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.account_id AS account_id_6 FROM loxone_user t0 WHERE t0.account_id = ? ORDER BY t0.id ASC
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||||||
|
0.60 ms (0.88%) |
12 |
SELECT t0.id AS id_1, t0.env_key AS env_key_2, t0.mail_send_time AS mail_send_time_3, t0.sync_time AS sync_time_4, t0.check_in_time AS check_in_time_5, t0.check_out_time AS check_out_time_6, t0.config_lead_days AS config_lead_days_7, t0.mail_lead_days AS mail_lead_days_8, t0.sync_lead_days AS sync_lead_days_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM account t0 WHERE t0.env_key = ? LIMIT 1
Parameters:
[
"HAINER_SEE"
]
|
||||||||||||||||||||||||||||||||||||||
|
0.54 ms (0.80%) |
15 |
SELECT t0.id AS id_1, t0.beds24_property_id AS beds24_property_id_2, t0.name AS name_3, t0.is_auto_created AS is_auto_created_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.account_id AS account_id_7 FROM beds24_property t0 WHERE t0.beds24_property_id = ? AND t0.account_id = ? LIMIT 1
Parameters:
[ "148132" 1 ] |
||||||||||||||||||||||||||||||||||||||
|
0.25 ms (0.37%) |
2 |
SELECT b0_.id AS id_0, a1_.env_key AS env_key_1 FROM beds24_booking b0_ LEFT JOIN loxone_config l2_ ON b0_.id = l2_.booking_id INNER JOIN beds24_property_item b3_ ON b0_.property_item_id = b3_.id INNER JOIN beds24_property b4_ ON b3_.property_id = b4_.id INNER JOIN account a1_ ON b4_.account_id = a1_.id WHERE l2_.id IS NULL AND b0_.departure_date < ? AND a1_.env_key = ? LIMIT 500
Parameters:
[ "2026-10-23" "HAINER_SEE" ] |
||||||||||||||||||||||||||||||||||||||
|
0.17 ms (0.24%) |
2 |
SELECT t0.id AS id_1, t0.beds24_property_id AS beds24_property_id_2, t0.name AS name_3, t0.is_auto_created AS is_auto_created_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.account_id AS account_id_7 FROM beds24_property t0 WHERE t0.account_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||||||
|
0.17 ms (0.24%) |
1 |
SELECT l0_.id AS id_0, l0_.access_code AS access_code_1, l0_.valid_from AS valid_from_2, l0_.valid_until AS valid_until_3, l0_.manual_valid_from AS manual_valid_from_4, l0_.manual_valid_until AS manual_valid_until_5, l0_.validity_derived_from_arrival_date AS validity_derived_from_arrival_date_6, l0_.validity_derived_from_departure_date AS validity_derived_from_departure_date_7, l0_.locked AS locked_8, l0_.do_not_send AS do_not_send_9, l0_.do_not_sync AS do_not_sync_10, l0_.code_sent_at AS code_sent_at_11, l0_.beds24_info_item_id AS beds24_info_item_id_12, l0_.last_sync_at AS last_sync_at_13, l0_.last_error AS last_error_14, l0_.created_at AS created_at_15, l0_.updated_at AS updated_at_16, l0_.booking_id AS booking_id_17, l0_.loxone_user_id AS loxone_user_id_18 FROM loxone_config l0_ INNER JOIN beds24_booking b1_ ON l0_.booking_id = b1_.id INNER JOIN beds24_property_item b2_ ON b1_.property_item_id = b2_.id INNER JOIN beds24_property b3_ ON b2_.property_id = b3_.id INNER JOIN account a4_ ON b3_.account_id = a4_.id WHERE l0_.booking_id IS NOT NULL AND l0_.booking_id NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a4_.env_key = ?
Parameters:
[ 10495 15647 8485 15131 1730 10847 15177 2186 15118 15181 15515 15689 15569 14982 15643 15189 10183 15597 6155 10579 12169 10742 10186 15644 15611 15000 5428 5427 5430 5429 15646 6813 15717 15712 15716 15683 15699 15685 15571 3041 15652 15679 14900 15678 8868 15696 3617 15671 15711 15514 15494 10443 10433 15686 15661 10611 15590 15710 7640 4236 4237 15143 10107 10574 8511 15001 15721 8343 11414 10108 10608 15645 15584 15663 15658 15624 15669 8994 15630 15677 8716 "KULKWITZER_SEE" ]
|
||||||||||||||||||||||||||||||||||||||
|
0.14 ms (0.20%) |
4 |
SELECT l0_.id AS id_0, l0_.access_code AS access_code_1, l0_.valid_from AS valid_from_2, l0_.valid_until AS valid_until_3, l0_.manual_valid_from AS manual_valid_from_4, l0_.manual_valid_until AS manual_valid_until_5, l0_.validity_derived_from_arrival_date AS validity_derived_from_arrival_date_6, l0_.validity_derived_from_departure_date AS validity_derived_from_departure_date_7, l0_.locked AS locked_8, l0_.do_not_send AS do_not_send_9, l0_.do_not_sync AS do_not_sync_10, l0_.code_sent_at AS code_sent_at_11, l0_.beds24_info_item_id AS beds24_info_item_id_12, l0_.last_sync_at AS last_sync_at_13, l0_.last_error AS last_error_14, l0_.created_at AS created_at_15, l0_.updated_at AS updated_at_16, l0_.booking_id AS booking_id_17, l0_.loxone_user_id AS loxone_user_id_18 FROM loxone_config l0_ INNER JOIN beds24_booking b1_ ON l0_.booking_id = b1_.id INNER JOIN beds24_property_item b2_ ON b1_.property_item_id = b2_.id INNER JOIN beds24_property b3_ ON b2_.property_id = b3_.id WHERE b3_.account_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||||||||
|
0.10 ms (0.15%) |
1 |
SELECT l0_.id AS id_0, l0_.access_code AS access_code_1, l0_.valid_from AS valid_from_2, l0_.valid_until AS valid_until_3, l0_.manual_valid_from AS manual_valid_from_4, l0_.manual_valid_until AS manual_valid_until_5, l0_.validity_derived_from_arrival_date AS validity_derived_from_arrival_date_6, l0_.validity_derived_from_departure_date AS validity_derived_from_departure_date_7, l0_.locked AS locked_8, l0_.do_not_send AS do_not_send_9, l0_.do_not_sync AS do_not_sync_10, l0_.code_sent_at AS code_sent_at_11, l0_.beds24_info_item_id AS beds24_info_item_id_12, l0_.last_sync_at AS last_sync_at_13, l0_.last_error AS last_error_14, l0_.created_at AS created_at_15, l0_.updated_at AS updated_at_16, l0_.booking_id AS booking_id_17, l0_.loxone_user_id AS loxone_user_id_18 FROM loxone_config l0_ INNER JOIN beds24_booking b1_ ON l0_.booking_id = b1_.id INNER JOIN beds24_property_item b2_ ON b1_.property_item_id = b2_.id INNER JOIN beds24_property b3_ ON b2_.property_id = b3_.id INNER JOIN account a4_ ON b3_.account_id = a4_.id WHERE l0_.booking_id IS NOT NULL AND l0_.booking_id NOT IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND a4_.env_key = ?
Parameters:
[ 7962 15692 15289 15714 9401 10750 15662 15137 15632 15667 15709 15634 15713 10125 15138 15164 82 15196 81 5275 2850 7842 7596 15635 15231 3979 266 "HAINER_SEE" ]
|
||||||||||||||||||||||||||||||||||||||
|
0.09 ms (0.14%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.loxone_uuid AS loxone_uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.account_id AS account_id_6 FROM loxone_group t0 WHERE t0.id = ?
Parameters:
[
18
]
|
||||||||||||||||||||||||||||||||||||||
|
0.06 ms (0.09%) |
2 |
SELECT b0_.id AS id_0, b0_.beds24_booking_id AS beds24_booking_id_1, b0_.beds24_master_id AS beds24_master_id_2, b0_.guest_name AS guest_name_3, b0_.arrival_date AS arrival_date_4, b0_.departure_date AS departure_date_5, b0_.status AS status_6, b0_.beds24_created_at AS beds24_created_at_7, b0_.beds24_modified_at AS beds24_modified_at_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.property_item_id AS property_item_id_11 FROM beds24_booking b0_ INNER JOIN beds24_property_item b1_ ON b0_.property_item_id = b1_.id INNER JOIN beds24_property b2_ ON b1_.property_id = b2_.id INNER JOIN account a3_ ON b2_.account_id = a3_.id WHERE b0_.status = ? AND b0_.arrival_date <= ? AND b0_.departure_date >= ? AND a3_.env_key = ?
Parameters:
[ "confirmed" "2026-10-30" "2026-10-23" "HAINER_SEE" ] |
||||||||||||||||||||||||||||||||||||||
|
0.03 ms (0.05%) |
2 |
"START TRANSACTION"
Parameters:
[]
|
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\LoxoneUser | 490 |
| App\Entity\LoxoneConfig | 81 |
| App\Entity\Beds24Booking | 81 |
| App\Entity\Beds24PropertyItem | 66 |
| App\Entity\LoxoneGroup | 2 |
| App\Entity\Account | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Account | No errors. |
| App\Entity\Beds24Property | No errors. |
| App\Entity\Beds24PropertyItem | No errors. |
| App\Entity\Beds24LoxoneMapping | No errors. |
| App\Entity\Beds24Booking | No errors. |
| App\Entity\LoxoneConfig | No errors. |
| App\Entity\LoxoneUser | No errors. |
| App\Entity\LoxoneGroup | No errors. |