GET https://saufolympix.itserviceschwarz.de/gameadmin/1

Query Metrics

16 Database Queries
2 Different statements
8.46 ms Query time
0 Invalid entities
28 Managed entities

Queries

Group similar statements

# Time Info
1 1.89 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, 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, g2_.id AS id_9, g2_.name AS name_10, g2_.game_type AS game_type_11, g2_.team_size AS team_size_12, g2_.points_distribution AS points_distribution_13, g2_.status AS status_14, g2_.order_position AS order_position_15, p1_.olympix_id AS olympix_id_16, g2_.olympix_id AS olympix_id_17 FROM olympix o0_ LEFT JOIN player p1_ ON o0_.id = p1_.olympix_id LEFT JOIN game g2_ ON o0_.id = g2_.olympix_id WHERE o0_.id = ?
Parameters:
[
  1
]
2 0.64 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  1
]
3 0.44 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  2
]
4 0.39 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  3
]
5 0.40 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  4
]
6 0.27 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  5
]
7 0.40 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  6
]
8 0.50 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  7
]
9 0.37 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  8
]
10 0.32 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  9
]
11 0.37 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  10
]
12 0.64 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  11
]
13 0.38 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  12
]
14 0.36 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  13
]
15 0.69 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  14
]
16 0.41 ms
SELECT t0.id AS id_1, t0.bracket_data AS bracket_data_2, t0.current_round AS current_round_3, t0.is_completed AS is_completed_4, t0.game_id AS game_id_5 FROM tournament t0 WHERE t0.game_id = ?
Parameters:
[
  15
]

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\QuizQuestion No errors.
App\Entity\Tournament No errors.
App\Entity\SplitOrStealMatch No errors.