https://sys.nenocourier.co.ke/bus_api/trips/38248

Query Metrics

56 Database Queries
7 Different statements
31.71 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
23.47 ms
(74.03%)
49
SELECT t0.id AS id_1, t0.passenger AS passenger_2, t0.phone AS phone_3, t0.departure_time AS departure_time_4, t0.eta AS eta_5, t0.amount AS amount_6, t0.paid_via AS paid_via_7, t0.created_at AS created_at_8, t0.origin AS origin_9, t0.destination AS destination_10, t0.seat_id AS seat_id_11, t0.created_by AS created_by_12 FROM bus_booking_seat t0 WHERE t0.seat_id = ?
Parameters:
[
  1873769
]
1.73 ms
(5.44%)
2
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:
[
  18
]
1.53 ms
(4.81%)
1
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 = ?
Parameters:
[
  2112
]
1.45 ms
(4.56%)
1
SELECT t0.id AS id_1, t0.seat_number AS seat_number_2, t0.is_booked AS is_booked_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.trip_id AS trip_id_6 FROM bus_seat t0 WHERE t0.trip_id = ?
Parameters:
[
  38248
]
1.30 ms
(4.09%)
1
SELECT t0.id AS id_1, t0.route_name AS route_name_2, t0.created_at AS created_at_3, t0.departure_time AS departure_time_4, t0.eta AS eta_5, t0.origin AS origin_6, t0.destination AS destination_7, t0.created_by AS created_by_8 FROM bus_route t0 WHERE t0.id = ?
Parameters:
[
  18
]
1.16 ms
(3.65%)
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 = ? LIMIT 1
Parameters:
[
  "38248"
]
1.08 ms
(3.41%)
1
SELECT t0.id AS id_1, t0.route_type AS route_type_2, t0.created_at AS created_at_3, t0.departure_time AS departure_time_4, t0.eta AS eta_5, t0.station_id AS station_id_6, t0.route_id AS route_id_7, t0.created_by AS created_by_8 FROM bus_stop t0 WHERE t0.route_id = ?
Parameters:
[
  18
]

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\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\User 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\Stop No errors.
App\Entity\Bus\BookingSeat No errors.
App\Entity\Organization No errors.
App\Entity\Model No errors.