Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.89 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

0.89 ms
(100.00%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.dateofbirth AS dateofbirth_7, t0.email AS email_8, t0.whatsapp AS whatsapp_9, t0.salution AS salution_10, t0.street AS street_11, t0.housenumber AS housenumber_12, t0.zip AS zip_13, t0.city AS city_14, t0.glanzkarte_customer_id AS glanzkarte_customer_id_15 FROM user t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "huth"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.dateofbirth AS dateofbirth_7,
  t0.email AS email_8,
  t0.whatsapp AS whatsapp_9,
  t0.salution AS salution_10,
  t0.street AS street_11,
  t0.housenumber AS housenumber_12,
  t0.zip AS zip_13,
  t0.city AS city_14,
  t0.glanzkarte_customer_id AS glanzkarte_customer_id_15
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.dateofbirth AS dateofbirth_7, t0.email AS email_8, t0.whatsapp AS whatsapp_9, t0.salution AS salution_10, t0.street AS street_11, t0.housenumber AS housenumber_12, t0.zip AS zip_13, t0.city AS city_14, t0.glanzkarte_customer_id AS glanzkarte_customer_id_15 FROM user t0 WHERE t0.username = 'huth' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Security\TwoDbUserProvider->loadUserByIdentifier (line 30)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 208)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 105)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 87)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 42)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 180)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
20	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 83)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 142)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 208)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 29)
32	require_once (line 6)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
contao	doctrine.dbal.contao_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
contao	doctrine.orm.contao_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Mws\User	1

contao entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Mws\User	No errors.
App\Entity\Mws\GlanzkarteCustomer	No errors.

contao entity manager

No loaded entities.

Symfony Profiler

POST https://mws.moenneke.de/api/huth/afterpayment

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

contao entity manager

Entities Mapping

default entity manager

contao entity manager