GET https://devel2.bowlres.se/admin/division-team?divisionId=2&leagueId=1

Query Metrics

8 Database Queries
5 Different statements
3.19 ms Query time
0 Invalid entities
8 Managed entities

Queries

Group similar statements

# Time Info
1 0.46 ms
SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5
]
2 0.41 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.rounds AS rounds_3, t0.league_id AS league_id_4 FROM division t0 WHERE t0.id = ?
Parameters:
[
  2
]
3 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.division_id AS division_id_3 FROM team t0 WHERE t0.division_id = ? ORDER BY t0.name ASC
Parameters:
[
  2
]
4 0.42 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5 FROM player t0 INNER JOIN team_player ON t0.id = team_player.player_id WHERE team_player.team_id = ? ORDER BY t0.firstname ASC, t0.lastname ASC
Parameters:
[
  60
]
5 0.36 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5 FROM player t0 INNER JOIN team_player ON t0.id = team_player.player_id WHERE team_player.team_id = ? ORDER BY t0.firstname ASC, t0.lastname ASC
Parameters:
[
  61
]
6 0.33 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5 FROM player t0 INNER JOIN team_player ON t0.id = team_player.player_id WHERE team_player.team_id = ? ORDER BY t0.firstname ASC, t0.lastname ASC
Parameters:
[
  62
]
7 0.34 ms
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5 FROM player t0 INNER JOIN team_player ON t0.id = team_player.player_id WHERE team_player.team_id = ? ORDER BY t0.firstname ASC, t0.lastname ASC
Parameters:
[
  63
]
8 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.default_alley_id AS default_alley_id_3 FROM league t0 WHERE t0.id = ?
Parameters:
[
  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\Team 4
App\Entity\User 1
App\Entity\Division 1
App\Entity\League 1
App\Entity\Alley 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\League No errors.
App\Entity\Team No errors.
App\Entity\Division No errors.
App\Entity\Player No errors.
App\Entity\LeagueMatch No errors.
App\Entity\LeagueMatchTeam No errors.
App\Entity\Alley No errors.