Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

7.41 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.35 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.logo AS logo_4, t0.status AS status_5, t0.settings AS settings_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.app_id AS app_id_9 FROM event t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.logo AS logo_4,
  t0.status AS status_5,
  t0.settings AS settings_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.app_id AS app_id_9
FROM
  event t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.logo AS logo_4, t0.status AS status_5, t0.settings AS settings_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.app_id AS app_id_9 FROM event t0 WHERE t0.id = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 116)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 7)

6.06 ms

SELECT t0.id AS id_1, t0.date AS date_2, t0.title AS title_3, t0.meta_data AS meta_data_4, t0.status AS status_5, t0.description AS description_6, t0.start_time AS start_time_7, t0.end_time AS end_time_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.event_id AS event_id_11 FROM agenda 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.date AS date_2,
  t0.title AS title_3,
  t0.meta_data AS meta_data_4,
  t0.status AS status_5,
  t0.description AS description_6,
  t0.start_time AS start_time_7,
  t0.end_time AS end_time_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.event_id AS event_id_11
FROM
  agenda t0
WHERE
  t0.event_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.title AS title_3, t0.meta_data AS meta_data_4, t0.status AS status_5, t0.description AS description_6, t0.start_time AS start_time_7, t0.end_time AS end_time_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.event_id AS event_id_11 FROM agenda t0 WHERE t0.event_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2705)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 237)
7	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 218)
8	App\Entity\Event->getAgendas (line 30)
9	App\Controller\API\AgendaController->sessions (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 7)

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.

Entities Mapping

Class	Mapping errors
App\Entity\Event	No errors.
App\Entity\App	No errors.
App\Entity\Announcement	No errors.
App\Entity\Page	No errors.
App\Entity\Agenda	The field App\Entity\Agenda#userAgendas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\UserAgenda#agenda does not contain the required 'inversedBy="userAgendas"' attribute.
App\Entity\Person	No errors.
App\Entity\Exhibitor	No errors.
App\Entity\ExhibitorGroup	No errors.
App\Entity\Presentation	No errors.
App\Entity\UserAgenda	No errors.
App\Entity\Video	No errors.
App\Entity\Evaluation	No errors.

Symfony Profiler

GET https://ivento.app/api/v1/apps/1/events/1/agenda/sessions

Configuration Settings

Theme