Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

5.73 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.59 ms
(27.66%)

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t1.discriminator FROM organizer t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.firstname AS firstname_4,
  t1.lastname AS lastname_5,
  t1.mail_address AS mail_address_6,
  t1.password AS password_7,
  t1.created AS created_8,
  t1.updated AS updated_9,
  t1.discriminator
FROM
  organizer t0
  INNER JOIN user t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t1.discriminator FROM organizer t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = 9;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Organizer::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 100)
6	Proxies\__CG__\App\Entity\Organizer->__get (line 184)
7	App\Entity\User->getFirstname (line 70)
8	App\Entity\User->__toString (line 152)
9	Twig\Runtime\EscaperRuntime->escape (line 126)
10	__TwigTemplate_5b9ffbcc2faf09544c941edca13e16bf->block_body (line 127)
11	Twig\Template->yieldBlock (line 446)
12	__TwigTemplate_508e41af4d04b27dcead258efe0e7410->doDisplay (line 123)
13	Twig\Template->yield (line 402)
14	__TwigTemplate_5b9ffbcc2faf09544c941edca13e16bf->doDisplay (line 54)
15	Twig\Template->yield (line 402)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 373)
18	Twig\TemplateWrapper->render (line 51)
19	Twig\Environment->render (line 333)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 452)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 457)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 257)
23	App\Controller\HuntController->hunt (line 44)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 208)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

1.46 ms
(25.51%)

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.created_at AS created_at_6, t7.id AS id_8, t7.cost AS cost_9, t7.participants_limit AS participants_limit_10, t7.hunt_id AS hunt_id_11, t0.organizer_id AS organizer_id_12, t13.id AS id_14, t13.latitude AS latitude_15, t13.longitude AS longitude_16, t13.radius AS radius_17, t13.hunt_id AS hunt_id_18 FROM hunt t0 LEFT JOIN participation_condition t7 ON t7.hunt_id = t0.id LEFT JOIN landmark t13 ON t13.hunt_id = t0.id WHERE t0.id = ?

Parameters:

[
  57
]

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.created_at AS created_at_6,
  t7.id AS id_8,
  t7.cost AS cost_9,
  t7.participants_limit AS participants_limit_10,
  t7.hunt_id AS hunt_id_11,
  t0.organizer_id AS organizer_id_12,
  t13.id AS id_14,
  t13.latitude AS latitude_15,
  t13.longitude AS longitude_16,
  t13.radius AS radius_17,
  t13.hunt_id AS hunt_id_18
FROM
  hunt t0
  LEFT JOIN participation_condition t7 ON t7.hunt_id = t0.id
  LEFT JOIN landmark t13 ON t13.hunt_id = t0.id
WHERE
  t0.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.created_at AS created_at_6, t7.id AS id_8, t7.cost AS cost_9, t7.participants_limit AS participants_limit_10, t7.hunt_id AS hunt_id_11, t0.organizer_id AS organizer_id_12, t13.id AS id_14, t13.latitude AS latitude_15, t13.longitude AS longitude_16, t13.radius AS radius_17, t13.hunt_id AS hunt_id_18 FROM hunt t0 LEFT JOIN participation_condition t7 ON t7.hunt_id = t0.id LEFT JOIN landmark t13 ON t13.hunt_id = t0.id WHERE t0.id = 57;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Controller\HuntController->hunt (line 43)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 208)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.35 ms
(23.62%)

SELECT t0.id AS id_1, t0.crown_amount AS crown_amount_2, t0.hunt_id AS hunt_id_3 FROM reward t0 WHERE t0.hunt_id = ?

Parameters:

[
  57
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.crown_amount AS crown_amount_2,
  t0.hunt_id AS hunt_id_3
FROM
  reward t0
WHERE
  t0.hunt_id = ?

SELECT t0.id AS id_1, t0.crown_amount AS crown_amount_2, t0.hunt_id AS hunt_id_3 FROM reward t0 WHERE t0.hunt_id = 57;

#	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 2729)
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->testEmpty (line 1423)
9	__TwigTemplate_5b9ffbcc2faf09544c941edca13e16bf::block_body (line 202)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_508e41af4d04b27dcead258efe0e7410->doDisplay (line 123)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_5b9ffbcc2faf09544c941edca13e16bf->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
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\HuntController->hunt (line 44)
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)

1.33 ms
(23.21%)

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t0.crowns AS crowns_10, t1.discriminator FROM participant t0 INNER JOIN user t1 ON t0.id = t1.id INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id WHERE participant_hunt.hunt_id = ?

Parameters:

[
  57
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.username AS username_3,
  t1.firstname AS firstname_4,
  t1.lastname AS lastname_5,
  t1.mail_address AS mail_address_6,
  t1.password AS password_7,
  t1.created AS created_8,
  t1.updated AS updated_9,
  t0.crowns AS crowns_10,
  t1.discriminator
FROM
  participant t0
  INNER JOIN user t1 ON t0.id = t1.id
  INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id
WHERE
  participant_hunt.hunt_id = ?

SELECT t1.id AS id_2, t1.username AS username_3, t1.firstname AS firstname_4, t1.lastname AS lastname_5, t1.mail_address AS mail_address_6, t1.password AS password_7, t1.created AS created_8, t1.updated AS updated_9, t0.crowns AS crowns_10, t1.discriminator FROM participant t0 INNER JOIN user t1 ON t0.id = t1.id INNER JOIN participant_hunt ON t0.id = participant_hunt.participant_id WHERE participant_hunt.hunt_id = 57;

#	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 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->testEmpty (line 1423)
9	__TwigTemplate_5b9ffbcc2faf09544c941edca13e16bf::block_body (line 241)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_508e41af4d04b27dcead258efe0e7410->doDisplay (line 123)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_5b9ffbcc2faf09544c941edca13e16bf->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
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\HuntController->hunt (line 44)
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)

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\Hunt	1
App\Entity\User	1
App\Entity\ParticipationCondition	1
App\Entity\Landmark	1
App\Entity\Reward	1

Entities Mapping

Class	Mapping errors
App\Entity\Hunt	No errors.
App\Entity\ParticipationCondition	No errors.
App\Entity\User	No errors.
App\Entity\Organizer	No errors.
App\Entity\Landmark	No errors.
App\Entity\Reward	No errors.
App\Entity\Participant	No errors.

Symfony Profiler

GET https://lootopia-test.ordwen-dev.com/hunt/57

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping