Symfony Profiler

SELECT
  COUNT(o0_.id) AS sclr_0
FROM
  order_product o0_
WHERE
  o0_.order_id = ?
  AND o0_.company_id = ?
  AND o0_.is_active = ?
LIMIT
  1

SELECT COUNT(o0_.id) AS sclr_0 FROM order_product o0_ WHERE o0_.order_id = 9570 AND o0_.company_id = 1 AND o0_.is_active = 1 LIMIT 1;

SELECT
  o0_.id AS id_0,
  o0_.platform_id AS platform_id_1,
  o0_.source_id AS source_id_2,
  o0_.type_id AS type_id_3,
  o0_.client_id AS client_id_4,
  o0_.client_work_point_id AS client_work_point_id_5,
  o0_.car_id AS car_id_6,
  o0_.driver_id AS driver_id_7,
  o0_.delivery_date AS delivery_date_8,
  o0_.production_day_id AS production_day_id_9,
  o0_.status_id AS status_id_10,
  o0_.payment_method_id AS payment_method_id_11,
  o0_.has_invoice AS has_invoice_12,
  o0_.invoice_series AS invoice_series_13,
  o0_.invoice_number AS invoice_number_14,
  o0_.has_storno_invoice AS has_storno_invoice_15,
  o0_.storno_invoice_number AS storno_invoice_number_16,
  o0_.storno_invoice_series AS storno_invoice_series_17,
  o0_.has_cargo_notice AS has_cargo_notice_18,
  o0_.cargo_notice_file AS cargo_notice_file_19,
  o0_.user_created AS user_created_20,
  o0_.date_created AS date_created_21,
  o0_.is_active AS is_active_22,
  c1_.name AS name_23,
  c1_.alias AS alias_24,
  c2_.name AS name_25,
  d3_.firstname AS firstname_26,
  d3_.lastname AS lastname_27,
  c4_.name AS name_28,
  c4_.color AS color_29,
  c5_.label AS label_30,
  c5_.collected AS collected_31,
  c5_.collected_not_vat AS collected_not_vat_32,
  p6_.date AS date_33
FROM
  `order` o0_
  LEFT JOIN client c1_ ON (o0_.client_id = c1_.id)
  LEFT JOIN client_work_point c2_ ON (
    o0_.client_work_point_id = c2_.id
  )
  LEFT JOIN driver d3_ ON (o0_.driver_id = d3_.id)
  LEFT JOIN config_payment_method c5_ ON (o0_.payment_method_id = c5_.id)
  LEFT JOIN config_order_status c4_ ON (o0_.status_id = c4_.id)
  LEFT JOIN production_day p6_ ON (o0_.production_day_id = p6_.id)
WHERE
  o0_.company_id = ?
  AND o0_.is_active = ?
  AND p6_.date = ?
  AND o0_.production_day_id = ?
  AND o0_.driver_id = ?
ORDER BY
  o0_.id DESC

SELECT o0_.id AS id_0, o0_.platform_id AS platform_id_1, o0_.source_id AS source_id_2, o0_.type_id AS type_id_3, o0_.client_id AS client_id_4, o0_.client_work_point_id AS client_work_point_id_5, o0_.car_id AS car_id_6, o0_.driver_id AS driver_id_7, o0_.delivery_date AS delivery_date_8, o0_.production_day_id AS production_day_id_9, o0_.status_id AS status_id_10, o0_.payment_method_id AS payment_method_id_11, o0_.has_invoice AS has_invoice_12, o0_.invoice_series AS invoice_series_13, o0_.invoice_number AS invoice_number_14, o0_.has_storno_invoice AS has_storno_invoice_15, o0_.storno_invoice_number AS storno_invoice_number_16, o0_.storno_invoice_series AS storno_invoice_series_17, o0_.has_cargo_notice AS has_cargo_notice_18, o0_.cargo_notice_file AS cargo_notice_file_19, o0_.user_created AS user_created_20, o0_.date_created AS date_created_21, o0_.is_active AS is_active_22, c1_.name AS name_23, c1_.alias AS alias_24, c2_.name AS name_25, d3_.firstname AS firstname_26, d3_.lastname AS lastname_27, c4_.name AS name_28, c4_.color AS color_29, c5_.label AS label_30, c5_.collected AS collected_31, c5_.collected_not_vat AS collected_not_vat_32, p6_.date AS date_33 FROM `order` o0_ LEFT JOIN client c1_ ON (o0_.client_id = c1_.id) LEFT JOIN client_work_point c2_ ON (o0_.client_work_point_id = c2_.id) LEFT JOIN driver d3_ ON (o0_.driver_id = d3_.id) LEFT JOIN config_payment_method c5_ ON (o0_.payment_method_id = c5_.id) LEFT JOIN config_order_status c4_ ON (o0_.status_id = c4_.id) LEFT JOIN production_day p6_ ON (o0_.production_day_id = p6_.id) WHERE o0_.company_id = 1 AND o0_.is_active = 1 AND p6_.date = '2025-12-06 00:00:00' AND o0_.production_day_id = 210 AND o0_.driver_id = 7 ORDER BY o0_.id DESC;

SELECT
  p0_.id AS id_0,
  p0_.is_active AS is_active_1
FROM
  production_day p0_
WHERE
  p0_.company_id = ?
  AND p0_.date = ?
  AND p0_.is_active = ?
LIMIT
  1

SELECT p0_.id AS id_0, p0_.is_active AS is_active_1 FROM production_day p0_ WHERE p0_.company_id = 1 AND p0_.date = '2025-12-06 00:00:00' AND p0_.is_active = 1 LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.platform_id AS platform_id_1,
  c0_.name AS name_2,
  c0_.color AS color_3,
  c0_.selectable AS selectable_4,
  c0_.is_active AS is_active_5
FROM
  config_order_status c0_
WHERE
  c0_.platform_id = ?
  AND c0_.is_active = ?

SELECT c0_.id AS id_0, c0_.platform_id AS platform_id_1, c0_.name AS name_2, c0_.color AS color_3, c0_.selectable AS selectable_4, c0_.is_active AS is_active_5 FROM config_order_status c0_ WHERE c0_.platform_id = 1 AND c0_.is_active = 1;