| 1 |
1.00 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.fonction AS fonction_5, t0.photo AS photo_6, t0.roles AS roles_7, t0.password AS password_8, t0.refresh_token AS refresh_token_9, t0.refresh_token_expires_at AS refresh_token_expires_at_10, t0.has_permis_de_conduire AS has_permis_de_conduire_11, t0.apps AS apps_12, t0.axium_refresh_token AS axium_refresh_token_13, t0.fcm_key AS fcm_key_14, t0.receive_notif AS receive_notif_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.station_id AS station_id_19, t0.lieu_empotage_id AS lieu_empotage_id_20 FROM `user` t0 WHERE t0.email = ? LIMIT 1
Parameters: [
"parcauto@sifogroup.com"
]
SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.fonction AS fonction_5, t0.photo AS photo_6, t0.roles AS roles_7, t0.password AS password_8, t0.refresh_token AS refresh_token_9, t0.refresh_token_expires_at AS refresh_token_expires_at_10, t0.has_permis_de_conduire AS has_permis_de_conduire_11, t0.apps AS apps_12, t0.axium_refresh_token AS axium_refresh_token_13, t0.fcm_key AS fcm_key_14, t0.receive_notif AS receive_notif_15, t0.slug AS slug_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.station_id AS station_id_19, t0.lieu_empotage_id AS lieu_empotage_id_20 FROM `user` t0 WHERE t0.email = 'parcauto@sifogroup.com' LIMIT 1;
|
| 2 |
0.61 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = 10;
|
| 3 |
0.31 ms |
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.role_id AS role_id_3, t0.permission_id AS permission_id_4 FROM role_permission t0 WHERE t0.role_id = ?
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.role_id AS role_id_3, t0.permission_id AS permission_id_4 FROM role_permission t0 WHERE t0.role_id = 8;
|
| 4 |
0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 166;
|
| 5 |
0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 157;
|
| 6 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 158;
|
| 7 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 152;
|
| 8 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 153;
|
| 9 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 122;
|
| 10 |
0.26 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 123;
|
| 11 |
0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 125;
|
| 12 |
0.19 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 126;
|
| 13 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 127;
|
| 14 |
0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = 128;
|
| 15 |
1.65 ms |
SELECT s0_.id AS id_0, s0_.date_de_sortie AS date_de_sortie_1, s0_.motif AS motif_2, s0_.niveau_carburant AS niveau_carburant_3, s0_.kilometrage AS kilometrage_4, s0_.niveau_carburant_retour AS niveau_carburant_retour_5, s0_.kilometrage_retour AS kilometrage_retour_6, s0_.capture_tdb AS capture_tdb_7, s0_.distance_parcourue AS distance_parcourue_8, s0_.capture_tdbretour AS capture_tdbretour_9, s0_.date_de_retour AS date_de_retour_10, s0_.commentaire AS commentaire_11, s0_.commentaire_retour AS commentaire_retour_12, s0_.slug AS slug_13, s0_.created_at AS created_at_14, s0_.updated_at AS updated_at_15, s0_.vehicule_id AS vehicule_id_16 FROM sortie_vehicule s0_ INNER JOIN sortie_vehicule_user s1_ ON (s1_.sortie_vehicule_id = s0_.id) WHERE s1_.user_id = ? ORDER BY s0_.date_de_sortie DESC LIMIT 5
SELECT s0_.id AS id_0, s0_.date_de_sortie AS date_de_sortie_1, s0_.motif AS motif_2, s0_.niveau_carburant AS niveau_carburant_3, s0_.kilometrage AS kilometrage_4, s0_.niveau_carburant_retour AS niveau_carburant_retour_5, s0_.kilometrage_retour AS kilometrage_retour_6, s0_.capture_tdb AS capture_tdb_7, s0_.distance_parcourue AS distance_parcourue_8, s0_.capture_tdbretour AS capture_tdbretour_9, s0_.date_de_retour AS date_de_retour_10, s0_.commentaire AS commentaire_11, s0_.commentaire_retour AS commentaire_retour_12, s0_.slug AS slug_13, s0_.created_at AS created_at_14, s0_.updated_at AS updated_at_15, s0_.vehicule_id AS vehicule_id_16 FROM sortie_vehicule s0_ INNER JOIN sortie_vehicule_user s1_ ON (s1_.sortie_vehicule_id = s0_.id) WHERE s1_.user_id = 10 ORDER BY s0_.date_de_sortie DESC LIMIT 5;
|
| 16 |
0.69 ms |
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.annee AS annee_3, t0.couleur AS couleur_4, t0.immatriculation AS immatriculation_5, t0.kilometrage AS kilometrage_6, t0.type_carburant AS type_carburant_7, t0.transmission AS transmission_8, t0.statut AS statut_9, t0.slug AS slug_10, t0.niveau_max_carburant AS niveau_max_carburant_11, t0.niveau_carburant AS niveau_carburant_12, t0.marque_id AS marque_id_13 FROM vehicule t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.annee AS annee_3, t0.couleur AS couleur_4, t0.immatriculation AS immatriculation_5, t0.kilometrage AS kilometrage_6, t0.type_carburant AS type_carburant_7, t0.transmission AS transmission_8, t0.statut AS statut_9, t0.slug AS slug_10, t0.niveau_max_carburant AS niveau_max_carburant_11, t0.niveau_carburant AS niveau_carburant_12, t0.marque_id AS marque_id_13 FROM vehicule t0 WHERE t0.id = 11;
|
| 17 |
0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM marque t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM marque t0 WHERE t0.id = 23;
|
| 18 |
0.47 ms |
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.annee AS annee_3, t0.couleur AS couleur_4, t0.immatriculation AS immatriculation_5, t0.kilometrage AS kilometrage_6, t0.type_carburant AS type_carburant_7, t0.transmission AS transmission_8, t0.statut AS statut_9, t0.slug AS slug_10, t0.niveau_max_carburant AS niveau_max_carburant_11, t0.niveau_carburant AS niveau_carburant_12, t0.marque_id AS marque_id_13 FROM vehicule t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.modele AS modele_2, t0.annee AS annee_3, t0.couleur AS couleur_4, t0.immatriculation AS immatriculation_5, t0.kilometrage AS kilometrage_6, t0.type_carburant AS type_carburant_7, t0.transmission AS transmission_8, t0.statut AS statut_9, t0.slug AS slug_10, t0.niveau_max_carburant AS niveau_max_carburant_11, t0.niveau_carburant AS niveau_carburant_12, t0.marque_id AS marque_id_13 FROM vehicule t0 WHERE t0.id = 12;
|
| 19 |
0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM marque t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM marque t0 WHERE t0.id = 1;
|