Query Metrics
21
Database Queries
5
Different statements
183.70 ms
Query time
0
Invalid entities
31
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 10.79 ms |
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
]
|
||||||||||||||||||||||||||||||||
| 2 | 11.16 ms |
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:
[
2
]
|
||||||||||||||||||||||||||||||||
| 3 | 10.57 ms |
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:
[
3
]
|
||||||||||||||||||||||||||||||||
| 4 | 7.24 ms |
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:
[
11
]
|
||||||||||||||||||||||||||||||||
| 5 | 10.26 ms |
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:
[
4
]
|
||||||||||||||||||||||||||||||||
| 6 | 10.34 ms |
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:
[
6
]
|
||||||||||||||||||||||||||||||||
| 7 | 8.53 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
11
]
|
||||||||||||||||||||||||||||||||
| 8 | 11.10 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 9 | 10.59 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||
| 10 | 10.43 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
3
]
|
||||||||||||||||||||||||||||||||
| 11 | 10.98 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
4
]
|
||||||||||||||||||||||||||||||||
| 12 | 11.03 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||||
| 13 | 10.77 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
6
]
|
||||||||||||||||||||||||||||||||
| 14 | 10.37 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
7
]
|
||||||||||||||||||||||||||||||||
| 15 | 10.81 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
8
]
|
||||||||||||||||||||||||||||||||
| 16 | 11.96 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
10
]
|
||||||||||||||||||||||||||||||||
| 17 | 10.34 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
9
]
|
||||||||||||||||||||||||||||||||
| 18 | 2.11 ms |
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, m0_.id DESC LIMIT 1
Parameters:
[
12
]
|
||||||||||||||||||||||||||||||||
| 19 | 0.34 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||||||||
| 20 | 0.60 ms |
INSERT INTO audit (uuid, user_id, session_id, created_at, source_ip, url, module, action, request_body, response_body, exception, type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "471111460011b03592c404311fc2c432" null "cb4a83e0e518c5beb31d76f2aa2b1a63" "2026-11-16 15:32:47" "216.73.217.152" "https://portal.tigresailing.club/webpage" "app_webpage" "App\Controller\DashboardController::webpage" "" null null "GET" ] |
||||||||||||||||||||||||||||||||
| 21 | 3.38 ms |
"COMMIT"
Parameters:
[]
|
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 | 18 |
| App\Entity\Mareografo | 12 |
| App\Entity\Audit | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Audit | No errors. |
| App\Entity\Marea | No errors. |
| App\Entity\Mareografo | No errors. |