Query Metrics
23
Database Queries
5
Different statements
10.98 ms
Query time
4
Invalid entities
47
Managed entities
Queries
#▲ | 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 |
|
App\Entity\Order | No errors. |
App\Entity\VATRate | No errors. |
App\Entity\CancellationPolicy | No errors. |
App\Entity\Customer |
|
App\Entity\OrderDetail | No errors. |
App\Entity\Car | No errors. |
App\Entity\OrderDetailEntry |
|
App\Entity\WorkReport |
|