https://sys.nenocourier.co.ke/api/deliveries/35

Query Metrics

130 Database Queries
4 Different statements
108.60 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 1.60 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.created_at AS created_at_4, t0.roles AS roles_5, t0.email AS email_6, t0.is_active AS is_active_7, t0.person_id AS person_id_8 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  57
]
2 3.52 ms
SELECT d0_.id AS id_0, d0_.is_received_fully AS is_received_fully_1, d0_.parcel_count AS parcel_count_2, s1_.id AS id_3, s2_.id AS id_4, d0_.is_cancelled AS is_cancelled_5, d0_.is_received AS is_received_6, d0_.is_loaded AS is_loaded_7, u3_.id AS id_8 FROM delivery d0_ INNER JOIN station s1_ ON d0_.destination = s1_.id INNER JOIN station s2_ ON d0_.origin_station = s2_.id INNER JOIN user u3_ ON d0_.created_by = u3_.id WHERE s2_.id = ? AND d0_.is_cancelled = 0 AND d0_.is_verified = 0
Parameters:
[
  "35"
]
3 3.00 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81311
]
4 2.38 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81311
]
5 3.02 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81380
]
6 1.87 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81380
]
7 1.81 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81494
]
8 1.47 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81494
]
9 2.05 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81528
]
10 2.23 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81528
]
11 1.65 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81529
]
12 0.72 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81529
]
13 1.99 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81607
]
14 1.48 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81607
]
15 0.77 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81625
]
16 0.50 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81625
]
17 0.68 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81626
]
18 0.53 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81626
]
19 1.92 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81629
]
20 0.83 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81629
]
21 1.36 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81631
]
22 1.12 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81631
]
23 0.84 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81633
]
24 0.64 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81633
]
25 0.62 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81634
]
26 0.67 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81634
]
27 0.86 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81635
]
28 0.47 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81635
]
29 1.29 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81673
]
30 0.64 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81673
]
31 1.11 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81674
]
32 0.76 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81674
]
33 0.69 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81675
]
34 0.45 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81675
]
35 0.57 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81676
]
36 0.82 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81676
]
37 0.58 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81677
]
38 0.46 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81677
]
39 0.67 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81678
]
40 0.61 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81678
]
41 1.88 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81679
]
42 0.89 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81679
]
43 0.84 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81680
]
44 0.59 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81680
]
45 0.74 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81681
]
46 0.51 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81681
]
47 2.11 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81682
]
48 1.22 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81682
]
49 1.19 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81683
]
50 1.59 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81683
]
51 0.94 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81684
]
52 0.66 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81684
]
53 0.75 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81685
]
54 0.72 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81685
]
55 0.48 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81686
]
56 0.51 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81686
]
57 0.59 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81687
]
58 0.44 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81687
]
59 0.63 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81688
]
60 0.49 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81688
]
61 0.95 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81689
]
62 0.93 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81689
]
63 0.82 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81690
]
64 0.63 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81690
]
65 0.56 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81691
]
66 0.37 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81691
]
67 0.51 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81692
]
68 0.43 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81692
]
69 0.52 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81693
]
70 0.39 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81693
]
71 0.65 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81694
]
72 0.39 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81694
]
73 0.53 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81695
]
74 0.75 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81695
]
75 0.71 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81710
]
76 0.48 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81710
]
77 0.53 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81726
]
78 0.47 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81726
]
79 0.60 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81727
]
80 0.44 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81727
]
81 0.63 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81728
]
82 0.41 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81728
]
83 0.56 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81729
]
84 0.42 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81729
]
85 0.99 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81730
]
86 0.45 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81730
]
87 0.46 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81731
]
88 0.43 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81731
]
89 0.47 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81732
]
90 0.45 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81732
]
91 0.50 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81733
]
92 0.38 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81733
]
93 0.44 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81734
]
94 0.38 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81734
]
95 0.62 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81735
]
96 0.49 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81735
]
97 2.07 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81736
]
98 1.13 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81736
]
99 1.29 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81737
]
100 0.66 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81737
]
101 0.71 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81738
]
102 0.62 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81738
]
103 0.59 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81739
]
104 0.42 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81739
]
105 0.57 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81740
]
106 0.78 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81740
]
107 0.66 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81741
]
108 0.41 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81741
]
109 0.46 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81742
]
110 0.37 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81742
]
111 0.46 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81743
]
112 0.41 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81743
]
113 1.01 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81744
]
114 1.14 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81744
]
115 0.61 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81745
]
116 0.41 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81745
]
117 0.54 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81746
]
118 0.53 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81746
]
119 0.78 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81747
]
120 0.53 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81747
]
121 0.71 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81748
]
122 0.50 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81748
]
123 0.59 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81749
]
124 0.37 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81749
]
125 0.48 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81750
]
126 0.37 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81750
]
127 0.45 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81751
]
128 0.35 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81751
]
129 0.49 ms
SELECT d0_.id AS id_0, w1_.id AS id_1, s2_.station_name AS station_name_2, t3_.amount AS amount_3, d4_.id AS id_4, p5_.id AS id_5, d0_.is_cancelled AS is_cancelled_6, d0_.cancelled_because AS cancelled_because_7, p6_.first_name AS first_name_8, p5_.description AS description_9 FROM delivery_parcel d0_ INNER JOIN parcel p5_ ON d0_.parcel_id = p5_.id INNER JOIN way_bill w1_ ON p5_.way_bill_id = w1_.id INNER JOIN transaction t3_ ON w1_.id = t3_.way_bill_id INNER JOIN station s2_ ON w1_.to_station_id = s2_.id INNER JOIN delivery d4_ ON d0_.delivery_id = d4_.id INNER JOIN user u7_ ON d0_.created_by = u7_.id INNER JOIN person p6_ ON u7_.person_id = p6_.id WHERE d4_.id = ?
Parameters:
[
  81752
]
130 0.37 ms
SELECT d0_.id AS id_0, v1_.id AS id_1, v1_.reg_number AS reg_number_2, d2_.id AS id_3 FROM delivery_vehicle d0_ LEFT JOIN delivery d2_ ON d0_.delivery_id = d2_.id LEFT JOIN vehicle v1_ ON d0_.vehicle_id = v1_.id LEFT JOIN station s3_ ON d2_.origin_station = s3_.id WHERE d2_.id = ? AND d0_.is_cancelled = 0
Parameters:
[
  81752
]

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.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Person No errors.
App\Entity\Delivery
  • The field App\Entity\Delivery#deliveryVehicle is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\DeliveryVehicle#delivery does not contain the required 'inversedBy="deliveryVehicle"' attribute.
App\Entity\Station No errors.
App\Entity\DeliveryParcel No errors.
App\Entity\Parcel No errors.
App\Entity\WayBill
  • The field App\Entity\WayBill#collectedParcel is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CollectedParcel#waybill does not contain the required 'inversedBy="collectedParcel"' attribute.
App\Entity\Transaction No errors.
App\Entity\DeliveryVehicle No errors.
App\Entity\Vehicle No errors.