POST https://demo5.business-erp.ro/car-route/list

Response
200 OK
Browse referrer URL
IP
94.234.91.205
Profiled on
Token
3af0d7

Query Metrics

36 Database Queries
3 Different statements
36.25 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

#▲ Time Info
1 1.07 ms 
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 = ?
Parameters: 
[
  1
  "2026-03-01 00:00:00"
  "2026-03-31 23:59:59"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
2 1.38 ms 
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
Parameters: 
[
  1
  1
  1
  "2026-03-01 00:00:00"
  "2026-03-31 23:59:59"
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
3 1.34 ms 
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
Parameters: 
[
  1201
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
4 1.00 ms 
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
Parameters: 
[
  1199
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.93 ms 
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
Parameters: 
[
  1198
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
6 1.10 ms 
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
Parameters: 
[
  1197
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.03 ms 
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
Parameters: 
[
  1196
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.89 ms 
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
Parameters: 
[
  1195
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
9 0.89 ms 
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
Parameters: 
[
  1194
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.81 ms 
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
Parameters: 
[
  1193
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.99 ms 
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
Parameters: 
[
  1192
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.97 ms 
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
Parameters: 
[
  1191
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.96 ms 
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
Parameters: 
[
  1190
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
14 1.29 ms 
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
Parameters: 
[
  1189
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
15 1.11 ms 
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
Parameters: 
[
  1188
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
16 1.08 ms 
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
Parameters: 
[
  1187
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.84 ms 
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
Parameters: 
[
  1186
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
18 1.08 ms 
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
Parameters: 
[
  1185
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
19 1.02 ms 
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
Parameters: 
[
  1184
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.87 ms 
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
Parameters: 
[
  1183
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.83 ms 
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
Parameters: 
[
  1182
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
22 1.10 ms 
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
Parameters: 
[
  1181
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.89 ms 
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
Parameters: 
[
  1180
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.97 ms 
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
Parameters: 
[
  1179
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
25 1.17 ms 
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
Parameters: 
[
  1178
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.89 ms 
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
Parameters: 
[
  1177
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
27 1.17 ms 
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
Parameters: 
[
  1176
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.98 ms 
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
Parameters: 
[
  1169
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
29 0.85 ms 
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
Parameters: 
[
  1168
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
30 0.89 ms 
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
Parameters: 
[
  1167
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
31 0.90 ms 
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
Parameters: 
[
  1166
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
32 0.81 ms 
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
Parameters: 
[
  1165
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
33 0.82 ms 
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
Parameters: 
[
  1161
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
34 1.08 ms 
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
Parameters: 
[
  1160
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
35 1.04 ms 
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
Parameters: 
[
  1157
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace
36 1.19 ms 
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
Parameters: 
[
  1134
  1
  0
  1
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

Class Mapping errors
App\Entity\CarRoute No errors.
App\Entity\Client No errors.
App\Entity\CarDetails No errors.
App\Entity\CarRoutePointDetails No errors.
App\Entity\CarRoutePoint No errors.
App\Entity\Country No errors.