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

Query Metrics

19 Database Queries
4 Different statements
3.40 ms Query time
0 Invalid entities
469 Managed entities

Queries

Group similar statements

# Time Info
1 0.34 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:
[
  "4"
]
2 0.26 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.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:
[]
4 0.31 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:
[
  4
  1393
]
5 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 WHERE t0.competition_id = ? AND t0.api_id = ? LIMIT 1
Parameters:
[
  4
  569
]
6 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:
[
  4
  735
]
7 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:
[
  4
  631
]
8 0.23 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:
[
  4
  266
]
9 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:
[
  4
  554
]
10 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:
[
  4
  742
]
11 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:
[
  4
  733
]
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:
[
  4
  261
]
13 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:
[
  4
  740
]
14 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:
[
  4
  736
]
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:
[
  4
  260
]
16 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:
[
  4
  600
]
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:
[
  4
  741
]
18 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:
[
  4
  5902
]
19 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:
[
  4
  6215
]

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.