Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.85 ms Query time

0 Invalid entities

5 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.85 ms

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.login AS login_7, t0.password AS password_8, t0.keycloak_id AS keycloak_id_9, t0.first_name AS first_name_10, t0.last_name AS last_name_11, t0.last_login AS last_login_12, t0.timezone AS timezone_13, t0.enabled AS enabled_14, t0.roles AS roles_15, t0.menu AS menu_16, t0.avatar_file AS avatar_file_17, t0.backup_codes AS backup_codes_18, t0.email_auth_code AS email_auth_code_19, t0.email_auth_code_generated_at AS email_auth_code_generated_at_20, t0.email_auth_enabled AS email_auth_enabled_21, t0.google_authenticator_enabled AS google_authenticator_enabled_22, t0.google_authenticator_secret AS google_authenticator_secret_23, t0.preferred_two_factor_provider AS preferred_two_factor_provider_24, t0.trusted_token_version AS trusted_token_version_25, t0.created_by_id AS created_by_id_26, t0.updated_by_id AS updated_by_id_27, t0.language_id AS language_id_28, t0.user_settings_id AS user_settings_id_29, t0.default_license_id AS default_license_id_30, t0.default_office_id AS default_office_id_31 FROM core.core_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.deleted_at AS deleted_at_1,
  t0.hidden AS hidden_2,
  t0.position AS position_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.id AS id_6,
  t0.login AS login_7,
  t0.password AS password_8,
  t0.keycloak_id AS keycloak_id_9,
  t0.first_name AS first_name_10,
  t0.last_name AS last_name_11,
  t0.last_login AS last_login_12,
  t0.timezone AS timezone_13,
  t0.enabled AS enabled_14,
  t0.roles AS roles_15,
  t0.menu AS menu_16,
  t0.avatar_file AS avatar_file_17,
  t0.backup_codes AS backup_codes_18,
  t0.email_auth_code AS email_auth_code_19,
  t0.email_auth_code_generated_at AS email_auth_code_generated_at_20,
  t0.email_auth_enabled AS email_auth_enabled_21,
  t0.google_authenticator_enabled AS google_authenticator_enabled_22,
  t0.google_authenticator_secret AS google_authenticator_secret_23,
  t0.preferred_two_factor_provider AS preferred_two_factor_provider_24,
  t0.trusted_token_version AS trusted_token_version_25,
  t0.created_by_id AS created_by_id_26,
  t0.updated_by_id AS updated_by_id_27,
  t0.language_id AS language_id_28,
  t0.user_settings_id AS user_settings_id_29,
  t0.default_license_id AS default_license_id_30,
  t0.default_office_id AS default_office_id_31
FROM
  core.core_user t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.deleted_at AS deleted_at_1, t0.hidden AS hidden_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.id AS id_6, t0.login AS login_7, t0.password AS password_8, t0.keycloak_id AS keycloak_id_9, t0.first_name AS first_name_10, t0.last_name AS last_name_11, t0.last_login AS last_login_12, t0.timezone AS timezone_13, t0.enabled AS enabled_14, t0.roles AS roles_15, t0.menu AS menu_16, t0.avatar_file AS avatar_file_17, t0.backup_codes AS backup_codes_18, t0.email_auth_code AS email_auth_code_19, t0.email_auth_code_generated_at AS email_auth_code_generated_at_20, t0.email_auth_enabled AS email_auth_enabled_21, t0.google_authenticator_enabled AS google_authenticator_enabled_22, t0.google_authenticator_secret AS google_authenticator_secret_23, t0.preferred_two_factor_provider AS preferred_two_factor_provider_24, t0.trusted_token_version AS trusted_token_version_25, t0.created_by_id AS created_by_id_26, t0.updated_by_id AS updated_by_id_27, t0.language_id AS language_id_28, t0.user_settings_id AS user_settings_id_29, t0.default_license_id AS default_license_id_30, t0.default_office_id AS default_office_id_31 FROM core.core_user t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 800)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
5	Doctrine\ORM\EntityManager->find (line 366)
6	Doctrine\ORM\EntityRepository->find (line 86)
7	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
8	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
9	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 227)
10	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::authenticate():80} (line 83)
13	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
14	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
15	Symfony\Component\Security\Http\Firewall\LogoutListener->authenticate (line 79)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
27	require_once (line 32)
28	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
Koredge\CoreBundle\Orm\Entity\CoreUser	1
Koredge\CoreBundle\Orm\Entity\Language	1
Koredge\CoreBundle\Orm\Entity\UserSettings	1
Koredge\CoreBundle\Orm\Entity\License	1
Koredge\CoreBundle\Orm\Entity\Office	1

Entities Mapping

Class	Mapping errors
Koredge\CoreBundle\Orm\Entity\Common	No errors.
Koredge\CoreBundle\Orm\Entity\CoreUser	No errors.
Koredge\CoreBundle\Orm\Entity\Language	No errors.
Koredge\CoreBundle\Orm\Entity\UserSettings	No errors.
Koredge\CoreBundle\Orm\Entity\License	No errors.
Koredge\CoreBundle\Orm\Entity\Office	No errors.
Koredge\CoreBundle\Orm\Entity\Grid	No errors.
Koredge\CoreBundle\Orm\Entity\View	No errors.
Koredge\CoreBundle\Orm\Entity\UserViewMm	No errors.
Koredge\CoreBundle\Orm\Entity\Role	No errors.
Koredge\CoreBundle\Orm\Entity\InternalLink	No errors.
Koredge\CoreBundle\Orm\Entity\ExternalLink	No errors.
Koredge\CoreBundle\Orm\Entity\ListingView	No errors.
Koredge\CoreBundle\Orm\Entity\Notification	No errors.
Koredge\CoreBundle\Orm\Entity\NotificationTopic	No errors.
Koredge\CoreBundle\Orm\Entity\EmailNotificationTopic	No errors.
Koredge\CoreBundle\Orm\Entity\Service	No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
Koredge\CoreBundle\Orm\Entity\API\RefreshToken	No errors.

Symfony Profiler

GET https://preprod.valmorel.smart.koredge.fr/logout

Configuration Settings

Theme

Page Width