Redirect 302 redirect from GET @app_dashboard_dashboard (5e5dcd)

GET https://plavs.ch/

Query Metrics

17 Database Queries
9 Different statements
84.51 ms Query time
2 Invalid entities
103 Managed entities

Queries

Group similar statements

# Time Info
1 0.54 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 25.16 ms
SELECT o0_.createdAt AS createdAt_0, o0_.updatedAt AS updatedAt_1, o0_.orderNumber AS orderNumber_2, o0_.title AS title_3, o0_.description AS description_4, o0_.leadin AS leadin_5, o0_.leadout AS leadout_6, o0_.notes AS notes_7, o0_.notesToDriver AS notesToDriver_8, o0_.bookingReference AS bookingReference_9, o0_.cost AS cost_10, o0_.orderStateCode AS orderStateCode_11, o0_.paymentTypeCode AS paymentTypeCode_12, o0_.duedate AS duedate_13, o0_.duedateOriginal AS duedateOriginal_14, o0_.paymentdate AS paymentdate_15, o0_.startdate AS startdate_16, o0_.enddate AS enddate_17, o0_.currency AS currency_18, o0_.id AS id_19, o0_.deletedAt AS deletedAt_20, o0_.vatrate_id AS vatrate_id_21, o0_.cancellationPolicy_id AS cancellationPolicy_id_22, o0_.customer_id AS customer_id_23 FROM orders o0_ WHERE (o0_.deletedAt IS NULL) ORDER BY o0_.updatedAt DESC LIMIT 20
Parameters:
[]
3 0.55 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.rate AS rate_3, t0.active AS active_4, t0.is_default AS is_default_5 FROM vatrate t0 WHERE t0.id IN (?)
Parameters:
[
  5
]
4 0.65 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.textEnglish AS textEnglish_3, t0.textGerman AS textGerman_4, t0.active AS active_5, t0.is_default AS is_default_6 FROM cancellationpolicy t0 WHERE t0.id IN (?, ?, ?, ?)
Parameters:
[
  3
  18
  15
  14
]
5 22.06 ms
SELECT o0_.createdAt AS createdAt_0, o0_.updatedAt AS updatedAt_1, o0_.orderNumber AS orderNumber_2, o0_.title AS title_3, o0_.description AS description_4, o0_.leadin AS leadin_5, o0_.leadout AS leadout_6, o0_.notes AS notes_7, o0_.notesToDriver AS notesToDriver_8, o0_.bookingReference AS bookingReference_9, o0_.cost AS cost_10, o0_.orderStateCode AS orderStateCode_11, o0_.paymentTypeCode AS paymentTypeCode_12, o0_.duedate AS duedate_13, o0_.duedateOriginal AS duedateOriginal_14, o0_.paymentdate AS paymentdate_15, o0_.startdate AS startdate_16, o0_.enddate AS enddate_17, o0_.currency AS currency_18, o0_.id AS id_19, o0_.deletedAt AS deletedAt_20, c1_.createdAt AS createdAt_21, c1_.updatedAt AS updatedAt_22, c1_.id AS id_23, c1_.customerNumber AS customerNumber_24, c1_.titleCode AS titleCode_25, c1_.languageCode AS languageCode_26, c1_.name AS name_27, c1_.name2 AS name2_28, c1_.street AS street_29, c1_.street2 AS street2_30, c1_.zipAndCity AS zipAndCity_31, c1_.countryCode AS countryCode_32, c1_.phoneNumberPrivate AS phoneNumberPrivate_33, c1_.phoneNumberBusiness AS phoneNumberBusiness_34, c1_.phoneNumberMobile AS phoneNumberMobile_35, c1_.phoneNumberFax AS phoneNumberFax_36, c1_.emailAddress AS emailAddress_37, c1_.notes AS notes_38, c1_.defaultCurrency AS defaultCurrency_39, o0_.vatrate_id AS vatrate_id_40, o0_.cancellationPolicy_id AS cancellationPolicy_id_41, o0_.customer_id AS customer_id_42 FROM orders o0_ INNER JOIN customer c1_ ON o0_.customer_id = c1_.id WHERE (o0_.orderStateCode = ?) AND (o0_.deletedAt IS NULL) ORDER BY o0_.startdate ASC LIMIT 20
Parameters:
[
  2
]
6 0.52 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.rate AS rate_3, t0.active AS active_4, t0.is_default AS is_default_5 FROM vatrate t0 WHERE t0.id IN (?)
Parameters:
[
  1
]
7 0.45 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.textEnglish AS textEnglish_3, t0.textGerman AS textGerman_4, t0.active AS active_5, t0.is_default AS is_default_6 FROM cancellationpolicy t0 WHERE t0.id IN (?)
Parameters:
[
  21
]
8 22.23 ms
SELECT o0_.createdAt AS createdAt_0, o0_.updatedAt AS updatedAt_1, o0_.orderNumber AS orderNumber_2, o0_.title AS title_3, o0_.description AS description_4, o0_.leadin AS leadin_5, o0_.leadout AS leadout_6, o0_.notes AS notes_7, o0_.notesToDriver AS notesToDriver_8, o0_.bookingReference AS bookingReference_9, o0_.cost AS cost_10, o0_.orderStateCode AS orderStateCode_11, o0_.paymentTypeCode AS paymentTypeCode_12, o0_.duedate AS duedate_13, o0_.duedateOriginal AS duedateOriginal_14, o0_.paymentdate AS paymentdate_15, o0_.startdate AS startdate_16, o0_.enddate AS enddate_17, o0_.currency AS currency_18, o0_.id AS id_19, o0_.deletedAt AS deletedAt_20, c1_.createdAt AS createdAt_21, c1_.updatedAt AS updatedAt_22, c1_.id AS id_23, c1_.customerNumber AS customerNumber_24, c1_.titleCode AS titleCode_25, c1_.languageCode AS languageCode_26, c1_.name AS name_27, c1_.name2 AS name2_28, c1_.street AS street_29, c1_.street2 AS street2_30, c1_.zipAndCity AS zipAndCity_31, c1_.countryCode AS countryCode_32, c1_.phoneNumberPrivate AS phoneNumberPrivate_33, c1_.phoneNumberBusiness AS phoneNumberBusiness_34, c1_.phoneNumberMobile AS phoneNumberMobile_35, c1_.phoneNumberFax AS phoneNumberFax_36, c1_.emailAddress AS emailAddress_37, c1_.notes AS notes_38, c1_.defaultCurrency AS defaultCurrency_39, o0_.vatrate_id AS vatrate_id_40, o0_.cancellationPolicy_id AS cancellationPolicy_id_41, o0_.customer_id AS customer_id_42 FROM orders o0_ INNER JOIN customer c1_ ON o0_.customer_id = c1_.id WHERE (o0_.orderStateCode = ? AND o0_.duedate <= ?) AND (o0_.deletedAt IS NULL)
Parameters:
[
  4
  "2025-09-17 00:00:00"
]
9 0.52 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.textEnglish AS textEnglish_3, t0.textGerman AS textGerman_4, t0.active AS active_5, t0.is_default AS is_default_6 FROM cancellationpolicy t0 WHERE t0.id IN (?)
Parameters:
[
  13
]
10 8.98 ms
SELECT h0_.createdAt AS createdAt_0, h0_.updatedAt AS updatedAt_1, h0_.id AS id_2, h0_.text AS text_3 FROM HQStatus h0_ ORDER BY h0_.createdAt DESC LIMIT 1
Parameters:
[]
11 0.59 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:
[
  4496
]
12 0.48 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:
[
  4201
]
13 0.36 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:
[
  2219
]
14 0.38 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:
[
  2962
]
15 0.33 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:
[
  2198
]
16 0.34 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:
[
  2586
]
17 0.36 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:
[
  4972
]

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\Order 66
App\Entity\Customer 26
App\Entity\CancellationPolicy 6
App\Entity\VATRate 2
App\Entity\User 1
App\Entity\Driver 1
App\Entity\HQStatus 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\HQStatus No errors.