Symfony Profiler

"COMMIT"

"COMMIT";

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 = ?

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 = '148132' AND b0_.room_id = '329148' AND b0_.unit_id = '1';

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 = ?

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 = 9785;

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 = ?

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 = 1;

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 = ?

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 = 266;

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.loxone_user_id = ?

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.loxone_user_id = 5402;

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 = ?

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 = 1;

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

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 = 7962 LIMIT 1;

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

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 = '9399' LIMIT 1;

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 = ?

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 = 15713;

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 = ?

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 = 10209;

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 = ?

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 = 1;

UPDATE
  beds24_booking
SET
  beds24_created_at = ?,
  beds24_modified_at = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE beds24_booking SET beds24_created_at = '2026-10-22 14:44:14', beds24_modified_at = '2026-10-22 15:00:06', updated_at = '2026-10-22 18:30:04' WHERE id = 15713;

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

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 = '95086607' AND b2_.account_id = 1 ORDER BY b0_.id ASC LIMIT 1;

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

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 = 'HAINER_SEE' LIMIT 1;

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

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 = '148132' AND t0.account_id = 1 LIMIT 1;

DELETE FROM
  loxone_config_loxone_group
WHERE
  loxone_config_id = ?

DELETE FROM loxone_config_loxone_group WHERE loxone_config_id = 9860;

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 = ?

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 = 1;

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

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 = 1 ORDER BY t0.id ASC;

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

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 < '2026-10-22' AND a1_.env_key = 'HAINER_SEE' LIMIT 500;

INSERT INTO beds24_booking (
  beds24_booking_id, beds24_master_id,
  guest_name, arrival_date, departure_date,
  status, beds24_created_at, beds24_modified_at,
  created_at, updated_at, property_item_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO beds24_booking (beds24_booking_id, beds24_master_id, guest_name, arrival_date, departure_date, status, beds24_created_at, beds24_modified_at, created_at, updated_at, property_item_id) VALUES ('95088997', NULL, 'Ulrich Manfred Klein', '2026-10-22', '2026-10-26', 'confirmed', '2026-10-22 15:37:39', '2026-10-22 16:00:08', '2026-10-22 18:30:06', '2026-10-22 18:30:06', 143);

INSERT INTO loxone_user (
  name, loxone_uuid, created_at, updated_at,
  account_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO loxone_user (name, loxone_uuid, created_at, updated_at, account_id) VALUES ('X_UlrichManfredKlein_95088997', '217e0f6b-0034-230a-ffff504f94a29f12', '2026-10-22 18:30:07', '2026-10-22 18:30:07', 2);