Query Metrics
6
Database Queries
6
Different statements
2.24 ms
Query time
0
Invalid entities
15
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.76 ms (34.14%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.start_at AS start_at_2, t0_.end_at AS end_at_3, t0_.registration_start_at AS registration_start_at_4, t0_.registration_end_at AS registration_end_at_5, t0_.ianseo_link AS ianseo_link_6, t0_.description AS description_7, t0_.url AS url_8, t0_.state AS state_9, t0_.token AS token_10, t0_.slug AS slug_11, t0_.created_at AS created_at_12, t0_.updated_at AS updated_at_13, t0_.created_by AS created_by_14, t0_.updated_by AS updated_by_15, t0_.tournament_category_id AS tournament_category_id_16, t0_.tournament_format_id AS tournament_format_id_17, t0_.place_id AS place_id_18, t0_.user_organizer_id AS user_organizer_id_19, t0_.club_organizer_id AS club_organizer_id_20, t0_.rule_book_id AS rule_book_id_21, t0_.banner_file_id AS banner_file_id_22 FROM tournament t0_ WHERE t0_.end_at >= ? ORDER BY t0_.start_at ASC
Parameters:
[
"2026-07-11 09:01:53"
]
|
|
0.61 ms (27.20%) |
1 |
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:
[] |
|
0.30 ms (13.58%) |
1 |
SELECT DISTINCT SUBSTRING(t0_.start_at FROM 1 FOR 4) AS sclr_0 FROM tournament t0_ ORDER BY sclr_0 DESC
Parameters:
[] |
|
0.23 ms (10.45%) |
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.id = ?
Parameters:
[
15
]
|
|
0.17 ms (7.65%) |
1 |
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:
[
21
]
|
|
0.16 ms (6.98%) |
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 = ?
Parameters:
[
2
]
|
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 | 3 |
| App\Entity\TournamentFormat | 3 |
| App\Entity\RuleBook | 2 |
| App\Entity\TournamentCategory | 2 |
| App\Entity\User | 2 |
| App\Entity\Federation | 1 |
| App\Entity\TournamentFile | 1 |
| App\Entity\Place | 1 |
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\TournamentCategory | No errors. |
| App\Entity\Place | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Federation | No errors. |
| App\Entity\TournamentFile | No errors. |
| App\Entity\TournamentReferee | No errors. |
| App\Entity\TournamentSession | No errors. |
| App\Entity\TournamentAgeClass | No errors. |
| App\Entity\TournamentQuestion | No errors. |