| 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 = ?
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 = 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 = ?
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 = 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"
]
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 '2026-01-10 00:00:00' AND '2026-01-10 23:59:59') AND g1_.num_imei = '2147483647' ORDER BY g0_.date_donnees ASC;
|