GET https://agoncillo.mapescador.duckdns.org/es/ciudades/agoncillo/rutas

Query Metrics

48 Database Queries
14 Different statements
101.17 ms Query time
0 Invalid entities
194 Managed entities

Queries

Group similar statements

# Time Info
1 42.58 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.nombre AS nombre_2, c0_.enabled AS enabled_3, c0_.disabletranslation AS disabletranslation_4, c0_.descripcion_corta AS descripcion_corta_5, c0_.descripcion_larga AS descripcion_larga_6, c0_.destacada AS destacada_7, c0_.localizacion AS localizacion_8, c0_.position AS position_9, ST_AsEWKT(c0_.point) AS point_10, c0_.deleted_at AS deleted_at_11 FROM ciudad c0_ WHERE (c0_.code = ? AND c0_.enabled = true) AND (c0_.deleted_at IS NULL) ORDER BY c0_.position ASC
Parameters:
[
  "agoncillo"
]
2 0.91 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ciudad_translations t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
3 1.26 ms
SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.field AS field_2, c0_.content AS content_3, c0_.object_id AS object_id_4 FROM ciudad_translations c0_ WHERE c0_.object_id = ? AND c0_.locale = ? AND c0_.field = 'descripcionCorta' ORDER BY c0_.id DESC
Parameters:
[
  1
  "es"
]
4 0.53 ms
SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.field AS field_2, c0_.content AS content_3, c0_.object_id AS object_id_4 FROM ciudad_translations c0_ WHERE c0_.object_id = ? AND c0_.locale = ? AND c0_.field = 'descripcionLarga' ORDER BY c0_.id DESC
Parameters:
[
  1
  "es"
]
5 5.19 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nombre AS nombre_3, t0.enabled AS enabled_4, t0.disabletranslation AS disabletranslation_5, t0.color AS color_6, t0.descripcion_corta AS descripcion_corta_7, t0.descripcion_larga AS descripcion_larga_8, t0.folleto AS folleto_9, t0.folleto_url AS folleto_url_10, t0.folletopdf AS folletopdf_11, t0.folletopdf_url AS folletopdf_url_12, t0.geojson AS geojson_13, t0.destacada AS destacada_14, t0.position AS position_15, ST_AsEWKT(t0.linestring) AS linestring_16, t0.distancia AS distancia_17, t0.tiempo AS tiempo_18, t0.dificultad AS dificultad_19, t0.deleted_at AS deleted_at_20, t0.ciudad_id AS ciudad_id_21 FROM ruta t0 WHERE t0.ciudad_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
6 0.90 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ruta_translations t0 WHERE t0.object_id = ?
Parameters:
[
  3
]
7 0.42 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ruta_translations t0 WHERE t0.object_id = ?
Parameters:
[
  4
]
8 0.41 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ruta_translations t0 WHERE t0.object_id = ?
Parameters:
[
  5
]
9 0.43 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ruta_translations t0 WHERE t0.object_id = ?
Parameters:
[
  2
]
10 0.38 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM ruta_translations t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
11 0.48 ms
SELECT r0_.id AS id_0, r0_.locale AS locale_1, r0_.field AS field_2, r0_.content AS content_3, r0_.object_id AS object_id_4 FROM ruta_translations r0_ WHERE r0_.object_id = ? AND r0_.locale = ? AND r0_.field = 'descripcionLarga' ORDER BY r0_.id DESC
Parameters:
[
  3
  "es"
]
12 0.38 ms
SELECT r0_.id AS id_0, r0_.locale AS locale_1, r0_.field AS field_2, r0_.content AS content_3, r0_.object_id AS object_id_4 FROM ruta_translations r0_ WHERE r0_.object_id = ? AND r0_.locale = ? AND r0_.field = 'descripcionCorta' ORDER BY r0_.id DESC
Parameters:
[
  3
  "es"
]
13 0.35 ms
SELECT r0_.id AS id_0, r0_.locale AS locale_1, r0_.field AS field_2, r0_.content AS content_3, r0_.object_id AS object_id_4 FROM ruta_translations r0_ WHERE r0_.object_id = ? AND r0_.locale = ? AND r0_.field = 'descripcionLarga' ORDER BY r0_.id DESC
Parameters:
[
  4
  "es"
]
14 0.44 ms
SELECT r0_.id AS id_0, r0_.locale AS locale_1, r0_.field AS field_2, r0_.content AS content_3, r0_.object_id AS object_id_4 FROM ruta_translations r0_ WHERE r0_.object_id = ? AND r0_.locale = ? AND r0_.field = 'descripcionCorta' ORDER BY r0_.id DESC
Parameters:
[
  4
  "es"
]
15 0.46 ms
SELECT r0_.id AS id_0, r0_.locale AS locale_1, r0_.field AS field_2, r0_.content AS content_3, r0_.object_id AS object_id_4 FROM ruta_translations r0_ WHERE r0_.object_id = ? AND r0_.locale = ? AND r0_.field = 'descripcionLarga' ORDER BY r0_.id DESC
Parameters:
[
  5
  "es"
]
16 0.43 ms
SELECT r0_.id AS id_0, r0_.locale AS locale_1, r0_.field AS field_2, r0_.content AS content_3, r0_.object_id AS object_id_4 FROM ruta_translations r0_ WHERE r0_.object_id = ? AND r0_.locale = ? AND r0_.field = 'descripcionCorta' ORDER BY r0_.id DESC
Parameters:
[
  5
  "es"
]
17 0.94 ms
SELECT f0_.id AS id_0, f0_.nombre AS nombre_1, f0_.enabled AS enabled_2, f0_.disabletranslation AS disabletranslation_3, f0_.url AS url_4, f0_.nolocal AS nolocal_5, f0_.auth AS auth_6, f0_.position AS position_7, f0_.deleted_at AS deleted_at_8, f0_.parent_id AS parent_id_9 FROM front_menu f0_ WHERE f0_.parent_id IS NULL AND f0_.enabled = true ORDER BY f0_.position ASC
Parameters:
[]
18 0.74 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM frontmenu_translations t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
19 0.37 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM frontmenu_translations t0 WHERE t0.object_id = ?
Parameters:
[
  3
]
20 0.37 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM frontmenu_translations t0 WHERE t0.object_id = ?
Parameters:
[
  4
]
21 0.38 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM frontmenu_translations t0 WHERE t0.object_id = ?
Parameters:
[
  5
]
22 0.54 ms
SELECT f0_.id AS id_0, f0_.locale AS locale_1, f0_.field AS field_2, f0_.content AS content_3, f0_.object_id AS object_id_4 FROM frontmenu_translations f0_ WHERE f0_.object_id = ? AND f0_.locale = ? AND f0_.field = 'nombre' ORDER BY f0_.id DESC
Parameters:
[
  1
  "es"
]
23 0.34 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.enabled AS enabled_3, t0.disabletranslation AS disabletranslation_4, t0.url AS url_5, t0.nolocal AS nolocal_6, t0.auth AS auth_7, t0.position AS position_8, t0.deleted_at AS deleted_at_9, t0.parent_id AS parent_id_10 FROM front_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
24 0.38 ms
SELECT f0_.id AS id_0, f0_.locale AS locale_1, f0_.field AS field_2, f0_.content AS content_3, f0_.object_id AS object_id_4 FROM frontmenu_translations f0_ WHERE f0_.object_id = ? AND f0_.locale = ? AND f0_.field = 'nombre' ORDER BY f0_.id DESC
Parameters:
[
  3
  "es"
]
25 0.36 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.enabled AS enabled_3, t0.disabletranslation AS disabletranslation_4, t0.url AS url_5, t0.nolocal AS nolocal_6, t0.auth AS auth_7, t0.position AS position_8, t0.deleted_at AS deleted_at_9, t0.parent_id AS parent_id_10 FROM front_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  3
]
26 11.74 ms
SELECT f0_.id AS id_0, f0_.locale AS locale_1, f0_.field AS field_2, f0_.content AS content_3, f0_.object_id AS object_id_4 FROM frontmenu_translations f0_ WHERE f0_.object_id = ? AND f0_.locale = ? AND f0_.field = 'nombre' ORDER BY f0_.id DESC
Parameters:
[
  4
  "es"
]
27 0.43 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.enabled AS enabled_3, t0.disabletranslation AS disabletranslation_4, t0.url AS url_5, t0.nolocal AS nolocal_6, t0.auth AS auth_7, t0.position AS position_8, t0.deleted_at AS deleted_at_9, t0.parent_id AS parent_id_10 FROM front_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  4
]
28 0.46 ms
SELECT f0_.id AS id_0, f0_.locale AS locale_1, f0_.field AS field_2, f0_.content AS content_3, f0_.object_id AS object_id_4 FROM frontmenu_translations f0_ WHERE f0_.object_id = ? AND f0_.locale = ? AND f0_.field = 'nombre' ORDER BY f0_.id DESC
Parameters:
[
  5
  "es"
]
29 0.44 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.enabled AS enabled_3, t0.disabletranslation AS disabletranslation_4, t0.url AS url_5, t0.nolocal AS nolocal_6, t0.auth AS auth_7, t0.position AS position_8, t0.deleted_at AS deleted_at_9, t0.parent_id AS parent_id_10 FROM front_menu t0 WHERE t0.parent_id = ?
Parameters:
[
  5
]
30 4.35 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nombre AS nombre_3, t0.enabled AS enabled_4, t0.accesible AS accesible_5, t0.disabletranslation AS disabletranslation_6, t0.descripcion_corta AS descripcion_corta_7, t0.descripcion_larga AS descripcion_larga_8, t0.direccion AS direccion_9, t0.telefono AS telefono_10, t0.horario AS horario_11, t0.web AS web_12, t0.localizacion AS localizacion_13, t0.destacada AS destacada_14, t0.position AS position_15, ST_AsEWKT(t0.point) AS point_16, t0.deleted_at AS deleted_at_17, t0.ciudad_id AS ciudad_id_18, t0.tipo_poi_id AS tipo_poi_id_19, t0.ruta_id AS ruta_id_20, t0.visitavirtual_id AS visitavirtual_id_21 FROM poi t0 WHERE t0.ciudad_id = ? AND ((t0.deleted_at IS NULL))
Parameters:
[
  1
]
31 11.63 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  5
]
32 0.59 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  6
]
33 0.85 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  2
]
34 0.59 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  17
]
35 0.52 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  7
]
36 0.59 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  4
]
37 0.49 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  16
]
38 0.52 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  10
]
39 0.56 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  12
]
40 0.53 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  14
]
41 0.51 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  11
]
42 3.46 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  8
]
43 0.51 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  15
]
44 0.46 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  9
]
45 0.61 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  3
]
46 0.41 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  18
]
47 0.44 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  13
]
48 0.49 ms
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  1
]

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\Translation\PoiTranslation 114
App\Translation\RutaTranslation 30
App\Entity\Poi 18
App\Translation\FrontmenuTranslation 12
App\Translation\CiudadTranslation 6
App\Entity\Ruta 5
App\Entity\Frontmenu 4
App\Entity\TipoPoi 4
App\Entity\Ciudad 1