Query Metrics
9
Database Queries
8
Different statements
10.13 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.66 ms (16.42%) |
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.61 ms (15.92%) |
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:
[
29
]
|
|
1.59 ms (15.64%) |
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:
[
"29"
]
|
|
1.45 ms (14.26%) |
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:
[
29
]
|
|
1.44 ms (14.16%) |
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:
[
29
]
|
|
0.87 ms (8.55%) |
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:
[
4
]
|
|
0.86 ms (8.49%) |
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:
[
4
]
|
|
0.66 ms (6.56%) |
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:
[
4
]
|
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. |