Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

3.26 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.83 ms
(25.38%)

SELECT t0.id AS id_1, t0.text AS text_2 FROM dictionnaire t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.text AS text_2
FROM
  dictionnaire t0

SELECT t0.id AS id_1, t0.text AS text_2 FROM dictionnaire t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 525)
6	App\Controller\InscriptionStageController->edit (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.74 ms
(22.69%)

SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.date_naissance AS date_naissance_5, t0.telephone AS telephone_6, t0.adresse AS adresse_7, t0.code_postal AS code_postal_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.email AS email_11, t0.cns AS cns_12, t0.autorisation_parentale AS autorisation_parentale_13, t0.politique_confidentalite AS politique_confidentalite_14, t0.debutant AS debutant_15, t0.annee_pratique AS annee_pratique_16, t0.classement AS classement_17, t0.semaine_stage AS semaine_stage_18, t0.formule AS formule_19, t0.remarque AS remarque_20, t0.repas AS repas_21, t0.horaire AS horaire_22, t0.formule_debutant AS formule_debutant_23, t0.formule_confirme AS formule_confirme_24, t0.stage_id AS stage_id_25 FROM inscription_stage t0 WHERE t0.id = ?

Parameters:

[
  "681"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.civilite AS civilite_2,
  t0.nom AS nom_3,
  t0.prenom AS prenom_4,
  t0.date_naissance AS date_naissance_5,
  t0.telephone AS telephone_6,
  t0.adresse AS adresse_7,
  t0.code_postal AS code_postal_8,
  t0.ville AS ville_9,
  t0.pays AS pays_10,
  t0.email AS email_11,
  t0.cns AS cns_12,
  t0.autorisation_parentale AS autorisation_parentale_13,
  t0.politique_confidentalite AS politique_confidentalite_14,
  t0.debutant AS debutant_15,
  t0.annee_pratique AS annee_pratique_16,
  t0.classement AS classement_17,
  t0.semaine_stage AS semaine_stage_18,
  t0.formule AS formule_19,
  t0.remarque AS remarque_20,
  t0.repas AS repas_21,
  t0.horaire AS horaire_22,
  t0.formule_debutant AS formule_debutant_23,
  t0.formule_confirme AS formule_confirme_24,
  t0.stage_id AS stage_id_25
FROM
  inscription_stage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.civilite AS civilite_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.date_naissance AS date_naissance_5, t0.telephone AS telephone_6, t0.adresse AS adresse_7, t0.code_postal AS code_postal_8, t0.ville AS ville_9, t0.pays AS pays_10, t0.email AS email_11, t0.cns AS cns_12, t0.autorisation_parentale AS autorisation_parentale_13, t0.politique_confidentalite AS politique_confidentalite_14, t0.debutant AS debutant_15, t0.annee_pratique AS annee_pratique_16, t0.classement AS classement_17, t0.semaine_stage AS semaine_stage_18, t0.formule AS formule_19, t0.remarque AS remarque_20, t0.repas AS repas_21, t0.horaire AS horaire_22, t0.formule_debutant AS formule_debutant_23, t0.formule_confirme AS formule_confirme_24, t0.stage_id AS stage_id_25 FROM inscription_stage t0 WHERE t0.id = '681';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 116)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.72 ms
(21.98%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.image AS image_5, t0.formule1 AS formule1_6, t0.formule2 AS formule2_7, t0.infos_pratiques AS infos_pratiques_8, t0.document_inscription AS document_inscription_9, t0.niveaux AS niveaux_10, t0.date_limite AS date_limite_11, t0.inscription_allow AS inscription_allow_12, t0.nb_jours AS nb_jours_13, t0.type AS type_14 FROM stage t0 WHERE t0.id = ?

Parameters:

[
  32
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.image AS image_5,
  t0.formule1 AS formule1_6,
  t0.formule2 AS formule2_7,
  t0.infos_pratiques AS infos_pratiques_8,
  t0.document_inscription AS document_inscription_9,
  t0.niveaux AS niveaux_10,
  t0.date_limite AS date_limite_11,
  t0.inscription_allow AS inscription_allow_12,
  t0.nb_jours AS nb_jours_13,
  t0.type AS type_14
FROM
  stage t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.image AS image_5, t0.formule1 AS formule1_6, t0.formule2 AS formule2_7, t0.infos_pratiques AS infos_pratiques_8, t0.document_inscription AS document_inscription_9, t0.niveaux AS niveaux_10, t0.date_limite AS date_limite_11, t0.inscription_allow AS inscription_allow_12, t0.nb_jours AS nb_jours_13, t0.type AS type_14 FROM stage t0 WHERE t0.id = 32;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 287)
5	Proxies\__CG__\App\Entity\Stage::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 102)
7	Proxies\__CG__\App\Entity\Stage->__load (line 3023)
8	Doctrine\ORM\UnitOfWork->initializeObject (line 557)
9	Doctrine\ORM\EntityManager->initializeObject (line 89)
10	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 49)
11	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->Symfony\Component\Form\ChoiceList\Loader\{closure} (line 1)
12	array_map (line 49)
13	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadValuesForChoices (line 81)
14	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 34)
15	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 992)
16	Symfony\Component\Form\Form->normToView (line 301)
17	Symfony\Component\Form\Form->setData (line 50)
18	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
19	Symfony\Component\Form\Form->setData (line 412)
20	Symfony\Component\Form\Form->initialize (line 176)
21	Symfony\Component\Form\FormBuilder->getForm (line 28)
22	Symfony\Component\Form\FormFactory->create (line 340)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 523)
24	App\Controller\InscriptionStageController->edit (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.51 ms
(15.68%)

SELECT s0_.id AS id_0, s0_.titre AS titre_1, s0_.date_debut AS date_debut_2, s0_.date_fin AS date_fin_3, s0_.image AS image_4, s0_.formule1 AS formule1_5, s0_.formule2 AS formule2_6, s0_.infos_pratiques AS infos_pratiques_7, s0_.document_inscription AS document_inscription_8, s0_.niveaux AS niveaux_9, s0_.date_limite AS date_limite_10, s0_.inscription_allow AS inscription_allow_11, s0_.nb_jours AS nb_jours_12, s0_.type AS type_13 FROM stage s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.titre AS titre_1,
  s0_.date_debut AS date_debut_2,
  s0_.date_fin AS date_fin_3,
  s0_.image AS image_4,
  s0_.formule1 AS formule1_5,
  s0_.formule2 AS formule2_6,
  s0_.infos_pratiques AS infos_pratiques_7,
  s0_.document_inscription AS document_inscription_8,
  s0_.niveaux AS niveaux_9,
  s0_.date_limite AS date_limite_10,
  s0_.inscription_allow AS inscription_allow_11,
  s0_.nb_jours AS nb_jours_12,
  s0_.type AS type_13
FROM
  stage s0_

SELECT s0_.id AS id_0, s0_.titre AS titre_1, s0_.date_debut AS date_debut_2, s0_.date_fin AS date_fin_3, s0_.image AS image_4, s0_.formule1 AS formule1_5, s0_.formule2 AS formule2_6, s0_.infos_pratiques AS infos_pratiques_7, s0_.document_inscription AS document_inscription_8, s0_.niveaux AS niveaux_9, s0_.date_limite AS date_limite_10, s0_.inscription_allow AS inscription_allow_11, s0_.nb_jours AS nb_jours_12, s0_.type AS type_13 FROM stage s0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 36)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
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 64)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 193)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
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 440)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 537)
24	App\Controller\InscriptionStageController->edit (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.46 ms
(14.27%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 733)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 751)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\User	No errors.
App\Entity\InscriptionStage	The association App\Entity\InscriptionStage#semaineStages refers to the owning side field App\Entity\SemaineStage#formulaire which does not exist.
App\Entity\Stage	No errors.
App\Entity\SemaineStage	No errors.
App\Entity\FormuleStage	No errors.
App\Entity\Sections	No errors.
App\Entity\Document	No errors.
App\Entity\SemaineStageAdulte	No errors.
App\Entity\CarouselStage	No errors.
App\Entity\Dictionnaire	No errors.

Symfony Profiler

GET https://tennisspora.lu/admin/inscription-stage/681/edit?p=admin%2Finscription-stage%2F681%2Fedit

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping