Symfony Profiler

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 = 143 AND t0_.place = 1 AND a2_.status = 'FINISHED' LIMIT 1;

SELECT
  a0_.id AS id_0,
  a0_.winning_games AS winning_games_1,
  a0_.time AS time_2,
  a0_.status AS status_3,
  t1_.pool_table_type AS pool_table_type_4,
  t1_.approved AS approved_5,
  t1_.counts_for_league_stats AS counts_for_league_stats_6,
  t1_.track_game_times AS track_game_times_7,
  t1_.track_final_ball_count AS track_final_ball_count_8,
  t1_.track_finished_with_foul AS track_finished_with_foul_9,
  t1_.single_game_tournament AS single_game_tournament_10,
  a0_.type AS type_11,
  t1_.league_id AS league_id_12,
  t1_.location_id AS location_id_13
FROM
  tournament t1_
  INNER JOIN abstract_tournament a0_ ON t1_.id = a0_.id
  LEFT JOIN league l2_ ON t1_.league_id = l2_.id
  LEFT JOIN location l3_ ON t1_.location_id = l3_.id
  LEFT JOIN abstract_tournament_user a5_ ON a0_.id = a5_.abstract_tournament_id
  LEFT JOIN `user` u4_ ON u4_.id = a5_.user_id
WHERE
  t1_.single_game_tournament = ?
  AND a0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.winning_games AS winning_games_1, a0_.time AS time_2, a0_.status AS status_3, t1_.pool_table_type AS pool_table_type_4, t1_.approved AS approved_5, t1_.counts_for_league_stats AS counts_for_league_stats_6, t1_.track_game_times AS track_game_times_7, t1_.track_final_ball_count AS track_final_ball_count_8, t1_.track_finished_with_foul AS track_finished_with_foul_9, t1_.single_game_tournament AS single_game_tournament_10, a0_.type AS type_11, t1_.league_id AS league_id_12, t1_.location_id AS location_id_13 FROM tournament t1_ INNER JOIN abstract_tournament a0_ ON t1_.id = a0_.id LEFT JOIN league l2_ ON t1_.league_id = l2_.id LEFT JOIN location l3_ ON t1_.location_id = l3_.id LEFT JOIN abstract_tournament_user a5_ ON a0_.id = a5_.abstract_tournament_id LEFT JOIN `user` u4_ ON u4_.id = a5_.user_id WHERE t1_.single_game_tournament = 0 AND a0_.id IN (143, 142, 140, 139, 137, 136, 135, 134, 132, 131, 130, 128, 124, 123, 60, 59, 57, 56, 50, 48, 47, 46, 41, 40, 39) ORDER BY a0_.id DESC;

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  tournament t1_
  INNER JOIN abstract_tournament a0_ ON t1_.id = a0_.id
  LEFT JOIN league l2_ ON t1_.league_id = l2_.id
  LEFT JOIN location l3_ ON t1_.location_id = l3_.id
  LEFT JOIN abstract_tournament_user a5_ ON a0_.id = a5_.abstract_tournament_id
  LEFT JOIN `user` u4_ ON u4_.id = a5_.user_id
WHERE
  t1_.single_game_tournament = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM tournament t1_ INNER JOIN abstract_tournament a0_ ON t1_.id = a0_.id LEFT JOIN league l2_ ON t1_.league_id = l2_.id LEFT JOIN location l3_ ON t1_.location_id = l3_.id LEFT JOIN abstract_tournament_user a5_ ON a0_.id = a5_.abstract_tournament_id LEFT JOIN `user` u4_ ON u4_.id = a5_.user_id WHERE t1_.single_game_tournament = 0;

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.id AS id_1
FROM
  tournament t1_
  INNER JOIN abstract_tournament a0_ ON t1_.id = a0_.id
  LEFT JOIN league l2_ ON t1_.league_id = l2_.id
  LEFT JOIN location l3_ ON t1_.location_id = l3_.id
  LEFT JOIN abstract_tournament_user a5_ ON a0_.id = a5_.abstract_tournament_id
  LEFT JOIN `user` u4_ ON u4_.id = a5_.user_id
WHERE
  t1_.single_game_tournament = ?
ORDER BY
  a0_.id DESC
LIMIT
  25

SELECT DISTINCT a0_.id AS id_0, a0_.id AS id_1 FROM tournament t1_ INNER JOIN abstract_tournament a0_ ON t1_.id = a0_.id LEFT JOIN league l2_ ON t1_.league_id = l2_.id LEFT JOIN location l3_ ON t1_.location_id = l3_.id LEFT JOIN abstract_tournament_user a5_ ON a0_.id = a5_.abstract_tournament_id LEFT JOIN `user` u4_ ON u4_.id = a5_.user_id WHERE t1_.single_game_tournament = 0 ORDER BY a0_.id 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
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 IN (?, ?, ?, ?, ?, ?)

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

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, 2, 1);