Symfony Profiler

Last 10 Latest Search

Method

Status

URL

Token

From

Until

Results

Profiler settings

Query Metrics

621 Database Queries

4 Different statements

248.02 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

172.10 ms
(69.39%)

618

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 = ?

Parameters:

[
  1744
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 1744;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 195)
7	App\Controller\IndexController->index (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

46.66 ms
(18.81%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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;

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;;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 227)
2	App\Service\Utilities->getHighscoreSingleMode (line 115)
3	App\Controller\IndexController->index (line 178)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

28.42 ms
(11.46%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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;

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;;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 266)
2	App\Service\Utilities->getHighscoreBlitzMode (line 116)
3	App\Controller\IndexController->index (line 178)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

0.83 ms
(0.34%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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;

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;;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 338)
2	App\Service\Utilities->getHighscoreTeamMode (line 134)
3	App\Controller\IndexController->index (line 178)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	require_once (line 5)

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.

Symfony Profiler

GET https://kfquiz.kompetenzz.net/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping