https://progression.seblemoine.fr/seance/40

Query Metrics

9 Database Queries
8 Different statements
33.12 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
17.67 ms
(53.34%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.ref_competence_id AS ref_competence_id_4 FROM competence t0 INNER JOIN seance_competence ON t0.id = seance_competence.competence_id WHERE seance_competence.seance_id = ?
Parameters:
[
  40
]
6.60 ms
(19.93%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.ref_competence_id AS ref_competence_id_4 FROM competence t0 INNER JOIN sequence_competence ON t0.id = sequence_competence.competence_id WHERE sequence_competence.sequence_id = ?
Parameters:
[
  5
]
2.37 ms
(7.15%)
1
SELECT t0.id AS id_1, t0.phase AS phase_2, t0.duree AS duree_3, t0.materiel AS materiel_4, t0.deroulement AS deroulement_5, t0.activite_eleve AS activite_eleve_6, t0.activite_prof AS activite_prof_7, t0.ref_seance_id AS ref_seance_id_8 FROM seance_detail t0 WHERE t0.ref_seance_id = ? ORDER BY t0.phase ASC
Parameters:
[
  40
]
1.84 ms
(5.57%)
2
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3, t0.ref_competence_id AS ref_competence_id_4 FROM competence t0 WHERE t0.id = ?
Parameters:
[
  10
]
1.82 ms
(5.50%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM savoir_technologique t0 INNER JOIN seance_savoir_technologique ON t0.id = seance_savoir_technologique.savoir_technologique_id WHERE seance_savoir_technologique.seance_id = ?
Parameters:
[
  40
]
1.01 ms
(3.05%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.duree AS duree_3, t0.objectif_intermediaire AS objectif_intermediaire_4, t0.prerequis AS prerequis_5, t0.deroule AS deroule_6, t0.ressources_fournies AS ressources_fournies_7, t0.remarque AS remarque_8, t0.organisation AS organisation_9, t0.etape AS etape_10, t0.bloom AS bloom_11, t0.ref_sequence_id AS ref_sequence_id_12, t0.ref_theme_seance_id AS ref_theme_seance_id_13 FROM seance t0 WHERE t0.id = ?
Parameters:
[
  "40"
]
0.93 ms
(2.81%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.objectif AS objectif_3, t0.attendu AS attendu_4, t0.prerequis AS prerequis_5, t0.periode AS periode_6, t0.bilan AS bilan_7, t0.ref_filiere_id AS ref_filiere_id_8, t0.ref_theme_sequence_id AS ref_theme_sequence_id_9 FROM sequence t0 WHERE t0.id = ?
Parameters:
[
  5
]
0.88 ms
(2.65%)
1
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM savoir_technologique t0 INNER JOIN sequence_savoir_technologique ON t0.id = sequence_savoir_technologique.savoir_technologique_id WHERE sequence_savoir_technologique.sequence_id = ?
Parameters:
[
  5
]

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\Seance No errors.
App\Entity\Sequence No errors.
App\Entity\ThemeSeance No errors.
App\Entity\Competence No errors.
App\Entity\SavoirTechnologique No errors.
App\Entity\SeanceDetail No errors.
App\Entity\Filiere No errors.
App\Entity\ThemeSequence No errors.