Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

31.43 ms Query time

0 Invalid entities

11 Managed entities

Queries

Group similar statements

#▲

Time

Info

28.01 ms

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.grade AS grade_2, r1_.name AS name_3, r1_.slug AS slug_4, a2_.slug AS slug_5 FROM routes r0_ INNER JOIN rock r1_ ON r0_.rock_id = r1_.id INNER JOIN area a2_ ON r0_.area_id = a2_.id WHERE r1_.slug IS NOT NULL AND a2_.slug IS NOT NULL AND r1_.online = 1 AND a2_.online = 1 ORDER BY r0_.year_first_ascent DESC LIMIT 5

Parameters:

[]

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,
  r1_.name AS name_3,
  r1_.slug AS slug_4,
  a2_.slug AS slug_5
FROM
  routes r0_
  INNER JOIN rock r1_ ON r0_.rock_id = r1_.id
  INNER JOIN area a2_ ON r0_.area_id = a2_.id
WHERE
  r1_.slug IS NOT NULL
  AND a2_.slug IS NOT NULL
  AND r1_.online = 1
  AND a2_.online = 1
ORDER BY
  r0_.year_first_ascent DESC
LIMIT
  5

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.grade AS grade_2, r1_.name AS name_3, r1_.slug AS slug_4, a2_.slug AS slug_5 FROM routes r0_ INNER JOIN rock r1_ ON r0_.rock_id = r1_.id INNER JOIN area a2_ ON r0_.area_id = a2_.id WHERE r1_.slug IS NOT NULL AND a2_.slug IS NOT NULL AND r1_.online = 1 AND a2_.online = 1 ORDER BY r0_.year_first_ascent DESC LIMIT 5;

#	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->latestRoutes (line 107)
7	App\Service\FrontendCacheService->App\Service\{closure} (line 48)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
9	Symfony\Component\Cache\LockRegistry->compute (line 113)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
15	App\Service\FrontendCacheService->getLatestRoutes (line 45)
16	App\Controller\FrontendController->index (line 82)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	handle (line 20)

3.42 ms

SELECT c0_.id AS id_0, c0_.comment AS comment_1, c0_.datetime AS datetime_2, u1_.firstname AS firstname_3, r2_.name AS name_4, r3_.slug AS slug_5, r3_.name AS name_6, a4_.slug AS slug_7, c0_.comment AS comment_8, c0_.datetime AS datetime_9, c0_.user_id AS user_id_10, c0_.route_id AS route_id_11 FROM comment c0_ INNER JOIN `user` u1_ ON c0_.user_id = u1_.id INNER JOIN routes r2_ ON c0_.route_id = r2_.id INNER JOIN rock r3_ ON r2_.rock_id = r3_.id INNER JOIN area a4_ ON r2_.area_id = a4_.id WHERE c0_.datetime IS NOT NULL ORDER BY c0_.datetime DESC LIMIT 5

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.comment AS comment_1,
  c0_.datetime AS datetime_2,
  u1_.firstname AS firstname_3,
  r2_.name AS name_4,
  r3_.slug AS slug_5,
  r3_.name AS name_6,
  a4_.slug AS slug_7,
  c0_.comment AS comment_8,
  c0_.datetime AS datetime_9,
  c0_.user_id AS user_id_10,
  c0_.route_id AS route_id_11
FROM
  comment c0_
  INNER JOIN `user` u1_ ON c0_.user_id = u1_.id
  INNER JOIN routes r2_ ON c0_.route_id = r2_.id
  INNER JOIN rock r3_ ON r2_.rock_id = r3_.id
  INNER JOIN area a4_ ON r2_.area_id = a4_.id
WHERE
  c0_.datetime IS NOT NULL
ORDER BY
  c0_.datetime DESC
LIMIT
  5

SELECT c0_.id AS id_0, c0_.comment AS comment_1, c0_.datetime AS datetime_2, u1_.firstname AS firstname_3, r2_.name AS name_4, r3_.slug AS slug_5, r3_.name AS name_6, a4_.slug AS slug_7, c0_.comment AS comment_8, c0_.datetime AS datetime_9, c0_.user_id AS user_id_10, c0_.route_id AS route_id_11 FROM comment c0_ INNER JOIN `user` u1_ ON c0_.user_id = u1_.id INNER JOIN routes r2_ ON c0_.route_id = r2_.id INNER JOIN rock r3_ ON r2_.rock_id = r3_.id INNER JOIN area a4_ ON r2_.area_id = a4_.id WHERE c0_.datetime IS NOT NULL ORDER BY c0_.datetime DESC LIMIT 5;

#	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\CommentRepository->latestComments (line 47)
7	App\Service\FrontendCacheService->App\Service\{closure} (line 60)
8	Symfony\Component\Cache\Adapter\TraceableAdapter->Symfony\Component\Cache\Adapter\{closure} (line 57)
9	Symfony\Component\Cache\LockRegistry->compute (line 113)
10	Symfony\Component\Cache\Adapter\AbstractAdapter::Symfony\Component\Cache\Traits\{closure} (line 102)
11	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
12	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
13	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
14	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
15	App\Service\FrontendCacheService->getLatestComments (line 57)
16	App\Controller\FrontendController->index (line 83)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	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\Comment	5
App\Entity\Routes	5
App\Entity\User	1

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\User	No errors.

Symfony Profiler

GET https://munichclimbs.com/

Configuration Settings

Theme

Page Width