Query Metrics

32 Database Queries
5 Different statements
5.51 ms Query time
0 Invalid entities
67 Managed entities

Queries

Group similar statements

# Time Info
1 0.55 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?
Parameters:
[
  "petra.hlavackova@gmail.com"
]
2 0.30 ms
SELECT t0.libelle AS libelle_1, t0.description AS description_2, t0.hyperlien_site_caesug AS hyperlien_site_caesug_3, t0.tarif_caesug AS tarif_caesug_4, t0.tarif_caesug_jeune AS tarif_caesug_jeune_5, t0.tarif_invite AS tarif_invite_6, t0.tarif_invite_jeune AS tarif_invite_jeune_7, t0.couleur AS couleur_8, t0.carte_usca AS carte_usca_9, t0.responsable_id AS responsable_id_10 FROM type_sortie t0 WHERE t0.libelle = ? LIMIT 1
Parameters:
[
  "Ski Dimanche"
]
3 0.23 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.destination AS destination_3, t0.heure_depart AS heure_depart_4, t0.heure_depart_station AS heure_depart_station_5, t0.heure_rdv AS heure_rdv_6, t0.lieu AS lieu_7, t0.etat AS etat_8, t0.nb_places_bus AS nb_places_bus_9, t0.heure_retour AS heure_retour_10, t0.description AS description_11, t0.active AS active_12, t0.type_sortie_id AS type_sortie_id_13, t0.responsable_id AS responsable_id_14 FROM sortie t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "365"
]
4 0.20 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.destination AS destination_3, t0.heure_depart AS heure_depart_4, t0.heure_depart_station AS heure_depart_station_5, t0.heure_rdv AS heure_rdv_6, t0.lieu AS lieu_7, t0.etat AS etat_8, t0.nb_places_bus AS nb_places_bus_9, t0.heure_retour AS heure_retour_10, t0.description AS description_11, t0.active AS active_12, t0.type_sortie_id AS type_sortie_id_13, t0.responsable_id AS responsable_id_14 FROM sortie t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "365"
]
5 0.23 ms
SELECT t0.id AS id_1, t0.date_inscription AS date_inscription_2, t0.utilisateur_participe AS utilisateur_participe_3, t0.cours AS cours_4, t0.niveau AS niveau_5, t0.est_handiski AS est_handiski_6, t0.telephone_autre AS telephone_autre_7, t0.inscrit_id AS inscrit_id_8, t0.sortie_id AS sortie_id_9 FROM inscription t0 WHERE t0.sortie_id = ?
Parameters:
[
  365
]
6 0.18 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?
Parameters:
[
  "xavier.espinosa@univ-grenoble-alpes.fr"
]
7 0.17 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1368
]
8 0.15 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1370
]
9 0.16 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?
Parameters:
[
  "nicolas.ferran@univ-grenoble-alpes.fr"
]
10 0.15 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1371
]
11 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1372
]
12 0.15 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?
Parameters:
[
  "jfmotte@sfr.fr"
]
13 0.15 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1375
]
14 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1376
]
15 0.14 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?
Parameters:
[
  "cedrixcc@gmail.com"
]
16 0.15 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1380
]
17 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1383
]
18 0.14 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?
Parameters:
[
  "koteva.k.i@gmail.com"
]
19 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1388
]
20 0.15 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1391
]
21 0.15 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?
Parameters:
[
  "sophie.prima@grenoble-inp.fr"
]
22 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1402
]
23 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1403
]
24 0.14 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?
Parameters:
[
  "bastien.brouant@univ-grenoble-alpes.fr"
]
25 0.15 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1411
]
26 0.14 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?
Parameters:
[
  "starclusterix@gmail.com"
]
27 0.15 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1412
]
28 0.14 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?
Parameters:
[
  "eleonor.sartori@gmail.com"
]
29 0.19 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1414
]
30 0.14 ms
SELECT t0.email AS email_1, t0.roles AS roles_2, t0.password AS password_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.telephone AS telephone_6, t0.date_creation AS date_creation_7, t0.est_invite AS est_invite_8 FROM utilisateur t0 WHERE t0.email = ?
Parameters:
[
  "sylvie.jacob@univ-grenoble-alpes.fr"
]
31 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1415
]
32 0.14 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.type AS type_4, t0.cours AS cours_5, t0.niveau AS niveau_6, t0.est_handiski AS est_handiski_7, t0.inscription_id AS inscription_id_8 FROM participant t0 WHERE t0.inscription_id = ?
Parameters:
[
  1468
]

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\Participant 28
App\Entity\Utilisateur 18
App\Entity\Inscription 17
App\Entity\Responsable 2
App\Entity\TypeSortie 1
App\Entity\Sortie 1

Entities Mapping

Class Mapping errors
App\Entity\Utilisateur No errors.
App\Entity\Inscription No errors.
App\Entity\TypeSortie No errors.
App\Entity\Responsable No errors.
App\Entity\Sortie No errors.
App\Entity\Participant No errors.