https://progression.seblemoine.fr/sequence/1/edit

Query Metrics

10 Database Queries
10 Different statements
6.96 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.70 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:
[
  "1"
]
2 0.69 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.64 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM filiere t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 0.62 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:
[
  1
]
5 0.68 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:
[
  1
]
6 1.08 ms
SELECT t0.id AS id_1, t0.theme AS theme_2 FROM theme_sequence t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.61 ms
SELECT f0_.id AS id_0, f0_.libelle AS libelle_1 FROM filiere f0_
Parameters:
[]
8 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_.id NOT IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17)
Parameters:
[]
9 0.65 ms
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1 FROM savoir_technologique s0_
Parameters:
[]
10 0.60 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.