Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

49.37 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

21.28 ms
(43.12%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 259)
3	Doctrine\ORM\EntityManager->flush (line 51)
4	App\Controller\Modules\Custom\GrootInBhv\RegistrationController->toggleDeleted (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

19.74 ms
(39.98%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 429)
3	Doctrine\ORM\UnitOfWork->commit (line 259)
4	Doctrine\ORM\EntityManager->flush (line 51)
5	App\Controller\Modules\Custom\GrootInBhv\RegistrationController->toggleDeleted (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)

7.26 ms
(14.70%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.first_name AS first_name_3, t0.gender AS gender_4, t0.email AS email_5, t0.phonenumber AS phonenumber_6, t0.dayofbirth AS dayofbirth_7, t0.password AS password_8, t0.deleted_at AS deleted_at_9, t0.calendar_item_id AS calendar_item_id_10 FROM registration t0 WHERE t0.id = ?

Parameters:

[
  663
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.first_name AS first_name_3,
  t0.gender AS gender_4,
  t0.email AS email_5,
  t0.phonenumber AS phonenumber_6,
  t0.dayofbirth AS dayofbirth_7,
  t0.password AS password_8,
  t0.deleted_at AS deleted_at_9,
  t0.calendar_item_id AS calendar_item_id_10
FROM
  registration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.first_name AS first_name_3, t0.gender AS gender_4, t0.email AS email_5, t0.phonenumber AS phonenumber_6, t0.dayofbirth AS dayofbirth_7, t0.password AS password_8, t0.deleted_at AS deleted_at_9, t0.calendar_item_id AS calendar_item_id_10 FROM registration t0 WHERE t0.id = 663;

#	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 39)
7	App\Controller\Modules\Custom\GrootInBhv\RegistrationController->toggleDeleted (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.09 ms
(2.20%)

UPDATE registration SET deleted_at = ? WHERE id = ?

Parameters:

[
  null
  663
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  registration
SET
  deleted_at = ?
WHERE
  id = ?

UPDATE registration SET deleted_at = NULL WHERE id = 663;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 490)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 374)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1126)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 404)
5	Doctrine\ORM\UnitOfWork->commit (line 259)
6	Doctrine\ORM\EntityManager->flush (line 51)
7	App\Controller\Modules\Custom\GrootInBhv\RegistrationController->toggleDeleted (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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.

Entities Mapping

Class	Mapping errors
App\Entity\Modules\Custom\GrootInBhv\Registration	No errors.
App\Entity\Modules\Custom\GrootInBhv\CalendarItem	The field App\Entity\Modules\Custom\GrootInBhv\CalendarItem#registrations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Modules\Custom\GrootInBhv\Registration#calendarItem does not contain the required 'inversedBy="registrations"' attribute.

Symfony Profiler

GET https://app.undernimme.nl/calendar/register/toggle-deleted/663

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping