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

Query Metrics

5 Database Queries
4 Different statements
2.00 ms Query time
0 Invalid entities
28 Managed entities

Queries

Group similar statements

# Time Info
1 0.64 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.33 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:
[]
3 0.36 ms
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
Parameters:
[
  1
  1
]
4 0.40 ms
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
Parameters:
[
  1
  1
]
5 0.27 ms
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
Parameters:
[
  1
  1
]

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\AgeClass 11
App\Entity\TournamentFormat 9
App\Entity\Division 6
App\Entity\RuleBook 2

Entities Mapping

Class Mapping errors
App\Entity\RuleBook No errors.
App\Entity\AgeClass No errors.
App\Entity\TournamentFormat No errors.
App\Entity\Division No errors.
App\Entity\Tournament No errors.
App\Entity\Season No errors.
App\Entity\TargetFace No errors.
App\Entity\Bafa No errors.
App\Entity\Record No errors.
App\Entity\SessionRegistration No errors.
App\Entity\Team No errors.
App\Entity\TournamentAgeClass No errors.