Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

6.01 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.50 ms
(74.97%)

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.libelle AS libelle_2, p0_.passage_examen AS passage_examen_3, p0_.filiere_id AS filiere_id_4, p0_.responsable_id AS responsable_id_5, p0_.promotion_id AS promotion_id_6, p0_.annee_scolaire_id AS annee_scolaire_id_7 FROM param_niveau p0_ INNER JOIN annee_scolaire a1_ ON p0_.annee_scolaire_id = a1_.id WHERE a1_.actif = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.libelle AS libelle_2,
  p0_.passage_examen AS passage_examen_3,
  p0_.filiere_id AS filiere_id_4,
  p0_.responsable_id AS responsable_id_5,
  p0_.promotion_id AS promotion_id_6,
  p0_.annee_scolaire_id AS annee_scolaire_id_7
FROM
  param_niveau p0_
  INNER JOIN annee_scolaire a1_ ON p0_.annee_scolaire_id = a1_.id
WHERE
  a1_.actif = ?

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.libelle AS libelle_2, p0_.passage_examen AS passage_examen_3, p0_.filiere_id AS filiere_id_4, p0_.responsable_id AS responsable_id_5, p0_.promotion_id AS promotion_id_6, p0_.annee_scolaire_id AS annee_scolaire_id_7 FROM param_niveau p0_ INNER JOIN annee_scolaire a1_ ON p0_.annee_scolaire_id = a1_.id WHERE a1_.actif = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 239)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 789)
23	App\Controller\Site\HomeController->inscriptionLogin (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.50 ms
(25.03%)

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.libelle AS libelle_2 FROM param_genre p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.libelle AS libelle_2
FROM
  param_genre p0_

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.libelle AS libelle_2 FROM param_genre p0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 44)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 56)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 461)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 236)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
19	Symfony\Component\Form\Form->createView (line 903)
20	Symfony\Component\Form\Form->createView (line 239)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 789)
23	App\Controller\Site\HomeController->inscriptionLogin (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\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\AnneeScolaire	No errors.
App\Entity\Filiere	No errors.
App\Entity\Personne	No errors.
App\Entity\Employe	No errors.
App\Entity\Promotion	No errors.
App\Entity\Genre	No errors.
App\Entity\Frais	No errors.
App\Entity\InfoNiveau	No errors.
App\Entity\Inscription	No errors.
App\Entity\UniteEnseignement	No errors.
App\Entity\Classe	No errors.
App\Entity\DecisionExamen	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.

Symfony Profiler

GET https://ufrseg.logicielspourtous.com/inscription/etudiant

Configuration Settings

Theme