Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.12 ms Query time

0 Invalid entities

13 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.36 ms

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)

0.77 ms

SELECT l0_.id AS id_0, l0_.round AS round_1, l0_.datetime AS datetime_2, l0_.info AS info_3, l0_.starting_lane AS starting_lane_4, l0_.ordinal AS ordinal_5, l1_.id AS id_6, l1_.points AS points_7, l1_.pinfall AS pinfall_8, l1_.ordering AS ordering_9, t2_.id AS id_10, t2_.name AS name_11, p3_.id AS id_12, p3_.firstname AS firstname_13, p3_.lastname AS lastname_14, p3_.email AS email_15, p3_.phone AS phone_16, l0_.division_id AS division_id_17, l0_.alley_id AS alley_id_18, l1_.league_match_id AS league_match_id_19, l1_.team_id AS team_id_20, t2_.division_id AS division_id_21 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 LEFT JOIN team_player t4_ ON t2_.id = t4_.team_id LEFT JOIN player p3_ ON p3_.id = t4_.player_id WHERE l0_.id IN (?) ORDER BY l0_.id ASC, l1_.ordering ASC, p3_.id ASC, p3_.firstname ASC, p3_.lastname ASC

Parameters:

[
  231
]

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,
  l0_.info AS info_3,
  l0_.starting_lane AS starting_lane_4,
  l0_.ordinal AS ordinal_5,
  l1_.id AS id_6,
  l1_.points AS points_7,
  l1_.pinfall AS pinfall_8,
  l1_.ordering AS ordering_9,
  t2_.id AS id_10,
  t2_.name AS name_11,
  p3_.id AS id_12,
  p3_.firstname AS firstname_13,
  p3_.lastname AS lastname_14,
  p3_.email AS email_15,
  p3_.phone AS phone_16,
  l0_.division_id AS division_id_17,
  l0_.alley_id AS alley_id_18,
  l1_.league_match_id AS league_match_id_19,
  l1_.team_id AS team_id_20,
  t2_.division_id AS division_id_21
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
  LEFT JOIN team_player t4_ ON t2_.id = t4_.team_id
  LEFT JOIN player p3_ ON p3_.id = t4_.player_id
WHERE
  l0_.id IN (?)
ORDER BY
  l0_.id ASC,
  l1_.ordering ASC,
  p3_.id ASC,
  p3_.firstname ASC,
  p3_.lastname ASC

SELECT l0_.id AS id_0, l0_.round AS round_1, l0_.datetime AS datetime_2, l0_.info AS info_3, l0_.starting_lane AS starting_lane_4, l0_.ordinal AS ordinal_5, l1_.id AS id_6, l1_.points AS points_7, l1_.pinfall AS pinfall_8, l1_.ordering AS ordering_9, t2_.id AS id_10, t2_.name AS name_11, p3_.id AS id_12, p3_.firstname AS firstname_13, p3_.lastname AS lastname_14, p3_.email AS email_15, p3_.phone AS phone_16, l0_.division_id AS division_id_17, l0_.alley_id AS alley_id_18, l1_.league_match_id AS league_match_id_19, l1_.team_id AS team_id_20, t2_.division_id AS division_id_21 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 LEFT JOIN team_player t4_ ON t2_.id = t4_.team_id LEFT JOIN player p3_ ON p3_.id = t4_.player_id WHERE l0_.id IN (231) ORDER BY l0_.id ASC, l1_.ordering ASC, p3_.id ASC, p3_.firstname ASC, p3_.lastname 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->findByIdsWithAvailablePlayers (line 45)
7	App\Controller\MatchesController->getParticipants (line 111)
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)

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\Player	5
App\Entity\LeagueMatchTeam	2
App\Entity\Team	2
App\Entity\User	1
App\Entity\LeagueMatch	1
App\Entity\Division	1
App\Entity\Alley	1

Entities Mapping

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

Symfony Profiler

GET https://api1.bowlres.se/matches/participants?match_ids%5B0%5D=231

Configuration Settings

Theme

Page Width