Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.firstname AS firstname_2,
  t0.firstname_international AS firstname_international_3,
  t0.lastname AS lastname_4,
  t0.lastname_international AS lastname_international_5,
  t0.tv_name AS tv_name_6,
  t0.scoreboard_name AS scoreboard_name_7,
  t0.nickname AS nickname_8,
  t0.nickname_international AS nickname_international_9,
  t0.birthdate AS birthdate_10,
  t0.gender AS gender_11,
  t0.height AS height_12,
  t0.weight AS weight_13,
  t0.approved_by AS approved_by_14,
  t0.license_type AS license_type_15,
  t0.license_number AS license_number_16,
  t0.esake_id AS esake_id_17,
  t0.euroleague_id AS euroleague_id_18,
  t0.default_shirt_number AS default_shirt_number_19,
  t0.default_playing_position AS default_playing_position_20,
  t0.basketball_school AS basketball_school_21,
  t0.about AS about_22,
  t0.about_international AS about_international_23,
  t0.achievements AS achievements_24,
  t0.achievements_international AS achievements_international_25,
  t0.teams AS teams_26,
  t0.teams_international AS teams_international_27,
  t0.custom_values AS custom_values_28,
  t0.image_name AS image_name_29,
  t0.image_size AS image_size_30,
  t0.web_image_name AS web_image_name_31,
  t0.web_image_size AS web_image_size_32,
  t0.is_web_visible AS is_web_visible_33,
  t0.is_archived AS is_archived_34,
  t0.created_at AS created_at_35,
  t0.updated_at AS updated_at_36,
  t0.nationality_id AS nationality_id_37,
  t0.sport_country_id AS sport_country_id_38,
  t0.primary_club_id AS primary_club_id_39,
  t0.primary_team_id AS primary_team_id_40,
  t41.id AS id_42,
  t41.games AS games_43,
  t41.points AS points_44,
  t41.points_per_game AS points_per_game_45,
  t41.minutes AS minutes_46,
  t41.minutes_per_game AS minutes_per_game_47,
  t41.assists AS assists_48,
  t41.assists_per_game AS assists_per_game_49,
  t41.rebounds AS rebounds_50,
  t41.rebounds_per_game AS rebounds_per_game_51,
  t41.two_points_attempt AS two_points_attempt_52,
  t41.two_points_made AS two_points_made_53,
  t41.three_points_attempt AS three_points_attempt_54,
  t41.three_points_made AS three_points_made_55,
  t41.free_throws_attempt AS free_throws_attempt_56,
  t41.free_throws_made AS free_throws_made_57,
  t41.created_at AS created_at_58,
  t41.updated_at AS updated_at_59,
  t41.person_id AS person_id_60
FROM
  person t0
  LEFT JOIN person_career_statistics t41 ON t41.person_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.firstname_international AS firstname_international_3, t0.lastname AS lastname_4, t0.lastname_international AS lastname_international_5, t0.tv_name AS tv_name_6, t0.scoreboard_name AS scoreboard_name_7, t0.nickname AS nickname_8, t0.nickname_international AS nickname_international_9, t0.birthdate AS birthdate_10, t0.gender AS gender_11, t0.height AS height_12, t0.weight AS weight_13, t0.approved_by AS approved_by_14, t0.license_type AS license_type_15, t0.license_number AS license_number_16, t0.esake_id AS esake_id_17, t0.euroleague_id AS euroleague_id_18, t0.default_shirt_number AS default_shirt_number_19, t0.default_playing_position AS default_playing_position_20, t0.basketball_school AS basketball_school_21, t0.about AS about_22, t0.about_international AS about_international_23, t0.achievements AS achievements_24, t0.achievements_international AS achievements_international_25, t0.teams AS teams_26, t0.teams_international AS teams_international_27, t0.custom_values AS custom_values_28, t0.image_name AS image_name_29, t0.image_size AS image_size_30, t0.web_image_name AS web_image_name_31, t0.web_image_size AS web_image_size_32, t0.is_web_visible AS is_web_visible_33, t0.is_archived AS is_archived_34, t0.created_at AS created_at_35, t0.updated_at AS updated_at_36, t0.nationality_id AS nationality_id_37, t0.sport_country_id AS sport_country_id_38, t0.primary_club_id AS primary_club_id_39, t0.primary_team_id AS primary_team_id_40, t41.id AS id_42, t41.games AS games_43, t41.points AS points_44, t41.points_per_game AS points_per_game_45, t41.minutes AS minutes_46, t41.minutes_per_game AS minutes_per_game_47, t41.assists AS assists_48, t41.assists_per_game AS assists_per_game_49, t41.rebounds AS rebounds_50, t41.rebounds_per_game AS rebounds_per_game_51, t41.two_points_attempt AS two_points_attempt_52, t41.two_points_made AS two_points_made_53, t41.three_points_attempt AS three_points_attempt_54, t41.three_points_made AS three_points_made_55, t41.free_throws_attempt AS free_throws_attempt_56, t41.free_throws_made AS free_throws_made_57, t41.created_at AS created_at_58, t41.updated_at AS updated_at_59, t41.person_id AS person_id_60 FROM person t0 LEFT JOIN person_career_statistics t41 ON t41.person_id = t0.id WHERE t0.id = 3266;

SELECT
  t0_.id AS id_0,
  t0_.active_from AS active_from_1,
  t0_.active_to AS active_to_2,
  t0_.default_shirt_number AS default_shirt_number_3,
  t0_.default_playing_position AS default_playing_position_4,
  t0_.is_captain AS is_captain_5,
  t0_.created_at AS created_at_6,
  t0_.updated_at AS updated_at_7,
  t0_.team_id AS team_id_8,
  t0_.person_id AS person_id_9
FROM
  team_player t0_
  LEFT JOIN person p1_ ON t0_.person_id = p1_.id
  AND (t0_.person_id = p1_.id)
WHERE
  (
    t0_.team_id IN (
      SELECT
        t2_.id
      FROM
        team t2_
      WHERE
        t2_.competition_id IN (
          SELECT
            c3_.id
          FROM
            competition c3_
          WHERE
            c3_.season_id IN (
              SELECT
                s4_.id
              FROM
                season s4_
              WHERE
                s4_.year = ?
            )
        )
        AND t2_.tv_code = ?
    )
  )
  AND p1_.is_web_visible = 1
  AND p1_.is_archived = 0
GROUP BY
  t0_.person_id
ORDER BY
  p1_.default_shirt_number ASC

SELECT t0_.id AS id_0, t0_.active_from AS active_from_1, t0_.active_to AS active_to_2, t0_.default_shirt_number AS default_shirt_number_3, t0_.default_playing_position AS default_playing_position_4, t0_.is_captain AS is_captain_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7, t0_.team_id AS team_id_8, t0_.person_id AS person_id_9 FROM team_player t0_ LEFT JOIN person p1_ ON t0_.person_id = p1_.id AND (t0_.person_id = p1_.id) WHERE (t0_.team_id IN (SELECT t2_.id FROM team t2_ WHERE t2_.competition_id IN (SELECT c3_.id FROM competition c3_ WHERE c3_.season_id IN (SELECT s4_.id FROM season s4_ WHERE s4_.year = '2025')) AND t2_.tv_code = 'OLY')) AND p1_.is_web_visible = 1 AND p1_.is_archived = 0 GROUP BY t0_.person_id ORDER BY p1_.default_shirt_number ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.abbr AS abbr_3,
  t0.name_international AS name_international_4,
  t0.abbr_international AS abbr_international_5,
  t0.code AS code_6,
  t0.code_ioc AS code_ioc_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbr AS abbr_3, t0.name_international AS name_international_4, t0.abbr_international AS abbr_international_5, t0.code AS code_6, t0.code_ioc AS code_ioc_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM country t0 WHERE t0.id = 33;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_international AS name_international_3,
  t0.nickname AS nickname_4,
  t0.nickname_international AS nickname_international_5,
  t0.is_active AS is_active_6,
  t0.is_virtual AS is_virtual_7,
  t0.address1 AS address1_8,
  t0.address2 AS address2_9,
  t0.postal AS postal_10,
  t0.phone AS phone_11,
  t0.fax AS fax_12,
  t0.email AS email_13,
  t0.notes AS notes_14,
  t0.ticket_url AS ticket_url_15,
  t0.custom_values AS custom_values_16,
  t0.image_name AS image_name_17,
  t0.image_size AS image_size_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.city_id AS city_id_21,
  t0.country_id AS country_id_22
FROM
  club t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_international AS name_international_3, t0.nickname AS nickname_4, t0.nickname_international AS nickname_international_5, t0.is_active AS is_active_6, t0.is_virtual AS is_virtual_7, t0.address1 AS address1_8, t0.address2 AS address2_9, t0.postal AS postal_10, t0.phone AS phone_11, t0.fax AS fax_12, t0.email AS email_13, t0.notes AS notes_14, t0.ticket_url AS ticket_url_15, t0.custom_values AS custom_values_16, t0.image_name AS image_name_17, t0.image_size AS image_size_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.city_id AS city_id_21, t0.country_id AS country_id_22 FROM club t0 WHERE t0.id = 8;