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

Query Metrics

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

Grouped Statements

Show all queries

admin connection

Time Count Info
7.45 ms
(68.68%)
1
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.47 ms
(22.80%)
1
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
]
0.52 ms
(4.79%)
11
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
]
0.30 ms
(2.80%)
1
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
]
0.10 ms
(0.93%)
1
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
]

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.