Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

386.35 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

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

382.31 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/_profiler/0a53ef/search/

Configuration Settings

Theme