https://www.lions-laclaireau.be/validation-de-la-commande/13?p=validation-de-la-commande%2F13

Query Metrics

18 Database Queries
8 Different statements
6.56 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.67 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.id = ?
Parameters:
[
  13
]
2 0.47 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:
[
  "13"
  0
]
3 0.42 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:
[
  36
]
4 0.29 ms
"START TRANSACTION"
Parameters:
[]
5 0.28 ms
UPDATE evenements SET nb_places = ? WHERE id = ?
Parameters:
[
  138
  36
]
6 0.28 ms
"COMMIT"
Parameters:
[]
7 0.21 ms
"START TRANSACTION"
Parameters:
[]
8 0.26 ms
UPDATE reservations SET payer = ? WHERE id = ?
Parameters:
[
  1
  715
]
9 0.24 ms
"COMMIT"
Parameters:
[]
10 0.36 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:
[
  36
]
11 1.07 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:
[
  37
]
12 0.23 ms
"START TRANSACTION"
Parameters:
[]
13 0.37 ms
UPDATE evenements SET nb_places = ? WHERE id = ?
Parameters:
[
  136
  37
]
14 0.31 ms
"COMMIT"
Parameters:
[]
15 0.19 ms
"START TRANSACTION"
Parameters:
[]
16 0.29 ms
UPDATE reservations SET payer = ? WHERE id = ?
Parameters:
[
  1
  716
]
17 0.25 ms
"COMMIT"
Parameters:
[]
18 0.37 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:
[
  37
]

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