Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

5.70 ms Query time

0 Invalid entities

13 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.64 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.orientation AS orientation_3, a0_.sequence AS sequence_4, a0_.online AS online_5, a0_.image AS image_6, a0_.header_image AS header_image_7, a0_.lat AS lat_8, a0_.lng AS lng_9, a0_.zoom AS zoom_10, a0_.rock_responsibility AS rock_responsibility_11, a0_.railway_station AS railway_station_12, a0_.kletterkonzeption AS kletterkonzeption_13 FROM area a0_ WHERE a0_.online = 1 ORDER BY a0_.sequence ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.orientation AS orientation_3,
  a0_.sequence AS sequence_4,
  a0_.online AS online_5,
  a0_.image AS image_6,
  a0_.header_image AS header_image_7,
  a0_.lat AS lat_8,
  a0_.lng AS lng_9,
  a0_.zoom AS zoom_10,
  a0_.rock_responsibility AS rock_responsibility_11,
  a0_.railway_station AS railway_station_12,
  a0_.kletterkonzeption AS kletterkonzeption_13
FROM
  area a0_
WHERE
  a0_.online = 1
ORDER BY
  a0_.sequence ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.orientation AS orientation_3, a0_.sequence AS sequence_4, a0_.online AS online_5, a0_.image AS image_6, a0_.header_image AS header_image_7, a0_.lat AS lat_8, a0_.lng AS lng_9, a0_.zoom AS zoom_10, a0_.rock_responsibility AS rock_responsibility_11, a0_.railway_station AS railway_station_12, a0_.kletterkonzeption AS kletterkonzeption_13 FROM area a0_ WHERE a0_.online = 1 ORDER BY a0_.sequence ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\AreaRepository->getAreasFrontend (line 80)
7	App\Controller\FirstAscencionistSearchController->index (line 62)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	handle (line 20)

2.57 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.image AS image_3, r1_.id AS id_4, r1_.name AS name_5, r1_.slug AS slug_6 FROM area a0_ LEFT JOIN rock r1_ ON a0_.id = r1_.area_id WHERE a0_.online = 1 AND r1_.online = 1 ORDER BY a0_.sequence ASC, r1_.nr ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.image AS image_3,
  r1_.id AS id_4,
  r1_.name AS name_5,
  r1_.slug AS slug_6
FROM
  area a0_
  LEFT JOIN rock r1_ ON a0_.id = r1_.area_id
WHERE
  a0_.online = 1
  AND r1_.online = 1
ORDER BY
  a0_.sequence ASC,
  r1_.nr ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.image AS image_3, r1_.id AS id_4, r1_.name AS name_5, r1_.slug AS slug_6 FROM area a0_ LEFT JOIN rock r1_ ON a0_.id = r1_.area_id WHERE a0_.online = 1 AND r1_.online = 1 ORDER BY a0_.sequence ASC, r1_.nr ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\AreaRepository->sidebarNavigation (line 122)
7	App\Service\AreasService->getSidebarAreas (line 37)
8	App\Twig\AppExtension->getSidebarAreas (line 47)
9	__TwigTemplate_83fdd89ca41f3fecd132258aa5d023c9->doDisplay (line 64)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Extension\CoreExtension->include (line 1520)
15	__TwigTemplate_ff16025daa213e723dbd3f304cc6dcda::block_body (line 100)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_bde03842f2367859c6433d1f2cc144f6->doDisplay (line 110)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_ff16025daa213e723dbd3f304cc6dcda->doDisplay (line 54)
20	Twig\Template->yield (line 402)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 373)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
28	App\Controller\FirstAscencionistSearchController->index (line 64)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 182)
32	handle (line 20)

1.49 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM area a0_ LEFT JOIN rock r1_ ON a0_.id = r1_.area_id WHERE a0_.online = 1 GROUP BY a0_.id, a0_.name ORDER BY a0_.sequence ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2
FROM
  area a0_
  LEFT JOIN rock r1_ ON a0_.id = r1_.area_id
WHERE
  a0_.online = 1
GROUP BY
  a0_.id,
  a0_.name
ORDER BY
  a0_.sequence ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2 FROM area a0_ LEFT JOIN rock r1_ ON a0_.id = r1_.area_id WHERE a0_.online = 1 GROUP BY a0_.id, a0_.name ORDER BY a0_.sequence ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\AreaRepository->getAreasFooter (line 192)
7	App\Service\AreasService->getFooterAreas (line 29)
8	App\Twig\AppExtension->getAreas (line 37)
9	__TwigTemplate_bde03842f2367859c6433d1f2cc144f6->doDisplay (line 115)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_ff16025daa213e723dbd3f304cc6dcda->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\FirstAscencionistSearchController->index (line 64)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	handle (line 20)

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\Area	13

Entities Mapping

Class	Mapping errors
App\Entity\Area	No errors.
App\Entity\Rock	No errors.
App\Entity\Routes	No errors.

Symfony Profiler

GET https://munichclimbs.com/suche

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping