Symfony Profiler

Query Metrics

12 Database Queries

8 Different statements

4.35 ms Query time

0 Invalid entities

16 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.56 ms
(35.89%)

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:

[
  37
]

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

#	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->getStartAtRaw (line 68)
8	App\Controller\ChapterController->show (line 148)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.55 ms
(12.58%)

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:

[
  "13"
]

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 = '13' 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.47 ms
(10.83%)

SELECT t0.id AS id_1, t0.text_align AS text_align_2, t0.position_left AS position_left_3, t0.position_top AS position_top_4, t0.character_id AS character_id_5, t6.id AS id_7, t6.name AS name_8, t6.description AS description_9, t6.short_description AS short_description_10, t6.sources AS sources_11, t6.is_visible AS is_visible_12, t6.teaser AS teaser_13, t6.range_id AS range_id_14, t6.image_id AS image_id_15, t0.chapter_id AS chapter_id_16 FROM character_chapter t0 INNER JOIN `character` t6 ON t0.character_id = t6.id AND (( t6.is_visible = 1 )) WHERE t0.chapter_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.text_align AS text_align_2,
  t0.position_left AS position_left_3,
  t0.position_top AS position_top_4,
  t0.character_id AS character_id_5,
  t6.id AS id_7,
  t6.name AS name_8,
  t6.description AS description_9,
  t6.short_description AS short_description_10,
  t6.sources AS sources_11,
  t6.is_visible AS is_visible_12,
  t6.teaser AS teaser_13,
  t6.range_id AS range_id_14,
  t6.image_id AS image_id_15,
  t0.chapter_id AS chapter_id_16
FROM
  character_chapter t0
  INNER JOIN `character` t6 ON t0.character_id = t6.id
  AND (
    (t6.is_visible = 1)
  )
WHERE
  t0.chapter_id = ?

SELECT t0.id AS id_1, t0.text_align AS text_align_2, t0.position_left AS position_left_3, t0.position_top AS position_top_4, t0.character_id AS character_id_5, t6.id AS id_7, t6.name AS name_8, t6.description AS description_9, t6.short_description AS short_description_10, t6.sources AS sources_11, t6.is_visible AS is_visible_12, t6.teaser AS teaser_13, t6.range_id AS range_id_14, t6.image_id AS image_id_15, t0.chapter_id AS chapter_id_16 FROM character_chapter t0 INNER JOIN `character` t6 ON t0.character_id = t6.id AND (( t6.is_visible = 1 )) WHERE t0.chapter_id = 13;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Controller\ChapterController->show (line 207)
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)

0.43 ms
(9.82%)

SELECT t0.id AS id_1, t0.text_align AS text_align_2, t0.position_left AS position_left_3, t0.position_top AS position_top_4, t0.event_id AS event_id_5, t6.id AS id_7, t6.name AS name_8, t6.description AS description_9, t6.short_description AS short_description_10, t6.sources AS sources_11, t6.is_visible AS is_visible_12, t6.teaser AS teaser_13, t6.range_id AS range_id_14, t6.image_id AS image_id_15, t0.chapter_id AS chapter_id_16 FROM event_chapter t0 INNER JOIN event t6 ON t0.event_id = t6.id AND (( t6.is_visible = 1 )) WHERE t0.chapter_id = ?

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.text_align AS text_align_2,
  t0.position_left AS position_left_3,
  t0.position_top AS position_top_4,
  t0.event_id AS event_id_5,
  t6.id AS id_7,
  t6.name AS name_8,
  t6.description AS description_9,
  t6.short_description AS short_description_10,
  t6.sources AS sources_11,
  t6.is_visible AS is_visible_12,
  t6.teaser AS teaser_13,
  t6.range_id AS range_id_14,
  t6.image_id AS image_id_15,
  t0.chapter_id AS chapter_id_16
FROM
  event_chapter t0
  INNER JOIN event t6 ON t0.event_id = t6.id
  AND (
    (t6.is_visible = 1)
  )
WHERE
  t0.chapter_id = ?

SELECT t0.id AS id_1, t0.text_align AS text_align_2, t0.position_left AS position_left_3, t0.position_top AS position_top_4, t0.event_id AS event_id_5, t6.id AS id_7, t6.name AS name_8, t6.description AS description_9, t6.short_description AS short_description_10, t6.sources AS sources_11, t6.is_visible AS is_visible_12, t6.teaser AS teaser_13, t6.range_id AS range_id_14, t6.image_id AS image_id_15, t0.chapter_id AS chapter_id_16 FROM event_chapter t0 INNER JOIN event t6 ON t0.event_id = t6.id AND (( t6.is_visible = 1 )) WHERE t0.chapter_id = 13;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Controller\ChapterController->show (line 201)
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)

0.37 ms
(8.51%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_visible AS is_visible_3, t0.is_group AS is_group_4, t0.ordering AS ordering_5, t0.description AS description_6, t0.short_description AS short_description_7, t0.sources AS sources_8, t0.chapter_id AS chapter_id_9, t0.parent_id AS parent_id_10 FROM theme t0 WHERE t0.chapter_id = ? AND (( t0.is_visible = 1 )) ORDER BY t0.ordering ASC

Parameters:

[
  13
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.is_visible AS is_visible_3,
  t0.is_group AS is_group_4,
  t0.ordering AS ordering_5,
  t0.description AS description_6,
  t0.short_description AS short_description_7,
  t0.sources AS sources_8,
  t0.chapter_id AS chapter_id_9,
  t0.parent_id AS parent_id_10
FROM
  theme t0
WHERE
  t0.chapter_id = ?
  AND (
    (t0.is_visible = 1)
  )
ORDER BY
  t0.ordering ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.is_visible AS is_visible_3, t0.is_group AS is_group_4, t0.ordering AS ordering_5, t0.description AS description_6, t0.short_description AS short_description_7, t0.sources AS sources_8, t0.chapter_id AS chapter_id_9, t0.parent_id AS parent_id_10 FROM theme t0 WHERE t0.chapter_id = 13 AND (( t0.is_visible = 1 )) ORDER BY t0.ordering ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\Chapter->getRootThemes (line 197)
8	App\Controller\ChapterController->show (line 161)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.34 ms
(7.91%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.color AS color_4, t0.range_id AS range_id_5, t0.image_id AS image_id_6 FROM period t0 WHERE (( t0.is_visible = 1 ))

Parameters:

[]

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.color AS color_4,
  t0.range_id AS range_id_5,
  t0.image_id AS image_id_6
FROM
  period t0
WHERE
  (
    (t0.is_visible = 1)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_visible AS is_visible_3, t0.color AS color_4, t0.range_id AS range_id_5, t0.image_id AS image_id_6 FROM period t0 WHERE (( t0.is_visible = 1 ));

#	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\ChapterController->show (line 147)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.32 ms
(7.31%)

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:

[
  83
]

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

#	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_c83af2a39cc5c4e61e0759bcd0853669::block_header (line 108)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_00209ee0e3b583cfc9859cf41e50d6a5->doDisplay (line 190)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_c83af2a39cc5c4e61e0759bcd0853669->doDisplay (line 57)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
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\ChapterController->show (line 220)
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)

0.31 ms
(7.15%)

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_c83af2a39cc5c4e61e0759bcd0853669->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\ChapterController->show (line 220)
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\DateRange	5
App\Entity\Image	5
App\Entity\Period	4
App\Entity\Chapter	1
App\Entity\Page	1

Entities Mapping

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

Symfony Profiler

GET https://biceps-history.mat.biceps.ch/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CStandardController%253A%253Amenu

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping