Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.platform_id AS platform_id_1,
  c0_.company_id AS company_id_2,
  c0_.car_route_id AS car_route_id_3,
  c0_.car_route_point_id AS car_route_point_id_4,
  c0_.reference AS reference_5,
  c0_.company_name AS company_name_6,
  c0_.country_id AS country_id_7,
  c0_.address AS address_8,
  c0_.lat AS lat_9,
  c0_.lng AS lng_10,
  c0_.distance_value AS distance_value_11,
  c0_.distance_text AS distance_text_12,
  c0_.duration_value AS duration_value_13,
  c0_.duration_text AS duration_text_14,
  c0_.duration_speed_used_text AS duration_speed_used_text_15,
  c0_.destination_car_route_point_details_id AS destination_car_route_point_details_id_16,
  c0_.arrival_date AS arrival_date_17,
  c0_.departure_date AS departure_date_18,
  c0_.waiting_time AS waiting_time_19,
  c0_.waiting_time_code AS waiting_time_code_20,
  c0_.authorization_code AS authorization_code_21,
  c0_.ferry_arrival_datetime AS ferry_arrival_datetime_22,
  c0_.ferry_departure_datetime AS ferry_departure_datetime_23,
  c0_.unload_date_start AS unload_date_start_24,
  c0_.unload_date_end AS unload_date_end_25,
  c0_.loading_date_start AS loading_date_start_26,
  c0_.loading_date_end AS loading_date_end_27,
  c0_.release_number AS release_number_28,
  c0_.completed AS completed_29,
  c0_.is_deleted AS is_deleted_30,
  c1_.name AS name_31,
  c1_.has_authorization_code AS has_authorization_code_32,
  c1_.has_ferry_arrival_datetime AS has_ferry_arrival_datetime_33,
  c1_.has_ferry_departure_datetime AS has_ferry_departure_datetime_34,
  c1_.has_unload_date AS has_unload_date_35,
  c1_.has_loading_date AS has_loading_date_36,
  c1_.has_reference AS has_reference_37,
  c1_.has_release_number AS has_release_number_38,
  c2_.nicename AS nicename_39
FROM
  car_route_point_details c0_
  LEFT JOIN car_route_point c1_ ON (c0_.car_route_point_id = c1_.id)
  LEFT JOIN country c2_ ON (c0_.country_id = c2_.id)
WHERE
  c0_.car_route_id = ?
  AND c0_.company_id = ?
  AND c0_.is_deleted = ?
  AND c1_.company_id = ?
ORDER BY
  c0_.position ASC,
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.platform_id AS platform_id_1, c0_.company_id AS company_id_2, c0_.car_route_id AS car_route_id_3, c0_.car_route_point_id AS car_route_point_id_4, c0_.reference AS reference_5, c0_.company_name AS company_name_6, c0_.country_id AS country_id_7, c0_.address AS address_8, c0_.lat AS lat_9, c0_.lng AS lng_10, c0_.distance_value AS distance_value_11, c0_.distance_text AS distance_text_12, c0_.duration_value AS duration_value_13, c0_.duration_text AS duration_text_14, c0_.duration_speed_used_text AS duration_speed_used_text_15, c0_.destination_car_route_point_details_id AS destination_car_route_point_details_id_16, c0_.arrival_date AS arrival_date_17, c0_.departure_date AS departure_date_18, c0_.waiting_time AS waiting_time_19, c0_.waiting_time_code AS waiting_time_code_20, c0_.authorization_code AS authorization_code_21, c0_.ferry_arrival_datetime AS ferry_arrival_datetime_22, c0_.ferry_departure_datetime AS ferry_departure_datetime_23, c0_.unload_date_start AS unload_date_start_24, c0_.unload_date_end AS unload_date_end_25, c0_.loading_date_start AS loading_date_start_26, c0_.loading_date_end AS loading_date_end_27, c0_.release_number AS release_number_28, c0_.completed AS completed_29, c0_.is_deleted AS is_deleted_30, c1_.name AS name_31, c1_.has_authorization_code AS has_authorization_code_32, c1_.has_ferry_arrival_datetime AS has_ferry_arrival_datetime_33, c1_.has_ferry_departure_datetime AS has_ferry_departure_datetime_34, c1_.has_unload_date AS has_unload_date_35, c1_.has_loading_date AS has_loading_date_36, c1_.has_reference AS has_reference_37, c1_.has_release_number AS has_release_number_38, c2_.nicename AS nicename_39 FROM car_route_point_details c0_ LEFT JOIN car_route_point c1_ ON (c0_.car_route_point_id = c1_.id) LEFT JOIN country c2_ ON (c0_.country_id = c2_.id) WHERE c0_.car_route_id = 1201 AND c0_.company_id = 1 AND c0_.is_deleted = 0 AND c1_.company_id = 1 ORDER BY c0_.position ASC, c0_.id ASC;

SELECT
  c0_.id AS id_0,
  c0_.platform_id AS platform_id_1,
  c0_.company_id AS company_id_2,
  c0_.job_number AS job_number_3,
  c0_.client_id AS client_id_4,
  c0_.car_id AS car_id_5,
  c0_.trailer_number AS trailer_number_6,
  c0_.indicative AS indicative_7,
  c0_.route_date AS route_date_8,
  c0_.distance_value AS distance_value_9,
  c0_.payment AS payment_10,
  c0_.is_completed AS is_completed_11,
  c0_.is_deleted AS is_deleted_12,
  c1_.name AS name_13,
  c2_.registration_number AS registration_number_14,
  c2_.indicative AS indicative_15
FROM
  car_route c0_
  LEFT JOIN client c1_ ON (c0_.client_id = c1_.id)
  LEFT JOIN car_details c2_ ON (c0_.car_id = c2_.id)
WHERE
  c0_.company_id = ?
  AND c1_.company_id = ?
  AND c2_.company_id = ?
  AND (
    c0_.route_date BETWEEN ?
    AND ?
  )
  AND c0_.is_completed = ?
ORDER BY
  c0_.is_deleted ASC,
  c0_.id DESC
LIMIT
  12

SELECT c0_.id AS id_0, c0_.platform_id AS platform_id_1, c0_.company_id AS company_id_2, c0_.job_number AS job_number_3, c0_.client_id AS client_id_4, c0_.car_id AS car_id_5, c0_.trailer_number AS trailer_number_6, c0_.indicative AS indicative_7, c0_.route_date AS route_date_8, c0_.distance_value AS distance_value_9, c0_.payment AS payment_10, c0_.is_completed AS is_completed_11, c0_.is_deleted AS is_deleted_12, c1_.name AS name_13, c2_.registration_number AS registration_number_14, c2_.indicative AS indicative_15 FROM car_route c0_ LEFT JOIN client c1_ ON (c0_.client_id = c1_.id) LEFT JOIN car_details c2_ ON (c0_.car_id = c2_.id) WHERE c0_.company_id = 1 AND c1_.company_id = 1 AND c2_.company_id = 1 AND (c0_.route_date BETWEEN '2026-03-01 00:00:00' AND '2026-03-31 23:59:59') AND c0_.is_completed = 0 ORDER BY c0_.is_deleted ASC, c0_.id DESC LIMIT 12;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  car_route c0_
WHERE
  c0_.company_id = ?
  AND (
    c0_.route_date BETWEEN ?
    AND ?
  )
  AND c0_.is_completed = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM car_route c0_ WHERE c0_.company_id = 1 AND (c0_.route_date BETWEEN '2026-03-01 00:00:00' AND '2026-03-31 23:59:59') AND c0_.is_completed = 0;