Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.43 ms Query time

0 Invalid entities

28 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.70 ms

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.created_at AS created_at_2, o0_.is_active AS is_active_3 FROM olympix o0_ WHERE o0_.is_active = ? ORDER BY o0_.created_at DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.name AS name_1,
  o0_.created_at AS created_at_2,
  o0_.is_active AS is_active_3
FROM
  olympix o0_
WHERE
  o0_.is_active = ?
ORDER BY
  o0_.created_at DESC

SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.created_at AS created_at_2, o0_.is_active AS is_active_3 FROM olympix o0_ WHERE o0_.is_active = 1 ORDER BY o0_.created_at DESC;

#	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 44)
7	App\Repository\OlympixRepository->findActiveOlympix (line 27)
8	App\Controller\MainController->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.42 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.total_points AS total_points_3, t0.joker_double_used AS joker_double_used_4, t0.joker_swap_used AS joker_swap_used_5, t0.olympix_id AS olympix_id_6 FROM player t0 WHERE t0.olympix_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.total_points AS total_points_3,
  t0.joker_double_used AS joker_double_used_4,
  t0.joker_swap_used AS joker_swap_used_5,
  t0.olympix_id AS olympix_id_6
FROM
  player t0
WHERE
  t0.olympix_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.total_points AS total_points_3, t0.joker_double_used AS joker_double_used_4, t0.joker_swap_used AS joker_swap_used_5, t0.olympix_id AS olympix_id_6 FROM player t0 WHERE t0.olympix_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1272)
9	Twig\Extension\CoreExtension::length (line 172)
10	__TwigTemplate_27c22113b23c4268bc901f088a12a731->block_body (line 446)
11	Twig\Template->yieldBlock (line 416)
12	__TwigTemplate_6f131861d482b4a632abb63bece87fe8->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_27c22113b23c4268bc901f088a12a731->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
23	App\Controller\MainController->index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.31 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.game_type AS game_type_3, t0.team_size AS team_size_4, t0.points_distribution AS points_distribution_5, t0.status AS status_6, t0.order_position AS order_position_7, t0.olympix_id AS olympix_id_8, t9.id AS id_10, t9.bracket_data AS bracket_data_11, t9.current_round AS current_round_12, t9.is_completed AS is_completed_13, t9.game_id AS game_id_14 FROM game t0 LEFT JOIN tournament t9 ON t9.game_id = t0.id WHERE t0.olympix_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.game_type AS game_type_3,
  t0.team_size AS team_size_4,
  t0.points_distribution AS points_distribution_5,
  t0.status AS status_6,
  t0.order_position AS order_position_7,
  t0.olympix_id AS olympix_id_8,
  t9.id AS id_10,
  t9.bracket_data AS bracket_data_11,
  t9.current_round AS current_round_12,
  t9.is_completed AS is_completed_13,
  t9.game_id AS game_id_14
FROM
  game t0
  LEFT JOIN tournament t9 ON t9.game_id = t0.id
WHERE
  t0.olympix_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.game_type AS game_type_3, t0.team_size AS team_size_4, t0.points_distribution AS points_distribution_5, t0.status AS status_6, t0.order_position AS order_position_7, t0.olympix_id AS olympix_id_8, t9.id AS id_10, t9.bracket_data AS bracket_data_11, t9.current_round AS current_round_12, t9.is_completed AS is_completed_13, t9.game_id AS game_id_14 FROM game t0 LEFT JOIN tournament t9 ON t9.game_id = t0.id WHERE t0.olympix_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1272)
9	Twig\Extension\CoreExtension::length (line 179)
10	__TwigTemplate_27c22113b23c4268bc901f088a12a731->block_body (line 446)
11	Twig\Template->yieldBlock (line 416)
12	__TwigTemplate_6f131861d482b4a632abb63bece87fe8->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_27c22113b23c4268bc901f088a12a731->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 29)
23	App\Controller\MainController->index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\Game	15
App\Entity\Player	8
App\Entity\Tournament	4
App\Entity\Olympix	1

Entities Mapping

Class	Mapping errors
App\Entity\Olympix	No errors.
App\Entity\Player	No errors.
App\Entity\Game	No errors.
App\Entity\GameResult	No errors.
App\Entity\QuizAnswer	No errors.
App\Entity\Joker	No errors.
App\Entity\GamechangerThrow	No errors.
App\Entity\Tournament	No errors.
App\Entity\QuizQuestion	No errors.
App\Entity\SplitOrStealMatch	No errors.

Symfony Profiler

GET https://saufolympix.itserviceschwarz.de/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping