Symfony Profiler

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;

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;

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;

SELECT
  t0.is_league_manager AS is_league_manager_1,
  t0.league_id AS league_id_2,
  t0.user_id AS user_id_3
FROM
  league_user t0
WHERE
  t0.user_id = ?

SELECT t0.is_league_manager AS is_league_manager_1, t0.league_id AS league_id_2, t0.user_id AS user_id_3 FROM league_user t0 WHERE t0.user_id = 3;

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;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.user_role AS user_role_2,
  u0_.password AS password_3,
  u0_.time_last_login AS time_last_login_4,
  u0_.enabled AS enabled_5,
  u0_.first_name AS first_name_6,
  u0_.last_name AS last_name_7,
  u0_.image AS image_8,
  u0_.original_image_name AS original_image_name_9,
  u0_.reset_password_token AS reset_password_token_10,
  u0_.elo AS elo_11,
  u0_.games_played AS games_played_12,
  u0_.reset_password_token_time_created AS reset_password_token_time_created_13,
  u0_.reset_password_token_time_expires AS reset_password_token_time_expires_14,
  u0_.time_password_last_changed AS time_password_last_changed_15,
  u0_.last_game_played_time AS last_game_played_time_16
FROM
  `user` u0_
  INNER JOIN league_user l1_ ON u0_.id = l1_.user_id
  INNER JOIN league l2_ ON l1_.league_id = l2_.id
WHERE
  u0_.games_played >= ?
  AND l2_.status = ?
  AND u0_.enabled = ?
ORDER BY
  u0_.elo DESC
LIMIT
  5

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.user_role AS user_role_2, u0_.password AS password_3, u0_.time_last_login AS time_last_login_4, u0_.enabled AS enabled_5, u0_.first_name AS first_name_6, u0_.last_name AS last_name_7, u0_.image AS image_8, u0_.original_image_name AS original_image_name_9, u0_.reset_password_token AS reset_password_token_10, u0_.elo AS elo_11, u0_.games_played AS games_played_12, u0_.reset_password_token_time_created AS reset_password_token_time_created_13, u0_.reset_password_token_time_expires AS reset_password_token_time_expires_14, u0_.time_password_last_changed AS time_password_last_changed_15, u0_.last_game_played_time AS last_game_played_time_16 FROM `user` u0_ INNER JOIN league_user l1_ ON u0_.id = l1_.user_id INNER JOIN league l2_ ON l1_.league_id = l2_.id WHERE u0_.games_played >= 20 AND l2_.status = 'IN_PROGRESS' AND u0_.enabled = 1 ORDER BY u0_.elo DESC LIMIT 5;

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.status IN (?, ?)

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.status IN ('IN_PROGRESS', 'DECIDER_IN_PROGRESS');

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  location t0
WHERE
  t0.id IN (?, ?)

SELECT t0.id AS id_1, t0.name AS name_2 FROM location t0 WHERE t0.id IN (1, 9);

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;

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';

SELECT
  l0_.id AS id_0,
  l0_.place AS place_1,
  l0_.games_won AS games_won_2,
  l0_.games_lost AS games_lost_3,
  l0_.games_lost_with_foul AS games_lost_with_foul_4,
  l0_.games_won_with_deciders AS games_won_with_deciders_5,
  l0_.games_lost_with_deciders AS games_lost_with_deciders_6,
  l0_.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_7,
  l0_.elo_change AS elo_change_8,
  l0_.duels_won AS duels_won_9,
  l0_.duels_lost AS duels_lost_10,
  l0_.duels_won_with_deciders AS duels_won_with_deciders_11,
  l0_.duels_lost_with_deciders AS duels_lost_with_deciders_12,
  l0_.points AS points_13,
  l0_.tournaments_won AS tournaments_won_14,
  l0_.tournaments_lost AS tournaments_lost_15,
  l0_.tournaments_played AS tournaments_played_16,
  l0_.tournaments_won_with_deciders AS tournaments_won_with_deciders_17,
  l0_.tournaments_lost_with_deciders AS tournaments_lost_with_deciders_18,
  l0_.league_id AS league_id_19,
  l0_.player_id AS player_id_20
FROM
  league_player_stats l0_
  INNER JOIN league l1_ ON l0_.league_id = l1_.id
WHERE
  l1_.status = ?
ORDER BY
  l0_.place ASC

SELECT l0_.id AS id_0, l0_.place AS place_1, l0_.games_won AS games_won_2, l0_.games_lost AS games_lost_3, l0_.games_lost_with_foul AS games_lost_with_foul_4, l0_.games_won_with_deciders AS games_won_with_deciders_5, l0_.games_lost_with_deciders AS games_lost_with_deciders_6, l0_.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_7, l0_.elo_change AS elo_change_8, l0_.duels_won AS duels_won_9, l0_.duels_lost AS duels_lost_10, l0_.duels_won_with_deciders AS duels_won_with_deciders_11, l0_.duels_lost_with_deciders AS duels_lost_with_deciders_12, l0_.points AS points_13, l0_.tournaments_won AS tournaments_won_14, l0_.tournaments_lost AS tournaments_lost_15, l0_.tournaments_played AS tournaments_played_16, l0_.tournaments_won_with_deciders AS tournaments_won_with_deciders_17, l0_.tournaments_lost_with_deciders AS tournaments_lost_with_deciders_18, l0_.league_id AS league_id_19, l0_.player_id AS player_id_20 FROM league_player_stats l0_ INNER JOIN league l1_ ON l0_.league_id = l1_.id WHERE l1_.status = 'IN_PROGRESS' ORDER BY l0_.place ASC;

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 = 1;

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 IN (?)

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 IN (3);