Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.51 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.55 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed_at AS password_changed_at_5, t0.password_reset_required AS password_reset_required_6, t0.is_active AS is_active_7, t0.preferences AS preferences_8, t0.sso_id AS sso_id_9, t0.sso_provider AS sso_provider_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.personne_id AS personne_id_14 FROM `user` t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))

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.password_changed_at AS password_changed_at_5,
  t0.password_reset_required AS password_reset_required_6,
  t0.is_active AS is_active_7,
  t0.preferences AS preferences_8,
  t0.sso_id AS sso_id_9,
  t0.sso_provider AS sso_provider_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.personne_id AS personne_id_14
FROM
  `user` t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.password_changed_at AS password_changed_at_5, t0.password_reset_required AS password_reset_required_6, t0.is_active AS is_active_7, t0.preferences AS preferences_8, t0.sso_id AS sso_id_9, t0.sso_provider AS sso_provider_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.personne_id AS personne_id_14 FROM `user` t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

#	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	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 191)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 14)

0.39 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM feature_flag t0 WHERE ((t0.deleted_at IS NULL))

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.enabled AS enabled_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  feature_flag t0
WHERE
  (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.code AS code_2, t0.enabled AS enabled_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6 FROM feature_flag t0 WHERE ((t0.deleted_at IS NULL));

#	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	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Core\Service\FeatureManager->getDbOverrides (line 273)
6	App\Core\Service\FeatureManager->resolveFeature (line 119)
7	App\Core\Service\FeatureManager->isEnabled (line 77)
8	App\Core\Service\AppMessageService->getUnseenMessages (line 67)
9	App\Core\Controller\Api\AppMessageApiController->list (line 50)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 14)

0.57 ms

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.type AS type_3, a0_.is_active AS is_active_4, a0_.starts_at AS starts_at_5, a0_.expires_at AS expires_at_6, a0_.audience AS audience_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.deleted_at AS deleted_at_10, a0_.author_id AS author_id_11 FROM app_message a0_ WHERE (a0_.is_active = 1 AND a0_.deleted_at IS NULL AND (a0_.starts_at IS NULL OR a0_.starts_at <= ?) AND (a0_.expires_at IS NULL OR a0_.expires_at >= ?)) AND (a0_.deleted_at IS NULL) ORDER BY a0_.created_at DESC

Parameters:

[
  "2026-06-02 12:03:13"
  "2026-06-02 12:03:13"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.content AS content_2,
  a0_.type AS type_3,
  a0_.is_active AS is_active_4,
  a0_.starts_at AS starts_at_5,
  a0_.expires_at AS expires_at_6,
  a0_.audience AS audience_7,
  a0_.created_at AS created_at_8,
  a0_.updated_at AS updated_at_9,
  a0_.deleted_at AS deleted_at_10,
  a0_.author_id AS author_id_11
FROM
  app_message a0_
WHERE
  (
    a0_.is_active = 1
    AND a0_.deleted_at IS NULL
    AND (
      a0_.starts_at IS NULL
      OR a0_.starts_at <= ?
    )
    AND (
      a0_.expires_at IS NULL
      OR a0_.expires_at >= ?
    )
  )
  AND (a0_.deleted_at IS NULL)
ORDER BY
  a0_.created_at DESC

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.type AS type_3, a0_.is_active AS is_active_4, a0_.starts_at AS starts_at_5, a0_.expires_at AS expires_at_6, a0_.audience AS audience_7, a0_.created_at AS created_at_8, a0_.updated_at AS updated_at_9, a0_.deleted_at AS deleted_at_10, a0_.author_id AS author_id_11 FROM app_message a0_ WHERE (a0_.is_active = 1 AND a0_.deleted_at IS NULL AND (a0_.starts_at IS NULL OR a0_.starts_at <= '2026-06-02 12:03:13') AND (a0_.expires_at IS NULL OR a0_.expires_at >= '2026-06-02 12:03:13')) AND (a0_.deleted_at IS NULL) ORDER BY a0_.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\Core\Repository\AppMessageRepository->findCurrentlyActive (line 53)
7	App\Core\Service\AppMessageService->getUnseenNotices (line 214)
8	App\Core\Service\AppMessageService->getUnseenMessages (line 86)
9	App\Core\Controller\Api\AppMessageApiController->list (line 50)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 191)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 14)

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\Core\Entity\User	1
App\Core\Entity\Personne	1

Entities Mapping

Class	Mapping errors
App\Core\Entity\User	No errors.
App\Core\Entity\Personne	No errors.
App\Core\Entity\Group	No errors.
App\Core\Entity\UserPermission	No errors.
App\Core\Entity\PermissionSchedule	No errors.
App\Core\Entity\NetworkRule	No errors.
App\Core\Entity\FeatureFlag	No errors.
App\Core\Entity\AppMessage	No errors.

Symfony Profiler

GET https://myworkspace.val.lab/api/app/messages

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping