Symfony Profiler

Query Metrics

14 Database Queries

3 Different statements

22.86 ms Query time

0 Invalid entities

25 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

12.93 ms
(56.56%)

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.grade AS grade_2, r0_.climbed AS climbed_3, r0_.first_ascent AS first_ascent_4, r0_.year_first_ascent AS year_first_ascent_5, r0_.protection AS protection_6, r0_.scale AS scale_7, r0_.grade_no AS grade_no_8, r0_.rating AS rating_9, r0_.topo_id AS topo_id_10, r0_.nr AS nr_11, r0_.rock_quality AS rock_quality_12, r0_.climbing_style AS climbing_style_13, r0_.area_id AS area_id_14, r0_.rock_id AS rock_id_15 FROM routes r0_ INNER JOIN rock r1_ ON r0_.rock_id = r1_.id WHERE r0_.year_first_ascent >= ? ORDER BY r0_.year_first_ascent DESC

Parameters:

[
  2024
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.grade AS grade_2,
  r0_.climbed AS climbed_3,
  r0_.first_ascent AS first_ascent_4,
  r0_.year_first_ascent AS year_first_ascent_5,
  r0_.protection AS protection_6,
  r0_.scale AS scale_7,
  r0_.grade_no AS grade_no_8,
  r0_.rating AS rating_9,
  r0_.topo_id AS topo_id_10,
  r0_.nr AS nr_11,
  r0_.rock_quality AS rock_quality_12,
  r0_.climbing_style AS climbing_style_13,
  r0_.area_id AS area_id_14,
  r0_.rock_id AS rock_id_15
FROM
  routes r0_
  INNER JOIN rock r1_ ON r0_.rock_id = r1_.id
WHERE
  r0_.year_first_ascent >= ?
ORDER BY
  r0_.year_first_ascent DESC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.grade AS grade_2, r0_.climbed AS climbed_3, r0_.first_ascent AS first_ascent_4, r0_.year_first_ascent AS year_first_ascent_5, r0_.protection AS protection_6, r0_.scale AS scale_7, r0_.grade_no AS grade_no_8, r0_.rating AS rating_9, r0_.topo_id AS topo_id_10, r0_.nr AS nr_11, r0_.rock_quality AS rock_quality_12, r0_.climbing_style AS climbing_style_13, r0_.area_id AS area_id_14, r0_.rock_id AS rock_id_15 FROM routes r0_ INNER JOIN rock r1_ ON r0_.rock_id = r1_.id WHERE r0_.year_first_ascent >= 2024 ORDER BY r0_.year_first_ascent DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\RoutesRepository->latestRoutesPage (line 118)
7	App\Controller\FrontendController->neuesteRouten (line 43)
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	handle (line 20)

7.40 ms
(32.39%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.zone AS zone_5, t0.banned AS banned_6, t0.height AS height_7, t0.orientation AS orientation_8, t0.season AS season_9, t0.child_friendly AS child_friendly_10, t0.sunny AS sunny_11, t0.rain AS rain_12, t0.image AS image_13, t0.lat AS lat_14, t0.lng AS lng_15, t0.online AS online_16, t0.path_coordinates AS path_coordinates_17, t0.zoom AS zoom_18, t0.preview_image AS preview_image_19, t0.train AS train_20, t0.bike AS bike_21, t0.area_id AS area_id_22 FROM rock t0 WHERE t0.id = ?

Parameters:

[
  714
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.nr AS nr_4,
  t0.zone AS zone_5,
  t0.banned AS banned_6,
  t0.height AS height_7,
  t0.orientation AS orientation_8,
  t0.season AS season_9,
  t0.child_friendly AS child_friendly_10,
  t0.sunny AS sunny_11,
  t0.rain AS rain_12,
  t0.image AS image_13,
  t0.lat AS lat_14,
  t0.lng AS lng_15,
  t0.online AS online_16,
  t0.path_coordinates AS path_coordinates_17,
  t0.zoom AS zoom_18,
  t0.preview_image AS preview_image_19,
  t0.train AS train_20,
  t0.bike AS bike_21,
  t0.area_id AS area_id_22
FROM
  rock t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.nr AS nr_4, t0.zone AS zone_5, t0.banned AS banned_6, t0.height AS height_7, t0.orientation AS orientation_8, t0.season AS season_9, t0.child_friendly AS child_friendly_10, t0.sunny AS sunny_11, t0.rain AS rain_12, t0.image AS image_13, t0.lat AS lat_14, t0.lng AS lng_15, t0.online AS online_16, t0.path_coordinates AS path_coordinates_17, t0.zoom AS zoom_18, t0.preview_image AS preview_image_19, t0.train AS train_20, t0.bike AS bike_21, t0.area_id AS area_id_22 FROM rock t0 WHERE t0.id = 714;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Rock::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Rock->__get (line 153)
7	App\Entity\Rock->getSlug (line 167)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_32aa1668d05a635f1f3499eae07c32e6::doDisplay (line 87)
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 1526)
15	__TwigTemplate_5855226942c86e52e6d1082a9e84f99a::block_body (line 112)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_590cc926e7ab1520d9b727dd1d9418f4->doDisplay (line 137)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_5855226942c86e52e6d1082a9e84f99a->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 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\FrontendController->neuesteRouten (line 45)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	handle (line 20)

2.53 ms
(11.05%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.orientation AS orientation_4, t0.sequence AS sequence_5, t0.online AS online_6, t0.image AS image_7, t0.header_image AS header_image_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.zoom AS zoom_11, t0.travel_time_minutes AS travel_time_minutes_12, t0.rock_responsibility AS rock_responsibility_13, t0.railway_station AS railway_station_14, t0.kletterkonzeption AS kletterkonzeption_15 FROM area t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.orientation AS orientation_4,
  t0.sequence AS sequence_5,
  t0.online AS online_6,
  t0.image AS image_7,
  t0.header_image AS header_image_8,
  t0.lat AS lat_9,
  t0.lng AS lng_10,
  t0.zoom AS zoom_11,
  t0.travel_time_minutes AS travel_time_minutes_12,
  t0.rock_responsibility AS rock_responsibility_13,
  t0.railway_station AS railway_station_14,
  t0.kletterkonzeption AS kletterkonzeption_15
FROM
  area t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.orientation AS orientation_4, t0.sequence AS sequence_5, t0.online AS online_6, t0.image AS image_7, t0.header_image AS header_image_8, t0.lat AS lat_9, t0.lng AS lng_10, t0.zoom AS zoom_11, t0.travel_time_minutes AS travel_time_minutes_12, t0.rock_responsibility AS rock_responsibility_13, t0.railway_station AS railway_station_14, t0.kletterkonzeption AS kletterkonzeption_15 FROM area t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Area::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Area->__get (line 153)
7	App\Entity\Area->getName (line 110)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_32aa1668d05a635f1f3499eae07c32e6::doDisplay (line 87)
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 1526)
15	__TwigTemplate_5855226942c86e52e6d1082a9e84f99a::block_body (line 112)
16	Twig\Template->yieldBlock (line 446)
17	__TwigTemplate_590cc926e7ab1520d9b727dd1d9418f4->doDisplay (line 137)
18	Twig\Template->yield (line 402)
19	__TwigTemplate_5855226942c86e52e6d1082a9e84f99a->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 467)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
28	App\Controller\FrontendController->neuesteRouten (line 45)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
31	Symfony\Component\HttpKernel\Kernel->handle (line 193)
32	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\Routes	12
App\Entity\Rock	10
App\Entity\Area	3

Entities Mapping

Class	Mapping errors
App\Entity\Routes	No errors.
App\Entity\Rock	No errors.
App\Entity\Area	No errors.
App\Entity\Comment	No errors.
App\Entity\RockTranslation	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://www.munichclimbs.com/neuesteRouten

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping