POST https://parkingsoft.de/bookings/edit

Query Metrics

28 Database Queries
8 Different statements
10.53 ms Query time
0 Invalid entities

Queries

Group similar statements

admin connection

# Time Info
1 0.47 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:
[
  3
]
2 6.95 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:
[]
3 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.clientInternal_id AS clientInternal_id_7 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
  3
]
4 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.clientInternal_id AS clientInternal_id_7 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
  4
]
5 0.09 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.clientInternal_id AS clientInternal_id_7 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
  5
]
6 0.11 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.clientInternal_id AS clientInternal_id_7 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
  6
]
7 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.clientInternal_id AS clientInternal_id_7 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
  7
]
8 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.clientInternal_id AS clientInternal_id_7 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
  12
]
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.clientInternal_id AS clientInternal_id_7 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
  13
]
10 0.03 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.clientInternal_id AS clientInternal_id_7 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
  14
]
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.clientInternal_id AS clientInternal_id_7 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
  15
]
12 0.03 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.clientInternal_id AS clientInternal_id_7 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
  16
]
13 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.clientInternal_id AS clientInternal_id_7 FROM ApiConnection t0 WHERE t0.id = ?
Parameters:
[
  21
]
14 0.29 ms
SELECT t0.id AS id_1, t0.agency AS agency_2, t0.product AS product_3, t0.reference AS reference_4, t0.lastName AS lastName_5, t0.firstName AS firstName_6, t0.duration AS duration_7, t0.arrivalDate AS arrivalDate_8, t0.arrivalTime AS arrivalTime_9, t0.departureDate AS departureDate_10, t0.departureTime AS departureTime_11, t0.passengers AS passengers_12, t0.status AS status_13, t0.price AS price_14, t0.licensePlate AS licensePlate_15, t0.model AS model_16, t0.color AS color_17, t0.phone AS phone_18, t0.notice AS notice_19, t0.flightNumberArrival AS flightNumberArrival_20, t0.flightNumberDeparture AS flightNumberDeparture_21, t0.terminalDeparture AS terminalDeparture_22, t0.terminalArrival AS terminalArrival_23, t0.paymentStatus AS paymentStatus_24, t0.createdByApiAt AS createdByApiAt_25, t0.updatedByApiAt AS updatedByApiAt_26, t0.createdAt AS createdAt_27, t0.updatedAt AS updatedAt_28, t0.ApiConnection_id AS ApiConnection_id_29 FROM ApiBooking t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "15232"
]
15 0.07 ms
"START TRANSACTION"
Parameters:
[]
16 0.15 ms
UPDATE ApiConnection SET clientId = ? WHERE id = ?
Parameters:
[
  "0"
  3
]
17 0.12 ms
UPDATE ApiConnection SET clientId = ? WHERE id = ?
Parameters:
[
  "0"
  4
]
18 0.12 ms
UPDATE ApiConnection SET clientId = ? WHERE id = ?
Parameters:
[
  "0"
  5
]
19 0.12 ms
UPDATE ApiConnection SET clientId = ? WHERE id = ?
Parameters:
[
  "0"
  6
]
20 0.12 ms
UPDATE ApiConnection SET clientId = ? WHERE id = ?
Parameters:
[
  "1484"
  7
]
21 0.10 ms
UPDATE ApiConnection SET clientId = ? WHERE id = ?
Parameters:
[
  "0"
  12
]
22 0.07 ms
UPDATE ApiConnection SET clientId = ? WHERE id = ?
Parameters:
[
  "0"
  13
]
23 0.07 ms
UPDATE ApiConnection SET clientId = ? WHERE id = ?
Parameters:
[
  "0"
  14
]
24 0.07 ms
UPDATE ApiConnection SET clientId = ? WHERE id = ?
Parameters:
[
  "0"
  15
]
25 0.10 ms
UPDATE ApiConnection SET clientId = ? WHERE id = ?
Parameters:
[
  "0"
  16
]
26 0.09 ms
UPDATE ApiConnection SET clientId = ? WHERE id = ?
Parameters:
[
  "0"
  21
]
27 0.84 ms
UPDATE ApiBooking SET notice = ? WHERE id = ?
Parameters:
[
  "<div><span style="caret-color: rgb(255, 0, 0); font-size: 22px;"><b><font color="#0000ff">P2</font></b></span></div><div><span style="caret-color: rgb(255, 0, 0); color: rgb(255, 0, 0); font-size: 22px;"><b>Landung um 19.00</b></span><br></div>"
  15232
]
28 0.10 ms
"COMMIT"
Parameters:
[]

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\User No errors.
App\Entity\Admin\ApiPreloadBooking No errors.
App\Entity\Admin\ApiConnection No errors.
App\Entity\Admin\DatabaseUser No errors.
App\Entity\Admin\ApiBooking No errors.

parking entity manager

No loaded entities.