https://sys.nenocourier.co.ke/api/data2?last_parcel_id=826276&last_vehicle=2232&station_id=15

Query Metrics

3 Database Queries
3 Different statements
77.41 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
75.31 ms
(97.28%)
1
SELECT p0_.id AS id_0, w1_.id AS id_1, p0_.number AS number_2, p0_.is_in_delivery AS is_in_delivery_3, p0_.description AS description_4, w1_.sender_name AS sender_name_5, w1_.sender_phone_number AS sender_phone_number_6, w1_.receiver_name AS receiver_name_7, w1_.receiver_phone_number AS receiver_phone_number_8, s2_.id AS id_9, s2_.station_name AS station_name_10, s3_.id AS id_11, s3_.station_name AS station_name_12, DATE_FORMAT(w1_.created_at, '%Y-%m-%d %H:%i:%s') AS sclr_13, u4_.id AS id_14, t5_.id AS id_15, t5_.amount AS amount_16, w1_.is_collected AS is_collected_17, o6_.id AS id_18, w1_.percel_count AS percel_count_19 FROM parcel p0_ INNER JOIN way_bill w1_ ON p0_.way_bill_id = w1_.id INNER JOIN station s2_ ON w1_.from_station_id = s2_.id INNER JOIN station s3_ ON w1_.to_station_id = s3_.id INNER JOIN user u4_ ON w1_.created_by = u4_.id INNER JOIN transaction t5_ ON w1_.id = t5_.way_bill_id INNER JOIN organization o6_ ON w1_.organization_id = o6_.id WHERE p0_.id > ? AND w1_.from_station_id = ? ORDER BY w1_.id DESC LIMIT 5000
Parameters:
[
  "826276"
  "15"
]
1.17 ms
(1.51%)
1
SELECT v0_.id AS id_0, v0_.reg_number AS reg_number_1, v0_.passenger_capacity AS passenger_capacity_2 FROM vehicle v0_ WHERE v0_.id > ?
Parameters:
[
  "2232"
]
0.94 ms
(1.21%)
1
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:
[
  117
]

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