Query Metrics
10
Database Queries
10
Different statements
7.39 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.07 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:
[
"11"
]
|
| 2 | 0.70 ms |
SELECT c0_.id AS id_0, c0_.libelle AS libelle_1, c0_.code AS code_2, c0_.ref_competence_id AS ref_competence_id_3 FROM competence c0_ WHERE c0_.ref_competence_id IS NOT NULL
Parameters:
[] |
| 3 | 0.62 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM filiere t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 4 | 0.63 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:
[
11
]
|
| 5 | 0.63 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:
[
11
]
|
| 6 | 0.61 ms |
SELECT t0.id AS id_1, t0.theme AS theme_2 FROM theme_sequence t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 7 | 0.62 ms |
SELECT f0_.id AS id_0, f0_.libelle AS libelle_1 FROM filiere f0_
Parameters:
[] |
| 8 | 0.67 ms |
SELECT c0_.id AS id_0, c0_.libelle AS libelle_1, c0_.code AS code_2, c0_.ref_competence_id AS ref_competence_id_3 FROM competence c0_ WHERE c0_.id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)
Parameters:
[] |
| 9 | 1.08 ms |
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1 FROM savoir_technologique s0_
Parameters:
[] |
| 10 | 0.76 ms |
SELECT t0_.id AS id_0, t0_.theme AS theme_1 FROM theme_sequence t0_
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\Sequence | No errors. |
| App\Entity\Filiere | No errors. |
| App\Entity\ThemeSequence | No errors. |
| App\Entity\Seance | No errors. |
| App\Entity\Competence | No errors. |
| App\Entity\SavoirTechnologique | No errors. |