Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.05 ms Query time

0 Invalid entities

69 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.77 ms
(37.30%)

SELECT l0_.id AS id_0, l0_.round AS round_1, l0_.datetime AS datetime_2, l1_.id AS id_3, l1_.points AS points_4, l1_.pinfall AS pinfall_5, l1_.ordering AS ordering_6, t2_.id AS id_7, t2_.name AS name_8, l0_.division_id AS division_id_9, l0_.alley_id AS alley_id_10, l1_.league_match_id AS league_match_id_11, l1_.team_id AS team_id_12, t2_.division_id AS division_id_13 FROM league_match l0_ LEFT JOIN league_match_team l1_ ON l0_.id = l1_.league_match_id LEFT JOIN team t2_ ON l1_.team_id = t2_.id WHERE l0_.division_id = ? ORDER BY l0_.division_id ASC, l0_.round ASC, l0_.id ASC

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.round AS round_1,
  l0_.datetime AS datetime_2,
  l1_.id AS id_3,
  l1_.points AS points_4,
  l1_.pinfall AS pinfall_5,
  l1_.ordering AS ordering_6,
  t2_.id AS id_7,
  t2_.name AS name_8,
  l0_.division_id AS division_id_9,
  l0_.alley_id AS alley_id_10,
  l1_.league_match_id AS league_match_id_11,
  l1_.team_id AS team_id_12,
  t2_.division_id AS division_id_13
FROM
  league_match l0_
  LEFT JOIN league_match_team l1_ ON l0_.id = l1_.league_match_id
  LEFT JOIN team t2_ ON l1_.team_id = t2_.id
WHERE
  l0_.division_id = ?
ORDER BY
  l0_.division_id ASC,
  l0_.round ASC,
  l0_.id ASC

SELECT l0_.id AS id_0, l0_.round AS round_1, l0_.datetime AS datetime_2, l1_.id AS id_3, l1_.points AS points_4, l1_.pinfall AS pinfall_5, l1_.ordering AS ordering_6, t2_.id AS id_7, t2_.name AS name_8, l0_.division_id AS division_id_9, l0_.alley_id AS alley_id_10, l1_.league_match_id AS league_match_id_11, l1_.team_id AS team_id_12, t2_.division_id AS division_id_13 FROM league_match l0_ LEFT JOIN league_match_team l1_ ON l0_.id = l1_.league_match_id LEFT JOIN team t2_ ON l1_.team_id = t2_.id WHERE l0_.division_id = 9 ORDER BY l0_.division_id ASC, l0_.round ASC, l0_.id 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->getResult (line 688)
6	App\Repository\LeagueMatchRepository->findWithFilters (line 101)
7	App\Controller\MatchesController->getMatches (line 67)
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.52 ms
(25.59%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.rounds AS rounds_3, t0.games AS games_4, t0.points_win_high_pinfall AS points_win_high_pinfall_5, t0.points_win_equal_pinfall AS points_win_equal_pinfall_6, t0.points_win_low_pinfall AS points_win_low_pinfall_7, t0.points_draw_high_pinfall AS points_draw_high_pinfall_8, t0.points_draw_equal_pinfall AS points_draw_equal_pinfall_9, t0.points_draw_low_pinfall AS points_draw_low_pinfall_10, t0.points_loss_high_pinfall AS points_loss_high_pinfall_11, t0.points_loss_equal_pinfall AS points_loss_equal_pinfall_12, t0.points_loss_low_pinfall AS points_loss_low_pinfall_13, t0.match_type AS match_type_14, t0.league_id AS league_id_15 FROM division t0 WHERE t0.id = ?

Parameters:

[
  9
]

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.games AS games_4,
  t0.points_win_high_pinfall AS points_win_high_pinfall_5,
  t0.points_win_equal_pinfall AS points_win_equal_pinfall_6,
  t0.points_win_low_pinfall AS points_win_low_pinfall_7,
  t0.points_draw_high_pinfall AS points_draw_high_pinfall_8,
  t0.points_draw_equal_pinfall AS points_draw_equal_pinfall_9,
  t0.points_draw_low_pinfall AS points_draw_low_pinfall_10,
  t0.points_loss_high_pinfall AS points_loss_high_pinfall_11,
  t0.points_loss_equal_pinfall AS points_loss_equal_pinfall_12,
  t0.points_loss_low_pinfall AS points_loss_low_pinfall_13,
  t0.match_type AS match_type_14,
  t0.league_id AS league_id_15
FROM
  division t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.rounds AS rounds_3, t0.games AS games_4, t0.points_win_high_pinfall AS points_win_high_pinfall_5, t0.points_win_equal_pinfall AS points_win_equal_pinfall_6, t0.points_win_low_pinfall AS points_win_low_pinfall_7, t0.points_draw_high_pinfall AS points_draw_high_pinfall_8, t0.points_draw_equal_pinfall AS points_draw_equal_pinfall_9, t0.points_draw_low_pinfall AS points_draw_low_pinfall_10, t0.points_loss_high_pinfall AS points_loss_high_pinfall_11, t0.points_loss_equal_pinfall AS points_loss_equal_pinfall_12, t0.points_loss_low_pinfall AS points_loss_low_pinfall_13, t0.match_type AS match_type_14, t0.league_id AS league_id_15 FROM division t0 WHERE t0.id = 9;

#	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	App\Controller\MatchesController->getMatches (line 30)
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.39 ms
(19.21%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5 FROM `user` t0 WHERE t0.id = 7;

#	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\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 191)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

0.37 ms
(17.90%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5 FROM `user` t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "viking"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5
FROM
  `user` t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5 FROM `user` t0 WHERE t0.username = 'viking' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 55)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 176)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 191)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	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\LeagueMatchTeam	40
App\Entity\LeagueMatch	20
App\Entity\Team	5
App\Entity\User	1
App\Entity\Division	1
App\Entity\League	1
App\Entity\Alley	1

Entities Mapping

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

Symfony Profiler

GET https://devel2.bowlres.se/matches?division_id=9

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping