Query Metrics
2
Database Queries
2
Different statements
1.13 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.82 ms |
SELECT t0_.id AS id_0, t0_.depart AS depart_1, t0_.arrivee AS arrivee_2, t0_.date_trajet AS date_trajet_3, t0_.heure_trajet AS heure_trajet_4, t0_.places_disponibles AS places_disponibles_5, t0_.prix AS prix_6, t0_.description AS description_7, t0_.annule AS annule_8, t0_.places AS places_9, t0_.created_at AS created_at_10, t0_.conducteur_id AS conducteur_id_11 FROM trajet t0_ WHERE LOWER(t0_.depart) = LOWER(?) AND LOWER(t0_.arrivee) = LOWER(?) AND t0_.date_trajet >= ? AND t0_.date_trajet < ? AND t0_.places_disponibles >= ? AND (t0_.annule IS NULL OR t0_.annule = 0) ORDER BY t0_.date_trajet ASC, t0_.heure_trajet ASC
Parameters:
[ "Acoua" "Bandrélé" "2025-12-10 00:00:00" "2025-12-10 23:59:59" 1 ] |
| 2 | 0.31 ms |
SELECT t0_.id AS id_0, t0_.depart AS depart_1, t0_.arrivee AS arrivee_2, t0_.date_trajet AS date_trajet_3, t0_.heure_trajet AS heure_trajet_4, t0_.places_disponibles AS places_disponibles_5, t0_.prix AS prix_6, t0_.description AS description_7, t0_.annule AS annule_8, t0_.places AS places_9, t0_.created_at AS created_at_10, t0_.conducteur_id AS conducteur_id_11 FROM trajet t0_ WHERE t0_.date_trajet = ? AND t0_.arrivee = ? AND t0_.depart <> ? AND t0_.annule <> 1
Parameters:
[ "2025-12-10 00:00:00" "Bandrélé" "Acoua" ] |
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\Trajet | No errors. |
| App\Entity\User | No errors. |