Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.31 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.45 ms
(62.63%)

SELECT t0.id AS id_1, t0.name_en AS name_en_2, t0.name_fr AS name_fr_3, t0.name_ar AS name_ar_4, t0.alpha2 AS alpha2_5, t0.alpha3 AS alpha3_6 FROM nation t0 WHERE t0.id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_en AS name_en_2,
  t0.name_fr AS name_fr_3,
  t0.name_ar AS name_ar_4,
  t0.alpha2 AS alpha2_5,
  t0.alpha3 AS alpha3_6
FROM
  nation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_en AS name_en_2, t0.name_fr AS name_fr_3, t0.name_ar AS name_ar_4, t0.alpha2 AS alpha2_5, t0.alpha3 AS alpha3_6 FROM nation t0 WHERE t0.id = 14;

#	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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Nation::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 178)
7	Proxies\__CG__\App\Entity\Nation->__get (line 148)
8	App\Entity\Nation->__toString (line 148)
9	Sonata\AdminBundle\Twig\RenderElementRuntime->renderRelationElement (line 97)
10	__TwigTemplate_e95b24c323f511b5d598322159f31b44->block_field (line 430)
11	Twig\Template->yieldBlock (line 61)
12	__TwigTemplate_8927a582b325f444e9db4588e0cc888e->doDisplay (line 360)
13	Twig\Template->yield (line 49)
14	__TwigTemplate_e95b24c323f511b5d598322159f31b44->doDisplay (line 360)
15	Twig\Template->yield (line 335)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 209)
18	Sonata\AdminBundle\Twig\RenderElementRuntime->render (line 72)
19	Sonata\AdminBundle\Twig\RenderElementRuntime->renderViewElement (line 568)
20	__TwigTemplate_cae4b345ebe4ee10224e92aa215630e3->block_show_field (line 430)
21	Twig\Template->yieldBlock (line 470)
22	__TwigTemplate_cae4b345ebe4ee10224e92aa215630e3->block_field_row (line 430)
23	Twig\Template->yieldBlock (line 382)
24	__TwigTemplate_cae4b345ebe4ee10224e92aa215630e3->block_show_groups (line 430)
25	Twig\Template->yieldBlock (line 346)
26	__TwigTemplate_cae4b345ebe4ee10224e92aa215630e3->block_show (line 430)
27	Twig\Template->yieldBlock (line 193)
28	Twig\Template->renderBlock (line 81)
29	__TwigTemplate_481c6bb5614b336005ea706742332429->doDisplay (line 360)
30	Twig\Template->yield (line 56)
31	__TwigTemplate_cae4b345ebe4ee10224e92aa215630e3->doDisplay (line 360)
32	Twig\Template->yield (line 48)
33	__TwigTemplate_e35da7b566c6102d4fc07d31cf6236bf->doDisplay (line 360)
34	Twig\Template->yield (line 335)
35	Twig\Template->render (line 38)
36	Twig\TemplateWrapper->render (line 307)
37	Twig\Environment->render (line 448)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 1023)
41	Sonata\AdminBundle\Controller\CRUDController->renderWithExtraParams (line 688)
42	Sonata\AdminBundle\Controller\CRUDController->showAction (line 181)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
45	Symfony\Component\HttpKernel\Kernel->handle (line 35)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
47	require_once (line 5)

0.86 ms
(37.37%)

SELECT t0.id AS id_1, t0.country_id AS country_id_2 FROM location t0 WHERE t0.id = ?

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.country_id AS country_id_2
FROM
  location t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.country_id AS country_id_2 FROM location t0 WHERE t0.id = '2';

#	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 163)
7	Sonata\DoctrineORMAdminBundle\Model\ModelManager->find (line 848)
8	Sonata\AdminBundle\Admin\AbstractAdmin->getObject (line 1455)
9	Sonata\AdminBundle\Controller\CRUDController->assertObjectExists (line 667)
10	Sonata\AdminBundle\Controller\CRUDController->showAction (line 181)
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)

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\Location	No errors.
App\Entity\Nation	No errors.
App\Entity\Employee	No errors.

Symfony Profiler

GET https://701130.web24.swisscenter.com/admin/app/location/2/show

Configuration Settings

Theme