Symfony Profiler

Query Metrics

7 Database Queries

5 Different statements

2.82 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.71 ms
(25.33%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4 FROM page t0

Parameters:

[]

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.description AS description_4
FROM
  page t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.description AS description_4 FROM page t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 995)
2	Doctrine\ORM\EntityRepository->findBy (line 224)
3	Doctrine\ORM\EntityRepository->findAll (line 206)
4	App\Controller\StandardController->menu (line 24)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler->handle (line 86)
8	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer::render (line 75)
9	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 81)
10	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 46)
11	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 41)
12	__TwigTemplate_00209ee0e3b583cfc9859cf41e50d6a5->doDisplay (line 249)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_8f63cd17499fa5dd888681ff1ac6043e->doDisplay (line 57)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
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\EventController->show (line 43)
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.64 ms
(22.60%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.is_start_fix AS is_start_fix_5, t0.is_end_fix AS is_end_fix_6, t0.date_interval AS date_interval_7, t0.steps AS steps_8 FROM date_range t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4,
  t0.is_start_fix AS is_start_fix_5,
  t0.is_end_fix AS is_end_fix_6,
  t0.date_interval AS date_interval_7,
  t0.steps AS steps_8
FROM
  date_range t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.is_start_fix AS is_start_fix_5, t0.is_end_fix AS is_end_fix_6, t0.date_interval AS date_interval_7, t0.steps AS steps_8 FROM date_range t0 WHERE t0.id = 7;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\App\Entity\DateRange::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\DateRange->__get (line 153)
7	App\Entity\DateRange->getLabel (line 51)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_fcb1f62c92b0768a8074d0d5cee0951d::doDisplay (line 80)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_8f63cd17499fa5dd888681ff1ac6043e->block_header (line 104)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_00209ee0e3b583cfc9859cf41e50d6a5->doDisplay (line 190)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_8f63cd17499fa5dd888681ff1ac6043e->doDisplay (line 57)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
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\EventController->show (line 43)
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.63 ms
(22.52%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.copyright AS copyright_4, t0.description AS description_5 FROM image t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.name AS name_3,
  t0.copyright AS copyright_4,
  t0.description AS description_5
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.name AS name_3, t0.copyright AS copyright_4, t0.description AS description_5 FROM image t0 WHERE t0.id = 6;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\App\Entity\Image::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Image->__get (line 153)
7	App\Entity\Image->getFilename (line 36)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_fcb1f62c92b0768a8074d0d5cee0951d::doDisplay (line 55)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_8f63cd17499fa5dd888681ff1ac6043e->block_header (line 104)
12	Twig\Template->yieldBlock (line 446)
13	__TwigTemplate_00209ee0e3b583cfc9859cf41e50d6a5->doDisplay (line 190)
14	Twig\Template->yield (line 402)
15	__TwigTemplate_8f63cd17499fa5dd888681ff1ac6043e->doDisplay (line 57)
16	Twig\Template->yield (line 402)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 373)
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\EventController->show (line 43)
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.50 ms
(17.63%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.sources AS sources_5, t0.is_visible AS is_visible_6, t0.teaser AS teaser_7, t0.range_id AS range_id_8, t0.image_id AS image_id_9 FROM event t0 WHERE t0.id = ? AND (( t0.is_visible = 1 ))

Parameters:

[
  "6"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.short_description AS short_description_4,
  t0.sources AS sources_5,
  t0.is_visible AS is_visible_6,
  t0.teaser AS teaser_7,
  t0.range_id AS range_id_8,
  t0.image_id AS image_id_9
FROM
  event t0
WHERE
  t0.id = ?
  AND (
    (t0.is_visible = 1)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.short_description AS short_description_4, t0.sources AS sources_5, t0.is_visible AS is_visible_6, t0.teaser AS teaser_7, t0.range_id AS range_id_8, t0.image_id AS image_id_9 FROM event t0 WHERE t0.id = '6' AND (( t0.is_visible = 1 ));

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

0.34 ms
(11.92%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.description AS description_4, t0.range_id AS range_id_5, t0.image_id AS image_id_6 FROM chapter t0 WHERE t0.id = ? AND (( t0.is_visible = 1 ))

Parameters:

[
  "4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_visible AS is_visible_3,
  t0.description AS description_4,
  t0.range_id AS range_id_5,
  t0.image_id AS image_id_6
FROM
  chapter t0
WHERE
  t0.id = ?
  AND (
    (t0.is_visible = 1)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.description AS description_4, t0.range_id AS range_id_5, t0.image_id AS image_id_6 FROM chapter t0 WHERE t0.id = '4' AND (( t0.is_visible = 1 ));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
9	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	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\DateRange	2
App\Entity\Image	2
App\Entity\Event	1
App\Entity\Chapter	1
App\Entity\Page	1

Entities Mapping

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\DateRange	No errors.
App\Entity\Image	No errors.
App\Entity\EventChapter	No errors.
App\Entity\Chapter	No errors.
App\Entity\CharacterChapter	No errors.
App\Entity\Theme	No errors.
App\Entity\Page	No errors.
App\Entity\Character	No errors.

Symfony Profiler

GET https://biceps-history.mat.biceps.ch/evenement/6/4/detail

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping