Query Metrics
5
Database Queries
5
Different statements
1.80 ms
Query time
4
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.41 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.price_per_kilometers AS price_per_kilometers_4, t0.number_of_persons AS number_of_persons_5 FROM category t0
Parameters:
[]
|
||||||||||||||||||||||
2 | 0.40 ms |
SELECT t0.id AS id_1, t0.pick_up_location AS pick_up_location_2, t0.drop_location AS drop_location_3, t0.status AS status_4, t0.price AS price_5, t0.created_at AS created_at_6, t0.driver_id AS driver_id_7, t0.rider_id AS rider_id_8, t0.category_id AS category_id_9 FROM booking t0 WHERE t0.rider_id IS NULL AND t0.status = ?
Parameters:
[
"Ride Start"
]
|
||||||||||||||||||||||
3 | 0.28 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.driver_id AS driver_id_6, t0.rider_id AS rider_id_7, t0.booking_id AS booking_id_8 FROM driver_rating t0 WHERE t0.booking_id IS NULL
Parameters:
[]
|
||||||||||||||||||||||
4 | 0.38 ms |
SELECT t0.id AS id_1, t0.pick_up_location AS pick_up_location_2, t0.drop_location AS drop_location_3, t0.status AS status_4, t0.price AS price_5, t0.created_at AS created_at_6, t0.driver_id AS driver_id_7, t0.rider_id AS rider_id_8, t0.category_id AS category_id_9 FROM booking t0 WHERE t0.rider_id IS NULL AND t0.status = ? LIMIT 1
Parameters:
[
"Ride Start"
]
|
||||||||||||||||||||||
5 | 0.33 ms |
SELECT t0.id AS id_1, t0.otp AS otp_2, t0.otp_expiration AS otp_expiration_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.booking_id AS booking_id_6 FROM ride_otp t0 WHERE t0.booking_id IS NULL ORDER BY t0.id DESC LIMIT 1
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\Admin\Category | No errors. |
App\Entity\Booking |
|
App\Entity\User |
|
App\Entity\DriverRating |
|
App\Entity\RideOtp |
|