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

SELECT
  t0.id AS id_1,
  t0.place AS place_2,
  t0.games_won AS games_won_3,
  t0.games_lost AS games_lost_4,
  t0.games_lost_with_foul AS games_lost_with_foul_5,
  t0.games_won_with_deciders AS games_won_with_deciders_6,
  t0.games_lost_with_deciders AS games_lost_with_deciders_7,
  t0.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_8,
  t0.elo_change AS elo_change_9,
  t0.duels_won AS duels_won_10,
  t0.duels_lost AS duels_lost_11,
  t0.duels_won_with_deciders AS duels_won_with_deciders_12,
  t0.duels_lost_with_deciders AS duels_lost_with_deciders_13,
  t0.points AS points_14,
  t0.tournaments_won AS tournaments_won_15,
  t0.tournaments_lost AS tournaments_lost_16,
  t0.tournaments_played AS tournaments_played_17,
  t0.tournaments_won_with_deciders AS tournaments_won_with_deciders_18,
  t0.tournaments_lost_with_deciders AS tournaments_lost_with_deciders_19,
  t0.league_id AS league_id_20,
  t21.id AS id_22,
  t21.name AS name_23,
  t21.min_players_to_count_into_stats AS min_players_to_count_into_stats_24,
  t21.status AS status_25,
  t0.player_id AS player_id_26,
  t27.id AS id_28,
  t27.email AS email_29,
  t27.user_role AS user_role_30,
  t27.password AS password_31,
  t27.time_last_login AS time_last_login_32,
  t27.enabled AS enabled_33,
  t27.first_name AS first_name_34,
  t27.last_name AS last_name_35,
  t27.image AS image_36,
  t27.original_image_name AS original_image_name_37,
  t27.reset_password_token AS reset_password_token_38,
  t27.elo AS elo_39,
  t27.games_played AS games_played_40,
  t27.reset_password_token_time_created AS reset_password_token_time_created_41,
  t27.reset_password_token_time_expires AS reset_password_token_time_expires_42,
  t27.time_password_last_changed AS time_password_last_changed_43,
  t27.last_game_played_time AS last_game_played_time_44
FROM
  league_player_stats t0
  INNER JOIN league t21 ON t0.league_id = t21.id
  INNER JOIN `user` t27 ON t0.player_id = t27.id
WHERE
  t0.league_id = ?
ORDER BY
  t0.place ASC

SELECT t0.id AS id_1, t0.place AS place_2, t0.games_won AS games_won_3, t0.games_lost AS games_lost_4, t0.games_lost_with_foul AS games_lost_with_foul_5, t0.games_won_with_deciders AS games_won_with_deciders_6, t0.games_lost_with_deciders AS games_lost_with_deciders_7, t0.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_8, t0.elo_change AS elo_change_9, t0.duels_won AS duels_won_10, t0.duels_lost AS duels_lost_11, t0.duels_won_with_deciders AS duels_won_with_deciders_12, t0.duels_lost_with_deciders AS duels_lost_with_deciders_13, t0.points AS points_14, t0.tournaments_won AS tournaments_won_15, t0.tournaments_lost AS tournaments_lost_16, t0.tournaments_played AS tournaments_played_17, t0.tournaments_won_with_deciders AS tournaments_won_with_deciders_18, t0.tournaments_lost_with_deciders AS tournaments_lost_with_deciders_19, t0.league_id AS league_id_20, t21.id AS id_22, t21.name AS name_23, t21.min_players_to_count_into_stats AS min_players_to_count_into_stats_24, t21.status AS status_25, t0.player_id AS player_id_26, t27.id AS id_28, t27.email AS email_29, t27.user_role AS user_role_30, t27.password AS password_31, t27.time_last_login AS time_last_login_32, t27.enabled AS enabled_33, t27.first_name AS first_name_34, t27.last_name AS last_name_35, t27.image AS image_36, t27.original_image_name AS original_image_name_37, t27.reset_password_token AS reset_password_token_38, t27.elo AS elo_39, t27.games_played AS games_played_40, t27.reset_password_token_time_created AS reset_password_token_time_created_41, t27.reset_password_token_time_expires AS reset_password_token_time_expires_42, t27.time_password_last_changed AS time_password_last_changed_43, t27.last_game_played_time AS last_game_played_time_44 FROM league_player_stats t0 INNER JOIN league t21 ON t0.league_id = t21.id INNER JOIN `user` t27 ON t0.player_id = t27.id WHERE t0.league_id = 3 ORDER BY t0.place ASC;

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
  t0.league_id = ?
  AND t1.status IN (?, ?)
ORDER BY
  t1.time DESC

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 t0.league_id = 3 AND t1.status IN ('IN_PROGRESS', 'DECIDER_IN_PROGRESS') ORDER BY t1.time DESC;

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

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
  t0.league_id = ?
  AND t1.status = ?
ORDER BY
  t1.time DESC

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 t0.league_id = 3 AND t1.status = 'FINISHED' ORDER BY t1.time DESC;

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.min_players_to_count_into_stats AS min_players_to_count_into_stats_2,
  l0_.status AS status_3
FROM
  league l0_
WHERE
  l0_.status IN (?, ?)
ORDER BY
  l0_.id DESC

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.min_players_to_count_into_stats AS min_players_to_count_into_stats_2, l0_.status AS status_3 FROM league l0_ WHERE l0_.status IN ('IN_PROGRESS', 'FINISHED') ORDER BY l0_.id DESC;

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

SELECT
  t0_.count_for_league_stats AS count_for_league_stats_0,
  t0_.id AS id_1,
  t0_.place AS place_2,
  t0_.games_won AS games_won_3,
  t0_.games_lost AS games_lost_4,
  t0_.games_lost_with_foul AS games_lost_with_foul_5,
  t0_.games_won_with_deciders AS games_won_with_deciders_6,
  t0_.games_lost_with_deciders AS games_lost_with_deciders_7,
  t0_.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_8,
  t0_.elo_change AS elo_change_9,
  t0_.duels_won AS duels_won_10,
  t0_.duels_lost AS duels_lost_11,
  t0_.duels_won_with_deciders AS duels_won_with_deciders_12,
  t0_.duels_lost_with_deciders AS duels_lost_with_deciders_13,
  t0_.points AS points_14,
  t0_.tournament_id AS tournament_id_15,
  t0_.player_id AS player_id_16
FROM
  tournament_player_stats t0_
  INNER JOIN `user` u1_ ON t0_.player_id = u1_.id
  INNER JOIN abstract_tournament a2_ ON t0_.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 = ?
  AND t0_.place = ?
  AND a2_.status = ?
LIMIT
  1

SELECT t0_.count_for_league_stats AS count_for_league_stats_0, t0_.id AS id_1, t0_.place AS place_2, t0_.games_won AS games_won_3, t0_.games_lost AS games_lost_4, t0_.games_lost_with_foul AS games_lost_with_foul_5, t0_.games_won_with_deciders AS games_won_with_deciders_6, t0_.games_lost_with_deciders AS games_lost_with_deciders_7, t0_.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_8, t0_.elo_change AS elo_change_9, t0_.duels_won AS duels_won_10, t0_.duels_lost AS duels_lost_11, t0_.duels_won_with_deciders AS duels_won_with_deciders_12, t0_.duels_lost_with_deciders AS duels_lost_with_deciders_13, t0_.points AS points_14, t0_.tournament_id AS tournament_id_15, t0_.player_id AS player_id_16 FROM tournament_player_stats t0_ INNER JOIN `user` u1_ ON t0_.player_id = u1_.id INNER JOIN abstract_tournament a2_ ON t0_.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 = 140 AND t0_.place = 1 AND a2_.status = 'FINISHED' LIMIT 1;

SELECT
  t0_.count_for_league_stats AS count_for_league_stats_0,
  t0_.id AS id_1,
  t0_.place AS place_2,
  t0_.games_won AS games_won_3,
  t0_.games_lost AS games_lost_4,
  t0_.games_lost_with_foul AS games_lost_with_foul_5,
  t0_.games_won_with_deciders AS games_won_with_deciders_6,
  t0_.games_lost_with_deciders AS games_lost_with_deciders_7,
  t0_.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_8,
  t0_.elo_change AS elo_change_9,
  t0_.duels_won AS duels_won_10,
  t0_.duels_lost AS duels_lost_11,
  t0_.duels_won_with_deciders AS duels_won_with_deciders_12,
  t0_.duels_lost_with_deciders AS duels_lost_with_deciders_13,
  t0_.points AS points_14,
  t0_.tournament_id AS tournament_id_15,
  t0_.player_id AS player_id_16
FROM
  tournament_player_stats t0_
  INNER JOIN `user` u1_ ON t0_.player_id = u1_.id
  INNER JOIN abstract_tournament a2_ ON t0_.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 = ?
  AND t0_.place = ?
  AND a2_.status = ?
LIMIT
  1

SELECT t0_.count_for_league_stats AS count_for_league_stats_0, t0_.id AS id_1, t0_.place AS place_2, t0_.games_won AS games_won_3, t0_.games_lost AS games_lost_4, t0_.games_lost_with_foul AS games_lost_with_foul_5, t0_.games_won_with_deciders AS games_won_with_deciders_6, t0_.games_lost_with_deciders AS games_lost_with_deciders_7, t0_.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_8, t0_.elo_change AS elo_change_9, t0_.duels_won AS duels_won_10, t0_.duels_lost AS duels_lost_11, t0_.duels_won_with_deciders AS duels_won_with_deciders_12, t0_.duels_lost_with_deciders AS duels_lost_with_deciders_13, t0_.points AS points_14, t0_.tournament_id AS tournament_id_15, t0_.player_id AS player_id_16 FROM tournament_player_stats t0_ INNER JOIN `user` u1_ ON t0_.player_id = u1_.id INNER JOIN abstract_tournament a2_ ON t0_.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 = 139 AND t0_.place = 1 AND a2_.status = 'FINISHED' LIMIT 1;

SELECT
  t0_.count_for_league_stats AS count_for_league_stats_0,
  t0_.id AS id_1,
  t0_.place AS place_2,
  t0_.games_won AS games_won_3,
  t0_.games_lost AS games_lost_4,
  t0_.games_lost_with_foul AS games_lost_with_foul_5,
  t0_.games_won_with_deciders AS games_won_with_deciders_6,
  t0_.games_lost_with_deciders AS games_lost_with_deciders_7,
  t0_.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_8,
  t0_.elo_change AS elo_change_9,
  t0_.duels_won AS duels_won_10,
  t0_.duels_lost AS duels_lost_11,
  t0_.duels_won_with_deciders AS duels_won_with_deciders_12,
  t0_.duels_lost_with_deciders AS duels_lost_with_deciders_13,
  t0_.points AS points_14,
  t0_.tournament_id AS tournament_id_15,
  t0_.player_id AS player_id_16
FROM
  tournament_player_stats t0_
  INNER JOIN `user` u1_ ON t0_.player_id = u1_.id
  INNER JOIN abstract_tournament a2_ ON t0_.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 = ?
  AND t0_.place = ?
  AND a2_.status = ?
LIMIT
  1

SELECT t0_.count_for_league_stats AS count_for_league_stats_0, t0_.id AS id_1, t0_.place AS place_2, t0_.games_won AS games_won_3, t0_.games_lost AS games_lost_4, t0_.games_lost_with_foul AS games_lost_with_foul_5, t0_.games_won_with_deciders AS games_won_with_deciders_6, t0_.games_lost_with_deciders AS games_lost_with_deciders_7, t0_.games_lost_with_foul_with_deciders AS games_lost_with_foul_with_deciders_8, t0_.elo_change AS elo_change_9, t0_.duels_won AS duels_won_10, t0_.duels_lost AS duels_lost_11, t0_.duels_won_with_deciders AS duels_won_with_deciders_12, t0_.duels_lost_with_deciders AS duels_lost_with_deciders_13, t0_.points AS points_14, t0_.tournament_id AS tournament_id_15, t0_.player_id AS player_id_16 FROM tournament_player_stats t0_ INNER JOIN `user` u1_ ON t0_.player_id = u1_.id INNER JOIN abstract_tournament a2_ ON t0_.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 = 137 AND t0_.place = 1 AND a2_.status = 'FINISHED' LIMIT 1;