GET https://coupinade.fr/gps/points/imei/2026-01-10?imei=2147483647

Query Metrics

4 Database Queries
4 Different statements
27.92 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.64 ms
SELECT g0_.id AS id_0, g0_.num_imei AS num_imei_1, g0_.immat AS immat_2 FROM gps_balise g0_ WHERE g0_.num_imei = ?
Parameters:
[
  "2147483647"
]
2 0.33 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.taux_horaire AS taux_horaire_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 0.29 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.taux_horaire AS taux_horaire_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 INNER JOIN gps_balise_user ON t0.id = gps_balise_user.user_id WHERE gps_balise_user.balise_id = ?
Parameters:
[
  7
]
4 26.66 ms
SELECT g0_.id AS id_0, g0_.latitude AS latitude_1, g0_.longitude AS longitude_2, g0_.vitesse AS vitesse_3, g0_.altitude AS altitude_4, g0_.date_donnees AS date_donnees_5, g0_.date_create AS date_create_6, g0_.etat_roule AS etat_roule_7, g0_.nombre_satelite AS nombre_satelite_8, g0_.tension_batterie AS tension_batterie_9, g0_.balise_gps_id AS balise_gps_id_10 FROM gps_donnee g0_ LEFT JOIN gps_balise g1_ ON g0_.balise_gps_id = g1_.id WHERE (g0_.date_donnees BETWEEN ? AND ?) AND g1_.num_imei = ? ORDER BY g0_.date_donnees ASC
Parameters:
[
  "2026-01-10 00:00:00"
  "2026-01-10 23:59:59"
  "2147483647"
]

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\Gps\BaliseGPS No errors.
App\Entity\User No errors.
App\Entity\Gps\Pointage No errors.
App\Entity\Gps\Absence No errors.
App\Entity\Gps\DonneeGPS No errors.