Query Metrics

28 Database Queries
8 Different statements
9.20 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.88 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.ignore_paiement AS ignore_paiement_8, t0.archive AS archive_9, t0.token AS token_10 FROM user t0 WHERE t0.token = ? LIMIT 1
Parameters:
[
  "5688600bf1330fc342e8b9c569045e56"
]
2 0.49 ms
SELECT t0.id AS id_1, t0.user_temp AS user_temp_2, t0.nb_places AS nb_places_3, t0.payer AS payer_4, t0.created AS created_5, t0.type AS type_6, t0.total AS total_7, t0.token AS token_8, t0.user_id AS user_id_9, t0.evenements_id AS evenements_id_10, t0.categories_evenements_id AS categories_evenements_id_11 FROM reservations t0 WHERE t0.user_id = ? AND t0.payer = ?
Parameters:
[
  300
  0
]
3 0.24 ms
"START TRANSACTION"
Parameters:
[]
4 0.33 ms
UPDATE reservations SET payer = ? WHERE id = ?
Parameters:
[
  1
  722
]
5 0.27 ms
"COMMIT"
Parameters:
[]
6 0.53 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.image AS image_4, t0.date AS date_5, t0.billeterie AS billeterie_6, t0.lieu AS lieu_7, t0.nb_places AS nb_places_8, t0.prix AS prix_9, t0.archive AS archive_10, t0.resume AS resume_11, t0.heure AS heure_12, t0.categories_evenements_id AS categories_evenements_id_13, t0.evenements_id AS evenements_id_14 FROM evenements t0 WHERE t0.id = ?
Parameters:
[
  31
]
7 0.30 ms
"START TRANSACTION"
Parameters:
[]
8 0.48 ms
UPDATE evenements SET nb_places = ? WHERE id = ?
Parameters:
[
  145
  31
]
9 0.34 ms
"COMMIT"
Parameters:
[]
10 0.54 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.image AS image_4, t0.date AS date_5, t0.billeterie AS billeterie_6, t0.lieu AS lieu_7, t0.nb_places AS nb_places_8, t0.prix AS prix_9, t0.archive AS archive_10, t0.resume AS resume_11, t0.heure AS heure_12, t0.categories_evenements_id AS categories_evenements_id_13, t0.evenements_id AS evenements_id_14 FROM evenements t0 WHERE t0.evenements_id = ?
Parameters:
[
  31
]
11 0.23 ms
"START TRANSACTION"
Parameters:
[]
12 0.33 ms
UPDATE evenements SET nb_places = ? WHERE id = ?
Parameters:
[
  136
  32
]
13 0.29 ms
"COMMIT"
Parameters:
[]
14 0.21 ms
"START TRANSACTION"
Parameters:
[]
15 0.30 ms
UPDATE evenements SET nb_places = ? WHERE id = ?
Parameters:
[
  142
  33
]
16 0.34 ms
"COMMIT"
Parameters:
[]
17 0.22 ms
"START TRANSACTION"
Parameters:
[]
18 0.29 ms
UPDATE evenements SET nb_places = ? WHERE id = ?
Parameters:
[
  117
  34
]
19 0.25 ms
"COMMIT"
Parameters:
[]
20 0.21 ms
"START TRANSACTION"
Parameters:
[]
21 0.30 ms
UPDATE evenements SET nb_places = ? WHERE id = ?
Parameters:
[
  137
  35
]
22 0.26 ms
"COMMIT"
Parameters:
[]
23 0.20 ms
"START TRANSACTION"
Parameters:
[]
24 0.28 ms
UPDATE evenements SET nb_places = ? WHERE id = ?
Parameters:
[
  135
  36
]
25 0.27 ms
"COMMIT"
Parameters:
[]
26 0.20 ms
"START TRANSACTION"
Parameters:
[]
27 0.27 ms
UPDATE evenements SET nb_places = ? WHERE id = ?
Parameters:
[
  133
  37
]
28 0.32 ms
"COMMIT"
Parameters:
[]

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\Articles No errors.
App\Entity\Evenements No errors.
App\Entity\Reservations No errors.
App\Entity\User No errors.
App\Entity\CategoriesEvenements No errors.