Symfony Profiler

Query Metrics

26 Database Queries

8 Different statements

24.33 ms Query time

0 Invalid entities

310 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

15.54 ms
(63.88%)

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->index (line 26)
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.40 ms
(9.85%)

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

Parameters:

[
  "page_view"
  "{"path":"\/","route":"app_home"}"
  "app_home"
  "2026-05-26"
  "2026-05-26 17:08:03"
]

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\":\"\\/\",\"route\":\"app_home\"}', 'app_home', '2026-05-26', '2026-05-26 17:08:03');

#	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)

2.36 ms
(9.70%)

"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.36 ms
(5.59%)

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_21535e7649b0aaec7cf2fa6abcaa139e->block_title (line 77)
10	Twig\Template->yieldBlock (line 446)
11	__TwigTemplate_36e97bcdf5f85c895046170d22e35136->doDisplay (line 62)
12	Twig\Template->yield (line 402)
13	__TwigTemplate_21535e7649b0aaec7cf2fa6abcaa139e->doDisplay (line 55)
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->index (line 28)
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)

1.03 ms
(4.24%)

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->index (line 26)
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.61 ms
(2.50%)

"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)

0.52 ms
(2.15%)

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->index (line 29)
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.51 ms
(2.09%)

SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.description AS description_2, h0_.background_image AS background_image_3, h0_.link_url AS link_url_4, h0_.cta_label AS cta_label_5, h0_.created_at AS created_at_6, h0_.updated_at AS updated_at_7, h0_.media_asset_id AS media_asset_id_8 FROM hero_banner h0_ ORDER BY h0_.created_at DESC LIMIT 8

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.title AS title_1,
  h0_.description AS description_2,
  h0_.background_image AS background_image_3,
  h0_.link_url AS link_url_4,
  h0_.cta_label AS cta_label_5,
  h0_.created_at AS created_at_6,
  h0_.updated_at AS updated_at_7,
  h0_.media_asset_id AS media_asset_id_8
FROM
  hero_banner h0_
ORDER BY
  h0_.created_at DESC
LIMIT
  8

SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.description AS description_2, h0_.background_image AS background_image_3, h0_.link_url AS link_url_4, h0_.cta_label AS cta_label_5, h0_.created_at AS created_at_6, h0_.updated_at AS updated_at_7, h0_.media_asset_id AS media_asset_id_8 FROM hero_banner h0_ ORDER BY h0_.created_at DESC LIMIT 8;

#	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\HeroBannerRepository->findAllForHomepage (line 26)
7	App\Controller\StorefrontController->index (line 31)
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)

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\DeviceModel	No errors.
App\Entity\Category	No errors.
App\Entity\Device	No errors.
App\Entity\MediaAsset	No errors.
App\Entity\DeviceModelImage	No errors.
App\Entity\Booking	No errors.
App\Entity\HeroBanner	No errors.
App\Entity\TextBlock	No errors.

Symfony Profiler

GET https://rental.florianbirkenberger.de/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping