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

Query Metrics

20 Database Queries
8 Different statements
16.31 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 2.82 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.est_genere AS est_genere_5 FROM progression t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
2 1.58 ms
SELECT t0.id AS id_1, t0.jour AS jour_2, t0.duree AS duree_3, t0.ref_matiere_id AS ref_matiere_id_4 FROM bloc_heure t0 INNER JOIN progression_bloc_heure ON t0.id = progression_bloc_heure.bloc_heure_id WHERE progression_bloc_heure.progression_id = ?
Parameters:
[
  1
]
3 1.52 ms
SELECT t0.id AS id_1, t0.debut AS debut_2, t0.fin AS fin_3, t0.ref_periode_type_id AS ref_periode_type_id_4 FROM periode_cle t0 INNER JOIN progression_periode_cle ON t0.id = progression_periode_cle.periode_cle_id WHERE progression_periode_cle.progression_id = ?
Parameters:
[
  1
]
4 0.69 ms
SELECT b0_.id AS id_0, b0_.jour AS jour_1, b0_.duree AS duree_2, b0_.ref_matiere_id AS ref_matiere_id_3 FROM bloc_heure b0_
Parameters:
[]
5 0.61 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ref_filere_id AS ref_filere_id_3 FROM matiere t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.61 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM filiere t0 WHERE t0.id = ?
Parameters:
[
  1
]
7 0.62 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ref_filere_id AS ref_filere_id_3 FROM matiere t0 WHERE t0.id = ?
Parameters:
[
  3
]
8 0.60 ms
SELECT p0_.id AS id_0, p0_.debut AS debut_1, p0_.fin AS fin_2, p0_.ref_periode_type_id AS ref_periode_type_id_3 FROM periode_cle p0_
Parameters:
[]
9 0.65 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.60 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  3
]
11 0.59 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  2
]
12 0.62 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  4
]
13 0.59 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  5
]
14 0.59 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  6
]
15 0.59 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  7
]
16 0.63 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  8
]
17 0.59 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  9
]
18 0.62 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  11
]
19 0.58 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  10
]
20 0.62 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.avoir_cours AS avoir_cours_3, t0.couleur AS couleur_4 FROM periode_type t0 WHERE t0.id = ?
Parameters:
[
  12
]

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\Progression No errors.
App\Entity\BlocHeure No errors.
App\Entity\PeriodeCle No errors.
App\Entity\ProgressionDetail No errors.
App\Entity\Matiere No errors.
App\Entity\PeriodeType No errors.
App\Entity\Filiere No errors.
App\Entity\Sequence No errors.