Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

4.85 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.46 ms
(30.07%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM symfony_demo_tag t0 INNER JOIN symfony_demo_post_symfony_demo_tag ON t0.id = symfony_demo_post_symfony_demo_tag.symfony_demo_tag_id WHERE symfony_demo_post_symfony_demo_tag.symfony_demo_post_id = ? ORDER BY t0.name ASC

Parameters:

[
  38
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  symfony_demo_tag t0
  INNER JOIN symfony_demo_post_symfony_demo_tag ON t0.id = symfony_demo_post_symfony_demo_tag.symfony_demo_tag_id
WHERE
  symfony_demo_post_symfony_demo_tag.symfony_demo_post_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2 FROM symfony_demo_tag t0 INNER JOIN symfony_demo_post_symfony_demo_tag ON t0.id = symfony_demo_post_symfony_demo_tag.symfony_demo_tag_id WHERE symfony_demo_post_symfony_demo_tag.symfony_demo_post_id = 38 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 110)
7	Doctrine\ORM\PersistentCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->offsetExists (line 420)
9	Twig\Extension\CoreExtension->getAttribute (line 1707)
10	__TwigTemplate_461c08bf1f4fba27c206e5f35b5f25b8::doDisplay (line 48)
11	Twig\Template->yield (line 411)
12	Twig\Template->display (line 366)
13	Twig\Template->render (line 381)
14	Twig\TemplateWrapper->render (line 51)
15	Twig\Extension\CoreExtension->include (line 1522)
16	__TwigTemplate_492488225b29ed4a302881acbf91a623::block_main (line 122)
17	Twig\Template->yieldBlock (line 456)
18	__TwigTemplate_492233238d2f37625314023c66eea6ab->block_body (line 320)
19	Twig\Template->yieldBlock (line 456)
20	__TwigTemplate_492233238d2f37625314023c66eea6ab->doDisplay (line 107)
21	Twig\Template->yield (line 411)
22	__TwigTemplate_492488225b29ed4a302881acbf91a623->doDisplay (line 55)
23	Twig\Template->yield (line 411)
24	Twig\Template->display (line 366)
25	Twig\Template->render (line 381)
26	Twig\TemplateWrapper->render (line 51)
27	Twig\Environment->render (line 333)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
31	App\Controller\BlogdemoController->postShow (line 77)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
34	Symfony\Component\HttpKernel\Kernel->handle (line 193)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
36	require_once (line 32)
37	require_once (line 5)

1.31 ms
(27.08%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.filename AS filename_7, t0.author_id AS author_id_8 FROM symfony_demo_post t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "jazz-night"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.summary AS summary_4,
  t0.content AS content_5,
  t0.published_at AS published_at_6,
  t0.filename AS filename_7,
  t0.author_id AS author_id_8
FROM
  symfony_demo_post t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.filename AS filename_7, t0.author_id AS author_id_8 FROM symfony_demo_post t0 WHERE t0.slug = 'jazz-night' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 79)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.12 ms
(23.18%)

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.symfony_demo_post_id AS symfony_demo_post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.symfony_demo_post_id = ?

Parameters:

[
  38
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.content AS content_2,
  t0.published_at AS published_at_3,
  t0.symfony_demo_post_id AS symfony_demo_post_id_4,
  t0.author_id AS author_id_5
FROM
  symfony_demo_comment t0
WHERE
  t0.symfony_demo_post_id = ?

SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.symfony_demo_post_id AS symfony_demo_post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.symfony_demo_post_id = 38;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_492488225b29ed4a302881acbf91a623::block_main (line 160)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_492233238d2f37625314023c66eea6ab->block_body (line 320)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_492233238d2f37625314023c66eea6ab->doDisplay (line 107)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_492488225b29ed4a302881acbf91a623->doDisplay (line 55)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\BlogdemoController->postShow (line 77)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	require_once (line 5)

0.95 ms
(19.68%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.email AS email_6 FROM symfony_demo_user t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.email AS email_6
FROM
  symfony_demo_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.email AS email_6 FROM symfony_demo_user t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Symfony_demo_user::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Symfony_demo_user->__get (line 153)
7	App\Entity\Symfony_demo_user->getFullName (line 61)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_492488225b29ed4a302881acbf91a623::block_main (line 179)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_492233238d2f37625314023c66eea6ab->block_body (line 320)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_492233238d2f37625314023c66eea6ab->doDisplay (line 107)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_492488225b29ed4a302881acbf91a623->doDisplay (line 55)
16	Twig\Template->yield (line 411)
17	Twig\Template->display (line 366)
18	Twig\Template->render (line 381)
19	Twig\TemplateWrapper->render (line 51)
20	Twig\Environment->render (line 333)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
24	App\Controller\BlogdemoController->postShow (line 77)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 193)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 32)
30	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Symfony_demo_post	1
App\Entity\Symfony_demo_user	1
App\Entity\Symfony_demo_comment	1

Entities Mapping

Class	Mapping errors
App\Entity\Symfony_demo_post	No errors.
App\Entity\Symfony_demo_user	No errors.
App\Entity\Symfony_demo_comment	No errors.
App\Entity\Symfony_demo_tag	No errors.

Symfony Profiler

GET https://masaepiano.com/it/blogdemo/posts/jazz-night

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping