GET https://fleetmaster.optimumci.com/api/sortie/vehicules/recent

Query Metrics

19 Database Queries
7 Different statements
8.33 ms Query time
0 Invalid entities
31 Managed entities

Queries

Group similar statements

# Time Info
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"
]
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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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
Parameters:
[
  10
]
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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  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 = ?
Parameters:
[
  1
]

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\Admin\RolePermission 11
App\Entity\Admin\Permission 11
App\Entity\Domain\Flotte\SortieVehicule 3
App\Entity\Domain\Flotte\Vehicule 2
App\Entity\Domain\Params\Marque 2
App\Entity\Admin\User 1
App\Entity\Admin\Role 1