Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

5.03 ms Query time

0 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.17 ms
(63.02%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.status AS status_5, t0.price AS price_6, t0.max_occupancy AS max_occupancy_7, t0.title AS title_8, t0.image AS image_9, t0.location_id AS location_id_10 FROM event t0 ORDER BY t0.date ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.start_time AS start_time_3,
  t0.end_time AS end_time_4,
  t0.status AS status_5,
  t0.price AS price_6,
  t0.max_occupancy AS max_occupancy_7,
  t0.title AS title_8,
  t0.image AS image_9,
  t0.location_id AS location_id_10
FROM
  event t0
ORDER BY
  t0.date ASC

SELECT t0.id AS id_1, t0.date AS date_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.status AS status_5, t0.price AS price_6, t0.max_occupancy AS max_occupancy_7, t0.title AS title_8, t0.image AS image_9, t0.location_id AS location_id_10 FROM event t0 ORDER BY t0.date ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 19)
5	App\Controller\MainController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.86 ms
(36.98%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email_address AS email_address_4, t0.phone_number AS phone_number_5, t0.participant_amount AS participant_amount_6, t0.wishes AS wishes_7, t0.status AS status_8, t0.event_id AS event_id_9, t0.user_id AS user_id_10 FROM registrant t0 WHERE t0.event_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email_address AS email_address_4,
  t0.phone_number AS phone_number_5,
  t0.participant_amount AS participant_amount_6,
  t0.wishes AS wishes_7,
  t0.status AS status_8,
  t0.event_id AS event_id_9,
  t0.user_id AS user_id_10
FROM
  registrant t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email_address AS email_address_4, t0.phone_number AS phone_number_5, t0.participant_amount AS participant_amount_6, t0.wishes AS wishes_7, t0.status AS status_8, t0.event_id AS event_id_9, t0.user_id AS user_id_10 FROM registrant t0 WHERE t0.event_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1858)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1803)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2720)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 196)
8	App\Entity\Event->getSlotsTaken (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 153)
10	__TwigTemplate_be6c5d8a9d4655a477ebcc6f04168c83->block_body (line 446)
11	Twig\Template->yieldBlock (line 152)
12	__TwigTemplate_6f131861d482b4a632abb63bece87fe8->doDisplay (line 402)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_be6c5d8a9d4655a477ebcc6f04168c83->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 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 21)
23	App\Controller\MainController->index (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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\Event	3
App\Entity\Registrant	3
App\Entity\User	2
App\Entity\Location	1

Entities Mapping

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\Location	No errors.
App\Entity\Registrant	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://jmulne-reserveerjmulnet-8278.site.transip.me/

Configuration Settings

Theme

Page Width