Symfony Profiler

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

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;

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)

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 = 4 AND o0_.duedate <= '2025-09-17 00:00:00') AND (o0_.deletedAt IS NULL);

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

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 = 2) AND (o0_.deletedAt IS NULL) ORDER BY o0_.startdate ASC LIMIT 20;

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

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;

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 = ?

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 = 4496;

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 (?)

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 (5);

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 (?)

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 (21);

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 (?, ?, ?, ?)

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 (3, 18, 15, 14);

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 = ?

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 = 12;