https://card.dev.smartegy.ca/editer-session/11 Return to referer URL

Query Metrics

9 Database Queries
9 Different statements
4.65 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.68 ms
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
]
2 0.36 ms
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"
]
3 0.38 ms
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
]
4 0.46 ms
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
]
5 0.32 ms
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
]
6 0.30 ms
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"
]
7 0.27 ms
"START TRANSACTION"
Parameters:
[]
8 0.26 ms
UPDATE session SET datefin = ? WHERE id = ?
Parameters:
[
  "2024-12-27"
  11
]
9 1.61 ms
"COMMIT"
Parameters:
[]

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.