Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.avatar AS avatar_7
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.avatar AS avatar_7 FROM user t0 WHERE t0.id = 6;

SELECT
  o0_.id AS id_0,
  o0_.number AS number_1,
  o0_.name AS name_2,
  o0_.construction_site_cost_center AS construction_site_cost_center_3,
  o0_.order_date AS order_date_4,
  o0_.start_time AS start_time_5,
  o0_.end_time AS end_time_6,
  o0_.repeat_order AS repeat_order_7,
  o0_.repeat_order_amount AS repeat_order_amount_8,
  o0_.daily_use AS daily_use_9,
  o0_.night_operation AS night_operation_10,
  o0_.delivery_note_mail AS delivery_note_mail_11,
  o0_.contact_person AS contact_person_12,
  o0_.contact_person_phone AS contact_person_phone_13,
  o0_.description AS description_14,
  o0_.customer_not_present AS customer_not_present_15,
  o0_.delivery_note_driver_text AS delivery_note_driver_text_16,
  o0_.contact_id AS contact_id_17,
  o0_.vehicle_id AS vehicle_id_18,
  o0_.driver_id AS driver_id_19,
  o0_.unloading_point_id AS unloading_point_id_20,
  o0_.loading_point_id AS loading_point_id_21,
  o0_.signature_id AS signature_id_22,
  o0_.delivery_note_id AS delivery_note_id_23,
  o0_.invoice_id AS invoice_id_24
FROM
  order_order o0_
  LEFT JOIN order_state o1_ ON o0_.id = o1_.order_relation_id
WHERE
  o0_.driver_id = ?
  AND o0_.order_date >= ?
  AND o0_.order_date <= ?
  AND o1_.type IN (?)

SELECT o0_.id AS id_0, o0_.number AS number_1, o0_.name AS name_2, o0_.construction_site_cost_center AS construction_site_cost_center_3, o0_.order_date AS order_date_4, o0_.start_time AS start_time_5, o0_.end_time AS end_time_6, o0_.repeat_order AS repeat_order_7, o0_.repeat_order_amount AS repeat_order_amount_8, o0_.daily_use AS daily_use_9, o0_.night_operation AS night_operation_10, o0_.delivery_note_mail AS delivery_note_mail_11, o0_.contact_person AS contact_person_12, o0_.contact_person_phone AS contact_person_phone_13, o0_.description AS description_14, o0_.customer_not_present AS customer_not_present_15, o0_.delivery_note_driver_text AS delivery_note_driver_text_16, o0_.contact_id AS contact_id_17, o0_.vehicle_id AS vehicle_id_18, o0_.driver_id AS driver_id_19, o0_.unloading_point_id AS unloading_point_id_20, o0_.loading_point_id AS loading_point_id_21, o0_.signature_id AS signature_id_22, o0_.delivery_note_id AS delivery_note_id_23, o0_.invoice_id AS invoice_id_24 FROM order_order o0_ LEFT JOIN order_state o1_ ON o0_.id = o1_.order_relation_id WHERE o0_.driver_id = 6 AND o0_.order_date >= '2024-11-14' AND o0_.order_date <= '2024-11-27' AND o1_.type IN ('DISPONIERT');

SELECT
  t0.id AS id_1,
  t0.system_date_time AS system_date_time_2,
  t0.user_date AS user_date_3,
  t0.user_time AS user_time_4,
  t0.type AS type_5,
  t0.order_relation_id AS order_relation_id_6
FROM
  order_state t0
WHERE
  t0.order_relation_id = ?
ORDER BY
  t0.system_date_time DESC

SELECT t0.id AS id_1, t0.system_date_time AS system_date_time_2, t0.user_date AS user_date_3, t0.user_time AS user_time_4, t0.type AS type_5, t0.order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0.order_relation_id = 117 ORDER BY t0.system_date_time DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.debitor_number AS debitor_number_3,
  t0.supplier_number AS supplier_number_4,
  t0.is_supplier AS is_supplier_5,
  t0.is_customer AS is_customer_6,
  t0.invoice_item_bundled_by_reference_number AS invoice_item_bundled_by_reference_number_7,
  t0.deleted_at AS deleted_at_8,
  t0.deleted_by_user_id AS deleted_by_user_id_9
FROM
  contact_contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.debitor_number AS debitor_number_3, t0.supplier_number AS supplier_number_4, t0.is_supplier AS is_supplier_5, t0.is_customer AS is_customer_6, t0.invoice_item_bundled_by_reference_number AS invoice_item_bundled_by_reference_number_7, t0.deleted_at AS deleted_at_8, t0.deleted_by_user_id AS deleted_by_user_id_9 FROM contact_contact t0 WHERE t0.id = 42;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.license_plate AS license_plate_3,
  t0.type AS type_4,
  t0.deleted_at AS deleted_at_5,
  t0.primary_driver_id AS primary_driver_id_6,
  t0.deleted_by_user_id AS deleted_by_user_id_7
FROM
  vehicle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.license_plate AS license_plate_3, t0.type AS type_4, t0.deleted_at AS deleted_at_5, t0.primary_driver_id AS primary_driver_id_6, t0.deleted_by_user_id AS deleted_by_user_id_7 FROM vehicle t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.system_date_time AS system_date_time_2,
  t0.user_date AS user_date_3,
  t0.user_time AS user_time_4,
  t0.type AS type_5,
  t0.order_relation_id AS order_relation_id_6
FROM
  order_state t0
WHERE
  t0.order_relation_id = ?
ORDER BY
  t0.system_date_time DESC

SELECT t0.id AS id_1, t0.system_date_time AS system_date_time_2, t0.user_date AS user_date_3, t0.user_time AS user_time_4, t0.type AS type_5, t0.order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0.order_relation_id = 132 ORDER BY t0.system_date_time DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.debitor_number AS debitor_number_3,
  t0.supplier_number AS supplier_number_4,
  t0.is_supplier AS is_supplier_5,
  t0.is_customer AS is_customer_6,
  t0.invoice_item_bundled_by_reference_number AS invoice_item_bundled_by_reference_number_7,
  t0.deleted_at AS deleted_at_8,
  t0.deleted_by_user_id AS deleted_by_user_id_9
FROM
  contact_contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.debitor_number AS debitor_number_3, t0.supplier_number AS supplier_number_4, t0.is_supplier AS is_supplier_5, t0.is_customer AS is_customer_6, t0.invoice_item_bundled_by_reference_number AS invoice_item_bundled_by_reference_number_7, t0.deleted_at AS deleted_at_8, t0.deleted_by_user_id AS deleted_by_user_id_9 FROM contact_contact t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.system_date_time AS system_date_time_2,
  t0.user_date AS user_date_3,
  t0.user_time AS user_time_4,
  t0.type AS type_5,
  t0.order_relation_id AS order_relation_id_6
FROM
  order_state t0
WHERE
  t0.order_relation_id = ?
ORDER BY
  t0.system_date_time DESC

SELECT t0.id AS id_1, t0.system_date_time AS system_date_time_2, t0.user_date AS user_date_3, t0.user_time AS user_time_4, t0.type AS type_5, t0.order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0.order_relation_id = 145 ORDER BY t0.system_date_time DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.debitor_number AS debitor_number_3,
  t0.supplier_number AS supplier_number_4,
  t0.is_supplier AS is_supplier_5,
  t0.is_customer AS is_customer_6,
  t0.invoice_item_bundled_by_reference_number AS invoice_item_bundled_by_reference_number_7,
  t0.deleted_at AS deleted_at_8,
  t0.deleted_by_user_id AS deleted_by_user_id_9
FROM
  contact_contact t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.debitor_number AS debitor_number_3, t0.supplier_number AS supplier_number_4, t0.is_supplier AS is_supplier_5, t0.is_customer AS is_customer_6, t0.invoice_item_bundled_by_reference_number AS invoice_item_bundled_by_reference_number_7, t0.deleted_at AS deleted_at_8, t0.deleted_by_user_id AS deleted_by_user_id_9 FROM contact_contact t0 WHERE t0.id = 36;

SELECT
  t0.id AS id_1,
  t0.system_date_time AS system_date_time_2,
  t0.user_date AS user_date_3,
  t0.user_time AS user_time_4,
  t0.type AS type_5,
  t0.order_relation_id AS order_relation_id_6
FROM
  order_state t0
WHERE
  t0.order_relation_id = ?
ORDER BY
  t0.system_date_time DESC

SELECT t0.id AS id_1, t0.system_date_time AS system_date_time_2, t0.user_date AS user_date_3, t0.user_time AS user_time_4, t0.type AS type_5, t0.order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0.order_relation_id = 146 ORDER BY t0.system_date_time DESC;

SELECT
  t0.id AS id_1,
  t0.system_date_time AS system_date_time_2,
  t0.user_date AS user_date_3,
  t0.user_time AS user_time_4,
  t0.type AS type_5,
  t0.order_relation_id AS order_relation_id_6
FROM
  order_state t0
WHERE
  t0.order_relation_id = ?
ORDER BY
  t0.system_date_time DESC

SELECT t0.id AS id_1, t0.system_date_time AS system_date_time_2, t0.user_date AS user_date_3, t0.user_time AS user_time_4, t0.type AS type_5, t0.order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0.order_relation_id = 153 ORDER BY t0.system_date_time DESC;

SELECT
  t0.id AS id_1,
  t0.system_date_time AS system_date_time_2,
  t0.user_date AS user_date_3,
  t0.user_time AS user_time_4,
  t0.type AS type_5,
  t0.order_relation_id AS order_relation_id_6
FROM
  order_state t0
WHERE
  t0.order_relation_id = ?
ORDER BY
  t0.system_date_time DESC

SELECT t0.id AS id_1, t0.system_date_time AS system_date_time_2, t0.user_date AS user_date_3, t0.user_time AS user_time_4, t0.type AS type_5, t0.order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0.order_relation_id = 155 ORDER BY t0.system_date_time DESC;

SELECT
  t0.id AS id_1,
  t0.system_date_time AS system_date_time_2,
  t0.user_date AS user_date_3,
  t0.user_time AS user_time_4,
  t0.type AS type_5,
  t0.order_relation_id AS order_relation_id_6
FROM
  order_state t0
WHERE
  t0.order_relation_id = ?
ORDER BY
  t0.system_date_time DESC

SELECT t0.id AS id_1, t0.system_date_time AS system_date_time_2, t0.user_date AS user_date_3, t0.user_time AS user_time_4, t0.type AS type_5, t0.order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0.order_relation_id = 163 ORDER BY t0.system_date_time DESC;

SELECT
  t0.id AS id_1,
  t0.system_date_time AS system_date_time_2,
  t0.user_date AS user_date_3,
  t0.user_time AS user_time_4,
  t0.type AS type_5,
  t0.order_relation_id AS order_relation_id_6
FROM
  order_state t0
WHERE
  t0.order_relation_id = ?
ORDER BY
  t0.system_date_time DESC

SELECT t0.id AS id_1, t0.system_date_time AS system_date_time_2, t0.user_date AS user_date_3, t0.user_time AS user_time_4, t0.type AS type_5, t0.order_relation_id AS order_relation_id_6 FROM order_state t0 WHERE t0.order_relation_id = 165 ORDER BY t0.system_date_time DESC;