Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.01 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.81 ms

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 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
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 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 74)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 70)
13	Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector->collect (line 158)
14	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
15	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
20	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.20 ms

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 74)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->Symfony\Bundle\SecurityBundle\Security\{closure} (line 34)
19	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage->getToken (line 70)
20	Symfony\Bundle\SecurityBundle\DataCollector\SecurityDataCollector->collect (line 158)
21	Symfony\Component\HttpKernel\Profiler\Profiler->collect (line 102)
22	Symfony\Component\HttpKernel\EventListener\ProfilerListener->onKernelResponse (line 115)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 126)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 216)
27	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 204)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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

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.

Symfony Profiler

GET https://wetter.allgaeu-webmarketing.de/mb/inventory/locked?apikey=r8QouitS1gTlZJp3&lang=de&maps=radar%2CwindAnimation%2CcloudsAndPrecipitation%2Csnow%2Cwarnings…

Configuration Settings

Theme

Page Width