Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

9.78 ms Query time

0 Invalid entities

16 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.66 ms
(47.59%)

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:

[
  "908df6106de4057d4fc9990963bbbcec4f68b6e5461514fe50d649f52b6c669fbf79d8b56e06c88f"
]

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 = '908df6106de4057d4fc9990963bbbcec4f68b6e5461514fe50d649f52b6c669fbf79d8b56e06c88f' 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)

3.78 ms
(38.63%)

SELECT d0_.id AS id_0, d0_.unique_id AS unique_id_1, d0_.name AS name_2, d0_.avatar_name AS avatar_name_3, d0_.status AS status_4, d0_.paired_at AS paired_at_5, d0_.geolocation_enabled AS geolocation_enabled_6, d0_.is_enabled AS is_enabled_7, d0_.internet_enabled AS internet_enabled_8, d0_.curfew_start AS curfew_start_9, d0_.curfew_end AS curfew_end_10, d0_.config_version AS config_version_11, d0_.installed_config_version AS installed_config_version_12, d0_.last_seen_at AS last_seen_at_13, d0_.fcm_token AS fcm_token_14, d0_.fcm_token_updated_at AS fcm_token_updated_at_15, d0_.created_at AS created_at_16, d0_.updated_at AS updated_at_17, d1_.id AS id_18, d1_.operator AS operator_19, d1_.service_name AS service_name_20, d1_.descriptions AS descriptions_21, d1_.primary_address AS primary_address_22, d1_.secondary_address AS secondary_address_23, d1_.information_url AS information_url_24, d1_.created_at AS created_at_25, d1_.updated_at AS updated_at_26, d0_.parent_id AS parent_id_27, d0_.dns_provider_id AS dns_provider_id_28 FROM device d0_ LEFT JOIN dns_provider d1_ ON d0_.dns_provider_id = d1_.id WHERE d0_.parent_id = ? ORDER BY d0_.id ASC

Parameters:

[
  "019e1fdf-3da9-71cb-b195-c6c4c6513e7f"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.unique_id AS unique_id_1,
  d0_.name AS name_2,
  d0_.avatar_name AS avatar_name_3,
  d0_.status AS status_4,
  d0_.paired_at AS paired_at_5,
  d0_.geolocation_enabled AS geolocation_enabled_6,
  d0_.is_enabled AS is_enabled_7,
  d0_.internet_enabled AS internet_enabled_8,
  d0_.curfew_start AS curfew_start_9,
  d0_.curfew_end AS curfew_end_10,
  d0_.config_version AS config_version_11,
  d0_.installed_config_version AS installed_config_version_12,
  d0_.last_seen_at AS last_seen_at_13,
  d0_.fcm_token AS fcm_token_14,
  d0_.fcm_token_updated_at AS fcm_token_updated_at_15,
  d0_.created_at AS created_at_16,
  d0_.updated_at AS updated_at_17,
  d1_.id AS id_18,
  d1_.operator AS operator_19,
  d1_.service_name AS service_name_20,
  d1_.descriptions AS descriptions_21,
  d1_.primary_address AS primary_address_22,
  d1_.secondary_address AS secondary_address_23,
  d1_.information_url AS information_url_24,
  d1_.created_at AS created_at_25,
  d1_.updated_at AS updated_at_26,
  d0_.parent_id AS parent_id_27,
  d0_.dns_provider_id AS dns_provider_id_28
FROM
  device d0_
  LEFT JOIN dns_provider d1_ ON d0_.dns_provider_id = d1_.id
WHERE
  d0_.parent_id = ?
ORDER BY
  d0_.id ASC

SELECT d0_.id AS id_0, d0_.unique_id AS unique_id_1, d0_.name AS name_2, d0_.avatar_name AS avatar_name_3, d0_.status AS status_4, d0_.paired_at AS paired_at_5, d0_.geolocation_enabled AS geolocation_enabled_6, d0_.is_enabled AS is_enabled_7, d0_.internet_enabled AS internet_enabled_8, d0_.curfew_start AS curfew_start_9, d0_.curfew_end AS curfew_end_10, d0_.config_version AS config_version_11, d0_.installed_config_version AS installed_config_version_12, d0_.last_seen_at AS last_seen_at_13, d0_.fcm_token AS fcm_token_14, d0_.fcm_token_updated_at AS fcm_token_updated_at_15, d0_.created_at AS created_at_16, d0_.updated_at AS updated_at_17, d1_.id AS id_18, d1_.operator AS operator_19, d1_.service_name AS service_name_20, d1_.descriptions AS descriptions_21, d1_.primary_address AS primary_address_22, d1_.secondary_address AS secondary_address_23, d1_.information_url AS information_url_24, d1_.created_at AS created_at_25, d1_.updated_at AS updated_at_26, d0_.parent_id AS parent_id_27, d0_.dns_provider_id AS dns_provider_id_28 FROM device d0_ LEFT JOIN dns_provider d1_ ON d0_.dns_provider_id = d1_.id WHERE d0_.parent_id = '019e1fdf-3da9-71cb-b195-c6c4c6513e7f' ORDER BY d0_.id ASC;

#	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->getResult (line 688)
6	ApiPlatform\Doctrine\Orm\State\CollectionProvider->provide (line 80)
7	ApiPlatform\State\CallableProvider->provide (line 43)
8	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
9	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 103)
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 101)
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 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 191)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 7)

1.35 ms
(13.78%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.is_email_verified AS is_email_verified_5, t0.is_active AS is_active_6, t0.failed_login_attempts AS failed_login_attempts_7, t0.locked_until AS locked_until_8, t0.pending_email AS pending_email_9, t0.pending_email_requested_at AS pending_email_requested_at_10, t0.scheduled_for_deletion_at AS scheduled_for_deletion_at_11, t0.age_verified_at AS age_verified_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM "user" t0 WHERE t0.id = ?

Parameters:

[
  "019e1fdf-3da9-71cb-b195-c6c4c6513e7f"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.is_email_verified AS is_email_verified_5,
  t0.is_active AS is_active_6,
  t0.failed_login_attempts AS failed_login_attempts_7,
  t0.locked_until AS locked_until_8,
  t0.pending_email AS pending_email_9,
  t0.pending_email_requested_at AS pending_email_requested_at_10,
  t0.scheduled_for_deletion_at AS scheduled_for_deletion_at_11,
  t0.age_verified_at AS age_verified_at_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.is_email_verified AS is_email_verified_5, t0.is_active AS is_active_6, t0.failed_login_attempts AS failed_login_attempts_7, t0.locked_until AS locked_until_8, t0.pending_email AS pending_email_9, t0.pending_email_requested_at AS pending_email_requested_at_10, t0.scheduled_for_deletion_at AS scheduled_for_deletion_at_11, t0.age_verified_at AS age_verified_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM "user" t0 WHERE t0.id = '019e1fdf-3da9-71cb-b195-c6c4c6513e7f';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	App\OAuth\Security\OAuth2Authenticator->{closure:App\OAuth\Security\OAuth2Authenticator::authenticate():75} (line 75)
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)

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

Entities Mapping

Class	Mapping errors
App\OAuth\Entity\OAuthAccessToken	No errors.
App\OAuth\Entity\OAuthClient	No errors.
App\Entity\User	No errors.
App\Entity\Device	No errors.
App\Entity\Notification	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/devices

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping