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

Query Metrics

1 Database Queries
1 Different statements
6.10 ms Query time
0 Invalid entities
148 Managed entities

Queries

Group similar statements

# Time Info
1 6.10 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, g3_.id AS id_16, g3_.points AS points_17, g3_.position AS position_18, g3_.team_id AS team_id_19, g3_.joker_double_applied AS joker_double_applied_20, q4_.id AS id_21, q4_.question AS question_22, q4_.correct_answer AS correct_answer_23, q4_.order_position AS order_position_24, t5_.id AS id_25, t5_.bracket_data AS bracket_data_26, t5_.current_round AS current_round_27, t5_.is_completed AS is_completed_28, p1_.olympix_id AS olympix_id_29, g2_.olympix_id AS olympix_id_30, g3_.game_id AS game_id_31, g3_.player_id AS player_id_32, q4_.game_id AS game_id_33, t5_.game_id AS game_id_34 FROM olympix o0_ LEFT JOIN player p1_ ON o0_.id = p1_.olympix_id LEFT JOIN game g2_ ON o0_.id = g2_.olympix_id LEFT JOIN game_result g3_ ON g2_.id = g3_.game_id LEFT JOIN quiz_question q4_ ON g2_.id = q4_.game_id LEFT JOIN tournament t5_ ON g2_.id = t5_.game_id WHERE o0_.id = ?
Parameters:
[
  1
]

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\GameResult 120
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\QuizQuestion No errors.
App\Entity\Tournament No errors.
App\Entity\QuizAnswer No errors.
App\Entity\Joker No errors.
App\Entity\GamechangerThrow No errors.
App\Entity\SplitOrStealMatch No errors.