GET https://parkingsoft.de/api/timetracker/status

Query Metrics

15 Database Queries
5 Different statements
10.85 ms Query time
1 Invalid entities

Queries

Group similar statements

admin connection

# Time Info
1 7.45 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:
[]
2 0.08 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
]
3 0.08 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
]
4 0.05 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
]
5 0.04 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
]
6 0.04 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
]
7 0.04 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
]
8 0.04 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
]
9 0.04 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
]
10 0.04 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
]
11 0.04 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
]
12 0.04 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
]
13 0.10 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.role AS role_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
  2
]
14 2.47 ms
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.timestamp AS timestamp_3, t0.type AS type_4, t0.note AS note_5, t0.isShiftStart AS isShiftStart_6, t0.user_id AS user_id_7, t0.parent_id AS parent_id_8 FROM TimeTracker t0 WHERE t0.user_id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  2
]
15 0.30 ms
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.timestamp AS timestamp_3, t0.type AS type_4, t0.note AS note_5, t0.isShiftStart AS isShiftStart_6, t0.user_id AS user_id_7, t0.parent_id AS parent_id_8 FROM TimeTracker t0 WHERE t0.user_id = ? AND t0.type = ? AND t0.isShiftStart = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  2
  "checkin"
  1
]

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.

Entities Mapping

admin entity manager

Class Mapping errors
App\Entity\Admin\ApiPreloadBooking No errors.
App\Entity\Admin\ApiConnection No errors.
App\Entity\Admin\DatabaseUser No errors.
App\Entity\Admin\ApiBooking
  • The field App\Entity\Admin\ApiBooking#customInformation is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Admin\BookingCustomInformation#apiBooking does not contain the required 'inversedBy="customInformation"' attribute.
  • The field App\Entity\Admin\ApiBooking#detailStatus is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Admin\BookingDetailStatus#apiBooking does not contain the required 'inversedBy="detailStatus"' attribute.
App\Entity\Admin\User No errors.
App\Entity\Admin\TimeTracker No errors.

parking entity manager

No loaded entities.