Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.search_name AS search_name_2,
  t0.subname AS subname_3,
  t0.category AS category_4,
  t0.gender AS gender_5,
  t0.crest_url AS crest_url_6,
  t0.name AS name_7,
  t0.normalized_name AS normalized_name_8,
  t0.clubee_id AS clubee_id_9,
  t0.club_id AS club_id_10
FROM
  "team" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = 544;

SELECT
  t0.id AS id_1,
  t0.clubee_id AS clubee_id_2,
  t0.name AS name_3
FROM
  "season" t0
WHERE
  t0.name = ?
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.name = '2026/2027' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.search_name AS search_name_1,
  c0_.gender AS gender_2,
  c0_.region AS region_3,
  c0_.category AS category_4,
  c0_.type AS type_5,
  c0_.active AS active_6,
  c0_.scanned_at AS scanned_at_7,
  c0_.name AS name_8,
  c0_.clubee_id AS clubee_id_9,
  COUNT(g1_.id) AS sclr_10,
  CASE WHEN c0_.season_id = ? THEN
    0
  ELSE
    1
  END AS sclr_11,
  c0_.season_id AS season_id_12
FROM
  "competition" c0_
  INNER JOIN "game" g1_ ON c0_.id = g1_.competition_id
WHERE
  g1_.home_team_id = ?
  OR g1_.away_team_id = ?
GROUP BY
  c0_.id
ORDER BY
  sclr_11 ASC,
  sclr_10 DESC
LIMIT
  1

SELECT c0_.id AS id_0, c0_.search_name AS search_name_1, c0_.gender AS gender_2, c0_.region AS region_3, c0_.category AS category_4, c0_.type AS type_5, c0_.active AS active_6, c0_.scanned_at AS scanned_at_7, c0_.name AS name_8, c0_.clubee_id AS clubee_id_9, COUNT(g1_.id) AS sclr_10, CASE WHEN c0_.season_id = 1 THEN 0 ELSE 1 END AS sclr_11, c0_.season_id AS season_id_12 FROM "competition" c0_ INNER JOIN "game" g1_ ON c0_.id = g1_.competition_id WHERE g1_.home_team_id = 544 OR g1_.away_team_id = 544 GROUP BY c0_.id ORDER BY sclr_11 ASC, sclr_10 DESC LIMIT 1;

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_.home_team_id = ?
    OR g0_.away_team_id = ?
  )
  AND g0_.starts_at >= ?
  AND g0_.cancelled = false
ORDER BY
  g0_.starts_at ASC
LIMIT
  1

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_.home_team_id = 544 OR g0_.away_team_id = 544) AND g0_.starts_at >= '2026-08-29 00:00:00' AND g0_.cancelled = false ORDER BY g0_.starts_at ASC LIMIT 1;

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_.home_team_id = ?
    OR g0_.away_team_id = ?
  )
  AND g0_.home_score IS NOT NULL
  AND g0_.away_score IS NOT NULL
ORDER BY
  g0_.starts_at DESC
LIMIT
  1

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_.home_team_id = 544 OR g0_.away_team_id = 544) AND g0_.home_score IS NOT NULL AND g0_.away_score IS NOT NULL ORDER BY g0_.starts_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_
  INNER JOIN "ranking_entry" r1_ ON r0_.id = r1_.snapshot_id
  INNER JOIN "competition" c2_ ON r0_.competition_id = c2_.id
WHERE
  r1_.team_id = ?
  AND c2_.clubee_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_ INNER JOIN "ranking_entry" r1_ ON r0_.id = r1_.snapshot_id INNER JOIN "competition" c2_ ON r0_.competition_id = c2_.id WHERE r1_.team_id = 544 AND c2_.clubee_id = 10823 ORDER BY r0_.captured_at DESC LIMIT 1;

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_.home_team_id = ?
  OR g0_.away_team_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_.home_team_id = 544 OR g0_.away_team_id = 544 ORDER BY g0_.starts_at ASC;

SELECT
  t0.id AS id_1,
  t0.search_name AS search_name_2,
  t0.clubee_id AS clubee_id_3,
  t0.name AS name_4,
  t0.normalized_name AS normalized_name_5,
  t0.region AS region_6,
  t0.website AS website_7,
  t0.placeholder AS placeholder_8,
  t0.address_name AS address_name_9,
  t0.address_street AS address_street_10,
  t0.address_city AS address_city_11,
  t0.address_zip AS address_zip_12,
  t0.address_country AS address_country_13,
  t0.address_latitude AS address_latitude_14,
  t0.address_longitude AS address_longitude_15
FROM
  "club" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.clubee_id AS clubee_id_3, t0.name AS name_4, t0.normalized_name AS normalized_name_5, t0.region AS region_6, t0.website AS website_7, t0.placeholder AS placeholder_8, t0.address_name AS address_name_9, t0.address_street AS address_street_10, t0.address_city AS address_city_11, t0.address_zip AS address_zip_12, t0.address_country AS address_country_13, t0.address_latitude AS address_latitude_14, t0.address_longitude AS address_longitude_15 FROM "club" t0 WHERE t0.id = 66;

SELECT
  t0.id AS id_1,
  t0.won AS won_2,
  t0.lost AS lost_3,
  t0.sets_won AS sets_won_4,
  t0.sets_lost AS sets_lost_5,
  t0.points_for AS points_for_6,
  t0.points_against AS points_against_7,
  t0.position AS position_8,
  t0.played AS played_9,
  t0.points AS points_10,
  t0.snapshot_id AS snapshot_id_11,
  t0.team_id AS team_id_12
FROM
  "ranking_entry" t0
WHERE
  t0.snapshot_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.won AS won_2, t0.lost AS lost_3, t0.sets_won AS sets_won_4, t0.sets_lost AS sets_lost_5, t0.points_for AS points_for_6, t0.points_against AS points_against_7, t0.position AS position_8, t0.played AS played_9, t0.points AS points_10, t0.snapshot_id AS snapshot_id_11, t0.team_id AS team_id_12 FROM "ranking_entry" t0 WHERE t0.snapshot_id = 85 ORDER BY t0.position ASC;