Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.80 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.11 ms
(39.64%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.data AS data_4, t0.img_bg AS img_bg_5, t0.city_id AS city_id_6 FROM adventure t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.img AS img_3,
  t0.data AS data_4,
  t0.img_bg AS img_bg_5,
  t0.city_id AS city_id_6
FROM
  adventure t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.data AS data_4, t0.img_bg AS img_bg_5, t0.city_id AS city_id_6 FROM adventure t0 WHERE t0.id = 1;

#	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 39)
6	App\Controller\AdminAdventureController->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.86 ms
(30.80%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.img AS img_2 FROM city c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.img AS img_2
FROM
  city c0_

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.img AS img_2 FROM city c0_;

#	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 179)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 190)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 468)
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 52)
23	App\Controller\AdminAdventureController->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.83 ms
(29.55%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3 FROM city t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.img AS img_3
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3 FROM city t0 WHERE t0.id = 3;

#	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\City->__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 40)
24	App\Controller\AdminAdventureController->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\Adventure	No errors.
App\Entity\City	No errors.
App\Entity\Player	The association App\Entity\Player#user refers to the inverse side field App\Entity\User#player which does not exist.
App\Entity\Shop	No errors.

Symfony Profiler

GET http://37.27.32.76/admin/adventure/edit/1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping