Symfony Profiler

Query Metrics

131 Database Queries

4 Different statements

32.19 ms Query time

0 Invalid entities

385 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

30.00 ms
(93.21%)

128

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:

[
  74
]

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

#	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->timeline (line 77)
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.95 ms
(2.96%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_visible AS is_visible_2, c0_.description AS description_3, c0_.range_id AS range_id_4, c0_.image_id AS image_id_5 FROM chapter c0_ LEFT JOIN date_range d1_ ON (c0_.range_id = d1_.id) WHERE ( c0_.is_visible = 1 ) ORDER BY d1_.start_at ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.is_visible AS is_visible_2,
  c0_.description AS description_3,
  c0_.range_id AS range_id_4,
  c0_.image_id AS image_id_5
FROM
  chapter c0_
  LEFT JOIN date_range d1_ ON (c0_.range_id = d1_.id)
WHERE
  (c0_.is_visible = 1)
ORDER BY
  d1_.start_at ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_visible AS is_visible_2, c0_.description AS description_3, c0_.range_id AS range_id_4, c0_.image_id AS image_id_5 FROM chapter c0_ LEFT JOIN date_range d1_ ON (c0_.range_id = d1_.id) WHERE ( c0_.is_visible = 1 ) ORDER BY d1_.start_at ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\ChapterRepository->findAllOrdered (line 60)
7	App\Controller\ChapterController->timeline (line 70)
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.68 ms
(2.12%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_visible AS is_visible_2, p0_.color AS color_3, p0_.range_id AS range_id_4, p0_.image_id AS image_id_5 FROM period p0_ LEFT JOIN date_range d1_ ON (p0_.range_id = d1_.id) WHERE ( p0_.is_visible = 1 ) ORDER BY d1_.start_at ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.is_visible AS is_visible_2,
  p0_.color AS color_3,
  p0_.range_id AS range_id_4,
  p0_.image_id AS image_id_5
FROM
  period p0_
  LEFT JOIN date_range d1_ ON (p0_.range_id = d1_.id)
WHERE
  (p0_.is_visible = 1)
ORDER BY
  d1_.start_at ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.is_visible AS is_visible_2, p0_.color AS color_3, p0_.range_id AS range_id_4, p0_.image_id AS image_id_5 FROM period p0_ LEFT JOIN date_range d1_ ON (p0_.range_id = d1_.id) WHERE ( p0_.is_visible = 1 ) ORDER BY d1_.start_at ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	App\Repository\PeriodRepository->findAllOrdered (line 58)
7	App\Controller\ChapterController->timeline (line 69)
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.55 ms
(1.71%)

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_64a728d3040b5139f12f7798e3cf23d1->doDisplay (line 63)
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->timeline (line 101)
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	128
App\Entity\Image	128
App\Entity\Chapter	124
App\Entity\Period	4
App\Entity\Page	1

Entities Mapping

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

Symfony Profiler

GET https://biceps-history.mat.biceps.ch/chapitres/chronologie

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping