Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.subdomain AS subdomain_3,
  t0.name AS name_4,
  t0.contact_email AS contact_email_5,
  t0.contact_phone AS contact_phone_6,
  t0.plan AS plan_7,
  t0.status AS status_8,
  t0.locale AS locale_9,
  t0.currency AS currency_10,
  t0.timezone AS timezone_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13
FROM
  tenant t0
WHERE
  t0.subdomain = ?
  AND t0.status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.subdomain AS subdomain_3, t0.name AS name_4, t0.contact_email AS contact_email_5, t0.contact_phone AS contact_phone_6, t0.plan AS plan_7, t0.status AS status_8, t0.locale AS locale_9, t0.currency AS currency_10, t0.timezone AS timezone_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM tenant t0 WHERE t0.subdomain = 'demo-sarl' AND t0.status = 'active' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.phone AS phone_5,
  t0.password AS password_6,
  t0.roles AS roles_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.last_login_at AS last_login_at_10,
  t0.tenant_id AS tenant_id_11,
  t0.agency_id AS agency_id_12
FROM
  "user" t0
WHERE
  t0.id = ?
  AND (
    (
      t0.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d'
    )
  )

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.phone AS phone_5, t0.password AS password_6, t0.roles AS roles_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.last_login_at AS last_login_at_10, t0.tenant_id AS tenant_id_11, t0.agency_id AS agency_id_12 FROM "user" t0 WHERE t0.id = '019e462d-af1d-7f3b-a24b-983c3b12d1e6' AND ((t0.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d'));

SELECT
  p0_.id AS id_0,
  p0_.contact_name AS contact_name_1,
  p0_.phone AS phone_2,
  p0_.email AS email_3,
  p0_.address AS address_4,
  p0_.city AS city_5,
  p0_.country_code AS country_code_6,
  p0_.latitude AS latitude_7,
  p0_.longitude AS longitude_8,
  p0_.scheduled_at AS scheduled_at_9,
  p0_.time_slot AS time_slot_10,
  p0_.proposed_time_slots AS proposed_time_slots_11,
  p0_.status AS status_12,
  p0_.estimated_weight_kg AS estimated_weight_kg_13,
  p0_.packages_count AS packages_count_14,
  p0_.description AS description_15,
  p0_.notes AS notes_16,
  p0_.picked_up_at AS picked_up_at_17,
  p0_.signature_base64 AS signature_base64_18,
  p0_.created_at AS created_at_19,
  p0_.updated_at AS updated_at_20,
  p0_.tenant_id AS tenant_id_21,
  p0_.customer_id AS customer_id_22,
  p0_.collector_id AS collector_id_23,
  p0_.agency_id AS agency_id_24,
  p0_.parcel_id AS parcel_id_25
FROM
  pickup_request p0_
WHERE
  (
    p0_.scheduled_at BETWEEN ?
    AND ?
  )
  AND (
    p0_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d'
  )
ORDER BY
  p0_.scheduled_at ASC

SELECT p0_.id AS id_0, p0_.contact_name AS contact_name_1, p0_.phone AS phone_2, p0_.email AS email_3, p0_.address AS address_4, p0_.city AS city_5, p0_.country_code AS country_code_6, p0_.latitude AS latitude_7, p0_.longitude AS longitude_8, p0_.scheduled_at AS scheduled_at_9, p0_.time_slot AS time_slot_10, p0_.proposed_time_slots AS proposed_time_slots_11, p0_.status AS status_12, p0_.estimated_weight_kg AS estimated_weight_kg_13, p0_.packages_count AS packages_count_14, p0_.description AS description_15, p0_.notes AS notes_16, p0_.picked_up_at AS picked_up_at_17, p0_.signature_base64 AS signature_base64_18, p0_.created_at AS created_at_19, p0_.updated_at AS updated_at_20, p0_.tenant_id AS tenant_id_21, p0_.customer_id AS customer_id_22, p0_.collector_id AS collector_id_23, p0_.agency_id AS agency_id_24, p0_.parcel_id AS parcel_id_25 FROM pickup_request p0_ WHERE (p0_.scheduled_at BETWEEN '2026-04-26 00:00:00' AND '2026-06-07 00:00:00') AND (p0_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d') ORDER BY p0_.scheduled_at ASC;

SELECT
  p0_.id AS id_0,
  p0_.tracking_code AS tracking_code_1,
  p0_.reference AS reference_2,
  p0_.status AS status_3,
  p0_.weight_kg AS weight_kg_4,
  p0_.declared_value AS declared_value_5,
  p0_.description AS description_6,
  p0_.packages_count AS packages_count_7,
  p0_.price_total AS price_total_8,
  p0_.currency AS currency_9,
  p0_.payment_status AS payment_status_10,
  p0_.delivery_signature_base64 AS delivery_signature_base64_11,
  p0_.scheduled_delivery_at AS scheduled_delivery_at_12,
  p0_.sender_confirm_otp AS sender_confirm_otp_13,
  p0_.sender_confirmed_at AS sender_confirmed_at_14,
  p0_.recipient_confirm_otp AS recipient_confirm_otp_15,
  p0_.recipient_confirmed_at AS recipient_confirmed_at_16,
  p0_.pickup_notes AS pickup_notes_17,
  p0_.delivery_notes AS delivery_notes_18,
  p0_.picked_up_at AS picked_up_at_19,
  p0_.delivered_at AS delivered_at_20,
  p0_.received_confirmed_at AS received_confirmed_at_21,
  p0_.received_confirmed_by AS received_confirmed_by_22,
  p0_.created_at AS created_at_23,
  p0_.updated_at AS updated_at_24,
  a1_.id AS id_25,
  a1_.type AS type_26,
  a1_.contact_name AS contact_name_27,
  a1_.phone AS phone_28,
  a1_.line1 AS line1_29,
  a1_.line2 AS line2_30,
  a1_.city AS city_31,
  a1_.postal_code AS postal_code_32,
  a1_.country_code AS country_code_33,
  a1_.latitude AS latitude_34,
  a1_.longitude AS longitude_35,
  a1_.notes AS notes_36,
  t2_.id AS id_37,
  t2_.email AS email_38,
  t2_.first_name AS first_name_39,
  t2_.last_name AS last_name_40,
  t2_.phone AS phone_41,
  t2_.password AS password_42,
  t2_.roles AS roles_43,
  t2_.is_active AS is_active_44,
  t2_.created_at AS created_at_45,
  t2_.last_login_at AS last_login_at_46,
  p0_.tenant_id AS tenant_id_47,
  p0_.sender_id AS sender_id_48,
  p0_.recipient_id AS recipient_id_49,
  p0_.container_id AS container_id_50,
  p0_.driver_id AS driver_id_51,
  p0_.current_agency_id AS current_agency_id_52,
  a1_.tenant_id AS tenant_id_53,
  t2_.tenant_id AS tenant_id_54,
  t2_.agency_id AS agency_id_55
FROM
  parcel p0_
  LEFT JOIN address a1_ ON p0_.recipient_id = a1_.id
  AND (
    a1_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d'
  )
  LEFT JOIN "user" t2_ ON p0_.driver_id = t2_.id
  AND (
    t2_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d'
  )
WHERE
  (
    (
      p0_.scheduled_delivery_at BETWEEN ?
      AND ?
    )
    OR (
      p0_.delivered_at BETWEEN ?
      AND ?
    )
  )
  AND (
    p0_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d'
  )

SELECT p0_.id AS id_0, p0_.tracking_code AS tracking_code_1, p0_.reference AS reference_2, p0_.status AS status_3, p0_.weight_kg AS weight_kg_4, p0_.declared_value AS declared_value_5, p0_.description AS description_6, p0_.packages_count AS packages_count_7, p0_.price_total AS price_total_8, p0_.currency AS currency_9, p0_.payment_status AS payment_status_10, p0_.delivery_signature_base64 AS delivery_signature_base64_11, p0_.scheduled_delivery_at AS scheduled_delivery_at_12, p0_.sender_confirm_otp AS sender_confirm_otp_13, p0_.sender_confirmed_at AS sender_confirmed_at_14, p0_.recipient_confirm_otp AS recipient_confirm_otp_15, p0_.recipient_confirmed_at AS recipient_confirmed_at_16, p0_.pickup_notes AS pickup_notes_17, p0_.delivery_notes AS delivery_notes_18, p0_.picked_up_at AS picked_up_at_19, p0_.delivered_at AS delivered_at_20, p0_.received_confirmed_at AS received_confirmed_at_21, p0_.received_confirmed_by AS received_confirmed_by_22, p0_.created_at AS created_at_23, p0_.updated_at AS updated_at_24, a1_.id AS id_25, a1_.type AS type_26, a1_.contact_name AS contact_name_27, a1_.phone AS phone_28, a1_.line1 AS line1_29, a1_.line2 AS line2_30, a1_.city AS city_31, a1_.postal_code AS postal_code_32, a1_.country_code AS country_code_33, a1_.latitude AS latitude_34, a1_.longitude AS longitude_35, a1_.notes AS notes_36, t2_.id AS id_37, t2_.email AS email_38, t2_.first_name AS first_name_39, t2_.last_name AS last_name_40, t2_.phone AS phone_41, t2_.password AS password_42, t2_.roles AS roles_43, t2_.is_active AS is_active_44, t2_.created_at AS created_at_45, t2_.last_login_at AS last_login_at_46, p0_.tenant_id AS tenant_id_47, p0_.sender_id AS sender_id_48, p0_.recipient_id AS recipient_id_49, p0_.container_id AS container_id_50, p0_.driver_id AS driver_id_51, p0_.current_agency_id AS current_agency_id_52, a1_.tenant_id AS tenant_id_53, t2_.tenant_id AS tenant_id_54, t2_.agency_id AS agency_id_55 FROM parcel p0_ LEFT JOIN address a1_ ON p0_.recipient_id = a1_.id AND (a1_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d') LEFT JOIN "user" t2_ ON p0_.driver_id = t2_.id AND (t2_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d') WHERE ((p0_.scheduled_delivery_at BETWEEN '2026-04-26 00:00:00' AND '2026-06-07 00:00:00') OR (p0_.delivered_at BETWEEN '2026-04-26 00:00:00' AND '2026-06-07 00:00:00')) AND (p0_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d');

SELECT
  c0_.id AS id_0,
  c0_.reference AS reference_1,
  c0_.seal_number AS seal_number_2,
  c0_.status AS status_3,
  c0_.warehouse_received_at AS warehouse_received_at_4,
  c0_.sealed_at AS sealed_at_5,
  c0_.scheduled_departure_at AS scheduled_departure_at_6,
  c0_.departed_warehouse_at AS departed_warehouse_at_7,
  c0_.at_origin_port_at AS at_origin_port_at_8,
  c0_.loaded_on_ship_at AS loaded_on_ship_at_9,
  c0_.shipped_at AS shipped_at_10,
  c0_.estimated_arrival_at AS estimated_arrival_at_11,
  c0_.at_destination_port_at AS at_destination_port_at_12,
  c0_.customs_started_at AS customs_started_at_13,
  c0_.customs_cleared_at AS customs_cleared_at_14,
  c0_.at_final_warehouse_at AS at_final_warehouse_at_15,
  c0_.arrived_at AS arrived_at_16,
  c0_.ship_name AS ship_name_17,
  c0_.voyage_number AS voyage_number_18,
  c0_.ship_imo AS ship_imo_19,
  c0_.ship_tracking_url AS ship_tracking_url_20,
  c0_.forwarder_name AS forwarder_name_21,
  c0_.notes AS notes_22,
  c0_.created_at AS created_at_23,
  a1_.id AS id_24,
  a1_.code AS code_25,
  a1_.name AS name_26,
  a1_.type AS type_27,
  a1_.address AS address_28,
  a1_.city AS city_29,
  a1_.country_code AS country_code_30,
  a1_.phone AS phone_31,
  a1_.latitude AS latitude_32,
  a1_.longitude AS longitude_33,
  a1_.is_active AS is_active_34,
  a2_.id AS id_35,
  a2_.code AS code_36,
  a2_.name AS name_37,
  a2_.type AS type_38,
  a2_.address AS address_39,
  a2_.city AS city_40,
  a2_.country_code AS country_code_41,
  a2_.phone AS phone_42,
  a2_.latitude AS latitude_43,
  a2_.longitude AS longitude_44,
  a2_.is_active AS is_active_45,
  c0_.tenant_id AS tenant_id_46,
  c0_.origin_agency_id AS origin_agency_id_47,
  c0_.destination_agency_id AS destination_agency_id_48,
  a1_.tenant_id AS tenant_id_49,
  a2_.tenant_id AS tenant_id_50
FROM
  container c0_
  LEFT JOIN agency a1_ ON c0_.origin_agency_id = a1_.id
  AND (
    a1_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d'
  )
  LEFT JOIN agency a2_ ON c0_.destination_agency_id = a2_.id
  AND (
    a2_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d'
  )
WHERE
  (
    (
      c0_.scheduled_departure_at BETWEEN ?
      AND ?
    )
    OR (
      c0_.estimated_arrival_at BETWEEN ?
      AND ?
    )
  )
  AND (
    c0_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d'
  )

SELECT c0_.id AS id_0, c0_.reference AS reference_1, c0_.seal_number AS seal_number_2, c0_.status AS status_3, c0_.warehouse_received_at AS warehouse_received_at_4, c0_.sealed_at AS sealed_at_5, c0_.scheduled_departure_at AS scheduled_departure_at_6, c0_.departed_warehouse_at AS departed_warehouse_at_7, c0_.at_origin_port_at AS at_origin_port_at_8, c0_.loaded_on_ship_at AS loaded_on_ship_at_9, c0_.shipped_at AS shipped_at_10, c0_.estimated_arrival_at AS estimated_arrival_at_11, c0_.at_destination_port_at AS at_destination_port_at_12, c0_.customs_started_at AS customs_started_at_13, c0_.customs_cleared_at AS customs_cleared_at_14, c0_.at_final_warehouse_at AS at_final_warehouse_at_15, c0_.arrived_at AS arrived_at_16, c0_.ship_name AS ship_name_17, c0_.voyage_number AS voyage_number_18, c0_.ship_imo AS ship_imo_19, c0_.ship_tracking_url AS ship_tracking_url_20, c0_.forwarder_name AS forwarder_name_21, c0_.notes AS notes_22, c0_.created_at AS created_at_23, a1_.id AS id_24, a1_.code AS code_25, a1_.name AS name_26, a1_.type AS type_27, a1_.address AS address_28, a1_.city AS city_29, a1_.country_code AS country_code_30, a1_.phone AS phone_31, a1_.latitude AS latitude_32, a1_.longitude AS longitude_33, a1_.is_active AS is_active_34, a2_.id AS id_35, a2_.code AS code_36, a2_.name AS name_37, a2_.type AS type_38, a2_.address AS address_39, a2_.city AS city_40, a2_.country_code AS country_code_41, a2_.phone AS phone_42, a2_.latitude AS latitude_43, a2_.longitude AS longitude_44, a2_.is_active AS is_active_45, c0_.tenant_id AS tenant_id_46, c0_.origin_agency_id AS origin_agency_id_47, c0_.destination_agency_id AS destination_agency_id_48, a1_.tenant_id AS tenant_id_49, a2_.tenant_id AS tenant_id_50 FROM container c0_ LEFT JOIN agency a1_ ON c0_.origin_agency_id = a1_.id AND (a1_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d') LEFT JOIN agency a2_ ON c0_.destination_agency_id = a2_.id AND (a2_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d') WHERE ((c0_.scheduled_departure_at BETWEEN '2026-04-26 00:00:00' AND '2026-06-07 00:00:00') OR (c0_.estimated_arrival_at BETWEEN '2026-04-26 00:00:00' AND '2026-06-07 00:00:00')) AND (c0_.tenant_id = '019e45e3-02d6-7f20-97d1-f3cc4c15028d');