GET https://rental.florianbirkenberger.de/katalog

Query Metrics

26 Database Queries
8 Different statements
22.02 ms Query time
0 Invalid entities
310 Managed entities

Queries

Group similar statements

# Time Info
1 0.17 ms
"START TRANSACTION"
Parameters:
[]
2 1.26 ms
INSERT INTO analytics_event (event_type, context, route, event_date, created_at) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  "page_view"
  "{"path":"\/katalog","route":"app_catalog"}"
  "app_catalog"
  "2026-05-26"
  "2026-05-26 18:44:17"
]
3 2.16 ms
"COMMIT"
Parameters:
[]
4 1.28 ms
SELECT b0_.device_id AS sclr_0 FROM booking b0_ WHERE b0_.pickup_at < ? AND b0_.return_at > ? AND b0_.status NOT IN (?, ?)
Parameters:
[
  "2026-05-26 19:15:17"
  "2026-05-26 18:14:17"
  "cancelled"
  "returned"
]
5 0.96 ms
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.name_en AS name_en_2, d0_.description AS description_3, d0_.description_en AS description_en_4, d0_.manufacturer AS manufacturer_5, d0_.model AS model_6, d0_.image_path AS image_path_7, d0_.notes AS notes_8, d0_.created_at AS created_at_9, d0_.updated_at AS updated_at_10, d0_.category_id AS category_id_11, d0_.main_image_id AS main_image_id_12 FROM device_model d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id INNER JOIN device d2_ ON d0_.id = d2_.device_model_id AND (d2_.status NOT IN (?, ?)) GROUP BY d0_.id ORDER BY d0_.name ASC
Parameters:
[
  "retired"
  "maintenance"
]
6 0.97 ms
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
Parameters:
[
  9
]
7 0.53 ms
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
Parameters:
[
  10
]
8 0.59 ms
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
Parameters:
[
  4
]
9 0.45 ms
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
Parameters:
[
  1
]
10 0.57 ms
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
Parameters:
[
  2
]
11 1.10 ms
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
Parameters:
[
  15
]
12 0.59 ms
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
Parameters:
[
  16
]
13 0.47 ms
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
Parameters:
[
  14
]
14 1.03 ms
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
Parameters:
[
  11
]
15 0.93 ms
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
Parameters:
[
  12
]
16 1.07 ms
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
Parameters:
[
  6
]
17 1.27 ms
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
Parameters:
[
  13
]
18 1.06 ms
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
Parameters:
[
  18
]
19 0.47 ms
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
Parameters:
[
  8
]
20 0.56 ms
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
Parameters:
[
  5
]
21 0.54 ms
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
Parameters:
[
  3
]
22 0.70 ms
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
Parameters:
[
  17
]
23 0.63 ms
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
Parameters:
[
  19
]
24 0.59 ms
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
Parameters:
[
  7
]
25 1.04 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_en AS name_en_2, c0_.description AS description_3, c0_.description_en AS description_en_4, c0_.slug AS slug_5, c0_.icon AS icon_6, c0_.sort_order AS sort_order_7 FROM category c0_ ORDER BY c0_.sort_order ASC, c0_.name ASC
Parameters:
[]
26 1.02 ms
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
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\TextBlock 265
App\Entity\DeviceModel 19
App\Entity\Device 19
App\Entity\Category 6
App\Entity\AnalyticsEvent 1

Entities Mapping

Class Mapping errors
App\Entity\AnalyticsEvent No errors.
App\Entity\Booking No errors.
App\Entity\Device No errors.
App\Entity\DeviceModel No errors.
App\Entity\Category No errors.
App\Entity\MediaAsset No errors.
App\Entity\DeviceModelImage No errors.
App\Entity\TextBlock No errors.