Symfony Profiler

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

SELECT
  DISTINCT g0_.id AS id_0,
  g0_.game_time_seconds AS game_time_seconds_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
ORDER BY
  g0_.game_time_seconds ASC
LIMIT
  25
OFFSET
  625

SELECT DISTINCT g0_.id AS id_0, g0_.game_time_seconds AS game_time_seconds_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 ORDER BY g0_.game_time_seconds ASC LIMIT 25 OFFSET 625;

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

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;

SELECT
  t0.id AS id_3,
  t0.winning_games AS winning_games_4,
  t0.time AS time_5,
  t0.status AS status_6,
  t0.type,
  t1.pool_table_type AS pool_table_type_7,
  t1.approved AS approved_8,
  t1.counts_for_league_stats AS counts_for_league_stats_9,
  t1.track_game_times AS track_game_times_10,
  t1.track_final_ball_count AS track_final_ball_count_11,
  t1.track_finished_with_foul AS track_finished_with_foul_12,
  t1.single_game_tournament AS single_game_tournament_13,
  t1.league_id AS league_id_14,
  t1.location_id AS location_id_15,
  t2.parent_tournament_id AS parent_tournament_id_16
FROM
  abstract_tournament t0
  LEFT JOIN tournament t1 ON t0.id = t1.id
  LEFT JOIN tournament_decider t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.winning_games AS winning_games_4, t0.time AS time_5, t0.status AS status_6, t0.type, t1.pool_table_type AS pool_table_type_7, t1.approved AS approved_8, t1.counts_for_league_stats AS counts_for_league_stats_9, t1.track_game_times AS track_game_times_10, t1.track_final_ball_count AS track_final_ball_count_11, t1.track_finished_with_foul AS track_finished_with_foul_12, t1.single_game_tournament AS single_game_tournament_13, t1.league_id AS league_id_14, t1.location_id AS location_id_15, t2.parent_tournament_id AS parent_tournament_id_16 FROM abstract_tournament t0 LEFT JOIN tournament t1 ON t0.id = t1.id LEFT JOIN tournament_decider t2 ON t0.id = t2.id WHERE t0.id = 132;

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,
  d1_.id AS id_5,
  d1_.games_played AS games_played_6,
  d1_.status AS status_7,
  u2_.id AS id_8,
  u2_.email AS email_9,
  u2_.user_role AS user_role_10,
  u2_.password AS password_11,
  u2_.time_last_login AS time_last_login_12,
  u2_.enabled AS enabled_13,
  u2_.first_name AS first_name_14,
  u2_.last_name AS last_name_15,
  u2_.image AS image_16,
  u2_.original_image_name AS original_image_name_17,
  u2_.reset_password_token AS reset_password_token_18,
  u2_.elo AS elo_19,
  u2_.games_played AS games_played_20,
  u2_.reset_password_token_time_created AS reset_password_token_time_created_21,
  u2_.reset_password_token_time_expires AS reset_password_token_time_expires_22,
  u2_.time_password_last_changed AS time_password_last_changed_23,
  u2_.last_game_played_time AS last_game_played_time_24,
  e3_.id AS id_25,
  e3_.time AS time_26,
  e3_.old_elo AS old_elo_27,
  e3_.new_elo AS new_elo_28,
  g0_.duel_id AS duel_id_29,
  g0_.winner_id AS winner_id_30,
  d1_.tournament_id AS tournament_id_31,
  d1_.winner_id AS winner_id_32,
  d1_.tournament_player_absence_id AS tournament_player_absence_id_33,
  e3_.player_id AS player_id_34,
  e3_.game_id AS game_id_35
FROM
  game g0_
  INNER JOIN duel d1_ ON g0_.duel_id = d1_.id
  INNER JOIN duel_user d4_ ON d1_.id = d4_.duel_id
  INNER JOIN `user` u2_ ON u2_.id = d4_.user_id
  LEFT JOIN elo_change_log e3_ ON g0_.id = e3_.game_id
WHERE
  g0_.id IN (?, ?, ?, ?, ?, ?, ?)
ORDER BY
  g0_.game_time_seconds ASC

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, d1_.id AS id_5, d1_.games_played AS games_played_6, d1_.status AS status_7, u2_.id AS id_8, u2_.email AS email_9, u2_.user_role AS user_role_10, u2_.password AS password_11, u2_.time_last_login AS time_last_login_12, u2_.enabled AS enabled_13, u2_.first_name AS first_name_14, u2_.last_name AS last_name_15, u2_.image AS image_16, u2_.original_image_name AS original_image_name_17, u2_.reset_password_token AS reset_password_token_18, u2_.elo AS elo_19, u2_.games_played AS games_played_20, u2_.reset_password_token_time_created AS reset_password_token_time_created_21, u2_.reset_password_token_time_expires AS reset_password_token_time_expires_22, u2_.time_password_last_changed AS time_password_last_changed_23, u2_.last_game_played_time AS last_game_played_time_24, e3_.id AS id_25, e3_.time AS time_26, e3_.old_elo AS old_elo_27, e3_.new_elo AS new_elo_28, g0_.duel_id AS duel_id_29, g0_.winner_id AS winner_id_30, d1_.tournament_id AS tournament_id_31, d1_.winner_id AS winner_id_32, d1_.tournament_player_absence_id AS tournament_player_absence_id_33, e3_.player_id AS player_id_34, e3_.game_id AS game_id_35 FROM game g0_ INNER JOIN duel d1_ ON g0_.duel_id = d1_.id INNER JOIN duel_user d4_ ON d1_.id = d4_.duel_id INNER JOIN `user` u2_ ON u2_.id = d4_.user_id LEFT JOIN elo_change_log e3_ ON g0_.id = e3_.game_id WHERE g0_.id IN (552, 564, 339, 348, 557, 482, 630) ORDER BY g0_.game_time_seconds ASC;

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
WHERE
  t0.id IN (?)

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 WHERE t0.id IN (4);

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

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