Query Metrics
17
Database Queries
7
Different statements
92.21 ms
Query time
0
Invalid entities
12704
Managed entities
Queries
admin connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.06 ms |
"START TRANSACTION"
Parameters:
[] |
| 2 | 0.23 ms |
INSERT INTO ApiLog (createdAt, success, log, reference, ApiConnection_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ "2026-07-15 19:05:02" 0 "[216.73.216.78] No route found for "GET https://staging.parkingsoft.de/robots.txt"" null null ] |
| 3 | 6.72 ms |
"COMMIT"
Parameters:
[] |
| 4 | 65.71 ms |
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.success AS success_3, t0.log AS log_4, t0.reference AS reference_5, t0.ApiConnection_id AS ApiConnection_id_6 FROM ApiLog t0
Parameters:
[] |
| 5 | 8.70 ms |
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.success AS success_3, t0.log AS log_4, t0.reference AS reference_5, t0.ApiConnection_id AS ApiConnection_id_6 FROM ApiLog t0 ORDER BY t0.createdAt ASC LIMIT 1
Parameters:
[] |
| 6 | 4.61 ms |
SELECT t0.id AS id_1, t0.json AS json_2, t0.updated AS updated_3, t0.connection_id AS connection_id_4 FROM ApiPreloadBooking t0
Parameters:
[] |
| 7 | 0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 8 | 1.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 9 | 0.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
5
]
|
| 10 | 0.80 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
6
]
|
| 11 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
7
]
|
| 12 | 0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
12
]
|
| 13 | 0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
13
]
|
| 14 | 0.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
14
]
|
| 15 | 1.47 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
15
]
|
| 16 | 0.07 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
16
]
|
| 17 | 1.74 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apiKey AS apiKey_3, t0.clientKey AS clientKey_4, t0.clientId AS clientId_5, t0.brokerFee AS brokerFee_6, t0.validUntil AS validUntil_7, t0.clientInternal_id AS clientInternal_id_8 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
21
]
|
Database Connections
| Name | Service |
|---|---|
| admin | doctrine.dbal.admin_connection |
| parking | doctrine.dbal.parking_connection |
Entity Managers
| Name | Service |
|---|---|
| admin | doctrine.orm.admin_entity_manager |
| parking | doctrine.orm.parking_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
admin entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Admin\ApiLog | 12676 |
| App\Entity\Admin\ApiConnection | 13 |
| App\Entity\Admin\ApiPreloadBooking | 11 |
| App\Entity\Admin\DatabaseUser | 4 |
parking entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
admin entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Admin\ApiLog | No errors. |
| App\Entity\Admin\ApiConnection | No errors. |
| App\Entity\Admin\ApiPreloadBooking | No errors. |
| App\Entity\Admin\DatabaseUser | No errors. |
| App\Entity\Admin\ApiBooking | No errors. |
parking entity manager
No loaded entities.