Symfony Profiler

"COMMIT"

"COMMIT";

SELECT
  t0_.id AS id_0,
  t0_.block_key AS block_key_1,
  t0_.label AS label_2,
  t0_.text_de AS text_de_3,
  t0_.text_en AS text_en_4,
  t0_.notes AS notes_5,
  t0_.created_at AS created_at_6,
  t0_.updated_at AS updated_at_7
FROM
  text_block t0_
ORDER BY
  t0_.block_key ASC

SELECT t0_.id AS id_0, t0_.block_key AS block_key_1, t0_.label AS label_2, t0_.text_de AS text_de_3, t0_.text_en AS text_en_4, t0_.notes AS notes_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7 FROM text_block t0_ ORDER BY t0_.block_key ASC;

SELECT
  b0_.id AS id_0,
  b0_.pickup_at AS pickup_at_1,
  b0_.return_at AS return_at_2,
  b0_.actual_return_at AS actual_return_at_3,
  b0_.overdue_notified_at AS overdue_notified_at_4,
  b0_.status AS status_5,
  b0_.notes AS notes_6,
  b0_.staff_notes AS staff_notes_7,
  b0_.created_at AS created_at_8,
  b0_.updated_at AS updated_at_9,
  b0_.locker_pickup_requested AS locker_pickup_requested_10,
  b0_.locker_return_requested AS locker_return_requested_11,
  b0_.terms_accepted_at AS terms_accepted_at_12,
  b0_.user_id AS user_id_13,
  b0_.device_id AS device_id_14
FROM
  booking b0_
WHERE
  b0_.device_id IN (?)
  AND b0_.status NOT IN (?, ?)
  AND b0_.pickup_at < ?
  AND b0_.return_at > ?
ORDER BY
  b0_.pickup_at ASC

SELECT b0_.id AS id_0, b0_.pickup_at AS pickup_at_1, b0_.return_at AS return_at_2, b0_.actual_return_at AS actual_return_at_3, b0_.overdue_notified_at AS overdue_notified_at_4, b0_.status AS status_5, b0_.notes AS notes_6, b0_.staff_notes AS staff_notes_7, b0_.created_at AS created_at_8, b0_.updated_at AS updated_at_9, b0_.locker_pickup_requested AS locker_pickup_requested_10, b0_.locker_return_requested AS locker_return_requested_11, b0_.terms_accepted_at AS terms_accepted_at_12, b0_.user_id AS user_id_13, b0_.device_id AS device_id_14 FROM booking b0_ WHERE b0_.device_id IN (4) AND b0_.status NOT IN ('cancelled', 'returned') AND b0_.pickup_at < '2026-06-25 00:30:00' AND b0_.return_at > '2026-05-25 23:30:00' ORDER BY b0_.pickup_at ASC;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  booking b0_
WHERE
  b0_.device_id = ?
  AND b0_.status IN (?, ?)
  AND b0_.actual_return_at IS NULL
  AND b0_.return_at < ?

SELECT COUNT(b0_.id) AS sclr_0 FROM booking b0_ WHERE b0_.device_id = 4 AND b0_.status IN ('active', 'overdue') AND b0_.actual_return_at IS NULL AND b0_.return_at < '2026-05-26 18:41:07';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.inventory_number AS inventory_number_4,
  t0.serial_number AS serial_number_5,
  t0.manufacturer AS manufacturer_6,
  t0.model AS model_7,
  t0.status AS status_8,
  t0.image_path AS image_path_9,
  t0.notes AS notes_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.category_id AS category_id_13,
  t0.device_model_id AS device_model_id_14
FROM
  device t0
WHERE
  t0.device_model_id = ?
ORDER BY
  t0.inventory_number ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.inventory_number AS inventory_number_4, t0.serial_number AS serial_number_5, t0.manufacturer AS manufacturer_6, t0.model AS model_7, t0.status AS status_8, t0.image_path AS image_path_9, t0.notes AS notes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category_id AS category_id_13, t0.device_model_id AS device_model_id_14 FROM device t0 WHERE t0.device_model_id = 4 ORDER BY t0.inventory_number ASC;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.description AS description_2,
  d0_.inventory_number AS inventory_number_3,
  d0_.serial_number AS serial_number_4,
  d0_.manufacturer AS manufacturer_5,
  d0_.model AS model_6,
  d0_.status AS status_7,
  d0_.image_path AS image_path_8,
  d0_.notes AS notes_9,
  d0_.created_at AS created_at_10,
  d0_.updated_at AS updated_at_11,
  d0_.category_id AS category_id_12,
  d0_.device_model_id AS device_model_id_13
FROM
  device d0_
WHERE
  d0_.device_model_id = ?
  AND d0_.status <> ?
ORDER BY
  d0_.inventory_number ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2, d0_.inventory_number AS inventory_number_3, d0_.serial_number AS serial_number_4, d0_.manufacturer AS manufacturer_5, d0_.model AS model_6, d0_.status AS status_7, d0_.image_path AS image_path_8, d0_.notes AS notes_9, d0_.created_at AS created_at_10, d0_.updated_at AS updated_at_11, d0_.category_id AS category_id_12, d0_.device_model_id AS device_model_id_13 FROM device d0_ WHERE d0_.device_model_id = 4 AND d0_.status <> 'retired' ORDER BY d0_.inventory_number ASC;

INSERT INTO analytics_event (
  event_type, context, route, event_date,
  created_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO analytics_event (event_type, context, route, event_date, created_at) VALUES ('page_view', '{\"path\":\"\\/modell\\/4\",\"route\":\"app_device_model_detail\"}', 'app_device_model_detail', '2026-05-26', '2026-05-26 18:41:07');

SELECT
  MIN(b0_.pickup_at) AS sclr_0
FROM
  booking b0_
WHERE
  b0_.device_id = ?
  AND b0_.status NOT IN (?, ?)
  AND b0_.pickup_at > ?

SELECT MIN(b0_.pickup_at) AS sclr_0 FROM booking b0_ WHERE b0_.device_id = 4 AND b0_.status NOT IN ('cancelled', 'returned') AND b0_.pickup_at > '2026-05-26 18:41:07';

SELECT
  o0_.id AS id_0,
  o0_.day_of_week AS day_of_week_1,
  o0_.open_time AS open_time_2,
  o0_.close_time AS close_time_3,
  o0_.is_active AS is_active_4
FROM
  opening_hours o0_
WHERE
  o0_.is_active = 1
ORDER BY
  o0_.day_of_week ASC,
  o0_.open_time ASC

SELECT o0_.id AS id_0, o0_.day_of_week AS day_of_week_1, o0_.open_time AS open_time_2, o0_.close_time AS close_time_3, o0_.is_active AS is_active_4 FROM opening_hours o0_ WHERE o0_.is_active = 1 ORDER BY o0_.day_of_week ASC, o0_.open_time ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.description AS description_4,
  t0.description_en AS description_en_5,
  t0.manufacturer AS manufacturer_6,
  t0.model AS model_7,
  t0.image_path AS image_path_8,
  t0.notes AS notes_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.category_id AS category_id_12,
  t0.main_image_id AS main_image_id_13
FROM
  device_model t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.description AS description_4, t0.description_en AS description_en_5, t0.manufacturer AS manufacturer_6, t0.model AS model_7, t0.image_path AS image_path_8, t0.notes AS notes_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12, t0.main_image_id AS main_image_id_13 FROM device_model t0 WHERE t0.id = '4';

SELECT
  t0.id AS id_1,
  t0.image_path AS image_path_2,
  t0.alt_text AS alt_text_3,
  t0.sort_order AS sort_order_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.device_model_id AS device_model_id_7,
  t0.media_asset_id AS media_asset_id_8
FROM
  device_model_image t0
WHERE
  t0.device_model_id = ?
ORDER BY
  t0.sort_order ASC,
  t0.id ASC

SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.alt_text AS alt_text_3, t0.sort_order AS sort_order_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.device_model_id AS device_model_id_7, t0.media_asset_id AS media_asset_id_8 FROM device_model_image t0 WHERE t0.device_model_id = 4 ORDER BY t0.sort_order ASC, t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.description AS description_4,
  t0.description_en AS description_en_5,
  t0.slug AS slug_6,
  t0.icon AS icon_7,
  t0.sort_order AS sort_order_8
FROM
  category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.description AS description_4, t0.description_en AS description_en_5, t0.slug AS slug_6, t0.icon AS icon_7, t0.sort_order AS sort_order_8 FROM category t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.description AS description_4,
  t0.description_en AS description_en_5,
  t0.manufacturer AS manufacturer_6,
  t0.model AS model_7,
  t0.image_path AS image_path_8,
  t0.notes AS notes_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.category_id AS category_id_12,
  t0.main_image_id AS main_image_id_13
FROM
  device_model t0
  INNER JOIN device_model_recommended ON t0.id = device_model_recommended.device_model_target
WHERE
  device_model_recommended.device_model_source = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.description AS description_4, t0.description_en AS description_en_5, t0.manufacturer AS manufacturer_6, t0.model AS model_7, t0.image_path AS image_path_8, t0.notes AS notes_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.category_id AS category_id_12, t0.main_image_id AS main_image_id_13 FROM device_model t0 INNER JOIN device_model_recommended ON t0.id = device_model_recommended.device_model_target WHERE device_model_recommended.device_model_source = 4;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  booking b0_
WHERE
  b0_.device_id = ?
  AND b0_.status NOT IN (?, ?)
  AND b0_.pickup_at < ?
  AND b0_.return_at > ?

SELECT COUNT(b0_.id) AS sclr_0 FROM booking b0_ WHERE b0_.device_id = 4 AND b0_.status NOT IN ('cancelled', 'returned') AND b0_.pickup_at < '2026-05-26 18:42:07' AND b0_.return_at > '2026-05-26 18:41:07';

SELECT
  b0_.device_id AS sclr_0
FROM
  booking b0_
WHERE
  b0_.device_id IN (?)
  AND b0_.status IN (?, ?)
  AND b0_.actual_return_at IS NULL
  AND b0_.return_at < ?
GROUP BY
  b0_.device_id

SELECT b0_.device_id AS sclr_0 FROM booking b0_ WHERE b0_.device_id IN (4) AND b0_.status IN ('active', 'overdue') AND b0_.actual_return_at IS NULL AND b0_.return_at < '2026-05-26 18:41:07' GROUP BY b0_.device_id;