Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

76.04 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

45.75 ms
(60.16%)

UPDATE report SET form_values = ?, notes = ? WHERE id = ?

Parameters:

[
  "{"estado_op_ini":"1","estado_fa_ini":"1","bomba_inc":"1","nivel_res":"1","acc_man_bomba":"1","acc_auto_bomba":"1","acc_man_bomba_j":"1","acc_auto_bomba_jk":"1","amp_bomba_principal_i":"4 BAR","amp_bomba_principal_f":"4.5 BAR ","pres_bomba_principal":"","amp_bomba_principal":"","volt_bomba_principal":"400 V","pres_corte_bomba_jk":"4.5 BAR","pres_arr_bomba_jk":"2,5 BAR ","pres_val_purga":"4 BAR","estado_op_final":"1","estado_fa_final":"1"}"
  "<p class="isSelectedEnd">Al concurrir al edificio, nuestros técnicos constataron que la bomba de incendio se encontraba desconectada de la alimentación eléctrica.</p><p class="isSelectedEnd">Se realizaron las pruebas de funcionamiento correspondientes y se verificó que el sistema se encuentra operativo y sin fallas.</p><p class="isSelectedEnd">No obstante, queremos hacer especial hincapié en que la bomba debe permanecer conectada permanentemente a la corriente eléctrica. En caso de una emergencia, si la bomba se encuentra desconectada, será necesario conectarla antes de poder utilizarla, lo que podría generar una demora crítica en la respuesta ante un incendio.</p><p>Asimismo, recordamos que, de acuerdo con la normativa vigente, la bomba debe permanecer conectada y disponible para su funcionamiento en todo momento.</p>"
  268
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  report
SET
  form_values = ?,
  notes = ?
WHERE
  id = ?

UPDATE report SET form_values = '{\"estado_op_ini\":\"1\",\"estado_fa_ini\":\"1\",\"bomba_inc\":\"1\",\"nivel_res\":\"1\",\"acc_man_bomba\":\"1\",\"acc_auto_bomba\":\"1\",\"acc_man_bomba_j\":\"1\",\"acc_auto_bomba_jk\":\"1\",\"amp_bomba_principal_i\":\"4 BAR\",\"amp_bomba_principal_f\":\"4.5 BAR \",\"pres_bomba_principal\":\"\",\"amp_bomba_principal\":\"\",\"volt_bomba_principal\":\"400 V\",\"pres_corte_bomba_jk\":\"4.5 BAR\",\"pres_arr_bomba_jk\":\"2,5 BAR \",\"pres_val_purga\":\"4 BAR\",\"estado_op_final\":\"1\",\"estado_fa_final\":\"1\"}', notes = '<p class=\"isSelectedEnd\">Al concurrir al edificio, nuestros técnicos constataron que la bomba de incendio se encontraba desconectada de la alimentación eléctrica.</p><p class=\"isSelectedEnd\">Se realizaron las pruebas de funcionamiento correspondientes y se verificó que el sistema se encuentra operativo y sin fallas.</p><p class=\"isSelectedEnd\">No obstante, queremos hacer especial hincapié en que la bomba debe permanecer conectada permanentemente a la corriente eléctrica. En caso de una emergencia, si la bomba se encuentra desconectada, será necesario conectarla antes de poder utilizarla, lo que podría generar una demora crítica en la respuesta ante un incendio.</p><p>Asimismo, recordamos que, de acuerdo con la normativa vigente, la bomba debe permanecer conectada y disponible para su funcionamiento en todo momento.</p>' WHERE id = 268;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 502)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 386)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1137)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 407)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 43)
7	App\Repository\ReportRepository->update (line 102)
8	App\Controller\OperatorTask\OperatorTaskController->reportManager (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

18.90 ms
(24.86%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 432)
2	Doctrine\ORM\UnitOfWork->commit (line 268)
3	Doctrine\ORM\EntityManager->flush (line 43)
4	App\Repository\ReportRepository->update (line 102)
5	App\Controller\OperatorTask\OperatorTaskController->reportManager (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

2.99 ms
(3.94%)

SELECT t0.id AS id_1, t0.form_values AS form_values_2, t0.html_form AS html_form_3, t0.notes AS notes_4 FROM report t0 WHERE t0.id = ?

Parameters:

[
  268
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.form_values AS form_values_2,
  t0.html_form AS html_form_3,
  t0.notes AS notes_4
FROM
  report t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.form_values AS form_values_2, t0.html_form AS html_form_3, t0.notes AS notes_4 FROM report t0 WHERE t0.id = 268;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 359)
5	Proxies\__CG__\App\Entity\Report::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Report->__get (line 57)
8	App\Entity\Report->getNotes (line 401)
9	Symfony\Component\PropertyAccess\PropertyAccessor->readProperty (line 102)
10	Symfony\Component\PropertyAccess\PropertyAccessor->getValue (line 97)
11	Symfony\Component\Form\Extension\Core\DataAccessor\PropertyPathAccessor->getPropertyValue (line 48)
12	Symfony\Component\Form\Extension\Core\DataAccessor\PropertyPathAccessor->getValue (line 35)
13	Symfony\Component\Form\Extension\Core\DataAccessor\ChainAccessor->getValue (line 50)
14	Symfony\Component\Form\Extension\Core\DataMapper\DataMapper->mapDataToForms (line 317)
15	Symfony\Component\Form\Form->setData (line 406)
16	Symfony\Component\Form\Form->initialize (line 171)
17	Symfony\Component\Form\FormBuilder->getForm (line 26)
18	Symfony\Component\Form\FormFactory->create (line 323)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 87)
20	App\Controller\OperatorTask\OperatorTaskController->reportManager (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

2.48 ms
(3.26%)

UPDATE task SET date_of_execution = ? WHERE id = ?

Parameters:

[
  "0026-07-03"
  427
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  task
SET
  date_of_execution = ?
WHERE
  id = ?

UPDATE task SET date_of_execution = '0026-07-03' WHERE id = 427;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 502)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 386)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1137)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 407)
5	Doctrine\ORM\UnitOfWork->commit (line 268)
6	Doctrine\ORM\EntityManager->flush (line 43)
7	App\Repository\ReportRepository->update (line 102)
8	App\Controller\OperatorTask\OperatorTaskController->reportManager (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.18 ms
(2.87%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.roles AS roles_5, t0.password AS password_6 FROM user t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.name AS name_3,
  t0.surname AS surname_4,
  t0.roles AS roles_5,
  t0.password AS password_6
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.surname AS surname_4, t0.roles AS roles_5, t0.password AS password_6 FROM user t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 61)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.89 ms
(2.48%)

"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 381)
2	Doctrine\ORM\UnitOfWork->commit (line 268)
3	Doctrine\ORM\EntityManager->flush (line 43)
4	App\Repository\ReportRepository->update (line 102)
5	App\Controller\OperatorTask\OperatorTaskController->reportManager (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

1.85 ms
(2.43%)

SELECT t0.id AS id_1, t0.month_of_execution AS month_of_execution_2, t0.expected_date AS expected_date_3, t0.date_of_execution AS date_of_execution_4, t0.title AS title_5, t0.archived AS archived_6, t0.send_report AS send_report_7, t0.template_id AS template_id_8, t0.report_id AS report_id_9, t0.client_id AS client_id_10 FROM task t0 WHERE t0.id = ?

Parameters:

[
  "427"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.month_of_execution AS month_of_execution_2,
  t0.expected_date AS expected_date_3,
  t0.date_of_execution AS date_of_execution_4,
  t0.title AS title_5,
  t0.archived AS archived_6,
  t0.send_report AS send_report_7,
  t0.template_id AS template_id_8,
  t0.report_id AS report_id_9,
  t0.client_id AS client_id_10
FROM
  task t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.month_of_execution AS month_of_execution_2, t0.expected_date AS expected_date_3, t0.date_of_execution AS date_of_execution_4, t0.title AS title_5, t0.archived AS archived_6, t0.send_report AS send_report_7, t0.template_id AS template_id_8, t0.report_id AS report_id_9, t0.client_id AS client_id_10 FROM task t0 WHERE t0.id = '427';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 65)
7	App\Controller\OperatorTask\OperatorTaskController->reportManager (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\User	1
App\Entity\Task	1
App\Entity\Template	1
App\Entity\Report	1
App\Entity\Client	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Task	No errors.
App\Entity\Template	No errors.
App\Entity\Report	No errors.
App\Entity\Client	No errors.

Symfony Profiler

POST https://mantenimiento.tdp.com.uy/tareas_operador/administrar_informes/427

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping