Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

1.61 ms Query time

0 Invalid entities

3 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.44 ms
(27.14%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.test_phase_start AS test_phase_start_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.street AS street_11, t0.zip_code AS zip_code_12, t0.city AS city_13, t0.country AS country_14, t0.stripe_customer_id AS stripe_customer_id_15, t0.pending_package_slug AS pending_package_slug_16, t0.pending_package_interval AS pending_package_interval_17, t0.vat_id AS vat_id_18, t0.favorite_cooldown_until AS favorite_cooldown_until_19, t0.ab_version AS ab_version_20, t0.trial_ends_at AS trial_ends_at_21, t0.subscription_active AS subscription_active_22 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.test_phase_start AS test_phase_start_8,
  t0.first_name AS first_name_9,
  t0.last_name AS last_name_10,
  t0.street AS street_11,
  t0.zip_code AS zip_code_12,
  t0.city AS city_13,
  t0.country AS country_14,
  t0.stripe_customer_id AS stripe_customer_id_15,
  t0.pending_package_slug AS pending_package_slug_16,
  t0.pending_package_interval AS pending_package_interval_17,
  t0.vat_id AS vat_id_18,
  t0.favorite_cooldown_until AS favorite_cooldown_until_19,
  t0.ab_version AS ab_version_20,
  t0.trial_ends_at AS trial_ends_at_21,
  t0.subscription_active AS subscription_active_22
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.test_phase_start AS test_phase_start_8, t0.first_name AS first_name_9, t0.last_name AS last_name_10, t0.street AS street_11, t0.zip_code AS zip_code_12, t0.city AS city_13, t0.country AS country_14, t0.stripe_customer_id AS stripe_customer_id_15, t0.pending_package_slug AS pending_package_slug_16, t0.pending_package_interval AS pending_package_interval_17, t0.vat_id AS vat_id_18, t0.favorite_cooldown_until AS favorite_cooldown_until_19, t0.ab_version AS ab_version_20, t0.trial_ends_at AS trial_ends_at_21, t0.subscription_active AS subscription_active_22 FROM `user` t0 WHERE t0.id = 28;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.38 ms
(23.78%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 431)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 99)
5	App\Service\Analytics\AnalyticsCollector->collect (line 30)
6	App\Controller\AnalyticsCollectController->collect (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.22 ms
(13.46%)

SELECT t0.id AS id_1, t0.emma_id AS emma_id_2, t0.land AS land_3 FROM warngebiet t0 INNER JOIN user_warngebiete ON t0.id = user_warngebiete.warngebiet_id WHERE user_warngebiete.user_id = ?

Parameters:

[
  28
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.emma_id AS emma_id_2,
  t0.land AS land_3
FROM
  warngebiet t0
  INNER JOIN user_warngebiete ON t0.id = user_warngebiete.warngebiet_id
WHERE
  user_warngebiete.user_id = ?

SELECT t0.id AS id_1, t0.emma_id AS emma_id_2, t0.land AS land_3 FROM warngebiet t0 INNER JOIN user_warngebiete ON t0.id = user_warngebiete.warngebiet_id WHERE user_warngebiete.user_id = 28;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1081)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1010)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2713)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 2588)
5	Doctrine\ORM\UnitOfWork->createEntity (line 176)
6	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateRowData (line 60)
7	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 170)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 744)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
11	Doctrine\ORM\EntityManager->find (line 86)
12	Doctrine\ORM\EntityRepository->find (line 61)
13	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
14	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
15	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
16	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
19	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.21 ms
(13.13%)

"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 380)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 99)
4	App\Service\Analytics\AnalyticsCollector->collect (line 30)
5	App\Controller\AnalyticsCollectController->collect (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.21 ms
(12.70%)

UPDATE analytics_session SET last_seen_at = ? WHERE session_id = ?

Parameters:

[
  "2026-07-18 08:01:15"
  "ca986535-08f2-4b2b-b7c2-258c25032b59"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  analytics_session
SET
  last_seen_at = ?
WHERE
  session_id = ?

UPDATE analytics_session SET last_seen_at = '2026-07-18 08:01:15' WHERE session_id = 'ca986535-08f2-4b2b-b7c2-258c25032b59';

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1130)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 406)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 99)
7	App\Service\Analytics\AnalyticsCollector->collect (line 30)
8	App\Controller\AnalyticsCollectController->collect (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.16 ms
(9.78%)

SELECT t0.session_id AS session_id_1, t0.first_seen_at AS first_seen_at_2, t0.last_seen_at AS last_seen_at_3, t0.current_path AS current_path_4, t0.area AS area_5, t0.visitor_id AS visitor_id_6, t0.user_id AS user_id_7 FROM analytics_session t0 WHERE t0.session_id = ?

Parameters:

[
  "ca986535-08f2-4b2b-b7c2-258c25032b59"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.session_id AS session_id_1,
  t0.first_seen_at AS first_seen_at_2,
  t0.last_seen_at AS last_seen_at_3,
  t0.current_path AS current_path_4,
  t0.area AS area_5,
  t0.visitor_id AS visitor_id_6,
  t0.user_id AS user_id_7
FROM
  analytics_session t0
WHERE
  t0.session_id = ?

SELECT t0.session_id AS session_id_1, t0.first_seen_at AS first_seen_at_2, t0.last_seen_at AS last_seen_at_3, t0.current_path AS current_path_4, t0.area AS area_5, t0.visitor_id AS visitor_id_6, t0.user_id AS user_id_7 FROM analytics_session t0 WHERE t0.session_id = 'ca986535-08f2-4b2b-b7c2-258c25032b59';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 65)
7	App\Service\Analytics\AnalyticsCollector->collect (line 30)
8	App\Controller\AnalyticsCollectController->collect (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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\User	1
App\Entity\Warngebiet	1
App\Entity\AnalyticsSession	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserAttribute	No errors.
App\Entity\Location	No errors.
App\Entity\UserSubscription	No errors.
App\Entity\PushSubscription	No errors.
App\Entity\Warngebiet	No errors.
App\Entity\AnalyticsSession	No errors.

Symfony Profiler

POST https://wetter.allgaeu-webmarketing.de/api/analytics/collect

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping