Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

5.71 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.94 ms
(34.02%)

SELECT u0_.id AS id_0, u0_.registered_at AS registered_at_1, u0_.last_login_at AS last_login_at_2, u0_.nickname AS nickname_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.email AS email_6, u0_.is_verified AS is_verified_7, u0_.google_id AS google_id_8, u0_.first_name AS first_name_9, u0_.last_name AS last_name_10, u0_.date_of_birth AS date_of_birth_11, u0_.avatar_filename AS avatar_filename_12, u0_.updated_at AS updated_at_13, u0_.notification_settings AS notification_settings_14, u0_.is_profile_private AS is_profile_private_15, COUNT(u1_.id) AS sclr_16 FROM users u0_ INNER JOIN user_followers u2_ ON u0_.id = u2_.user_target INNER JOIN users u1_ ON u1_.id = u2_.user_source GROUP BY u0_.id ORDER BY sclr_16 DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.registered_at AS registered_at_1,
  u0_.last_login_at AS last_login_at_2,
  u0_.nickname AS nickname_3,
  u0_.roles AS roles_4,
  u0_.password AS password_5,
  u0_.email AS email_6,
  u0_.is_verified AS is_verified_7,
  u0_.google_id AS google_id_8,
  u0_.first_name AS first_name_9,
  u0_.last_name AS last_name_10,
  u0_.date_of_birth AS date_of_birth_11,
  u0_.avatar_filename AS avatar_filename_12,
  u0_.updated_at AS updated_at_13,
  u0_.notification_settings AS notification_settings_14,
  u0_.is_profile_private AS is_profile_private_15,
  COUNT(u1_.id) AS sclr_16
FROM
  users u0_
  INNER JOIN user_followers u2_ ON u0_.id = u2_.user_target
  INNER JOIN users u1_ ON u1_.id = u2_.user_source
GROUP BY
  u0_.id
ORDER BY
  sclr_16 DESC
LIMIT
  10

SELECT u0_.id AS id_0, u0_.registered_at AS registered_at_1, u0_.last_login_at AS last_login_at_2, u0_.nickname AS nickname_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.email AS email_6, u0_.is_verified AS is_verified_7, u0_.google_id AS google_id_8, u0_.first_name AS first_name_9, u0_.last_name AS last_name_10, u0_.date_of_birth AS date_of_birth_11, u0_.avatar_filename AS avatar_filename_12, u0_.updated_at AS updated_at_13, u0_.notification_settings AS notification_settings_14, u0_.is_profile_private AS is_profile_private_15, COUNT(u1_.id) AS sclr_16 FROM users u0_ INNER JOIN user_followers u2_ ON u0_.id = u2_.user_target INNER JOIN users u1_ ON u1_.id = u2_.user_source GROUP BY u0_.id ORDER BY sclr_16 DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 301)
7	App\Repository\UsersRepository->findTopByFollowers (line 73)
8	App\Controller\StatsController->topUsers (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.42 ms
(24.79%)

SELECT u0_.id AS id_0, u0_.registered_at AS registered_at_1, u0_.last_login_at AS last_login_at_2, u0_.nickname AS nickname_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.email AS email_6, u0_.is_verified AS is_verified_7, u0_.google_id AS google_id_8, u0_.first_name AS first_name_9, u0_.last_name AS last_name_10, u0_.date_of_birth AS date_of_birth_11, u0_.avatar_filename AS avatar_filename_12, u0_.updated_at AS updated_at_13, u0_.notification_settings AS notification_settings_14, u0_.is_profile_private AS is_profile_private_15, COUNT(b1_.id) AS sclr_16 FROM users u0_ INNER JOIN user_ludotheque_games u2_ ON u0_.id = u2_.users_id INNER JOIN bgg_boardgame b1_ ON b1_.id = u2_.boardgame_id GROUP BY u0_.id ORDER BY sclr_16 DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.registered_at AS registered_at_1,
  u0_.last_login_at AS last_login_at_2,
  u0_.nickname AS nickname_3,
  u0_.roles AS roles_4,
  u0_.password AS password_5,
  u0_.email AS email_6,
  u0_.is_verified AS is_verified_7,
  u0_.google_id AS google_id_8,
  u0_.first_name AS first_name_9,
  u0_.last_name AS last_name_10,
  u0_.date_of_birth AS date_of_birth_11,
  u0_.avatar_filename AS avatar_filename_12,
  u0_.updated_at AS updated_at_13,
  u0_.notification_settings AS notification_settings_14,
  u0_.is_profile_private AS is_profile_private_15,
  COUNT(b1_.id) AS sclr_16
FROM
  users u0_
  INNER JOIN user_ludotheque_games u2_ ON u0_.id = u2_.users_id
  INNER JOIN bgg_boardgame b1_ ON b1_.id = u2_.boardgame_id
GROUP BY
  u0_.id
ORDER BY
  sclr_16 DESC
LIMIT
  10

SELECT u0_.id AS id_0, u0_.registered_at AS registered_at_1, u0_.last_login_at AS last_login_at_2, u0_.nickname AS nickname_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.email AS email_6, u0_.is_verified AS is_verified_7, u0_.google_id AS google_id_8, u0_.first_name AS first_name_9, u0_.last_name AS last_name_10, u0_.date_of_birth AS date_of_birth_11, u0_.avatar_filename AS avatar_filename_12, u0_.updated_at AS updated_at_13, u0_.notification_settings AS notification_settings_14, u0_.is_profile_private AS is_profile_private_15, COUNT(b1_.id) AS sclr_16 FROM users u0_ INNER JOIN user_ludotheque_games u2_ ON u0_.id = u2_.users_id INNER JOIN bgg_boardgame b1_ ON b1_.id = u2_.boardgame_id GROUP BY u0_.id ORDER BY sclr_16 DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 325)
7	App\Repository\UsersRepository->findTopByLudothequeSize (line 75)
8	App\Controller\StatsController->topUsers (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.19 ms
(20.90%)

SELECT u0_.id AS id_0, u0_.registered_at AS registered_at_1, u0_.last_login_at AS last_login_at_2, u0_.nickname AS nickname_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.email AS email_6, u0_.is_verified AS is_verified_7, u0_.google_id AS google_id_8, u0_.first_name AS first_name_9, u0_.last_name AS last_name_10, u0_.date_of_birth AS date_of_birth_11, u0_.avatar_filename AS avatar_filename_12, u0_.updated_at AS updated_at_13, u0_.notification_settings AS notification_settings_14, u0_.is_profile_private AS is_profile_private_15, COUNT(b1_.id) AS sclr_16 FROM users u0_ INNER JOIN bgg_forum_post b1_ ON u0_.id = b1_.author_id WHERE b1_.is_deleted = 0 GROUP BY u0_.id ORDER BY sclr_16 DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.registered_at AS registered_at_1,
  u0_.last_login_at AS last_login_at_2,
  u0_.nickname AS nickname_3,
  u0_.roles AS roles_4,
  u0_.password AS password_5,
  u0_.email AS email_6,
  u0_.is_verified AS is_verified_7,
  u0_.google_id AS google_id_8,
  u0_.first_name AS first_name_9,
  u0_.last_name AS last_name_10,
  u0_.date_of_birth AS date_of_birth_11,
  u0_.avatar_filename AS avatar_filename_12,
  u0_.updated_at AS updated_at_13,
  u0_.notification_settings AS notification_settings_14,
  u0_.is_profile_private AS is_profile_private_15,
  COUNT(b1_.id) AS sclr_16
FROM
  users u0_
  INNER JOIN bgg_forum_post b1_ ON u0_.id = b1_.author_id
WHERE
  b1_.is_deleted = 0
GROUP BY
  u0_.id
ORDER BY
  sclr_16 DESC
LIMIT
  10

SELECT u0_.id AS id_0, u0_.registered_at AS registered_at_1, u0_.last_login_at AS last_login_at_2, u0_.nickname AS nickname_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.email AS email_6, u0_.is_verified AS is_verified_7, u0_.google_id AS google_id_8, u0_.first_name AS first_name_9, u0_.last_name AS last_name_10, u0_.date_of_birth AS date_of_birth_11, u0_.avatar_filename AS avatar_filename_12, u0_.updated_at AS updated_at_13, u0_.notification_settings AS notification_settings_14, u0_.is_profile_private AS is_profile_private_15, COUNT(b1_.id) AS sclr_16 FROM users u0_ INNER JOIN bgg_forum_post b1_ ON u0_.id = b1_.author_id WHERE b1_.is_deleted = 0 GROUP BY u0_.id ORDER BY sclr_16 DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 338)
7	App\Repository\UsersRepository->findTopByForumPosts (line 76)
8	App\Controller\StatsController->topUsers (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.16 ms
(20.29%)

SELECT u0_.id AS id_0, u0_.registered_at AS registered_at_1, u0_.last_login_at AS last_login_at_2, u0_.nickname AS nickname_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.email AS email_6, u0_.is_verified AS is_verified_7, u0_.google_id AS google_id_8, u0_.first_name AS first_name_9, u0_.last_name AS last_name_10, u0_.date_of_birth AS date_of_birth_11, u0_.avatar_filename AS avatar_filename_12, u0_.updated_at AS updated_at_13, u0_.notification_settings AS notification_settings_14, u0_.is_profile_private AS is_profile_private_15, COUNT(b1_.id) AS sclr_16 FROM users u0_ INNER JOIN bgg_review b1_ ON u0_.id = b1_.author_id GROUP BY u0_.id ORDER BY sclr_16 DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.registered_at AS registered_at_1,
  u0_.last_login_at AS last_login_at_2,
  u0_.nickname AS nickname_3,
  u0_.roles AS roles_4,
  u0_.password AS password_5,
  u0_.email AS email_6,
  u0_.is_verified AS is_verified_7,
  u0_.google_id AS google_id_8,
  u0_.first_name AS first_name_9,
  u0_.last_name AS last_name_10,
  u0_.date_of_birth AS date_of_birth_11,
  u0_.avatar_filename AS avatar_filename_12,
  u0_.updated_at AS updated_at_13,
  u0_.notification_settings AS notification_settings_14,
  u0_.is_profile_private AS is_profile_private_15,
  COUNT(b1_.id) AS sclr_16
FROM
  users u0_
  INNER JOIN bgg_review b1_ ON u0_.id = b1_.author_id
GROUP BY
  u0_.id
ORDER BY
  sclr_16 DESC
LIMIT
  10

SELECT u0_.id AS id_0, u0_.registered_at AS registered_at_1, u0_.last_login_at AS last_login_at_2, u0_.nickname AS nickname_3, u0_.roles AS roles_4, u0_.password AS password_5, u0_.email AS email_6, u0_.is_verified AS is_verified_7, u0_.google_id AS google_id_8, u0_.first_name AS first_name_9, u0_.last_name AS last_name_10, u0_.date_of_birth AS date_of_birth_11, u0_.avatar_filename AS avatar_filename_12, u0_.updated_at AS updated_at_13, u0_.notification_settings AS notification_settings_14, u0_.is_profile_private AS is_profile_private_15, COUNT(b1_.id) AS sclr_16 FROM users u0_ INNER JOIN bgg_review b1_ ON u0_.id = b1_.author_id GROUP BY u0_.id ORDER BY sclr_16 DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 313)
7	App\Repository\UsersRepository->findTopByReviews (line 74)
8	App\Controller\StatsController->topUsers (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Users	1

Entities Mapping

Class	Mapping errors
App\Entity\Users	No errors.
App\Entity\Boardgame\Review	No errors.
App\Entity\Boardgame\Boardgame	No errors.
App\Entity\Boardgame\ForumThread	No errors.
App\Entity\Boardgame\ForumPost	No errors.
App\Entity\Boardgame\BoardgameFile	No errors.
App\Entity\Boardgame\BgCollection	No errors.
App\Entity\Boardgame\PlaySession	No errors.
App\Entity\Boardgame\ReviewComment	No errors.
App\Entity\Boardgame\Notification	No errors.
App\Entity\MessageThread	No errors.
App\Entity\Message	No errors.
App\Entity\Boardgame\Tournament	No errors.
App\Entity\Feedback	No errors.
App\Entity\Activity	No errors.
App\Entity\UserBadge	No errors.
App\Entity\Report	No errors.
App\Entity\Boardgame\BoardgameImage	No errors.

Symfony Profiler

GET https://jeux.sifflote.fr/stats/top-utilisateurs

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping