https://sys.nenocourier.co.ke/bus/trip/38335/json Return to referer URL

Query Metrics

3 Database Queries
3 Different statements
6.22 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.67 ms
(59.03%)
1
SELECT bs.id,a.seat_number, bs.passenger, bs.phone,p.first_name,st.station_name as origin,mp.transaction_id, std.station_name as destination, bs.amount,a.status FROM bus_seat a 
                    LEFT JOIN bus_booking_seat bs on a.id = bs.seat_id
                    LEFT JOIN bus_stop s on s.id = bs.origin
                    LEFT JOIN station st ON st.id = s.station_id
                    LEFT JOIN bus_stop sd ON sd.id = bs.destination
                    LEFT JOIN station std ON std.id = sd.station_id
                    LEFT JOIN user u on bs.created_by = u.id
                    LEFT JOIN person p on u.person_id = p.id
                    LEFT JOIN bus_booking_mpesa bs_mpesa ON bs_mpesa.booking_id = bs.id
                    LEFT JOIN mpesa mp ON mp.id = bs_mpesa.mpesa_id
                 WHERE a.trip_id = 38335  order by a.seat_number
Parameters:
[]
1.28 ms
(20.62%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.trip_date AS trip_date_3, t0.departure_time AS departure_time_4, t0.eta AS eta_5, t0.fare AS fare_6, t0.trip_index AS trip_index_7, t0.vehicle_is_approved AS vehicle_is_approved_8, t0.route_id AS route_id_9, t0.origin AS origin_10, t0.destination AS destination_11, t0.created_by AS created_by_12, t0.vehicle AS vehicle_13 FROM bus_trip t0 WHERE t0.id = ?
Parameters:
[
  "38335"
]
1.27 ms
(20.35%)
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.is_active AS is_active_7, t0.person_id AS person_id_8 FROM user t0 WHERE t0.id = ?
Parameters:
[
  166
]

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\Bus\Trip
  • The field App\Entity\Bus\Trip#seats is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Bus\Seat#trip does not contain the required 'inversedBy="seats"' attribute.
App\Entity\Bus\Route
  • The field App\Entity\Bus\Route#stops is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Bus\Stop#route does not contain the required 'inversedBy="stops"' attribute.
App\Entity\Station No errors.
App\Entity\Vehicle No errors.
App\Entity\Bus\Seat
  • The field App\Entity\Bus\Seat#booking is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Bus\BookingSeat#seat does not contain the required 'inversedBy="booking"' attribute.
App\Entity\Bus\BookingSeat No errors.