Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

370.53 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.62 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)

2.46 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)

366.45 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.

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