Query Metrics
26
Database Queries
8
Different statements
24.33 ms
Query time
0
Invalid entities
310
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.61 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 2 | 2.40 ms |
INSERT INTO analytics_event (event_type, context, route, event_date, created_at) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "page_view" "{"path":"\/","route":"app_home"}" "app_home" "2026-05-26" "2026-05-26 17:08:03" ] |
||||||||||||||||||||||||||||||
| 3 | 2.36 ms |
"COMMIT"
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 4 | 1.03 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" ]
|
||||||||||||||||||||||||||||||
| 5 | 1.43 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
]
|
||||||||||||||||||||||||||||||
| 6 | 1.83 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
]
|
||||||||||||||||||||||||||||||
| 7 | 0.62 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
]
|
||||||||||||||||||||||||||||||
| 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:
[
1
]
|
||||||||||||||||||||||||||||||
| 9 | 1.23 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
]
|
||||||||||||||||||||||||||||||
| 10 | 0.34 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
]
|
||||||||||||||||||||||||||||||
| 11 | 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:
[
16
]
|
||||||||||||||||||||||||||||||
| 12 | 0.52 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
]
|
||||||||||||||||||||||||||||||
| 13 | 0.72 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
]
|
||||||||||||||||||||||||||||||
| 14 | 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:
[
12
]
|
||||||||||||||||||||||||||||||
| 15 | 0.62 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
]
|
||||||||||||||||||||||||||||||
| 16 | 0.80 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
]
|
||||||||||||||||||||||||||||||
| 17 | 0.72 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
]
|
||||||||||||||||||||||||||||||
| 18 | 0.61 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
]
|
||||||||||||||||||||||||||||||
| 19 | 0.75 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
]
|
||||||||||||||||||||||||||||||
| 20 | 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:
[
3
]
|
||||||||||||||||||||||||||||||
| 21 | 0.66 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
]
|
||||||||||||||||||||||||||||||
| 22 | 0.72 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
]
|
||||||||||||||||||||||||||||||
| 23 | 1.58 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
]
|
||||||||||||||||||||||||||||||
| 24 | 0.52 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:
[]
|
||||||||||||||||||||||||||||||
| 25 | 0.51 ms |
SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.description AS description_2, h0_.background_image AS background_image_3, h0_.link_url AS link_url_4, h0_.cta_label AS cta_label_5, h0_.created_at AS created_at_6, h0_.updated_at AS updated_at_7, h0_.media_asset_id AS media_asset_id_8 FROM hero_banner h0_ ORDER BY h0_.created_at DESC LIMIT 8
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 26 | 1.36 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\DeviceModel | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\Device | No errors. |
| App\Entity\MediaAsset | No errors. |
| App\Entity\DeviceModelImage | No errors. |
| App\Entity\Booking | No errors. |
| App\Entity\HeroBanner | No errors. |
| App\Entity\TextBlock | No errors. |