Symfony Profiler

Query Metrics

67 Database Queries

19 Different statements

22.55 ms Query time

0 Invalid entities

15 Managed entities

Queries


SELECT t1.id AS id_2, t1.winning_games AS winning_games_3, t1.time AS time_4, t1.status AS status_5, t0.pool_table_type AS pool_table_type_6, t0.approved AS approved_7, t0.counts_for_league_stats AS counts_for_league_stats_8, t0.track_game_times AS track_game_times_9, t0.track_final_ball_count AS track_final_ball_count_10, t0.track_finished_with_foul AS track_finished_with_foul_11, t0.single_game_tournament AS single_game_tournament_12, t0.league_id AS league_id_13, t0.location_id AS location_id_14, t1.type FROM tournament t0 INNER JOIN abstract_tournament t1 ON t0.id = t1.id WHERE t1.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.min_players_to_count_into_stats AS min_players_to_count_into_stats_3, t0.status AS status_4 FROM league t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2 FROM location t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.user_role AS user_role_3, t0.password AS password_4, t0.time_last_login AS time_last_login_5, t0.enabled AS enabled_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.image AS image_9, t0.original_image_name AS original_image_name_10, t0.reset_password_token AS reset_password_token_11, t0.elo AS elo_12, t0.games_played AS games_played_13, t0.reset_password_token_time_created AS reset_password_token_time_created_14, t0.reset_password_token_time_expires AS reset_password_token_time_expires_15, t0.time_password_last_changed AS time_password_last_changed_16, t0.last_game_played_time AS last_game_played_time_17 FROM `user` t0 INNER JOIN abstract_tournament_user ON t0.id = abstract_tournament_user.user_id WHERE abstract_tournament_user.abstract_tournament_id = ?
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT t1.id AS id_2, t1.winning_games AS winning_games_3, t1.time AS time_4, t1.status AS status_5, t0.parent_tournament_id AS parent_tournament_id_6, t1.type FROM tournament_decider t0 INNER JOIN abstract_tournament t1 ON t0.id = t1.id WHERE t0.parent_tournament_id = ?
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ?
SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = ?
SELECT count(DISTINCT g0_.id) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN duel_user d3_ ON d1_.id = d3_.duel_id INNER JOIN `user` u2_ ON u2_.id = d3_.user_id LEFT JOIN elo_change_log e4_ ON g0_.id = e4_.game_id INNER JOIN abstract_tournament a5_ ON d1_.tournament_id = a5_.id LEFT JOIN tournament t6_ ON a5_.id = t6_.id LEFT JOIN tournament_decider t7_ ON a5_.id = t7_.id WHERE a5_.id IN (?)
SELECT DISTINCT g0_.id AS id_0, g0_.time AS time_1 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN duel_user d3_ ON d1_.id = d3_.duel_id INNER JOIN `user` u2_ ON u2_.id = d3_.user_id LEFT JOIN elo_change_log e4_ ON g0_.id = e4_.game_id INNER JOIN abstract_tournament a5_ ON d1_.tournament_id = a5_.id LEFT JOIN tournament t6_ ON a5_.id = t6_.id LEFT JOIN tournament_decider t7_ ON a5_.id = t7_.id WHERE a5_.id IN (?) ORDER BY g0_.time DESC LIMIT 25
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT t0.id AS id_1, t0.games_played AS games_played_2, t0.status AS status_3, t0.tournament_id AS tournament_id_4, t0.winner_id AS winner_id_5, t6.id AS id_7, t6.email AS email_8, t6.user_role AS user_role_9, t6.password AS password_10, t6.time_last_login AS time_last_login_11, t6.enabled AS enabled_12, t6.first_name AS first_name_13, t6.last_name AS last_name_14, t6.image AS image_15, t6.original_image_name AS original_image_name_16, t6.reset_password_token AS reset_password_token_17, t6.elo AS elo_18, t6.games_played AS games_played_19, t6.reset_password_token_time_created AS reset_password_token_time_created_20, t6.reset_password_token_time_expires AS reset_password_token_time_expires_21, t6.time_password_last_changed AS time_password_last_changed_22, t6.last_game_played_time AS last_game_played_time_23, t0.tournament_player_absence_id AS tournament_player_absence_id_24, t25.id AS id_26, t25.time AS time_27, t25.tournament_id AS tournament_id_28, t25.player_id AS player_id_29 FROM duel t0 LEFT JOIN `user` t6 ON t0.winner_id = t6.id LEFT JOIN tournament_player_absence t25 ON t0.tournament_player_absence_id = t25.id WHERE t0.tournament_id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, g0_.duel_id AS duel_id_5, g0_.winner_id AS winner_id_6 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN abstract_tournament a2_ ON d1_.tournament_id = a2_.id LEFT JOIN tournament t3_ ON a2_.id = t3_.id LEFT JOIN tournament_decider t4_ ON a2_.id = t4_.id WHERE a2_.id = ? ORDER BY g0_.time DESC LIMIT 1
SELECT t0.name AS name_1, t0.value AS value_2 FROM setting t0 WHERE t0.name = ?
SELECT t0.name AS name_1, t0.value AS value_2 FROM setting t0 WHERE t0.name = ?
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ?
SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?)
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ?
SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?)
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ?
SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?)
SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ?
SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ?
SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?)
SELECT t0.id AS id_1, t0.time AS time_2, t0.tournament_id AS tournament_id_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.email AS email_7, t5.user_role AS user_role_8, t5.password AS password_9, t5.time_last_login AS time_last_login_10, t5.enabled AS enabled_11, t5.first_name AS first_name_12, t5.last_name AS last_name_13, t5.image AS image_14, t5.original_image_name AS original_image_name_15, t5.reset_password_token AS reset_password_token_16, t5.elo AS elo_17, t5.games_played AS games_played_18, t5.reset_password_token_time_created AS reset_password_token_time_created_19, t5.reset_password_token_time_expires AS reset_password_token_time_expires_20, t5.time_password_last_changed AS time_password_last_changed_21, t5.last_game_played_time AS last_game_played_time_22 FROM tournament_player_absence t0 INNER JOIN `user` t5 ON t0.player_id = t5.id WHERE t0.tournament_id = ?

#▲	Time	Info
1	0.47 ms	SELECT t1.id AS id_2, t1.winning_games AS winning_games_3, t1.time AS time_4, t1.status AS status_5, t0.pool_table_type AS pool_table_type_6, t0.approved AS approved_7, t0.counts_for_league_stats AS counts_for_league_stats_8, t0.track_game_times AS track_game_times_9, t0.track_final_ball_count AS track_final_ball_count_10, t0.track_finished_with_foul AS track_finished_with_foul_11, t0.single_game_tournament AS single_game_tournament_12, t0.league_id AS league_id_13, t0.location_id AS location_id_14, t1.type FROM tournament t0 INNER JOIN abstract_tournament t1 ON t0.id = t1.id WHERE t1.id = ? Parameters: [`"142"`] View formatted query View runnable query Explain query SELECT t1.id AS id_2, t1.winning_games AS winning_games_3, t1.time AS time_4, t1.status AS status_5, t0.pool_table_type AS pool_table_type_6, t0.approved AS approved_7, t0.counts_for_league_stats AS counts_for_league_stats_8, t0.track_game_times AS track_game_times_9, t0.track_final_ball_count AS track_final_ball_count_10, t0.track_finished_with_foul AS track_finished_with_foul_11, t0.single_game_tournament AS single_game_tournament_12, t0.league_id AS league_id_13, t0.location_id AS location_id_14, t1.type FROM tournament t0 INNER JOIN abstract_tournament t1 ON t0.id = t1.id WHERE t1.id = ? SELECT t1.id AS id_2, t1.winning_games AS winning_games_3, t1.time AS time_4, t1.status AS status_5, t0.pool_table_type AS pool_table_type_6, t0.approved AS approved_7, t0.counts_for_league_stats AS counts_for_league_stats_8, t0.track_game_times AS track_game_times_9, t0.track_final_ball_count AS track_final_ball_count_10, t0.track_finished_with_foul AS track_finished_with_foul_11, t0.single_game_tournament AS single_game_tournament_12, t0.league_id AS league_id_13, t0.location_id AS location_id_14, t1.type FROM tournament t0 INNER JOIN abstract_tournament t1 ON t0.id = t1.id WHERE t1.id = '142';
2	0.19 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.min_players_to_count_into_stats AS min_players_to_count_into_stats_3, t0.status AS status_4 FROM league t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.min_players_to_count_into_stats AS min_players_to_count_into_stats_3, t0.status AS status_4 FROM league t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.min_players_to_count_into_stats AS min_players_to_count_into_stats_3, t0.status AS status_4 FROM league t0 WHERE t0.id = 3;
3	0.15 ms	SELECT t0.id AS id_1, t0.name AS name_2 FROM location t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2 FROM location t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2 FROM location t0 WHERE t0.id = 1;
4	0.37 ms	SELECT t0.id AS id_1, t0.email AS email_2, t0.user_role AS user_role_3, t0.password AS password_4, t0.time_last_login AS time_last_login_5, t0.enabled AS enabled_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.image AS image_9, t0.original_image_name AS original_image_name_10, t0.reset_password_token AS reset_password_token_11, t0.elo AS elo_12, t0.games_played AS games_played_13, t0.reset_password_token_time_created AS reset_password_token_time_created_14, t0.reset_password_token_time_expires AS reset_password_token_time_expires_15, t0.time_password_last_changed AS time_password_last_changed_16, t0.last_game_played_time AS last_game_played_time_17 FROM `user` t0 INNER JOIN abstract_tournament_user ON t0.id = abstract_tournament_user.user_id WHERE abstract_tournament_user.abstract_tournament_id = ? Parameters: [`142`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.email AS email_2, t0.user_role AS user_role_3, t0.password AS password_4, t0.time_last_login AS time_last_login_5, t0.enabled AS enabled_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.image AS image_9, t0.original_image_name AS original_image_name_10, t0.reset_password_token AS reset_password_token_11, t0.elo AS elo_12, t0.games_played AS games_played_13, t0.reset_password_token_time_created AS reset_password_token_time_created_14, t0.reset_password_token_time_expires AS reset_password_token_time_expires_15, t0.time_password_last_changed AS time_password_last_changed_16, t0.last_game_played_time AS last_game_played_time_17 FROM `user` t0 INNER JOIN abstract_tournament_user ON t0.id = abstract_tournament_user.user_id WHERE abstract_tournament_user.abstract_tournament_id = ? SELECT t0.id AS id_1, t0.email AS email_2, t0.user_role AS user_role_3, t0.password AS password_4, t0.time_last_login AS time_last_login_5, t0.enabled AS enabled_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.image AS image_9, t0.original_image_name AS original_image_name_10, t0.reset_password_token AS reset_password_token_11, t0.elo AS elo_12, t0.games_played AS games_played_13, t0.reset_password_token_time_created AS reset_password_token_time_created_14, t0.reset_password_token_time_expires AS reset_password_token_time_expires_15, t0.time_password_last_changed AS time_password_last_changed_16, t0.last_game_played_time AS last_game_played_time_17 FROM `user` t0 INNER JOIN abstract_tournament_user ON t0.id = abstract_tournament_user.user_id WHERE abstract_tournament_user.abstract_tournament_id = 142;
5	0.37 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`2 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 2 AND l0_.id = 3;
6	0.18 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`3 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 3 AND l0_.id = 3;
7	0.17 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`4 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 4 AND l0_.id = 3;
8	0.15 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`5 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 5 AND l0_.id = 3;
9	0.54 ms	SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = ? Parameters: [`142`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = ? SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = 142;
10	0.25 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`419`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 419;
11	0.21 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`420`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 420;
12	0.22 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`421`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 421;
13	0.23 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`422`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 422;
14	0.20 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`423`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 423;
15	0.20 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`424`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 424;
16	0.20 ms	SELECT t1.id AS id_2, t1.winning_games AS winning_games_3, t1.time AS time_4, t1.status AS status_5, t0.parent_tournament_id AS parent_tournament_id_6, t1.type FROM tournament_decider t0 INNER JOIN abstract_tournament t1 ON t0.id = t1.id WHERE t0.parent_tournament_id = ? Parameters: [`142`] View formatted query View runnable query Explain query SELECT t1.id AS id_2, t1.winning_games AS winning_games_3, t1.time AS time_4, t1.status AS status_5, t0.parent_tournament_id AS parent_tournament_id_6, t1.type FROM tournament_decider t0 INNER JOIN abstract_tournament t1 ON t0.id = t1.id WHERE t0.parent_tournament_id = ? SELECT t1.id AS id_2, t1.winning_games AS winning_games_3, t1.time AS time_4, t1.status AS status_5, t0.parent_tournament_id AS parent_tournament_id_6, t1.type FROM tournament_decider t0 INNER JOIN abstract_tournament t1 ON t0.id = t1.id WHERE t0.parent_tournament_id = 142;
17	0.17 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`2 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 2 AND l0_.id = 3;
18	0.17 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`3 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 3 AND l0_.id = 3;
19	0.43 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`4 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 4 AND l0_.id = 3;
20	0.17 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`5 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 5 AND l0_.id = 3;
21	0.36 ms	SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = ? Parameters: [`142`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = ? SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = 142;
22	0.39 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`419`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 419;
23	0.22 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`420`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 420;
24	0.21 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`421`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 421;
25	0.22 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`422`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 422;
26	0.20 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`423`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 423;
27	0.20 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? Parameters: [`424`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = ? SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, e1_.id AS id_5, e1_.time AS time_6, e1_.old_elo AS old_elo_7, e1_.new_elo AS new_elo_8, g0_.duel_id AS duel_id_9, g0_.winner_id AS winner_id_10, e1_.player_id AS player_id_11, e1_.game_id AS game_id_12 FROM game g0_ INNER JOIN elo_change_log e1_ ON g0_.id = e1_.game_id WHERE g0_.duel_id = 424;
28	0.36 ms	SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = ? Parameters: [`142`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = ? SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, u1_.id AS id_3, u1_.email AS email_4, u1_.user_role AS user_role_5, u1_.password AS password_6, u1_.time_last_login AS time_last_login_7, u1_.enabled AS enabled_8, u1_.first_name AS first_name_9, u1_.last_name AS last_name_10, u1_.image AS image_11, u1_.original_image_name AS original_image_name_12, u1_.reset_password_token AS reset_password_token_13, u1_.elo AS elo_14, u1_.games_played AS games_played_15, u1_.reset_password_token_time_created AS reset_password_token_time_created_16, u1_.reset_password_token_time_expires AS reset_password_token_time_expires_17, u1_.time_password_last_changed AS time_password_last_changed_18, u1_.last_game_played_time AS last_game_played_time_19, d0_.tournament_id AS tournament_id_20, d0_.winner_id AS winner_id_21, d0_.tournament_player_absence_id AS tournament_player_absence_id_22 FROM duel d0_ INNER JOIN duel_user d2_ ON d0_.id = d2_.duel_id INNER JOIN `user` u1_ ON u1_.id = d2_.user_id WHERE d0_.tournament_id = 142;
29	0.55 ms	SELECT count(DISTINCT g0_.id) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN duel_user d3_ ON d1_.id = d3_.duel_id INNER JOIN `user` u2_ ON u2_.id = d3_.user_id LEFT JOIN elo_change_log e4_ ON g0_.id = e4_.game_id INNER JOIN abstract_tournament a5_ ON d1_.tournament_id = a5_.id LEFT JOIN tournament t6_ ON a5_.id = t6_.id LEFT JOIN tournament_decider t7_ ON a5_.id = t7_.id WHERE a5_.id IN (?) Parameters: [`142`] View formatted query View runnable query Explain query SELECT count(DISTINCT g0_.id) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN duel_user d3_ ON d1_.id = d3_.duel_id INNER JOIN `user` u2_ ON u2_.id = d3_.user_id LEFT JOIN elo_change_log e4_ ON g0_.id = e4_.game_id INNER JOIN abstract_tournament a5_ ON d1_.tournament_id = a5_.id LEFT JOIN tournament t6_ ON a5_.id = t6_.id LEFT JOIN tournament_decider t7_ ON a5_.id = t7_.id WHERE a5_.id IN (?) SELECT count(DISTINCT g0_.id) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN duel_user d3_ ON d1_.id = d3_.duel_id INNER JOIN `user` u2_ ON u2_.id = d3_.user_id LEFT JOIN elo_change_log e4_ ON g0_.id = e4_.game_id INNER JOIN abstract_tournament a5_ ON d1_.tournament_id = a5_.id LEFT JOIN tournament t6_ ON a5_.id = t6_.id LEFT JOIN tournament_decider t7_ ON a5_.id = t7_.id WHERE a5_.id IN (142);
30	0.55 ms	SELECT DISTINCT g0_.id AS id_0, g0_.time AS time_1 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN duel_user d3_ ON d1_.id = d3_.duel_id INNER JOIN `user` u2_ ON u2_.id = d3_.user_id LEFT JOIN elo_change_log e4_ ON g0_.id = e4_.game_id INNER JOIN abstract_tournament a5_ ON d1_.tournament_id = a5_.id LEFT JOIN tournament t6_ ON a5_.id = t6_.id LEFT JOIN tournament_decider t7_ ON a5_.id = t7_.id WHERE a5_.id IN (?) ORDER BY g0_.time DESC LIMIT 25 Parameters: [`142`] View formatted query View runnable query Explain query SELECT DISTINCT g0_.id AS id_0, g0_.time AS time_1 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN duel_user d3_ ON d1_.id = d3_.duel_id INNER JOIN `user` u2_ ON u2_.id = d3_.user_id LEFT JOIN elo_change_log e4_ ON g0_.id = e4_.game_id INNER JOIN abstract_tournament a5_ ON d1_.tournament_id = a5_.id LEFT JOIN tournament t6_ ON a5_.id = t6_.id LEFT JOIN tournament_decider t7_ ON a5_.id = t7_.id WHERE a5_.id IN (?) ORDER BY g0_.time DESC LIMIT 25 SELECT DISTINCT g0_.id AS id_0, g0_.time AS time_1 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN duel_user d3_ ON d1_.id = d3_.duel_id INNER JOIN `user` u2_ ON u2_.id = d3_.user_id LEFT JOIN elo_change_log e4_ ON g0_.id = e4_.game_id INNER JOIN abstract_tournament a5_ ON d1_.tournament_id = a5_.id LEFT JOIN tournament t6_ ON a5_.id = t6_.id LEFT JOIN tournament_decider t7_ ON a5_.id = t7_.id WHERE a5_.id IN (142) ORDER BY g0_.time DESC LIMIT 25;
31	0.36 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142.2"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142.2');
32	1.26 ms	DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142.2"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?) DELETE FROM cache_items WHERE item_lifetime + item_time <= 1746065906 AND item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142.2');
33	0.34 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:\x00tags\x00tournamentPositionProbabilities.142.2"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:\0tags\0tournamentPositionProbabilities.142.2');
34	0.45 ms	SELECT t0.id AS id_1, t0.games_played AS games_played_2, t0.status AS status_3, t0.tournament_id AS tournament_id_4, t0.winner_id AS winner_id_5, t6.id AS id_7, t6.email AS email_8, t6.user_role AS user_role_9, t6.password AS password_10, t6.time_last_login AS time_last_login_11, t6.enabled AS enabled_12, t6.first_name AS first_name_13, t6.last_name AS last_name_14, t6.image AS image_15, t6.original_image_name AS original_image_name_16, t6.reset_password_token AS reset_password_token_17, t6.elo AS elo_18, t6.games_played AS games_played_19, t6.reset_password_token_time_created AS reset_password_token_time_created_20, t6.reset_password_token_time_expires AS reset_password_token_time_expires_21, t6.time_password_last_changed AS time_password_last_changed_22, t6.last_game_played_time AS last_game_played_time_23, t0.tournament_player_absence_id AS tournament_player_absence_id_24, t25.id AS id_26, t25.time AS time_27, t25.tournament_id AS tournament_id_28, t25.player_id AS player_id_29 FROM duel t0 LEFT JOIN `user` t6 ON t0.winner_id = t6.id LEFT JOIN tournament_player_absence t25 ON t0.tournament_player_absence_id = t25.id WHERE t0.tournament_id = ? Parameters: [`142`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.games_played AS games_played_2, t0.status AS status_3, t0.tournament_id AS tournament_id_4, t0.winner_id AS winner_id_5, t6.id AS id_7, t6.email AS email_8, t6.user_role AS user_role_9, t6.password AS password_10, t6.time_last_login AS time_last_login_11, t6.enabled AS enabled_12, t6.first_name AS first_name_13, t6.last_name AS last_name_14, t6.image AS image_15, t6.original_image_name AS original_image_name_16, t6.reset_password_token AS reset_password_token_17, t6.elo AS elo_18, t6.games_played AS games_played_19, t6.reset_password_token_time_created AS reset_password_token_time_created_20, t6.reset_password_token_time_expires AS reset_password_token_time_expires_21, t6.time_password_last_changed AS time_password_last_changed_22, t6.last_game_played_time AS last_game_played_time_23, t0.tournament_player_absence_id AS tournament_player_absence_id_24, t25.id AS id_26, t25.time AS time_27, t25.tournament_id AS tournament_id_28, t25.player_id AS player_id_29 FROM duel t0 LEFT JOIN `user` t6 ON t0.winner_id = t6.id LEFT JOIN tournament_player_absence t25 ON t0.tournament_player_absence_id = t25.id WHERE t0.tournament_id = ? SELECT t0.id AS id_1, t0.games_played AS games_played_2, t0.status AS status_3, t0.tournament_id AS tournament_id_4, t0.winner_id AS winner_id_5, t6.id AS id_7, t6.email AS email_8, t6.user_role AS user_role_9, t6.password AS password_10, t6.time_last_login AS time_last_login_11, t6.enabled AS enabled_12, t6.first_name AS first_name_13, t6.last_name AS last_name_14, t6.image AS image_15, t6.original_image_name AS original_image_name_16, t6.reset_password_token AS reset_password_token_17, t6.elo AS elo_18, t6.games_played AS games_played_19, t6.reset_password_token_time_created AS reset_password_token_time_created_20, t6.reset_password_token_time_expires AS reset_password_token_time_expires_21, t6.time_password_last_changed AS time_password_last_changed_22, t6.last_game_played_time AS last_game_played_time_23, t0.tournament_player_absence_id AS tournament_player_absence_id_24, t25.id AS id_26, t25.time AS time_27, t25.tournament_id AS tournament_id_28, t25.player_id AS player_id_29 FROM duel t0 LEFT JOIN `user` t6 ON t0.winner_id = t6.id LEFT JOIN tournament_player_absence t25 ON t0.tournament_player_absence_id = t25.id WHERE t0.tournament_id = 142;
35	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142tags');
36	0.76 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`2 => 3600 3 => 1746065906 0 => "Kb6UtO0glY:tournamentPositionProbabilities.142.2" 1 => b"O:1:"©":2:{s:6:"{DÕ\x05à\x1C";a:4:{i:1;d:0.010267070176487873;i:2;d:0.08389902053587198;i:3;d:0.2962202801623144;i:4;d:0.6096136291253259;}s:35:"tournamentPositionProbabilities.142";s:6:"JÁÄQmŽ";}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('Kb6UtO0glY:tournamentPositionProbabilities.142.2', 0x4F3A313A22A9223A323A7B733A363A227B44D505E01C223B613A343A7B693A313B643A302E3031303236373037303137363438373837333B693A323B643A302E30383338393930323035333538373139383B693A333B643A302E323936323230323830313632333134343B693A343B643A302E363039363133363239313235333235393B7D733A33353A22746F75726E616D656E74506F736974696F6E50726F626162696C69746965732E313432223B733A363A224AC1C4516D8E223B7D, 3600, 1746065906) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
37	0.38 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142.3"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142.3');
38	0.38 ms	DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142.3"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?) DELETE FROM cache_items WHERE item_lifetime + item_time <= 1746065906 AND item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142.3');
39	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:\x00tags\x00tournamentPositionProbabilities.142.3"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:\0tags\0tournamentPositionProbabilities.142.3');
40	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142tags');
41	1.26 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`2 => 3600 3 => 1746065906 0 => "Kb6UtO0glY:tournamentPositionProbabilities.142.3" 1 => b"O:1:"©":2:{s:6:"{DÕ\x05à\x1D";a:4:{i:2;d:0.20468467947168958;i:4;d:0.015925012523624445;i:3;d:0.046572449754675116;i:1;d:0.732817858250011;}s:35:"tournamentPositionProbabilities.142";s:6:"JÁÄQmŽ";}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('Kb6UtO0glY:tournamentPositionProbabilities.142.3', 0x4F3A313A22A9223A323A7B733A363A227B44D505E01D223B613A343A7B693A323B643A302E32303436383436373934373136383935383B693A343B643A302E3031353932353031323532333632343434353B693A333B643A302E3034363537323434393735343637353131363B693A313B643A302E3733323831373835383235303031313B7D733A33353A22746F75726E616D656E74506F736974696F6E50726F626162696C69746965732E313432223B733A363A224AC1C4516D8E223B7D, 3600, 1746065906) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
42	0.29 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142.4"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142.4');
43	1.10 ms	DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142.4"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?) DELETE FROM cache_items WHERE item_lifetime + item_time <= 1746065906 AND item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142.4');
44	0.26 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:\x00tags\x00tournamentPositionProbabilities.142.4"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:\0tags\0tournamentPositionProbabilities.142.4');
45	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142tags');
46	0.55 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`2 => 3600 3 => 1746065906 0 => "Kb6UtO0glY:tournamentPositionProbabilities.142.4" 1 => b"O:1:"©":2:{s:6:"{DÕ\x05À\x1D";a:4:{i:3;d:0.20308424301265038;i:4;d:0.11247353097923649;i:2;d:0.45152061980229014;i:1;d:0.23292160620582308;}s:35:"tournamentPositionProbabilities.142";s:6:"JÁÄQmŽ";}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('Kb6UtO0glY:tournamentPositionProbabilities.142.4', 0x4F3A313A22A9223A323A7B733A363A227B44D505C01D223B613A343A7B693A333B643A302E32303330383432343330313236353033383B693A343B643A302E31313234373335333039373932333634393B693A323B643A302E34353135323036313938303232393031343B693A313B643A302E32333239323136303632303538323330383B7D733A33353A22746F75726E616D656E74506F736974696F6E50726F626162696C69746965732E313432223B733A363A224AC1C4516D8E223B7D, 3600, 1746065906) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
47	0.21 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142.5"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142.5');
48	0.43 ms	DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142.5"`] View formatted query View runnable query Explain query DELETE FROM cache_items WHERE item_lifetime + item_time <= ? AND item_id IN (?) DELETE FROM cache_items WHERE item_lifetime + item_time <= 1746065906 AND item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142.5');
49	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:\x00tags\x00tournamentPositionProbabilities.142.5"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:\0tags\0tournamentPositionProbabilities.142.5');
50	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1746065906 "Kb6UtO0glY:tournamentPositionProbabilities.142\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1746065906 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('Kb6UtO0glY:tournamentPositionProbabilities.142tags');
51	0.46 ms	INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time) Parameters: [`2 => 3600 3 => 1746065906 0 => "Kb6UtO0glY:tournamentPositionProbabilities.142.5" 1 => b"O:1:"©":2:{s:6:"{DÕ\x05À\x1D";a:4:{i:4;d:0.3409704974001678;i:3;d:0.4159039446730124;i:2;d:0.16630295611634174;i:1;d:0.07682260181047809;}s:35:"tournamentPositionProbabilities.142";s:6:"JÁÄQmŽ";}"`] View formatted query View runnable query Explain query INSERT INTO cache_items ( item_id, item_data, item_lifetime, item_time ) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES (item_data), item_lifetime = VALUES (item_lifetime), item_time = VALUES (item_time) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('Kb6UtO0glY:tournamentPositionProbabilities.142.5', 0x4F3A313A22A9223A323A7B733A363A227B44D505C01D223B613A343A7B693A343B643A302E333430393730343937343030313637383B693A333B643A302E343135393033393434363733303132343B693A323B643A302E31363633303239353631313633343137343B693A313B643A302E30373638323236303138313034373830393B7D733A33353A22746F75726E616D656E74506F736974696F6E50726F626162696C69746965732E313432223B733A363A224AC1C4516D8E223B7D, 3600, 1746065906) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
52	0.45 ms	SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, g0_.duel_id AS duel_id_5, g0_.winner_id AS winner_id_6 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN abstract_tournament a2_ ON d1_.tournament_id = a2_.id LEFT JOIN tournament t3_ ON a2_.id = t3_.id LEFT JOIN tournament_decider t4_ ON a2_.id = t4_.id WHERE a2_.id = ? ORDER BY g0_.time DESC LIMIT 1 Parameters: [`142`] View formatted query View runnable query Explain query SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, g0_.duel_id AS duel_id_5, g0_.winner_id AS winner_id_6 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN abstract_tournament a2_ ON d1_.tournament_id = a2_.id LEFT JOIN tournament t3_ ON a2_.id = t3_.id LEFT JOIN tournament_decider t4_ ON a2_.id = t4_.id WHERE a2_.id = ? ORDER BY g0_.time DESC LIMIT 1 SELECT g0_.id AS id_0, g0_.time AS time_1, g0_.finished_with_foul AS finished_with_foul_2, g0_.final_ball_count AS final_ball_count_3, g0_.game_time_seconds AS game_time_seconds_4, g0_.duel_id AS duel_id_5, g0_.winner_id AS winner_id_6 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN abstract_tournament a2_ ON d1_.tournament_id = a2_.id LEFT JOIN tournament t3_ ON a2_.id = t3_.id LEFT JOIN tournament_decider t4_ ON a2_.id = t4_.id WHERE a2_.id = 142 ORDER BY g0_.time DESC LIMIT 1;
53	0.22 ms	SELECT t0.name AS name_1, t0.value AS value_2 FROM setting t0 WHERE t0.name = ? Parameters: [`"POOLNAMENT_LOGO"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.value AS value_2 FROM setting t0 WHERE t0.name = ? SELECT t0.name AS name_1, t0.value AS value_2 FROM setting t0 WHERE t0.name = 'POOLNAMENT_LOGO';
54	0.18 ms	SELECT t0.name AS name_1, t0.value AS value_2 FROM setting t0 WHERE t0.name = ? Parameters: [`"POOLNAMENT_LOGO_TEXT"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.value AS value_2 FROM setting t0 WHERE t0.name = ? SELECT t0.name AS name_1, t0.value AS value_2 FROM setting t0 WHERE t0.name = 'POOLNAMENT_LOGO_TEXT';
55	0.23 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`2 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 2 AND l0_.id = 3;
56	0.49 ms	SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ? Parameters: [`142 2`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ? SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (142) AND u4_.id = 2;
57	0.28 ms	SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?) Parameters: [`419 420 421`] View formatted query View runnable query Explain query SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?) SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (419, 420, 421);
58	0.17 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`3 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 3 AND l0_.id = 3;
59	0.26 ms	SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ? Parameters: [`142 3`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ? SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (142) AND u4_.id = 3;
60	0.43 ms	SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?) Parameters: [`419 422 423`] View formatted query View runnable query Explain query SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?) SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (419, 422, 423);
61	0.16 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`4 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 4 AND l0_.id = 3;
62	0.26 ms	SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ? Parameters: [`142 4`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ? SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (142) AND u4_.id = 4;
63	0.19 ms	SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?) Parameters: [`420 422 424`] View formatted query View runnable query Explain query SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?) SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (420, 422, 424);
64	0.17 ms	SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? Parameters: [`5 3`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = ? AND l0_.id = ? SELECT l0_.id AS id_0 FROM league l0_ INNER JOIN league_user l1_ ON l0_.id = l1_.league_id WHERE l1_.user_id = 5 AND l0_.id = 3;
65	0.47 ms	SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ? Parameters: [`142 5`] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (?) AND u4_.id = ? SELECT d0_.id AS id_0, d0_.games_played AS games_played_1, d0_.status AS status_2, d0_.tournament_id AS tournament_id_3, d0_.winner_id AS winner_id_4, d0_.tournament_player_absence_id AS tournament_player_absence_id_5 FROM duel d0_ INNER JOIN abstract_tournament a1_ ON d0_.tournament_id = a1_.id LEFT JOIN tournament t2_ ON a1_.id = t2_.id LEFT JOIN tournament_decider t3_ ON a1_.id = t3_.id INNER JOIN duel_user d5_ ON d0_.id = d5_.duel_id INNER JOIN `user` u4_ ON u4_.id = d5_.user_id WHERE a1_.id IN (142) AND u4_.id = 5;
66	0.22 ms	SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?) Parameters: [`421 423 424`] View formatted query View runnable query Explain query SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (?, ?, ?) SELECT SUM(g0_.game_time_seconds) AS sclr_0 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id WHERE d1_.id IN (421, 423, 424);
67	0.28 ms	SELECT t0.id AS id_1, t0.time AS time_2, t0.tournament_id AS tournament_id_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.email AS email_7, t5.user_role AS user_role_8, t5.password AS password_9, t5.time_last_login AS time_last_login_10, t5.enabled AS enabled_11, t5.first_name AS first_name_12, t5.last_name AS last_name_13, t5.image AS image_14, t5.original_image_name AS original_image_name_15, t5.reset_password_token AS reset_password_token_16, t5.elo AS elo_17, t5.games_played AS games_played_18, t5.reset_password_token_time_created AS reset_password_token_time_created_19, t5.reset_password_token_time_expires AS reset_password_token_time_expires_20, t5.time_password_last_changed AS time_password_last_changed_21, t5.last_game_played_time AS last_game_played_time_22 FROM tournament_player_absence t0 INNER JOIN `user` t5 ON t0.player_id = t5.id WHERE t0.tournament_id = ? Parameters: [`142`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.time AS time_2, t0.tournament_id AS tournament_id_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.email AS email_7, t5.user_role AS user_role_8, t5.password AS password_9, t5.time_last_login AS time_last_login_10, t5.enabled AS enabled_11, t5.first_name AS first_name_12, t5.last_name AS last_name_13, t5.image AS image_14, t5.original_image_name AS original_image_name_15, t5.reset_password_token AS reset_password_token_16, t5.elo AS elo_17, t5.games_played AS games_played_18, t5.reset_password_token_time_created AS reset_password_token_time_created_19, t5.reset_password_token_time_expires AS reset_password_token_time_expires_20, t5.time_password_last_changed AS time_password_last_changed_21, t5.last_game_played_time AS last_game_played_time_22 FROM tournament_player_absence t0 INNER JOIN `user` t5 ON t0.player_id = t5.id WHERE t0.tournament_id = ? SELECT t0.id AS id_1, t0.time AS time_2, t0.tournament_id AS tournament_id_3, t0.player_id AS player_id_4, t5.id AS id_6, t5.email AS email_7, t5.user_role AS user_role_8, t5.password AS password_9, t5.time_last_login AS time_last_login_10, t5.enabled AS enabled_11, t5.first_name AS first_name_12, t5.last_name AS last_name_13, t5.image AS image_14, t5.original_image_name AS original_image_name_15, t5.reset_password_token AS reset_password_token_16, t5.elo AS elo_17, t5.games_played AS games_played_18, t5.reset_password_token_time_created AS reset_password_token_time_created_19, t5.reset_password_token_time_expires AS reset_password_token_time_expires_20, t5.time_password_last_changed AS time_password_last_changed_21, t5.last_game_played_time AS last_game_played_time_22 FROM tournament_player_absence t0 INNER JOIN `user` t5 ON t0.player_id = t5.id WHERE t0.tournament_id = 142;

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\Duel	6
App\Entity\User	4
App\Entity\Setting	2
App\Entity\AbstractTournament	1
App\Entity\League	1
App\Entity\Location	1

Entities Mapping

Class	Mapping errors
App\Entity\AbstractTournament	No errors.
App\Entity\Tournament	No errors.
App\Entity\League	No errors.
App\Entity\Location	No errors.
App\Entity\User	No errors.
App\Entity\Duel	No errors.
App\Entity\LeagueUser	No errors.
App\Entity\TournamentDecider	No errors.
App\Entity\TournamentPlayerAbsence	No errors.
App\Entity\Game	No errors.
App\Entity\EloChangeLog	No errors.
App\Entity\Setting	No errors.

Symfony Profiler

GET https://www.poolnament.com/tournament/142/stats

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping