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

Response
200 OK
IP
172.18.0.2
Profiled on
Token
53e1ad

Query Metrics

35 Database Queries
4 Different statements
5.29 ms Query time
0 Invalid entities
469 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.27 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: 
[
  "1"
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.22 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: 
[
  3
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.25 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.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: 
[
  1
  "17"
]
View formatted query    View runnable query    Explain query    View query backtrace
5 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: 
[
  1
  "30"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.18 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: 
[
  1
  "23"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 0.15 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: 
[
  1
  "34"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 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: 
[
  1
  "2"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 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: 
[
  1
  "24"
]
View formatted query    View runnable query    Explain query    View query backtrace
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: 
[
  1
  "11"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 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: 
[
  1
  "33"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 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: 
[
  1
  "15"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 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: 
[
  1
  "4"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 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: 
[
  1
  "12"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 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: 
[
  1
  "5"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 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: 
[
  1
  "13"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 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: 
[
  1
  "20"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 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: 
[
  1
  "10"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 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: 
[
  1
  "7"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 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: 
[
  1
  "3"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 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: 
[
  1
  "21"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 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: 
[
  1
  "29"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 1.01 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: 
[
  1
  "14"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 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: 
[
  1
  "25"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 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: 
[
  1
  "9"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 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: 
[
  1
  "16"
]
View formatted query    View runnable query    Explain query    View query backtrace
27 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: 
[
  1
  "8"
]
View formatted query    View runnable query    Explain query    View query backtrace
28 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: 
[
  1
  "27"
]
View formatted query    View runnable query    Explain query    View query backtrace
29 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: 
[
  1
  "1"
]
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: 
[
  1
  "6"
]
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: 
[
  1
  "18"
]
View formatted query    View runnable query    Explain query    View query backtrace
32 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: 
[
  1
  "28"
]
View formatted query    View runnable query    Explain query    View query backtrace
33 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: 
[
  1
  "19"
]
View formatted query    View runnable query    Explain query    View query backtrace
34 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: 
[
  1
  "22"
]
View formatted query    View runnable query    Explain query    View query backtrace
35 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: 
[
  1
  "26"
]
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.