https://progression.seblemoine.fr/progression/detail/new/1

Query Metrics

19 Database Queries
7 Different statements
13.62 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.73 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.12 ms
SELECT s0_.id AS id_0, s0_.titre AS titre_1, s0_.duree AS duree_2, s0_.objectif_intermediaire AS objectif_intermediaire_3, s0_.prerequis AS prerequis_4, s0_.deroule AS deroule_5, s0_.ressources_fournies AS ressources_fournies_6, s0_.remarque AS remarque_7, s0_.organisation AS organisation_8, s0_.etape AS etape_9, s0_.bloom AS bloom_10, s0_.ref_sequence_id AS ref_sequence_id_11, s0_.ref_theme_seance_id AS ref_theme_seance_id_12 FROM seance s0_
Parameters:
[]
3 0.77 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:
[]
4 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:
[
  1
]
5 0.61 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
]
6 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:
[
  2
]
7 0.61 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
]
8 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
]
9 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:
[
  6
]
10 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
]
11 0.61 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
]
12 0.68 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
]
13 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:
[
  11
]
14 0.71 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
]
15 0.61 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
]
16 0.66 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:
[]
17 0.65 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
]
18 0.63 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM filiere t0 WHERE t0.id = ?
Parameters:
[
  1
]
19 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:
[
  3
]

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\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\PeriodeType No errors.
App\Entity\Matiere No errors.
App\Entity\Filiere No errors.