Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.search_name AS search_name_2,
  t0.gender AS gender_3,
  t0.region AS region_4,
  t0.category AS category_5,
  t0.type AS type_6,
  t0.active AS active_7,
  t0.scanned_at AS scanned_at_8,
  t0.name AS name_9,
  t0.clubee_id AS clubee_id_10,
  t0.season_id AS season_id_11
FROM
  "competition" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.gender AS gender_3, t0.region AS region_4, t0.category AS category_5, t0.type AS type_6, t0.active AS active_7, t0.scanned_at AS scanned_at_8, t0.name AS name_9, t0.clubee_id AS clubee_id_10, t0.season_id AS season_id_11 FROM "competition" t0 WHERE t0.id = 246;

SELECT
  g0_.id AS id_0,
  g0_.home_score AS home_score_1,
  g0_.away_score AS away_score_2,
  g0_.cancelled AS cancelled_3,
  g0_.forfeit AS forfeit_4,
  g0_.completed AS completed_5,
  g0_.phase_clubee_id AS phase_clubee_id_6,
  g0_.phase_name AS phase_name_7,
  g0_.updated_at AS updated_at_8,
  g0_.result_recorded_at AS result_recorded_at_9,
  g0_.detail_fetched_at AS detail_fetched_at_10,
  g0_.clubee_id AS clubee_id_11,
  g0_.starts_at AS starts_at_12,
  g0_.venue_name AS venue_name_13,
  g0_.venue_street AS venue_street_14,
  g0_.venue_city AS venue_city_15,
  g0_.venue_zip AS venue_zip_16,
  g0_.venue_country AS venue_country_17,
  g0_.venue_latitude AS venue_latitude_18,
  g0_.venue_longitude AS venue_longitude_19,
  t1_.id AS id_20,
  t1_.search_name AS search_name_21,
  t1_.subname AS subname_22,
  t1_.category AS category_23,
  t1_.gender AS gender_24,
  t1_.crest_url AS crest_url_25,
  t1_.name AS name_26,
  t1_.normalized_name AS normalized_name_27,
  t1_.clubee_id AS clubee_id_28,
  t2_.id AS id_29,
  t2_.search_name AS search_name_30,
  t2_.subname AS subname_31,
  t2_.category AS category_32,
  t2_.gender AS gender_33,
  t2_.crest_url AS crest_url_34,
  t2_.name AS name_35,
  t2_.normalized_name AS normalized_name_36,
  t2_.clubee_id AS clubee_id_37,
  c3_.id AS id_38,
  c3_.search_name AS search_name_39,
  c3_.gender AS gender_40,
  c3_.region AS region_41,
  c3_.category AS category_42,
  c3_.type AS type_43,
  c3_.active AS active_44,
  c3_.scanned_at AS scanned_at_45,
  c3_.name AS name_46,
  c3_.clubee_id AS clubee_id_47,
  g0_.home_team_id AS home_team_id_48,
  g0_.away_team_id AS away_team_id_49,
  g0_.competition_id AS competition_id_50,
  g0_.season_id AS season_id_51,
  t1_.club_id AS club_id_52,
  t2_.club_id AS club_id_53,
  c3_.season_id AS season_id_54
FROM
  "game" g0_
  INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id
  INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id
  INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id
WHERE
  g0_.competition_id = ?
ORDER BY
  g0_.starts_at ASC

SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.cancelled AS cancelled_3, g0_.forfeit AS forfeit_4, g0_.completed AS completed_5, g0_.phase_clubee_id AS phase_clubee_id_6, g0_.phase_name AS phase_name_7, g0_.updated_at AS updated_at_8, g0_.result_recorded_at AS result_recorded_at_9, g0_.detail_fetched_at AS detail_fetched_at_10, g0_.clubee_id AS clubee_id_11, g0_.starts_at AS starts_at_12, g0_.venue_name AS venue_name_13, g0_.venue_street AS venue_street_14, g0_.venue_city AS venue_city_15, g0_.venue_zip AS venue_zip_16, g0_.venue_country AS venue_country_17, g0_.venue_latitude AS venue_latitude_18, g0_.venue_longitude AS venue_longitude_19, t1_.id AS id_20, t1_.search_name AS search_name_21, t1_.subname AS subname_22, t1_.category AS category_23, t1_.gender AS gender_24, t1_.crest_url AS crest_url_25, t1_.name AS name_26, t1_.normalized_name AS normalized_name_27, t1_.clubee_id AS clubee_id_28, t2_.id AS id_29, t2_.search_name AS search_name_30, t2_.subname AS subname_31, t2_.category AS category_32, t2_.gender AS gender_33, t2_.crest_url AS crest_url_34, t2_.name AS name_35, t2_.normalized_name AS normalized_name_36, t2_.clubee_id AS clubee_id_37, c3_.id AS id_38, c3_.search_name AS search_name_39, c3_.gender AS gender_40, c3_.region AS region_41, c3_.category AS category_42, c3_.type AS type_43, c3_.active AS active_44, c3_.scanned_at AS scanned_at_45, c3_.name AS name_46, c3_.clubee_id AS clubee_id_47, g0_.home_team_id AS home_team_id_48, g0_.away_team_id AS away_team_id_49, g0_.competition_id AS competition_id_50, g0_.season_id AS season_id_51, t1_.club_id AS club_id_52, t2_.club_id AS club_id_53, c3_.season_id AS season_id_54 FROM "game" g0_ INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id WHERE g0_.competition_id = 246 ORDER BY g0_.starts_at ASC;

SELECT
  r0_.id AS id_0,
  r0_.captured_at AS captured_at_1,
  r0_.hash AS hash_2,
  r0_.competition_id AS competition_id_3
FROM
  "ranking_snapshot" r0_
WHERE
  r0_.competition_id = ?
ORDER BY
  r0_.captured_at DESC
LIMIT
  1

SELECT r0_.id AS id_0, r0_.captured_at AS captured_at_1, r0_.hash AS hash_2, r0_.competition_id AS competition_id_3 FROM "ranking_snapshot" r0_ WHERE r0_.competition_id = 246 ORDER BY r0_.captured_at DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.clubee_id AS clubee_id_2,
  t0.name AS name_3
FROM
  "season" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.clubee_id AS clubee_id_2, t0.name AS name_3 FROM "season" t0 WHERE t0.id = 1;