https://sys.nenocourier.co.ke/api/deliveries/load/65348/2193

Query Metrics

35 Database Queries
16 Different statements
91.42 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 3.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.person_id AS person_id_7 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  104
]
2 2.21 ms
SELECT t0.id AS id_1, t0.parcel_count AS parcel_count_2, t0.is_cancelled AS is_cancelled_3, t0.cancelled_at AS cancelled_at_4, t0.is_loaded AS is_loaded_5, t0.loaded_at AS loaded_at_6, t0.is_received AS is_received_7, t0.is_received_fully AS is_received_fully_8, t0.received_parcels AS received_parcels_9, t0.received_at AS received_at_10, t0.created_at AS created_at_11, t0.is_verified AS is_verified_12, t0.origin_station AS origin_station_13, t0.destination AS destination_14, t0.cancelled_by AS cancelled_by_15, t0.loaded_by AS loaded_by_16, t0.received_by AS received_by_17, t0.created_by AS created_by_18, t19.id AS id_20, t19.is_verified AS is_verified_21, t19.verified_at AS verified_at_22, t19.is_cancelled AS is_cancelled_23, t19.cancelled_at AS cancelled_at_24, t19.created_at AS created_at_25, t19.delivery_id AS delivery_id_26, t19.vehicle_id AS vehicle_id_27, t19.verified_by AS verified_by_28, t19.cancelled_by AS cancelled_by_29, t19.created_by AS created_by_30 FROM delivery t0 LEFT JOIN delivery_vehicle t19 ON t19.delivery_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "65348"
]
3 1.62 ms
SELECT t0.id AS id_1, t0.reg_number AS reg_number_2, t0.passenger_capacity AS passenger_capacity_3, t0.vehicle_name AS vehicle_name_4, t0.manufacture_year AS manufacture_year_5, t0.fuel AS fuel_6, t0.created_at AS created_at_7, t0.model_id AS model_id_8, t0.created_by AS created_by_9 FROM vehicle t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "2193"
]
4 1.24 ms
SELECT t0.id AS id_1, t0.is_verified AS is_verified_2, t0.verified_at AS verified_at_3, t0.is_cancelled AS is_cancelled_4, t0.cancelled_at AS cancelled_at_5, t0.created_at AS created_at_6, t0.delivery_id AS delivery_id_7, t0.vehicle_id AS vehicle_id_8, t0.verified_by AS verified_by_9, t0.cancelled_by AS cancelled_by_10, t0.created_by AS created_by_11 FROM delivery_vehicle t0 WHERE t0.delivery_id = ? AND t0.is_cancelled = ? LIMIT 1
Parameters:
[
  65348
  0
]
5 0.34 ms
"START TRANSACTION"
Parameters:
[]
6 6.37 ms
INSERT INTO delivery_vehicle (is_verified, verified_at, is_cancelled, cancelled_at, created_at, delivery_id, vehicle_id, verified_by, cancelled_by, created_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  0
  null
  0
  null
  "2025-03-18 12:32:15"
  65348
  2193
  null
  null
  104
]
7 5.13 ms
UPDATE delivery SET is_loaded = ?, loaded_at = ?, loaded_by = ? WHERE id = ?
Parameters:
[
  1
  "2025-03-18 12:32:15"
  104
  65348
]
8 6.15 ms
"COMMIT"
Parameters:
[]
9 2.09 ms
SELECT t0.id AS id_1, t0.is_cancelled AS is_cancelled_2, t0.cancelled_at AS cancelled_at_3, t0.cancelled_because AS cancelled_because_4, t0.is_received AS is_received_5, t0.received_at AS received_at_6, t0.created_at AS created_at_7, t0.delivery_id AS delivery_id_8, t0.parcel_id AS parcel_id_9, t0.cancelled_by AS cancelled_by_10, t0.received_by AS received_by_11, t0.created_by AS created_by_12 FROM delivery_parcel t0 WHERE t0.delivery_id = ?
Parameters:
[
  65348
]
10 1.14 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.number AS number_3, t0.is_in_delivery AS is_in_delivery_4, t0.created_at AS created_at_5, t0.way_bill_id AS way_bill_id_6 FROM parcel t0 WHERE t0.id = ?
Parameters:
[
  1069835
]
11 1.00 ms
SELECT t0.id AS id_1, t0.sample_message AS sample_message_2, t0.send_to AS send_to_3, t0.action AS action_4, t0.created_by AS created_by_5 FROM sms_setup t0 WHERE t0.action = ?
Parameters:
[
  "loading"
]
12 1.37 ms
SELECT t0.id AS id_1, t0.sender_name AS sender_name_2, t0.sender_phone_number AS sender_phone_number_3, t0.receiver_name AS receiver_name_4, t0.receiver_phone_number AS receiver_phone_number_5, t0.created_at AS created_at_6, t0.is_collected AS is_collected_7, t0.is_received AS is_received_8, t0.received_at AS received_at_9, t0.percel_count AS percel_count_10, t0.longitude AS longitude_11, t0.latitude AS latitude_12, t0.parcel_value AS parcel_value_13, t0.from_station_id AS from_station_id_14, t0.to_station_id AS to_station_id_15, t0.created_by AS created_by_16, t17.id AS id_18, t17.amount AS amount_19, t17.cash_amount AS cash_amount_20, t17.mpesa_amount AS mpesa_amount_21, t17.tax_percentage AS tax_percentage_22, t17.tax_amount AS tax_amount_23, t17.gross_amount AS gross_amount_24, t17.station_expenses AS station_expenses_25, t17.station_balance AS station_balance_26, t17.expenses AS expenses_27, t17.balance AS balance_28, t17.created_at AS created_at_29, t17.is_cancelled AS is_cancelled_30, t17.is_complete AS is_complete_31, t17.is_paid AS is_paid_32, t17.paid_by AS paid_by_33, t17.mpesa_payment_phone AS mpesa_payment_phone_34, t17.payment_method AS payment_method_35, t17.pin_number AS pin_number_36, t17.cu_invoice_number AS cu_invoice_number_37, t17.cu_invoice_number_credit AS cu_invoice_number_credit_38, t17.cu_serial_number AS cu_serial_number_39, t17.is_final AS is_final_40, t17.way_bill_id AS way_bill_id_41, t17.created_by AS created_by_42, t17.organization_id AS organization_id_43, t17.daily_account_id AS daily_account_id_44, t0.received_by AS received_by_45, t0.organization_id AS organization_id_46, t47.id AS id_48, t47.is_consignee AS is_consignee_49, t47.consignee_national_id AS consignee_national_id_50, t47.collector_name AS collector_name_51, t47.national_id AS national_id_52, t47.created_at AS created_at_53, t47.waybill_id AS waybill_id_54, t47.created_by AS created_by_55 FROM way_bill t0 LEFT JOIN transaction t17 ON t17.way_bill_id = t0.id LEFT JOIN collected_parcel t47 ON t47.waybill_id = t0.id WHERE t0.id = ?
Parameters:
[
  1059513
]
13 1.28 ms
SELECT t0.id AS id_1, t0.station_name AS station_name_2, t0.station_address AS station_address_3, t0.phone_numbers AS phone_numbers_4, t0.created_at AS created_at_5, t0.operating_hrs AS operating_hrs_6, t0.is_mobile AS is_mobile_7, t0.organization_id AS organization_id_8, t0.created_by AS created_by_9 FROM station t0 WHERE t0.id = ?
Parameters:
[
  1
]
14 0.71 ms
SELECT t0.id AS id_1, t0.station_name AS station_name_2, t0.station_address AS station_address_3, t0.phone_numbers AS phone_numbers_4, t0.created_at AS created_at_5, t0.operating_hrs AS operating_hrs_6, t0.is_mobile AS is_mobile_7, t0.organization_id AS organization_id_8, t0.created_by AS created_by_9 FROM station t0 WHERE t0.id = ?
Parameters:
[
  2
]
15 0.63 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.amount AS amount_3, t0.sms AS sms_4, t0.recepient AS recepient_5, t0.created_at AS created_at_6, t0.status_code AS status_code_7, t0.manually_sent AS manually_sent_8, t0.action AS action_9, t0.message_id AS message_id_10, t0.transaction_id AS transaction_id_11, t0.organization_id AS organization_id_12, t0.created_by AS created_by_13 FROM sms t0 WHERE t0.transaction_id = ? AND t0.recepient = ? AND t0.action = ?
Parameters:
[
  1059472
  "+254721839714"
  "loading"
]
16 0.23 ms
"START TRANSACTION"
Parameters:
[]
17 5.35 ms
INSERT INTO sms (status, amount, sms, recepient, created_at, status_code, manually_sent, action, message_id, transaction_id, organization_id, created_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  0
  "Hello MARTHA KAGUNYI, DAN has sent you parcel WAYBILL 1059513 from NAIROBI. Please expect it at EMBU in a few hours.Thank you for your continued trust in us,Have an Awesome Afternoon"
  "+254721839714"
  "2025-03-18 12:32:15"
  null
  null
  "loading"
  null
  1059472
  null
  104
]
18 6.64 ms
"COMMIT"
Parameters:
[]
19 7.81 ms
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:23:\"App\\Messages\\SMSMessage\":1:{s:30:\"\0App\\Messages\\SMSMessage\0smsId\";i:1436814;}}"
  "[]"
  "default"
  "2025-03-18 12:32:15"
  "2025-03-18 12:32:15"
]
20 1.46 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.number AS number_3, t0.is_in_delivery AS is_in_delivery_4, t0.created_at AS created_at_5, t0.way_bill_id AS way_bill_id_6 FROM parcel t0 WHERE t0.id = ?
Parameters:
[
  1069839
]
21 1.11 ms
SELECT t0.id AS id_1, t0.sample_message AS sample_message_2, t0.send_to AS send_to_3, t0.action AS action_4, t0.created_by AS created_by_5 FROM sms_setup t0 WHERE t0.action = ?
Parameters:
[
  "loading"
]
22 1.19 ms
SELECT t0.id AS id_1, t0.sender_name AS sender_name_2, t0.sender_phone_number AS sender_phone_number_3, t0.receiver_name AS receiver_name_4, t0.receiver_phone_number AS receiver_phone_number_5, t0.created_at AS created_at_6, t0.is_collected AS is_collected_7, t0.is_received AS is_received_8, t0.received_at AS received_at_9, t0.percel_count AS percel_count_10, t0.longitude AS longitude_11, t0.latitude AS latitude_12, t0.parcel_value AS parcel_value_13, t0.from_station_id AS from_station_id_14, t0.to_station_id AS to_station_id_15, t0.created_by AS created_by_16, t17.id AS id_18, t17.amount AS amount_19, t17.cash_amount AS cash_amount_20, t17.mpesa_amount AS mpesa_amount_21, t17.tax_percentage AS tax_percentage_22, t17.tax_amount AS tax_amount_23, t17.gross_amount AS gross_amount_24, t17.station_expenses AS station_expenses_25, t17.station_balance AS station_balance_26, t17.expenses AS expenses_27, t17.balance AS balance_28, t17.created_at AS created_at_29, t17.is_cancelled AS is_cancelled_30, t17.is_complete AS is_complete_31, t17.is_paid AS is_paid_32, t17.paid_by AS paid_by_33, t17.mpesa_payment_phone AS mpesa_payment_phone_34, t17.payment_method AS payment_method_35, t17.pin_number AS pin_number_36, t17.cu_invoice_number AS cu_invoice_number_37, t17.cu_invoice_number_credit AS cu_invoice_number_credit_38, t17.cu_serial_number AS cu_serial_number_39, t17.is_final AS is_final_40, t17.way_bill_id AS way_bill_id_41, t17.created_by AS created_by_42, t17.organization_id AS organization_id_43, t17.daily_account_id AS daily_account_id_44, t0.received_by AS received_by_45, t0.organization_id AS organization_id_46, t47.id AS id_48, t47.is_consignee AS is_consignee_49, t47.consignee_national_id AS consignee_national_id_50, t47.collector_name AS collector_name_51, t47.national_id AS national_id_52, t47.created_at AS created_at_53, t47.waybill_id AS waybill_id_54, t47.created_by AS created_by_55 FROM way_bill t0 LEFT JOIN transaction t17 ON t17.way_bill_id = t0.id LEFT JOIN collected_parcel t47 ON t47.waybill_id = t0.id WHERE t0.id = ?
Parameters:
[
  1059517
]
23 0.96 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.amount AS amount_3, t0.sms AS sms_4, t0.recepient AS recepient_5, t0.created_at AS created_at_6, t0.status_code AS status_code_7, t0.manually_sent AS manually_sent_8, t0.action AS action_9, t0.message_id AS message_id_10, t0.transaction_id AS transaction_id_11, t0.organization_id AS organization_id_12, t0.created_by AS created_by_13 FROM sms t0 WHERE t0.transaction_id = ? AND t0.recepient = ? AND t0.action = ?
Parameters:
[
  1059476
  "+254114625008"
  "loading"
]
24 0.23 ms
"START TRANSACTION"
Parameters:
[]
25 1.44 ms
INSERT INTO sms (status, amount, sms, recepient, created_at, status_code, manually_sent, action, message_id, transaction_id, organization_id, created_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  0
  "Hello RUTH HAMALI, FAITH has sent you parcel WAYBILL 1059517 from NAIROBI. Please expect it at EMBU in a few hours.Thank you for your continued trust in us,Have an Awesome Afternoon"
  "+254114625008"
  "2025-03-18 12:32:15"
  null
  null
  "loading"
  null
  1059476
  null
  104
]
26 5.85 ms
"COMMIT"
Parameters:
[]
27 6.86 ms
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:23:\"App\\Messages\\SMSMessage\":1:{s:30:\"\0App\\Messages\\SMSMessage\0smsId\";i:1436815;}}"
  "[]"
  "default"
  "2025-03-18 12:32:15"
  "2025-03-18 12:32:15"
]
28 0.87 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.number AS number_3, t0.is_in_delivery AS is_in_delivery_4, t0.created_at AS created_at_5, t0.way_bill_id AS way_bill_id_6 FROM parcel t0 WHERE t0.id = ?
Parameters:
[
  1069826
]
29 1.38 ms
SELECT t0.id AS id_1, t0.sample_message AS sample_message_2, t0.send_to AS send_to_3, t0.action AS action_4, t0.created_by AS created_by_5 FROM sms_setup t0 WHERE t0.action = ?
Parameters:
[
  "loading"
]
30 0.92 ms
SELECT t0.id AS id_1, t0.sender_name AS sender_name_2, t0.sender_phone_number AS sender_phone_number_3, t0.receiver_name AS receiver_name_4, t0.receiver_phone_number AS receiver_phone_number_5, t0.created_at AS created_at_6, t0.is_collected AS is_collected_7, t0.is_received AS is_received_8, t0.received_at AS received_at_9, t0.percel_count AS percel_count_10, t0.longitude AS longitude_11, t0.latitude AS latitude_12, t0.parcel_value AS parcel_value_13, t0.from_station_id AS from_station_id_14, t0.to_station_id AS to_station_id_15, t0.created_by AS created_by_16, t17.id AS id_18, t17.amount AS amount_19, t17.cash_amount AS cash_amount_20, t17.mpesa_amount AS mpesa_amount_21, t17.tax_percentage AS tax_percentage_22, t17.tax_amount AS tax_amount_23, t17.gross_amount AS gross_amount_24, t17.station_expenses AS station_expenses_25, t17.station_balance AS station_balance_26, t17.expenses AS expenses_27, t17.balance AS balance_28, t17.created_at AS created_at_29, t17.is_cancelled AS is_cancelled_30, t17.is_complete AS is_complete_31, t17.is_paid AS is_paid_32, t17.paid_by AS paid_by_33, t17.mpesa_payment_phone AS mpesa_payment_phone_34, t17.payment_method AS payment_method_35, t17.pin_number AS pin_number_36, t17.cu_invoice_number AS cu_invoice_number_37, t17.cu_invoice_number_credit AS cu_invoice_number_credit_38, t17.cu_serial_number AS cu_serial_number_39, t17.is_final AS is_final_40, t17.way_bill_id AS way_bill_id_41, t17.created_by AS created_by_42, t17.organization_id AS organization_id_43, t17.daily_account_id AS daily_account_id_44, t0.received_by AS received_by_45, t0.organization_id AS organization_id_46, t47.id AS id_48, t47.is_consignee AS is_consignee_49, t47.consignee_national_id AS consignee_national_id_50, t47.collector_name AS collector_name_51, t47.national_id AS national_id_52, t47.created_at AS created_at_53, t47.waybill_id AS waybill_id_54, t47.created_by AS created_by_55 FROM way_bill t0 LEFT JOIN transaction t17 ON t17.way_bill_id = t0.id LEFT JOIN collected_parcel t47 ON t47.waybill_id = t0.id WHERE t0.id = ?
Parameters:
[
  1059504
]
31 0.81 ms
SELECT t0.id AS id_1, t0.status AS status_2, t0.amount AS amount_3, t0.sms AS sms_4, t0.recepient AS recepient_5, t0.created_at AS created_at_6, t0.status_code AS status_code_7, t0.manually_sent AS manually_sent_8, t0.action AS action_9, t0.message_id AS message_id_10, t0.transaction_id AS transaction_id_11, t0.organization_id AS organization_id_12, t0.created_by AS created_by_13 FROM sms t0 WHERE t0.transaction_id = ? AND t0.recepient = ? AND t0.action = ?
Parameters:
[
  1059463
  "+254111904796"
  "loading"
]
32 0.37 ms
"START TRANSACTION"
Parameters:
[]
33 1.53 ms
INSERT INTO sms (status, amount, sms, recepient, created_at, status_code, manually_sent, action, message_id, transaction_id, organization_id, created_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  0
  "Hello VERONICA WAMBUI, HEALTH CAVE has sent you parcel WAYBILL 1059504 from NAIROBI. Please expect it at EMBU in a few hours.Thank you for your continued trust in us,Have an Awesome Afternoon"
  "+254111904796"
  "2025-03-18 12:32:15"
  null
  null
  "loading"
  null
  1059463
  null
  104
]
34 5.08 ms
"COMMIT"
Parameters:
[]
35 6.44 ms
INSERT INTO messenger_messages (body, headers, queue_name, created_at, available_at) VALUES(?, ?, ?, ?, ?)
Parameters:
[
  "O:36:\"Symfony\\Component\\Messenger\\Envelope\":2:{s:44:\"\0Symfony\\Component\\Messenger\\Envelope\0stamps\";a:1:{s:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\";a:1:{i:0;O:46:\"Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\":1:{s:55:\"\0Symfony\\Component\\Messenger\\Stamp\\BusNameStamp\0busName\";s:21:\"messenger.bus.default\";}}}s:45:\"\0Symfony\\Component\\Messenger\\Envelope\0message\";O:23:\"App\\Messages\\SMSMessage\":1:{s:30:\"\0App\\Messages\\SMSMessage\0smsId\";i:1436816;}}"
  "[]"
  "default"
  "2025-03-18 12:32:15"
  "2025-03-18 12:32:15"
]

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\DeliveryVehicle No errors.
App\Entity\Vehicle No errors.
App\Entity\DeliveryParcel No errors.
App\Entity\Model 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\SmsSetup No errors.
App\Entity\Transaction No errors.
App\Entity\Organization No errors.
App\Entity\DailyAccount No errors.
App\Entity\CollectedParcel No errors.
App\Entity\TransactionExpense No errors.
App\Entity\Sms No errors.