Symfony Profiler

Query Metrics

10 Database Queries

10 Different statements

6.47 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.64 ms
(25.30%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.tel AS tel_7, t0.societe_id AS societe_id_8 FROM user t0 WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.nom AS nom_5,
  t0.prenom AS prenom_6,
  t0.tel AS tel_7,
  t0.societe_id AS societe_id_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.tel AS tel_7, t0.societe_id AS societe_id_8 FROM user t0 WHERE t0.id = 7;

#	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 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 73)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 158)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

1.09 ms
(16.78%)

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.prenom AS prenom_2, c0_.mail AS mail_3, c0_.adresse AS adresse_4, c0_.ville AS ville_5, c0_.tel AS tel_6, c0_.num_edof AS num_edof_7, c0_.date_creation AS date_creation_8, c0_.vendeur AS vendeur_9, c0_.cp AS cp_10, c0_.date_naissance AS date_naissance_11, c0_.lieu_naissance AS lieu_naissance_12, c0_.statut_id AS statut_id_13, c0_.statut_prospect_id AS statut_prospect_id_14, c0_.provenance_id AS provenance_id_15, c0_.categorie_id AS categorie_id_16, c0_.civilite_id AS civilite_id_17, c0_.societe_id AS societe_id_18 FROM clients c0_ WHERE c0_.societe_id = ? AND c0_.id IN (?)

Parameters:

[
  1
  "8118"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.prenom AS prenom_2,
  c0_.mail AS mail_3,
  c0_.adresse AS adresse_4,
  c0_.ville AS ville_5,
  c0_.tel AS tel_6,
  c0_.num_edof AS num_edof_7,
  c0_.date_creation AS date_creation_8,
  c0_.vendeur AS vendeur_9,
  c0_.cp AS cp_10,
  c0_.date_naissance AS date_naissance_11,
  c0_.lieu_naissance AS lieu_naissance_12,
  c0_.statut_id AS statut_id_13,
  c0_.statut_prospect_id AS statut_prospect_id_14,
  c0_.provenance_id AS provenance_id_15,
  c0_.categorie_id AS categorie_id_16,
  c0_.civilite_id AS civilite_id_17,
  c0_.societe_id AS societe_id_18
FROM
  clients c0_
WHERE
  c0_.societe_id = ?
  AND c0_.id IN (?)

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.prenom AS prenom_2, c0_.mail AS mail_3, c0_.adresse AS adresse_4, c0_.ville AS ville_5, c0_.tel AS tel_6, c0_.num_edof AS num_edof_7, c0_.date_creation AS date_creation_8, c0_.vendeur AS vendeur_9, c0_.cp AS cp_10, c0_.date_naissance AS date_naissance_11, c0_.lieu_naissance AS lieu_naissance_12, c0_.statut_id AS statut_id_13, c0_.statut_prospect_id AS statut_prospect_id_14, c0_.provenance_id AS provenance_id_15, c0_.categorie_id AS categorie_id_16, c0_.civilite_id AS civilite_id_17, c0_.societe_id AS societe_id_18 FROM clients c0_ WHERE c0_.societe_id = 1 AND c0_.id IN ('8118');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 108)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 95)
8	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 76)
10	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 43)
11	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 1014)
12	Symfony\Component\Form\Form->viewToNorm (line 558)
13	Symfony\Component\Form\Form->submit (line 499)
14	Symfony\Component\Form\Form->submit (line 109)
15	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 420)
16	Symfony\Component\Form\Form->handleRequest (line 542)
17	App\Controller\DossiersController->update (line 182)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.58 ms
(9.00%)

UPDATE clients SET num_edof = ? WHERE id = ?

Parameters:

[
  421171060211
  8118
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  clients
SET
  num_edof = ?
WHERE
  id = ?

UPDATE clients SET num_edof = 421171060211 WHERE id = 8118;

#	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 544)
7	App\Controller\DossiersController->update (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.57 ms
(8.77%)

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:

[
  8118
]

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

#	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 111)
7	Proxies\__CG__\App\Entity\Clients->__load (line 3538)
8	Doctrine\ORM\UnitOfWork->initializeObject (line 953)
9	Doctrine\ORM\EntityManager->initializeObject (line 87)
10	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 49)
11	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->Symfony\Component\Form\ChoiceList\Loader\{closure} (line 1)
12	array_map (line 49)
13	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadValuesForChoices (line 81)
14	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 34)
15	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 992)
16	Symfony\Component\Form\Form->normToView (line 301)
17	Symfony\Component\Form\Form->setData (line 50)
18	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
19	Symfony\Component\Form\Form->setData (line 412)
20	Symfony\Component\Form\Form->initialize (line 176)
21	Symfony\Component\Form\FormBuilder->getForm (line 28)
22	Symfony\Component\Form\FormFactory->create (line 344)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 538)
24	App\Controller\DossiersController->update (line 182)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.56 ms
(8.67%)

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.societe_id = ? AND t0.session_client_id = ? ORDER BY t0.date DESC

Parameters:

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.societe_id = ?
  AND t0.session_client_id = ?
ORDER BY
  t0.date DESC

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.societe_id = 1 AND t0.session_client_id = 10045 ORDER BY t0.date DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 527)
4	App\Controller\DossiersController->update (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)

0.55 ms
(8.57%)

SELECT s0_.id AS id_0, s0_.titre AS titre_1, s0_.date_entree AS date_entree_2, s0_.date_sortie AS date_sortie_3, s0_.lieu AS lieu_4, s0_.formation_id AS formation_id_5, s0_.format_id AS format_id_6, s0_.mode_id AS mode_id_7, s0_.provenance_id AS provenance_id_8, s0_.referant_id AS referant_id_9, s0_.societe_id AS societe_id_10 FROM sessions s0_ WHERE s0_.societe_id = ? AND s0_.id IN (?)

Parameters:

[
  1
  "5162"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.titre AS titre_1,
  s0_.date_entree AS date_entree_2,
  s0_.date_sortie AS date_sortie_3,
  s0_.lieu AS lieu_4,
  s0_.formation_id AS formation_id_5,
  s0_.format_id AS format_id_6,
  s0_.mode_id AS mode_id_7,
  s0_.provenance_id AS provenance_id_8,
  s0_.referant_id AS referant_id_9,
  s0_.societe_id AS societe_id_10
FROM
  sessions s0_
WHERE
  s0_.societe_id = ?
  AND s0_.id IN (?)

SELECT s0_.id AS id_0, s0_.titre AS titre_1, s0_.date_entree AS date_entree_2, s0_.date_sortie AS date_sortie_3, s0_.lieu AS lieu_4, s0_.formation_id AS formation_id_5, s0_.format_id AS format_id_6, s0_.mode_id AS mode_id_7, s0_.provenance_id AS provenance_id_8, s0_.referant_id AS referant_id_9, s0_.societe_id AS societe_id_10 FROM sessions s0_ WHERE s0_.societe_id = 1 AND s0_.id IN ('5162');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 325)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 108)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntitiesByIds (line 95)
8	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->doLoadChoicesForValues (line 38)
9	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoicesForValues (line 76)
10	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoicesForValues (line 43)
11	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->reverseTransform (line 1014)
12	Symfony\Component\Form\Form->viewToNorm (line 558)
13	Symfony\Component\Form\Form->submit (line 499)
14	Symfony\Component\Form\Form->submit (line 109)
15	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 420)
16	Symfony\Component\Form\Form->handleRequest (line 542)
17	App\Controller\DossiersController->update (line 182)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.48 ms
(7.35%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_entree AS date_entree_3, t0.date_sortie AS date_sortie_4, t0.lieu AS lieu_5, t0.formation_id AS formation_id_6, t0.format_id AS format_id_7, t0.mode_id AS mode_id_8, t0.provenance_id AS provenance_id_9, t0.referant_id AS referant_id_10, t0.societe_id AS societe_id_11 FROM sessions t0 WHERE t0.id = ?

Parameters:

[
  5162
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.date_entree AS date_entree_3,
  t0.date_sortie AS date_sortie_4,
  t0.lieu AS lieu_5,
  t0.formation_id AS formation_id_6,
  t0.format_id AS format_id_7,
  t0.mode_id AS mode_id_8,
  t0.provenance_id AS provenance_id_9,
  t0.referant_id AS referant_id_10,
  t0.societe_id AS societe_id_11
FROM
  sessions t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_entree AS date_entree_3, t0.date_sortie AS date_sortie_4, t0.lieu AS lieu_5, t0.formation_id AS formation_id_6, t0.format_id AS format_id_7, t0.mode_id AS mode_id_8, t0.provenance_id AS provenance_id_9, t0.referant_id AS referant_id_10, t0.societe_id AS societe_id_11 FROM sessions t0 WHERE t0.id = 5162;

#	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 111)
7	Proxies\__CG__\App\Entity\Sessions->__load (line 3538)
8	Doctrine\ORM\UnitOfWork->initializeObject (line 953)
9	Doctrine\ORM\EntityManager->initializeObject (line 87)
10	Symfony\Bridge\Doctrine\Form\ChoiceList\IdReader->getIdValue (line 49)
11	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->Symfony\Component\Form\ChoiceList\Loader\{closure} (line 1)
12	array_map (line 49)
13	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadValuesForChoices (line 81)
14	Symfony\Component\Form\ChoiceList\LazyChoiceList->getValuesForChoices (line 34)
15	Symfony\Component\Form\Extension\Core\DataTransformer\ChoiceToValueTransformer->transform (line 992)
16	Symfony\Component\Form\Form->normToView (line 301)
17	Symfony\Component\Form\Form->setData (line 50)
18	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 323)
19	Symfony\Component\Form\Form->setData (line 412)
20	Symfony\Component\Form\Form->initialize (line 176)
21	Symfony\Component\Form\FormBuilder->getForm (line 28)
22	Symfony\Component\Form\FormFactory->create (line 344)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 538)
24	App\Controller\DossiersController->update (line 182)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.46 ms
(7.07%)

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:

[
  10045
]

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

#	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 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 522)
6	App\Controller\DossiersController->update (line 182)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.33 ms
(5.16%)

"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 544)
4	App\Controller\DossiersController->update (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)

0.22 ms
(3.34%)

"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 544)
5	App\Controller\DossiersController->update (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\User	No errors.
App\Entity\Societe	No errors.
App\Entity\SessionClient	No errors.
App\Entity\Clients	No errors.
App\Entity\Sessions	No errors.
App\Entity\DocumentClient	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\Formations	No errors.
App\Entity\Format	No errors.
App\Entity\Mode	No errors.
App\Entity\Referent	No errors.
App\Entity\HitoriqueMail	No errors.

Symfony Profiler

POST https://formatracker.com/erp/dossiers/modifier/10045?activeTab=fiche&p=erp%2Fdossiers%2Fmodifier%2F10045

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping