GET https://agoncillo.mapescador.duckdns.org/es/cookie_consent_alt?locale=es

Query Metrics

20 Database Queries
11 Different statements
12.99 ms Query time
0 Invalid entities
25 Managed entities

Queries

Group similar statements

# Time Info
1 1.66 ms
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.enabled AS enabled_2, c0_.accesible AS accesible_3, c0_.asunto AS asunto_4, c0_.disabletranslation AS disabletranslation_5, c0_.fecha_inicio AS fecha_inicio_6, c0_.destacada AS destacada_7, c0_.fecha_fin AS fecha_fin_8, c0_.cuerpo AS cuerpo_9, c0_.direccion AS direccion_10, c0_.telefono AS telefono_11, c0_.web AS web_12, c0_.localizacion AS localizacion_13, c0_.ciudad_id AS ciudad_id_14, c0_.tipo AS tipo_15 FROM calendario c0_ WHERE c0_.code = ?
Parameters:
[
  "fiestas_san_roque"
]
2 1.01 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 calendario_translations t0 WHERE t0.object_id = ?
Parameters:
[
  1
]
3 1.47 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 calendario_translations c0_ WHERE c0_.object_id = ? AND c0_.locale = ? AND c0_.field = 'asunto' ORDER BY c0_.id DESC
Parameters:
[
  1
  "es"
]
4 0.46 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 calendario_translations c0_ WHERE c0_.object_id = ? AND c0_.locale = ? AND c0_.field = 'cuerpo' ORDER BY c0_.id DESC
Parameters:
[
  1
  "es"
]
5 0.96 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:
[]
6 0.69 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
]
7 0.36 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
]
8 0.30 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
]
9 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:
[
  5
]
10 0.50 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"
]
11 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
]
12 0.39 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"
]
13 0.33 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
]
14 0.41 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"
]
15 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:
[
  4
]
16 0.40 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"
]
17 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:
[
  5
]
18 0.98 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.ruta_archivo AS ruta_archivo_4, t0.updated AS updated_5, t0.ciudad_id AS ciudad_id_6, t0.ruta_id AS ruta_id_7, t0.poi_id AS poi_id_8, t0.calendario_id AS calendario_id_9 FROM imagen t0 WHERE t0.calendario_id = ?
Parameters:
[
  1
]
19 0.94 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.nombre AS nombre_3, t0.descripcion AS descripcion_4, t0.ruta_archivo AS ruta_archivo_5, t0.updated AS updated_6, t0.ciudad_id AS ciudad_id_7, t0.ruta_id AS ruta_id_8, t0.poi_id AS poi_id_9, t0.calendario_id AS calendario_id_10, t0.visitavirtual_id AS visitavirtual_id_11 FROM panoramica t0 WHERE t0.calendario_id = ?
Parameters:
[
  1
]
20 0.71 ms
SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.descripcion AS descripcion_3, t0.ruta_archivo AS ruta_archivo_4, t0.updated AS updated_5, t0.ciudad_id AS ciudad_id_6, t0.ruta_id AS ruta_id_7, t0.poi_id AS poi_id_8, t0.calendario_id AS calendario_id_9 FROM recurso t0 WHERE t0.calendario_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\FrontmenuTranslation 12
App\Translation\CalendarioTranslation 6
App\Entity\Frontmenu 4
App\Entity\Calendario 1
App\Entity\Ciudad 1
App\Entity\CalendarioTipos 1