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

Response
200 OK
IP
172.18.0.2
Profiled on
Token
7442eb

Query Metrics

39 Database Queries
4 Different statements
5.44 ms Query time
0 Invalid entities
469 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.36 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: 
[
  "2"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.17 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
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.29 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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 0.27 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: 
[
  2
  42
]
View formatted query    View runnable query    Explain query    View query backtrace
5 0.13 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: 
[
  2
  157
]
View formatted query    View runnable query    Explain query    View query backtrace
6 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: 
[
  2
  40
]
View formatted query    View runnable query    Explain query    View query backtrace
7 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: 
[
  2
  47
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  2
  529
]
View formatted query    View runnable query    Explain query    View query backtrace
9 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: 
[
  2
  49
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.20 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: 
[
  2
  228
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.17 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: 
[
  2
  50
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.13 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: 
[
  2
  541
]
View formatted query    View runnable query    Explain query    View query backtrace
13 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: 
[
  2
  505
]
View formatted query    View runnable query    Explain query    View query backtrace
14 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: 
[
  2
  85
]
View formatted query    View runnable query    Explain query    View query backtrace
15 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: 
[
  2
  34
]
View formatted query    View runnable query    Explain query    View query backtrace
16 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: 
[
  2
  496
]
View formatted query    View runnable query    Explain query    View query backtrace
17 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: 
[
  2
  530
]
View formatted query    View runnable query    Explain query    View query backtrace
18 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: 
[
  2
  499
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.13 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: 
[
  2
  168
]
View formatted query    View runnable query    Explain query    View query backtrace
20 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: 
[
  2
  165
]
View formatted query    View runnable query    Explain query    View query backtrace
21 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: 
[
  2
  553
]
View formatted query    View runnable query    Explain query    View query backtrace
22 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: 
[
  2
  569
]
View formatted query    View runnable query    Explain query    View query backtrace
23 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: 
[
  2
  645
]
View formatted query    View runnable query    Explain query    View query backtrace
24 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: 
[
  2
  91
]
View formatted query    View runnable query    Explain query    View query backtrace
25 0.17 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: 
[
  2
  556
]
View formatted query    View runnable query    Explain query    View query backtrace
26 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: 
[
  2
  327
]
View formatted query    View runnable query    Explain query    View query backtrace
27 0.16 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: 
[
  2
  211
]
View formatted query    View runnable query    Explain query    View query backtrace
28 0.20 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: 
[
  2
  81
]
View formatted query    View runnable query    Explain query    View query backtrace
29 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: 
[
  2
  3403
]
View formatted query    View runnable query    Explain query    View query backtrace
30 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: 
[
  2
  1393
]
View formatted query    View runnable query    Explain query    View query backtrace
31 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: 
[
  2
  197
]
View formatted query    View runnable query    Explain query    View query backtrace
32 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: 
[
  2
  531
]
View formatted query    View runnable query    Explain query    View query backtrace
33 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: 
[
  2
  492
]
View formatted query    View runnable query    Explain query    View query backtrace
34 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: 
[
  2
  400
]
View formatted query    View runnable query    Explain query    View query backtrace
35 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: 
[
  2
  194
]
View formatted query    View runnable query    Explain query    View query backtrace
36 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: 
[
  2
  169
]
View formatted query    View runnable query    Explain query    View query backtrace
37 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: 
[
  2
  560
]
View formatted query    View runnable query    Explain query    View query backtrace
38 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: 
[
  2
  533
]
View formatted query    View runnable query    Explain query    View query backtrace
39 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: 
[
  2
  664
]
View formatted query    View runnable query    Explain query    View query backtrace

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.