Query Metrics
9
Database Queries
8
Different statements
11.71 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.01 ms |
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:
[
"41"
]
|
| 2 | 1.97 ms |
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:
[
41
]
|
| 3 | 2.04 ms |
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:
[
41
]
|
| 4 | 2.13 ms |
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:
[
41
]
|
| 5 | 0.91 ms |
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
]
|
| 6 | 1.01 ms |
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
]
|
| 7 | 0.88 ms |
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
]
|
| 8 | 0.82 ms |
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:
[
2
]
|
| 9 | 0.95 ms |
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. |