Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

257.21 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.26 ms

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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13 FROM area t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "robots.txt"
]

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.rock_responsibility AS rock_responsibility_12,
  t0.railway_station AS railway_station_13
FROM
  area t0
WHERE
  t0.slug = ?
LIMIT
  1

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.rock_responsibility AS rock_responsibility_12, t0.railway_station AS railway_station_13 FROM area t0 WHERE t0.slug = 'robots.txt' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 20)

3.18 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\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 122)
7	App\Repository\AreaRepository->sidebarNavigation (line 15)
8	App\Controller\ErrorController->showError (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
11	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
16	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 20)

251.77 ms

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.image AS image_3, a0_.lat AS lat_4, a0_.lng AS lng_5, COUNT(DISTINCT r1_.id) AS sclr_6, COUNT(DISTINCT r2_.id) AS sclr_7, COUNT(DISTINCT CASE WHEN r1_.grade_no > 0 AND r1_.grade_no <= 15 THEN r1_.id ELSE 0 END) AS sclr_8, COUNT(DISTINCT CASE WHEN r1_.grade_no > 15 AND r1_.grade_no <= 29 THEN r1_.id ELSE 0 END) AS sclr_9, COUNT(DISTINCT CASE WHEN r1_.grade_no > 29 AND r1_.grade_no <= 60 THEN r1_.id ELSE 0 END) AS sclr_10, COUNT(DISTINCT CASE WHEN r1_.grade_no = 0 OR r1_.grade_no IS NULL THEN r1_.id ELSE 0 END) AS sclr_11 FROM area a0_ LEFT JOIN routes r1_ ON a0_.id = r1_.area_id LEFT JOIN rock r2_ ON a0_.id = r2_.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,
  a0_.image AS image_3,
  a0_.lat AS lat_4,
  a0_.lng AS lng_5,
  COUNT(DISTINCT r1_.id) AS sclr_6,
  COUNT(DISTINCT r2_.id) AS sclr_7,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 0
    AND r1_.grade_no <= 15 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_8,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 15
    AND r1_.grade_no <= 29 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_9,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no > 29
    AND r1_.grade_no <= 60 THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_10,
  COUNT(
    DISTINCT CASE WHEN r1_.grade_no = 0
    OR r1_.grade_no IS NULL THEN
      r1_.id
    ELSE
      0
    END
  ) AS sclr_11
FROM
  area a0_
  LEFT JOIN routes r1_ ON a0_.id = r1_.area_id
  LEFT JOIN rock r2_ ON a0_.id = r2_.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, a0_.image AS image_3, a0_.lat AS lat_4, a0_.lng AS lng_5, COUNT(DISTINCT r1_.id) AS sclr_6, COUNT(DISTINCT r2_.id) AS sclr_7, COUNT(DISTINCT CASE WHEN r1_.grade_no > 0 AND r1_.grade_no <= 15 THEN r1_.id ELSE 0 END) AS sclr_8, COUNT(DISTINCT CASE WHEN r1_.grade_no > 15 AND r1_.grade_no <= 29 THEN r1_.id ELSE 0 END) AS sclr_9, COUNT(DISTINCT CASE WHEN r1_.grade_no > 29 AND r1_.grade_no <= 60 THEN r1_.id ELSE 0 END) AS sclr_10, COUNT(DISTINCT CASE WHEN r1_.grade_no = 0 OR r1_.grade_no IS NULL THEN r1_.id ELSE 0 END) AS sclr_11 FROM area a0_ LEFT JOIN routes r1_ ON a0_.id = r1_.area_id LEFT JOIN rock r2_ ON a0_.id = r2_.area_id WHERE a0_.online = 1 GROUP BY a0_.id, a0_.name ORDER BY a0_.sequence ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 106)
7	App\Repository\AreaRepository->getAreasInformation (line 16)
8	App\Controller\ErrorController->showError (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 97)
11	Symfony\Component\HttpKernel\EventListener\ErrorListener->onKernelException (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 241)
16	Symfony\Component\HttpKernel\HttpKernel->handleThrowable (line 91)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->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.

Entities Mapping

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

Symfony Profiler

GET https://munichclimbs.com/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping