Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

6.55 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.56 ms
(54.34%)

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:

[
  "c23422bb8e494c52f3029f82ea32b28b229e1fd0e7c42c4dc8717466c94a3edb"
]

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 = 'c23422bb8e494c52f3029f82ea32b28b229e1fd0e7c42c4dc8717466c94a3edb' 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 1189)
4	App\Controller\DossiersController->confirmationSms (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.48 ms
(22.58%)

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

0.42 ms
(6.41%)

UPDATE document_client SET code_tel = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  document_client
SET
  code_tel = ?
WHERE
  id = ?

UPDATE document_client SET code_tel = 804518 WHERE id = 1979;

#	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 1208)
7	App\Controller\DossiersController->confirmationSms (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)

0.33 ms
(5.01%)

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:

[
  10001
]

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 = 10001;

#	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 1194)
9	App\Controller\DossiersController->confirmationSms (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)

0.28 ms
(4.23%)

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:

[
  8077
]

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 = 8077;

#	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 155)
8	App\Entity\Clients->getTel (line 1195)
9	App\Controller\DossiersController->confirmationSms (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)

0.24 ms
(3.74%)

UPDATE clients SET num_edof = ? WHERE id = ?

Parameters:

[
  381058310473
  8077
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  clients
SET
  num_edof = ?
WHERE
  id = ?

UPDATE clients SET num_edof = 381058310473 WHERE id = 8077;

#	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 1208)
7	App\Controller\DossiersController->confirmationSms (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)

0.24 ms
(3.70%)

"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 1208)
4	App\Controller\DossiersController->confirmationSms (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.
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.

Symfony Profiler

GET https://formatracker.com/confirmation-sms/c23422bb8e494c52f3029f82ea32b28b229e1fd0e7c42c4dc8717466c94a3edb?p=confirmation-sms%2Fc23422bb8e494c52f3029f82ea32b28b…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping