GET https://ufrseg.logicielspourtous.com/comptabilite/niveau/etudiant/2255/imprime/comptabilite

Query Metrics

7 Database Queries
7 Different statements
8.10 ms Query time
8 Invalid entities

Queries

Group similar statements

# Time Info
1 0.96 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.reset_token AS reset_token_4, t0.password AS password_5, t0.email AS email_6, t0.personne_id AS personne_id_7 FROM user_utilisateur t0 WHERE t0.id = ?
Parameters:
[
  1482
]
2 1.22 ms
SELECT t0.id AS id_3, t0.nom AS nom_4, t0.prenom AS prenom_5, t0.date_naissance AS date_naissance_6, t0.lieu_naissance AS lieu_naissance_7, t0.email AS email_8, t0.contact AS contact_9, t0.genre_id AS genre_id_10, t0.civilite_id AS civilite_id_11, t0.fonction_id AS fonction_id_12, t0.discr, t2.ville AS ville_13, t2.adresse AS adresse_14, t2.boite AS boite_15, t2.fax AS fax_16, t2.employeur AS employeur_17, t2.bailleur AS bailleur_18, t2.parent AS parent_19, t2.autre AS autre_20, t2.radio AS radio_21, t2.presse AS presse_22, t2.affiche AS affiche_23, t2.ministere AS ministere_24, t2.mailing AS mailing_25, t2.site_web AS site_web_26, t2.vous_meme AS vous_meme_27, t2.professeur AS professeur_28, t2.ami_collegue AS ami_collegue_29, t2.autre_existence AS autre_existence_30, t2.etat AS etat_31, t2.numero_whatsapp AS numero_whatsapp_32, t2.statut_travail AS statut_travail_33, t2.travail AS travail_34, t2.statut_etudiant AS statut_etudiant_35, t2.filiere_id AS filiere_id_36, t2.pays_id AS pays_id_37, t2.nationalite_id AS nationalite_id_38 FROM user_personne t0 LEFT JOIN user_employe t1 ON t0.id = t1.id LEFT JOIN user_etudiant t2 ON t0.id = t2.id WHERE t0.id = ?
Parameters:
[
  1592
]
3 0.75 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.reset_token AS reset_token_4, t0.password AS password_5, t0.email AS email_6, t0.personne_id AS personne_id_7 FROM user_utilisateur t0 WHERE t0.personne_id = ?
Parameters:
[
  1592
]
4 2.01 ms
SELECT t0.id AS id_1, t0.date_preinscription AS date_preinscription_2, t0.etat AS etat_3, t0.code AS code_4, t0.etat_deliberation AS etat_deliberation_5, t0.date_validation AS date_validation_6, t0.commentaire AS commentaire_7, t0.montant AS montant_8, t0.niveau_id AS niveau_id_9, t0.etudiant_id AS etudiant_id_10, t0.utilisateur_id AS utilisateur_id_11, t12.id AS id_13, t12.montant AS montant_14, t12.date_paiement AS date_paiement_15, t12.utilisateur_id AS utilisateur_id_16, t12.preinscription_id AS preinscription_id_17, t12.mode_paiement_id AS mode_paiement_id_18, t19.id AS id_20, t19.preinscription_id AS preinscription_id_21, t19.deliberation_id AS deliberation_id_22, t0.caissiere_id AS caissiere_id_23 FROM compta_preinscription t0 LEFT JOIN compta_info_preinscription t12 ON t12.preinscription_id = t0.id LEFT JOIN dir_deliberation_preinscription t19 ON t19.preinscription_id = t0.id WHERE t0.id = ?
Parameters:
[
  "2255"
]
5 0.95 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.passage_examen AS passage_examen_4, t0.filiere_id AS filiere_id_5, t0.responsable_id AS responsable_id_6, t0.promotion_id AS promotion_id_7, t0.annee_scolaire_id AS annee_scolaire_id_8 FROM param_niveau t0 WHERE t0.id = ?
Parameters:
[
  113
]
6 1.22 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.actif AS actif_5, t0.verrou AS verrou_6, t0.numero AS numero_7 FROM annee_scolaire t0 WHERE t0.id = ?
Parameters:
[
  11
]
7 1.00 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3, t0.description AS description_4, t0.montant_preinscription AS montant_preinscription_5, t0.fichier_id AS fichier_id_6, t7.id AS id_8, t7.size AS size_9, t7.path AS path_10, t7.alt AS alt_11, t7.date_creation AS date_creation_12, t7.url AS url_13 FROM param_filiere t0 LEFT JOIN param_fichier t7 ON t0.fichier_id = t7.id WHERE t0.id = ?
Parameters:
[
  4
]

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\Utilisateur
  • The field App\Entity\Utilisateur#infoInscriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\InfoInscription#utilisateur does not contain the required 'inversedBy="infoInscriptions"' attribute.
App\Entity\Personne No errors.
App\Entity\Employe No errors.
App\Entity\Etudiant
  • The association App\Entity\Etudiant#filiere refers to the inverse side field App\Entity\Filiere#etudiants which does not exist.
  • The field App\Entity\Etudiant#inscriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Inscription#etudiant does not contain the required 'inversedBy="inscriptions"' attribute.
App\Entity\Genre No errors.
App\Entity\Civilite No errors.
App\Entity\Fonction No errors.
App\Entity\Filiere No errors.
App\Entity\Pays No errors.
App\Entity\Nationalite No errors.
App\Entity\NiveauEtudiant
  • The association App\Entity\NiveauEtudiant#niveau refers to the inverse side field App\Entity\Niveau#niveauEtudiants which does not exist.
App\Entity\Preinscription No errors.
App\Entity\Inscription No errors.
App\Entity\Document No errors.
App\Entity\CursusUniversitaire No errors.
App\Entity\CursusProfessionnel No errors.
App\Entity\Stage No errors.
App\Entity\InfoEtudiant No errors.
App\Entity\Note
  • The association App\Entity\Note#valeurNoteExamens refers to the owning side field App\Entity\ValeurNoteExamen#note which is not defined as association, but as field.
  • The association App\Entity\Note#valeurNoteExamens refers to the owning side field App\Entity\ValeurNoteExamen#note which does not exist.
App\Entity\MoyenneMatiere
  • The association App\Entity\MoyenneMatiere#ue refers to the inverse side field App\Entity\UniteEnseignement#moyenneMatieres which does not exist.
App\Entity\BlocEcheancier No errors.
App\Entity\EncartBac No errors.
App\Entity\LigneRattrapage No errors.
App\Entity\DecisionResume No errors.
App\Entity\DecisionExamen No errors.
App\Entity\UtilisateurGroupe No errors.
App\Entity\InfoInscription No errors.
App\Entity\Decision No errors.
App\Entity\Niveau
  • The field App\Entity\Niveau#inscriptions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Inscription#niveau does not contain the required 'inversedBy="inscriptions"' attribute.
App\Entity\InfoPreinscription No errors.
App\Entity\NaturePaiement No errors.
App\Entity\DeliberationPreinscription No errors.
App\Entity\Deliberation No errors.
App\Entity\Promotion No errors.
App\Entity\AnneeScolaire No errors.
App\Entity\Frais No errors.
App\Entity\InfoNiveau No errors.
App\Entity\UniteEnseignement No errors.
App\Entity\Classe No errors.
App\Entity\Examen No errors.
App\Entity\Session
  • The association App\Entity\Session#moyenneMatieres refers to the owning side field App\Entity\MoyenneMatiere#session which does not exist.
App\Entity\EcheancierNiveau No errors.
App\Entity\NiveauxCaisse No errors.
App\Entity\Semestre No errors.
App\Entity\Cours No errors.
App\Entity\Controle
  • The association App\Entity\Controle#ue refers to the inverse side field App\Entity\UniteEnseignement#controles which does not exist.
App\Entity\Fichier No errors.