Symfony Profiler

Query Metrics

92 Database Queries

13 Different statements

72.02 ms Query time

0 Invalid entities

253 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.25 ms
(21.17%)

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:

[
  21
]

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

#	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_bd869420a7aa19eda12735377da8380e::block_content (line 137)
13	Twig\Template->yieldBlock (line 456)
14	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 102)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_bd869420a7aa19eda12735377da8380e->doDisplay (line 54)
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->list (line 27)
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)

14.89 ms
(20.67%)

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:

[
  21
]

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 = 21 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->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_bd869420a7aa19eda12735377da8380e::block_content (line 138)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 102)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_bd869420a7aa19eda12735377da8380e->doDisplay (line 54)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\ArticleController->list (line 27)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

14.43 ms
(20.03%)

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:

[
  101
]

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

#	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_bd869420a7aa19eda12735377da8380e::block_content (line 139)
13	Twig\Template->yieldBlock (line 456)
14	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 102)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_bd869420a7aa19eda12735377da8380e->doDisplay (line 54)
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->list (line 27)
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)

13.33 ms
(18.51%)

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_bd869420a7aa19eda12735377da8380e->doDisplay (line 54)
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->list (line 27)
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)

4.43 ms
(6.15%)

SELECT a0_.id AS id_0, a0_.start AS start_1, a0_.end AS end_2, a0_.sort AS sort_3, a0_.created_by AS created_by_4, a0_.updated_by AS updated_by_5, a0_.deleted_by AS deleted_by_6, a0_.deleted_at AS deleted_at_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_id AS seo_id_10 FROM article a0_ LEFT JOIN article_article_category a2_ ON a0_.id = a2_.article_id LEFT JOIN article_category a1_ ON a1_.id = a2_.article_category_id WHERE a0_.deleted_at IS NULL AND (a0_.start IS NULL OR a0_.start >= ?) AND (a0_.end IS NULL OR a0_.end <= ?) AND a1_.id = 2 AND a1_.deleted_at IS NULL ORDER BY a1_.sort ASC, a0_.sort ASC

Parameters:

[
  "2026-06-17 11:24:27"
  "2026-06-17 11:24:27"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.start AS start_1,
  a0_.end AS end_2,
  a0_.sort AS sort_3,
  a0_.created_by AS created_by_4,
  a0_.updated_by AS updated_by_5,
  a0_.deleted_by AS deleted_by_6,
  a0_.deleted_at AS deleted_at_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.seo_id AS seo_id_10
FROM
  article a0_
  LEFT JOIN article_article_category a2_ ON a0_.id = a2_.article_id
  LEFT JOIN article_category a1_ ON a1_.id = a2_.article_category_id
WHERE
  a0_.deleted_at IS NULL
  AND (
    a0_.start IS NULL
    OR a0_.start >= ?
  )
  AND (
    a0_.end IS NULL
    OR a0_.end <= ?
  )
  AND a1_.id = 2
  AND a1_.deleted_at IS NULL
ORDER BY
  a1_.sort ASC,
  a0_.sort ASC

SELECT a0_.id AS id_0, a0_.start AS start_1, a0_.end AS end_2, a0_.sort AS sort_3, a0_.created_by AS created_by_4, a0_.updated_by AS updated_by_5, a0_.deleted_by AS deleted_by_6, a0_.deleted_at AS deleted_at_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.seo_id AS seo_id_10 FROM article a0_ LEFT JOIN article_article_category a2_ ON a0_.id = a2_.article_id LEFT JOIN article_category a1_ ON a1_.id = a2_.article_category_id WHERE a0_.deleted_at IS NULL AND (a0_.start IS NULL OR a0_.start >= '2026-06-17 11:24:27') AND (a0_.end IS NULL OR a0_.end <= '2026-06-17 11:24:27') AND a1_.id = 2 AND a1_.deleted_at IS NULL ORDER BY a1_.sort ASC, a0_.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\ArticleRepository->getArticles (line 48)
7	App\Controller\ArticleController->list (line 26)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
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)

3.79 ms
(5.27%)

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_bd869420a7aa19eda12735377da8380e->doDisplay (line 54)
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->list (line 27)
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.98 ms
(1.36%)

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 = ?

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.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 = ?

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 = '2';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.97 ms
(1.35%)

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_bd869420a7aa19eda12735377da8380e->doDisplay (line 54)
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->list (line 27)
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.84 ms
(1.17%)

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:

[
  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.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 = 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\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_bd869420a7aa19eda12735377da8380e::block_content (line 111)
13	Twig\Template->yieldBlock (line 456)
14	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 102)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_bd869420a7aa19eda12735377da8380e->doDisplay (line 54)
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->list (line 27)
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.80 ms
(1.11%)

SELECT t0.id AS id_1, t0.url AS url_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.seo_id AS seo_id_8 FROM static_url t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "/fr/article/2-categorie-d-articles-1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_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.seo_id AS seo_id_8
FROM
  static_url t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_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.seo_id AS seo_id_8 FROM static_url t0 WHERE t0.url = '/fr/article/2-categorie-d-articles-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	App\Twig\TwigExtension->title (line 58)
5	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->block_seo (line 181)
6	Twig\Template->yieldBlock (line 456)
7	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 82)
8	Twig\Template->yield (line 411)
9	__TwigTemplate_bd869420a7aa19eda12735377da8380e->doDisplay (line 54)
10	Twig\Template->yield (line 411)
11	Twig\Template->display (line 366)
12	Twig\Template->render (line 381)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
18	App\Controller\ArticleController->list (line 27)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.80 ms
(1.11%)

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

Parameters:

[
  22
]

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

#	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->h1 (line 37)
11	__TwigTemplate_bd869420a7aa19eda12735377da8380e->block_content (line 112)
12	Twig\Template->yieldBlock (line 456)
13	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 102)
14	Twig\Template->yield (line 411)
15	__TwigTemplate_bd869420a7aa19eda12735377da8380e->doDisplay (line 54)
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->list (line 27)
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.79 ms
(1.09%)

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:

[
  22
]

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

#	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->h1 (line 37)
12	__TwigTemplate_bd869420a7aa19eda12735377da8380e->block_content (line 112)
13	Twig\Template->yieldBlock (line 456)
14	__TwigTemplate_e6fb805884017bc5f9d81b5af55e1ffa->doDisplay (line 102)
15	Twig\Template->yield (line 411)
16	__TwigTemplate_bd869420a7aa19eda12735377da8380e->doDisplay (line 54)
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->list (line 27)
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.72 ms
(1.00%)

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_bd869420a7aa19eda12735377da8380e->doDisplay (line 54)
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->list (line 27)
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)

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\ArticlePicture	100
App\Entity\ArticleTranslation	40
App\Entity\ArticlePictureTranslation	40
App\Entity\Seo	26
App\Entity\Article	20
App\Entity\PageTranslation	10
App\Entity\Setting	7
App\Entity\Page	5
App\Entity\ArticleCategoryTranslation	2
App\Entity\SeoTranslation	2
App\Entity\ArticleCategory	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\StaticUrl	No errors.
App\Entity\Setting	No errors.
App\Entity\Page	No errors.
App\Entity\PageTranslation	No errors.
App\Entity\SeoTranslation	No errors.
App\Entity\SeoMetadata	No errors.
App\Entity\SeoOg	No errors.
App\Entity\ArticlePictureTranslation	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping