Query Metrics
24
Database Queries
7
Different statements
10.23 ms
Query time
4
Invalid entities
39
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.75 ms |
SELECT t0.id AS id_1, t0.date_debut AS date_debut_2, t0.date_fin AS date_fin_3, t0.annee AS annee_4, t0.statut AS statut_5, t0.resultat AS resultat_6, t0.fichier AS fichier_7 FROM annee_scolaire t0 ORDER BY t0.id DESC
Parameters:
[] |
| 2 | 0.59 ms |
SELECT t0.id AS id_1, t0.code_inscription AS code_inscription_2, t0.date_inscription AS date_inscription_3, t0.frais_inscription AS frais_inscription_4, t0.statut AS statut_5, t0.statut_frais AS statut_frais_6, t0.frais_scolarite AS frais_scolarite_7, t0.reduction AS reduction_8, t0.user AS user_9, t0.annee_scolaire_id AS annee_scolaire_id_10, t0.eleve_id AS eleve_id_11, t0.classe_id AS classe_id_12 FROM inscription t0 WHERE t0.annee_scolaire_id = ?
Parameters:
[
1
]
|
| 3 | 0.42 ms |
SELECT t0.id AS id_1, t0.capacite_accueil AS capacite_accueil_2, t0.libelle AS libelle_3, t0.niveau_enseignement AS niveau_enseignement_4, t0.niveau_id AS niveau_id_5 FROM classe t0 WHERE t0.id = ?
Parameters:
[
13
]
|
| 4 | 0.60 ms |
SELECT n0_.id AS id_0, n0_.semestre AS semestre_1, n0_.note AS note_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.user AS user_5, n0_.inscription_id AS inscription_id_6, n0_.annee_scolaire_id AS annee_scolaire_id_7, n0_.classe_id AS classe_id_8, n0_.cours_id AS cours_id_9 FROM note n0_ INNER JOIN annee_scolaire a1_ ON n0_.annee_scolaire_id = a1_.id INNER JOIN inscription i2_ ON n0_.inscription_id = i2_.id WHERE a1_.statut = ? AND i2_.code_inscription = ? AND n0_.semestre = ?
Parameters:
[ 1 "I2026E1" "Semestre_1" ] |
| 5 | 0.44 ms |
SELECT n0_.id AS id_0, n0_.semestre AS semestre_1, n0_.note AS note_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.user AS user_5, n0_.inscription_id AS inscription_id_6, n0_.annee_scolaire_id AS annee_scolaire_id_7, n0_.classe_id AS classe_id_8, n0_.cours_id AS cours_id_9 FROM note n0_ INNER JOIN annee_scolaire a1_ ON n0_.annee_scolaire_id = a1_.id INNER JOIN inscription i2_ ON n0_.inscription_id = i2_.id WHERE a1_.statut = ? AND i2_.code_inscription = ? AND n0_.semestre = ?
Parameters:
[ 1 "I2026E1" "Semestre_2" ] |
| 6 | 0.44 ms |
SELECT t0.id AS id_1, t0.nombre_heure AS nombre_heure_2, t0.coefficient AS coefficient_3, t0.matiere_id AS matiere_id_4, t0.classe_id AS classe_id_5, t0.enseignant_id AS enseignant_id_6 FROM cours t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 7 | 0.32 ms |
SELECT t0.id AS id_1, t0.nombre_heure AS nombre_heure_2, t0.coefficient AS coefficient_3, t0.matiere_id AS matiere_id_4, t0.classe_id AS classe_id_5, t0.enseignant_id AS enseignant_id_6 FROM cours t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 8 | 0.48 ms |
SELECT n0_.id AS id_0, n0_.semestre AS semestre_1, n0_.note AS note_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.user AS user_5, n0_.inscription_id AS inscription_id_6, n0_.annee_scolaire_id AS annee_scolaire_id_7, n0_.classe_id AS classe_id_8, n0_.cours_id AS cours_id_9 FROM note n0_ INNER JOIN annee_scolaire a1_ ON n0_.annee_scolaire_id = a1_.id INNER JOIN inscription i2_ ON n0_.inscription_id = i2_.id WHERE a1_.statut = ? AND i2_.code_inscription = ? AND n0_.semestre = ?
Parameters:
[ 1 "I2026E2" "Semestre_1" ] |
| 9 | 0.48 ms |
SELECT n0_.id AS id_0, n0_.semestre AS semestre_1, n0_.note AS note_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.user AS user_5, n0_.inscription_id AS inscription_id_6, n0_.annee_scolaire_id AS annee_scolaire_id_7, n0_.classe_id AS classe_id_8, n0_.cours_id AS cours_id_9 FROM note n0_ INNER JOIN annee_scolaire a1_ ON n0_.annee_scolaire_id = a1_.id INNER JOIN inscription i2_ ON n0_.inscription_id = i2_.id WHERE a1_.statut = ? AND i2_.code_inscription = ? AND n0_.semestre = ?
Parameters:
[ 1 "I2026E2" "Semestre_2" ] |
| 10 | 0.35 ms |
SELECT t0.id AS id_1, t0.capacite_accueil AS capacite_accueil_2, t0.libelle AS libelle_3, t0.niveau_enseignement AS niveau_enseignement_4, t0.niveau_id AS niveau_id_5 FROM classe t0 WHERE t0.id = ?
Parameters:
[
14
]
|
| 11 | 0.44 ms |
SELECT n0_.id AS id_0, n0_.semestre AS semestre_1, n0_.note AS note_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.user AS user_5, n0_.inscription_id AS inscription_id_6, n0_.annee_scolaire_id AS annee_scolaire_id_7, n0_.classe_id AS classe_id_8, n0_.cours_id AS cours_id_9 FROM note n0_ INNER JOIN annee_scolaire a1_ ON n0_.annee_scolaire_id = a1_.id INNER JOIN inscription i2_ ON n0_.inscription_id = i2_.id WHERE a1_.statut = ? AND i2_.code_inscription = ? AND n0_.semestre = ?
Parameters:
[ 1 "I2026E3" "Semestre_1" ] |
| 12 | 0.47 ms |
SELECT n0_.id AS id_0, n0_.semestre AS semestre_1, n0_.note AS note_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.user AS user_5, n0_.inscription_id AS inscription_id_6, n0_.annee_scolaire_id AS annee_scolaire_id_7, n0_.classe_id AS classe_id_8, n0_.cours_id AS cours_id_9 FROM note n0_ INNER JOIN annee_scolaire a1_ ON n0_.annee_scolaire_id = a1_.id INNER JOIN inscription i2_ ON n0_.inscription_id = i2_.id WHERE a1_.statut = ? AND i2_.code_inscription = ? AND n0_.semestre = ?
Parameters:
[ 1 "I2026E3" "Semestre_2" ] |
| 13 | 0.34 ms |
SELECT t0.id AS id_1, t0.nombre_heure AS nombre_heure_2, t0.coefficient AS coefficient_3, t0.matiere_id AS matiere_id_4, t0.classe_id AS classe_id_5, t0.enseignant_id AS enseignant_id_6 FROM cours t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 14 | 0.31 ms |
SELECT t0.id AS id_1, t0.nombre_heure AS nombre_heure_2, t0.coefficient AS coefficient_3, t0.matiere_id AS matiere_id_4, t0.classe_id AS classe_id_5, t0.enseignant_id AS enseignant_id_6 FROM cours t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 15 | 0.31 ms |
SELECT t0.id AS id_1, t0.capacite_accueil AS capacite_accueil_2, t0.libelle AS libelle_3, t0.niveau_enseignement AS niveau_enseignement_4, t0.niveau_id AS niveau_id_5 FROM classe t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 16 | 0.45 ms |
SELECT n0_.id AS id_0, n0_.semestre AS semestre_1, n0_.note AS note_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.user AS user_5, n0_.inscription_id AS inscription_id_6, n0_.annee_scolaire_id AS annee_scolaire_id_7, n0_.classe_id AS classe_id_8, n0_.cours_id AS cours_id_9 FROM note n0_ INNER JOIN annee_scolaire a1_ ON n0_.annee_scolaire_id = a1_.id INNER JOIN inscription i2_ ON n0_.inscription_id = i2_.id WHERE a1_.statut = ? AND i2_.code_inscription = ? AND n0_.semestre = ?
Parameters:
[ 1 "I2026E4" "Semestre_1" ] |
| 17 | 0.43 ms |
SELECT n0_.id AS id_0, n0_.semestre AS semestre_1, n0_.note AS note_2, n0_.created_at AS created_at_3, n0_.updated_at AS updated_at_4, n0_.user AS user_5, n0_.inscription_id AS inscription_id_6, n0_.annee_scolaire_id AS annee_scolaire_id_7, n0_.classe_id AS classe_id_8, n0_.cours_id AS cours_id_9 FROM note n0_ INNER JOIN annee_scolaire a1_ ON n0_.annee_scolaire_id = a1_.id INNER JOIN inscription i2_ ON n0_.inscription_id = i2_.id WHERE a1_.statut = ? AND i2_.code_inscription = ? AND n0_.semestre = ?
Parameters:
[ 1 "I2026E4" "Semestre_2" ] |
| 18 | 0.53 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.date_naissance AS date_naissance_4, t0.adresse AS adresse_5, t0.email AS email_6, t0.telephone AS telephone_7, t0.genre AS genre_8, t0.lieu_naissance AS lieu_naissance_9, t0.photo AS photo_10, t0.nom_complet_tuteur AS nom_complet_tuteur_11, t0.email_tuteur AS email_tuteur_12, t0.telephone_tuteur AS telephone_tuteur_13, t0.user AS user_14 FROM eleve t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 19 | 0.40 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM niveau t0 WHERE t0.id = ?
Parameters:
[
12
]
|
| 20 | 0.35 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.date_naissance AS date_naissance_4, t0.adresse AS adresse_5, t0.email AS email_6, t0.telephone AS telephone_7, t0.genre AS genre_8, t0.lieu_naissance AS lieu_naissance_9, t0.photo AS photo_10, t0.nom_complet_tuteur AS nom_complet_tuteur_11, t0.email_tuteur AS email_tuteur_12, t0.telephone_tuteur AS telephone_tuteur_13, t0.user AS user_14 FROM eleve t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 21 | 0.29 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM niveau t0 WHERE t0.id = ?
Parameters:
[
13
]
|
| 22 | 0.35 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.date_naissance AS date_naissance_4, t0.adresse AS adresse_5, t0.email AS email_6, t0.telephone AS telephone_7, t0.genre AS genre_8, t0.lieu_naissance AS lieu_naissance_9, t0.photo AS photo_10, t0.nom_complet_tuteur AS nom_complet_tuteur_11, t0.email_tuteur AS email_tuteur_12, t0.telephone_tuteur AS telephone_tuteur_13, t0.user AS user_14 FROM eleve t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 23 | 0.37 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.date_naissance AS date_naissance_4, t0.adresse AS adresse_5, t0.email AS email_6, t0.telephone AS telephone_7, t0.genre AS genre_8, t0.lieu_naissance AS lieu_naissance_9, t0.photo AS photo_10, t0.nom_complet_tuteur AS nom_complet_tuteur_11, t0.email_tuteur AS email_tuteur_12, t0.telephone_tuteur AS telephone_tuteur_13, t0.user AS user_14 FROM eleve t0 WHERE t0.id = ?
Parameters:
[
4
]
|
| 24 | 0.29 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM niveau t0 WHERE t0.id = ?
Parameters:
[
19
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Note | 12 |
| App\Entity\Inscription | 4 |
| App\Entity\Eleve | 4 |
| App\Entity\Cours | 4 |
| App\Entity\Matiere | 4 |
| App\Entity\Enseignant | 4 |
| App\Entity\Classe | 3 |
| App\Entity\Niveau | 3 |
| App\Entity\AnneeScolaire | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\AnneeScolaire | No errors. |
| App\Entity\Semestre | No errors. |
| App\Entity\Budget | No errors. |
| App\Entity\Inscription | No errors. |
| App\Entity\Scolarite | No errors. |
| App\Entity\FraisScolarite | No errors. |
| App\Entity\Note | No errors. |
| App\Entity\Depense | No errors. |
| App\Entity\Eleve |
|
| App\Entity\Classe |
|
| App\Entity\Niveau | No errors. |
| App\Entity\Cours | No errors. |
| App\Entity\Seance | No errors. |
| App\Entity\Matiere |
|
| App\Entity\Enseignant |
|