Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.40 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.11 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.id = ?

Parameters:

[
  12
]

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.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.id = 12;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 173)
7	App\Controller\JokerController->manage (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.00 ms

SELECT j0_.id AS id_0, j0_.joker_type AS joker_type_1, j0_.is_used AS is_used_2, j0_.used_at AS used_at_3, p1_.id AS id_4, p1_.name AS name_5, p1_.total_points AS total_points_6, p1_.joker_double_used AS joker_double_used_7, p1_.joker_swap_used AS joker_swap_used_8, j0_.player_id AS player_id_9, j0_.game_id AS game_id_10, j0_.target_player_id AS target_player_id_11, p1_.olympix_id AS olympix_id_12 FROM joker j0_ LEFT JOIN player p1_ ON j0_.player_id = p1_.id WHERE j0_.game_id = ? AND j0_.is_used = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.joker_type AS joker_type_1,
  j0_.is_used AS is_used_2,
  j0_.used_at AS used_at_3,
  p1_.id AS id_4,
  p1_.name AS name_5,
  p1_.total_points AS total_points_6,
  p1_.joker_double_used AS joker_double_used_7,
  p1_.joker_swap_used AS joker_swap_used_8,
  j0_.player_id AS player_id_9,
  j0_.game_id AS game_id_10,
  j0_.target_player_id AS target_player_id_11,
  p1_.olympix_id AS olympix_id_12
FROM
  joker j0_
  LEFT JOIN player p1_ ON j0_.player_id = p1_.id
WHERE
  j0_.game_id = ?
  AND j0_.is_used = ?

SELECT j0_.id AS id_0, j0_.joker_type AS joker_type_1, j0_.is_used AS is_used_2, j0_.used_at AS used_at_3, p1_.id AS id_4, p1_.name AS name_5, p1_.total_points AS total_points_6, p1_.joker_double_used AS joker_double_used_7, p1_.joker_swap_used AS joker_swap_used_8, j0_.player_id AS player_id_9, j0_.game_id AS game_id_10, j0_.target_player_id AS target_player_id_11, p1_.olympix_id AS olympix_id_12 FROM joker j0_ LEFT JOIN player p1_ ON j0_.player_id = p1_.id WHERE j0_.game_id = 12 AND j0_.is_used = 1;

#	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 47)
7	App\Repository\JokerRepository->findActiveJokersByGame (line 179)
8	App\Controller\JokerController->manage (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.62 ms

SELECT j0_.id AS id_0, j0_.joker_type AS joker_type_1, j0_.is_used AS is_used_2, j0_.used_at AS used_at_3, p1_.id AS id_4, p1_.name AS name_5, p1_.total_points AS total_points_6, p1_.joker_double_used AS joker_double_used_7, p1_.joker_swap_used AS joker_swap_used_8, j0_.player_id AS player_id_9, j0_.game_id AS game_id_10, j0_.target_player_id AS target_player_id_11, p1_.olympix_id AS olympix_id_12 FROM joker j0_ LEFT JOIN player p1_ ON j0_.player_id = p1_.id WHERE j0_.game_id = ? AND j0_.joker_type = ? AND j0_.is_used = ?

Parameters:

[
  12
  "double"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.joker_type AS joker_type_1,
  j0_.is_used AS is_used_2,
  j0_.used_at AS used_at_3,
  p1_.id AS id_4,
  p1_.name AS name_5,
  p1_.total_points AS total_points_6,
  p1_.joker_double_used AS joker_double_used_7,
  p1_.joker_swap_used AS joker_swap_used_8,
  j0_.player_id AS player_id_9,
  j0_.game_id AS game_id_10,
  j0_.target_player_id AS target_player_id_11,
  p1_.olympix_id AS olympix_id_12
FROM
  joker j0_
  LEFT JOIN player p1_ ON j0_.player_id = p1_.id
WHERE
  j0_.game_id = ?
  AND j0_.joker_type = ?
  AND j0_.is_used = ?

SELECT j0_.id AS id_0, j0_.joker_type AS joker_type_1, j0_.is_used AS is_used_2, j0_.used_at AS used_at_3, p1_.id AS id_4, p1_.name AS name_5, p1_.total_points AS total_points_6, p1_.joker_double_used AS joker_double_used_7, p1_.joker_swap_used AS joker_swap_used_8, j0_.player_id AS player_id_9, j0_.game_id AS game_id_10, j0_.target_player_id AS target_player_id_11, p1_.olympix_id AS olympix_id_12 FROM joker j0_ LEFT JOIN player p1_ ON j0_.player_id = p1_.id WHERE j0_.game_id = 12 AND j0_.joker_type = 'double' AND j0_.is_used = 1;

#	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 62)
7	App\Repository\JokerRepository->findDoubleJokersByGame (line 180)
8	App\Controller\JokerController->manage (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.68 ms

SELECT j0_.id AS id_0, j0_.joker_type AS joker_type_1, j0_.is_used AS is_used_2, j0_.used_at AS used_at_3, p1_.id AS id_4, p1_.name AS name_5, p1_.total_points AS total_points_6, p1_.joker_double_used AS joker_double_used_7, p1_.joker_swap_used AS joker_swap_used_8, p2_.id AS id_9, p2_.name AS name_10, p2_.total_points AS total_points_11, p2_.joker_double_used AS joker_double_used_12, p2_.joker_swap_used AS joker_swap_used_13, j0_.player_id AS player_id_14, j0_.game_id AS game_id_15, j0_.target_player_id AS target_player_id_16, p1_.olympix_id AS olympix_id_17, p2_.olympix_id AS olympix_id_18 FROM joker j0_ LEFT JOIN player p1_ ON j0_.player_id = p1_.id LEFT JOIN player p2_ ON j0_.target_player_id = p2_.id WHERE j0_.game_id = ? AND j0_.joker_type = ? AND j0_.is_used = ?

Parameters:

[
  12
  "swap"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.id AS id_0,
  j0_.joker_type AS joker_type_1,
  j0_.is_used AS is_used_2,
  j0_.used_at AS used_at_3,
  p1_.id AS id_4,
  p1_.name AS name_5,
  p1_.total_points AS total_points_6,
  p1_.joker_double_used AS joker_double_used_7,
  p1_.joker_swap_used AS joker_swap_used_8,
  p2_.id AS id_9,
  p2_.name AS name_10,
  p2_.total_points AS total_points_11,
  p2_.joker_double_used AS joker_double_used_12,
  p2_.joker_swap_used AS joker_swap_used_13,
  j0_.player_id AS player_id_14,
  j0_.game_id AS game_id_15,
  j0_.target_player_id AS target_player_id_16,
  p1_.olympix_id AS olympix_id_17,
  p2_.olympix_id AS olympix_id_18
FROM
  joker j0_
  LEFT JOIN player p1_ ON j0_.player_id = p1_.id
  LEFT JOIN player p2_ ON j0_.target_player_id = p2_.id
WHERE
  j0_.game_id = ?
  AND j0_.joker_type = ?
  AND j0_.is_used = ?

SELECT j0_.id AS id_0, j0_.joker_type AS joker_type_1, j0_.is_used AS is_used_2, j0_.used_at AS used_at_3, p1_.id AS id_4, p1_.name AS name_5, p1_.total_points AS total_points_6, p1_.joker_double_used AS joker_double_used_7, p1_.joker_swap_used AS joker_swap_used_8, p2_.id AS id_9, p2_.name AS name_10, p2_.total_points AS total_points_11, p2_.joker_double_used AS joker_double_used_12, p2_.joker_swap_used AS joker_swap_used_13, j0_.player_id AS player_id_14, j0_.game_id AS game_id_15, j0_.target_player_id AS target_player_id_16, p1_.olympix_id AS olympix_id_17, p2_.olympix_id AS olympix_id_18 FROM joker j0_ LEFT JOIN player p1_ ON j0_.player_id = p1_.id LEFT JOIN player p2_ ON j0_.target_player_id = p2_.id WHERE j0_.game_id = 12 AND j0_.joker_type = 'swap' AND j0_.is_used = 1;

#	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 79)
7	App\Repository\JokerRepository->findSwapJokersByGame (line 181)
8	App\Controller\JokerController->manage (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)

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	1
App\Entity\Olympix	1

Entities Mapping

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

Symfony Profiler

GET https://saufolympix.itserviceschwarz.de/joker/manage/12

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping