GET https://locav.rben.ovh/vehicle/019bd724-3abf-7f35-b722-772a248bf3f3?dateFrom=2026-01-21&dateTo=2026-01-24

Query Metrics

9 Database Queries
9 Different statements
9.46 ms Query time
2 Invalid entities
8 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.80 ms
(29.58%)
1
SELECT t0.id AS id_2, t0.year AS year_3, t0.days_min AS days_min_4, t0.description AS description_5, t0.reference AS reference_6, t0.status AS status_7, t0.price AS price_8, t0.registration_number AS registration_number_9, t0.registration_letter AS registration_letter_10, t0.registration_city_code AS registration_city_code_11, t0.created_at AS created_at_12, t0.city_id AS city_id_13, t0.agency_id AS agency_id_14, t0.model_id AS model_id_15, t0.discriminator_type, t1.seats_nbr AS seats_nbr_16, t1.doors_nbr AS doors_nbr_17, t1.child_seat AS child_seat_18, t1.gear_box AS gear_box_19, t1.fuel AS fuel_20, t1.type AS type_21 FROM vehicle t0 LEFT JOIN car t1 ON t0.id = t1.id WHERE t0.id = ?
Parameters:
[
  "019bd724-3abf-7f35-b722-772a248bf3f3"
]
1.59 ms
(16.81%)
1
SELECT COUNT(b0_.id) AS sclr_0 FROM booking b0_ WHERE b0_.status = ? AND (b0_.date_from < ? AND b0_.date_to > ?) AND b0_.vehicle_id = ?
Parameters:
[
  "confirmed"
  "2026-01-24"
  "2026-01-21"
  "019bd724-3abf-7f35-b722-772a248bf3f3"
]
1.39 ms
(14.68%)
1
SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.is_email_verified AS is_email_verified_6, t1.is_phone_verified AS is_phone_verified_7, t1.email_verification_token AS email_verification_token_8, t1.phone_verification_token AS phone_verification_token_9, t1.status AS status_10, t1.pending_email AS pending_email_11, t1.pending_phone AS pending_phone_12, t1.reference AS reference_13, t1.created_at AS created_at_14, t1.last_name AS last_name_15, t1.first_name AS first_name_16, t1.phone AS phone_17, t0.name AS name_18, t0.profile_picture AS profile_picture_19, t0.description AS description_20, t0.slug AS slug_21, t0.is_visible AS is_visible_22, t1.discriminator_type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  "019bd724-3715-7380-812d-4036cc4b851a"
]
0.92 ms
(9.68%)
1
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.reference AS reference_4, t0.created_at AS created_at_5, t0.client_id AS client_id_6, t0.agency_id AS agency_id_7 FROM review t0 WHERE t0.agency_id = ? ORDER BY t0.created_at DESC
Parameters:
[
  "019bd724-3715-7380-812d-4036cc4b851a"
]
0.75 ms
(7.96%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.vehicle_type AS vehicle_type_3, t0.brand_id AS brand_id_4 FROM model t0 WHERE t0.id = ?
Parameters:
[
  8
]
0.63 ms
(6.64%)
1
SELECT t0.id AS id_1, t0.file_name AS file_name_2, t0.is_default AS is_default_3, t0.update_trigger AS update_trigger_4, t0.created_at AS created_at_5, t0.vehicle_id AS vehicle_id_6 FROM vehicle_image t0 WHERE t0.vehicle_id = ?
Parameters:
[
  "019bd724-3abf-7f35-b722-772a248bf3f3"
]
0.57 ms
(6.04%)
1
SELECT t0.id AS id_1, t0.addresses AS addresses_2, t0.city_id AS city_id_3, t0.agency_id AS agency_id_4 FROM agency_address t0 WHERE t0.agency_id = ?
Parameters:
[
  "019bd724-3715-7380-812d-4036cc4b851a"
]
0.44 ms
(4.68%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.37 ms
(3.94%)
1
SELECT t0.id AS id_1, t0.name_fr AS name_fr_2 FROM city t0 WHERE t0.id = ?
Parameters:
[
  5
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\VehicleImage 3
App\Entity\Vehicle 1
App\Entity\City 1
App\Entity\User 1
App\Entity\Model 1
App\Entity\Brand 1

Entities Mapping

Class Mapping errors
App\Entity\Vehicle No errors.
App\Entity\Car No errors.
App\Entity\City No errors.
App\Entity\User No errors.
App\Entity\Agency
  • The association App\Entity\Agency#employees refers to the owning side field App\Entity\Employee#employee which does not exist.
App\Entity\Model No errors.
App\Entity\VehicleStatus No errors.
App\Entity\VehicleImage No errors.
App\Entity\Booking No errors.
App\Entity\UserStatus No errors.
App\Entity\Employee
  • The mappings App\Entity\Employee#agency and App\Entity\Agency#employees are inconsistent with each other.
App\Entity\AgencyAddress No errors.
App\Entity\Review No errors.
App\Entity\Client No errors.
App\Entity\Brand No errors.
App\Entity\Renter No errors.