Query Metrics
22
Database Queries
6
Different statements
2.88 ms
Query time
4
Invalid entities
152
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.18 ms |
SELECT t0.id AS id_1, t0.host AS host_2, t0.puerto AS puerto_3, t0.seguridad AS seguridad_4, t0.email AS email_5, t0.password AS password_6 FROM smtp t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||
| 2 | 0.14 ms |
SELECT g0_.id AS id_0, g0_.texto AS texto_1, g0_.path AS path_2, g0_.url AS url_3, g0_.orden AS orden_4 FROM galeria g0_ ORDER BY g0_.orden ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
| 3 | 0.23 ms |
SELECT e0_.id AS id_0, e0_.deleted_at AS deleted_at_1, e0_.created_at AS created_at_2, e0_.nombre AS nombre_3, e0_.slug AS slug_4, e0_.codigo_postal AS codigo_postal_5, e0_.direccion AS direccion_6, e0_.latitud AS latitud_7, e0_.longitud AS longitud_8, e0_.descripcion_min AS descripcion_min_9, e0_.descripcion AS descripcion_10, e0_.path AS path_11, e0_.codigo_ine AS codigo_ine_12, e0_.habitantes AS habitantes_13, e0_.auto_evaluar_datos AS auto_evaluar_datos_14, e0_.mostrar_parte_publica AS mostrar_parte_publica_15, e0_.path_portada_ivl AS path_portada_ivl_16, e0_.path_fondo_ivl AS path_fondo_ivl_17, e0_.path_contraportada_ivl AS path_contraportada_ivl_18, e0_.optimizado_portada_ivl AS optimizado_portada_ivl_19, e0_.optimizado_fondo_ivl AS optimizado_fondo_ivl_20, e0_.optimizado_contraportada_ivl AS optimizado_contraportada_ivl_21, e0_.color_titulos_ivl AS color_titulos_ivl_22, e0_.color_subtitulos_ivl AS color_subtitulos_ivl_23, e0_.color_textos_ivl AS color_textos_ivl_24, e0_.color_corporativo AS color_corporativo_25, e0_.color_fondo AS color_fondo_26, e0_.comunidad_id AS comunidad_id_27, e0_.provincia_id AS provincia_id_28, e0_.poblacion_id AS poblacion_id_29 FROM entidad_local e0_ WHERE e0_.deleted_at IS NULL AND e0_.mostrar_parte_publica = 1
Parameters:
[]
|
||||||||||||||||||||||||||||
| 4 | 0.17 ms |
SELECT o0_.id AS id_0, o0_.deleted_at AS deleted_at_1, o0_.created_at AS created_at_2, o0_.orden AS orden_3, o0_.nombre AS nombre_4, o0_.descripcion AS descripcion_5, o0_.color AS color_6, o0_.path_ivl AS path_ivl_7 FROM ods o0_ WHERE o0_.deleted_at IS NULL ORDER BY o0_.orden ASC
Parameters:
[]
|
||||||||||||||||||||||||||||
| 5 | 0.13 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
2
]
|
||||||||||||||||||||||||||||
| 6 | 0.13 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
3
]
|
||||||||||||||||||||||||||||
| 7 | 0.11 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
4
]
|
||||||||||||||||||||||||||||
| 8 | 0.11 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
5
]
|
||||||||||||||||||||||||||||
| 9 | 0.11 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
6
]
|
||||||||||||||||||||||||||||
| 10 | 0.14 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
7
]
|
||||||||||||||||||||||||||||
| 11 | 0.10 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
9
]
|
||||||||||||||||||||||||||||
| 12 | 0.12 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
10
]
|
||||||||||||||||||||||||||||
| 13 | 0.13 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
11
]
|
||||||||||||||||||||||||||||
| 14 | 0.10 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
12
]
|
||||||||||||||||||||||||||||
| 15 | 0.11 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
13
]
|
||||||||||||||||||||||||||||
| 16 | 0.12 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
14
]
|
||||||||||||||||||||||||||||
| 17 | 0.11 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
15
]
|
||||||||||||||||||||||||||||
| 18 | 0.11 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
16
]
|
||||||||||||||||||||||||||||
| 19 | 0.15 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
17
]
|
||||||||||||||||||||||||||||
| 20 | 0.12 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
18
]
|
||||||||||||||||||||||||||||
| 21 | 0.13 ms |
SELECT m0_.id AS id_0, m0_.deleted_at AS deleted_at_1, m0_.created_at AS created_at_2, m0_.orden AS orden_3, m0_.nombre AS nombre_4, m0_.descripcion AS descripcion_5, m0_.color AS color_6, m0_.path_ivl AS path_ivl_7, m0_.ods_id AS ods_id_8 FROM meta m0_ WHERE m0_.deleted_at IS NULL AND m0_.ods_id = ? ORDER BY m0_.orden ASC
Parameters:
[
19
]
|
||||||||||||||||||||||||||||
| 22 | 0.13 ms |
SELECT f0_.id AS id_0, f0_.created_at AS created_at_1, f0_.deleted_at AS deleted_at_2, f0_.orden AS orden_3, f0_.pregunta AS pregunta_4, f0_.respuesta AS respuesta_5, f0_.categoria_faq_id AS categoria_faq_id_6 FROM faq f0_ LEFT JOIN categoria_faq c1_ ON f0_.categoria_faq_id = c1_.id WHERE f0_.deleted_at IS NULL ORDER BY c1_.orden ASC, f0_.orden ASC
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\Meta | 112 |
| App\Entity\Ods | 17 |
| App\Entity\Faq | 15 |
| App\Entity\Galeria | 2 |
| App\Entity\Smtp | 1 |
| App\Entity\EntidadLocal | 1 |
| App\Entity\Comunidad | 1 |
| App\Entity\Provincia | 1 |
| App\Entity\Poblacion | 1 |
| App\Entity\CategoriaFaq | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Smtp | No errors. |
| App\Entity\Galeria | No errors. |
| App\Entity\EntidadLocal | No errors. |
| App\Entity\Comunidad | No errors. |
| App\Entity\Provincia |
|
| App\Entity\Poblacion |
|
| App\Entity\Usuario |
|
| App\Entity\Cluster | No errors. |
| App\Entity\Anio | No errors. |
| App\Entity\Ivl | No errors. |
| App\Entity\Ods | No errors. |
| App\Entity\Meta | No errors. |
| App\Entity\Faq |
|
| App\Entity\CategoriaFaq | No errors. |