Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.12 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.63 ms

SELECT COUNT(g0_.id) AS sclr_0 FROM game g0_ WHERE g0_.played_at >= ? AND g0_.played_at < ?

Parameters:

[
  "2026-01-01"
  "2027-01-01"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(g0_.id) AS sclr_0
FROM
  game g0_
WHERE
  g0_.played_at >= ?
  AND g0_.played_at < ?

SELECT COUNT(g0_.id) AS sclr_0 FROM game g0_ WHERE g0_.played_at >= '2026-01-01' AND g0_.played_at < '2027-01-01';

#	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\Repository\GameRepository->countGamesPlayedByYear (line 158)
8	App\Repository\StatsPlayerRepository->minGamesToBeInChampionship (line 99)
9	App\Controller\Public\DefaultController->index (line 37)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 182)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

0.83 ms

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM stats_player s0_ INNER JOIN player p1_ ON s0_.player_id = p1_.id WHERE s0_.year = ? AND s0_.championship_ranking > 0

Parameters:

[
  2026
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT s0_.id) AS sclr_0
FROM
  stats_player s0_
  INNER JOIN player p1_ ON s0_.player_id = p1_.id
WHERE
  s0_.year = ?
  AND s0_.championship_ranking > 0

SELECT count(DISTINCT s0_.id) AS sclr_0 FROM stats_player s0_ INNER JOIN player p1_ ON s0_.player_id = p1_.id WHERE s0_.year = 2026 AND s0_.championship_ranking > 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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerUknx6pw\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\Public\DefaultController->index (line 43)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.36 ms

SELECT DISTINCT s0_.id AS id_0, s0_.championship_ranking AS championship_ranking_1 FROM stats_player s0_ INNER JOIN player p1_ ON s0_.player_id = p1_.id WHERE s0_.year = ? AND s0_.championship_ranking > 0 ORDER BY s0_.championship_ranking ASC LIMIT 50

Parameters:

[
  2026
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.championship_ranking AS championship_ranking_1
FROM
  stats_player s0_
  INNER JOIN player p1_ ON s0_.player_id = p1_.id
WHERE
  s0_.year = ?
  AND s0_.championship_ranking > 0
ORDER BY
  s0_.championship_ranking ASC
LIMIT
  50

SELECT DISTINCT s0_.id AS id_0, s0_.championship_ranking AS championship_ranking_1 FROM stats_player s0_ INNER JOIN player p1_ ON s0_.player_id = p1_.id WHERE s0_.year = 2026 AND s0_.championship_ranking > 0 ORDER BY s0_.championship_ranking ASC LIMIT 50;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 122)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerUknx6pw\PaginatorProxyBa079e5->paginate (line 25)
15	App\Controller\Public\DefaultController->index (line 43)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.31 ms

SELECT s0_.year AS year_0, s0_.nb_games AS nb_games_1, s0_.nb_victories AS nb_victories_2, s0_.nb_defeats AS nb_defeats_3, s0_.goal_average AS goal_average_4, s0_.ranking AS ranking_5, s0_.championship_ranking AS championship_ranking_6, s0_.points AS points_7, s0_.victory_rate AS victory_rate_8, s0_.id AS id_9, s0_.player_id AS player_id_10 FROM stats_player s0_ INNER JOIN player p1_ ON s0_.player_id = p1_.id WHERE s0_.year = ? AND s0_.championship_ranking > 0 ORDER BY s0_.championship_ranking ASC LIMIT 3

Parameters:

[
  2026
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.year AS year_0,
  s0_.nb_games AS nb_games_1,
  s0_.nb_victories AS nb_victories_2,
  s0_.nb_defeats AS nb_defeats_3,
  s0_.goal_average AS goal_average_4,
  s0_.ranking AS ranking_5,
  s0_.championship_ranking AS championship_ranking_6,
  s0_.points AS points_7,
  s0_.victory_rate AS victory_rate_8,
  s0_.id AS id_9,
  s0_.player_id AS player_id_10
FROM
  stats_player s0_
  INNER JOIN player p1_ ON s0_.player_id = p1_.id
WHERE
  s0_.year = ?
  AND s0_.championship_ranking > 0
ORDER BY
  s0_.championship_ranking ASC
LIMIT
  3

SELECT s0_.year AS year_0, s0_.nb_games AS nb_games_1, s0_.nb_victories AS nb_victories_2, s0_.nb_defeats AS nb_defeats_3, s0_.goal_average AS goal_average_4, s0_.ranking AS ranking_5, s0_.championship_ranking AS championship_ranking_6, s0_.points AS points_7, s0_.victory_rate AS victory_rate_8, s0_.id AS id_9, s0_.player_id AS player_id_10 FROM stats_player s0_ INNER JOIN player p1_ ON s0_.player_id = p1_.id WHERE s0_.year = 2026 AND s0_.championship_ranking > 0 ORDER BY s0_.championship_ranking ASC LIMIT 3;

#	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\StatsPlayerRepository->findTopPlayers (line 136)
7	App\Controller\Public\DefaultController->index (line 50)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
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

Entities Mapping

Class	Mapping errors
App\Entity\StatsPlayer	No errors.
App\Entity\Game	No errors.
App\Entity\Player	No errors.

Symfony Profiler

GET https://dev-stats-foot.mollenthiel.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping