https://www.lions-laclaireau.be/evenements/?p=evenements%2F

Query Metrics

16 Database Queries
4 Different statements
8.22 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.84 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:
[
  9
]
2 0.85 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.archive = ?
Parameters:
[
  0
]
3 0.48 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 = ?
Parameters:
[
  31
]
4 0.34 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.prix_abo AS prix_abo_3, t0.ordre AS ordre_4 FROM categories_evenements t0 WHERE t0.id = ?
Parameters:
[
  8
]
5 0.50 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 = ?
Parameters:
[
  32
]
6 0.50 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 = ?
Parameters:
[
  31
]
7 0.45 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 = ?
Parameters:
[
  33
]
8 0.44 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 = ?
Parameters:
[
  31
]
9 0.46 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 = ?
Parameters:
[
  34
]
10 0.44 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 = ?
Parameters:
[
  31
]
11 0.60 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 = ?
Parameters:
[
  35
]
12 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 = ?
Parameters:
[
  31
]
13 0.43 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 = ?
Parameters:
[
  36
]
14 0.45 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 = ?
Parameters:
[
  31
]
15 0.42 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 = ?
Parameters:
[
  37
]
16 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.evenements_id = ?
Parameters:
[
  31
]

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.