Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

15.33 ms Query time

0 Invalid entities

6 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.35 ms
(28.35%)

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:

[
  "e92bf697d4b97db6e6e0a54d26934fd05d5f4664edaaaf4fc43b806b88cd5478d0eac4b4ba3f2290"
]

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 = 'e92bf697d4b97db6e6e0a54d26934fd05d5f4664edaaaf4fc43b806b88cd5478d0eac4b4ba3f2290' 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.81 ms
(24.84%)

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:

[
  "019eac94-cff8-79b3-bfae-65cf0238021a"
]

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 = '019eac94-cff8-79b3-bfae-65cf0238021a';

#	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\Api\Controller\UsageStatsController->stats (line 42)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 7)

2.69 ms
(17.52%)

SELECT d0_.id AS id_0, d0_.app_identifier AS app_identifier_1, d0_.date AS date_2, d0_.minutes_used AS minutes_used_3, d0_.created_at AS created_at_4, d0_.updated_at AS updated_at_5, d0_.device_id AS device_id_6 FROM device_app_usage d0_ WHERE d0_.device_id = ? AND d0_.date >= ? ORDER BY d0_.date ASC, d0_.app_identifier ASC

Parameters:

[
  Symfony\Component\Uid\UuidV7 {#1279
    __toString(): "019eac94-cff8-79b3-bfae-65cf0238021a"
  }
  "2026-06-12"
]

View formatted query View runnable query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.app_identifier AS app_identifier_1,
  d0_.date AS date_2,
  d0_.minutes_used AS minutes_used_3,
  d0_.created_at AS created_at_4,
  d0_.updated_at AS updated_at_5,
  d0_.device_id AS device_id_6
FROM
  device_app_usage d0_
WHERE
  d0_.device_id = ?
  AND d0_.date >= ?
ORDER BY
  d0_.date ASC,
  d0_.app_identifier ASC

SELECT d0_.id AS id_0, d0_.app_identifier AS app_identifier_1, d0_.date AS date_2, d0_.minutes_used AS minutes_used_3, d0_.created_at AS created_at_4, d0_.updated_at AS updated_at_5, d0_.device_id AS device_id_6 FROM device_app_usage d0_ WHERE d0_.device_id = '019eac94-cff8-79b3-bfae-65cf0238021a' AND d0_.date >= '2026-06-12' ORDER BY d0_.date ASC, d0_.app_identifier 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	App\Repository\DeviceAppUsageRepository->historyForDevice (line 70)
7	App\Api\Controller\UsageStatsController->stats (line 91)
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.73 ms
(11.29%)

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.63 ms
(10.61%)

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.list_type AS list_type_7, t0.daily_limit_minutes AS daily_limit_minutes_8, t0.extra_time_minutes AS extra_time_minutes_9, t0.extra_time_date AS extra_time_date_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.device_id AS device_id_13 FROM device_app_permission_override t0 WHERE t0.device_id = ?

Parameters:

[
  "019eac94-cff8-79b3-bfae-65cf0238021a"
]

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.list_type AS list_type_7,
  t0.daily_limit_minutes AS daily_limit_minutes_8,
  t0.extra_time_minutes AS extra_time_minutes_9,
  t0.extra_time_date AS extra_time_date_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.device_id AS device_id_13
FROM
  device_app_permission_override t0
WHERE
  t0.device_id = ?

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.list_type AS list_type_7, t0.daily_limit_minutes AS daily_limit_minutes_8, t0.extra_time_minutes AS extra_time_minutes_9, t0.extra_time_date AS extra_time_date_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.device_id AS device_id_13 FROM device_app_permission_override t0 WHERE t0.device_id = '019eac94-cff8-79b3-bfae-65cf0238021a';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Api\Controller\UsageStatsController->stats (line 55)
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.13 ms
(7.38%)

SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_limit_minutes AS daily_limit_minutes_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.device_id AS device_id_6 FROM device_app_category_limit t0 WHERE t0.device_id = ?

Parameters:

[
  "019eac94-cff8-79b3-bfae-65cf0238021a"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.category AS category_2,
  t0.daily_limit_minutes AS daily_limit_minutes_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.device_id AS device_id_6
FROM
  device_app_category_limit t0
WHERE
  t0.device_id = ?

SELECT t0.id AS id_1, t0.category AS category_2, t0.daily_limit_minutes AS daily_limit_minutes_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.device_id AS device_id_6 FROM device_app_category_limit t0 WHERE t0.device_id = '019eac94-cff8-79b3-bfae-65cf0238021a';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Repository\DeviceAppCategoryLimitRepository->limitsByCategoryForDevice (line 26)
5	App\Api\Controller\UsageStatsController->stats (line 62)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 191)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	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\DeviceAppPermissionOverride	2
App\OAuth\Entity\OAuthAccessToken	1
App\OAuth\Entity\OAuthClient	1
App\Entity\User	1
App\Entity\Device	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/019eac94-cff8-79b3-bfae-65cf0238021a/usage-stats?days=1&deviceId=019eac94-cff8-79b3-bfae-65cf0238021a

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping