Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Emails
• Serializer
• Configuration

Query Metrics

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
  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 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 l2_.status = ? AND u0_.enabled = ? AND u0_.id IN (?, ?, ?, ?) ORDER BY u0_.elo DESC

[
  "IN_PROGRESS"
  1
  3
  4
  5
  2
]

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
  l2_.status = ?
  AND u0_.enabled = ?
  AND u0_.id IN (?, ?, ?, ?)
ORDER BY
  u0_.elo DESC

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 l2_.status = 'IN_PROGRESS' AND u0_.enabled = 1 AND u0_.id IN (3, 4, 5, 2) ORDER BY u0_.elo DESC;

SELECT count(DISTINCT u0_.id) AS sclr_0 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 l2_.status = ? AND u0_.enabled = ?

[
  "IN_PROGRESS"
  1
]

SELECT
  count(DISTINCT u0_.id) AS sclr_0
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
  l2_.status = ?
  AND u0_.enabled = ?

SELECT count(DISTINCT u0_.id) AS sclr_0 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 l2_.status = 'IN_PROGRESS' AND u0_.enabled = 1;

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

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 = ?

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 DISTINCT u0_.id AS id_0, u0_.elo AS elo_1 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 l2_.status = ? AND u0_.enabled = ? ORDER BY u0_.elo DESC LIMIT 25

[
  "IN_PROGRESS"
  1
]

SELECT
  DISTINCT u0_.id AS id_0,
  u0_.elo AS elo_1
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
  l2_.status = ?
  AND u0_.enabled = ?
ORDER BY
  u0_.elo DESC
LIMIT
  25

SELECT DISTINCT u0_.id AS id_0, u0_.elo AS elo_1 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 l2_.status = 'IN_PROGRESS' AND u0_.enabled = 1 ORDER BY u0_.elo DESC LIMIT 25;