Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  b0_.id AS id_0,
  b0_.bookaball_booking_id AS bookaball_booking_id_1,
  b0_.start_time AS start_time_2,
  b0_.end_time AS end_time_3,
  b0_.status AS status_4,
  b0_.access_code AS access_code_5,
  b0_.created_at AS created_at_6,
  b0_.updated_at AS updated_at_7,
  b0_.account_id AS account_id_8,
  b0_.court_id AS court_id_9
FROM
  bookaball_booking b0_
WHERE
  b0_.bookaball_booking_id = ?
  AND b0_.account_id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.bookaball_booking_id AS bookaball_booking_id_1, b0_.start_time AS start_time_2, b0_.end_time AS end_time_3, b0_.status AS status_4, b0_.access_code AS access_code_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.account_id AS account_id_8, b0_.court_id AS court_id_9 FROM bookaball_booking b0_ WHERE b0_.bookaball_booking_id = '2912085' AND b0_.account_id = 1 ORDER BY b0_.id ASC 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_sync AS do_not_sync_10,
  t0.last_sync_at AS last_sync_at_11,
  t0.last_error AS last_error_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.booking_id AS booking_id_15,
  t0.loxone_user_id AS loxone_user_id_16
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_sync AS do_not_sync_10, t0.last_sync_at AS last_sync_at_11, t0.last_error AS last_error_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.booking_id AS booking_id_15, t0.loxone_user_id AS loxone_user_id_16 FROM loxone_config t0 WHERE t0.booking_id = 2006;

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

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_sync AS do_not_sync_10,
  t0.last_sync_at AS last_sync_at_11,
  t0.last_error AS last_error_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.booking_id AS booking_id_15,
  t0.loxone_user_id AS loxone_user_id_16
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_sync AS do_not_sync_10, t0.last_sync_at AS last_sync_at_11, t0.last_error AS last_error_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.booking_id AS booking_id_15, t0.loxone_user_id AS loxone_user_id_16 FROM loxone_config t0 WHERE t0.booking_id = 2022 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_sync AS do_not_sync_10,
  t0.last_sync_at AS last_sync_at_11,
  t0.last_error AS last_error_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.booking_id AS booking_id_15,
  t0.loxone_user_id AS loxone_user_id_16
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_sync AS do_not_sync_10, t0.last_sync_at AS last_sync_at_11, t0.last_error AS last_error_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.booking_id AS booking_id_15, t0.loxone_user_id AS loxone_user_id_16 FROM loxone_config t0 WHERE t0.access_code = '700017' 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_sync AS do_not_sync_10,
  t0.last_sync_at AS last_sync_at_11,
  t0.last_error AS last_error_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.booking_id AS booking_id_15,
  t0.loxone_user_id AS loxone_user_id_16
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_sync AS do_not_sync_10, t0.last_sync_at AS last_sync_at_11, t0.last_error AS last_error_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.booking_id AS booking_id_15, t0.loxone_user_id AS loxone_user_id_16 FROM loxone_config t0 WHERE t0.loxone_user_id = 1642;

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_Guest_2912085', '21256683-02a9-87ab-ffff504f94a2f1d2', '2026-08-16 10:35:10', '2026-08-16 10:35:10', 1);

INSERT INTO bookaball_booking (
  bookaball_booking_id, start_time,
  end_time, status, access_code, created_at,
  updated_at, account_id, court_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO bookaball_booking (bookaball_booking_id, start_time, end_time, status, access_code, created_at, updated_at, account_id, court_id) VALUES ('3181418', '2026-08-17 06:00:00', '2026-08-17 07:00:00', 'active', '550619', '2026-08-16 10:35:02', '2026-08-16 10:35:02', 1, 3);

DELETE FROM
  loxone_config_loxone_group
WHERE
  loxone_config_id = ?

DELETE FROM loxone_config_loxone_group WHERE loxone_config_id = 1582;

SELECT
  b0_.id AS id_0,
  b0_.bookaball_court_id AS bookaball_court_id_1,
  b0_.name AS name_2,
  b0_.created_at AS created_at_3,
  b0_.updated_at AS updated_at_4,
  b0_.account_id AS account_id_5
FROM
  bookaball_court b0_
WHERE
  b0_.bookaball_court_id = ?
  AND b0_.account_id = ?
ORDER BY
  b0_.id ASC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.bookaball_court_id AS bookaball_court_id_1, b0_.name AS name_2, b0_.created_at AS created_at_3, b0_.updated_at AS updated_at_4, b0_.account_id AS account_id_5 FROM bookaball_court b0_ WHERE b0_.bookaball_court_id = '592' AND b0_.account_id = 1 ORDER BY b0_.id ASC LIMIT 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
  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 bookaball_court_loxone_group ON t0.id = bookaball_court_loxone_group.loxone_group_id
WHERE
  bookaball_court_loxone_group.bookaball_court_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 bookaball_court_loxone_group ON t0.id = bookaball_court_loxone_group.loxone_group_id WHERE bookaball_court_loxone_group.bookaball_court_id = 1;

SELECT
  t0.id AS id_1,
  t0.env_key AS env_key_2,
  t0.sync_time AS sync_time_3,
  t0.pre_check_in_minutes AS pre_check_in_minutes_4,
  t0.post_check_out_minutes AS post_check_out_minutes_5,
  t0.config_lead_days AS config_lead_days_6,
  t0.sync_lead_days AS sync_lead_days_7,
  t0.default_loxone_group_name AS default_loxone_group_name_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  account t0
WHERE
  t0.env_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.env_key AS env_key_2, t0.sync_time AS sync_time_3, t0.pre_check_in_minutes AS pre_check_in_minutes_4, t0.post_check_out_minutes AS post_check_out_minutes_5, t0.config_lead_days AS config_lead_days_6, t0.sync_lead_days AS sync_lead_days_7, t0.default_loxone_group_name AS default_loxone_group_name_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM account t0 WHERE t0.env_key = 'PADELPLUS_FGCC' LIMIT 1;

INSERT INTO loxone_config_loxone_group (
  loxone_config_id, loxone_group_id
)
VALUES
  (?, ?)

INSERT INTO loxone_config_loxone_group (loxone_config_id, loxone_group_id) VALUES (1585, 5);

UPDATE
  loxone_config
SET
  loxone_user_id = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE loxone_config SET loxone_user_id = 1681, updated_at = '2026-08-16 10:35:10' WHERE id = 1574;

DELETE FROM
  bookaball_booking
WHERE
  id = ?

DELETE FROM bookaball_booking WHERE id = 1970;

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

SELECT
  b0_.id AS id_0,
  b0_.bookaball_booking_id AS bookaball_booking_id_1,
  b0_.start_time AS start_time_2,
  b0_.end_time AS end_time_3,
  b0_.status AS status_4,
  b0_.access_code AS access_code_5,
  b0_.created_at AS created_at_6,
  b0_.updated_at AS updated_at_7,
  b0_.account_id AS account_id_8,
  b0_.court_id AS court_id_9
FROM
  bookaball_booking b0_
  LEFT JOIN loxone_config l1_ ON b0_.id = l1_.booking_id
  INNER JOIN account a2_ ON b0_.account_id = a2_.id
WHERE
  b0_.end_time < ?
  AND l1_.id IS NULL
  AND a2_.env_key = ?
ORDER BY
  b0_.end_time ASC

SELECT b0_.id AS id_0, b0_.bookaball_booking_id AS bookaball_booking_id_1, b0_.start_time AS start_time_2, b0_.end_time AS end_time_3, b0_.status AS status_4, b0_.access_code AS access_code_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.account_id AS account_id_8, b0_.court_id AS court_id_9 FROM bookaball_booking b0_ LEFT JOIN loxone_config l1_ ON b0_.id = l1_.booking_id INNER JOIN account a2_ ON b0_.account_id = a2_.id WHERE b0_.end_time < '2026-08-16 10:35:01' AND l1_.id IS NULL AND a2_.env_key = 'PADELPLUS_FGCC' ORDER BY b0_.end_time ASC;

INSERT INTO loxone_config (
  access_code, valid_from, valid_until,
  manual_valid_from, manual_valid_until,
  validity_derived_from_arrival_date,
  validity_derived_from_departure_date,
  locked, do_not_sync, last_sync_at,
  last_error, created_at, updated_at,
  booking_id, loxone_user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO loxone_config (access_code, valid_from, valid_until, manual_valid_from, manual_valid_until, validity_derived_from_arrival_date, validity_derived_from_departure_date, locked, do_not_sync, last_sync_at, last_error, created_at, updated_at, booking_id, loxone_user_id) VALUES ('161324', '2026-08-16 15:00:00', '2026-08-16 17:30:00', NULL, NULL, '2026-08-16 15:30:00', '2026-08-16 16:30:00', 0, 0, NULL, NULL, '2026-08-16 10:35:10', '2026-08-16 10:35:10', 2050, NULL);

"START TRANSACTION"

"START TRANSACTION";

SELECT
  b0_.id AS id_0,
  b0_.bookaball_booking_id AS bookaball_booking_id_1,
  b0_.start_time AS start_time_2,
  b0_.end_time AS end_time_3,
  b0_.status AS status_4,
  b0_.access_code AS access_code_5,
  b0_.created_at AS created_at_6,
  b0_.updated_at AS updated_at_7,
  b0_.account_id AS account_id_8,
  b0_.court_id AS court_id_9
FROM
  bookaball_booking b0_
  INNER JOIN account a1_ ON b0_.account_id = a1_.id
WHERE
  b0_.status = ?
  AND b0_.start_time <= ?
  AND b0_.end_time >= ?
  AND a1_.env_key = ?
ORDER BY
  b0_.start_time ASC

SELECT b0_.id AS id_0, b0_.bookaball_booking_id AS bookaball_booking_id_1, b0_.start_time AS start_time_2, b0_.end_time AS end_time_3, b0_.status AS status_4, b0_.access_code AS access_code_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.account_id AS account_id_8, b0_.court_id AS court_id_9 FROM bookaball_booking b0_ INNER JOIN account a1_ ON b0_.account_id = a1_.id WHERE b0_.status = 'active' AND b0_.start_time <= '2026-08-17 22:00:00' AND b0_.end_time >= '2026-08-15 22:00:00' AND a1_.env_key = 'PADELPLUS_FGCC' ORDER BY b0_.start_time ASC;