Symfony Profiler

Query Metrics

8 Database Queries

3 Different statements

6.07 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.51 ms
(41.38%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3 FROM template_image t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "favicon"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.img AS img_3
FROM
  template_image t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3 FROM template_image t0 WHERE t0.name = 'favicon' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 16)
5	App\Controller\Partial\FaviconController->favicon (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 86)
13	__TwigTemplate_62c19dc9a293a5dff529945b44a1211d->doDisplay (line 388)
14	Twig\Template->yield (line 59)
15	__TwigTemplate_e873f9e5ef0780c78af9f48f6c3137e7->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 334)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
24	App\Controller\AppRouterController->newsList (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

2.39 ms
(39.45%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM config t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "global"
]

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
FROM
  config t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM config t0 WHERE t0.name = 'global' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 32)
5	App\Controller\Partial\NavbarController->name (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 61)
13	__TwigTemplate_08d1599b41811d39d6ccae7b59a4dc7e->doDisplay (line 388)
14	Twig\Template->yield (line 344)
15	Twig\Template->display (line 359)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 334)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 17)
22	App\Controller\Partial\NavbarController->navbar (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
25	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
26	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
27	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
28	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
29	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 177)
30	__TwigTemplate_62c19dc9a293a5dff529945b44a1211d->doDisplay (line 388)
31	Twig\Template->yield (line 59)
32	__TwigTemplate_e873f9e5ef0780c78af9f48f6c3137e7->doDisplay (line 388)
33	Twig\Template->yield (line 344)
34	Twig\Template->display (line 359)
35	Twig\Template->render (line 51)
36	Twig\TemplateWrapper->render (line 334)
37	Twig\Environment->render (line 448)
38	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
41	App\Controller\AppRouterController->newsList (line 181)
42	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
43	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
44	Symfony\Component\HttpKernel\Kernel->handle (line 35)
45	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
46	require_once (line 5)

1.16 ms
(19.18%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.img AS img_6, t0.html AS html_7, t0.is_published AS is_published_8, t0.created_at AS created_at_9, t0.name AS name_10 FROM page t0 WHERE t0.is_published = ?

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.slug AS slug_3,
  t0.seo_title AS seo_title_4,
  t0.seo_description AS seo_description_5,
  t0.img AS img_6,
  t0.html AS html_7,
  t0.is_published AS is_published_8,
  t0.created_at AS created_at_9,
  t0.name AS name_10
FROM
  page t0
WHERE
  t0.is_published = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.seo_title AS seo_title_4, t0.seo_description AS seo_description_5, t0.img AS img_6, t0.html AS html_7, t0.is_published AS is_published_8, t0.created_at AS created_at_9, t0.name AS name_10 FROM page t0 WHERE t0.is_published = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 26)
5	App\Controller\Partial\FooterController->footer (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 193)
13	__TwigTemplate_62c19dc9a293a5dff529945b44a1211d->doDisplay (line 388)
14	Twig\Template->yield (line 59)
15	__TwigTemplate_e873f9e5ef0780c78af9f48f6c3137e7->doDisplay (line 388)
16	Twig\Template->yield (line 344)
17	Twig\Template->display (line 359)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 334)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
24	App\Controller\AppRouterController->newsList (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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.

Entities Mapping

Class	Mapping errors
App\Entity\TemplateImage	No errors.
App\Entity\Config	No errors.
App\Entity\Page	No errors.

Symfony Profiler

GET https://dev.associationdupatrimoinemouxois.fr/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CPartial%255CFooterController%…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping