Query Metrics
1
Database Queries
1
Different statements
6.10 ms
Query time
0
Invalid entities
148
Managed entities
Queries
| #▲ | 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. |