Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

2.80 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.42 ms
(14.99%)

SELECT MAX(l0_.round) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(l0_.round) AS sclr_0
FROM
  league_match_team l1_
  INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id
WHERE
  l0_.division_id = ?

SELECT MAX(l0_.round) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = 2;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\StandingsController->standings (line 57)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.36 ms
(12.97%)

SELECT l0_.team_id AS sclr_0, p1_.firstname AS firstname_1, p1_.lastname AS lastname_2, l2_.scores AS scores_3 FROM league_match_participant l2_ INNER JOIN league_match_team l0_ ON l2_.league_match_team_id = l0_.id INNER JOIN league_match l3_ ON l0_.league_match_id = l3_.id INNER JOIN player p1_ ON l2_.player_id = p1_.id WHERE l3_.division_id = ? AND l3_.round <= ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.team_id AS sclr_0,
  p1_.firstname AS firstname_1,
  p1_.lastname AS lastname_2,
  l2_.scores AS scores_3
FROM
  league_match_participant l2_
  INNER JOIN league_match_team l0_ ON l2_.league_match_team_id = l0_.id
  INNER JOIN league_match l3_ ON l0_.league_match_id = l3_.id
  INNER JOIN player p1_ ON l2_.player_id = p1_.id
WHERE
  l3_.division_id = ?
  AND l3_.round <= ?

SELECT l0_.team_id AS sclr_0, p1_.firstname AS firstname_1, p1_.lastname AS lastname_2, l2_.scores AS scores_3 FROM league_match_participant l2_ INNER JOIN league_match_team l0_ ON l2_.league_match_team_id = l0_.id INNER JOIN league_match l3_ ON l0_.league_match_id = l3_.id INNER JOIN player p1_ ON l2_.player_id = p1_.id WHERE l3_.division_id = 2 AND l3_.round <= 1;

#	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->getArrayResult (line 700)
6	App\Controller\StandingsController->standings (line 226)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.35 ms
(12.63%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.rounds AS rounds_3, t0.league_id AS league_id_4 FROM division 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.rounds AS rounds_3,
  t0.league_id AS league_id_4
FROM
  division t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.rounds AS rounds_3, t0.league_id AS league_id_4 FROM division 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\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

0.35 ms
(12.53%)

SELECT l0_.id AS id_0, l0_.datetime AS datetime_1, t1_.name AS name_2, l2_.points AS points_3, l2_.pinfall AS pinfall_4 FROM league_match_team l2_ INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id INNER JOIN team t1_ ON l2_.team_id = t1_.id WHERE l0_.division_id = ? AND l0_.round = ? ORDER BY l0_.datetime ASC, l0_.id ASC, l2_.ordering ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.datetime AS datetime_1,
  t1_.name AS name_2,
  l2_.points AS points_3,
  l2_.pinfall AS pinfall_4
FROM
  league_match_team l2_
  INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id
  INNER JOIN team t1_ ON l2_.team_id = t1_.id
WHERE
  l0_.division_id = ?
  AND l0_.round = ?
ORDER BY
  l0_.datetime ASC,
  l0_.id ASC,
  l2_.ordering ASC

SELECT l0_.id AS id_0, l0_.datetime AS datetime_1, t1_.name AS name_2, l2_.points AS points_3, l2_.pinfall AS pinfall_4 FROM league_match_team l2_ INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id INNER JOIN team t1_ ON l2_.team_id = t1_.id WHERE l0_.division_id = 2 AND l0_.round = 1 ORDER BY l0_.datetime ASC, l0_.id ASC, l2_.ordering ASC;

#	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->getArrayResult (line 700)
6	App\Controller\StandingsController->standings (line 174)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.35 ms
(12.39%)

SELECT l0_.team_id AS sclr_0, t1_.name AS name_1, l0_.league_match_id AS sclr_2, l0_.points AS points_3, l0_.pinfall AS pinfall_4 FROM league_match_team l0_ INNER JOIN team t1_ ON l0_.team_id = t1_.id INNER JOIN league_match l2_ ON l0_.league_match_id = l2_.id WHERE l2_.division_id = ? AND l2_.round <= ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.team_id AS sclr_0,
  t1_.name AS name_1,
  l0_.league_match_id AS sclr_2,
  l0_.points AS points_3,
  l0_.pinfall AS pinfall_4
FROM
  league_match_team l0_
  INNER JOIN team t1_ ON l0_.team_id = t1_.id
  INNER JOIN league_match l2_ ON l0_.league_match_id = l2_.id
WHERE
  l2_.division_id = ?
  AND l2_.round <= ?

SELECT l0_.team_id AS sclr_0, t1_.name AS name_1, l0_.league_match_id AS sclr_2, l0_.points AS points_3, l0_.pinfall AS pinfall_4 FROM league_match_team l0_ INNER JOIN team t1_ ON l0_.team_id = t1_.id INNER JOIN league_match l2_ ON l0_.league_match_id = l2_.id WHERE l2_.division_id = 2 AND l2_.round <= 1;

#	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->getArrayResult (line 700)
6	App\Controller\StandingsController->standings (line 101)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.34 ms
(12.29%)

SELECT MAX(l0_.round) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = ? AND l1_.points > 0

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  MAX(l0_.round) AS sclr_0
FROM
  league_match_team l1_
  INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id
WHERE
  l0_.division_id = ?
  AND l1_.points > 0

SELECT MAX(l0_.round) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = 2 AND l1_.points > 0;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\StandingsController->standings (line 65)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.33 ms
(11.88%)

SELECT l0_.id AS id_0, l0_.datetime AS datetime_1, t1_.name AS name_2 FROM league_match_team l2_ INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id INNER JOIN team t1_ ON l2_.team_id = t1_.id WHERE l0_.division_id = ? AND l0_.round = ? ORDER BY l0_.datetime ASC, l0_.id ASC, l2_.ordering ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.datetime AS datetime_1,
  t1_.name AS name_2
FROM
  league_match_team l2_
  INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id
  INNER JOIN team t1_ ON l2_.team_id = t1_.id
WHERE
  l0_.division_id = ?
  AND l0_.round = ?
ORDER BY
  l0_.datetime ASC,
  l0_.id ASC,
  l2_.ordering ASC

SELECT l0_.id AS id_0, l0_.datetime AS datetime_1, t1_.name AS name_2 FROM league_match_team l2_ INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id INNER JOIN team t1_ ON l2_.team_id = t1_.id WHERE l0_.division_id = 2 AND l0_.round = 2 ORDER BY l0_.datetime ASC, l0_.id ASC, l2_.ordering ASC;

#	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->getArrayResult (line 700)
6	App\Controller\StandingsController->standings (line 203)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.29 ms
(10.32%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.default_alley_id AS default_alley_id_3 FROM league t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.default_alley_id AS default_alley_id_3
FROM
  league t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.default_alley_id AS default_alley_id_3 FROM league t0 WHERE t0.id = 1;

#	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->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\League::__toString (line 95)
5	App\Entity\Division->__toString (line 119)
6	Twig\Runtime\EscaperRuntime->escape (line 126)
7	__TwigTemplate_ef9dc40d4af21946802338d8eb14f203->block_body (line 102)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_f15e5708116c7e094de331a8f54f560f->doDisplay (line 111)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_ef9dc40d4af21946802338d8eb14f203->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
20	App\Controller\StandingsController->standings (line 253)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

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\Division	1
App\Entity\League	1
App\Entity\Alley	1

Entities Mapping

Class	Mapping errors
App\Entity\Division	No errors.
App\Entity\League	No errors.
App\Entity\Player	No errors.
App\Entity\Team	No errors.
App\Entity\LeagueMatch	No errors.
App\Entity\LeagueMatchTeam	No errors.
App\Entity\LeagueMatchParticipant	No errors.
App\Entity\Alley	No errors.

Symfony Profiler

GET https://devel2.bowlres.se/division/2/standings?round=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping