Symfony Profiler

SELECT
  o0_.id AS id_0,
  o0_.order_id AS order_id_1,
  o0_.date AS date_2,
  o0_.start_time AS start_time_3,
  o0_.end_time AS end_time_4,
  o0_.estimated_delivery_time AS estimated_delivery_time_5,
  o0_.delivery_order AS delivery_order_6,
  o0_.state AS state_7,
  o0_.created_at AS created_at_8,
  o0_.updated_at AS updated_at_9,
  o0_.route_id AS route_id_10,
  o0_.shipping_address_id AS shipping_address_id_11,
  o0_.created_by_id AS created_by_id_12,
  o0_.updated_by_id AS updated_by_id_13
FROM
  order_shipping o0_
WHERE
  o0_.date = ?
  AND o0_.state NOT IN (?)
ORDER BY
  o0_.route_id ASC,
  o0_.delivery_order ASC

SELECT o0_.id AS id_0, o0_.order_id AS order_id_1, o0_.date AS date_2, o0_.start_time AS start_time_3, o0_.end_time AS end_time_4, o0_.estimated_delivery_time AS estimated_delivery_time_5, o0_.delivery_order AS delivery_order_6, o0_.state AS state_7, o0_.created_at AS created_at_8, o0_.updated_at AS updated_at_9, o0_.route_id AS route_id_10, o0_.shipping_address_id AS shipping_address_id_11, o0_.created_by_id AS created_by_id_12, o0_.updated_by_id AS updated_by_id_13 FROM order_shipping o0_ WHERE o0_.date = '2025-12-27 00:00:00' AND o0_.state NOT IN ('state.cancelled') ORDER BY o0_.route_id ASC, o0_.delivery_order ASC;

SELECT
  t0.id AS id_1,
  t0.place AS place_2,
  t0.area AS area_3,
  t0.postal_code AS postal_code_4,
  t0.city AS city_5,
  t0.apartment AS apartment_6,
  t0.phoneNumberA AS phoneNumberA_7,
  t0.phoneNumberB AS phoneNumberB_8,
  t0.isActive AS isActive_9,
  t0.notes AS notes_10,
  ST_AsBinary(t0.location) AS location_11,
  t0.formatted_address AS formatted_address_12,
  t0.customer_id AS customer_id_13
FROM
  street_address t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.place AS place_2, t0.area AS area_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.apartment AS apartment_6, t0.phoneNumberA AS phoneNumberA_7, t0.phoneNumberB AS phoneNumberB_8, t0.isActive AS isActive_9, t0.notes AS notes_10, ST_AsBinary(t0.location) AS location_11, t0.formatted_address AS formatted_address_12, t0.customer_id AS customer_id_13 FROM street_address t0 WHERE t0.id = 52733 LIMIT 1;

SELECT
  v0_.id AS id_0,
  v0_.date AS date_1,
  v0_.repeatable AS repeatable_2,
  v0_.day AS day_3,
  v0_.type AS type_4,
  v0_.start AS start_5,
  v0_.end AS end_6,
  ST_AsBinary(v0_.start_location) AS start_location_7,
  ST_AsBinary(v0_.end_location) AS end_location_8,
  v0_.vehicle_id AS vehicle_id_9
FROM
  vehicle_work_schedule v0_
WHERE
  (
    v0_.day = ?
    AND v0_.repeatable = 1
  )
  OR (v0_.date = ?)
ORDER BY
  v0_.vehicle_id ASC,
  v0_.start ASC

SELECT v0_.id AS id_0, v0_.date AS date_1, v0_.repeatable AS repeatable_2, v0_.day AS day_3, v0_.type AS type_4, v0_.start AS start_5, v0_.end AS end_6, ST_AsBinary(v0_.start_location) AS start_location_7, ST_AsBinary(v0_.end_location) AS end_location_8, v0_.vehicle_id AS vehicle_id_9 FROM vehicle_work_schedule v0_ WHERE (v0_.day = 6 AND v0_.repeatable = 1) OR (v0_.date = '2025-12-27 00:00:00') ORDER BY v0_.vehicle_id ASC, v0_.start ASC;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.coordinates AS coordinates_2,
  d0_.center AS center_3,
  d0_.waiting_time AS waiting_time_4,
  ST_AsBinary(d0_.polygon) AS polygon_5,
  d0_.is_active AS is_active_6,
  d0_.is_for_wholesaler AS is_for_wholesaler_7,
  d0_.shipping_cost_product_id AS shipping_cost_product_id_8
FROM
  deliveryZones d0_
WHERE
  ST_Contains(
    d0_.polygon,
    ST_GeomFromText(
      'POINT(-58.4043495 -34.612345)'
    )
  ) = 1
  AND d0_.is_active = 1
  AND d0_.is_for_wholesaler = 0

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.coordinates AS coordinates_2, d0_.center AS center_3, d0_.waiting_time AS waiting_time_4, ST_AsBinary(d0_.polygon) AS polygon_5, d0_.is_active AS is_active_6, d0_.is_for_wholesaler AS is_for_wholesaler_7, d0_.shipping_cost_product_id AS shipping_cost_product_id_8 FROM deliveryZones d0_ WHERE ST_Contains(d0_.polygon, ST_GeomFromText('POINT(-58.4043495 -34.612345)')) = 1 AND d0_.is_active = 1 AND d0_.is_for_wholesaler = 0;

SELECT
  h0_.id AS id_0,
  h0_.name AS name_1,
  h0_.date AS date_2,
  h0_.delivery AS delivery_3,
  h0_.created_at AS created_at_4,
  h0_.updated_at AS updated_at_5,
  h0_.created_by_id AS created_by_id_6,
  h0_.updated_by_id AS updated_by_id_7
FROM
  holiday h0_
WHERE
  h0_.date = ?
  AND h0_.delivery = ?

SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.date AS date_2, h0_.delivery AS delivery_3, h0_.created_at AS created_at_4, h0_.updated_at AS updated_at_5, h0_.created_by_id AS created_by_id_6, h0_.updated_by_id AS updated_by_id_7 FROM holiday h0_ WHERE h0_.date = '2025-12-27' AND h0_.delivery = 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.make_and_model AS make_and_model_3,
  t0.license AS license_4,
  t0.capacity AS capacity_5,
  t0.idUser AS idUser_6,
  t0.idUserCompanion AS idUserCompanion_7
FROM
  vehicle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.make_and_model AS make_and_model_3, t0.license AS license_4, t0.capacity AS capacity_5, t0.idUser AS idUser_6, t0.idUserCompanion AS idUserCompanion_7 FROM vehicle t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.created_by_id AS created_by_id_5,
  t0.updated_by_id AS updated_by_id_6
FROM
  vehicle_feature t0
  INNER JOIN vehicle_vehicle_feature ON t0.id = vehicle_vehicle_feature.vehicle_feature_id
WHERE
  vehicle_vehicle_feature.vehicle_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6 FROM vehicle_feature t0 INNER JOIN vehicle_vehicle_feature ON t0.id = vehicle_vehicle_feature.vehicle_feature_id WHERE vehicle_vehicle_feature.vehicle_id = 2;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.presentation AS presentation_5,
  t0.is_wholesaler AS is_wholesaler_6,
  t0.publicSale AS publicSale_7,
  t0.active AS active_8,
  t0.isDeleted AS isDeleted_9,
  t0.recommended AS recommended_10,
  t0.tax AS tax_11,
  t0.base_price AS base_price_12,
  t0.price AS price_13,
  t0.thumbnail AS thumbnail_14,
  t0.image AS image_15,
  t0.idCategory AS idCategory_16,
  t0.idSize AS idSize_17,
  t0.unit_of_measurement_id AS unit_of_measurement_id_18
FROM
  product t0
WHERE
  t0.id IN (?)

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.description AS description_4, t0.presentation AS presentation_5, t0.is_wholesaler AS is_wholesaler_6, t0.publicSale AS publicSale_7, t0.active AS active_8, t0.isDeleted AS isDeleted_9, t0.recommended AS recommended_10, t0.tax AS tax_11, t0.base_price AS base_price_12, t0.price AS price_13, t0.thumbnail AS thumbnail_14, t0.image AS image_15, t0.idCategory AS idCategory_16, t0.idSize AS idSize_17, t0.unit_of_measurement_id AS unit_of_measurement_id_18 FROM product t0 WHERE t0.id IN (856);