Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

55.61 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

18.82 ms
(33.85%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.num_edof AS num_edof_3, t0.client_id AS client_id_4, t0.session_id AS session_id_5, t0.societe_id AS societe_id_6 FROM session_client t0 WHERE t0.id = ?

Parameters:

[
  10023
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.num_edof AS num_edof_3,
  t0.client_id AS client_id_4,
  t0.session_id AS session_id_5,
  t0.societe_id AS societe_id_6
FROM
  session_client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.num_edof AS num_edof_3, t0.client_id AS client_id_4, t0.session_id AS session_id_5, t0.societe_id AS societe_id_6 FROM session_client t0 WHERE t0.id = 10023;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\SessionClient->__get (line 65)
8	App\Entity\SessionClient->getClient (line 1297)
9	App\Controller\DossiersController->confirmationCode (line 182)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

12.59 ms
(22.64%)

"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 424)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 1273)
4	App\Controller\DossiersController->confirmationCode (line 182)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

9.86 ms
(17.74%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.mail AS mail_4, t0.adresse AS adresse_5, t0.ville AS ville_6, t0.tel AS tel_7, t0.num_edof AS num_edof_8, t0.date_creation AS date_creation_9, t0.vendeur AS vendeur_10, t0.cp AS cp_11, t0.date_naissance AS date_naissance_12, t0.lieu_naissance AS lieu_naissance_13, t0.statut_id AS statut_id_14, t0.statut_prospect_id AS statut_prospect_id_15, t0.provenance_id AS provenance_id_16, t0.categorie_id AS categorie_id_17, t0.civilite_id AS civilite_id_18, t0.societe_id AS societe_id_19 FROM clients t0 WHERE t0.id = ?

Parameters:

[
  8098
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.prenom AS prenom_3,
  t0.mail AS mail_4,
  t0.adresse AS adresse_5,
  t0.ville AS ville_6,
  t0.tel AS tel_7,
  t0.num_edof AS num_edof_8,
  t0.date_creation AS date_creation_9,
  t0.vendeur AS vendeur_10,
  t0.cp AS cp_11,
  t0.date_naissance AS date_naissance_12,
  t0.lieu_naissance AS lieu_naissance_13,
  t0.statut_id AS statut_id_14,
  t0.statut_prospect_id AS statut_prospect_id_15,
  t0.provenance_id AS provenance_id_16,
  t0.categorie_id AS categorie_id_17,
  t0.civilite_id AS civilite_id_18,
  t0.societe_id AS societe_id_19
FROM
  clients t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.mail AS mail_4, t0.adresse AS adresse_5, t0.ville AS ville_6, t0.tel AS tel_7, t0.num_edof AS num_edof_8, t0.date_creation AS date_creation_9, t0.vendeur AS vendeur_10, t0.cp AS cp_11, t0.date_naissance AS date_naissance_12, t0.lieu_naissance AS lieu_naissance_13, t0.statut_id AS statut_id_14, t0.statut_prospect_id AS statut_prospect_id_15, t0.provenance_id AS provenance_id_16, t0.categorie_id AS categorie_id_17, t0.civilite_id AS civilite_id_18, t0.societe_id AS societe_id_19 FROM clients t0 WHERE t0.id = 8098;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 789)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 248)
4	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 134)
5	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 97)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
7	Proxies\__CG__\App\Entity\Clients->__get (line 95)
8	App\Entity\Clients->getNom (line 1297)
9	App\Controller\DossiersController->confirmationCode (line 182)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

7.35 ms
(13.21%)

UPDATE document_client SET signature_sms_date = ? WHERE id = ?

Parameters:

[
  "2025-03-03 10:27:05"
  2114
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  document_client
SET
  signature_sms_date = ?
WHERE
  id = ?

UPDATE document_client SET signature_sms_date = '2025-03-03 10:27:05' WHERE id = 2114;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 528)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 414)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1271)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 448)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 1273)
7	App\Controller\DossiersController->confirmationCode (line 182)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

5.29 ms
(9.52%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.lien AS lien_3, t0.date AS date_4, t0.signature AS signature_5, t0.signature_canva AS signature_canva_6, t0.code_tel AS code_tel_7, t0.signature_envoi AS signature_envoi_8, t0.signature_canva_date AS signature_canva_date_9, t0.signature_ip AS signature_ip_10, t0.signature_sms_date AS signature_sms_date_11, t0.token AS token_12, t0.auto_send AS auto_send_13, t0.generate AS generate_14, t0.session_client_id AS session_client_id_15, t0.societe_id AS societe_id_16 FROM document_client t0 WHERE t0.token = ? LIMIT 1

Parameters:

[
  "96c2f0836552a622b6c3773d69f5915066f356693254849aabb5f8c48532f7fd"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.lien AS lien_3,
  t0.date AS date_4,
  t0.signature AS signature_5,
  t0.signature_canva AS signature_canva_6,
  t0.code_tel AS code_tel_7,
  t0.signature_envoi AS signature_envoi_8,
  t0.signature_canva_date AS signature_canva_date_9,
  t0.signature_ip AS signature_ip_10,
  t0.signature_sms_date AS signature_sms_date_11,
  t0.token AS token_12,
  t0.auto_send AS auto_send_13,
  t0.generate AS generate_14,
  t0.session_client_id AS session_client_id_15,
  t0.societe_id AS societe_id_16
FROM
  document_client t0
WHERE
  t0.token = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.lien AS lien_3, t0.date AS date_4, t0.signature AS signature_5, t0.signature_canva AS signature_canva_6, t0.code_tel AS code_tel_7, t0.signature_envoi AS signature_envoi_8, t0.signature_canva_date AS signature_canva_date_9, t0.signature_ip AS signature_ip_10, t0.signature_sms_date AS signature_sms_date_11, t0.token AS token_12, t0.auto_send AS auto_send_13, t0.generate AS generate_14, t0.session_client_id AS session_client_id_15, t0.societe_id AS societe_id_16 FROM document_client t0 WHERE t0.token = '96c2f0836552a622b6c3773d69f5915066f356693254849aabb5f8c48532f7fd' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 1263)
4	App\Controller\DossiersController->confirmationCode (line 182)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.69 ms
(3.05%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1422)
2	Doctrine\DBAL\Connection->commit (line 472)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 1273)
5	App\Controller\DossiersController->confirmationCode (line 182)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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.

Entities Mapping

Class	Mapping errors
App\Entity\DocumentClient	No errors.
App\Entity\SessionClient	No errors.
App\Entity\Societe	No errors.
App\Entity\Clients	No errors.
App\Entity\Sessions	No errors.
App\Entity\Statut	No errors.
App\Entity\StatutProspect	No errors.
App\Entity\Provenance	No errors.
App\Entity\Categorie	No errors.
App\Entity\Civilite	No errors.
App\Entity\HitoriqueMail	No errors.
App\Entity\Formations	No errors.
App\Entity\DocumentsFormation	No errors.
App\Entity\Format	No errors.
App\Entity\Tva	No errors.
App\Entity\Admission	No errors.
App\Entity\Referent	No errors.
App\Entity\Mode	No errors.
App\Entity\Drive	No errors.
App\Entity\User	No errors.
App\Entity\ModelDocument	No errors.
App\Entity\Variables	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://formatracker.com/code-confirmation/96c2f0836552a622b6c3773d69f5915066f356693254849aabb5f8c48532f7fd?code=541300&p=code-confirmation%2F96c2f0836552a622b6…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping