Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

10.36 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

4.86 ms

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.expires_at AS expires_at_5, t0.is_revoked AS is_revoked_6, t0.client_id AS client_id_7 FROM oauth_access_token t0 WHERE t0.identifier = ? LIMIT 1

Parameters:

[
  "ba8604e20dab4446450b883b72998ef08068cef949f4b73ac4a6985dac7f461f8d1428caf473ad0a"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.user_identifier AS user_identifier_3,
  t0.scopes AS scopes_4,
  t0.expires_at AS expires_at_5,
  t0.is_revoked AS is_revoked_6,
  t0.client_id AS client_id_7
FROM
  oauth_access_token t0
WHERE
  t0.identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.expires_at AS expires_at_5, t0.is_revoked AS is_revoked_6, t0.client_id AS client_id_7 FROM oauth_access_token t0 WHERE t0.identifier = 'ba8604e20dab4446450b883b72998ef08068cef949f4b73ac4a6985dac7f461f8d1428caf473ad0a' 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\ServiceEntityRepository->findOneBy (line 86)
4	App\OAuth\Repository\OAuthAccessTokenRepository->findByIdentifier (line 24)
5	App\OAuth\Bridge\AccessTokenRepository->isAccessTokenRevoked (line 77)
6	League\OAuth2\Server\AuthorizationValidators\BearerTokenValidator->validateAuthorization (line 125)
7	League\OAuth2\Server\ResourceServer->validateAuthenticatedRequest (line 56)
8	App\OAuth\Security\OAuth2Authenticator->authenticate (line 51)
9	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 172)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
13	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
14	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
15	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
16	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
17	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 7)

1.52 ms

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.secret_hash AS secret_hash_3, t0.name AS name_4, t0.grant_types AS grant_types_5, t0.allowed_scopes AS allowed_scopes_6, t0.redirect_uris AS redirect_uris_7, t0.is_confidential AS is_confidential_8, t0.is_revoked AS is_revoked_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.device_id AS device_id_12 FROM oauth_client t0 WHERE t0.identifier = ? AND t0.is_revoked = ? LIMIT 1

Parameters:

[
  "b99808bae3ddd3f8"
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.secret_hash AS secret_hash_3,
  t0.name AS name_4,
  t0.grant_types AS grant_types_5,
  t0.allowed_scopes AS allowed_scopes_6,
  t0.redirect_uris AS redirect_uris_7,
  t0.is_confidential AS is_confidential_8,
  t0.is_revoked AS is_revoked_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.device_id AS device_id_12
FROM
  oauth_client t0
WHERE
  t0.identifier = ?
  AND t0.is_revoked = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.secret_hash AS secret_hash_3, t0.name AS name_4, t0.grant_types AS grant_types_5, t0.allowed_scopes AS allowed_scopes_6, t0.redirect_uris AS redirect_uris_7, t0.is_confidential AS is_confidential_8, t0.is_revoked AS is_revoked_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.device_id AS device_id_12 FROM oauth_client t0 WHERE t0.identifier = 'b99808bae3ddd3f8' AND t0.is_revoked = 0 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\ServiceEntityRepository->findOneBy (line 86)
4	App\OAuth\Repository\OAuthClientRepository->findByIdentifier (line 24)
5	App\OAuth\Security\OAuth2Authenticator->loadDevicePrincipal (line 104)
6	App\OAuth\Security\OAuth2Authenticator->{closure:App\OAuth\Security\OAuth2Authenticator::authenticate():66} (line 66)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 176)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
22	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
23	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
25	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 191)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 7)

3.98 ms

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.name AS name_3, t0.avatar_name AS avatar_name_4, t0.status AS status_5, t0.paired_at AS paired_at_6, t0.geolocation_enabled AS geolocation_enabled_7, t0.is_enabled AS is_enabled_8, t0.internet_enabled AS internet_enabled_9, t0.curfew_start AS curfew_start_10, t0.curfew_end AS curfew_end_11, t0.config_version AS config_version_12, t0.installed_config_version AS installed_config_version_13, t0.last_seen_at AS last_seen_at_14, t0.fcm_token AS fcm_token_15, t0.fcm_token_updated_at AS fcm_token_updated_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.parent_id AS parent_id_19, t0.dns_provider_id AS dns_provider_id_20, t21.id AS id_22, t21.operator AS operator_23, t21.service_name AS service_name_24, t21.descriptions AS descriptions_25, t21.primary_address AS primary_address_26, t21.secondary_address AS secondary_address_27, t21.information_url AS information_url_28, t21.created_at AS created_at_29, t21.updated_at AS updated_at_30 FROM device t0 LEFT JOIN dns_provider t21 ON t0.dns_provider_id = t21.id WHERE t0.id = ?

Parameters:

[
  "019fa45c-04cd-778a-bdda-69d054e1b783"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.name AS name_3,
  t0.avatar_name AS avatar_name_4,
  t0.status AS status_5,
  t0.paired_at AS paired_at_6,
  t0.geolocation_enabled AS geolocation_enabled_7,
  t0.is_enabled AS is_enabled_8,
  t0.internet_enabled AS internet_enabled_9,
  t0.curfew_start AS curfew_start_10,
  t0.curfew_end AS curfew_end_11,
  t0.config_version AS config_version_12,
  t0.installed_config_version AS installed_config_version_13,
  t0.last_seen_at AS last_seen_at_14,
  t0.fcm_token AS fcm_token_15,
  t0.fcm_token_updated_at AS fcm_token_updated_at_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.parent_id AS parent_id_19,
  t0.dns_provider_id AS dns_provider_id_20,
  t21.id AS id_22,
  t21.operator AS operator_23,
  t21.service_name AS service_name_24,
  t21.descriptions AS descriptions_25,
  t21.primary_address AS primary_address_26,
  t21.secondary_address AS secondary_address_27,
  t21.information_url AS information_url_28,
  t21.created_at AS created_at_29,
  t21.updated_at AS updated_at_30
FROM
  device t0
  LEFT JOIN dns_provider t21 ON t0.dns_provider_id = t21.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.name AS name_3, t0.avatar_name AS avatar_name_4, t0.status AS status_5, t0.paired_at AS paired_at_6, t0.geolocation_enabled AS geolocation_enabled_7, t0.is_enabled AS is_enabled_8, t0.internet_enabled AS internet_enabled_9, t0.curfew_start AS curfew_start_10, t0.curfew_end AS curfew_end_11, t0.config_version AS config_version_12, t0.installed_config_version AS installed_config_version_13, t0.last_seen_at AS last_seen_at_14, t0.fcm_token AS fcm_token_15, t0.fcm_token_updated_at AS fcm_token_updated_at_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.parent_id AS parent_id_19, t0.dns_provider_id AS dns_provider_id_20, t21.id AS id_22, t21.operator AS operator_23, t21.service_name AS service_name_24, t21.descriptions AS descriptions_25, t21.primary_address AS primary_address_26, t21.secondary_address AS secondary_address_27, t21.information_url AS information_url_28, t21.created_at AS created_at_29, t21.updated_at AS updated_at_30 FROM device t0 LEFT JOIN dns_provider t21 ON t0.dns_provider_id = t21.id WHERE t0.id = '019fa45c-04cd-778a-bdda-69d054e1b783';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Api\EventSubscriber\DeviceLastSeenSubscriber::onController (line 47)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 171)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 7)

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\OAuth\Entity\OAuthAccessToken	1
App\OAuth\Entity\OAuthClient	1
App\Entity\Device	1

Entities Mapping

Class	Mapping errors
App\OAuth\Entity\OAuthAccessToken	No errors.
App\OAuth\Entity\OAuthClient	No errors.
App\Entity\Device	No errors.
App\Entity\User	No errors.
App\Entity\DnsProvider	No errors.
App\Entity\DeviceAppPermissionOverride	No errors.
App\Entity\Contact	No errors.
App\Entity\DeviceAppCategoryLimit	No errors.
App\Entity\DeviceAppUsage	No errors.

Symfony Profiler

GET https://nw-flow.cloud/api/config

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping