Symfony Profiler

Query Metrics

16 Database Queries

6 Different statements

3.88 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.25 ms
(32.09%)

SELECT t0.username AS username_1, t0.roles AS roles_2, t0.password AS password_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM player t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.username AS username_1,
  t0.roles AS roles_2,
  t0.password AS password_3,
  t0.id AS id_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  player t0
WHERE
  t0.id = ?

SELECT t0.username AS username_1, t0.roles AS roles_2, t0.password AS password_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM player t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Player::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\Player->__get (line 66)
8	App\Entity\Player->getUsername (line 71)
9	App\Controller\Public\DefaultController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.88 ms
(22.71%)

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

Parameters:

[
  "2025-01-01"
  "2026-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 >= '2025-01-01' AND g0_.played_at < '2026-01-01';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 158)
8	App\Repository\GameRepository->countGamesPlayedByYear (line 99)
9	App\Repository\StatsPlayerRepository->minGamesToBeInChampionship (line 37)
10	App\Controller\Public\DefaultController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.79 ms
(20.26%)

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:

[
  2025
]

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 = 2025 AND s0_.championship_ranking > 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 1)
8	count (line 43)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerXB1y9aI\PaginatorProxyBa079e5->paginate (line 43)
16	App\Controller\Public\DefaultController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.40 ms
(10.32%)

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 AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.championship_ranking ASC

Parameters:

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
  AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  s0_.championship_ranking ASC

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 = 2025 AND s0_.championship_ranking > 0 AND s0_.id IN (1629, 1630, 1634, 1645, 1631, 1635, 1637, 1640, 1636, 1638, 1639) ORDER BY s0_.championship_ranking ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 145)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerXB1y9aI\PaginatorProxyBa079e5->paginate (line 43)
16	App\Controller\Public\DefaultController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.30 ms
(7.70%)

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:

[
  2025
]

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 = 2025 AND s0_.championship_ranking > 0 ORDER BY s0_.championship_ranking ASC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 136)
7	App\Repository\StatsPlayerRepository->findTopPlayers (line 50)
8	App\Controller\Public\DefaultController->index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.27 ms
(6.92%)

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:

[
  2025
]

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 = 2025 AND s0_.championship_ranking > 0 ORDER BY s0_.championship_ranking ASC LIMIT 50;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 1)
8	iterator_to_array (line 45)
9	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber->items (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
14	Knp\Component\Pager\Paginator->paginate (line 25)
15	ContainerXB1y9aI\PaginatorProxyBa079e5->paginate (line 43)
16	App\Controller\Public\DefaultController->index (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	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.

Entities Mapping

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

Symfony Profiler

GET https://dev-stats-foot.mollenthiel.fr/?direction=asc&page=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping