GET https://dev.odarts.blue.bzh/classement/individuel

Query Metrics

19 Database Queries
4 Different statements
1.54 ms Query time
0 Invalid entities
89 Managed entities

Queries

Group similar statements

# Time Info
1 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.format AS format_3, t0.start_at AS start_at_4, t0.finish_at AS finish_at_5, t0.is_locked AS is_locked_6, t0.nb_targets AS nb_targets_7, t0.nb_poule AS nb_poule_8, t0.players_per_poule AS players_per_poule_9, t0.min_players AS min_players_10, t0.max_players AS max_players_11, t0.is_full AS is_full_12, t0.slot_duration AS slot_duration_13, t0.break_duration AS break_duration_14, t0.max_manches_poule AS max_manches_poule_15, t0.max_manches_finale AS max_manches_finale_16, t0.current_step AS current_step_17, t0.organizer_name AS organizer_name_18 FROM tournament t0 WHERE t0.format = ? ORDER BY t0.start_at DESC LIMIT 1
Parameters:
[
  "individuel"
]
2 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.format AS format_3, t0.start_at AS start_at_4, t0.finish_at AS finish_at_5, t0.is_locked AS is_locked_6, t0.nb_targets AS nb_targets_7, t0.nb_poule AS nb_poule_8, t0.players_per_poule AS players_per_poule_9, t0.min_players AS min_players_10, t0.max_players AS max_players_11, t0.is_full AS is_full_12, t0.slot_duration AS slot_duration_13, t0.break_duration AS break_duration_14, t0.max_manches_poule AS max_manches_poule_15, t0.max_manches_finale AS max_manches_finale_16, t0.current_step AS current_step_17, t0.organizer_name AS organizer_name_18 FROM tournament t0 WHERE t0.format = ? ORDER BY t0.start_at DESC LIMIT 1
Parameters:
[
  "individuel"
]
3 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_locked AS is_locked_3, t0.tournament_id AS tournament_id_4 FROM poule t0 WHERE t0.tournament_id = ?
Parameters:
[
  1
]
4 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.rating AS rating_3, t0.level AS level_4, t0.is_paid AS is_paid_5, t0.is_coming AS is_coming_6, t0.tournament_id AS tournament_id_7, t0.poule_id AS poule_id_8 FROM participant t0 WHERE t0.poule_id = ?
Parameters:
[
  113
]
5 0.12 ms
SELECT t0.id AS id_1, t0.slot_start AS slot_start_2, t0.slot_end AS slot_end_3, t0.status AS status_4, t0.score_a AS score_a_5, t0.score_b AS score_b_6, t0.round_index AS round_index_7, t0.display_order AS display_order_8, t0.target AS target_9, t0.tournament_id AS tournament_id_10, t0.poule_id AS poule_id_11, t0.participant_a_id AS participant_a_id_12, t0.participant_b_id AS participant_b_id_13 FROM match_game t0 WHERE t0.poule_id = ?
Parameters:
[
  113
]
6 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.rating AS rating_3, t0.level AS level_4, t0.is_paid AS is_paid_5, t0.is_coming AS is_coming_6, t0.tournament_id AS tournament_id_7, t0.poule_id AS poule_id_8 FROM participant t0 WHERE t0.poule_id = ?
Parameters:
[
  114
]
7 0.07 ms
SELECT t0.id AS id_1, t0.slot_start AS slot_start_2, t0.slot_end AS slot_end_3, t0.status AS status_4, t0.score_a AS score_a_5, t0.score_b AS score_b_6, t0.round_index AS round_index_7, t0.display_order AS display_order_8, t0.target AS target_9, t0.tournament_id AS tournament_id_10, t0.poule_id AS poule_id_11, t0.participant_a_id AS participant_a_id_12, t0.participant_b_id AS participant_b_id_13 FROM match_game t0 WHERE t0.poule_id = ?
Parameters:
[
  114
]
8 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.rating AS rating_3, t0.level AS level_4, t0.is_paid AS is_paid_5, t0.is_coming AS is_coming_6, t0.tournament_id AS tournament_id_7, t0.poule_id AS poule_id_8 FROM participant t0 WHERE t0.poule_id = ?
Parameters:
[
  115
]
9 0.07 ms
SELECT t0.id AS id_1, t0.slot_start AS slot_start_2, t0.slot_end AS slot_end_3, t0.status AS status_4, t0.score_a AS score_a_5, t0.score_b AS score_b_6, t0.round_index AS round_index_7, t0.display_order AS display_order_8, t0.target AS target_9, t0.tournament_id AS tournament_id_10, t0.poule_id AS poule_id_11, t0.participant_a_id AS participant_a_id_12, t0.participant_b_id AS participant_b_id_13 FROM match_game t0 WHERE t0.poule_id = ?
Parameters:
[
  115
]
10 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.rating AS rating_3, t0.level AS level_4, t0.is_paid AS is_paid_5, t0.is_coming AS is_coming_6, t0.tournament_id AS tournament_id_7, t0.poule_id AS poule_id_8 FROM participant t0 WHERE t0.poule_id = ?
Parameters:
[
  116
]
11 0.07 ms
SELECT t0.id AS id_1, t0.slot_start AS slot_start_2, t0.slot_end AS slot_end_3, t0.status AS status_4, t0.score_a AS score_a_5, t0.score_b AS score_b_6, t0.round_index AS round_index_7, t0.display_order AS display_order_8, t0.target AS target_9, t0.tournament_id AS tournament_id_10, t0.poule_id AS poule_id_11, t0.participant_a_id AS participant_a_id_12, t0.participant_b_id AS participant_b_id_13 FROM match_game t0 WHERE t0.poule_id = ?
Parameters:
[
  116
]
12 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.rating AS rating_3, t0.level AS level_4, t0.is_paid AS is_paid_5, t0.is_coming AS is_coming_6, t0.tournament_id AS tournament_id_7, t0.poule_id AS poule_id_8 FROM participant t0 WHERE t0.poule_id = ?
Parameters:
[
  117
]
13 0.06 ms
SELECT t0.id AS id_1, t0.slot_start AS slot_start_2, t0.slot_end AS slot_end_3, t0.status AS status_4, t0.score_a AS score_a_5, t0.score_b AS score_b_6, t0.round_index AS round_index_7, t0.display_order AS display_order_8, t0.target AS target_9, t0.tournament_id AS tournament_id_10, t0.poule_id AS poule_id_11, t0.participant_a_id AS participant_a_id_12, t0.participant_b_id AS participant_b_id_13 FROM match_game t0 WHERE t0.poule_id = ?
Parameters:
[
  117
]
14 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.rating AS rating_3, t0.level AS level_4, t0.is_paid AS is_paid_5, t0.is_coming AS is_coming_6, t0.tournament_id AS tournament_id_7, t0.poule_id AS poule_id_8 FROM participant t0 WHERE t0.poule_id = ?
Parameters:
[
  118
]
15 0.07 ms
SELECT t0.id AS id_1, t0.slot_start AS slot_start_2, t0.slot_end AS slot_end_3, t0.status AS status_4, t0.score_a AS score_a_5, t0.score_b AS score_b_6, t0.round_index AS round_index_7, t0.display_order AS display_order_8, t0.target AS target_9, t0.tournament_id AS tournament_id_10, t0.poule_id AS poule_id_11, t0.participant_a_id AS participant_a_id_12, t0.participant_b_id AS participant_b_id_13 FROM match_game t0 WHERE t0.poule_id = ?
Parameters:
[
  118
]
16 0.07 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.rating AS rating_3, t0.level AS level_4, t0.is_paid AS is_paid_5, t0.is_coming AS is_coming_6, t0.tournament_id AS tournament_id_7, t0.poule_id AS poule_id_8 FROM participant t0 WHERE t0.poule_id = ?
Parameters:
[
  119
]
17 0.06 ms
SELECT t0.id AS id_1, t0.slot_start AS slot_start_2, t0.slot_end AS slot_end_3, t0.status AS status_4, t0.score_a AS score_a_5, t0.score_b AS score_b_6, t0.round_index AS round_index_7, t0.display_order AS display_order_8, t0.target AS target_9, t0.tournament_id AS tournament_id_10, t0.poule_id AS poule_id_11, t0.participant_a_id AS participant_a_id_12, t0.participant_b_id AS participant_b_id_13 FROM match_game t0 WHERE t0.poule_id = ?
Parameters:
[
  119
]
18 0.06 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.rating AS rating_3, t0.level AS level_4, t0.is_paid AS is_paid_5, t0.is_coming AS is_coming_6, t0.tournament_id AS tournament_id_7, t0.poule_id AS poule_id_8 FROM participant t0 WHERE t0.poule_id = ?
Parameters:
[
  120
]
19 0.08 ms
SELECT t0.id AS id_1, t0.slot_start AS slot_start_2, t0.slot_end AS slot_end_3, t0.status AS status_4, t0.score_a AS score_a_5, t0.score_b AS score_b_6, t0.round_index AS round_index_7, t0.display_order AS display_order_8, t0.target AS target_9, t0.tournament_id AS tournament_id_10, t0.poule_id AS poule_id_11, t0.participant_a_id AS participant_a_id_12, t0.participant_b_id AS participant_b_id_13 FROM match_game t0 WHERE t0.poule_id = ?
Parameters:
[
  120
]

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\MatchGame 48
App\Entity\Participant 32
App\Entity\Poule 8
App\Entity\Tournament 1

Entities Mapping

Class Mapping errors
App\Entity\Tournament No errors.
App\Entity\Poule No errors.
App\Entity\Participant No errors.
App\Entity\MatchGame No errors.
App\Entity\Bracket No errors.