Symfony Profiler

Query Metrics

33 Database Queries

5 Different statements

54.69 ms Query time

1 Invalid entities

53 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

25.66 ms
(46.92%)

SELECT t0.id AS id_1, t0.description AS description_2, t0.public AS public_3, t0.world AS world_4, t0.title AS title_5, t0.start_latitude AS start_latitude_6, t0.start_longitude AS start_longitude_7, t0.start_city AS start_city_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.cost AS cost_13, t11.participants_limit AS participants_limit_14, t11.hunt_id AS hunt_id_15, t0.organizer_id AS organizer_id_16, t17.id AS id_18, t17.latitude AS latitude_19, t17.longitude AS longitude_20, t17.radius AS radius_21, t17.hunt_id AS hunt_id_22 FROM hunt t0 LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id LEFT JOIN landmark t17 ON t17.hunt_id = t0.id INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id WHERE participant_hunt.participant_id = ?

Parameters:

[
  264
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.public AS public_3,
  t0.world AS world_4,
  t0.title AS title_5,
  t0.start_latitude AS start_latitude_6,
  t0.start_longitude AS start_longitude_7,
  t0.start_city AS start_city_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t11.id AS id_12,
  t11.cost AS cost_13,
  t11.participants_limit AS participants_limit_14,
  t11.hunt_id AS hunt_id_15,
  t0.organizer_id AS organizer_id_16,
  t17.id AS id_18,
  t17.latitude AS latitude_19,
  t17.longitude AS longitude_20,
  t17.radius AS radius_21,
  t17.hunt_id AS hunt_id_22
FROM
  hunt t0
  LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id
  LEFT JOIN landmark t17 ON t17.hunt_id = t0.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id
WHERE
  participant_hunt.participant_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.public AS public_3, t0.world AS world_4, t0.title AS title_5, t0.start_latitude AS start_latitude_6, t0.start_longitude AS start_longitude_7, t0.start_city AS start_city_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.cost AS cost_13, t11.participants_limit AS participants_limit_14, t11.hunt_id AS hunt_id_15, t0.organizer_id AS organizer_id_16, t17.id AS id_18, t17.latitude AS latitude_19, t17.longitude AS longitude_20, t17.radius AS radius_21, t17.hunt_id AS hunt_id_22 FROM hunt t0 LEFT JOIN participation_condition t11 ON t11.hunt_id = t0.id LEFT JOIN landmark t17 ON t17.hunt_id = t0.id INNER JOIN participant_hunt ON t0.id = participant_hunt.hunt_id WHERE participant_hunt.participant_id = 264;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2737)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_b4d225b1419530dd79e80890c8c3c821::block_body (line 369)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_bab945b757f79136cce4f54d294ec0a2->doDisplay (line 202)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_b4d225b1419530dd79e80890c8c3c821->doDisplay (line 56)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\Participant\LeaderboardController->index (line 33)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

18.01 ms
(32.93%)

SELECT t0.id AS id_1, t0.obtained_at AS obtained_at_2, t0.participant_id AS participant_id_3, t0.badge_id AS badge_id_4 FROM participant_badge t0 WHERE t0.participant_id = ?

Parameters:

[
  264
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.obtained_at AS obtained_at_2,
  t0.participant_id AS participant_id_3,
  t0.badge_id AS badge_id_4
FROM
  participant_badge t0
WHERE
  t0.participant_id = ?

SELECT t0.id AS id_1, t0.obtained_at AS obtained_at_2, t0.participant_id AS participant_id_3, t0.badge_id AS badge_id_4 FROM participant_badge t0 WHERE t0.participant_id = 264;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 41)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	Twig\Extension\CoreExtension->length (line 1278)
9	__TwigTemplate_b4d225b1419530dd79e80890c8c3c821::block_body (line 370)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_bab945b757f79136cce4f54d294ec0a2->doDisplay (line 202)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_b4d225b1419530dd79e80890c8c3c821->doDisplay (line 56)
14	Twig\Template->yield (line 411)
15	Twig\Template->display (line 366)
16	Twig\Template->render (line 381)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
22	App\Controller\Participant\LeaderboardController->index (line 33)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 208)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

4.44 ms
(8.11%)

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM participant p1_ INNER JOIN user u0_ ON p1_.id = u0_.id LEFT JOIN participant_hunt p3_ ON p1_.id = p3_.participant_id LEFT JOIN hunt h2_ ON h2_.id = p3_.hunt_id LEFT JOIN participant_badge p4_ ON p1_.id = p4_.participant_id GROUP BY u0_.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  participant p1_
  INNER JOIN user u0_ ON p1_.id = u0_.id
  LEFT JOIN participant_hunt p3_ ON p1_.id = p3_.participant_id
  LEFT JOIN hunt h2_ ON h2_.id = p3_.hunt_id
  LEFT JOIN participant_badge p4_ ON p1_.id = p4_.participant_id
GROUP BY
  u0_.id

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM participant p1_ INNER JOIN user u0_ ON p1_.id = u0_.id LEFT JOIN participant_hunt p3_ ON p1_.id = p3_.participant_id LEFT JOIN hunt h2_ ON h2_.id = p3_.hunt_id LEFT JOIN participant_badge p4_ ON p1_.id = p4_.participant_id GROUP BY u0_.id;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 96)
7	count (line 43)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 43)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerGjGcN20\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\Participant\LeaderboardController->index (line 27)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

3.71 ms
(6.78%)

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.firstname AS firstname_2, u0_.lastname AS lastname_3, u0_.mail_address AS mail_address_4, u0_.password AS password_5, u0_.created AS created_6, u0_.updated AS updated_7, p1_.crowns AS crowns_8, p1_.completed_hunts_count AS completed_hunts_count_9, p1_.avatar_path AS avatar_path_10, COUNT(DISTINCT h2_.id) AS sclr_11, COUNT(DISTINCT p3_.id) AS sclr_12, u0_.discriminator AS discriminator_13 FROM participant p1_ INNER JOIN user u0_ ON p1_.id = u0_.id LEFT JOIN participant_hunt p4_ ON p1_.id = p4_.participant_id LEFT JOIN hunt h2_ ON h2_.id = p4_.hunt_id LEFT JOIN participant_badge p3_ ON p1_.id = p3_.participant_id WHERE u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) GROUP BY u0_.id ORDER BY p1_.completed_hunts_count DESC, u0_.username ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.username AS username_1,
  u0_.firstname AS firstname_2,
  u0_.lastname AS lastname_3,
  u0_.mail_address AS mail_address_4,
  u0_.password AS password_5,
  u0_.created AS created_6,
  u0_.updated AS updated_7,
  p1_.crowns AS crowns_8,
  p1_.completed_hunts_count AS completed_hunts_count_9,
  p1_.avatar_path AS avatar_path_10,
  COUNT(DISTINCT h2_.id) AS sclr_11,
  COUNT(DISTINCT p3_.id) AS sclr_12,
  u0_.discriminator AS discriminator_13
FROM
  participant p1_
  INNER JOIN user u0_ ON p1_.id = u0_.id
  LEFT JOIN participant_hunt p4_ ON p1_.id = p4_.participant_id
  LEFT JOIN hunt h2_ ON h2_.id = p4_.hunt_id
  LEFT JOIN participant_badge p3_ ON p1_.id = p3_.participant_id
WHERE
  u0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
GROUP BY
  u0_.id
ORDER BY
  p1_.completed_hunts_count DESC,
  u0_.username ASC

SELECT u0_.id AS id_0, u0_.username AS username_1, u0_.firstname AS firstname_2, u0_.lastname AS lastname_3, u0_.mail_address AS mail_address_4, u0_.password AS password_5, u0_.created AS created_6, u0_.updated AS updated_7, p1_.crowns AS crowns_8, p1_.completed_hunts_count AS completed_hunts_count_9, p1_.avatar_path AS avatar_path_10, COUNT(DISTINCT h2_.id) AS sclr_11, COUNT(DISTINCT p3_.id) AS sclr_12, u0_.discriminator AS discriminator_13 FROM participant p1_ INNER JOIN user u0_ ON p1_.id = u0_.id LEFT JOIN participant_hunt p4_ ON p1_.id = p4_.participant_id LEFT JOIN hunt h2_ ON h2_.id = p4_.hunt_id LEFT JOIN participant_badge p3_ ON p1_.id = p3_.participant_id WHERE u0_.id IN (264, 268, 267, 255, 263, 260, 266, 256, 258, 254, 261, 250, 252, 253, 257) GROUP BY u0_.id ORDER BY p1_.completed_hunts_count DESC, u0_.username ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerGjGcN20\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\Participant\LeaderboardController->index (line 27)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

2.87 ms
(5.25%)

SELECT DISTINCT u0_.id AS id_0, p1_.completed_hunts_count AS completed_hunts_count_1, u0_.username AS username_2 FROM participant p1_ INNER JOIN user u0_ ON p1_.id = u0_.id LEFT JOIN participant_hunt p3_ ON p1_.id = p3_.participant_id LEFT JOIN hunt h2_ ON h2_.id = p3_.hunt_id LEFT JOIN participant_badge p4_ ON p1_.id = p4_.participant_id GROUP BY u0_.id ORDER BY p1_.completed_hunts_count DESC, u0_.username ASC LIMIT 15

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT u0_.id AS id_0,
  p1_.completed_hunts_count AS completed_hunts_count_1,
  u0_.username AS username_2
FROM
  participant p1_
  INNER JOIN user u0_ ON p1_.id = u0_.id
  LEFT JOIN participant_hunt p3_ ON p1_.id = p3_.participant_id
  LEFT JOIN hunt h2_ ON h2_.id = p3_.hunt_id
  LEFT JOIN participant_badge p4_ ON p1_.id = p4_.participant_id
GROUP BY
  u0_.id
ORDER BY
  p1_.completed_hunts_count DESC,
  u0_.username ASC
LIMIT
  15

SELECT DISTINCT u0_.id AS id_0, p1_.completed_hunts_count AS completed_hunts_count_1, u0_.username AS username_2 FROM participant p1_ INNER JOIN user u0_ ON p1_.id = u0_.id LEFT JOIN participant_hunt p3_ ON p1_.id = p3_.participant_id LEFT JOIN hunt h2_ ON h2_.id = p3_.hunt_id LEFT JOIN participant_badge p4_ ON p1_.id = p4_.participant_id GROUP BY u0_.id ORDER BY p1_.completed_hunts_count DESC, u0_.username ASC LIMIT 15;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	iterator_to_array (line 45)
8	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\ORM\QuerySubscriber::items (line 45)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
13	Knp\Component\Pager\Paginator->paginate (line 97)
14	ContainerGjGcN20\PaginatorProxy9cc2a8f->paginate (line 25)
15	App\Controller\Participant\LeaderboardController->index (line 27)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 208)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	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\User	19
App\Entity\Hunt	11
App\Entity\ParticipationCondition	11
App\Entity\Landmark	6
App\Entity\ParticipantBadge	3
App\Entity\Badge	3

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Participant	No errors.
App\Entity\Hunt	The field 'App\Entity\Hunt#startLatitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Hunt#startLongitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\ParticipantBadge	No errors.
App\Entity\ParticipantArtifact	No errors.
App\Entity\Transaction	No errors.
App\Entity\ParticipationCondition	No errors.
App\Entity\Organizer	No errors.
App\Entity\Landmark	No errors.
App\Entity\Reward	No errors.
App\Entity\Badge	No errors.

Symfony Profiler

GET https://lootopia-test.ordwen-dev.com/leaderboard

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping