Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

21.67 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

13.84 ms
(63.86%)

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:

[
  "259e895fd136283cc825900fc2f480b9f26b4ca6cc62711e8b6a7bc937c24228"
]

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 = '259e895fd136283cc825900fc2f480b9f26b4ca6cc62711e8b6a7bc937c24228' 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)

4.03 ms
(18.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)

2.46 ms
(11.36%)

"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.34 ms
(6.17%)

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

Parameters:

[
  "signature-67acb92f812d0.png"
  "2025-02-12 15:07:27"
  "37.165.55.83"
  1907
]

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-67acb92f812d0.png', signature_canva_date = '2025-02-12 15:07:27', signature_ip = '37.165.55.83' WHERE id = 1907;

#	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)

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/259e895fd136283cc825900fc2f480b9f26b4ca6cc62711e8b6a7bc937c24228?p=submit-signature%2F259e895fd136283cc825900fc2f480b9…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping