Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

11.74 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.73 ms
(40.29%)

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:

[
  "76bbc84de07b7fd890dd64bbf2a8ea98cfd1ea5a5c6b87056eb1d38285347725036abef856b60b54"
]

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 = '76bbc84de07b7fd890dd64bbf2a8ea98cfd1ea5a5c6b87056eb1d38285347725036abef856b60b54' 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.93 ms
(33.50%)

SELECT s0_.id AS id_0, s0_.app_identifier AS app_identifier_1, s0_.granted_minutes AS granted_minutes_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.decided_at AS decided_at_5, s0_.device_id AS device_id_6 FROM screen_time_extension_request s0_ INNER JOIN device d1_ ON s0_.device_id = d1_.id WHERE d1_.parent_id = ? ORDER BY s0_.created_at DESC

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#726
    __toString(): "019e1fdf-3da9-71cb-b195-c6c4c6513e7f"
  }
]

View formatted query View runnable query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.app_identifier AS app_identifier_1,
  s0_.granted_minutes AS granted_minutes_2,
  s0_.status AS status_3,
  s0_.created_at AS created_at_4,
  s0_.decided_at AS decided_at_5,
  s0_.device_id AS device_id_6
FROM
  screen_time_extension_request s0_
  INNER JOIN device d1_ ON s0_.device_id = d1_.id
WHERE
  d1_.parent_id = ?
ORDER BY
  s0_.created_at DESC

SELECT s0_.id AS id_0, s0_.app_identifier AS app_identifier_1, s0_.granted_minutes AS granted_minutes_2, s0_.status AS status_3, s0_.created_at AS created_at_4, s0_.decided_at AS decided_at_5, s0_.device_id AS device_id_6 FROM screen_time_extension_request s0_ INNER JOIN device d1_ ON s0_.device_id = d1_.id WHERE d1_.parent_id = '019e1fdf-3da9-71cb-b195-c6c4c6513e7f' ORDER BY s0_.created_at DESC;

#	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	App\Repository\ScreenTimeExtensionRequestRepository->findForParent (line 37)
7	App\Api\Controller\ScreenTimeExtensionRequestController->list (line 84)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 7)

1.61 ms
(13.67%)

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)

1.47 ms
(12.54%)

SELECT t0.id AS id_1, t0.app_identifier AS app_identifier_2, t0.app_name AS app_name_3, t0.app_icon AS app_icon_4, t0.category AS category_5, t0.play_store_url AS play_store_url_6, t0.descriptions AS descriptions_7, t0.fetched_at AS fetched_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM app_catalog_cache t0 WHERE t0.app_identifier = ? LIMIT 1

Parameters:

[
  "com.google.android.apps.maps"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.app_identifier AS app_identifier_2,
  t0.app_name AS app_name_3,
  t0.app_icon AS app_icon_4,
  t0.category AS category_5,
  t0.play_store_url AS play_store_url_6,
  t0.descriptions AS descriptions_7,
  t0.fetched_at AS fetched_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  app_catalog_cache t0
WHERE
  t0.app_identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.app_identifier AS app_identifier_2, t0.app_name AS app_name_3, t0.app_icon AS app_icon_4, t0.category AS category_5, t0.play_store_url AS play_store_url_6, t0.descriptions AS descriptions_7, t0.fetched_at AS fetched_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM app_catalog_cache t0 WHERE t0.app_identifier = 'com.google.android.apps.maps' 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\Api\Controller\ScreenTimeExtensionRequestController->serialize (line 175)
5	App\Api\Controller\ScreenTimeExtensionRequestController->{closure:App\Api\Controller\ScreenTimeExtensionRequestController::list():83} (line 83)
6	array_map (line 82)
7	App\Api\Controller\ScreenTimeExtensionRequestController::list (line 82)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	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\User	1
App\Entity\ScreenTimeExtensionRequest	1
App\Entity\Device	1
App\Entity\AppCatalogCache	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\ScreenTimeExtensionRequest	No errors.
App\Entity\AppCatalogCache	No errors.

Symfony Profiler

GET https://nw-flow.cloud/api/screen-time-extension-requests

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping