Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

9.79 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.33 ms
(44.25%)

SELECT t0.id AS id_1, t0.`order` AS order_2, t0.name AS name_3, t0.explanation AS explanation_4, t0.justification AS justification_5, t0.pdca AS pdca_6, t0.year AS year_7, t0.simplification_title AS simplification_title_8, t0.simplification_justification AS simplification_justification_9, t0.simplification_text AS simplification_text_10, t0.locked AS locked_11, t0.category_id AS category_id_12, t13.id AS id_14, t13.value AS value_15, t13.norm_id AS norm_id_16, t0.assigned_to_id AS assigned_to_id_17 FROM norm t0 LEFT JOIN norm_level t13 ON t13.norm_id = t0.id WHERE t0.category_id IS NULL AND t0.`order` IS NULL LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.`order` AS order_2,
  t0.name AS name_3,
  t0.explanation AS explanation_4,
  t0.justification AS justification_5,
  t0.pdca AS pdca_6,
  t0.year AS year_7,
  t0.simplification_title AS simplification_title_8,
  t0.simplification_justification AS simplification_justification_9,
  t0.simplification_text AS simplification_text_10,
  t0.locked AS locked_11,
  t0.category_id AS category_id_12,
  t13.id AS id_14,
  t13.value AS value_15,
  t13.norm_id AS norm_id_16,
  t0.assigned_to_id AS assigned_to_id_17
FROM
  norm t0
  LEFT JOIN norm_level t13 ON t13.norm_id = t0.id
WHERE
  t0.category_id IS NULL
  AND t0.`order` IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.`order` AS order_2, t0.name AS name_3, t0.explanation AS explanation_4, t0.justification AS justification_5, t0.pdca AS pdca_6, t0.year AS year_7, t0.simplification_title AS simplification_title_8, t0.simplification_justification AS simplification_justification_9, t0.simplification_text AS simplification_text_10, t0.locked AS locked_11, t0.category_id AS category_id_12, t13.id AS id_14, t13.value AS value_15, t13.norm_id AS norm_id_16, t0.assigned_to_id AS assigned_to_id_17 FROM norm t0 LEFT JOIN norm_level t13 ON t13.norm_id = t0.id WHERE t0.category_id IS NULL AND t0.`order` IS NULL LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->Sentry\SentryBundle\Tracing\Doctrine\DBAL\{closure} (line 236)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 106)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->query (line 49)
4	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->query (line 1106)
5	Doctrine\DBAL\Connection->executeQuery (line 746)
6	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
7	Doctrine\ORM\EntityRepository->findOneBy (line 81)
8	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 80)
9	App\Listener\PageListener->getNormByRouteParams (line 64)
10	App\Listener\PageListener->onRequest (line 115)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 18)

2.88 ms
(29.40%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->Sentry\SentryBundle\Tracing\Doctrine\DBAL\{closure} (line 236)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 156)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->commit (line 93)
4	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->commit (line 1502)
5	Doctrine\DBAL\Connection->doCommit (line 1454)
6	Doctrine\DBAL\Connection->commit (line 431)
7	Doctrine\ORM\UnitOfWork->commit (line 264)
8	Doctrine\ORM\EntityManager->flush (line 70)
9	App\Listener\PageListener->onRequest (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 18)

2.04 ms
(20.89%)

INSERT INTO page_view (user, ip_address, created_at, page, page_type, context, user_agent) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  null
  "104.164.173.16"
  "2025-12-25 15:55:23"
  "https://edf1.tribital.com/beveiliging?p=beveiliging"
  "page"
  "{"params":{"_route":"security_overview","norm":null,"pathInfo":"\/beveiliging"}}"
  "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO page_view (
  user, ip_address, created_at, page,
  page_type, context, user_agent
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO page_view (user, ip_address, created_at, page, page_type, context, user_agent) VALUES (NULL, '104.164.173.16', '2025-12-25 15:55:23', 'https://edf1.tribital.com/beveiliging?p=beveiliging', 'page', '{\"params\":{\"_route\":\"security_overview\",\"norm\":null,\"pathInfo\":\"\\/beveiliging\"}}', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/117.0.0.0 Safari/537.36');

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\AbstractTracingStatement->traceFunction (line 44)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV3->execute (line 190)
3	Doctrine\DBAL\Statement->execute (line 249)
4	Doctrine\DBAL\Statement->executeStatement (line 261)
5	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1052)
6	Doctrine\ORM\UnitOfWork->executeInserts (line 401)
7	Doctrine\ORM\UnitOfWork->commit (line 264)
8	Doctrine\ORM\EntityManager->flush (line 70)
9	App\Listener\PageListener->onRequest (line 115)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 18)

0.53 ms
(5.46%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->Sentry\SentryBundle\Tracing\Doctrine\DBAL\{closure} (line 236)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->traceFunction (line 146)
3	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV2V3->beginTransaction (line 85)
4	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingServerInfoAwareDriverConnection->beginTransaction (line 1391)
5	Doctrine\DBAL\Connection->beginTransaction (line 380)
6	Doctrine\ORM\UnitOfWork->commit (line 264)
7	Doctrine\ORM\EntityManager->flush (line 70)
8	App\Listener\PageListener->onRequest (line 115)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 18)

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\PageView	1

Entities Mapping

Class	Mapping errors
App\Entity\Norm	No errors.
App\Entity\Category	No errors.
App\Entity\NormLevel	No errors.
App\Entity\User	No errors.
App\Entity\PageView	No errors.

Symfony Profiler

GET https://edf1.tribital.com/beveiliging?p=beveiliging

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping