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 = '2931163' 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 = 4289;

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

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 = 4234 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 = '273747' 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_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;

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 ('3415638', '2026-10-18 10:00:00', '2026-10-18 12:00:00', 'declined', '161099', '2026-10-15 10:35:02', '2026-10-15 10:35:02', 1, 5);

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_2931163', '21748084-02ab-1629-ffff504f94a2f1d2', '2026-10-15 10:35:03', '2026-10-15 10:35:03', 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 = 3552;

DELETE FROM
  loxone_config_loxone_group
WHERE
  loxone_config_id = ?

DELETE FROM loxone_config_loxone_group WHERE loxone_config_id = 3474;

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 (3469, 5);

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

UPDATE loxone_config SET loxone_user_id = 3583, updated_at = '2026-10-15 10:35:03' WHERE id = 3469;

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,
  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 = '973' 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_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 = 5;

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-10-15 10:35:01' AND l1_.id IS NULL AND a2_.env_key = 'PADELPLUS_FGCC' ORDER BY b0_.end_time ASC;

"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-10-16 22:00:00' AND b0_.end_time >= '2026-10-14 22:00:00' AND a1_.env_key = 'PADELPLUS_FGCC' ORDER BY b0_.start_time ASC;

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_sync AS do_not_sync_9,
  l0_.last_sync_at AS last_sync_at_10,
  l0_.last_error AS last_error_11,
  l0_.created_at AS created_at_12,
  l0_.updated_at AS updated_at_13,
  l0_.booking_id AS booking_id_14,
  l0_.loxone_user_id AS loxone_user_id_15
FROM
  loxone_config l0_
  INNER JOIN bookaball_booking b1_ ON l0_.booking_id = b1_.id
WHERE
  b1_.account_id = ?

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_sync AS do_not_sync_9, l0_.last_sync_at AS last_sync_at_10, l0_.last_error AS last_error_11, l0_.created_at AS created_at_12, l0_.updated_at AS updated_at_13, l0_.booking_id AS booking_id_14, l0_.loxone_user_id AS loxone_user_id_15 FROM loxone_config l0_ INNER JOIN bookaball_booking b1_ ON l0_.booking_id = b1_.id WHERE b1_.account_id = 1;