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

Query Metrics

16 Database Queries
5 Different statements
2.48 ms Query time
0 Invalid entities
38 Managed entities

Queries

Group similar statements

# Time Info
1 0.44 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
Parameters:
[]
2 0.26 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
Parameters:
[]
3 0.24 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:
[
  1
]
4 0.14 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
]
5 0.17 ms
SELECT t0.id AS id_1, t0.file_category AS file_category_2, t0.name AS name_3, t0.original_name AS original_name_4, t0.dimension AS dimension_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.url AS url_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, t0.tournament_id AS tournament_id_13 FROM tournament_file t0 WHERE t0.tournament_id = ?
Parameters:
[
  1
]
6 0.15 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:
[
  5
]
7 0.12 ms
SELECT t0.id AS id_1, t0.file_category AS file_category_2, t0.name AS name_3, t0.original_name AS original_name_4, t0.dimension AS dimension_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.url AS url_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, t0.tournament_id AS tournament_id_13 FROM tournament_file t0 WHERE t0.tournament_id = ?
Parameters:
[
  3
]
8 0.10 ms
SELECT t0.id AS id_1, t0.file_category AS file_category_2, t0.name AS name_3, t0.original_name AS original_name_4, t0.dimension AS dimension_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.url AS url_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, t0.tournament_id AS tournament_id_13 FROM tournament_file t0 WHERE t0.tournament_id = ?
Parameters:
[
  11
]
9 0.12 ms
SELECT t0.id AS id_1, t0.file_category AS file_category_2, t0.name AS name_3, t0.original_name AS original_name_4, t0.dimension AS dimension_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.url AS url_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, t0.tournament_id AS tournament_id_13 FROM tournament_file t0 WHERE t0.tournament_id = ?
Parameters:
[
  13
]
10 0.10 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
]
11 0.10 ms
SELECT t0.id AS id_1, t0.file_category AS file_category_2, t0.name AS name_3, t0.original_name AS original_name_4, t0.dimension AS dimension_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.url AS url_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, t0.tournament_id AS tournament_id_13 FROM tournament_file t0 WHERE t0.tournament_id = ?
Parameters:
[
  15
]
12 0.10 ms
SELECT t0.id AS id_1, t0.file_category AS file_category_2, t0.name AS name_3, t0.original_name AS original_name_4, t0.dimension AS dimension_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.url AS url_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, t0.tournament_id AS tournament_id_13 FROM tournament_file t0 WHERE t0.tournament_id = ?
Parameters:
[
  16
]
13 0.09 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:
[
  7
]
14 0.10 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:
[
  3
]
15 0.09 ms
SELECT t0.id AS id_1, t0.file_category AS file_category_2, t0.name AS name_3, t0.original_name AS original_name_4, t0.dimension AS dimension_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.url AS url_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, t0.tournament_id AS tournament_id_13 FROM tournament_file t0 WHERE t0.tournament_id = ?
Parameters:
[
  17
]
16 0.16 ms
SELECT t0.id AS id_1, t0.file_category AS file_category_2, t0.name AS name_3, t0.original_name AS original_name_4, t0.dimension AS dimension_5, t0.size AS size_6, t0.mime_type AS mime_type_7, t0.url AS url_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, t0.tournament_id AS tournament_id_13 FROM tournament_file t0 WHERE t0.tournament_id = ?
Parameters:
[
  20
]

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\Tournament 10
App\Entity\Place 7
App\Entity\TournamentFile 7
App\Entity\TournamentFormat 4
App\Entity\User 4
App\Entity\RuleBook 2
App\Entity\TournamentCategory 2
App\Entity\Federation 2