GET https://devel2.bowlres.se/division/10/standings?round=11

Query Metrics

9 Database Queries
9 Different statements
4.11 ms Query time
0 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 0.40 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:
[
  "10"
]
2 0.52 ms
SELECT MAX(l0_.round) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = ?
Parameters:
[
  10
]
3 0.51 ms
SELECT MAX(l0_.round) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = ? AND l1_.points > 0
Parameters:
[
  10
]
4 0.36 ms
SELECT MIN(l0_.datetime) AS sclr_0 FROM league_match_team l1_ INNER JOIN league_match l0_ ON l1_.league_match_id = l0_.id WHERE l0_.division_id = ? AND l0_.round = ?
Parameters:
[
  10
  10
]
5 0.50 ms
SELECT l0_.team_id AS sclr_0, t1_.name AS name_1, l0_.league_match_id AS sclr_2, l0_.points AS points_3, l0_.pinfall AS pinfall_4 FROM league_match_team l0_ INNER JOIN team t1_ ON l0_.team_id = t1_.id INNER JOIN league_match l2_ ON l0_.league_match_id = l2_.id WHERE l2_.division_id = ? AND l2_.round <= ?
Parameters:
[
  10
  11
]
6 0.49 ms
SELECT l0_.id AS id_0, l0_.datetime AS datetime_1, t1_.name AS name_2, l2_.points AS points_3, l2_.pinfall AS pinfall_4 FROM league_match_team l2_ INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id INNER JOIN team t1_ ON l2_.team_id = t1_.id WHERE l0_.division_id = ? AND l0_.round = ? ORDER BY l0_.datetime ASC, l0_.id ASC, l2_.ordering ASC
Parameters:
[
  10
  11
]
7 0.39 ms
SELECT l0_.id AS id_0, l0_.datetime AS datetime_1, t1_.name AS name_2 FROM league_match_team l2_ INNER JOIN league_match l0_ ON l2_.league_match_id = l0_.id INNER JOIN team t1_ ON l2_.team_id = t1_.id WHERE l0_.division_id = ? AND l0_.round = ? ORDER BY l0_.datetime ASC, l0_.id ASC, l2_.ordering ASC
Parameters:
[
  10
  12
]
8 0.61 ms
SELECT l0_.team_id AS sclr_0, p1_.firstname AS firstname_1, p1_.lastname AS lastname_2, l2_.scores AS scores_3 FROM league_match_participant l2_ INNER JOIN league_match_team l0_ ON l2_.league_match_team_id = l0_.id INNER JOIN league_match l3_ ON l0_.league_match_id = l3_.id INNER JOIN player p1_ ON l2_.player_id = p1_.id WHERE l3_.division_id = ? AND l3_.round <= ?
Parameters:
[
  10
  11
]
9 0.34 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:
[
  8
]

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\Division 1
App\Entity\League 1
App\Entity\Alley 1

Entities Mapping

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