Symfony Profiler

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.service_date AS service_date_1,
  c0_.created_at AS created_at_2
FROM
  customer_order c0_
WHERE
  c0_.status <> (?)
  OR c0_.status IS NULL
ORDER BY
  c0_.service_date DESC,
  c0_.created_at DESC
LIMIT
  20

SELECT DISTINCT c0_.id AS id_0, c0_.service_date AS service_date_1, c0_.created_at AS created_at_2 FROM customer_order c0_ WHERE c0_.status <> ('cancelled') OR c0_.status IS NULL ORDER BY c0_.service_date DESC, c0_.created_at DESC LIMIT 20;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.display_name AS display_name_5
FROM
  app_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.display_name AS display_name_5 FROM app_user t0 WHERE t0.id = '019fe74c-e07f-7b19-9238-0660fb6839f2';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.normalized_name AS normalized_name_3,
  t0.address AS address_4,
  t0.archived_at AS archived_at_5,
  t0.customer_id AS customer_id_6
FROM
  customer_unit t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.normalized_name AS normalized_name_3, t0.address AS address_4, t0.archived_at AS archived_at_5, t0.customer_id AS customer_id_6 FROM customer_unit t0 WHERE t0.id = '019ff1a5-3d5f-7e9e-969b-15fc8d309a5e';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.legal_name AS legal_name_3,
  t0.tax_id AS tax_id_4,
  t0.archived_at AS archived_at_5
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.legal_name AS legal_name_3, t0.tax_id AS tax_id_4, t0.archived_at AS archived_at_5 FROM customer t0 WHERE t0.id = '019ff1a5-3d5f-7e8e-969b-15fc8c914f37';

SELECT
  c0_.id AS id_0,
  c0_.service_date AS service_date_1,
  c0_.status AS status_2,
  c0_.exact_weight AS exact_weight_3,
  c0_.billable_weight AS billable_weight_4,
  c0_.calculated_billable_weight AS calculated_billable_weight_5,
  c0_.billable_weight_override AS billable_weight_override_6,
  c0_.transport_price_per_trip AS transport_price_per_trip_7,
  c0_.trip_count AS trip_count_8,
  c0_.price_per_kg AS price_per_kg_9,
  c0_.laundry_amount AS laundry_amount_10,
  c0_.additional_amount AS additional_amount_11,
  c0_.transport_amount AS transport_amount_12,
  c0_.total_amount AS total_amount_13,
  c0_.calculated_at AS calculated_at_14,
  c0_.created_at AS created_at_15,
  c0_.updated_at AS updated_at_16,
  c0_.version AS version_17,
  c0_.customer_unit_id AS customer_unit_id_18,
  c0_.tariff_id AS tariff_id_19,
  c0_.created_by_id AS created_by_id_20
FROM
  customer_order c0_
WHERE
  (
    c0_.status <> (?)
    OR c0_.status IS NULL
  )
  AND c0_.id IN (?, ?, ?)
ORDER BY
  c0_.service_date DESC,
  c0_.created_at DESC

SELECT c0_.id AS id_0, c0_.service_date AS service_date_1, c0_.status AS status_2, c0_.exact_weight AS exact_weight_3, c0_.billable_weight AS billable_weight_4, c0_.calculated_billable_weight AS calculated_billable_weight_5, c0_.billable_weight_override AS billable_weight_override_6, c0_.transport_price_per_trip AS transport_price_per_trip_7, c0_.trip_count AS trip_count_8, c0_.price_per_kg AS price_per_kg_9, c0_.laundry_amount AS laundry_amount_10, c0_.additional_amount AS additional_amount_11, c0_.transport_amount AS transport_amount_12, c0_.total_amount AS total_amount_13, c0_.calculated_at AS calculated_at_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.version AS version_17, c0_.customer_unit_id AS customer_unit_id_18, c0_.tariff_id AS tariff_id_19, c0_.created_by_id AS created_by_id_20 FROM customer_order c0_ WHERE (c0_.status <> ('cancelled') OR c0_.status IS NULL) AND c0_.id IN ('019ff512-3812-732e-bfe7-68f3f5f0d518', '019ff50d-5748-7046-aa6f-46230ca3def0', '019ff220-5000-7bbe-b1a6-2920bc4d5864') ORDER BY c0_.service_date DESC, c0_.created_at DESC;

SELECT
  count(*) AS sclr_0
FROM
  customer_order c0_
WHERE
  c0_.status <> (?)
  OR c0_.status IS NULL

SELECT count(*) AS sclr_0 FROM customer_order c0_ WHERE c0_.status <> ('cancelled') OR c0_.status IS NULL;