Symfony Profiler

Query Metrics

26 Database Queries

8 Different statements

22.02 ms Query time

0 Invalid entities

310 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.13 ms
(64.14%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.inventory_number AS inventory_number_4, t0.serial_number AS serial_number_5, t0.manufacturer AS manufacturer_6, t0.model AS model_7, t0.status AS status_8, t0.image_path AS image_path_9, t0.notes AS notes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category_id AS category_id_13, t0.device_model_id AS device_model_id_14 FROM device t0 WHERE t0.device_model_id = ? ORDER BY t0.inventory_number ASC

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.inventory_number AS inventory_number_4,
  t0.serial_number AS serial_number_5,
  t0.manufacturer AS manufacturer_6,
  t0.model AS model_7,
  t0.status AS status_8,
  t0.image_path AS image_path_9,
  t0.notes AS notes_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.category_id AS category_id_13,
  t0.device_model_id AS device_model_id_14
FROM
  device t0
WHERE
  t0.device_model_id = ?
ORDER BY
  t0.inventory_number ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.inventory_number AS inventory_number_4, t0.serial_number AS serial_number_5, t0.manufacturer AS manufacturer_6, t0.model AS model_7, t0.status AS status_8, t0.image_path AS image_path_9, t0.notes AS notes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.category_id AS category_id_13, t0.device_model_id AS device_model_id_14 FROM device t0 WHERE t0.device_model_id = 9 ORDER BY t0.inventory_number ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Repository\DeviceModelRepository->findAllForCatalog (line 116)
8	App\Controller\StorefrontController->catalog (line 62)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

2.16 ms
(9.78%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\AnalyticsService->track (line 42)
4	App\EventSubscriber\PageViewTrackingSubscriber->onKernelRequest (line 59)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

1.28 ms
(5.83%)

SELECT b0_.device_id AS sclr_0 FROM booking b0_ WHERE b0_.pickup_at < ? AND b0_.return_at > ? AND b0_.status NOT IN (?, ?)

Parameters:

[
  "2026-05-26 19:15:17"
  "2026-05-26 18:14:17"
  "cancelled"
  "returned"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.device_id AS sclr_0
FROM
  booking b0_
WHERE
  b0_.pickup_at < ?
  AND b0_.return_at > ?
  AND b0_.status NOT IN (?, ?)

SELECT b0_.device_id AS sclr_0 FROM booking b0_ WHERE b0_.pickup_at < '2026-05-26 19:15:17' AND b0_.return_at > '2026-05-26 18:14:17' AND b0_.status NOT IN ('cancelled', 'returned');

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 724)
6	App\Repository\BookingRepository->findBlockedDeviceIdsInPeriod (line 642)
7	App\Controller\StorefrontController->catalog (line 59)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.26 ms
(5.73%)

INSERT INTO analytics_event (event_type, context, route, event_date, created_at) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "page_view"
  "{"path":"\/katalog","route":"app_catalog"}"
  "app_catalog"
  "2026-05-26"
  "2026-05-26 18:44:17"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO analytics_event (
  event_type, context, route, event_date,
  created_at
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO analytics_event (event_type, context, route, event_date, created_at) VALUES ('page_view', '{\"path\":\"\\/katalog\",\"route\":\"app_catalog\"}', 'app_catalog', '2026-05-26', '2026-05-26 18:44:17');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\AnalyticsService->track (line 42)
7	App\EventSubscriber\PageViewTrackingSubscriber->onKernelRequest (line 59)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
14	Symfony\Component\HttpKernel\Kernel->handle (line 193)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
16	require_once (line 32)
17	require_once (line 5)

1.04 ms
(4.74%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_en AS name_en_2, c0_.description AS description_3, c0_.description_en AS description_en_4, c0_.slug AS slug_5, c0_.icon AS icon_6, c0_.sort_order AS sort_order_7 FROM category c0_ ORDER BY c0_.sort_order ASC, c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.name_en AS name_en_2,
  c0_.description AS description_3,
  c0_.description_en AS description_en_4,
  c0_.slug AS slug_5,
  c0_.icon AS icon_6,
  c0_.sort_order AS sort_order_7
FROM
  category c0_
ORDER BY
  c0_.sort_order ASC,
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_en AS name_en_2, c0_.description AS description_3, c0_.description_en AS description_en_4, c0_.slug AS slug_5, c0_.icon AS icon_6, c0_.sort_order AS sort_order_7 FROM category c0_ ORDER BY c0_.sort_order ASC, c0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\CategoryRepository->findAllSorted (line 26)
7	App\Controller\StorefrontController->catalog (line 66)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

1.02 ms
(4.64%)

SELECT t0_.id AS id_0, t0_.block_key AS block_key_1, t0_.label AS label_2, t0_.text_de AS text_de_3, t0_.text_en AS text_en_4, t0_.notes AS notes_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7 FROM text_block t0_ ORDER BY t0_.block_key ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.block_key AS block_key_1,
  t0_.label AS label_2,
  t0_.text_de AS text_de_3,
  t0_.text_en AS text_en_4,
  t0_.notes AS notes_5,
  t0_.created_at AS created_at_6,
  t0_.updated_at AS updated_at_7
FROM
  text_block t0_
ORDER BY
  t0_.block_key ASC

SELECT t0_.id AS id_0, t0_.block_key AS block_key_1, t0_.label AS label_2, t0_.text_de AS text_de_3, t0_.text_en AS text_en_4, t0_.notes AS notes_5, t0_.created_at AS created_at_6, t0_.updated_at AS updated_at_7 FROM text_block t0_ ORDER BY t0_.block_key ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\TextBlockRepository->findAllIndexedByKey (line 32)
7	App\Service\TextBlockResolver->resolve (line 26)
8	App\Twig\TextBlockExtension->textBlock (line 27)
9	__TwigTemplate_99a32f182db4cc5031d86eda5afbf5d1->block_title (line 76)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_36e97bcdf5f85c895046170d22e35136->doDisplay (line 62)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_99a32f182db4cc5031d86eda5afbf5d1->doDisplay (line 54)
14	Twig\Template->yield (line 402)
15	Twig\Template->display (line 358)
16	Twig\Template->render (line 373)
17	Twig\TemplateWrapper->render (line 51)
18	Twig\Environment->render (line 333)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
22	App\Controller\StorefrontController->catalog (line 64)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

0.96 ms
(4.36%)

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.name_en AS name_en_2, d0_.description AS description_3, d0_.description_en AS description_en_4, d0_.manufacturer AS manufacturer_5, d0_.model AS model_6, d0_.image_path AS image_path_7, d0_.notes AS notes_8, d0_.created_at AS created_at_9, d0_.updated_at AS updated_at_10, d0_.category_id AS category_id_11, d0_.main_image_id AS main_image_id_12 FROM device_model d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id INNER JOIN device d2_ ON d0_.id = d2_.device_model_id AND (d2_.status NOT IN (?, ?)) GROUP BY d0_.id ORDER BY d0_.name ASC

Parameters:

[
  "retired"
  "maintenance"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.name_en AS name_en_2,
  d0_.description AS description_3,
  d0_.description_en AS description_en_4,
  d0_.manufacturer AS manufacturer_5,
  d0_.model AS model_6,
  d0_.image_path AS image_path_7,
  d0_.notes AS notes_8,
  d0_.created_at AS created_at_9,
  d0_.updated_at AS updated_at_10,
  d0_.category_id AS category_id_11,
  d0_.main_image_id AS main_image_id_12
FROM
  device_model d0_
  INNER JOIN category c1_ ON d0_.category_id = c1_.id
  INNER JOIN device d2_ ON d0_.id = d2_.device_model_id
  AND (
    d2_.status NOT IN (?, ?)
  )
GROUP BY
  d0_.id
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.name_en AS name_en_2, d0_.description AS description_3, d0_.description_en AS description_en_4, d0_.manufacturer AS manufacturer_5, d0_.model AS model_6, d0_.image_path AS image_path_7, d0_.notes AS notes_8, d0_.created_at AS created_at_9, d0_.updated_at AS updated_at_10, d0_.category_id AS category_id_11, d0_.main_image_id AS main_image_id_12 FROM device_model d0_ INNER JOIN category c1_ ON d0_.category_id = c1_.id INNER JOIN device d2_ ON d0_.id = d2_.device_model_id AND (d2_.status NOT IN ('retired', 'maintenance')) GROUP BY d0_.id ORDER BY d0_.name ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\DeviceModelRepository->findAllForCatalog (line 108)
7	App\Controller\StorefrontController->catalog (line 62)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.17 ms
(0.78%)

"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 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\AnalyticsService->track (line 42)
4	App\EventSubscriber\PageViewTrackingSubscriber->onKernelRequest (line 59)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	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\TextBlock	265
App\Entity\DeviceModel	19
App\Entity\Device	19
App\Entity\Category	6
App\Entity\AnalyticsEvent	1

Entities Mapping

Class	Mapping errors
App\Entity\AnalyticsEvent	No errors.
App\Entity\Booking	No errors.
App\Entity\Device	No errors.
App\Entity\DeviceModel	No errors.
App\Entity\Category	No errors.
App\Entity\MediaAsset	No errors.
App\Entity\DeviceModelImage	No errors.
App\Entity\TextBlock	No errors.

Symfony Profiler

GET https://rental.florianbirkenberger.de/katalog

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping