GET https://rutascsf.mapescador.duckdns.org/es/cookie_consent?locale=es

Query Metrics

88 Database Queries
12 Different statements
80.10 ms Query time
0 Invalid entities
230 Managed entities

Grouped Statements

Show all queries

Time Count Info
42.98 ms
(53.66%)
1
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_.deleted_at IS NULL) ORDER BY c0_.position ASC
Parameters:
[]
9.28 ms
(11.59%)
24
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:
[
  2
  "es"
]
8.22 ms
(10.26%)
24
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:
[
  2
]
3.95 ms
(4.93%)
10
SELECT t0_.id AS id_0, t0_.locale AS locale_1, t0_.field AS field_2, t0_.content AS content_3, t0_.object_id AS object_id_4 FROM tipo_poi_translations t0_ WHERE t0_.object_id = ? AND t0_.locale = ? AND t0_.field = 'nombre' ORDER BY t0_.id DESC
Parameters:
[
  1
  "es"
]
3.84 ms
(4.79%)
10
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 tipo_poi_translations t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
2.99 ms
(3.73%)
3
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:
[
  5
]
2.29 ms
(2.86%)
7
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:
[
  2
]
2.12 ms
(2.64%)
3
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:
[
  5
  "es"
]
1.57 ms
(1.96%)
3
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:
[
  5
  "es"
]
1.05 ms
(1.31%)
1
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.enabled AS enabled_2, c0_.asunto AS asunto_3, c0_.disabletranslation AS disabletranslation_4, c0_.fecha_inicio AS fecha_inicio_5, c0_.destacada AS destacada_6, c0_.fecha_fin AS fecha_fin_7, c0_.cuerpo AS cuerpo_8, c0_.direccion AS direccion_9, c0_.telefono AS telefono_10, c0_.web AS web_11, c0_.localizacion AS localizacion_12, c0_.ciudad_id AS ciudad_id_13, c0_.tipo AS tipo_14 FROM calendario c0_ WHERE c0_.fecha_inicio > CURRENT_TIMESTAMP
Parameters:
[]
0.98 ms
(1.23%)
1
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:
[]
0.83 ms
(1.03%)
1
SELECT t0_.id AS id_0, t0_.code AS code_1, t0_.enabled AS enabled_2, t0_.disabletranslation AS disabletranslation_3, t0_.nombre AS nombre_4, t0_.descripcion AS descripcion_5, t0_.ruta_archivo AS ruta_archivo_6, t0_.position AS position_7 FROM tipo_poi t0_ ORDER BY t0_.id 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\Translation\FrontmenuTranslation 96
App\Translation\TipoPoiTranslation 73
App\Translation\CiudadTranslation 24
App\Entity\Frontmenu 24
App\Entity\TipoPoi 10
App\Entity\Ciudad 3