GET https://www.sylvain-meunier.fr/souscription

Query Metrics

5 Database Queries
5 Different statements
152.27 ms Query time
2 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 53.69 ms
SELECT t0.id AS id_1, t0.role AS role_2, t0.libelle_long AS libelle_long_3, t0.libelle_court AS libelle_court_4, t0.commentaire AS commentaire_5, t0.ordre_affichage AS ordre_affichage_6, t0.reference AS reference_7, t0.num_asso AS num_asso_8, t0.created_at AS created_at_9, t0.actif AS actif_10, t0.modifiable AS modifiable_11 FROM type_user t0 WHERE t0.reference = ? LIMIT 1
Parameters:
[
  1
]
2 32.85 ms
SELECT t0.id AS id_1, t0.libelle_long AS libelle_long_2, t0.libelle_court AS libelle_court_3, t0.commentaire AS commentaire_4, t0.ordre_affichage AS ordre_affichage_5, t0.reference AS reference_6, t0.num_asso AS num_asso_7, t0.created_at AS created_at_8, t0.actif AS actif_9, t0.modifiable AS modifiable_10 FROM statut_user t0 WHERE t0.reference = ? LIMIT 1
Parameters:
[
  2
]
3 6.61 ms
SELECT c0_.id AS id_0, c0_.libelle_long AS libelle_long_1, c0_.libelle_court AS libelle_court_2, c0_.numero AS numero_3, c0_.adresse AS adresse_4, c0_.complement_adresse AS complement_adresse_5, c0_.code_postal AS code_postal_6, c0_.ville AS ville_7, c0_.nom_contact AS nom_contact_8, c0_.tel_contact AS tel_contact_9, c0_.created_at AS created_at_10, c0_.num_asso AS num_asso_11, c0_.actif AS actif_12 FROM club c0_
Parameters:
[]
4 58.53 ms
SELECT c0_.id AS id_0, c0_.libelle_long AS libelle_long_1, c0_.libelle_court AS libelle_court_2, c0_.commentaire AS commentaire_3, c0_.ordre_affichage AS ordre_affichage_4, c0_.reference AS reference_5, c0_.num_asso AS num_asso_6, c0_.created_at AS created_at_7, c0_.actif AS actif_8, c0_.modifiable AS modifiable_9, c0_.comite_regional_id AS comite_regional_id_10 FROM codep c0_ WHERE c0_.actif = 1 ORDER BY c0_.ordre_affichage ASC
Parameters:
[]
5 0.58 ms
SELECT n0_.id AS id_0, n0_.formation AS formation_1, n0_.libelle_long AS libelle_long_2, n0_.libelle_court AS libelle_court_3, n0_.commentaire AS commentaire_4, n0_.ordre_affichage AS ordre_affichage_5, n0_.reference AS reference_6, n0_.num_asso AS num_asso_7, n0_.created_at AS created_at_8, n0_.actif AS actif_9, n0_.modifiable AS modifiable_10 FROM niveau n0_ ORDER BY n0_.ordre_affichage ASC
Parameters:
[]

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

Entities Mapping

Class Mapping errors
App\Entity\Referentiel\TypeUser No errors.
App\Entity\Referentiel\StatutUser No errors.
App\Entity\User\User
  • The mappings App\Entity\User\User#niveauPrepare and App\Entity\Referentiel\Niveau#users are inconsistent with each other.
App\Entity\User\Club No errors.
App\Entity\Referentiel\Codep No errors.
App\Entity\Referentiel\ComiteRegional No errors.
App\Entity\Referentiel\Niveau
  • The association App\Entity\Referentiel\Niveau#stages refers to the owning side field App\Entity\Formation\Stage#niveau which does not exist.
  • The mappings App\Entity\Referentiel\Niveau#usersNiveauPrepare and App\Entity\User\User#niveauPrepare are inconsistent with each other.
  • The association App\Entity\Referentiel\Niveau#typeStages refers to the owning side field App\Entity\Referentiel\TypeStage#nifeauFormation which does not exist.
  • The association App\Entity\Referentiel\Niveau#sousEtapePedagogiques refers to the owning side field App\Entity\Evaluation\SousEtapePedagogique#niveau which does not exist.