Symfony Profiler

Query Metrics

21 Database Queries

4 Different statements

4.55 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.55 ms
(78.06%)

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 178)
6	Proxies\__CG__\App\Entity\Location->__get (line 51)
7	App\Entity\Location->getLabel (line 41)
8	App\Entity\Location->__toString (line 52)
9	App\Form\RateType->App\Form\{closure} (line 162)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceView (line 237)
11	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory::addChoiceViewsFromStructuredValues (line 127)
12	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 182)
13	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 193)
14	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 465)
15	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 238)
16	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 116)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 114)
19	Symfony\Component\Form\ResolvedFormType->buildView (line 87)
20	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 900)
21	Symfony\Component\Form\Form->createView (line 903)
22	Symfony\Component\Form\Form->createView (line 440)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 65)
26	App\Controller\RateController->edit (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.39 ms
(8.57%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.person_number AS person_number_3, t0.price AS price_4, t0.path_id AS path_id_5 FROM rate t0 WHERE t0.id = ?

Parameters:

[
  "163"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.person_number AS person_number_3,
  t0.price AS price_4,
  t0.path_id AS path_id_5
FROM
  rate t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.person_number AS person_number_3, t0.price AS price_4, t0.path_id AS path_id_5 FROM rate t0 WHERE t0.id = '163';

#	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.33 ms
(7.22%)

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:

[
  27
]

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 = 27;

#	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\Path->__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\RateController->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.28 ms
(6.15%)

SELECT p0_.id AS id_0, p0_.location1_id AS location1_id_1, p0_.location2_id AS location2_id_2 FROM path p0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.location1_id AS location1_id_1,
  p0_.location2_id AS location2_id_2
FROM
  path p0_

SELECT p0_.id AS id_0, p0_.location1_id AS location1_id_1, p0_.location2_id AS location2_id_2 FROM path p0_;

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

Symfony Profiler

GET https://www.transfer.createch.tn/rate/163/edit

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping