Query Metrics
8
Database Queries
6
Different statements
73.10 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
66.45 ms (90.90%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.code AS code_3, t0.active AS active_4, t0.nickname AS nickname_5, t0.createdat AS createdat_6, t0.lastlogin AS lastlogin_7, t0.avatar AS avatar_8, t0.awards AS awards_9 FROM user t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"161"
]
|
||||||||||||||||||||||||
2.54 ms (3.47%) |
1 |
SELECT q2.id AS quizid, q2.gametype, ua.userid_id AS userid, IF(u.nickname IS NULL OR u.nickname = '','Anonymus',u.nickname) AS nickname, SUM(q.points) AS highscore_points FROM user_answers ua LEFT JOIN questions q ON ua.questionid_id = q.id LEFT JOIN user u ON ua.userid_id = u.id LEFT JOIN quiz q2 ON q.quizid_id = q2.id WHERE ua.answered_correctly = 1 AND (q2.gametype = 'single') GROUP BY ua.userid_id ORDER BY highscore_points DESC;
Parameters:
[]
|
||||||||||||||||||||||||
1.55 ms (2.12%) |
1 |
SELECT q2.id AS quizid, q2.gametype, ua.userid_id AS userid, IF(u.nickname IS NULL OR u.nickname = '','Anonymus',u.nickname) AS nickname, SUM(q.points) AS highscore_points FROM user_answers ua LEFT JOIN questions q ON ua.questionid_id = q.id LEFT JOIN user u ON ua.userid_id = u.id LEFT JOIN quiz q2 ON q.quizid_id = q2.id WHERE ua.answered_correctly = 1 AND q2.gametype = 'blitz' GROUP BY ua.userid_id ORDER BY highscore_points DESC;
Parameters:
[]
|
||||||||||||||||||||||||
1.31 ms (1.80%) |
3 |
SELECT u.id, ut.teams_id, IF(u.nickname IS NULL OR u.nickname = '','Anonymus',u.nickname) AS nickname FROM user_teams ut LEFT JOIN `user` u ON ut.user_id = u.id WHERE ut.teams_id = ?;
Parameters:
[
2
]
|
||||||||||||||||||||||||
0.73 ms (0.99%) |
1 |
SELECT ua.teamid_id AS teamid, t.teamname, SUM(q.points) AS highscore_points FROM user_answers ua LEFT JOIN questions q ON ua.questionid_id = q.id LEFT JOIN quiz q2 ON q.quizid_id = q2.id LEFT JOIN teams t ON t.id = ua.teamid_id WHERE ua.answered_correctly = 1 AND q2.gametype = 'multi' AND ua.teamid_id IS NOT NULL GROUP BY ua.teamid_id ORDER BY highscore_points DESC;
Parameters:
[]
|
||||||||||||||||||||||||
0.53 ms (0.72%) |
1 |
SELECT * FROM `user_answers` WHERE `userid_id` = 161
Parameters:
[]
|
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\User | No errors. |
App\Entity\UserAnswers | No errors. |
App\Entity\Teams | No errors. |