Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.24 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.24 ms

SELECT t0.id AS id_1, t0.admin AS admin_2, t0.sso AS sso_3, t0.password AS password_4, t0.email AS email_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.function_title AS function_title_8, t0.phone_number AS phone_number_9, t0.tableau_auth_key AS tableau_auth_key_10, t0.updated AS updated_11, t0.integrations AS integrations_12, t0.feature_flags AS feature_flags_13, t14.id AS id_15, t14.token AS token_16, t14.expires AS expires_17, t14.callback_url AS callback_url_18, t14.user_id AS user_id_19, t20.id AS id_21, t20.token AS token_22, t20.expires AS expires_23, t20.user_id AS user_id_24 FROM users t0 LEFT JOIN confirmationtokens t14 ON t14.user_id = t0.id LEFT JOIN saml_token t20 ON t20.user_id = t0.id WHERE t0.email = ? AND t0.sso = ? LIMIT 1

Parameters:

[
  "someone@rawstadia.com"
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.admin AS admin_2,
  t0.sso AS sso_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.first_name AS first_name_6,
  t0.last_name AS last_name_7,
  t0.function_title AS function_title_8,
  t0.phone_number AS phone_number_9,
  t0.tableau_auth_key AS tableau_auth_key_10,
  t0.updated AS updated_11,
  t0.integrations AS integrations_12,
  t0.feature_flags AS feature_flags_13,
  t14.id AS id_15,
  t14.token AS token_16,
  t14.expires AS expires_17,
  t14.callback_url AS callback_url_18,
  t14.user_id AS user_id_19,
  t20.id AS id_21,
  t20.token AS token_22,
  t20.expires AS expires_23,
  t20.user_id AS user_id_24
FROM
  users t0
  LEFT JOIN confirmationtokens t14 ON t14.user_id = t0.id
  LEFT JOIN saml_token t20 ON t20.user_id = t0.id
WHERE
  t0.email = ?
  AND t0.sso = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.admin AS admin_2, t0.sso AS sso_3, t0.password AS password_4, t0.email AS email_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.function_title AS function_title_8, t0.phone_number AS phone_number_9, t0.tableau_auth_key AS tableau_auth_key_10, t0.updated AS updated_11, t0.integrations AS integrations_12, t0.feature_flags AS feature_flags_13, t14.id AS id_15, t14.token AS token_16, t14.expires AS expires_17, t14.callback_url AS callback_url_18, t14.user_id AS user_id_19, t20.id AS id_21, t20.token AS token_22, t20.expires AS expires_23, t20.user_id AS user_id_24 FROM users t0 LEFT JOIN confirmationtokens t14 ON t14.user_id = t0.id LEFT JOIN saml_token t20 ON t20.user_id = t0.id WHERE t0.email = 'someone@rawstadia.com' AND t0.sso = 0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 38)
4	App\Security\SingleSignOnDisabledUserProvider->loadUserByIdentifier (line 87)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	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

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\ConfirmationToken	No errors.
App\Entity\SamlToken	No errors.
App\Entity\Pitch	No errors.
App\Entity\SurfaceAnalysis	No errors.

Symfony Profiler

POST https://staging.platform.rawstadia.com/api/authenticate

Configuration Settings

Theme

Page Width