Symfony Profiler

Query Metrics

10 Database Queries

5 Different statements

97.31 ms Query time

0 Invalid entities

35 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

57.19 ms
(58.77%)

SELECT m0_.id AS id_0, m0_.fecha_hora AS fecha_hora_1, m0_.altura AS altura_2, m1_.id AS id_3, m1_.nombre AS nombre_4, m1_.descripcion AS descripcion_5, m1_.latitud AS latitud_6, m1_.longitud AS longitud_7, m1_.agregado AS agregado_8, m1_.modificado AS modificado_9, m0_.mareografo_id AS mareografo_id_10 FROM marea m0_ INNER JOIN mareografo m1_ ON m0_.mareografo_id = m1_.id WHERE m1_.id = ? ORDER BY m0_.fecha_hora DESC LIMIT 2

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.fecha_hora AS fecha_hora_1,
  m0_.altura AS altura_2,
  m1_.id AS id_3,
  m1_.nombre AS nombre_4,
  m1_.descripcion AS descripcion_5,
  m1_.latitud AS latitud_6,
  m1_.longitud AS longitud_7,
  m1_.agregado AS agregado_8,
  m1_.modificado AS modificado_9,
  m0_.mareografo_id AS mareografo_id_10
FROM
  marea m0_
  INNER JOIN mareografo m1_ ON m0_.mareografo_id = m1_.id
WHERE
  m1_.id = ?
ORDER BY
  m0_.fecha_hora DESC
LIMIT
  2

SELECT m0_.id AS id_0, m0_.fecha_hora AS fecha_hora_1, m0_.altura AS altura_2, m1_.id AS id_3, m1_.nombre AS nombre_4, m1_.descripcion AS descripcion_5, m1_.latitud AS latitud_6, m1_.longitud AS longitud_7, m1_.agregado AS agregado_8, m1_.modificado AS modificado_9, m0_.mareografo_id AS mareografo_id_10 FROM marea m0_ INNER JOIN mareografo m1_ ON m0_.mareografo_id = m1_.id WHERE m1_.id = 1 ORDER BY m0_.fecha_hora DESC LIMIT 2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\MareaRepository->getResumenFluvialEstaciones (line 162)
7	App\Controller\DashboardController->webpage (line 55)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
10	Symfony\Component\HttpKernel\Kernel->handle (line 205)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

37.00 ms
(38.03%)

SELECT m0_.id AS id_0, m0_.fecha_hora AS fecha_hora_1, m0_.altura AS altura_2, m1_.id AS id_3, m1_.nombre AS nombre_4, m1_.descripcion AS descripcion_5, m1_.latitud AS latitud_6, m1_.longitud AS longitud_7, m1_.agregado AS agregado_8, m1_.modificado AS modificado_9, m0_.mareografo_id AS mareografo_id_10 FROM marea m0_ INNER JOIN mareografo m1_ ON m0_.mareografo_id = m1_.id ORDER BY m0_.fecha_hora DESC, m0_.id DESC LIMIT 15

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.fecha_hora AS fecha_hora_1,
  m0_.altura AS altura_2,
  m1_.id AS id_3,
  m1_.nombre AS nombre_4,
  m1_.descripcion AS descripcion_5,
  m1_.latitud AS latitud_6,
  m1_.longitud AS longitud_7,
  m1_.agregado AS agregado_8,
  m1_.modificado AS modificado_9,
  m0_.mareografo_id AS mareografo_id_10
FROM
  marea m0_
  INNER JOIN mareografo m1_ ON m0_.mareografo_id = m1_.id
ORDER BY
  m0_.fecha_hora DESC,
  m0_.id DESC
LIMIT
  15

SELECT m0_.id AS id_0, m0_.fecha_hora AS fecha_hora_1, m0_.altura AS altura_2, m1_.id AS id_3, m1_.nombre AS nombre_4, m1_.descripcion AS descripcion_5, m1_.latitud AS latitud_6, m1_.longitud AS longitud_7, m1_.agregado AS agregado_8, m1_.modificado AS modificado_9, m0_.mareografo_id AS mareografo_id_10 FROM marea m0_ INNER JOIN mareografo m1_ ON m0_.mareografo_id = m1_.id ORDER BY m0_.fecha_hora DESC, m0_.id DESC LIMIT 15;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\MareaRepository->getUltimosRegistros (line 129)
7	App\Controller\DashboardController->webpage (line 56)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 195)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
10	Symfony\Component\HttpKernel\Kernel->handle (line 205)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

2.19 ms
(2.25%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 458)
2	Doctrine\ORM\EntityManager->flush (line 270)
3	App\EventSubscriber\AuditSubscriber->flushAudit (line 110)
4	App\EventSubscriber\AuditSubscriber->onResponse (line 80)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 228)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 216)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
12	Symfony\Component\HttpKernel\Kernel->handle (line 205)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	require_once (line 5)

0.61 ms
(0.63%)

INSERT INTO audit (uuid, user_id, session_id, created_at, source_ip, url, module, action, request_body, response_body, exception, type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "05b7949760760bd17b208a00c04552d7"
  null
  ""
  "2026-11-14 09:19:15"
  "85.203.46.111"
  "http://tsc.justamente.net/webpage"
  "app_webpage"
  "App\Controller\DashboardController::webpage"
  ""
  null
  null
  "GET"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO audit (
  uuid, user_id, session_id, created_at,
  source_ip, url, module, action, request_body,
  response_body, exception, type
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO audit (uuid, user_id, session_id, created_at, source_ip, url, module, action, request_body, response_body, exception, type) VALUES ('05b7949760760bd17b208a00c04552d7', NULL, '', '2026-11-14 09:19:15', '85.203.46.111', 'http://tsc.justamente.net/webpage', 'app_webpage', 'App\\Controller\\DashboardController::webpage', '', NULL, NULL, 'GET');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 255)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1144)
4	Doctrine\ORM\UnitOfWork->commit (line 426)
5	Doctrine\ORM\EntityManager->flush (line 270)
6	App\EventSubscriber\AuditSubscriber->flushAudit (line 110)
7	App\EventSubscriber\AuditSubscriber->onResponse (line 80)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
12	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 228)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 216)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
15	Symfony\Component\HttpKernel\Kernel->handle (line 205)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
17	require_once (line 32)
18	require_once (line 5)

0.32 ms
(0.32%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 405)
2	Doctrine\ORM\EntityManager->flush (line 270)
3	App\EventSubscriber\AuditSubscriber->flushAudit (line 110)
4	App\EventSubscriber\AuditSubscriber->onResponse (line 80)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
9	Symfony\Component\HttpKernel\HttpKernel->filterResponse (line 228)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 216)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 77)
12	Symfony\Component\HttpKernel\Kernel->handle (line 205)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
14	require_once (line 32)
15	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\Marea	21
App\Entity\Mareografo	13
App\Entity\Audit	1

Entities Mapping

Class	Mapping errors
App\Entity\Audit	No errors.
App\Entity\Marea	No errors.
App\Entity\Mareografo	No errors.

Symfony Profiler

GET http://tsc.justamente.net/webpage

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping