Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.abbreviation AS abbreviation_3,
  t0.referee_label AS referee_label_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  rule_book t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.referee_label AS referee_label_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM rule_book t0;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.start_at AS start_at_2,
  s0_.end_at AS end_at_3,
  s0_.ranking_tournament_count AS ranking_tournament_count_4,
  s0_.rule_book_id AS rule_book_id_5
FROM
  season s0_
WHERE
  s0_.rule_book_id = ?
ORDER BY
  s0_.start_at DESC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.start_at AS start_at_2, s0_.end_at AS end_at_3, s0_.ranking_tournament_count AS ranking_tournament_count_4, s0_.rule_book_id AS rule_book_id_5 FROM season s0_ WHERE s0_.rule_book_id = 1 ORDER BY s0_.start_at DESC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.start_at AS start_at_2,
  s0_.end_at AS end_at_3,
  s0_.ranking_tournament_count AS ranking_tournament_count_4,
  s0_.rule_book_id AS rule_book_id_5
FROM
  season s0_
WHERE
  s0_.start_at <= ?
  AND s0_.end_at >= ?
  AND s0_.rule_book_id = ?
LIMIT
  1

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.start_at AS start_at_2, s0_.end_at AS end_at_3, s0_.ranking_tournament_count AS ranking_tournament_count_4, s0_.rule_book_id AS rule_book_id_5 FROM season s0_ WHERE s0_.start_at <= '2026-07-11 04:31:30' AND s0_.end_at >= '2026-07-11 04:31:30' AND s0_.rule_book_id = 1 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.state AS state_1,
  s0_.result AS result_2,
  s0_.is_guest AS is_guest_3,
  s0_.correspondence_language AS correspondence_language_4,
  s0_.first_name AS first_name_5,
  s0_.last_name AS last_name_6,
  s0_.email AS email_7,
  s0_.phone AS phone_8,
  s0_.address AS address_9,
  s0_.zip AS zip_10,
  s0_.city AS city_11,
  s0_.birth_date AS birth_date_12,
  s0_.license_number AS license_number_13,
  s0_.country AS country_14,
  s0_.token AS token_15,
  s0_.club_name AS club_name_16,
  s0_.is_wheelchair_user AS is_wheelchair_user_17,
  s0_.created_at AS created_at_18,
  s0_.updated_at AS updated_at_19,
  s0_.created_by AS created_by_20,
  s0_.updated_by AS updated_by_21,
  s0_.id AS id_22,
  s0_.state AS state_23,
  s0_.result AS result_24,
  s0_.is_guest AS is_guest_25,
  s0_.correspondence_language AS correspondence_language_26,
  s0_.first_name AS first_name_27,
  s0_.last_name AS last_name_28,
  s0_.email AS email_29,
  s0_.phone AS phone_30,
  s0_.address AS address_31,
  s0_.zip AS zip_32,
  s0_.city AS city_33,
  s0_.birth_date AS birth_date_34,
  s0_.license_number AS license_number_35,
  s0_.country AS country_36,
  s0_.token AS token_37,
  s0_.club_name AS club_name_38,
  s0_.is_wheelchair_user AS is_wheelchair_user_39,
  s0_.created_at AS created_at_40,
  s0_.updated_at AS updated_at_41,
  s0_.created_by AS created_by_42,
  s0_.updated_by AS updated_by_43,
  t1_.id AS id_44,
  t1_.fee AS fee_45,
  t1_.currency AS currency_46,
  t1_.created_at AS created_at_47,
  t1_.updated_at AS updated_at_48,
  t1_.created_by AS created_by_49,
  t1_.updated_by AS updated_by_50,
  t2_.id AS id_51,
  t2_.name AS name_52,
  t2_.register_start_at AS register_start_at_53,
  t2_.register_end_at AS register_end_at_54,
  t2_.inspection_start_at AS inspection_start_at_55,
  t2_.training_start_at AS training_start_at_56,
  t2_.shooting_start_at AS shooting_start_at_57,
  t2_.max_competitors AS max_competitors_58,
  t2_.is_final AS is_final_59,
  t2_.session_category AS session_category_60,
  t2_.is_inter_club AS is_inter_club_61,
  t2_.is_inter_gender AS is_inter_gender_62,
  t2_.team_members_number AS team_members_number_63,
  t2_.created_at AS created_at_64,
  t2_.updated_at AS updated_at_65,
  t2_.created_by AS created_by_66,
  t2_.updated_by AS updated_by_67,
  t3_.id AS id_68,
  t3_.name AS name_69,
  t3_.start_at AS start_at_70,
  t3_.end_at AS end_at_71,
  t3_.registration_start_at AS registration_start_at_72,
  t3_.registration_end_at AS registration_end_at_73,
  t3_.ianseo_link AS ianseo_link_74,
  t3_.description AS description_75,
  t3_.url AS url_76,
  t3_.state AS state_77,
  t3_.token AS token_78,
  t3_.slug AS slug_79,
  t3_.created_at AS created_at_80,
  t3_.updated_at AS updated_at_81,
  t3_.created_by AS created_by_82,
  t3_.updated_by AS updated_by_83,
  u4_.id AS id_84,
  u4_.roles AS roles_85,
  u4_.email AS email_86,
  u4_.password AS password_87,
  u4_.username AS username_88,
  u4_.locale AS locale_89,
  u4_.created_by AS created_by_90,
  u4_.updated_by AS updated_by_91,
  u4_.created_at AS created_at_92,
  u4_.updated_at AS updated_at_93,
  a5_.id AS id_94,
  a5_.name AS name_95,
  a5_.gender AS gender_96,
  a5_.state AS state_97,
  a5_.age_min AS age_min_98,
  a5_.age_max AS age_max_99,
  a5_.abbreviation AS abbreviation_100,
  a5_.created_at AS created_at_101,
  a5_.updated_at AS updated_at_102,
  a5_.created_by AS created_by_103,
  a5_.updated_by AS updated_by_104,
  d6_.id AS id_105,
  d6_.name AS name_106,
  d6_.abbreviation AS abbreviation_107,
  d6_.state AS state_108,
  d6_.created_at AS created_at_109,
  d6_.updated_at AS updated_at_110,
  d6_.created_by AS created_by_111,
  d6_.updated_by AS updated_by_112,
  t7_.id AS id_113,
  t7_.type AS type_114,
  t7_.name AS name_115,
  t7_.state AS state_116,
  t7_.round_count_max AS round_count_max_117,
  t7_.created_at AS created_at_118,
  t7_.updated_at AS updated_at_119,
  t7_.created_by AS created_by_120,
  t7_.updated_by AS updated_by_121,
  s0_.user_id AS user_id_122,
  s0_.tournament_session_id AS tournament_session_id_123,
  s0_.division_id AS division_id_124,
  s0_.tournament_age_class_id AS tournament_age_class_id_125,
  s0_.team_id AS team_id_126,
  t1_.age_class_id AS age_class_id_127,
  t1_.tournament_id AS tournament_id_128,
  t2_.tournament_id AS tournament_id_129,
  t3_.tournament_category_id AS tournament_category_id_130,
  t3_.tournament_format_id AS tournament_format_id_131,
  t3_.place_id AS place_id_132,
  t3_.user_organizer_id AS user_organizer_id_133,
  t3_.club_organizer_id AS club_organizer_id_134,
  t3_.rule_book_id AS rule_book_id_135,
  t3_.banner_file_id AS banner_file_id_136,
  u4_.person_id AS person_id_137,
  u4_.federation_id AS federation_id_138,
  a5_.rule_book_id AS rule_book_id_139,
  d6_.rule_book_id AS rule_book_id_140,
  t7_.rule_book_id AS rule_book_id_141
FROM
  session_registration s0_
  INNER JOIN tournament_age_class t1_ ON s0_.tournament_age_class_id = t1_.id
  INNER JOIN tournament_session t2_ ON s0_.tournament_session_id = t2_.id
  INNER JOIN tournament t3_ ON t2_.tournament_id = t3_.id
  INNER JOIN user u4_ ON s0_.user_id = u4_.id
  INNER JOIN age_class a5_ ON t1_.age_class_id = a5_.id
  INNER JOIN division d6_ ON s0_.division_id = d6_.id
  INNER JOIN tournament_format t7_ ON t3_.tournament_format_id = t7_.id
WHERE
  t3_.rule_book_id = ?
  AND t3_.start_at >= ?
  AND t3_.end_at <= ?
  AND s0_.result IS NOT NULL
  AND t2_.session_category <> ?
ORDER BY
  t2_.shooting_start_at ASC
LIMIT
  1

SELECT s0_.id AS id_0, s0_.state AS state_1, s0_.result AS result_2, s0_.is_guest AS is_guest_3, s0_.correspondence_language AS correspondence_language_4, s0_.first_name AS first_name_5, s0_.last_name AS last_name_6, s0_.email AS email_7, s0_.phone AS phone_8, s0_.address AS address_9, s0_.zip AS zip_10, s0_.city AS city_11, s0_.birth_date AS birth_date_12, s0_.license_number AS license_number_13, s0_.country AS country_14, s0_.token AS token_15, s0_.club_name AS club_name_16, s0_.is_wheelchair_user AS is_wheelchair_user_17, s0_.created_at AS created_at_18, s0_.updated_at AS updated_at_19, s0_.created_by AS created_by_20, s0_.updated_by AS updated_by_21, s0_.id AS id_22, s0_.state AS state_23, s0_.result AS result_24, s0_.is_guest AS is_guest_25, s0_.correspondence_language AS correspondence_language_26, s0_.first_name AS first_name_27, s0_.last_name AS last_name_28, s0_.email AS email_29, s0_.phone AS phone_30, s0_.address AS address_31, s0_.zip AS zip_32, s0_.city AS city_33, s0_.birth_date AS birth_date_34, s0_.license_number AS license_number_35, s0_.country AS country_36, s0_.token AS token_37, s0_.club_name AS club_name_38, s0_.is_wheelchair_user AS is_wheelchair_user_39, s0_.created_at AS created_at_40, s0_.updated_at AS updated_at_41, s0_.created_by AS created_by_42, s0_.updated_by AS updated_by_43, t1_.id AS id_44, t1_.fee AS fee_45, t1_.currency AS currency_46, t1_.created_at AS created_at_47, t1_.updated_at AS updated_at_48, t1_.created_by AS created_by_49, t1_.updated_by AS updated_by_50, t2_.id AS id_51, t2_.name AS name_52, t2_.register_start_at AS register_start_at_53, t2_.register_end_at AS register_end_at_54, t2_.inspection_start_at AS inspection_start_at_55, t2_.training_start_at AS training_start_at_56, t2_.shooting_start_at AS shooting_start_at_57, t2_.max_competitors AS max_competitors_58, t2_.is_final AS is_final_59, t2_.session_category AS session_category_60, t2_.is_inter_club AS is_inter_club_61, t2_.is_inter_gender AS is_inter_gender_62, t2_.team_members_number AS team_members_number_63, t2_.created_at AS created_at_64, t2_.updated_at AS updated_at_65, t2_.created_by AS created_by_66, t2_.updated_by AS updated_by_67, t3_.id AS id_68, t3_.name AS name_69, t3_.start_at AS start_at_70, t3_.end_at AS end_at_71, t3_.registration_start_at AS registration_start_at_72, t3_.registration_end_at AS registration_end_at_73, t3_.ianseo_link AS ianseo_link_74, t3_.description AS description_75, t3_.url AS url_76, t3_.state AS state_77, t3_.token AS token_78, t3_.slug AS slug_79, t3_.created_at AS created_at_80, t3_.updated_at AS updated_at_81, t3_.created_by AS created_by_82, t3_.updated_by AS updated_by_83, u4_.id AS id_84, u4_.roles AS roles_85, u4_.email AS email_86, u4_.password AS password_87, u4_.username AS username_88, u4_.locale AS locale_89, u4_.created_by AS created_by_90, u4_.updated_by AS updated_by_91, u4_.created_at AS created_at_92, u4_.updated_at AS updated_at_93, a5_.id AS id_94, a5_.name AS name_95, a5_.gender AS gender_96, a5_.state AS state_97, a5_.age_min AS age_min_98, a5_.age_max AS age_max_99, a5_.abbreviation AS abbreviation_100, a5_.created_at AS created_at_101, a5_.updated_at AS updated_at_102, a5_.created_by AS created_by_103, a5_.updated_by AS updated_by_104, d6_.id AS id_105, d6_.name AS name_106, d6_.abbreviation AS abbreviation_107, d6_.state AS state_108, d6_.created_at AS created_at_109, d6_.updated_at AS updated_at_110, d6_.created_by AS created_by_111, d6_.updated_by AS updated_by_112, t7_.id AS id_113, t7_.type AS type_114, t7_.name AS name_115, t7_.state AS state_116, t7_.round_count_max AS round_count_max_117, t7_.created_at AS created_at_118, t7_.updated_at AS updated_at_119, t7_.created_by AS created_by_120, t7_.updated_by AS updated_by_121, s0_.user_id AS user_id_122, s0_.tournament_session_id AS tournament_session_id_123, s0_.division_id AS division_id_124, s0_.tournament_age_class_id AS tournament_age_class_id_125, s0_.team_id AS team_id_126, t1_.age_class_id AS age_class_id_127, t1_.tournament_id AS tournament_id_128, t2_.tournament_id AS tournament_id_129, t3_.tournament_category_id AS tournament_category_id_130, t3_.tournament_format_id AS tournament_format_id_131, t3_.place_id AS place_id_132, t3_.user_organizer_id AS user_organizer_id_133, t3_.club_organizer_id AS club_organizer_id_134, t3_.rule_book_id AS rule_book_id_135, t3_.banner_file_id AS banner_file_id_136, u4_.person_id AS person_id_137, u4_.federation_id AS federation_id_138, a5_.rule_book_id AS rule_book_id_139, d6_.rule_book_id AS rule_book_id_140, t7_.rule_book_id AS rule_book_id_141 FROM session_registration s0_ INNER JOIN tournament_age_class t1_ ON s0_.tournament_age_class_id = t1_.id INNER JOIN tournament_session t2_ ON s0_.tournament_session_id = t2_.id INNER JOIN tournament t3_ ON t2_.tournament_id = t3_.id INNER JOIN user u4_ ON s0_.user_id = u4_.id INNER JOIN age_class a5_ ON t1_.age_class_id = a5_.id INNER JOIN division d6_ ON s0_.division_id = d6_.id INNER JOIN tournament_format t7_ ON t3_.tournament_format_id = t7_.id WHERE t3_.rule_book_id = 1 AND t3_.start_at >= '2026-03-01 00:00:00' AND t3_.end_at <= '2026-09-30 00:00:00' AND s0_.result IS NOT NULL AND t2_.session_category <> 20 ORDER BY t2_.shooting_start_at ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_3,
  t0.state AS state_4,
  t0.round_count_max AS round_count_max_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.created_by AS created_by_8,
  t0.updated_by AS updated_by_9,
  t0.rule_book_id AS rule_book_id_10
FROM
  tournament_format t0
WHERE
  t0.rule_book_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.state AS state_4, t0.round_count_max AS round_count_max_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9, t0.rule_book_id AS rule_book_id_10 FROM tournament_format t0 WHERE t0.rule_book_id = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.abbreviation AS abbreviation_3,
  t0.state AS state_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.rule_book_id AS rule_book_id_9
FROM
  division t0
WHERE
  t0.rule_book_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.abbreviation AS abbreviation_3, t0.state AS state_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.rule_book_id AS rule_book_id_9 FROM division t0 WHERE t0.rule_book_id = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.gender AS gender_3,
  t0.state AS state_4,
  t0.age_min AS age_min_5,
  t0.age_max AS age_max_6,
  t0.abbreviation AS abbreviation_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.rule_book_id AS rule_book_id_12
FROM
  age_class t0
WHERE
  t0.rule_book_id = ?
ORDER BY
  t0.age_min ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.gender AS gender_3, t0.state AS state_4, t0.age_min AS age_min_5, t0.age_max AS age_max_6, t0.abbreviation AS abbreviation_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.rule_book_id AS rule_book_id_12 FROM age_class t0 WHERE t0.rule_book_id = 1 ORDER BY t0.age_min ASC;

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.abbreviation AS abbreviation_2,
  r0_.referee_label AS referee_label_3,
  r0_.created_at AS created_at_4,
  r0_.updated_at AS updated_at_5,
  r0_.created_by AS created_by_6,
  r0_.updated_by AS updated_by_7
FROM
  rule_book r0_
WHERE
  (
    SELECT
      COUNT(*)
    FROM
      season s1_
    WHERE
      s1_.rule_book_id = r0_.id
  ) > 0

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.abbreviation AS abbreviation_2, r0_.referee_label AS referee_label_3, r0_.created_at AS created_at_4, r0_.updated_at AS updated_at_5, r0_.created_by AS created_by_6, r0_.updated_by AS updated_by_7 FROM rule_book r0_ WHERE (SELECT COUNT(*) FROM season s1_ WHERE s1_.rule_book_id = r0_.id) > 0;

SELECT
  t0_.id AS id_0,
  t0_.type AS type_1,
  t0_.name AS name_2,
  t0_.state AS state_3,
  t0_.round_count_max AS round_count_max_4,
  t0_.created_at AS created_at_5,
  t0_.updated_at AS updated_at_6,
  t0_.created_by AS created_by_7,
  t0_.updated_by AS updated_by_8,
  t0_.rule_book_id AS rule_book_id_9
FROM
  tournament_format t0_
WHERE
  t0_.rule_book_id = ?
  AND t0_.state = ?
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.name AS name_2, t0_.state AS state_3, t0_.round_count_max AS round_count_max_4, t0_.created_at AS created_at_5, t0_.updated_at AS updated_at_6, t0_.created_by AS created_by_7, t0_.updated_by AS updated_by_8, t0_.rule_book_id AS rule_book_id_9 FROM tournament_format t0_ WHERE t0_.rule_book_id = 1 AND t0_.state = 1 ORDER BY t0_.name ASC;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.abbreviation AS abbreviation_2,
  d0_.state AS state_3,
  d0_.created_at AS created_at_4,
  d0_.updated_at AS updated_at_5,
  d0_.created_by AS created_by_6,
  d0_.updated_by AS updated_by_7,
  d0_.rule_book_id AS rule_book_id_8
FROM
  division d0_
WHERE
  d0_.rule_book_id = ?
  AND d0_.state = ?
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.abbreviation AS abbreviation_2, d0_.state AS state_3, d0_.created_at AS created_at_4, d0_.updated_at AS updated_at_5, d0_.created_by AS created_by_6, d0_.updated_by AS updated_by_7, d0_.rule_book_id AS rule_book_id_8 FROM division d0_ WHERE d0_.rule_book_id = 1 AND d0_.state = 1 ORDER BY d0_.name ASC;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.gender AS gender_2,
  a0_.state AS state_3,
  a0_.age_min AS age_min_4,
  a0_.age_max AS age_max_5,
  a0_.abbreviation AS abbreviation_6,
  a0_.created_at AS created_at_7,
  a0_.updated_at AS updated_at_8,
  a0_.created_by AS created_by_9,
  a0_.updated_by AS updated_by_10,
  a0_.rule_book_id AS rule_book_id_11
FROM
  age_class a0_
WHERE
  a0_.rule_book_id = ?
  AND a0_.state = ?
ORDER BY
  a0_.age_min ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.gender AS gender_2, a0_.state AS state_3, a0_.age_min AS age_min_4, a0_.age_max AS age_max_5, a0_.abbreviation AS abbreviation_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.created_by AS created_by_9, a0_.updated_by AS updated_by_10, a0_.rule_book_id AS rule_book_id_11 FROM age_class a0_ WHERE a0_.rule_book_id = 1 AND a0_.state = 1 ORDER BY a0_.age_min ASC;