GET https://ctfpanel.adrardev.fr/score/all

Query Metrics

45 Database Queries
3 Different statements
18.16 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.12 ms
SELECT t0.id AS id_1, t0.date_score AS date_score_2, t0.participant_id AS participant_id_3 FROM score t0
Parameters:
[]
2 0.43 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  39
]
3 1.38 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  29
]
4 0.29 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  40
]
5 0.34 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  31
]
6 0.28 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  41
]
7 0.37 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  32
]
8 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  42
]
9 0.37 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  33
]
10 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  43
]
11 0.30 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  34
]
12 0.26 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  45
]
13 0.30 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  35
]
14 0.29 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  46
]
15 0.30 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  36
]
16 0.25 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  47
]
17 0.29 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  37
]
18 0.24 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  48
]
19 0.29 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  38
]
20 0.24 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  49
]
21 0.30 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  39
]
22 0.24 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  50
]
23 0.40 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  40
]
24 0.41 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  51
]
25 0.55 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  41
]
26 0.94 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  56
]
27 0.69 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  42
]
28 0.51 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  57
]
29 0.59 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  43
]
30 0.48 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  59
]
31 0.50 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  44
]
32 0.37 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  60
]
33 0.44 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  45
]
34 0.34 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  61
]
35 0.41 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  46
]
36 0.32 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  62
]
37 0.36 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  47
]
38 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  65
]
39 0.40 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  48
]
40 0.28 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  67
]
41 0.38 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  49
]
42 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  68
]
43 0.30 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  50
]
44 0.24 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.login AS login_4, t0.active AS active_5 FROM participant t0 WHERE t0.id = ?
Parameters:
[
  69
]
45 0.28 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.valeur AS valeur_3, t0.description AS description_4 FROM flag t0 INNER JOIN score_flag ON t0.id = score_flag.flag_id WHERE score_flag.score_id = ?
Parameters:
[
  51
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Score No errors.
App\Entity\Participant No errors.
App\Entity\Flag No errors.