Symfony Profiler

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;

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_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
  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
  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 = '593' 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 = 2;

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 = '2912162' 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 = 2007;

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 = '594' 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 = 3;

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 = '2912182' 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 = 2008;

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 = '2912203' 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 = 2030;

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 = '2912223' 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 = 2031;

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