Symfony Profiler

Query Metrics

38 Database Queries

12 Different statements

29.02 ms Query time

0 Invalid entities

52 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.16 ms
(48.82%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_by AS deleted_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "website-name"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.created_by AS created_by_4,
  t0.updated_by AS updated_by_5,
  t0.deleted_by AS deleted_by_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.created_by AS created_by_4, t0.updated_by AS updated_by_5, t0.deleted_by AS deleted_by_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.name = 'website-name' 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	App\Service\SettingHandler->get (line 18)
5	Twig\Extension\CoreExtension->getAttribute (line 1918)
6	__TwigTemplate_165c5dba967f717a4470a9decb00cb93::doDisplay (line 59)
7	Twig\Template->yield (line 411)
8	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->block_header (line 257)
9	Twig\Template->yieldBlock (line 456)
10	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 94)
11	Twig\Template->yield (line 411)
12	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->doDisplay (line 55)
13	Twig\Template->yield (line 411)
14	Twig\Template->display (line 366)
15	Twig\Template->render (line 381)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
21	App\Controller\ArticleController->show (line 36)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

3.74 ms
(12.90%)

SELECT t0.id AS id_1, t0.picture AS picture_2, t0.title AS title_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM article_picture_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.picture AS picture_2,
  t0.title AS title_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  article_picture_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.picture AS picture_2, t0.title AS title_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM article_picture_translation t0 WHERE t0.translatable_id = 6;

#	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->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 380)
8	App\Entity\ArticlePicture->findTranslationByLocale (line 190)
9	App\Entity\ArticlePicture->doTranslate (line 138)
10	App\Entity\ArticlePicture->translate (line 75)
11	Twig\Extension\CoreExtension->getAttribute (line 1918)
12	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a::block_content (line 143)
13	Twig\Template->yieldBlock (line 456)
14	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 102)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->doDisplay (line 55)
17	Twig\Template->yield (line 411)
18	Twig\Template->display (line 366)
19	Twig\Template->render (line 381)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\ArticleController->show (line 36)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

3.72 ms
(12.82%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.slug AS slug_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  page_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM page_translation t0 WHERE t0.translatable_id = 1;

#	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->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 380)
8	App\Entity\Page->findTranslationByLocale (line 190)
9	App\Entity\Page->doTranslate (line 138)
10	App\Entity\Page->translate (line 75)
11	Twig\Extension\CoreExtension->getAttribute (line 1918)
12	__TwigTemplate_1a1bf423a60f3449ad521cea11506ea2::doDisplay (line 64)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_165c5dba967f717a4470a9decb00cb93->doDisplay (line 99)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->block_header (line 257)
17	Twig\Template->yieldBlock (line 456)
18	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 94)
19	Twig\Template->yield (line 411)
20	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->doDisplay (line 55)
21	Twig\Template->yield (line 411)
22	Twig\Template->display (line 366)
23	Twig\Template->render (line 381)
24	Twig\TemplateWrapper->render (line 51)
25	Twig\Environment->render (line 333)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
29	App\Controller\ArticleController->show (line 36)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 193)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 32)
35	require_once (line 5)

0.99 ms
(3.41%)

SELECT t0.id AS id_1, t0.sort AS sort_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_by AS deleted_by_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.seo_id AS seo_id_9 FROM article_category t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sort AS sort_2,
  t0.created_by AS created_by_3,
  t0.updated_by AS updated_by_4,
  t0.deleted_by AS deleted_by_5,
  t0.deleted_at AS deleted_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.seo_id AS seo_id_9
FROM
  article_category t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.sort AS sort_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_by AS deleted_by_5, t0.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.seo_id AS seo_id_9 FROM article_category t0 WHERE t0.id = '1' 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)

0.87 ms
(3.00%)

SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.sort AS sort_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.deleted_by AS deleted_by_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.seo_id AS seo_id_11 FROM article t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start AS start_2,
  t0.end AS end_3,
  t0.sort AS sort_4,
  t0.created_by AS created_by_5,
  t0.updated_by AS updated_by_6,
  t0.deleted_by AS deleted_by_7,
  t0.deleted_at AS deleted_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.seo_id AS seo_id_11
FROM
  article t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.sort AS sort_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.deleted_by AS deleted_by_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.seo_id AS seo_id_11 FROM article t0 WHERE t0.id = '2' 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)

0.86 ms
(2.96%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM article_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.slug AS slug_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  article_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.slug AS slug_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM article_translation t0 WHERE t0.translatable_id = 2;

#	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->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 380)
8	App\Entity\Article->findTranslationByLocale (line 190)
9	App\Entity\Article->doTranslate (line 138)
10	App\Entity\Article->translate (line 75)
11	Twig\Extension\CoreExtension->getAttribute (line 1918)
12	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a::block_content (line 139)
13	Twig\Template->yieldBlock (line 456)
14	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 102)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->doDisplay (line 55)
17	Twig\Template->yield (line 411)
18	Twig\Template->display (line 366)
19	Twig\Template->render (line 381)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\ArticleController->show (line 36)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.81 ms
(2.78%)

SELECT p0_.id AS id_0, p0_.is_legal AS is_legal_1, p0_.sort AS sort_2, p0_.created_by AS created_by_3, p0_.updated_by AS updated_by_4, p0_.deleted_by AS deleted_by_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.seo_id AS seo_id_8 FROM page p0_ WHERE p0_.is_legal <> 1 OR p0_.is_legal IS NULL ORDER BY p0_.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.is_legal AS is_legal_1,
  p0_.sort AS sort_2,
  p0_.created_by AS created_by_3,
  p0_.updated_by AS updated_by_4,
  p0_.deleted_by AS deleted_by_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7,
  p0_.seo_id AS seo_id_8
FROM
  page p0_
WHERE
  p0_.is_legal <> 1
  OR p0_.is_legal IS NULL
ORDER BY
  p0_.sort ASC

SELECT p0_.id AS id_0, p0_.is_legal AS is_legal_1, p0_.sort AS sort_2, p0_.created_by AS created_by_3, p0_.updated_by AS updated_by_4, p0_.deleted_by AS deleted_by_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.seo_id AS seo_id_8 FROM page p0_ WHERE p0_.is_legal <> 1 OR p0_.is_legal IS NULL ORDER BY p0_.sort ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PageRepository->getPages (line 37)
7	App\Twig\TwigExtension->listPages (line 23)
8	__TwigTemplate_1a1bf423a60f3449ad521cea11506ea2->doDisplay (line 60)
9	Twig\Template->yield (line 411)
10	__TwigTemplate_165c5dba967f717a4470a9decb00cb93->doDisplay (line 99)
11	Twig\Template->yield (line 411)
12	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->block_header (line 257)
13	Twig\Template->yieldBlock (line 456)
14	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 94)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->doDisplay (line 55)
17	Twig\Template->yield (line 411)
18	Twig\Template->display (line 366)
19	Twig\Template->render (line 381)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\ArticleController->show (line 36)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.79 ms
(2.73%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.h1 AS h1_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM seo_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.h1 AS h1_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  seo_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.h1 AS h1_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM seo_translation t0 WHERE t0.translatable_id = 3;

#	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->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 380)
8	App\Entity\Seo->findTranslationByLocale (line 190)
9	App\Entity\Seo->doTranslate (line 138)
10	App\Entity\Seo->translate (line 75)
11	App\Twig\TwigExtension->title (line 56)
12	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->block_seo (line 110)
13	Twig\Template->yieldBlock (line 456)
14	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 82)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->doDisplay (line 55)
17	Twig\Template->yield (line 411)
18	Twig\Template->display (line 366)
19	Twig\Template->render (line 381)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\ArticleController->show (line 36)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.78 ms
(2.70%)

SELECT p0_.id AS id_0, p0_.is_legal AS is_legal_1, p0_.sort AS sort_2, p0_.created_by AS created_by_3, p0_.updated_by AS updated_by_4, p0_.deleted_by AS deleted_by_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.seo_id AS seo_id_8 FROM page p0_ WHERE p0_.is_legal = 1 ORDER BY p0_.sort ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.is_legal AS is_legal_1,
  p0_.sort AS sort_2,
  p0_.created_by AS created_by_3,
  p0_.updated_by AS updated_by_4,
  p0_.deleted_by AS deleted_by_5,
  p0_.created_at AS created_at_6,
  p0_.updated_at AS updated_at_7,
  p0_.seo_id AS seo_id_8
FROM
  page p0_
WHERE
  p0_.is_legal = 1
ORDER BY
  p0_.sort ASC

SELECT p0_.id AS id_0, p0_.is_legal AS is_legal_1, p0_.sort AS sort_2, p0_.created_by AS created_by_3, p0_.updated_by AS updated_by_4, p0_.deleted_by AS deleted_by_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.seo_id AS seo_id_8 FROM page p0_ WHERE p0_.is_legal = 1 ORDER BY p0_.sort ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PageRepository->getPages (line 37)
7	App\Twig\TwigExtension->listLegalPages (line 29)
8	__TwigTemplate_f5e81b3f48af66c597a11f6468b95f04->doDisplay (line 126)
9	Twig\Template->yield (line 411)
10	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->block_footer (line 333)
11	Twig\Template->yieldBlock (line 456)
12	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 105)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->doDisplay (line 55)
15	Twig\Template->yield (line 411)
16	Twig\Template->display (line 366)
17	Twig\Template->render (line 381)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
23	App\Controller\ArticleController->show (line 36)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.77 ms
(2.65%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.picture AS picture_4, t0.slug AS slug_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM article_category_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.content AS content_3,
  t0.picture AS picture_4,
  t0.slug AS slug_5,
  t0.locale AS locale_6,
  t0.translatable_id AS translatable_id_7
FROM
  article_category_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.picture AS picture_4, t0.slug AS slug_5, t0.locale AS locale_6, t0.translatable_id AS translatable_id_7 FROM article_category_translation t0 WHERE t0.translatable_id = 1;

#	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->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 380)
8	App\Entity\ArticleCategory->findTranslationByLocale (line 190)
9	App\Entity\ArticleCategory->doTranslate (line 138)
10	App\Entity\ArticleCategory->translate (line 75)
11	Twig\Extension\CoreExtension->getAttribute (line 1918)
12	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a::block_content (line 142)
13	Twig\Template->yieldBlock (line 456)
14	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 102)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->doDisplay (line 55)
17	Twig\Template->yield (line 411)
18	Twig\Template->display (line 366)
19	Twig\Template->render (line 381)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
25	App\Controller\ArticleController->show (line 36)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.76 ms
(2.62%)

SELECT t0.id AS id_1, t0.sort AS sort_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_by AS deleted_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.article_id AS article_id_8 FROM article_picture t0 WHERE t0.article_id = ? ORDER BY t0.sort ASC

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.sort AS sort_2,
  t0.created_by AS created_by_3,
  t0.updated_by AS updated_by_4,
  t0.deleted_by AS deleted_by_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.article_id AS article_id_8
FROM
  article_picture t0
WHERE
  t0.article_id = ?
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.sort AS sort_2, t0.created_by AS created_by_3, t0.updated_by AS updated_by_4, t0.deleted_by AS deleted_by_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.article_id AS article_id_8 FROM article_picture t0 WHERE t0.article_id = 2 ORDER BY t0.sort ASC;

#	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->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_6352dd5ce8eca3c49be4344510e8f07a::block_content (line 143)
11	Twig\Template->yieldBlock (line 456)
12	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 102)
13	Twig\Template->yield (line 411)
14	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->doDisplay (line 55)
15	Twig\Template->yield (line 411)
16	Twig\Template->display (line 366)
17	Twig\Template->render (line 381)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
23	App\Controller\ArticleController->show (line 36)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	require_once (line 5)

0.76 ms
(2.61%)

SELECT t0.id AS id_1 FROM seo t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1
FROM
  seo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1 FROM seo t0 WHERE t0.id = 3;

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Seo::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Seo->__get (line 153)
7	App\Entity\Seo->getCurrentLocale (line 107)
8	App\Entity\Seo->doTranslate (line 135)
9	App\Entity\Seo->translate (line 75)
10	App\Twig\TwigExtension->title (line 56)
11	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->block_seo (line 110)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 82)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_6352dd5ce8eca3c49be4344510e8f07a->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\ArticleController->show (line 36)
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\PageTranslation	10
App\Entity\ArticlePictureTranslation	10
App\Entity\Seo	7
App\Entity\Setting	7
App\Entity\Page	5
App\Entity\ArticlePicture	5
App\Entity\SeoTranslation	2
App\Entity\ArticleTranslation	2
App\Entity\ArticleCategoryTranslation	2
App\Entity\ArticleCategory	1
App\Entity\Article	1

Entities Mapping

Class	Mapping errors
App\Entity\ArticleCategory	No errors.
App\Entity\Seo	No errors.
App\Entity\Article	No errors.
App\Entity\ArticleCategoryTranslation	No errors.
App\Entity\ArticlePicture	No errors.
App\Entity\ArticleTranslation	No errors.
App\Entity\SeoTranslation	No errors.
App\Entity\SeoMetadata	No errors.
App\Entity\SeoOg	No errors.
App\Entity\Setting	No errors.
App\Entity\Page	No errors.
App\Entity\PageTranslation	No errors.
App\Entity\ArticlePictureTranslation	No errors.

Symfony Profiler

GET https://socle-sf74.preprod.sercopw.fr/fr/article/1-categorie-d-articles-0/2-article-1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping