Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.78 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.07 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.end AS end_4, t0.track_id AS track_id_5 FROM event t0 WHERE t0.id = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start AS start_3,
  t0.end AS end_4,
  t0.track_id AS track_id_5
FROM
  event t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.start AS start_3, t0.end AS end_4, t0.track_id AS track_id_5 FROM event t0 WHERE t0.id = '2';

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

0.38 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.line_one_x AS line_one_x_3, t0.line_one_y AS line_one_y_4, t0.line_two_x AS line_two_x_5, t0.line_two_y AS line_two_y_6, t0.lat AS lat_7, t0.lng AS lng_8 FROM track t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.line_one_x AS line_one_x_3,
  t0.line_one_y AS line_one_y_4,
  t0.line_two_x AS line_two_x_5,
  t0.line_two_y AS line_two_y_6,
  t0.lat AS lat_7,
  t0.lng AS lng_8
FROM
  track t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.line_one_x AS line_one_x_3, t0.line_one_y AS line_one_y_4, t0.line_two_x AS line_two_x_5, t0.line_two_y AS line_two_y_6, t0.lat AS lat_7, t0.lng AS lng_8 FROM track t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 111)
7	Proxies\__CG__\App\Entity\Track->__load (line 3538)
8	Doctrine\ORM\UnitOfWork->initializeObject (line 953)
9	Doctrine\ORM\EntityManager->initializeObject (line 87)
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 344)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 56)
24	App\Controller\Administration\EventController->edit (line 182)
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.34 ms

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.line_one_x AS line_one_x_2, t0_.line_one_y AS line_one_y_3, t0_.line_two_x AS line_two_x_4, t0_.line_two_y AS line_two_y_5, t0_.lat AS lat_6, t0_.lng AS lng_7 FROM track t0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.line_one_x AS line_one_x_2,
  t0_.line_one_y AS line_one_y_3,
  t0_.line_two_x AS line_two_x_4,
  t0_.line_two_y AS line_two_y_5,
  t0_.lat AS lat_6,
  t0_.lng AS lng_7
FROM
  track t0_

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.line_one_x AS line_one_x_2, t0_.line_one_y AS line_one_y_3, t0_.line_two_x AS line_two_x_4, t0_.line_two_y AS line_two_y_5, t0_.lat AS lat_6, t0_.lng AS lng_7 FROM track t0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
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 203)
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 65)
23	App\Controller\Administration\EventController->edit (line 182)
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\Event	No errors.
App\Entity\Track	No errors.
App\Entity\Session	No errors.
App\Entity\Sector	No errors.

Symfony Profiler

GET https://mep.altislab.fr/administration/event/2/edit

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping