Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.02 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.02 ms
(100.00%)

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:

[
  "2252"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = '2252';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 142)
6	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->find (line 91)
7	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\DoctrineParamConverter->apply (line 84)
8	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->applyConverter (line 48)
9	Sensio\Bundle\FrameworkExtraBundle\Request\ParamConverter\ParamConverterManager->apply (line 72)
10	Sensio\Bundle\FrameworkExtraBundle\EventListener\ParamConverterListener->onKernelController (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

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\Preinscription	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\Personne	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\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\InfoPreinscription	No errors.
App\Entity\NaturePaiement	No errors.
App\Entity\DeliberationPreinscription	No errors.
App\Entity\Deliberation	No errors.
App\Entity\Decision	No errors.

Symfony Profiler

GET https://ufrseg.logicielspourtous.com/public/workflow/etudiant/2252/formation/preinscription

Configuration Settings

Theme