Symfony Profiler

Query Metrics

10 Database Queries

8 Different statements

6.84 ms Query time

0 Invalid entities

48 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

1.33 ms
(19.49%)

SELECT t0.id AS id_1, t0.fk AS fk_2, t0.type AS type_3, t0.info AS info_4, t0.sperre AS sperre_5, t0.user_id AS user_id_6 FROM datensatzsperre t0 WHERE t0.type = ? AND t0.user_id = ? AND t0.fk = ? LIMIT 1

Parameters:

[
  "paket"
  88
  "47"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fk AS fk_2,
  t0.type AS type_3,
  t0.info AS info_4,
  t0.sperre AS sperre_5,
  t0.user_id AS user_id_6
FROM
  datensatzsperre t0
WHERE
  t0.type = ?
  AND t0.user_id = ?
  AND t0.fk = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.fk AS fk_2, t0.type AS type_3, t0.info AS info_4, t0.sperre AS sperre_5, t0.user_id AS user_id_6 FROM datensatzsperre t0 WHERE t0.type = 'paket' AND t0.user_id = 88 AND t0.fk = '47' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
3	Doctrine\ORM\EntityRepository->findOneBy (line 126)
4	App\Service\DatensatzSperreService->sperren (line 200)
5	App\Controller\Backend\System\DatensatzsperreController->create (line 54)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
8	Symfony\Component\HttpKernel\Kernel->handle (line 155)
9	handle (line 25)

1.30 ms
(18.98%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1080)
2	Doctrine\ORM\UnitOfWork->commit (line 458)
3	Doctrine\ORM\EntityManager->flush (line 270)
4	App\Service\DatensatzSperreService->sperren (line 215)
5	App\Controller\Backend\System\DatensatzsperreController->create (line 54)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
8	Symfony\Component\HttpKernel\Kernel->handle (line 155)
9	handle (line 25)

1.18 ms
(17.33%)

SELECT t0.id AS id_1, t0.allow_edit AS allow_edit_2, t0.allow_delete AS allow_delete_3, t0.right_id AS right_id_4, t0.role_id AS role_id_5 FROM role_right t0 WHERE t0.role_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.allow_edit AS allow_edit_2,
  t0.allow_delete AS allow_delete_3,
  t0.right_id AS right_id_4,
  t0.role_id AS role_id_5
FROM
  role_right t0
WHERE
  t0.role_id = ?

SELECT t0.id AS id_1, t0.allow_edit AS allow_edit_2, t0.allow_delete AS allow_delete_3, t0.right_id AS right_id_4, t0.role_id AS role_id_5 FROM role_right t0 WHERE t0.role_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1876)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1821)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 2928)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
6	Doctrine\ORM\PersistentCollection->initialize (line 188)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 253)
8	App\Entity\Administration\User->getRights (line 553)
9	App\Entity\Administration\User->getRoles (line 545)
10	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 333)
11	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 234)
12	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
13	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 174)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
23	Symfony\Component\HttpKernel\Kernel->handle (line 155)
24	handle (line 25)

0.75 ms
(10.91%)

UPDATE datensatzsperre SET sperre = ? WHERE id = ?

Parameters:

[
  "2026-11-05 13:15:03"
  15619
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  datensatzsperre
SET
  sperre = ?
WHERE
  id = ?

UPDATE datensatzsperre SET sperre = '2026-11-05 13:15:03' WHERE id = 15619;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 902)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 496)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 380)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 1228)
5	Doctrine\ORM\UnitOfWork->commit (line 433)
6	Doctrine\ORM\EntityManager->flush (line 270)
7	App\Service\DatensatzSperreService->sperren (line 215)
8	App\Controller\Backend\System\DatensatzsperreController->create (line 54)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
11	Symfony\Component\HttpKernel\Kernel->handle (line 155)
12	handle (line 25)

0.63 ms
(9.27%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.class AS class_3, t0.kopie AS kopie_4, t0.modal_edit AS modal_edit_5, t0.no_edit AS no_edit_6, t0.no_delete AS no_delete_7, t0.datensatzsperre AS datensatzsperre_8, t0.bezeichnung_objekt AS bezeichnung_objekt_9, t0.bezeichnung_getter AS bezeichnung_getter_10, t0.select_field1 AS select_field1_11, t0.select_field2 AS select_field2_12, t0.right_id AS right_id_13 FROM table_ t0 WHERE t0.id = ?

Parameters:

[
  "paket"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.class AS class_3,
  t0.kopie AS kopie_4,
  t0.modal_edit AS modal_edit_5,
  t0.no_edit AS no_edit_6,
  t0.no_delete AS no_delete_7,
  t0.datensatzsperre AS datensatzsperre_8,
  t0.bezeichnung_objekt AS bezeichnung_objekt_9,
  t0.bezeichnung_getter AS bezeichnung_getter_10,
  t0.select_field1 AS select_field1_11,
  t0.select_field2 AS select_field2_12,
  t0.right_id AS right_id_13
FROM
  table_ t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.class AS class_3, t0.kopie AS kopie_4, t0.modal_edit AS modal_edit_5, t0.no_edit AS no_edit_6, t0.no_delete AS no_delete_7, t0.datensatzsperre AS datensatzsperre_8, t0.bezeichnung_objekt AS bezeichnung_objekt_9, t0.bezeichnung_getter AS bezeichnung_getter_10, t0.select_field1 AS select_field1_11, t0.select_field2 AS select_field2_12, t0.right_id AS right_id_13 FROM table_ t0 WHERE t0.id = 'paket';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
4	Doctrine\ORM\EntityManager->find (line 376)
5	App\Service\DatensatzSperreService->sperren (line 187)
6	App\Controller\Backend\System\DatensatzsperreController->create (line 54)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
9	Symfony\Component\HttpKernel\Kernel->handle (line 155)
10	handle (line 25)

0.62 ms
(9.07%)

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.username AS username_9, t0.vorname AS vorname_10, t0.nachname AS nachname_11, t0.password AS password_12, t0.email AS email_13, t0.to_user AS to_user_14, t0.auth_counter AS auth_counter_15, t0.auth_sperre AS auth_sperre_16, t0.telefonnummer AS telefonnummer_17, t0.kuerzel AS kuerzel_18, t0.veroeffentlichen AS veroeffentlichen_19, t0.geburtstag AS geburtstag_20, t0.letzter_login AS letzter_login_21, t0.letzte_passwort_aenderung AS letzte_passwort_aenderung_22, t0.text AS text_23, t0.signatur_email AS signatur_email_24, t0.token AS token_25, t0.to2_token AS to2_token_26, t0.langdock_api_key AS langdock_api_key_27, t0.website_user AS website_user_28, t0.sb_user AS sb_user_29, t0.geschlecht_id AS geschlecht_id_30, t0.sprache_id AS sprache_id_31, t0.abteilung_id AS abteilung_id_32 FROM user t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  88
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.tempFlag AS tempFlag_6,
  t0.deleteFlag AS deleteFlag_7,
  t0.id AS id_8,
  t0.username AS username_9,
  t0.vorname AS vorname_10,
  t0.nachname AS nachname_11,
  t0.password AS password_12,
  t0.email AS email_13,
  t0.to_user AS to_user_14,
  t0.auth_counter AS auth_counter_15,
  t0.auth_sperre AS auth_sperre_16,
  t0.telefonnummer AS telefonnummer_17,
  t0.kuerzel AS kuerzel_18,
  t0.veroeffentlichen AS veroeffentlichen_19,
  t0.geburtstag AS geburtstag_20,
  t0.letzter_login AS letzter_login_21,
  t0.letzte_passwort_aenderung AS letzte_passwort_aenderung_22,
  t0.text AS text_23,
  t0.signatur_email AS signatur_email_24,
  t0.token AS token_25,
  t0.to2_token AS to2_token_26,
  t0.langdock_api_key AS langdock_api_key_27,
  t0.website_user AS website_user_28,
  t0.sb_user AS sb_user_29,
  t0.geschlecht_id AS geschlecht_id_30,
  t0.sprache_id AS sprache_id_31,
  t0.abteilung_id AS abteilung_id_32
FROM
  user t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.tempFlag AS tempFlag_6, t0.deleteFlag AS deleteFlag_7, t0.id AS id_8, t0.username AS username_9, t0.vorname AS vorname_10, t0.nachname AS nachname_11, t0.password AS password_12, t0.email AS email_13, t0.to_user AS to_user_14, t0.auth_counter AS auth_counter_15, t0.auth_sperre AS auth_sperre_16, t0.telefonnummer AS telefonnummer_17, t0.kuerzel AS kuerzel_18, t0.veroeffentlichen AS veroeffentlichen_19, t0.geburtstag AS geburtstag_20, t0.letzter_login AS letzter_login_21, t0.letzte_passwort_aenderung AS letzte_passwort_aenderung_22, t0.text AS text_23, t0.signatur_email AS signatur_email_24, t0.token AS token_25, t0.to2_token AS to2_token_26, t0.langdock_api_key AS langdock_api_key_27, t0.website_user AS website_user_28, t0.sb_user AS sb_user_29, t0.geschlecht_id AS geschlecht_id_30, t0.sprache_id AS sprache_id_31, t0.abteilung_id AS abteilung_id_32 FROM user t0 WHERE t0.id = 88 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
4	Doctrine\ORM\EntityManager->find (line 376)
5	Doctrine\ORM\EntityRepository->find (line 87)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 70)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 231)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 174)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
20	Symfony\Component\HttpKernel\Kernel->handle (line 155)
21	handle (line 25)

0.58 ms
(8.55%)

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.bezeichnung AS bezeichnung_7, t0.sb_user AS sb_user_8 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  88
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.deleted_at AS deleted_at_1,
  t0.anlage_datum AS anlage_datum_2,
  t0.aenderung_datum AS aenderung_datum_3,
  t0.aktiv AS aktiv_4,
  t0.sb_name AS sb_name_5,
  t0.id AS id_6,
  t0.bezeichnung AS bezeichnung_7,
  t0.sb_user AS sb_user_8
FROM
  role t0
  INNER JOIN role_user ON t0.id = role_user.role_id
WHERE
  role_user.user_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.anlage_datum AS anlage_datum_2, t0.aenderung_datum AS aenderung_datum_3, t0.aktiv AS aktiv_4, t0.sb_name AS sb_name_5, t0.id AS id_6, t0.bezeichnung AS bezeichnung_7, t0.sb_user AS sb_user_8 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = 88 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 800)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1106)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 1035)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 2932)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 629)
6	Doctrine\ORM\PersistentCollection->initialize (line 188)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 253)
8	App\Entity\Administration\User->getRoles (line 540)
9	Symfony\Component\Security\Http\Firewall\ContextListener->hasUserChanged (line 333)
10	Symfony\Component\Security\Http\Firewall\ContextListener::refreshUser (line 234)
11	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
13	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
14	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
15	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 174)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
22	Symfony\Component\HttpKernel\Kernel->handle (line 155)
23	handle (line 25)

0.44 ms
(6.40%)

"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 1055)
2	Doctrine\ORM\UnitOfWork->commit (line 405)
3	Doctrine\ORM\EntityManager->flush (line 270)
4	App\Service\DatensatzSperreService->sperren (line 215)
5	App\Controller\Backend\System\DatensatzsperreController->create (line 54)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 200)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 80)
8	Symfony\Component\HttpKernel\Kernel->handle (line 155)
9	handle (line 25)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
external	doctrine.dbal.external_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
external	doctrine.orm.external_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Administration\RoleRight	21
App\Entity\Administration\Right	16
App\Entity\Administration\User	4
App\Entity\Administration\Role	3
App\Entity\Key\KeyGeschlecht	1
App\Entity\Stammdaten\SpracheAPI	1
App\Entity\Administration\Table	1
App\Entity\Administration\Datensatzsperre	1

external entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\AbstractToEntity	No errors.
App\Entity\AbstractTemporableToEntity	No errors.
App\Entity\Administration\User	No errors.
App\Entity\Key\KeyGeschlecht	No errors.
App\Entity\Stammdaten\SpracheAPI	No errors.
App\Entity\Administration\Abteilung	No errors.
App\Entity\Administration\Datensatzsperre	No errors.
App\Entity\CRM\Kunde	No errors.
App\Entity\Administration\UserTable	No errors.
App\Entity\Reise\Paket\PaketUser	No errors.
App\Entity\Administration\UserFilter	No errors.
App\Entity\Administration\Role	No errors.
App\Entity\Administration\RoleRight	No errors.
App\Entity\Administration\Right	No errors.
App\Entity\Administration\Table	No errors.
App\Entity\Administration\TableColumn	No errors.
App\Entity\Doku\Xwiki	No errors.

external entity manager

No loaded entities.

PUT https://to3-abnahme.tourone.de/backend/admin/datensatzsperre

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

external entity manager

Entities Mapping

default entity manager

external entity manager