Symfony Profiler

Query Metrics

15 Database Queries

10 Different statements

7.77 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

3.03 ms
(39.00%)

INSERT INTO intern_hmac_nonce (nonce, key_id, erstellt_am) VALUES (?, ?, ?)

Parameters:

[
  b"¥ÌÂòš¼IO †?È(È2"
  "kv00015"
  "2026-08-27 23:07:36"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO intern_hmac_nonce (nonce, key_id, erstellt_am)
VALUES
  (?, ?, ?)

INSERT INTO intern_hmac_nonce (nonce, key_id, erstellt_am) VALUES (0xA5CCC2F29ABC494F9DA0863FC828C832, 'kv00015', '2026-08-27 23:07:36');

#	File/Call
1	App\Versand\Intern\Sicherheit\DbNonceRegister->verbuche (line 47)
2	App\Ueberwachung\Sicherheit\UeberwachungsWaechter->__invoke (line 154)
3	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
4	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
6	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

2.93 ms
(37.67%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\EntityManager->wrapInTransaction (line 190)
2	App\Ueberwachung\Meldung\Meldedienst->melde (line 65)
3	App\Ueberwachung\Controller\MeldungsController->meldung (line 151)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.68 ms
(8.71%)

INSERT INTO ueberwachung_posten (id, melder_kennung, kennung, art, zustand, meldung, zuletzt_gemeldet) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  b"\x01 Ez–’xí¿Í¹¿è,;\x06"
  "kv00015"
  "flextl-gateway-touren-schalter"
  "container"
  "gesund"
  "Up 3 weeks (healthy)"
  "2026-08-27 23:07:36"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO ueberwachung_posten (
  id, melder_kennung, kennung, art, zustand,
  meldung, zuletzt_gemeldet
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO ueberwachung_posten (id, melder_kennung, kennung, art, zustand, meldung, zuletzt_gemeldet) VALUES (0x01A0457A969278EDBFCDB9BFE82C3B06, 'kv00015', 'flextl-gateway-touren-schalter', 'container', 'gesund', 'Up 3 weeks (healthy)', '2026-08-27 23:07:36');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1061)
4	Doctrine\ORM\UnitOfWork->commit (line 404)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	Doctrine\ORM\EntityManager->wrapInTransaction (line 189)
7	App\Ueberwachung\Meldung\Meldedienst->melde (line 65)
8	App\Ueberwachung\Controller\MeldungsController->meldung (line 151)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.25 ms
(3.24%)

SELECT t0.id AS id_1, t0.kennung AS kennung_2, t0.anzeigename AS anzeigename_3, t0.art AS art_4, t0.zuletzt_gemeldet AS zuletzt_gemeldet_5, t0.meldung AS meldung_6 FROM ueberwachung_melder t0 WHERE t0.kennung = ? LIMIT 1

Parameters:

[
  "kv00015"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.kennung AS kennung_2,
  t0.anzeigename AS anzeigename_3,
  t0.art AS art_4,
  t0.zuletzt_gemeldet AS zuletzt_gemeldet_5,
  t0.meldung AS meldung_6
FROM
  ueberwachung_melder t0
WHERE
  t0.kennung = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.kennung AS kennung_2, t0.anzeigename AS anzeigename_3, t0.art AS art_4, t0.zuletzt_gemeldet AS zuletzt_gemeldet_5, t0.meldung AS meldung_6 FROM ueberwachung_melder t0 WHERE t0.kennung = 'kv00015' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Ueberwachung\Repository\MelderRepository->findByKennung (line 24)
5	App\Ueberwachung\Meldung\Meldedienst->{closure:App\Ueberwachung\Meldung\Meldedienst::melde():65} (line 66)
6	Doctrine\ORM\EntityManager->wrapInTransaction (line 187)
7	App\Ueberwachung\Meldung\Meldedienst->melde (line 65)
8	App\Ueberwachung\Controller\MeldungsController->meldung (line 151)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.22 ms
(2.78%)

DELETE FROM intern_hmac_nonce WHERE erstellt_am < ?

Parameters:

[
  "2026-08-27 23:02:36"
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  intern_hmac_nonce
WHERE
  erstellt_am < ?

DELETE FROM intern_hmac_nonce WHERE erstellt_am < '2026-08-27 23:02:36';

#	File/Call
1	App\Versand\Intern\Sicherheit\DbNonceRegister->verbuche (line 41)
2	App\Ueberwachung\Sicherheit\UeberwachungsWaechter->__invoke (line 154)
3	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
4	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
6	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.21 ms
(2.76%)

DELETE FROM ueberwachung_posten WHERE melder_kennung = ?

Parameters:

[
  "kv00015"
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  ueberwachung_posten
WHERE
  melder_kennung = ?

DELETE FROM ueberwachung_posten WHERE melder_kennung = 'kv00015';

#	File/Call
1	Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute (line 38)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	App\Ueberwachung\Repository\PostenRepository->loescheAlleVon (line 38)
6	App\Ueberwachung\Meldung\Meldedienst->{closure:App\Ueberwachung\Meldung\Meldedienst::melde():65} (line 79)
7	Doctrine\ORM\EntityManager->wrapInTransaction (line 187)
8	App\Ueberwachung\Meldung\Meldedienst->melde (line 65)
9	App\Ueberwachung\Controller\MeldungsController->meldung (line 151)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.15 ms
(1.92%)

SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->createSavepoint (line 1173)
2	Doctrine\DBAL\Connection->beginTransaction (line 1063)
3	Doctrine\ORM\UnitOfWork->commit (line 383)
4	Doctrine\ORM\EntityManager->flush (line 268)
5	Doctrine\ORM\EntityManager->wrapInTransaction (line 189)
6	App\Ueberwachung\Meldung\Meldedienst->melde (line 65)
7	App\Ueberwachung\Controller\MeldungsController->meldung (line 151)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.13 ms
(1.63%)

UPDATE ueberwachung_melder SET zuletzt_gemeldet = ? WHERE id = ?

Parameters:

[
  "2026-08-27 23:07:36"
  b"""
    \x01Ÿ¾+¸]u\n
    ¹+‚×b-ä{
    """
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  ueberwachung_melder
SET
  zuletzt_gemeldet = ?
WHERE
  id = ?

UPDATE ueberwachung_melder SET zuletzt_gemeldet = '2026-08-27 23:07:36' WHERE id = 0x019FBE2BB85D750AB92B82D7622DE47B;

#	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	Doctrine\ORM\EntityManager->wrapInTransaction (line 189)
7	App\Ueberwachung\Meldung\Meldedienst->melde (line 65)
8	App\Ueberwachung\Controller\MeldungsController->meldung (line 151)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.11 ms
(1.44%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\EntityManager->wrapInTransaction (line 182)
2	App\Ueberwachung\Meldung\Meldedienst->melde (line 65)
3	App\Ueberwachung\Controller\MeldungsController->meldung (line 151)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 191)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

0.07 ms
(0.85%)

RELEASE SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->releaseSavepoint (line 1195)
2	Doctrine\DBAL\Connection->commit (line 1088)
3	Doctrine\ORM\UnitOfWork->commit (line 434)
4	Doctrine\ORM\EntityManager->flush (line 268)
5	Doctrine\ORM\EntityManager->wrapInTransaction (line 189)
6	App\Ueberwachung\Meldung\Meldedienst->melde (line 65)
7	App\Ueberwachung\Controller\MeldungsController->meldung (line 151)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
planung	doctrine.dbal.planung_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
planung	doctrine.orm.planung_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Ueberwachung\Entity\Posten	6
App\Ueberwachung\Entity\Melder	1

planung entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Ueberwachung\Entity\Melder	No errors.
App\Ueberwachung\Entity\Posten	No errors.

planung entity manager

No loaded entities.

Symfony Profiler

POST https://backend.flex-systeme.de/intern/v1/ueberwachung/meldung

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

planung entity manager

Entities Mapping

default entity manager

planung entity manager