Query Metrics
8
Database Queries
5
Different statements
2.46 ms
Query time
0
Invalid entities
65
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.45 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
Parameters:
[] |
| 2 | 0.20 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.29 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.rule_book_id = ? ORDER BY t0.age_min ASC
Parameters:
[
1
]
|
| 4 | 0.23 ms |
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.rule_book_id = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 5 | 0.13 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.rule_book_id = ? ORDER BY t0.name ASC
Parameters:
[
1
]
|
| 6 | 0.52 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.rule_book_id = ? ORDER BY t0.age_min ASC
Parameters:
[
2
]
|
| 7 | 0.32 ms |
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.rule_book_id = ? ORDER BY t0.name ASC
Parameters:
[
2
]
|
| 8 | 0.31 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.rule_book_id = ? ORDER BY t0.name ASC
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\AgeClass | 25 |
| App\Entity\Division | 19 |
| App\Entity\TournamentFormat | 16 |
| App\Entity\TournamentCategory | 3 |
| App\Entity\RuleBook | 2 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\TournamentCategory | No errors. |
| App\Entity\Tournament | No errors. |
| App\Entity\RuleBook | No errors. |
| App\Entity\AgeClass | No errors. |
| App\Entity\TournamentFormat | No errors. |
| App\Entity\Division | No errors. |
| App\Entity\Season | No errors. |
| App\Entity\TargetFace | No errors. |
| App\Entity\Bafa | No errors. |
| App\Entity\TournamentAgeClass | No errors. |
| App\Entity\Record | No errors. |
| App\Entity\SessionRegistration | No errors. |
| App\Entity\Team | No errors. |