Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

0.87 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.33 ms

SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = ?

Parameters:

[
  "49"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.location1_id AS location1_id_2,
  t0.location2_id AS location2_id_3
FROM
  path t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.location1_id AS location1_id_2, t0.location2_id AS location2_id_3 FROM path t0 WHERE t0.id = '49';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
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.20 ms

SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.state AS state_3,
  t0.type AS type_4
FROM
  location t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 104)
6	Proxies\__CG__\App\Entity\Location->__load (line 3032)
7	Doctrine\ORM\UnitOfWork->initializeObject (line 557)
8	Doctrine\ORM\EntityManager->initializeObject (line 89)
9	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 49)
10	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->Symfony\Component\Form\ChoiceList\Loader\{closure} (line 1)
11	array_map (line 49)
12	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadValuesForChoices (line 81)
13	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 34)
14	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 992)
15	Symfony\Component\Form\Form->normToView (line 301)
16	Symfony\Component\Form\Form->setData (line 50)
17	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
18	Symfony\Component\Form\Form->setData (line 412)
19	Symfony\Component\Form\Form->initialize (line 176)
20	Symfony\Component\Form\FormBuilder->getForm (line 28)
21	Symfony\Component\Form\FormFactory->create (line 340)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 56)
23	App\Controller\PathController->edit (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)

0.18 ms

SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = ?

Parameters:

[
  19
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.state AS state_3,
  t0.type AS type_4
FROM
  location t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.state AS state_3, t0.type AS type_4 FROM location t0 WHERE t0.id = 19;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 104)
6	Proxies\__CG__\App\Entity\Location->__load (line 3032)
7	Doctrine\ORM\UnitOfWork->initializeObject (line 557)
8	Doctrine\ORM\EntityManager->initializeObject (line 89)
9	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 49)
10	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->Symfony\Component\Form\ChoiceList\Loader\{closure} (line 1)
11	array_map (line 49)
12	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadValuesForChoices (line 81)
13	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 34)
14	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 992)
15	Symfony\Component\Form\Form->normToView (line 301)
16	Symfony\Component\Form\Form->setData (line 50)
17	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
18	Symfony\Component\Form\Form->setData (line 412)
19	Symfony\Component\Form\Form->initialize (line 176)
20	Symfony\Component\Form\FormBuilder->getForm (line 28)
21	Symfony\Component\Form\FormFactory->create (line 340)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 56)
23	App\Controller\PathController->edit (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)

0.16 ms

SELECT l0_.id AS id_0, l0_.label AS label_1, l0_.state AS state_2, l0_.type AS type_3 FROM location l0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.label AS label_1,
  l0_.state AS state_2,
  l0_.type AS type_3
FROM
  location l0_

SELECT l0_.id AS id_0, l0_.label AS label_1, l0_.state AS state_2, l0_.type AS type_3 FROM location l0_;

#	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 65)
24	App\Controller\PathController->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)

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\Path	No errors.
App\Entity\Location	No errors.
App\Entity\Rate	No errors.
App\Entity\Transfer	No errors.

Symfony Profiler

GET https://www.transfer.createch.tn/path/49/edit

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping