Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

2.38 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.78 ms
(32.95%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 434)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Repository\OwnerRepository->save (line 24)
4	App\Controller\OwnerController->updateEmail (line 112)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	require_once (line 5)

0.65 ms
(27.55%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.stableName AS stableName_3, t0.salutation AS salutation_4, t0.title AS title_5, t0.firstName AS firstName_6, t0.lastName AS lastName_7, t0.street AS street_8, t0.zip AS zip_9, t0.town AS town_10, t0.country AS country_11, t0.language AS language_12, t0.email AS email_13, t0.taxNumber AS taxNumber_14, t0.intTaxNumber AS intTaxNumber_15, t0.taxedAbroad AS taxedAbroad_16, t0.visible AS visible_17, t0.phone AS phone_18, t0.officePhone AS officePhone_19, t0.mobilePhone AS mobilePhone_20, t0.info AS info_21, t0.created AS created_22, t0.updated AS updated_23, t0.deleted AS deleted_24, t0.updatedBy_id AS updatedBy_id_25 FROM Owner t0 WHERE t0.id = ?

Parameters:

[
  "353"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.stableName AS stableName_3,
  t0.salutation AS salutation_4,
  t0.title AS title_5,
  t0.firstName AS firstName_6,
  t0.lastName AS lastName_7,
  t0.street AS street_8,
  t0.zip AS zip_9,
  t0.town AS town_10,
  t0.country AS country_11,
  t0.language AS language_12,
  t0.email AS email_13,
  t0.taxNumber AS taxNumber_14,
  t0.intTaxNumber AS intTaxNumber_15,
  t0.taxedAbroad AS taxedAbroad_16,
  t0.visible AS visible_17,
  t0.phone AS phone_18,
  t0.officePhone AS officePhone_19,
  t0.mobilePhone AS mobilePhone_20,
  t0.info AS info_21,
  t0.created AS created_22,
  t0.updated AS updated_23,
  t0.deleted AS deleted_24,
  t0.updatedBy_id AS updatedBy_id_25
FROM
  Owner t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.stableName AS stableName_3, t0.salutation AS salutation_4, t0.title AS title_5, t0.firstName AS firstName_6, t0.lastName AS lastName_7, t0.street AS street_8, t0.zip AS zip_9, t0.town AS town_10, t0.country AS country_11, t0.language AS language_12, t0.email AS email_13, t0.taxNumber AS taxNumber_14, t0.intTaxNumber AS intTaxNumber_15, t0.taxedAbroad AS taxedAbroad_16, t0.visible AS visible_17, t0.phone AS phone_18, t0.officePhone AS officePhone_19, t0.mobilePhone AS mobilePhone_20, t0.info AS info_21, t0.created AS created_22, t0.updated AS updated_23, t0.deleted AS deleted_24, t0.updatedBy_id AS updatedBy_id_25 FROM Owner t0 WHERE t0.id = '353';

#	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\ServiceEntityRepository->find (line 66)
6	App\Controller\OwnerController->updateEmail (line 108)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
9	Symfony\Component\HttpKernel\Kernel->handle (line 143)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
11	require_once (line 32)
12	require_once (line 5)

0.44 ms
(18.67%)

UPDATE Owner SET email = ? WHERE id = ?

Parameters:

[
  "georg@sh-ording.de"
  353
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  Owner
SET
  email = ?
WHERE
  id = ?

UPDATE Owner SET email = 'georg@sh-ording.de' WHERE id = 353;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1141)
4	Doctrine\ORM\UnitOfWork->commit (line 409)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Repository\OwnerRepository->save (line 24)
7	App\Controller\OwnerController->updateEmail (line 112)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

0.26 ms
(11.02%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.fullName AS fullName_3, t0.phone AS phone_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.isVerified AS isVerified_8, t0.visible AS visible_9, t0.deleted AS deleted_10, t0.created AS created_11 FROM User t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.fullName AS fullName_3,
  t0.phone AS phone_4,
  t0.email AS email_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.isVerified AS isVerified_8,
  t0.visible AS visible_9,
  t0.deleted AS deleted_10,
  t0.created AS created_11
FROM
  User t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.fullName AS fullName_3, t0.phone AS phone_4, t0.email AS email_5, t0.roles AS roles_6, t0.password AS password_7, t0.isVerified AS isVerified_8, t0.visible AS visible_9, t0.deleted AS deleted_10, t0.created AS created_11 FROM User t0 WHERE t0.id = 2;

#	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\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 227)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 162)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
19	Symfony\Component\HttpKernel\Kernel->handle (line 143)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

0.23 ms
(9.81%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 383)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Repository\OwnerRepository->save (line 24)
4	App\Controller\OwnerController->updateEmail (line 112)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
7	Symfony\Component\HttpKernel\Kernel->handle (line 143)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
9	require_once (line 32)
10	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	1
App\Entity\Owner	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\TravelExpensesEmployee	No errors.
App\Entity\Start	No errors.
App\Entity\Owner	No errors.
App\Entity\TravelExpensesOwner	No errors.
App\Entity\OwnerExpenses	No errors.
App\Entity\HorseInOut	No errors.
App\Entity\HorseShare	No errors.
App\Entity\Invoice	No errors.

POST https://dev.xn--asterblte-w9a.de/admin/owner/updateEmail/353/georg@sh-ording.de

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping