Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.start_at AS start_at_3,
  t0.end_at AS end_at_4,
  t0.registration_start_at AS registration_start_at_5,
  t0.registration_end_at AS registration_end_at_6,
  t0.ianseo_link AS ianseo_link_7,
  t0.description AS description_8,
  t0.url AS url_9,
  t0.state AS state_10,
  t0.token AS token_11,
  t0.slug AS slug_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.tournament_category_id AS tournament_category_id_17,
  t0.tournament_format_id AS tournament_format_id_18,
  t0.place_id AS place_id_19,
  t0.user_organizer_id AS user_organizer_id_20,
  t0.club_organizer_id AS club_organizer_id_21,
  t0.rule_book_id AS rule_book_id_22,
  t0.banner_file_id AS banner_file_id_23
FROM
  tournament t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.start_at AS start_at_3, t0.end_at AS end_at_4, t0.registration_start_at AS registration_start_at_5, t0.registration_end_at AS registration_end_at_6, t0.ianseo_link AS ianseo_link_7, t0.description AS description_8, t0.url AS url_9, t0.state AS state_10, t0.token AS token_11, t0.slug AS slug_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.tournament_category_id AS tournament_category_id_17, t0.tournament_format_id AS tournament_format_id_18, t0.place_id AS place_id_19, t0.user_organizer_id AS user_organizer_id_20, t0.club_organizer_id AS club_organizer_id_21, t0.rule_book_id AS rule_book_id_22, t0.banner_file_id AS banner_file_id_23 FROM tournament t0 WHERE t0.id = '3';

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
WHERE
  t0.id = ?

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 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.licence_required AS licence_required_3,
  t0.national_ranking_allowed AS national_ranking_allowed_4,
  t0.guest_allowed AS guest_allowed_5,
  t0.record_allowed AS record_allowed_6,
  t0.referee_required AS referee_required_7,
  t0.access_roles AS access_roles_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.created_by AS created_by_11,
  t0.updated_by AS updated_by_12
FROM
  tournament_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.licence_required AS licence_required_3, t0.national_ranking_allowed AS national_ranking_allowed_4, t0.guest_allowed AS guest_allowed_5, t0.record_allowed AS record_allowed_6, t0.referee_required AS referee_required_7, t0.access_roles AS access_roles_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM tournament_category t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.name AS name_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
  tournament_format t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_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 tournament_format t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.function AS function_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.created_by AS created_by_5,
  t0.updated_by AS updated_by_6,
  t0.person_id AS person_id_7,
  t0.tournament_id AS tournament_id_8
FROM
  tournament_referee t0
WHERE
  t0.tournament_id = ?

SELECT t0.id AS id_1, t0.function AS function_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by AS created_by_5, t0.updated_by AS updated_by_6, t0.person_id AS person_id_7, t0.tournament_id AS tournament_id_8 FROM tournament_referee t0 WHERE t0.tournament_id = 3;

SELECT
  t0.id AS id_1,
  t0.gender AS gender_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.address AS address_7,
  t0.npa AS npa_8,
  t0.city AS city_9,
  t0.birth_date AS birth_date_10,
  t0.decease_date AS decease_date_11,
  t0.retire_date AS retire_date_12,
  t0.printedAt AS printedAt_13,
  t0.lastPrintedAt AS lastPrintedAt_14,
  t0.numberPrinted AS numberPrinted_15,
  t0.note AS note_16,
  t0.language AS language_17,
  t0.membership_date AS membership_date_18,
  t0.membership_type AS membership_type_19,
  t0.deletedAt AS deletedAt_20,
  t0.locked AS locked_21,
  t0.licenseNumber AS licenseNumber_22,
  t0.hash AS hash_23,
  t0.birth_city_country AS birth_city_country_24,
  t0.height AS height_25,
  t0.spouse_children AS spouse_children_26,
  t0.former_name AS former_name_27,
  t0.residence_city_country AS residence_city_country_28,
  t0.education_city_country AS education_city_country_29,
  t0.occupation AS occupation_30,
  t0.website AS website_31,
  t0.twitter AS twitter_32,
  t0.facebook AS facebook_33,
  t0.instagram AS instagram_34,
  t0.snapchat AS snapchat_35,
  t0.discr AS discr_36,
  t0.created_by AS created_by_37,
  t0.updated_by AS updated_by_38,
  t0.created_at AS created_at_39,
  t0.updated_at AS updated_at_40,
  t0.federation_id AS federation_id_41,
  t42.id AS id_43,
  t42.name AS name_44,
  t42.shortName AS shortName_45,
  t42.code AS code_46,
  t42.correspondenceLanguage AS correspondenceLanguage_47,
  t42.country AS country_48,
  t42.visible AS visible_49,
  t42.address AS address_50,
  t42.npa AS npa_51,
  t42.city AS city_52,
  t42.cantonCode AS cantonCode_53,
  t42.phone AS phone_54,
  t42.phone2 AS phone2_55,
  t42.mobile AS mobile_56,
  t42.fax AS fax_57,
  t42.fax2 AS fax2_58,
  t42.correspondanceCountry AS correspondanceCountry_59,
  t42.affiliated_year AS affiliated_year_60,
  t42.contactName AS contactName_61,
  t42.emailAddress AS emailAddress_62,
  t42.url AS url_63,
  t42.isMember AS isMember_64,
  t42.sendTo AS sendTo_65,
  t42.member_until_date AS member_until_date_66,
  t42.comment AS comment_67,
  t0.previous_federation_id AS previous_federation_id_68,
  t69.id AS id_70,
  t69.name AS name_71,
  t69.shortName AS shortName_72,
  t69.code AS code_73,
  t69.correspondenceLanguage AS correspondenceLanguage_74,
  t69.country AS country_75,
  t69.visible AS visible_76,
  t69.address AS address_77,
  t69.npa AS npa_78,
  t69.city AS city_79,
  t69.cantonCode AS cantonCode_80,
  t69.phone AS phone_81,
  t69.phone2 AS phone2_82,
  t69.mobile AS mobile_83,
  t69.fax AS fax_84,
  t69.fax2 AS fax2_85,
  t69.correspondanceCountry AS correspondanceCountry_86,
  t69.affiliated_year AS affiliated_year_87,
  t69.contactName AS contactName_88,
  t69.emailAddress AS emailAddress_89,
  t69.url AS url_90,
  t69.isMember AS isMember_91,
  t69.sendTo AS sendTo_92,
  t69.member_until_date AS member_until_date_93,
  t69.comment AS comment_94,
  t95.id AS id_96,
  t95.roles AS roles_97,
  t95.email AS email_98,
  t95.password AS password_99,
  t95.username AS username_100,
  t95.locale AS locale_101,
  t95.created_by AS created_by_102,
  t95.updated_by AS updated_by_103,
  t95.created_at AS created_at_104,
  t95.updated_at AS updated_at_105,
  t95.person_id AS person_id_106,
  t95.federation_id AS federation_id_107
FROM
  person t0
  LEFT JOIN federation t42 ON t0.federation_id = t42.id
  LEFT JOIN federation t69 ON t0.previous_federation_id = t69.id
  LEFT JOIN user t95 ON t95.person_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.gender AS gender_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.email AS email_5, t0.phone AS phone_6, t0.address AS address_7, t0.npa AS npa_8, t0.city AS city_9, t0.birth_date AS birth_date_10, t0.decease_date AS decease_date_11, t0.retire_date AS retire_date_12, t0.printedAt AS printedAt_13, t0.lastPrintedAt AS lastPrintedAt_14, t0.numberPrinted AS numberPrinted_15, t0.note AS note_16, t0.language AS language_17, t0.membership_date AS membership_date_18, t0.membership_type AS membership_type_19, t0.deletedAt AS deletedAt_20, t0.locked AS locked_21, t0.licenseNumber AS licenseNumber_22, t0.hash AS hash_23, t0.birth_city_country AS birth_city_country_24, t0.height AS height_25, t0.spouse_children AS spouse_children_26, t0.former_name AS former_name_27, t0.residence_city_country AS residence_city_country_28, t0.education_city_country AS education_city_country_29, t0.occupation AS occupation_30, t0.website AS website_31, t0.twitter AS twitter_32, t0.facebook AS facebook_33, t0.instagram AS instagram_34, t0.snapchat AS snapchat_35, t0.discr AS discr_36, t0.created_by AS created_by_37, t0.updated_by AS updated_by_38, t0.created_at AS created_at_39, t0.updated_at AS updated_at_40, t0.federation_id AS federation_id_41, t42.id AS id_43, t42.name AS name_44, t42.shortName AS shortName_45, t42.code AS code_46, t42.correspondenceLanguage AS correspondenceLanguage_47, t42.country AS country_48, t42.visible AS visible_49, t42.address AS address_50, t42.npa AS npa_51, t42.city AS city_52, t42.cantonCode AS cantonCode_53, t42.phone AS phone_54, t42.phone2 AS phone2_55, t42.mobile AS mobile_56, t42.fax AS fax_57, t42.fax2 AS fax2_58, t42.correspondanceCountry AS correspondanceCountry_59, t42.affiliated_year AS affiliated_year_60, t42.contactName AS contactName_61, t42.emailAddress AS emailAddress_62, t42.url AS url_63, t42.isMember AS isMember_64, t42.sendTo AS sendTo_65, t42.member_until_date AS member_until_date_66, t42.comment AS comment_67, t0.previous_federation_id AS previous_federation_id_68, t69.id AS id_70, t69.name AS name_71, t69.shortName AS shortName_72, t69.code AS code_73, t69.correspondenceLanguage AS correspondenceLanguage_74, t69.country AS country_75, t69.visible AS visible_76, t69.address AS address_77, t69.npa AS npa_78, t69.city AS city_79, t69.cantonCode AS cantonCode_80, t69.phone AS phone_81, t69.phone2 AS phone2_82, t69.mobile AS mobile_83, t69.fax AS fax_84, t69.fax2 AS fax2_85, t69.correspondanceCountry AS correspondanceCountry_86, t69.affiliated_year AS affiliated_year_87, t69.contactName AS contactName_88, t69.emailAddress AS emailAddress_89, t69.url AS url_90, t69.isMember AS isMember_91, t69.sendTo AS sendTo_92, t69.member_until_date AS member_until_date_93, t69.comment AS comment_94, t95.id AS id_96, t95.roles AS roles_97, t95.email AS email_98, t95.password AS password_99, t95.username AS username_100, t95.locale AS locale_101, t95.created_by AS created_by_102, t95.updated_by AS updated_by_103, t95.created_at AS created_at_104, t95.updated_at AS updated_at_105, t95.person_id AS person_id_106, t95.federation_id AS federation_id_107 FROM person t0 LEFT JOIN federation t42 ON t0.federation_id = t42.id LEFT JOIN federation t69 ON t0.previous_federation_id = t69.id LEFT JOIN user t95 ON t95.person_id = t0.id WHERE t0.id = '44269aa4-18b2-11';

SELECT
  t0.id AS id_1,
  t0.fee AS fee_2,
  t0.currency AS currency_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.age_class_id AS age_class_id_8,
  t0.tournament_id AS tournament_id_9
FROM
  tournament_age_class t0
WHERE
  t0.tournament_id = ?

SELECT t0.id AS id_1, t0.fee AS fee_2, t0.currency AS currency_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.age_class_id AS age_class_id_8, t0.tournament_id AS tournament_id_9 FROM tournament_age_class t0 WHERE t0.tournament_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.register_start_at AS register_start_at_3,
  t0.register_end_at AS register_end_at_4,
  t0.inspection_start_at AS inspection_start_at_5,
  t0.training_start_at AS training_start_at_6,
  t0.shooting_start_at AS shooting_start_at_7,
  t0.max_competitors AS max_competitors_8,
  t0.is_final AS is_final_9,
  t0.session_category AS session_category_10,
  t0.is_inter_club AS is_inter_club_11,
  t0.is_inter_gender AS is_inter_gender_12,
  t0.team_members_number AS team_members_number_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.created_by AS created_by_16,
  t0.updated_by AS updated_by_17,
  t0.tournament_id AS tournament_id_18
FROM
  tournament_session t0
WHERE
  t0.tournament_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.register_start_at AS register_start_at_3, t0.register_end_at AS register_end_at_4, t0.inspection_start_at AS inspection_start_at_5, t0.training_start_at AS training_start_at_6, t0.shooting_start_at AS shooting_start_at_7, t0.max_competitors AS max_competitors_8, t0.is_final AS is_final_9, t0.session_category AS session_category_10, t0.is_inter_club AS is_inter_club_11, t0.is_inter_gender AS is_inter_gender_12, t0.team_members_number AS team_members_number_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.tournament_id AS tournament_id_18 FROM tournament_session t0 WHERE t0.tournament_id = 3;