Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.63 ms Query time

3 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.06 ms
(31.05%)

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:

[
  16
]

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

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

1.71 ms
(25.79%)

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:

[
  222
]

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Organizer::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Organizer->__get (line 64)
8	App\Entity\User->getFirstname (line 146)
9	App\Entity\User->__toString (line 126)
10	Twig\Runtime\EscaperRuntime->escape (line 127)
11	__TwigTemplate_73da699d69bf489b3d8491734d68f079->block_body (line 446)
12	Twig\Template->yieldBlock (line 123)
13	__TwigTemplate_642278f1d859cd7596f2a460982f204c->doDisplay (line 402)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_73da699d69bf489b3d8491734d68f079->doDisplay (line 402)
16	Twig\Template->yield (line 358)
17	Twig\Template->display (line 373)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 333)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
24	App\Controller\HuntController->hunt (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

1.47 ms
(22.17%)

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:

[
  16
]

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1417)
9	Twig\Extension\CoreExtension::testEmpty (line 202)
10	__TwigTemplate_73da699d69bf489b3d8491734d68f079->block_body (line 446)
11	Twig\Template->yieldBlock (line 123)
12	__TwigTemplate_642278f1d859cd7596f2a460982f204c->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_73da699d69bf489b3d8491734d68f079->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
23	App\Controller\HuntController->hunt (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.39 ms
(20.98%)

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:

[
  16
]

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1417)
9	Twig\Extension\CoreExtension::testEmpty (line 241)
10	__TwigTemplate_73da699d69bf489b3d8491734d68f079->block_body (line 446)
11	Twig\Template->yieldBlock (line 123)
12	__TwigTemplate_642278f1d859cd7596f2a460982f204c->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_73da699d69bf489b3d8491734d68f079->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 44)
23	App\Controller\HuntController->hunt (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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\User	2
App\Entity\Hunt	1
App\Entity\ParticipationCondition	1
App\Entity\Landmark	1
App\Entity\Reward	1

Entities Mapping

Class	Mapping errors
App\Entity\Hunt	The mappings App\Entity\Hunt#rewards and App\Entity\Reward#hunt are inconsistent with each other.
App\Entity\ParticipationCondition	No errors.
App\Entity\User	No errors.
App\Entity\Organizer	No errors.
App\Entity\Landmark	The field 'App\Entity\Landmark#latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\Landmark#longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Reward	If association App\Entity\Reward#hunt is many-to-one, then the inversed side App\Entity\Hunt#conditions has to be one-to-many.
App\Entity\Participant	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping