Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.07 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.64 ms

SELECT a0_.id AS id_0, a0_.token_hash AS token_hash_1, a0_.last_used_at AS last_used_at_2, a0_.expires_at AS expires_at_3, a0_.revoked_at AS revoked_at_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.user_id AS user_id_7 FROM api_token a0_ WHERE a0_.token_hash = ? AND a0_.revoked_at IS NULL AND a0_.expires_at > ?

Parameters:

[
  "51642cefd14329b7f82f6b1ddea3d7796fe895386a58e26d4fb4b99a8ca610cf"
  "2026-09-13 12:53:19"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.token_hash AS token_hash_1,
  a0_.last_used_at AS last_used_at_2,
  a0_.expires_at AS expires_at_3,
  a0_.revoked_at AS revoked_at_4,
  a0_.created_at AS created_at_5,
  a0_.updated_at AS updated_at_6,
  a0_.user_id AS user_id_7
FROM
  api_token a0_
WHERE
  a0_.token_hash = ?
  AND a0_.revoked_at IS NULL
  AND a0_.expires_at > ?

SELECT a0_.id AS id_0, a0_.token_hash AS token_hash_1, a0_.last_used_at AS last_used_at_2, a0_.expires_at AS expires_at_3, a0_.revoked_at AS revoked_at_4, a0_.created_at AS created_at_5, a0_.updated_at AS updated_at_6, a0_.user_id AS user_id_7 FROM api_token a0_ WHERE a0_.token_hash = '51642cefd14329b7f82f6b1ddea3d7796fe895386a58e26d4fb4b99a8ca610cf' AND a0_.revoked_at IS NULL AND a0_.expires_at > '2026-09-13 12:53:19';

#	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->getOneOrNullResult (line 737)
6	App\Repository\ApiTokenRepository->findActiveByHash (line 30)
7	App\Security\ApiTokenAuthenticator->authenticate (line 48)
8	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 74)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 172)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
12	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
13	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
14	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
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 5)

0.68 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5, t0.timezone AS timezone_6, t0.base_currency AS base_currency_7, t0.default_ai_language AS default_ai_language_8, t0.economic_calendar_preferences AS economic_calendar_preferences_9, t0.last_seen_at AS last_seen_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.display_name AS display_name_5,
  t0.timezone AS timezone_6,
  t0.base_currency AS base_currency_7,
  t0.default_ai_language AS default_ai_language_8,
  t0.economic_calendar_preferences AS economic_calendar_preferences_9,
  t0.last_seen_at AS last_seen_at_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.display_name AS display_name_5, t0.timezone AS timezone_6, t0.base_currency AS base_currency_7, t0.default_ai_language AS default_ai_language_8, t0.economic_calendar_preferences AS economic_calendar_preferences_9, t0.last_seen_at AS last_seen_at_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM `user` t0 WHERE t0.id = 1;

#	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\Entity\User::getRoles (line 134)
5	Symfony\Component\Security\Http\Authenticator\AbstractAuthenticator->createToken (line 31)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->createToken (line 84)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 194)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 154)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 136)
10	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.75 ms

SELECT t0.id AS id_1, t0.type AS type_2, t0.is_read AS is_read_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6, t0.trade_id AS trade_id_7 FROM notification t0 WHERE t0.user_id = ? AND t0.is_read = ? ORDER BY t0.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.is_read AS is_read_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.user_id AS user_id_6,
  t0.trade_id AS trade_id_7
FROM
  notification t0
WHERE
  t0.user_id = ?
  AND t0.is_read = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.type AS type_2, t0.is_read AS is_read_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6, t0.trade_id AS trade_id_7 FROM notification t0 WHERE t0.user_id = 1 AND t0.is_read = 0 ORDER BY t0.created_at DESC;

#	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\Controller\NotificationController->list (line 19)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	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
App\Entity\ApiToken	1
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\ApiToken	No errors.
App\Entity\User	No errors.
App\Entity\Broker	No errors.
App\Entity\TradingAccount	No errors.
App\Entity\Tag	No errors.
App\Entity\Trade	No errors.
App\Entity\Symbol	No errors.
App\Entity\Market	No errors.
App\Entity\Bias	No errors.
App\Entity\Notification	No errors.

Symfony Profiler

GET https://trade.api.eventually.biz/api/v1/notifications

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping