Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

20.08 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

17.86 ms
(88.94%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.variable AS variable_3, t0.uri AS uri_4, t0.content AS content_5, t0.active AS active_6, t0.created AS created_7, t0.seo_meta_title AS seo_meta_title_8, t0.seo_meta_description AS seo_meta_description_9, t0.seo_meta_keywords AS seo_meta_keywords_10, t0.seo_og_title AS seo_og_title_11, t0.seo_og_description AS seo_og_description_12, t0.seo_tt_title AS seo_tt_title_13, t0.seo_tt_description AS seo_tt_description_14, t0.seo_tt_cover_alt AS seo_tt_cover_alt_15, t0.seo_tt_card AS seo_tt_card_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.slug AS slug_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22 FROM page t0 WHERE t0.uri = ? AND t0.active = ? LIMIT 1

Parameters:

[
  ""
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.variable AS variable_3,
  t0.uri AS uri_4,
  t0.content AS content_5,
  t0.active AS active_6,
  t0.created AS created_7,
  t0.seo_meta_title AS seo_meta_title_8,
  t0.seo_meta_description AS seo_meta_description_9,
  t0.seo_meta_keywords AS seo_meta_keywords_10,
  t0.seo_og_title AS seo_og_title_11,
  t0.seo_og_description AS seo_og_description_12,
  t0.seo_tt_title AS seo_tt_title_13,
  t0.seo_tt_description AS seo_tt_description_14,
  t0.seo_tt_cover_alt AS seo_tt_cover_alt_15,
  t0.seo_tt_card AS seo_tt_card_16,
  t0.created_by AS created_by_17,
  t0.updated_by AS updated_by_18,
  t0.deleted_by AS deleted_by_19,
  t0.slug AS slug_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22
FROM
  page t0
WHERE
  t0.uri = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.variable AS variable_3, t0.uri AS uri_4, t0.content AS content_5, t0.active AS active_6, t0.created AS created_7, t0.seo_meta_title AS seo_meta_title_8, t0.seo_meta_description AS seo_meta_description_9, t0.seo_meta_keywords AS seo_meta_keywords_10, t0.seo_og_title AS seo_og_title_11, t0.seo_og_description AS seo_og_description_12, t0.seo_tt_title AS seo_tt_title_13, t0.seo_tt_description AS seo_tt_description_14, t0.seo_tt_cover_alt AS seo_tt_cover_alt_15, t0.seo_tt_card AS seo_tt_card_16, t0.created_by AS created_by_17, t0.updated_by AS updated_by_18, t0.deleted_by AS deleted_by_19, t0.slug AS slug_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22 FROM page t0 WHERE t0.uri = '' AND t0.active = 1 LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	App\Utils\Managers\BaseManager->findOneBy (line 112)
7	App\Controller\Front\PageController->renderPage (line 65)
8	App\Controller\Front\PageController->index (line 32)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

1.29 ms
(6.44%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.ref AS ref_3, t0.content AS content_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.deleted_by AS deleted_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM autocomponent t0 WHERE t0.ref = ? LIMIT 1

Parameters:

[
  "##menu##"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ref AS ref_3,
  t0.content AS content_4,
  t0.created_by AS created_by_5,
  t0.updated_by AS updated_by_6,
  t0.deleted_by AS deleted_by_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  autocomponent t0
WHERE
  t0.ref = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.ref AS ref_3, t0.content AS content_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.deleted_by AS deleted_by_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM autocomponent t0 WHERE t0.ref = '##menu##' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	App\Utils\Managers\BaseManager->findOneBy (line 112)
6	App\Twig\InjectVariablesExtension->replaceContentWithRenders (line 84)
7	App\Twig\InjectVariablesExtension->injectVariables (line 57)
8	__TwigTemplate_326cc287285f96e708eb35e15cd2b9fb->block_body (line 191)
9	Twig\Template->yieldBlock (line 446)
10	__TwigTemplate_dfb1b9802f185b879d204976886e94a4->doDisplay (line 139)
11	Twig\Template->yield (line 402)
12	__TwigTemplate_326cc287285f96e708eb35e15cd2b9fb->doDisplay (line 59)
13	Twig\Template->yield (line 402)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 373)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
21	App\Controller\Front\PageController->index (line 31)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 182)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

0.57 ms
(2.86%)

SELECT p0_.variable AS variable_0, p0_.uri AS uri_1, p0_.name AS name_2 FROM page p0_ ORDER BY p0_.variable ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.variable AS variable_0,
  p0_.uri AS uri_1,
  p0_.name AS name_2
FROM
  page p0_
ORDER BY
  p0_.variable ASC

SELECT p0_.variable AS variable_0, p0_.uri AS uri_1, p0_.name AS name_2 FROM page p0_ ORDER BY p0_.variable ASC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 234)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 105)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
5	Doctrine\ORM\Query->_doExecute (line 296)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
7	Doctrine\ORM\AbstractQuery->execute (line 886)
8	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
9	App\Repository\PageRepository->getAllVariables (line 56)
10	App\Utils\Managers\Website\PageManager->getAllVariables (line 40)
11	App\Twig\InjectVariablesExtension->getVariablesKeyValue (line 125)
12	App\Twig\InjectVariablesExtension->replaceContentWithVariables (line 107)
13	App\Twig\InjectVariablesExtension->injectVariables (line 58)
14	__TwigTemplate_326cc287285f96e708eb35e15cd2b9fb->block_body (line 191)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_dfb1b9802f185b879d204976886e94a4->doDisplay (line 139)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_326cc287285f96e708eb35e15cd2b9fb->doDisplay (line 59)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
27	App\Controller\Front\PageController->index (line 31)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	require_once (line 5)

0.35 ms
(1.75%)

SELECT v0_.v_key AS v_key_0, v0_.v_value AS v_value_1, v0_.name AS name_2 FROM variable v0_ ORDER BY v0_.v_key ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.v_key AS v_key_0,
  v0_.v_value AS v_value_1,
  v0_.name AS name_2
FROM
  variable v0_
ORDER BY
  v0_.v_key ASC

SELECT v0_.v_key AS v_key_0, v0_.v_value AS v_value_1, v0_.name AS name_2 FROM variable v0_ ORDER BY v0_.v_key ASC;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 234)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 105)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
5	Doctrine\ORM\Query->_doExecute (line 296)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
7	Doctrine\ORM\AbstractQuery->execute (line 886)
8	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
9	App\Repository\VariableRepository->getAllVariables (line 49)
10	App\Utils\Managers\Website\VariableManager->getAllVariables (line 40)
11	App\Twig\InjectVariablesExtension->getVariablesKeyValue (line 130)
12	App\Twig\InjectVariablesExtension->replaceContentWithVariables (line 107)
13	App\Twig\InjectVariablesExtension->injectVariables (line 58)
14	__TwigTemplate_326cc287285f96e708eb35e15cd2b9fb->block_body (line 191)
15	Twig\Template->yieldBlock (line 446)
16	__TwigTemplate_dfb1b9802f185b879d204976886e94a4->doDisplay (line 139)
17	Twig\Template->yield (line 402)
18	__TwigTemplate_326cc287285f96e708eb35e15cd2b9fb->doDisplay (line 59)
19	Twig\Template->yield (line 402)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 373)
22	Twig\TemplateWrapper->render (line 51)
23	Twig\Environment->render (line 333)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 463)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 468)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 282)
27	App\Controller\Front\PageController->index (line 31)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
30	Symfony\Component\HttpKernel\Kernel->handle (line 182)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
32	require_once (line 32)
33	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\Autocomponent	2
App\Entity\Page	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Variable	No errors.
App\Entity\Autocomponent	No errors.

Symfony Profiler

GET https://recette.lourmel-sa.com/?XDEBUG_SESSION_START=phpstorm

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping