https://www.lions-laclaireau.be/reservations/34?p=reservations%2F34

Query Metrics

8 Database Queries
5 Different statements
4.01 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.91 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:
[
  "34"
]
2 0.49 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 = ? LIMIT 1
Parameters:
[
  "34"
]
3 0.54 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.evenements_id = ? AND t0.payer = ?
Parameters:
[
  34
  1
]
4 0.57 ms
SELECT r0_.id AS id_0, r0_.user_temp AS user_temp_1, r0_.nb_places AS nb_places_2, r0_.payer AS payer_3, r0_.created AS created_4, r0_.type AS type_5, r0_.total AS total_6, r0_.token AS token_7, r0_.user_id AS user_id_8, r0_.evenements_id AS evenements_id_9, r0_.categories_evenements_id AS categories_evenements_id_10 FROM reservations r0_ WHERE r0_.created >= ? AND r0_.created <= ? AND r0_.categories_evenements_id = 8 AND r0_.payer = 1 AND r0_.type = ? ORDER BY r0_.id ASC
Parameters:
[
  "2026-01-01 00:00:00"
  "2026-02-22 00:00:00"
  "abonnement"
]
5 0.51 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:
[
  193
]
6 0.36 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:
[
  18
]
7 0.32 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
]
8 0.31 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:
[
  290
]

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