Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.71 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.52 ms
(52.52%)

UPDATE user SET last_connexion = ?, updated_by = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "2026-01-13 16:00:59"
  App\Entity\Administrator {#1886
    __toString(): "ADM0000002"
  }
  "2026-01-13 16:00:59"
  165
]

View formatted query View runnable query View query backtrace

UPDATE
  user
SET
  last_connexion = ?,
  updated_by = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user SET last_connexion = '2026-01-13 16:00:59', updated_by = 'ADM0000002', updated_at = '2026-01-13 16:00:59' WHERE id = 165;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeStatement (line 905)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
4	Doctrine\ORM\Persisters\Entity\JoinedSubclassPersister->update (line 211)
5	Doctrine\ORM\UnitOfWork->executeUpdates (line 1139)
6	Doctrine\ORM\UnitOfWork->commit (line 407)
7	Doctrine\ORM\EntityManager->flush (line 268)
8	App\Security\KeycloakAuthenticator->onAuthenticationSuccess (line 86)
9	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 91)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 244)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
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 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 182)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	require_once (line 5)

1.88 ms
(28.01%)

SELECT t0.id AS id_3, t0.job AS job_4, t0.unique_identifier AS unique_identifier_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.keycloak_id AS keycloak_id_9, t0.keycloak_access_token AS keycloak_access_token_10, t0.type AS type_11, t0.last_cgu_accept AS last_cgu_accept_12, t0.last_rgpd_accept AS last_rgpd_accept_13, t0.rights AS rights_14, t0.status AS status_15, t0.is_first_administrator AS is_first_administrator_16, t0.first_connexion AS first_connexion_17, t0.last_connexion AS last_connexion_18, t0.profile_picture AS profile_picture_19, t0.external_identifier AS external_identifier_20, t0.profideo_group AS profideo_group_21, t0.update_keycloak_fail AS update_keycloak_fail_22, t0.typology AS typology_23, t0.profile_user AS profile_user_24, t0.street_number AS street_number_25, t0.address AS address_26, t0.address_complement AS address_complement_27, t0.zipcode AS zipcode_28, t0.city AS city_29, t0.state AS state_30, t0.county AS county_31, t0.country AS country_32, t0.civility AS civility_33, t0.first_name AS first_name_34, t0.last_name AS last_name_35, t0.phone AS phone_36, t0.mobile AS mobile_37, t0.relationship_start_date AS relationship_start_date_38, t0.relationship_end_date AS relationship_end_date_39, t0.status_valid_refuse_date AS status_valid_refuse_date_40, t0.created_by AS created_by_41, t0.updated_by AS updated_by_42, t0.deleted_by AS deleted_by_43, t0.created_at AS created_at_44, t0.updated_at AS updated_at_45, t0.contact_commercial_id AS contact_commercial_id_46, t0.business_provider_id AS business_provider_id_47, t0.structure_id AS structure_id_48, t0.parent_id AS parent_id_49, t0.discr, t1.commentary AS commentary_50, t1.is_commercial_contact AS is_commercial_contact_51, t1.email_commercial_contact AS email_commercial_contact_52, t1.phone_commercial_contact AS phone_commercial_contact_53, t1.address_commercial_contact AS address_commercial_contact_54, t1.street_number_commercial_contact AS street_number_commercial_contact_55, t1.address_complement_commercial_contact AS address_complement_commercial_contact_56, t1.zipcode_commercial_contact AS zipcode_commercial_contact_57, t1.city_commercial_contact AS city_commercial_contact_58, t1.county_commercial_contact AS county_commercial_contact_59, t1.country_commercial_contact AS country_commercial_contact_60, t2.campaign_code AS campaign_code_61, t2.orias_transaction_number AS orias_transaction_number_62, t2.owner_orias_transaction_number AS owner_orias_transaction_number_63, t2.ccmo_code AS ccmo_code_64, t2.orias_number AS orias_number_65, t2.orias_start AS orias_start_66, t2.orias_end AS orias_end_67, t2.payment_id AS payment_id_68 FROM user t0 LEFT JOIN administrator t1 ON t0.id = t1.id LEFT JOIN seller t2 ON t0.id = t2.id WHERE t0.unique_identifier = ? LIMIT 1

Parameters:

[
  "adm0000002"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_3,
  t0.job AS job_4,
  t0.unique_identifier AS unique_identifier_5,
  t0.email AS email_6,
  t0.roles AS roles_7,
  t0.password AS password_8,
  t0.keycloak_id AS keycloak_id_9,
  t0.keycloak_access_token AS keycloak_access_token_10,
  t0.type AS type_11,
  t0.last_cgu_accept AS last_cgu_accept_12,
  t0.last_rgpd_accept AS last_rgpd_accept_13,
  t0.rights AS rights_14,
  t0.status AS status_15,
  t0.is_first_administrator AS is_first_administrator_16,
  t0.first_connexion AS first_connexion_17,
  t0.last_connexion AS last_connexion_18,
  t0.profile_picture AS profile_picture_19,
  t0.external_identifier AS external_identifier_20,
  t0.profideo_group AS profideo_group_21,
  t0.update_keycloak_fail AS update_keycloak_fail_22,
  t0.typology AS typology_23,
  t0.profile_user AS profile_user_24,
  t0.street_number AS street_number_25,
  t0.address AS address_26,
  t0.address_complement AS address_complement_27,
  t0.zipcode AS zipcode_28,
  t0.city AS city_29,
  t0.state AS state_30,
  t0.county AS county_31,
  t0.country AS country_32,
  t0.civility AS civility_33,
  t0.first_name AS first_name_34,
  t0.last_name AS last_name_35,
  t0.phone AS phone_36,
  t0.mobile AS mobile_37,
  t0.relationship_start_date AS relationship_start_date_38,
  t0.relationship_end_date AS relationship_end_date_39,
  t0.status_valid_refuse_date AS status_valid_refuse_date_40,
  t0.created_by AS created_by_41,
  t0.updated_by AS updated_by_42,
  t0.deleted_by AS deleted_by_43,
  t0.created_at AS created_at_44,
  t0.updated_at AS updated_at_45,
  t0.contact_commercial_id AS contact_commercial_id_46,
  t0.business_provider_id AS business_provider_id_47,
  t0.structure_id AS structure_id_48,
  t0.parent_id AS parent_id_49,
  t0.discr,
  t1.commentary AS commentary_50,
  t1.is_commercial_contact AS is_commercial_contact_51,
  t1.email_commercial_contact AS email_commercial_contact_52,
  t1.phone_commercial_contact AS phone_commercial_contact_53,
  t1.address_commercial_contact AS address_commercial_contact_54,
  t1.street_number_commercial_contact AS street_number_commercial_contact_55,
  t1.address_complement_commercial_contact AS address_complement_commercial_contact_56,
  t1.zipcode_commercial_contact AS zipcode_commercial_contact_57,
  t1.city_commercial_contact AS city_commercial_contact_58,
  t1.county_commercial_contact AS county_commercial_contact_59,
  t1.country_commercial_contact AS country_commercial_contact_60,
  t2.campaign_code AS campaign_code_61,
  t2.orias_transaction_number AS orias_transaction_number_62,
  t2.owner_orias_transaction_number AS owner_orias_transaction_number_63,
  t2.ccmo_code AS ccmo_code_64,
  t2.orias_number AS orias_number_65,
  t2.orias_start AS orias_start_66,
  t2.orias_end AS orias_end_67,
  t2.payment_id AS payment_id_68
FROM
  user t0
  LEFT JOIN administrator t1 ON t0.id = t1.id
  LEFT JOIN seller t2 ON t0.id = t2.id
WHERE
  t0.unique_identifier = ?
LIMIT
  1

SELECT t0.id AS id_3, t0.job AS job_4, t0.unique_identifier AS unique_identifier_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.keycloak_id AS keycloak_id_9, t0.keycloak_access_token AS keycloak_access_token_10, t0.type AS type_11, t0.last_cgu_accept AS last_cgu_accept_12, t0.last_rgpd_accept AS last_rgpd_accept_13, t0.rights AS rights_14, t0.status AS status_15, t0.is_first_administrator AS is_first_administrator_16, t0.first_connexion AS first_connexion_17, t0.last_connexion AS last_connexion_18, t0.profile_picture AS profile_picture_19, t0.external_identifier AS external_identifier_20, t0.profideo_group AS profideo_group_21, t0.update_keycloak_fail AS update_keycloak_fail_22, t0.typology AS typology_23, t0.profile_user AS profile_user_24, t0.street_number AS street_number_25, t0.address AS address_26, t0.address_complement AS address_complement_27, t0.zipcode AS zipcode_28, t0.city AS city_29, t0.state AS state_30, t0.county AS county_31, t0.country AS country_32, t0.civility AS civility_33, t0.first_name AS first_name_34, t0.last_name AS last_name_35, t0.phone AS phone_36, t0.mobile AS mobile_37, t0.relationship_start_date AS relationship_start_date_38, t0.relationship_end_date AS relationship_end_date_39, t0.status_valid_refuse_date AS status_valid_refuse_date_40, t0.created_by AS created_by_41, t0.updated_by AS updated_by_42, t0.deleted_by AS deleted_by_43, t0.created_at AS created_at_44, t0.updated_at AS updated_at_45, t0.contact_commercial_id AS contact_commercial_id_46, t0.business_provider_id AS business_provider_id_47, t0.structure_id AS structure_id_48, t0.parent_id AS parent_id_49, t0.discr, t1.commentary AS commentary_50, t1.is_commercial_contact AS is_commercial_contact_51, t1.email_commercial_contact AS email_commercial_contact_52, t1.phone_commercial_contact AS phone_commercial_contact_53, t1.address_commercial_contact AS address_commercial_contact_54, t1.street_number_commercial_contact AS street_number_commercial_contact_55, t1.address_complement_commercial_contact AS address_complement_commercial_contact_56, t1.zipcode_commercial_contact AS zipcode_commercial_contact_57, t1.city_commercial_contact AS city_commercial_contact_58, t1.county_commercial_contact AS county_commercial_contact_59, t1.country_commercial_contact AS country_commercial_contact_60, t2.campaign_code AS campaign_code_61, t2.orias_transaction_number AS orias_transaction_number_62, t2.owner_orias_transaction_number AS owner_orias_transaction_number_63, t2.ccmo_code AS ccmo_code_64, t2.orias_number AS orias_number_65, t2.orias_start AS orias_start_66, t2.orias_end AS orias_end_67, t2.payment_id AS payment_id_68 FROM user t0 LEFT JOIN administrator t1 ON t0.id = t1.id LEFT JOIN seller t2 ON t0.id = t2.id WHERE t0.unique_identifier = 'adm0000002' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	App\Security\KeycloakAuthenticator->{closure:App\Security\KeycloakAuthenticator::authenticate():60} (line 63)
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 126)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
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 46)
20	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
21	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 126)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 182)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.76 ms
(11.30%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 234)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->beginTransaction (line 143)
3	Doctrine\DBAL\Connection->beginTransaction (line 1054)
4	Doctrine\ORM\UnitOfWork->commit (line 381)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Security\KeycloakAuthenticator->onAuthenticationSuccess (line 86)
7	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 91)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 244)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
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 46)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.55 ms
(8.17%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 234)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->commit (line 153)
3	Doctrine\DBAL\Connection->commit (line 1079)
4	Doctrine\ORM\UnitOfWork->commit (line 432)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Security\KeycloakAuthenticator->onAuthenticationSuccess (line 86)
7	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->onAuthenticationSuccess (line 91)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->handleAuthenticationSuccess (line 244)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 230)
10	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
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 46)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
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 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	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\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Page	No errors.
App\Entity\Variable	No errors.
App\Entity\Autocomponent	No errors.
App\Entity\User	No errors.
App\Entity\Administrator	No errors.
App\Entity\Seller	No errors.
App\Entity\BusinessProvider	No errors.
App\Entity\RightsGroup	No errors.
App\Entity\MessageSent	No errors.
App\Entity\UserRelaunch	No errors.

Symfony Profiler

GET https://recette.lourmel-sa.com/extranet/connect/keycloak/check?code=ff88c407-55e9-4536-9338-507ce7b7fa2d.627d61cb-54a6-4773-ac01-62a061a50e00.bd3efbed-740b-43a4…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping