Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

0.45 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.26 ms
(58.23%)

SELECT t0.id AS id_1, t0.bets_number AS bets_number_2, t0.bets_won AS bets_won_3, t0.bets_lost AS bets_lost_4, t0.points AS points_5, t0.ranking AS ranking_6, t0.competition_points AS competition_points_7, t0.competition_ranking AS competition_ranking_8, t0.competition_bets_number AS competition_bets_number_9, t0.competition_bets_won AS competition_bets_won_10, t0.competition_bets_lost AS competition_bets_lost_11, t0.competition_id AS competition_id_12, t0.round_id AS round_id_13, t0.user_id AS user_id_14 FROM user_competition_round t0 WHERE t0.competition_id = ? AND t0.user_id IS NULL ORDER BY t0.id ASC

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.bets_number AS bets_number_2,
  t0.bets_won AS bets_won_3,
  t0.bets_lost AS bets_lost_4,
  t0.points AS points_5,
  t0.ranking AS ranking_6,
  t0.competition_points AS competition_points_7,
  t0.competition_ranking AS competition_ranking_8,
  t0.competition_bets_number AS competition_bets_number_9,
  t0.competition_bets_won AS competition_bets_won_10,
  t0.competition_bets_lost AS competition_bets_lost_11,
  t0.competition_id AS competition_id_12,
  t0.round_id AS round_id_13,
  t0.user_id AS user_id_14
FROM
  user_competition_round t0
WHERE
  t0.competition_id = ?
  AND t0.user_id IS NULL
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.bets_number AS bets_number_2, t0.bets_won AS bets_won_3, t0.bets_lost AS bets_lost_4, t0.points AS points_5, t0.ranking AS ranking_6, t0.competition_points AS competition_points_7, t0.competition_ranking AS competition_ranking_8, t0.competition_bets_number AS competition_bets_number_9, t0.competition_bets_won AS competition_bets_won_10, t0.competition_bets_lost AS competition_bets_lost_11, t0.competition_id AS competition_id_12, t0.round_id AS round_id_13, t0.user_id AS user_id_14 FROM user_competition_round t0 WHERE t0.competition_id = 5 AND t0.user_id IS NULL ORDER BY t0.id ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Controller\UserStatisticsController->get (line 56)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.19 ms
(41.77%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.icon AS icon_5, t0.code AS code_6, t0.league AS league_7, t0.season AS season_8, t0.sport_id AS sport_id_9 FROM competition t0 WHERE t0.id = ?

Parameters:

[
  "5"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.status AS status_4,
  t0.icon AS icon_5,
  t0.code AS code_6,
  t0.league AS league_7,
  t0.season AS season_8,
  t0.sport_id AS sport_id_9
FROM
  competition t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.icon AS icon_5, t0.code AS code_6, t0.league AS league_7, t0.season AS season_8, t0.sport_id AS sport_id_9 FROM competition t0 WHERE t0.id = '5';

#	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\ServiceEntityRepositoryProxy->find (line 61)
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 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	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\Competition	1
App\Entity\Sport	1

Entities Mapping

Class	Mapping errors
App\Entity\Competition	No errors.
App\Entity\Sport	No errors.
App\Entity\Round	No errors.
App\Entity\Competitor	No errors.
App\Entity\Game	No errors.
App\Entity\UserCompetition	No errors.
App\Entity\League	No errors.
App\Entity\UserCompetitionRound	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET http://betforfun.be/competition/5/statistics

Configuration Settings

Theme

Page Width