Query Metrics
28
Database Queries
8
Different statements
9.20 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.36 ms (25.61%) |
8 |
"COMMIT"
Parameters:
[] |
|
2.25 ms (24.41%) |
7 |
UPDATE evenements SET nb_places = ? WHERE id = ?
Parameters:
[ 145 31 ] |
|
1.82 ms (19.79%) |
8 |
"START TRANSACTION"
Parameters:
[] |
|
0.88 ms (9.57%) |
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.token = ? LIMIT 1
Parameters:
[
"5688600bf1330fc342e8b9c569045e56"
]
|
|
0.54 ms (5.91%) |
1 |
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
]
|
|
0.53 ms (5.77%) |
1 |
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
]
|
|
0.49 ms (5.37%) |
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:
[ 300 0 ] |
|
0.33 ms (3.58%) |
1 |
UPDATE reservations SET payer = ? WHERE id = ?
Parameters:
[ 1 722 ] |
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. |