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

Query Metrics

33 Database Queries
4 Different statements
41.01 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.94 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 3.05 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.jour AS jour_3, t0.ref_seance_id AS ref_seance_id_4, t0.ref_periode_cle_id AS ref_periode_cle_id_5, t0.ref_bloc_heure_id AS ref_bloc_heure_id_6, t0.ref_progression_id AS ref_progression_id_7 FROM progression_detail t0 WHERE t0.ref_progression_id = ?
Parameters:
[
  1
]
3 1.62 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 WHERE t0.id = ?
Parameters:
[
  13
]
4 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
]
5 1.53 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 WHERE t0.id = ?
Parameters:
[
  15
]
6 0.66 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
]
7 1.13 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 WHERE t0.id = ?
Parameters:
[
  1
]
8 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:
[
  1
]
9 1.08 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 WHERE t0.id = ?
Parameters:
[
  7
]
10 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:
[
  2
]
11 1.20 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 WHERE t0.id = ?
Parameters:
[
  11
]
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:
[
  7
]
13 1.19 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 WHERE t0.id = ?
Parameters:
[
  2
]
14 0.82 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
]
15 1.42 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 WHERE t0.id = ?
Parameters:
[
  3
]
16 1.77 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 WHERE t0.id = ?
Parameters:
[
  18
]
17 1.38 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 2.58 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 WHERE t0.id = ?
Parameters:
[
  17
]
19 1.63 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 WHERE t0.id = ?
Parameters:
[
  4
]
20 0.80 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
]
21 1.68 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 WHERE t0.id = ?
Parameters:
[
  19
]
22 0.81 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
]
23 1.69 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 WHERE t0.id = ?
Parameters:
[
  20
]
24 1.60 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 WHERE t0.id = ?
Parameters:
[
  21
]
25 0.74 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
]
26 1.41 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 WHERE t0.id = ?
Parameters:
[
  16
]
27 1.27 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 WHERE t0.id = ?
Parameters:
[
  12
]
28 1.30 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 WHERE t0.id = ?
Parameters:
[
  5
]
29 0.69 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
]
30 1.33 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 WHERE t0.id = ?
Parameters:
[
  6
]
31 1.21 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 WHERE t0.id = ?
Parameters:
[
  9
]
32 1.25 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 WHERE t0.id = ?
Parameters:
[
  10
]
33 0.69 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
]

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\PeriodeType No errors.