Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

36.58 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

26.90 ms
(73.55%)

UPDATE document_client SET signature_canva = ?, signature_canva_date = ?, signature_ip = ? WHERE id = ?

Parameters:

[
  "signature-67ca00933c934.png"
  "2025-03-06 20:07:47"
  "87.88.145.157"
  2162
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  document_client
SET
  signature_canva = ?,
  signature_canva_date = ?,
  signature_ip = ?
WHERE
  id = ?

UPDATE document_client SET signature_canva = 'signature-67ca00933c934.png', signature_canva_date = '2025-03-06 20:07:47', signature_ip = '87.88.145.157' WHERE id = 2162;

#	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 1176)
7	App\Controller\DossiersController->submitSignature (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)

7.17 ms
(19.61%)

"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 1176)
4	App\Controller\DossiersController->submitSignature (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.42 ms
(3.88%)

"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 1176)
5	App\Controller\DossiersController->submitSignature (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)

1.08 ms
(2.95%)

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:

[
  "b17b54ba9bcdbaae4339b08dbe097c39f1b8b789b99dd81764b2be54c870d291"
]

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 = 'b17b54ba9bcdbaae4339b08dbe097c39f1b8b789b99dd81764b2be54c870d291' 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 1169)
4	App\Controller\DossiersController->submitSignature (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)

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.

Symfony Profiler

POST https://formatracker.com/submit-signature/b17b54ba9bcdbaae4339b08dbe097c39f1b8b789b99dd81764b2be54c870d291?p=submit-signature%2Fb17b54ba9bcdbaae4339b08dbe097c39…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping