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

Grouped Statements

Show all queries

Time Count Info
1.49 ms
(22.68%)
2
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
]
1.08 ms
(16.40%)
4
"COMMIT"
Parameters:
[]
0.93 ms
(14.20%)
4
"START TRANSACTION"
Parameters:
[]
0.72 ms
(10.98%)
2
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
]
0.67 ms
(10.20%)
1
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
]
0.65 ms
(9.87%)
2
UPDATE evenements SET nb_places = ? WHERE id = ?
Parameters:
[
  138
  36
]
0.56 ms
(8.50%)
2
UPDATE reservations SET payer = ? WHERE id = ?
Parameters:
[
  1
  715
]
0.47 ms
(7.18%)
1
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
]

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.