GET http://betforfun.be/competition/5/ranking

Query Metrics

23 Database Queries
4 Different statements
2.78 ms Query time
0 Invalid entities
469 Managed entities

Queries

Group similar statements

# Time Info
1 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.status AS status_4, t0.icon AS icon_5, t0.code AS code_6, t0.league AS league_7, t0.season AS season_8, t0.sport_id AS sport_id_9 FROM competition t0 WHERE t0.id = ?
Parameters:
[
  "5"
]
2 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.icon AS icon_4 FROM sport t0 WHERE t0.id = ?
Parameters:
[
  2
]
3 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0
Parameters:
[]
4 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  42
]
5 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  50
]
6 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  33
]
7 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  66
]
8 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  49
]
9 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  40
]
10 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  55
]
11 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  45
]
12 0.10 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  35
]
13 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  36
]
14 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  746
]
15 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  34
]
16 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  51
]
17 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  52
]
18 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  63
]
19 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  47
]
20 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  65
]
21 0.09 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  48
]
22 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  44
]
23 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.code AS code_4, t0.icon AS icon_5, t0.api_id AS api_id_6, t0.current_form AS current_form_7, t0.participant_id AS participant_id_8, t0.competition_id AS competition_id_9 FROM competitor t0 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  5
  39
]

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\Competitor 241
App\Entity\Participant 221
App\Entity\Competition 6
App\Entity\Sport 1

Entities Mapping

Class Mapping errors
App\Entity\Competition No errors.
App\Entity\Sport No errors.
App\Entity\Round No errors.
App\Entity\Competitor No errors.
App\Entity\Game No errors.
App\Entity\UserCompetition No errors.
App\Entity\League No errors.
App\Entity\Participant No errors.