Symfony Profiler

Query Metrics

9 Database Queries

8 Different statements

4.07 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.27 ms
(31.34%)

SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = ?

Parameters:

[
  "maintenance_mode"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.clef AS clef_1,
  t0.valeur AS valeur_2
FROM
  app_config t0
WHERE
  t0.clef = ?

SELECT t0.clef AS clef_1, t0.valeur AS valeur_2 FROM app_config t0 WHERE t0.clef = 'maintenance_mode';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 19)
6	App\Service\AppConfigService->get (line 56)
7	App\EventSubscriber\MaintenanceSubscriber->onKernelRequest (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.66 ms
(16.14%)

SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.email = ? LIMIT 1

Parameters:

[
  "gbenagnonagbannon@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.uuid AS uuid_1,
  t0.email AS email_2,
  t0.prenom AS prenom_3,
  t0.nom AS nom_4,
  t0.telephone AS telephone_5,
  t0.ifu AS ifu_6,
  t0.photo AS photo_7,
  t0.roles AS roles_8,
  t0.position_updated_at AS position_updated_at_9,
  t0.type_compte AS type_compte_10,
  t0.created_at AS created_at_11,
  t0.last_login_at AS last_login_at_12,
  t0.bpay_account AS bpay_account_13,
  t0.business_pay_account AS business_pay_account_14,
  t0.care_concept_account AS care_concept_account_15,
  t0.cashline_account AS cashline_account_16,
  t0.current_lat AS current_lat_17,
  t0.current_lon AS current_lon_18,
  t19.id AS id_20,
  t19.numero_carte AS numero_carte_21,
  t19.points_actuels AS points_actuels_22,
  t19.points_totaux AS points_totaux_23,
  t19.created_at AS created_at_24,
  t19.user_uuid AS user_uuid_25
FROM
  users t0
  LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.uuid AS uuid_1, t0.email AS email_2, t0.prenom AS prenom_3, t0.nom AS nom_4, t0.telephone AS telephone_5, t0.ifu AS ifu_6, t0.photo AS photo_7, t0.roles AS roles_8, t0.position_updated_at AS position_updated_at_9, t0.type_compte AS type_compte_10, t0.created_at AS created_at_11, t0.last_login_at AS last_login_at_12, t0.bpay_account AS bpay_account_13, t0.business_pay_account AS business_pay_account_14, t0.care_concept_account AS care_concept_account_15, t0.cashline_account AS cashline_account_16, t0.current_lat AS current_lat_17, t0.current_lon AS current_lon_18, t19.id AS id_20, t19.numero_carte AS numero_carte_21, t19.points_actuels AS points_actuels_22, t19.points_totaux AS points_totaux_23, t19.created_at AS created_at_24, t19.user_uuid AS user_uuid_25 FROM users t0 LEFT JOIN fidelity_card t19 ON t19.user_uuid = t0.uuid WHERE t0.email = 'gbenagnonagbannon@gmail.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 54)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 91)
5	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
6	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 40)
7	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 115)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 178)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 156)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 138)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 38)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 58)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
18	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.57 ms
(14.10%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 477)
3	Doctrine\ORM\UnitOfWork->commit (line 414)
4	Doctrine\ORM\EntityManager->flush (line 204)
5	App\Controller\WelcomeController->welcomeBoard (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.46 ms
(11.29%)

SELECT t0.id AS id_1, t0.collab_id AS collab_id_2, t0.role AS role_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.enseigne_id AS enseigne_id_6, t0.entreprise_id AS entreprise_id_7, t0.plateforme_id AS plateforme_id_8, t0.plateforme_nom AS plateforme_nom_9, t0.user_uuid AS user_uuid_10, t0.user_email AS user_email_11, t0.user_prenom AS user_prenom_12, t0.user_nom AS user_nom_13, t0.user_photo AS user_photo_14, t0.statut AS statut_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM collaboration t0 WHERE t0.collab_id = ? LIMIT 1

Parameters:

[
  211
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.collab_id AS collab_id_2,
  t0.role AS role_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.enseigne_id AS enseigne_id_6,
  t0.entreprise_id AS entreprise_id_7,
  t0.plateforme_id AS plateforme_id_8,
  t0.plateforme_nom AS plateforme_nom_9,
  t0.user_uuid AS user_uuid_10,
  t0.user_email AS user_email_11,
  t0.user_prenom AS user_prenom_12,
  t0.user_nom AS user_nom_13,
  t0.user_photo AS user_photo_14,
  t0.statut AS statut_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17
FROM
  collaboration t0
WHERE
  t0.collab_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.collab_id AS collab_id_2, t0.role AS role_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.enseigne_id AS enseigne_id_6, t0.entreprise_id AS entreprise_id_7, t0.plateforme_id AS plateforme_id_8, t0.plateforme_nom AS plateforme_nom_9, t0.user_uuid AS user_uuid_10, t0.user_email AS user_email_11, t0.user_prenom AS user_prenom_12, t0.user_nom AS user_nom_13, t0.user_photo AS user_photo_14, t0.statut AS statut_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM collaboration t0 WHERE t0.collab_id = 211 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 176)
4	App\Controller\WelcomeController->welcomeBoard (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.35 ms
(8.68%)

SELECT t0.id AS id_1, t0.collab_id AS collab_id_2, t0.role AS role_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.enseigne_id AS enseigne_id_6, t0.entreprise_id AS entreprise_id_7, t0.plateforme_id AS plateforme_id_8, t0.plateforme_nom AS plateforme_nom_9, t0.user_uuid AS user_uuid_10, t0.user_email AS user_email_11, t0.user_prenom AS user_prenom_12, t0.user_nom AS user_nom_13, t0.user_photo AS user_photo_14, t0.statut AS statut_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM collaboration t0 WHERE t0.user_uuid = ? AND t0.plateforme_id = ?

Parameters:

[
  "759d4938-4a3a-4c94-b244-28d1bf506b0f"
  "4"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.collab_id AS collab_id_2,
  t0.role AS role_3,
  t0.date_debut AS date_debut_4,
  t0.date_fin AS date_fin_5,
  t0.enseigne_id AS enseigne_id_6,
  t0.entreprise_id AS entreprise_id_7,
  t0.plateforme_id AS plateforme_id_8,
  t0.plateforme_nom AS plateforme_nom_9,
  t0.user_uuid AS user_uuid_10,
  t0.user_email AS user_email_11,
  t0.user_prenom AS user_prenom_12,
  t0.user_nom AS user_nom_13,
  t0.user_photo AS user_photo_14,
  t0.statut AS statut_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17
FROM
  collaboration t0
WHERE
  t0.user_uuid = ?
  AND t0.plateforme_id = ?

SELECT t0.id AS id_1, t0.collab_id AS collab_id_2, t0.role AS role_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.enseigne_id AS enseigne_id_6, t0.entreprise_id AS entreprise_id_7, t0.plateforme_id AS plateforme_id_8, t0.plateforme_nom AS plateforme_nom_9, t0.user_uuid AS user_uuid_10, t0.user_email AS user_email_11, t0.user_prenom AS user_prenom_12, t0.user_nom AS user_nom_13, t0.user_photo AS user_photo_14, t0.statut AS statut_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM collaboration t0 WHERE t0.user_uuid = '759d4938-4a3a-4c94-b244-28d1bf506b0f' AND t0.plateforme_id = '4';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 974)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 209)
4	App\Controller\WelcomeController->welcomeBoard (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.31 ms
(7.75%)

UPDATE collaboration SET date_debut = ?, date_fin = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "2026-03-26 00:00:00"
  "2026-12-31 00:00:00"
  "2026-04-15 19:35:31"
  83
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  collaboration
SET
  date_debut = ?,
  date_fin = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE collaboration SET date_debut = '2026-03-26 00:00:00', date_fin = '2026-12-31 00:00:00', updated_at = '2026-04-15 19:35:31' WHERE id = 83;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 538)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 424)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1280)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 453)
5	Doctrine\ORM\UnitOfWork->commit (line 414)
6	Doctrine\ORM\EntityManager->flush (line 204)
7	App\Controller\WelcomeController->welcomeBoard (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.28 ms
(6.89%)

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.libelle AS libelle_4, t0.main_db_host AS main_db_host_5, t0.main_db_name AS main_db_name_6, t0.main_db_user AS main_db_user_7, t0.main_db_pass AS main_db_pass_8, t0.base_url AS base_url_9, t0.api_key AS api_key_10, t0.dgi_token AS dgi_token_11 FROM enseignes t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "YLWE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.libelle AS libelle_4,
  t0.main_db_host AS main_db_host_5,
  t0.main_db_name AS main_db_name_6,
  t0.main_db_user AS main_db_user_7,
  t0.main_db_pass AS main_db_pass_8,
  t0.base_url AS base_url_9,
  t0.api_key AS api_key_10,
  t0.dgi_token AS dgi_token_11
FROM
  enseignes t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.libelle AS libelle_4, t0.main_db_host AS main_db_host_5, t0.main_db_name AS main_db_name_6, t0.main_db_user AS main_db_user_7, t0.main_db_pass AS main_db_pass_8, t0.base_url AS base_url_9, t0.api_key AS api_key_10, t0.dgi_token AS dgi_token_11 FROM enseignes t0 WHERE t0.code = 'YLWE' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 364)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 275)
5	Doctrine\ORM\EntityRepository->__call (line 181)
6	App\Controller\WelcomeController->welcomeBoard (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.15 ms
(3.81%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 427)
2	Doctrine\ORM\UnitOfWork->commit (line 414)
3	Doctrine\ORM\EntityManager->flush (line 204)
4	App\Controller\WelcomeController->welcomeBoard (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\AppConfig	2
App\Entity\Users	1
App\Entity\Collaboration	1
App\Entity\Enseigne	1

Entities Mapping

Class	Mapping errors
App\Entity\AppConfig	No errors.
App\Entity\Users	No errors.
App\Entity\FidelityCard	No errors.
App\Entity\Reward	No errors.
App\Entity\HR\UserOrganizationalUnit	No errors.
App\Entity\Collaboration	No errors.
App\Entity\Enseigne	No errors.
App\Entity\PointDeVente	No errors.
App\Entity\RewardType	No errors.
App\Entity\RedemptionType	No errors.

Symfony Profiler

GET https://careconcept-n2a.myn2a.online/welcome-board

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping