Query Metrics
9
Database Queries
9
Different statements
4.65 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.61 ms (34.61%) |
1 |
"COMMIT"
Parameters:
[] |
0.68 ms (14.73%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.role AS role_5, t0.nom AS nom_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
8
]
|
0.46 ms (9.99%) |
1 |
SELECT m0_.id AS id_0, m0_.membre_id AS membre_id_1, m0_.seance_id AS seance_id_2, m0_.suivienseignement_id AS suivienseignement_id_3 FROM membre_seance_suivi_ens m0_ INNER JOIN seance s1_ ON m0_.seance_id = s1_.id INNER JOIN session s2_ ON s1_.sessions_id = s2_.id WHERE s2_.id = ?
Parameters:
[
11
]
|
0.38 ms (8.09%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.jour AS jour_3, t0.heuredebut AS heuredebut_4, t0.heurefin AS heurefin_5, t0.typeseance AS typeseance_6, t0.semainendps AS semainendps_7, t0.sessions_id AS sessions_id_8 FROM seance t0 WHERE t0.sessions_id = ?
Parameters:
[
11
]
|
0.36 ms (7.77%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.datedebut AS datedebut_4, t0.datefin AS datefin_5, t0.nbrmaxparticipants AS nbrmaxparticipants_6, t0.programme_id AS programme_id_7 FROM session t0 WHERE t0.id = ?
Parameters:
[
"11"
]
|
0.32 ms (6.89%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.seance AS seance_4, t0.trancheage_id AS trancheage_id_5 FROM programme t0 WHERE t0.id = ?
Parameters:
[
4
]
|
0.30 ms (6.42%) |
1 |
SELECT p0_.id AS id_0, p0_.nom AS nom_1, p0_.description AS description_2, p0_.seance AS seance_3, p0_.trancheage_id AS trancheage_id_4 FROM programme p0_ WHERE p0_.id IN (?)
Parameters:
[
"4"
]
|
0.27 ms (5.90%) |
1 |
"START TRANSACTION"
Parameters:
[] |
0.26 ms (5.60%) |
1 |
UPDATE session SET datefin = ? WHERE id = ?
Parameters:
[ "2024-12-27" 11 ] |
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\User | No errors. |
App\Entity\Suivi | No errors. |
App\Entity\Session | No errors. |
App\Entity\Programme | No errors. |
App\Entity\Seance | No errors. |
App\Entity\SeanceDetail | No errors. |
App\Entity\MembreSeanceSuiviEns | No errors. |
App\Entity\Membre | No errors. |
App\Entity\SuivieEnseignement | No errors. |
App\Entity\TrancheAge | No errors. |