GET https://uller-dev.swissarchery.org/en/tournament/15/register

Query Metrics

21 Database Queries
11 Different statements
3.20 ms Query time
0 Invalid entities
39 Managed entities

Queries

Group similar statements

# Time Info
1 0.47 ms
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 = ?
Parameters:
[
  "15"
]
2 0.30 ms
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 = ?
Parameters:
[
  1
]
3 0.18 ms
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 = ?
Parameters:
[
  2
]
4 0.12 ms
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 = ?
Parameters:
[
  6
]
5 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.shortName AS shortName_3, t0.code AS code_4, t0.correspondenceLanguage AS correspondenceLanguage_5, t0.country AS country_6, t0.visible AS visible_7, t0.address AS address_8, t0.npa AS npa_9, t0.city AS city_10, t0.cantonCode AS cantonCode_11, t0.phone AS phone_12, t0.phone2 AS phone2_13, t0.mobile AS mobile_14, t0.fax AS fax_15, t0.fax2 AS fax2_16, t0.correspondanceCountry AS correspondanceCountry_17, t0.affiliated_year AS affiliated_year_18, t0.contactName AS contactName_19, t0.emailAddress AS emailAddress_20, t0.url AS url_21, t0.isMember AS isMember_22, t0.sendTo AS sendTo_23, t0.member_until_date AS member_until_date_24, t0.comment AS comment_25 FROM federation t0 WHERE t0.id = ?
Parameters:
[
  41
]
6 0.17 ms
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 = ?
Parameters:
[
  15
]
7 0.15 ms
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 = ?
Parameters:
[
  15
]
8 0.15 ms
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.id = ?
Parameters:
[
  2
]
9 0.11 ms
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.id = ?
Parameters:
[
  3
]
10 0.10 ms
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.id = ?
Parameters:
[
  4
]
11 0.11 ms
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.id = ?
Parameters:
[
  5
]
12 0.10 ms
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.id = ?
Parameters:
[
  6
]
13 0.10 ms
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.id = ?
Parameters:
[
  7
]
14 0.11 ms
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.id = ?
Parameters:
[
  8
]
15 0.10 ms
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.id = ?
Parameters:
[
  9
]
16 0.09 ms
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.id = ?
Parameters:
[
  10
]
17 0.10 ms
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.id = ?
Parameters:
[
  11
]
18 0.11 ms
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 = ?
Parameters:
[
  15
]
19 0.16 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.result AS result_3, t0.is_guest AS is_guest_4, t0.correspondence_language AS correspondence_language_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.phone AS phone_9, t0.address AS address_10, t0.zip AS zip_11, t0.city AS city_12, t0.birth_date AS birth_date_13, t0.license_number AS license_number_14, t0.country AS country_15, t0.token AS token_16, t0.club_name AS club_name_17, t0.is_wheelchair_user AS is_wheelchair_user_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22, t0.user_id AS user_id_23, t0.tournament_session_id AS tournament_session_id_24, t0.division_id AS division_id_25, t0.tournament_age_class_id AS tournament_age_class_id_26, t0.team_id AS team_id_27 FROM session_registration t0 WHERE t0.tournament_session_id = ?
Parameters:
[
  11
]
20 0.16 ms
SELECT t0.id AS id_1, t0.state AS state_2, t0.result AS result_3, t0.is_guest AS is_guest_4, t0.correspondence_language AS correspondence_language_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.email AS email_8, t0.phone AS phone_9, t0.address AS address_10, t0.zip AS zip_11, t0.city AS city_12, t0.birth_date AS birth_date_13, t0.license_number AS license_number_14, t0.country AS country_15, t0.token AS token_16, t0.club_name AS club_name_17, t0.is_wheelchair_user AS is_wheelchair_user_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.created_by AS created_by_21, t0.updated_by AS updated_by_22, t0.user_id AS user_id_23, t0.tournament_session_id AS tournament_session_id_24, t0.division_id AS division_id_25, t0.tournament_age_class_id AS tournament_age_class_id_26, t0.team_id AS team_id_27 FROM session_registration t0 WHERE t0.tournament_session_id = ?
Parameters:
[
  12
]
21 0.18 ms
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.id = ?
Parameters:
[
  4
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\TournamentAgeClass 10
App\Entity\AgeClass 10
App\Entity\SessionRegistration 5
App\Entity\Division 4
App\Entity\User 3
App\Entity\TournamentSession 2
App\Entity\Tournament 1
App\Entity\TournamentCategory 1
App\Entity\TournamentFormat 1
App\Entity\Federation 1
App\Entity\RuleBook 1