Symfony Profiler

Query Metrics

40 Database Queries

7 Different statements

5.41 ms Query time

0 Invalid entities

67 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.89 ms
(35.02%)

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 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Service\SettingHandler->get (line 18)
5	Twig\Extension\CoreExtension->getAttribute (line 1996)
6	__TwigTemplate_2b9e31daf904749848a6ffb326e0a02e::doDisplay (line 64)
7	Twig\Template->yield (line 461)
8	__TwigTemplate_c7f756cd658130345a91fc337bbe8424->block_header (line 266)
9	Twig\Template->yieldBlock (line 493)
10	__TwigTemplate_c7f756cd658130345a91fc337bbe8424->doDisplay (line 103)
11	Twig\Template->yield (line 461)
12	__TwigTemplate_44c5f575c85c8dd3d504321c7e263104->doDisplay (line 56)
13	Twig\Template->yield (line 461)
14	Twig\Template->display (line 416)
15	Twig\Template->render (line 431)
16	Twig\TemplateWrapper->render (line 53)
17	Twig\Environment->render (line 343)
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\ProductController->index (line 17)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 195)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 5)

1.30 ms
(24.07%)

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 product_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
  product_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 product_category_translation t0 WHERE t0.translatable_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 382)
8	App\Entity\ProductCategory->findTranslationByLocale (line 190)
9	App\Entity\ProductCategory->doTranslate (line 138)
10	App\Entity\ProductCategory->translate (line 75)
11	Twig\Extension\CoreExtension->getAttribute (line 1996)
12	__TwigTemplate_44c5f575c85c8dd3d504321c7e263104::block_content (line 125)
13	Twig\Template->yieldBlock (line 493)
14	__TwigTemplate_c7f756cd658130345a91fc337bbe8424->doDisplay (line 111)
15	Twig\Template->yield (line 461)
16	__TwigTemplate_44c5f575c85c8dd3d504321c7e263104->doDisplay (line 56)
17	Twig\Template->yield (line 461)
18	Twig\Template->display (line 416)
19	Twig\Template->render (line 431)
20	Twig\TemplateWrapper->render (line 53)
21	Twig\Environment->render (line 343)
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\ProductController->index (line 17)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 195)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	require_once (line 5)

0.69 ms
(12.68%)

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:

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

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
5	Doctrine\ORM\PersistentCollection->initialize (line 188)
6	Doctrine\Common\Collections\AbstractLazyCollection->get (line 120)
7	Doctrine\ORM\PersistentCollection->get (line 382)
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 1996)
12	__TwigTemplate_49c5c668499e46d53da2b2ee045c91a6::doDisplay (line 66)
13	Twig\Template->yield (line 461)
14	__TwigTemplate_2b9e31daf904749848a6ffb326e0a02e->doDisplay (line 104)
15	Twig\Template->yield (line 461)
16	__TwigTemplate_c7f756cd658130345a91fc337bbe8424->block_header (line 266)
17	Twig\Template->yieldBlock (line 493)
18	__TwigTemplate_c7f756cd658130345a91fc337bbe8424->doDisplay (line 103)
19	Twig\Template->yield (line 461)
20	__TwigTemplate_44c5f575c85c8dd3d504321c7e263104->doDisplay (line 56)
21	Twig\Template->yield (line 461)
22	Twig\Template->display (line 416)
23	Twig\Template->render (line 431)
24	Twig\TemplateWrapper->render (line 53)
25	Twig\Environment->render (line 343)
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\ProductController->index (line 17)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 195)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
34	require_once (line 32)
35	require_once (line 5)

0.63 ms
(11.68%)

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.parent_id AS parent_id_9, t0.seo_id AS seo_id_10 FROM product_category t0 WHERE t0.deleted_at IS NULL AND t0.parent_id IS NULL ORDER BY t0.sort ASC

Parameters:

[]

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.parent_id AS parent_id_9,
  t0.seo_id AS seo_id_10
FROM
  product_category t0
WHERE
  t0.deleted_at IS NULL
  AND t0.parent_id IS NULL
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.deleted_at AS deleted_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.parent_id AS parent_id_9, t0.seo_id AS seo_id_10 FROM product_category t0 WHERE t0.deleted_at IS NULL AND t0.parent_id IS NULL ORDER BY t0.sort ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 111)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\ProductController->index (line 18)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 195)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.39 ms
(7.19%)

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/product"
]

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/product' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 126)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Twig\TwigExtension->title (line 58)
5	__TwigTemplate_c7f756cd658130345a91fc337bbe8424->block_seo (line 190)
6	Twig\Template->yieldBlock (line 493)
7	__TwigTemplate_c7f756cd658130345a91fc337bbe8424->doDisplay (line 87)
8	Twig\Template->yield (line 461)
9	__TwigTemplate_44c5f575c85c8dd3d504321c7e263104->doDisplay (line 56)
10	Twig\Template->yield (line 461)
11	Twig\Template->display (line 416)
12	Twig\Template->render (line 431)
13	Twig\TemplateWrapper->render (line 53)
14	Twig\Environment->render (line 343)
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\ProductController->index (line 17)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 195)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
23	require_once (line 32)
24	require_once (line 5)

0.32 ms
(5.86%)

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_49c5c668499e46d53da2b2ee045c91a6->doDisplay (line 62)
9	Twig\Template->yield (line 461)
10	__TwigTemplate_2b9e31daf904749848a6ffb326e0a02e->doDisplay (line 104)
11	Twig\Template->yield (line 461)
12	__TwigTemplate_c7f756cd658130345a91fc337bbe8424->block_header (line 266)
13	Twig\Template->yieldBlock (line 493)
14	__TwigTemplate_c7f756cd658130345a91fc337bbe8424->doDisplay (line 103)
15	Twig\Template->yield (line 461)
16	__TwigTemplate_44c5f575c85c8dd3d504321c7e263104->doDisplay (line 56)
17	Twig\Template->yield (line 461)
18	Twig\Template->display (line 416)
19	Twig\Template->render (line 431)
20	Twig\TemplateWrapper->render (line 53)
21	Twig\Environment->render (line 343)
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\ProductController->index (line 17)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 195)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	require_once (line 5)

0.19 ms
(3.50%)

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_385cfbe3076dea7b4f8764bd4d9a373f->doDisplay (line 131)
9	Twig\Template->yield (line 461)
10	__TwigTemplate_c7f756cd658130345a91fc337bbe8424->block_footer (line 342)
11	Twig\Template->yieldBlock (line 493)
12	__TwigTemplate_c7f756cd658130345a91fc337bbe8424->doDisplay (line 114)
13	Twig\Template->yield (line 461)
14	__TwigTemplate_44c5f575c85c8dd3d504321c7e263104->doDisplay (line 56)
15	Twig\Template->yield (line 461)
16	Twig\Template->display (line 416)
17	Twig\Template->render (line 431)
18	Twig\TemplateWrapper->render (line 53)
19	Twig\Environment->render (line 343)
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\ProductController->index (line 17)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 185)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 195)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
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\ProductCategoryTranslation	20
App\Entity\Seo	15
App\Entity\ProductCategory	10
App\Entity\PageTranslation	10
App\Entity\Setting	7
App\Entity\Page	5

Entities Mapping

Class	Mapping errors
App\Entity\ProductCategory	No errors.
App\Entity\Seo	No errors.
App\Entity\Product	No errors.
App\Entity\ProductCategoryTranslation	No errors.
App\Entity\StaticUrl	No errors.
App\Entity\Setting	No errors.
App\Entity\Page	No errors.
App\Entity\PageTranslation	No errors.

Symfony Profiler

GET https://socle-sf74.preprod.sercopw.fr/fr/product

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping