Symfony Profiler

SELECT
  t0_.id AS id_0,
  c1_.name AS name_1,
  COUNT(g2_.id) AS sclr_2
FROM
  "team" t0_
  INNER JOIN "game" g2_ ON (
    g2_.home_team_id = t0_.id
    OR g2_.away_team_id = t0_.id
  )
  INNER JOIN "competition" c1_ ON g2_.competition_id = c1_.id
WHERE
  t0_.id IN (?, ?, ?, ?, ?, ?)
GROUP BY
  t0_.id,
  c1_.id
ORDER BY
  sclr_2 DESC

SELECT t0_.id AS id_0, c1_.name AS name_1, COUNT(g2_.id) AS sclr_2 FROM "team" t0_ INNER JOIN "game" g2_ ON (g2_.home_team_id = t0_.id OR g2_.away_team_id = t0_.id) INNER JOIN "competition" c1_ ON g2_.competition_id = c1_.id WHERE t0_.id IN (722, 990, 995, 1002, 1042, 1045) GROUP BY t0_.id, c1_.id ORDER BY sclr_2 DESC;

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

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.club_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.club_id = 14;