GET https://plavs.ch/pdf/order/66295

Query Metrics

23 Database Queries
5 Different statements
10.98 ms Query time
4 Invalid entities
47 Managed entities

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.displayName AS displayName_4, t0.password AS password_5, t0.email AS email_6, t0.email_canonical AS email_canonical_7, t0.salt AS salt_8, t0.roles AS roles_9, t0.enabled AS enabled_10, t0.locked AS locked_11, t0.expired AS expired_12, t0.credentials_expired AS credentials_expired_13, t0.signaturePath AS signaturePath_14, t0.driver_id AS driver_id_15 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  12
]
2 0.71 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.orderNumber AS orderNumber_3, t0.title AS title_4, t0.description AS description_5, t0.leadin AS leadin_6, t0.leadout AS leadout_7, t0.notes AS notes_8, t0.notesToDriver AS notesToDriver_9, t0.bookingReference AS bookingReference_10, t0.cost AS cost_11, t0.orderStateCode AS orderStateCode_12, t0.paymentTypeCode AS paymentTypeCode_13, t0.duedate AS duedate_14, t0.duedateOriginal AS duedateOriginal_15, t0.paymentdate AS paymentdate_16, t0.startdate AS startdate_17, t0.enddate AS enddate_18, t0.currency AS currency_19, t0.id AS id_20, t0.deletedAt AS deletedAt_21, t0.vatrate_id AS vatrate_id_22, t23.id AS id_24, t23.description AS description_25, t23.rate AS rate_26, t23.active AS active_27, t23.is_default AS is_default_28, t0.cancellationPolicy_id AS cancellationPolicy_id_29, t30.id AS id_31, t30.description AS description_32, t30.textEnglish AS textEnglish_33, t30.textGerman AS textGerman_34, t30.active AS active_35, t30.is_default AS is_default_36, t0.customer_id AS customer_id_37 FROM orders t0 INNER JOIN vatrate t23 ON t0.vatrate_id = t23.id INNER JOIN cancellationpolicy t30 ON t0.cancellationPolicy_id = t30.id WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
  "66295"
]
3 0.57 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.customerNumber AS customerNumber_4, t0.titleCode AS titleCode_5, t0.languageCode AS languageCode_6, t0.name AS name_7, t0.name2 AS name2_8, t0.street AS street_9, t0.street2 AS street2_10, t0.zipAndCity AS zipAndCity_11, t0.countryCode AS countryCode_12, t0.phoneNumberPrivate AS phoneNumberPrivate_13, t0.phoneNumberBusiness AS phoneNumberBusiness_14, t0.phoneNumberMobile AS phoneNumberMobile_15, t0.phoneNumberFax AS phoneNumberFax_16, t0.emailAddress AS emailAddress_17, t0.notes AS notes_18, t0.defaultCurrency AS defaultCurrency_19 FROM customer t0 WHERE t0.id = ?
Parameters:
[
  2972
]
4 0.84 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.startDate AS startDate_3, t0.endDate AS endDate_4, t0.title AS title_5, t0.startLocation AS startLocation_6, t0.endLocation AS endLocation_7, t0.orderDetailNumber AS orderDetailNumber_8, t0.notes AS notes_9, t0.notesToDriver AS notesToDriver_10, t0.leadin AS leadin_11, t0.leadout AS leadout_12, t0.numberOfPassengers AS numberOfPassengers_13, t0.driverAckConfirmed AS driverAckConfirmed_14, t0.driverAckTime AS driverAckTime_15, t0.driverAckComment AS driverAckComment_16, t0.carType AS carType_17, t0.id AS id_18, t0.deletedAt AS deletedAt_19, t0.order_id AS order_id_20, t0.driver_id AS driver_id_21, t0.car_id AS car_id_22 FROM orderdetail t0 WHERE t0.order_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.startDate ASC, t0.orderDetailNumber ASC
Parameters:
[
  66295
]
5 0.67 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111295
]
6 0.48 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111296
]
7 0.41 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111297
]
8 0.36 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111298
]
9 0.40 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111304
]
10 0.39 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111299
]
11 0.36 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111301
]
12 0.45 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111302
]
13 0.48 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111300
]
14 0.44 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111303
]
15 0.45 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111305
]
16 0.40 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111306
]
17 0.45 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111307
]
18 0.42 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111308
]
19 0.40 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111309
]
20 0.48 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111310
]
21 0.41 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111311
]
22 0.47 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111312
]
23 0.41 ms
SELECT t0.createdAt AS createdAt_1, t0.updatedAt AS updatedAt_2, t0.id AS id_3, t0.description AS description_4, t0.costQuantity AS costQuantity_5, t0.costAmount AS costAmount_6, t0.costPercent AS costPercent_7, t0.sortKey AS sortKey_8, t0.deletedAt AS deletedAt_9, t0.order_detail_id AS order_detail_id_10 FROM orderdetailentry t0 WHERE t0.order_detail_id = ? AND ((t0.deletedAt IS NULL)) ORDER BY t0.sortKey ASC
Parameters:
[
  111313
]

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\OrderDetailEntry 22
App\Entity\OrderDetail 19
App\Entity\User 1
App\Entity\Driver 1
App\Entity\Order 1
App\Entity\Customer 1
App\Entity\VATRate 1
App\Entity\CancellationPolicy 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\BaseEntity No errors.
App\Entity\Driver
  • The field 'App\Entity\Driver#salaryParameterA' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Driver#salaryParameterB' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Driver#salaryParameterC' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Driver#salaryParameterD' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Driver#salaryParameterNightSurcharge' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Order No errors.
App\Entity\VATRate No errors.
App\Entity\CancellationPolicy No errors.
App\Entity\Customer
  • The field 'App\Entity\Customer#titleCode' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
  • The field 'App\Entity\Customer#languageCode' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\OrderDetail No errors.
App\Entity\Car No errors.
App\Entity\OrderDetailEntry
  • The field 'App\Entity\OrderDetailEntry#costQuantity' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\OrderDetailEntry#costAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\WorkReport
  • The field 'App\Entity\WorkReport#payableMinutes' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\WorkReport#totalKilometers' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\WorkReport#kilometersWithClients' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\WorkReport#expenseParking' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\WorkReport#expenseHotel' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\WorkReport#expenseMobilePhone' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\WorkReport#expenseFS' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\WorkReport#expenseME' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\WorkReport#expenseNE' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.