GET https://api-gestion-ecole.sonoya-technology.com/home/pages/tableau/honneur

Query Metrics

24 Database Queries
7 Different statements
10.23 ms Query time
4 Invalid entities
39 Managed entities

Queries

Group similar statements

#▲ 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
  • The association App\Entity\Eleve#fraisScolarites refers to the owning side field App\Entity\FraisScolarite#eleve which does not exist.
App\Entity\Classe
  • The field App\Entity\Classe#seances is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Seance#classe does not contain the required 'inversedBy="seances"' attribute.
  • The association App\Entity\Classe#fraisScolarites refers to the owning side field App\Entity\FraisScolarite#classe which does not exist.
App\Entity\Niveau No errors.
App\Entity\Cours No errors.
App\Entity\Seance No errors.
App\Entity\Matiere
  • The association App\Entity\Matiere#notes refers to the owning side field App\Entity\Note#matiere which does not exist.
App\Entity\Enseignant
  • The field App\Entity\Enseignant#seances is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Seance#enseignant does not contain the required 'inversedBy="seances"' attribute.