GET https://kfquiz.kompetenzz.net/nutzer?id=161

Query Metrics

8 Database Queries
6 Different statements
73.10 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.