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

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 = 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,
  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
  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 (?)
  AND g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  g0_.time DESC

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 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 (33) AND g0_.id IN (239, 238, 237, 236, 235, 234, 233, 232, 231, 230, 229, 228, 227) ORDER BY g0_.time DESC;

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

SELECT
  t0.count_for_league_stats AS count_for_league_stats_1,
  t0.id AS id_2,
  t0.place AS place_3,
  t0.games_won AS games_won_4,
  t0.games_lost AS games_lost_5,
  t0.games_lost_with_foul AS games_lost_with_foul_6,
  t0.games_won_with_deciders AS games_won_with_deciders_7,
  t0.games_lost_with_deciders AS games_lost_with_deciders_8,
  t0.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_9,
  t0.elo_change AS elo_change_10,
  t0.duels_won AS duels_won_11,
  t0.duels_lost AS duels_lost_12,
  t0.duels_won_with_deciders AS duels_won_with_deciders_13,
  t0.duels_lost_with_deciders AS duels_lost_with_deciders_14,
  t0.points AS points_15,
  t0.tournament_id AS tournament_id_16,
  t0.player_id AS player_id_17,
  t18.id AS id_19,
  t18.email AS email_20,
  t18.user_role AS user_role_21,
  t18.password AS password_22,
  t18.time_last_login AS time_last_login_23,
  t18.enabled AS enabled_24,
  t18.first_name AS first_name_25,
  t18.last_name AS last_name_26,
  t18.image AS image_27,
  t18.original_image_name AS original_image_name_28,
  t18.reset_password_token AS reset_password_token_29,
  t18.elo AS elo_30,
  t18.games_played AS games_played_31,
  t18.reset_password_token_time_created AS reset_password_token_time_created_32,
  t18.reset_password_token_time_expires AS reset_password_token_time_expires_33,
  t18.time_password_last_changed AS time_password_last_changed_34,
  t18.last_game_played_time AS last_game_played_time_35
FROM
  tournament_player_stats t0
  INNER JOIN `user` t18 ON t0.player_id = t18.id
WHERE
  t0.tournament_id = ?
ORDER BY
  t0.place ASC

SELECT t0.count_for_league_stats AS count_for_league_stats_1, t0.id AS id_2, t0.place AS place_3, t0.games_won AS games_won_4, t0.games_lost AS games_lost_5, t0.games_lost_with_foul AS games_lost_with_foul_6, t0.games_won_with_deciders AS games_won_with_deciders_7, t0.games_lost_with_deciders AS games_lost_with_deciders_8, t0.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_9, t0.elo_change AS elo_change_10, t0.duels_won AS duels_won_11, t0.duels_lost AS duels_lost_12, t0.duels_won_with_deciders AS duels_won_with_deciders_13, t0.duels_lost_with_deciders AS duels_lost_with_deciders_14, t0.points AS points_15, t0.tournament_id AS tournament_id_16, t0.player_id AS player_id_17, t18.id AS id_19, t18.email AS email_20, t18.user_role AS user_role_21, t18.password AS password_22, t18.time_last_login AS time_last_login_23, t18.enabled AS enabled_24, t18.first_name AS first_name_25, t18.last_name AS last_name_26, t18.image AS image_27, t18.original_image_name AS original_image_name_28, t18.reset_password_token AS reset_password_token_29, t18.elo AS elo_30, t18.games_played AS games_played_31, t18.reset_password_token_time_created AS reset_password_token_time_created_32, t18.reset_password_token_time_expires AS reset_password_token_time_expires_33, t18.time_password_last_changed AS time_password_last_changed_34, t18.last_game_played_time AS last_game_played_time_35 FROM tournament_player_stats t0 INNER JOIN `user` t18 ON t0.player_id = t18.id WHERE t0.tournament_id = 33 ORDER BY t0.place ASC;

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 (33);

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 (33) ORDER BY g0_.time DESC LIMIT 25;

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

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

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.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 = 33;

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

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