https://courier.ohau.co.ke/api/deliveries/15

Query Metrics

7 Database Queries
6 Different statements
14.04 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.93 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 1.38 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 = ? LIMIT 1
Parameters:
[
  "15"
]
3 1.26 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.user AS user_4, t0.station_id AS station_id_5 FROM user_station t0 WHERE t0.user = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  104
]
4 1.32 ms
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.user AS user_4, t0.station_id AS station_id_5 FROM user_station t0 WHERE t0.user = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[
  104
]
5 0.62 ms
"START TRANSACTION"
Parameters:
[]
6 1.52 ms
INSERT INTO delivery (parcel_count, is_cancelled, cancelled_at, is_loaded, loaded_at, is_received, is_received_fully, received_parcels, received_at, created_at, is_verified, origin_station, destination, cancelled_by, loaded_by, received_by, created_by) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  0
  0
  null
  0
  null
  0
  0
  0
  null
  "2025-03-18 12:02:50"
  0
  1
  15
  null
  null
  null
  104
]
7 7.00 ms
"COMMIT"
Parameters:
[]

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\Station No errors.
App\Entity\Organization No errors.
App\Entity\UserStation 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.