Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.63 ms Query time

3 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

contao connection

Time▼

Count

Info

0.93 ms
(56.79%)

SELECT t0.id AS id_1, t0.tstamp AS tstamp_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.dateOfBirth AS dateOfBirth_5, t0.gender AS gender_6, t0.company AS company_7, t0.street AS street_8, t0.postal AS postal_9, t0.city AS city_10, t0.state AS state_11, t0.country AS country_12, t0.phone AS phone_13, t0.mobile AS mobile_14, t0.fax AS fax_15, t0.email AS email_16, t0.website AS website_17, t0.language AS language_18, t0.username AS username_19, t0.password AS password_20, t0.groups AS groups_21, t0.login AS login_22, t0.assignDir AS assignDir_23, t0.homeDir AS homeDir_24, t0.disable AS disable_25, t0.start AS start_26, t0.stop AS stop_27, t0.dateAdded AS dateAdded_28, t0.lastLogin AS lastLogin_29, t0.currentLogin AS currentLogin_30, t0.loginCount AS loginCount_31, t0.locked AS locked_32, t0.session AS session_33, t0.autologin AS autologin_34, t0.createdOn AS createdOn_35, t0.activation AS activation_36, t0.newsletter AS newsletter_37, t0.salutation AS salutation_38, t0.newsletter_sms AS newsletter_sms_39, t0.newsletter_email AS newsletter_email_40, t0.housenumber AS housenumber_41, t0.sms_approve_until AS sms_approve_until_42, t0.sms_approve AS sms_approve_43, t0.alias AS alias_44, t0.publicFields AS publicFields_45, t0.allowEmail AS allowEmail_46, t0.moenneke_customer_number AS moenneke_customer_number_47 FROM tl_member t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "tm@thomas-meyer.net"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.tstamp AS tstamp_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.dateOfBirth AS dateOfBirth_5,
  t0.gender AS gender_6,
  t0.company AS company_7,
  t0.street AS street_8,
  t0.postal AS postal_9,
  t0.city AS city_10,
  t0.state AS state_11,
  t0.country AS country_12,
  t0.phone AS phone_13,
  t0.mobile AS mobile_14,
  t0.fax AS fax_15,
  t0.email AS email_16,
  t0.website AS website_17,
  t0.language AS language_18,
  t0.username AS username_19,
  t0.password AS password_20,
  t0.groups AS groups_21,
  t0.login AS login_22,
  t0.assignDir AS assignDir_23,
  t0.homeDir AS homeDir_24,
  t0.disable AS disable_25,
  t0.start AS start_26,
  t0.stop AS stop_27,
  t0.dateAdded AS dateAdded_28,
  t0.lastLogin AS lastLogin_29,
  t0.currentLogin AS currentLogin_30,
  t0.loginCount AS loginCount_31,
  t0.locked AS locked_32,
  t0.session AS session_33,
  t0.autologin AS autologin_34,
  t0.createdOn AS createdOn_35,
  t0.activation AS activation_36,
  t0.newsletter AS newsletter_37,
  t0.salutation AS salutation_38,
  t0.newsletter_sms AS newsletter_sms_39,
  t0.newsletter_email AS newsletter_email_40,
  t0.housenumber AS housenumber_41,
  t0.sms_approve_until AS sms_approve_until_42,
  t0.sms_approve AS sms_approve_43,
  t0.alias AS alias_44,
  t0.publicFields AS publicFields_45,
  t0.allowEmail AS allowEmail_46,
  t0.moenneke_customer_number AS moenneke_customer_number_47
FROM
  tl_member t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.tstamp AS tstamp_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.dateOfBirth AS dateOfBirth_5, t0.gender AS gender_6, t0.company AS company_7, t0.street AS street_8, t0.postal AS postal_9, t0.city AS city_10, t0.state AS state_11, t0.country AS country_12, t0.phone AS phone_13, t0.mobile AS mobile_14, t0.fax AS fax_15, t0.email AS email_16, t0.website AS website_17, t0.language AS language_18, t0.username AS username_19, t0.password AS password_20, t0.groups AS groups_21, t0.login AS login_22, t0.assignDir AS assignDir_23, t0.homeDir AS homeDir_24, t0.disable AS disable_25, t0.start AS start_26, t0.stop AS stop_27, t0.dateAdded AS dateAdded_28, t0.lastLogin AS lastLogin_29, t0.currentLogin AS currentLogin_30, t0.loginCount AS loginCount_31, t0.locked AS locked_32, t0.session AS session_33, t0.autologin AS autologin_34, t0.createdOn AS createdOn_35, t0.activation AS activation_36, t0.newsletter AS newsletter_37, t0.salutation AS salutation_38, t0.newsletter_sms AS newsletter_sms_39, t0.newsletter_email AS newsletter_email_40, t0.housenumber AS housenumber_41, t0.sms_approve_until AS sms_approve_until_42, t0.sms_approve AS sms_approve_43, t0.alias AS alias_44, t0.publicFields AS publicFields_45, t0.allowEmail AS allowEmail_46, t0.moenneke_customer_number AS moenneke_customer_number_47 FROM tl_member t0 WHERE t0.username = 'tm@thomas-meyer.net' LIMIT 1;

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

default connection

Time▼

Count

Info

0.71 ms
(43.21%)

SELECT w0_.id AS id_0, w0_.token AS token_1, w0_.glanzkarte AS glanzkarte_2, w0_.glanzkarte_id AS glanzkarte_id_3, w0_.valid_from AS valid_from_4, w0_.valid_to AS valid_to_5, w0_.moenneke_customer_nr AS moenneke_customer_nr_6, w0_.token_used_at AS token_used_at_7, w0_.washcount AS washcount_8, w0_.interaction_uuid AS interaction_uuid_9, w0_.type AS type_10, w0_.wash_programm_id AS wash_programm_id_11, w0_.portal_maschine_id AS portal_maschine_id_12 FROM wash_portal_token w0_ WHERE (w0_.token_used_at IS NULL AND w0_.moenneke_customer_nr = ? AND w0_.valid_to >= ?) AND w0_.type IN ('washtectoken') LIMIT 1

Parameters:

[
  5055
  "2026-09-01 08:47:13"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.token AS token_1,
  w0_.glanzkarte AS glanzkarte_2,
  w0_.glanzkarte_id AS glanzkarte_id_3,
  w0_.valid_from AS valid_from_4,
  w0_.valid_to AS valid_to_5,
  w0_.moenneke_customer_nr AS moenneke_customer_nr_6,
  w0_.token_used_at AS token_used_at_7,
  w0_.washcount AS washcount_8,
  w0_.interaction_uuid AS interaction_uuid_9,
  w0_.type AS type_10,
  w0_.wash_programm_id AS wash_programm_id_11,
  w0_.portal_maschine_id AS portal_maschine_id_12
FROM
  wash_portal_token w0_
WHERE
  (
    w0_.token_used_at IS NULL
    AND w0_.moenneke_customer_nr = ?
    AND w0_.valid_to >= ?
  )
  AND w0_.type IN ('washtectoken')
LIMIT
  1

SELECT w0_.id AS id_0, w0_.token AS token_1, w0_.glanzkarte AS glanzkarte_2, w0_.glanzkarte_id AS glanzkarte_id_3, w0_.valid_from AS valid_from_4, w0_.valid_to AS valid_to_5, w0_.moenneke_customer_nr AS moenneke_customer_nr_6, w0_.token_used_at AS token_used_at_7, w0_.washcount AS washcount_8, w0_.interaction_uuid AS interaction_uuid_9, w0_.type AS type_10, w0_.wash_programm_id AS wash_programm_id_11, w0_.portal_maschine_id AS portal_maschine_id_12 FROM wash_portal_token w0_ WHERE (w0_.token_used_at IS NULL AND w0_.moenneke_customer_nr = 5055 AND w0_.valid_to >= '2026-09-01 08:47:13') AND w0_.type IN ('washtectoken') LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\ApiResource\Glanzkarte\GlanzkarteRedeemWashportalStatusProvider->provide (line 57)
7	ApiPlatform\State\CallableProvider->provide (line 43)
8	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
9	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 104)
10	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 71)
12	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
13	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
15	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
17	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 102)
18	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
19	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
20	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 208)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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

contao entity manager

Class	Amount of managed objects
App\Entity\Contao\ContaoMember	1

Entities Mapping

default entity manager

Class	Mapping errors
App\Entity\Mws\WashPortalToken	The field 'App\Entity\Mws\WashPortalToken#glanzkarte' has the property type 'App\Entity\Mws\Glanzkarte' that differs from the metadata field type 'string' returned by the 'string' DBAL type. The target entity 'App\Entity\Mws\PortalMaschine' specified on App\Entity\Mws\WashPortalToken#portalMaschine is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Mws\WashtecWashPortalToken	The field 'App\Entity\Mws\WashtecWashPortalToken#glanzkarte' has the property type 'App\Entity\Mws\Glanzkarte' that differs from the metadata field type 'string' returned by the 'string' DBAL type. The target entity 'App\Entity\Mws\PortalMaschine' specified on App\Entity\Mws\WashtecWashPortalToken#portalMaschine is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Mws\WashProgramm	The target entity 'App\Entity\Mws\PortalMaschine' specified on App\Entity\Mws\WashProgramm#portalMaschine is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Mws\WashMaschine	No errors.
App\Entity\Mws\PortalMaschine	No errors.

contao entity manager

Class	Mapping errors
App\Entity\Contao\ContaoMember	No errors.

Symfony Profiler

GET https://mws.moenneke.de/api/glanzkarte/redeem-washportal-status

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

contao connection

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