Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

6.28 ms Query time

6 Invalid entities

58 Managed entities

Queries

Group similar statements

#▲	Time	Info
1	1.85 ms	SELECT t0.ID AS ID_1, t0.IDEcole AS IDEcole_2, t0.nom AS nom_3, t0.adresse AS adresse_4, t0.telephone AS telephone_5, t0.fax AS fax_6, t0.codepostal AS codepostal_7, t0.ville AS ville_8, t0.creer_le AS creer_le_9, t0.creer_par AS creer_par_10, t0.modifier_le AS modifier_le_11, t0.modifier_par AS modifier_par_12, t0.email AS email_13, t0.siret AS siret_14, t0.IDEcole AS IDEcole_15 FROM Etablissement t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.ID AS ID_1, t0.IDEcole AS IDEcole_2, t0.nom AS nom_3, t0.adresse AS adresse_4, t0.telephone AS telephone_5, t0.fax AS fax_6, t0.codepostal AS codepostal_7, t0.ville AS ville_8, t0.creer_le AS creer_le_9, t0.creer_par AS creer_par_10, t0.modifier_le AS modifier_le_11, t0.modifier_par AS modifier_par_12, t0.email AS email_13, t0.siret AS siret_14, t0.IDEcole AS IDEcole_15 FROM Etablissement t0 SELECT t0.ID AS ID_1, t0.IDEcole AS IDEcole_2, t0.nom AS nom_3, t0.adresse AS adresse_4, t0.telephone AS telephone_5, t0.fax AS fax_6, t0.codepostal AS codepostal_7, t0.ville AS ville_8, t0.creer_le AS creer_le_9, t0.creer_par AS creer_par_10, t0.modifier_le AS modifier_le_11, t0.modifier_par AS modifier_par_12, t0.email AS email_13, t0.siret AS siret_14, t0.IDEcole AS IDEcole_15 FROM Etablissement t0;
2	2.28 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.ordre AS ordre_4, t0.groupe AS groupe_5, t0.description AS description_6, t0.configuration AS configuration_7, t0.actif AS actif_8, t0.creer_le AS creer_le_9, t0.creer_par AS creer_par_10, t0.modifier_le AS modifier_le_11, t0.modifier_par AS modifier_par_12, t0.etablissement_id AS etablissement_id_13 FROM niveau_scolaire t0 WHERE t0.actif = ? ORDER BY t0.ordre ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.ordre AS ordre_4, t0.groupe AS groupe_5, t0.description AS description_6, t0.configuration AS configuration_7, t0.actif AS actif_8, t0.creer_le AS creer_le_9, t0.creer_par AS creer_par_10, t0.modifier_le AS modifier_le_11, t0.modifier_par AS modifier_par_12, t0.etablissement_id AS etablissement_id_13 FROM niveau_scolaire t0 WHERE t0.actif = ? ORDER BY t0.ordre ASC SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.ordre AS ordre_4, t0.groupe AS groupe_5, t0.description AS description_6, t0.configuration AS configuration_7, t0.actif AS actif_8, t0.creer_le AS creer_le_9, t0.creer_par AS creer_par_10, t0.modifier_le AS modifier_le_11, t0.modifier_par AS modifier_par_12, t0.etablissement_id AS etablissement_id_13 FROM niveau_scolaire t0 WHERE t0.actif = 1 ORDER BY t0.ordre ASC;
3	2.15 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.annee_scolaire AS annee_scolaire_3, t0.capacite AS capacite_4, t0.effectif AS effectif_5, t0.description AS description_6, t0.actif AS actif_7, t0.creer_le AS creer_le_8, t0.creer_par AS creer_par_9, t0.modifier_le AS modifier_le_10, t0.modifier_par AS modifier_par_11, t0.etablissement_id AS etablissement_id_12, t0.niveau_scolaire_id AS niveau_scolaire_id_13, t0.professeur_principal_id AS professeur_principal_id_14, t0.salle_id AS salle_id_15 FROM classe t0 WHERE t0.actif = ? ORDER BY t0.nom ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.annee_scolaire AS annee_scolaire_3, t0.capacite AS capacite_4, t0.effectif AS effectif_5, t0.description AS description_6, t0.actif AS actif_7, t0.creer_le AS creer_le_8, t0.creer_par AS creer_par_9, t0.modifier_le AS modifier_le_10, t0.modifier_par AS modifier_par_11, t0.etablissement_id AS etablissement_id_12, t0.niveau_scolaire_id AS niveau_scolaire_id_13, t0.professeur_principal_id AS professeur_principal_id_14, t0.salle_id AS salle_id_15 FROM classe t0 WHERE t0.actif = ? ORDER BY t0.nom ASC SELECT t0.id AS id_1, t0.nom AS nom_2, t0.annee_scolaire AS annee_scolaire_3, t0.capacite AS capacite_4, t0.effectif AS effectif_5, t0.description AS description_6, t0.actif AS actif_7, t0.creer_le AS creer_le_8, t0.creer_par AS creer_par_9, t0.modifier_le AS modifier_le_10, t0.modifier_par AS modifier_par_11, t0.etablissement_id AS etablissement_id_12, t0.niveau_scolaire_id AS niveau_scolaire_id_13, t0.professeur_principal_id AS professeur_principal_id_14, t0.salle_id AS salle_id_15 FROM classe t0 WHERE t0.actif = 1 ORDER BY t0.nom ASC;

#▲

Time

Info

1.85 ms

SELECT t0.ID AS ID_1, t0.IDEcole AS IDEcole_2, t0.nom AS nom_3, t0.adresse AS adresse_4, t0.telephone AS telephone_5, t0.fax AS fax_6, t0.codepostal AS codepostal_7, t0.ville AS ville_8, t0.creer_le AS creer_le_9, t0.creer_par AS creer_par_10, t0.modifier_le AS modifier_le_11, t0.modifier_par AS modifier_par_12, t0.email AS email_13, t0.siret AS siret_14, t0.IDEcole AS IDEcole_15 FROM Etablissement t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.ID AS ID_1,
  t0.IDEcole AS IDEcole_2,
  t0.nom AS nom_3,
  t0.adresse AS adresse_4,
  t0.telephone AS telephone_5,
  t0.fax AS fax_6,
  t0.codepostal AS codepostal_7,
  t0.ville AS ville_8,
  t0.creer_le AS creer_le_9,
  t0.creer_par AS creer_par_10,
  t0.modifier_le AS modifier_le_11,
  t0.modifier_par AS modifier_par_12,
  t0.email AS email_13,
  t0.siret AS siret_14,
  t0.IDEcole AS IDEcole_15
FROM
  Etablissement t0

SELECT t0.ID AS ID_1, t0.IDEcole AS IDEcole_2, t0.nom AS nom_3, t0.adresse AS adresse_4, t0.telephone AS telephone_5, t0.fax AS fax_6, t0.codepostal AS codepostal_7, t0.ville AS ville_8, t0.creer_le AS creer_le_9, t0.creer_par AS creer_par_10, t0.modifier_le AS modifier_le_11, t0.modifier_par AS modifier_par_12, t0.email AS email_13, t0.siret AS siret_14, t0.IDEcole AS IDEcole_15 FROM Etablissement t0;

2.28 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.ordre AS ordre_4, t0.groupe AS groupe_5, t0.description AS description_6, t0.configuration AS configuration_7, t0.actif AS actif_8, t0.creer_le AS creer_le_9, t0.creer_par AS creer_par_10, t0.modifier_le AS modifier_le_11, t0.modifier_par AS modifier_par_12, t0.etablissement_id AS etablissement_id_13 FROM niveau_scolaire t0 WHERE t0.actif = ? ORDER BY t0.ordre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.ordre AS ordre_4,
  t0.groupe AS groupe_5,
  t0.description AS description_6,
  t0.configuration AS configuration_7,
  t0.actif AS actif_8,
  t0.creer_le AS creer_le_9,
  t0.creer_par AS creer_par_10,
  t0.modifier_le AS modifier_le_11,
  t0.modifier_par AS modifier_par_12,
  t0.etablissement_id AS etablissement_id_13
FROM
  niveau_scolaire t0
WHERE
  t0.actif = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.ordre AS ordre_4, t0.groupe AS groupe_5, t0.description AS description_6, t0.configuration AS configuration_7, t0.actif AS actif_8, t0.creer_le AS creer_le_9, t0.creer_par AS creer_par_10, t0.modifier_le AS modifier_le_11, t0.modifier_par AS modifier_par_12, t0.etablissement_id AS etablissement_id_13 FROM niveau_scolaire t0 WHERE t0.actif = 1 ORDER BY t0.ordre ASC;

2.15 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.annee_scolaire AS annee_scolaire_3, t0.capacite AS capacite_4, t0.effectif AS effectif_5, t0.description AS description_6, t0.actif AS actif_7, t0.creer_le AS creer_le_8, t0.creer_par AS creer_par_9, t0.modifier_le AS modifier_le_10, t0.modifier_par AS modifier_par_11, t0.etablissement_id AS etablissement_id_12, t0.niveau_scolaire_id AS niveau_scolaire_id_13, t0.professeur_principal_id AS professeur_principal_id_14, t0.salle_id AS salle_id_15 FROM classe t0 WHERE t0.actif = ? ORDER BY t0.nom ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.annee_scolaire AS annee_scolaire_3,
  t0.capacite AS capacite_4,
  t0.effectif AS effectif_5,
  t0.description AS description_6,
  t0.actif AS actif_7,
  t0.creer_le AS creer_le_8,
  t0.creer_par AS creer_par_9,
  t0.modifier_le AS modifier_le_10,
  t0.modifier_par AS modifier_par_11,
  t0.etablissement_id AS etablissement_id_12,
  t0.niveau_scolaire_id AS niveau_scolaire_id_13,
  t0.professeur_principal_id AS professeur_principal_id_14,
  t0.salle_id AS salle_id_15
FROM
  classe t0
WHERE
  t0.actif = ?
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.annee_scolaire AS annee_scolaire_3, t0.capacite AS capacite_4, t0.effectif AS effectif_5, t0.description AS description_6, t0.actif AS actif_7, t0.creer_le AS creer_le_8, t0.creer_par AS creer_par_9, t0.modifier_le AS modifier_le_10, t0.modifier_par AS modifier_par_11, t0.etablissement_id AS etablissement_id_12, t0.niveau_scolaire_id AS niveau_scolaire_id_13, t0.professeur_principal_id AS professeur_principal_id_14, t0.salle_id AS salle_id_15 FROM classe t0 WHERE t0.actif = 1 ORDER BY t0.nom ASC;

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\NiveauScolaire	21
App\Entity\Classe	20
App\Entity\Etablissement	9
App\Entity\Utilisateurs	5
App\Entity\Ecole	3

Entities Mapping

Class	Mapping errors
App\Entity\Etablissement	The association App\Entity\Etablissement#superviseurs refers to the owning side field App\Entity\EtablissementUtilisateur#idEtablissement which does not exist.
App\Entity\Ecole	No errors.
App\Entity\NiveauScolaire	The association App\Entity\NiveauScolaire#matieresScolaires refers to the owning side field App\Entity\MatiereScolaire#niveauScolaire which does not exist.
App\Entity\Classe	The field App\Entity\Classe#enseignantClasses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\EnseignantClasse#classe does not contain the required 'inversedBy: "enseignantClasses"' attribute. The field App\Entity\Classe#eleves is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Eleve#classe does not contain the required 'inversedBy: "eleves"' attribute.
App\Entity\EtablissementUtilisateur	The mappings App\Entity\EtablissementUtilisateur#etablissement and App\Entity\Etablissement#superviseurs are inconsistent with each other.
App\Entity\MatiereScolaire	No errors.
App\Entity\Utilisateurs	The field App\Entity\Utilisateurs#etablissementUtilisateurs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\EtablissementUtilisateur#utilisateur does not contain the required 'inversedBy: "etablissementUtilisateurs"' attribute.
App\Entity\Salle	No errors.
App\Entity\EnseignantClasse	No errors.
App\Entity\Eleve	The field 'App\Entity\Eleve#fraisInscription' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Eleve#fraisPaye' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field App\Entity\Eleve#parentRelations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ParentEleveRelation#eleve does not contain the required 'inversedBy: "parentRelations"' attribute.

Symfony Profiler

GET https://www.schoolmaly.tech/preinscription

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping