Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

8.14 ms Query time

1 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.44 ms
(29.95%)

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, t0.completed_hunts_count AS completed_hunts_count_11, t0.avatar_path AS avatar_path_12, 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:

[
  7
]

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,
  t0.completed_hunts_count AS completed_hunts_count_11,
  t0.avatar_path AS avatar_path_12,
  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, t0.completed_hunts_count AS completed_hunts_count_11, t0.avatar_path AS avatar_path_12, 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 = 7;

#	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_1a7646f7435ab9fa6ed3fc7e15df10e0::block_body (line 132)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_bab945b757f79136cce4f54d294ec0a2->doDisplay (line 202)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_1a7646f7435ab9fa6ed3fc7e15df10e0->doDisplay (line 55)
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\HuntController->hunt (line 59)
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)

2.31 ms
(28.41%)

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 WHERE t0.id = ?

Parameters:

[
  7
]

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
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.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 WHERE t0.id = 7;

#	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 58)
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.73 ms
(21.20%)

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:

[
  248
]

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

#	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->getUsername (line 60)
8	Twig\Extension\CoreExtension->getAttribute (line 1918)
9	__TwigTemplate_1a7646f7435ab9fa6ed3fc7e15df10e0::block_body (line 241)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_bab945b757f79136cce4f54d294ec0a2->doDisplay (line 202)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_1a7646f7435ab9fa6ed3fc7e15df10e0->doDisplay (line 55)
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\HuntController->hunt (line 59)
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.67 ms
(20.44%)

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:

[
  7
]

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

#	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->testEmpty (line 1423)
9	__TwigTemplate_1a7646f7435ab9fa6ed3fc7e15df10e0::block_body (line 412)
10	Twig\Template->yieldBlock (line 456)
11	__TwigTemplate_bab945b757f79136cce4f54d294ec0a2->doDisplay (line 202)
12	Twig\Template->yield (line 411)
13	__TwigTemplate_1a7646f7435ab9fa6ed3fc7e15df10e0->doDisplay (line 55)
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\HuntController->hunt (line 59)
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\User	2
App\Entity\Hunt	1
App\Entity\ParticipationCondition	1
App\Entity\Reward	1

Entities Mapping

Class	Mapping 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\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.
App\Entity\ParticipantBadge	No errors.
App\Entity\ParticipantArtifact	No errors.
App\Entity\Transaction	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping