Symfony Profiler

SELECT
  v0_.id AS id_0,
  v0_.code AS code_1,
  v0_.nombre AS nombre_2,
  v0_.enabled AS enabled_3,
  v0_.disabletranslation AS disabletranslation_4,
  v0_.descripcion_corta AS descripcion_corta_5,
  v0_.descripcion_larga AS descripcion_larga_6,
  v0_.destacada AS destacada_7,
  v0_.localizacion AS localizacion_8,
  v0_.position AS position_9,
  v0_.deleted_at AS deleted_at_10,
  v0_.ciudad_id AS ciudad_id_11,
  v0_.ruta_id AS ruta_id_12
FROM
  visitavirtual v0_
WHERE
  (
    v0_.code = ?
    AND v0_.enabled = true
  )
  AND (v0_.deleted_at IS NULL)

SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.nombre AS nombre_2, v0_.enabled AS enabled_3, v0_.disabletranslation AS disabletranslation_4, v0_.descripcion_corta AS descripcion_corta_5, v0_.descripcion_larga AS descripcion_larga_6, v0_.destacada AS destacada_7, v0_.localizacion AS localizacion_8, v0_.position AS position_9, v0_.deleted_at AS deleted_at_10, v0_.ciudad_id AS ciudad_id_11, v0_.ruta_id AS ruta_id_12 FROM visitavirtual v0_ WHERE (v0_.code = 'visitavirtualburgoscsf' AND v0_.enabled = true) AND (v0_.deleted_at IS NULL);

SELECT
  c0_.content AS content_0,
  c0_.field AS field_1
FROM
  ciudad_translations c0_
WHERE
  c0_.locale = ?
  AND c0_.object_id = ?

SELECT c0_.content AS content_0, c0_.field AS field_1 FROM ciudad_translations c0_ WHERE c0_.locale = 'en_US' AND c0_.object_id = 1;

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

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 = 7 AND r0_.locale = 'es' AND r0_.field = 'descripcionCorta' ORDER BY r0_.id DESC;

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.deleted_at AS deleted_at_18,
  t0.ciudad_id AS ciudad_id_19
FROM
  ruta t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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.deleted_at AS deleted_at_18, t0.ciudad_id AS ciudad_id_19 FROM ruta t0 WHERE t0.id = 7 AND ((t0.deleted_at IS NULL));

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 = ?

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 = 7;

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

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 = 7 AND r0_.locale = 'es' AND r0_.field = 'descripcionLarga' ORDER BY r0_.id DESC;

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.nombre AS nombre_2,
  p0_.descripcion AS descripcion_3,
  p0_.ruta_archivo AS ruta_archivo_4,
  p0_.updated AS updated_5,
  p0_.ciudad_id AS ciudad_id_6,
  p0_.ruta_id AS ruta_id_7,
  p0_.poi_id AS poi_id_8,
  p0_.calendario_id AS calendario_id_9,
  p0_.visitavirtual_id AS visitavirtual_id_10
FROM
  panoramica p0_
WHERE
  p0_.ciudad_id = ?

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.nombre AS nombre_2, p0_.descripcion AS descripcion_3, p0_.ruta_archivo AS ruta_archivo_4, p0_.updated AS updated_5, p0_.ciudad_id AS ciudad_id_6, p0_.ruta_id AS ruta_id_7, p0_.poi_id AS poi_id_8, p0_.calendario_id AS calendario_id_9, p0_.visitavirtual_id AS visitavirtual_id_10 FROM panoramica p0_ WHERE p0_.ciudad_id = 5;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.field AS field_2,
  p0_.content AS content_3,
  p0_.object_id AS object_id_4
FROM
  poi_translations p0_
WHERE
  p0_.object_id = ?
  AND p0_.locale = ?
  AND p0_.field = 'descripcionCorta'
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.field AS field_2, p0_.content AS content_3, p0_.object_id AS object_id_4 FROM poi_translations p0_ WHERE p0_.object_id = 130 AND p0_.locale = 'es' AND p0_.field = 'descripcionCorta' ORDER BY p0_.id DESC;

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.descripcion_corta AS descripcion_corta_6,
  t0.descripcion_larga AS descripcion_larga_7,
  t0.direccion AS direccion_8,
  t0.telefono AS telefono_9,
  t0.horario AS horario_10,
  t0.web AS web_11,
  t0.localizacion AS localizacion_12,
  t0.destacada AS destacada_13,
  t0.position AS position_14,
  ST_AsEWKT(t0.point) AS point_15,
  t0.deleted_at AS deleted_at_16,
  t0.ciudad_id AS ciudad_id_17,
  t0.tipo_poi_id AS tipo_poi_id_18,
  t0.ruta_id AS ruta_id_19,
  t0.visitavirtual_id AS visitavirtual_id_20
FROM
  poi t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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.descripcion_corta AS descripcion_corta_6, t0.descripcion_larga AS descripcion_larga_7, t0.direccion AS direccion_8, t0.telefono AS telefono_9, t0.horario AS horario_10, t0.web AS web_11, t0.localizacion AS localizacion_12, t0.destacada AS destacada_13, t0.position AS position_14, ST_AsEWKT(t0.point) AS point_15, t0.deleted_at AS deleted_at_16, t0.ciudad_id AS ciudad_id_17, t0.tipo_poi_id AS tipo_poi_id_18, t0.ruta_id AS ruta_id_19, t0.visitavirtual_id AS visitavirtual_id_20 FROM poi t0 WHERE t0.id = 130 AND ((t0.deleted_at IS NULL));

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 = ?

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 = 130;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.field AS field_2,
  p0_.content AS content_3,
  p0_.object_id AS object_id_4
FROM
  poi_translations p0_
WHERE
  p0_.object_id = ?
  AND p0_.locale = ?
  AND p0_.field = 'descripcionLarga'
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.field AS field_2, p0_.content AS content_3, p0_.object_id AS object_id_4 FROM poi_translations p0_ WHERE p0_.object_id = 130 AND p0_.locale = 'es' AND p0_.field = 'descripcionLarga' ORDER BY p0_.id DESC;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.field AS field_2,
  p0_.content AS content_3,
  p0_.object_id AS object_id_4
FROM
  poi_translations p0_
WHERE
  p0_.object_id = ?
  AND p0_.locale = ?
  AND p0_.field = 'descripcionCorta'
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.field AS field_2, p0_.content AS content_3, p0_.object_id AS object_id_4 FROM poi_translations p0_ WHERE p0_.object_id = 91 AND p0_.locale = 'es' AND p0_.field = 'descripcionCorta' ORDER BY p0_.id DESC;

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.descripcion_corta AS descripcion_corta_6,
  t0.descripcion_larga AS descripcion_larga_7,
  t0.direccion AS direccion_8,
  t0.telefono AS telefono_9,
  t0.horario AS horario_10,
  t0.web AS web_11,
  t0.localizacion AS localizacion_12,
  t0.destacada AS destacada_13,
  t0.position AS position_14,
  ST_AsEWKT(t0.point) AS point_15,
  t0.deleted_at AS deleted_at_16,
  t0.ciudad_id AS ciudad_id_17,
  t0.tipo_poi_id AS tipo_poi_id_18,
  t0.ruta_id AS ruta_id_19,
  t0.visitavirtual_id AS visitavirtual_id_20
FROM
  poi t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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.descripcion_corta AS descripcion_corta_6, t0.descripcion_larga AS descripcion_larga_7, t0.direccion AS direccion_8, t0.telefono AS telefono_9, t0.horario AS horario_10, t0.web AS web_11, t0.localizacion AS localizacion_12, t0.destacada AS destacada_13, t0.position AS position_14, ST_AsEWKT(t0.point) AS point_15, t0.deleted_at AS deleted_at_16, t0.ciudad_id AS ciudad_id_17, t0.tipo_poi_id AS tipo_poi_id_18, t0.ruta_id AS ruta_id_19, t0.visitavirtual_id AS visitavirtual_id_20 FROM poi t0 WHERE t0.id = 91 AND ((t0.deleted_at IS NULL));

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 = ?

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 = 91;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.field AS field_2,
  p0_.content AS content_3,
  p0_.object_id AS object_id_4
FROM
  poi_translations p0_
WHERE
  p0_.object_id = ?
  AND p0_.locale = ?
  AND p0_.field = 'descripcionLarga'
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.field AS field_2, p0_.content AS content_3, p0_.object_id AS object_id_4 FROM poi_translations p0_ WHERE p0_.object_id = 91 AND p0_.locale = 'es' AND p0_.field = 'descripcionLarga' ORDER BY p0_.id DESC;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.field AS field_2,
  p0_.content AS content_3,
  p0_.object_id AS object_id_4
FROM
  poi_translations p0_
WHERE
  p0_.object_id = ?
  AND p0_.locale = ?
  AND p0_.field = 'descripcionCorta'
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.field AS field_2, p0_.content AS content_3, p0_.object_id AS object_id_4 FROM poi_translations p0_ WHERE p0_.object_id = 58 AND p0_.locale = 'es' AND p0_.field = 'descripcionCorta' ORDER BY p0_.id DESC;

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.descripcion_corta AS descripcion_corta_6,
  t0.descripcion_larga AS descripcion_larga_7,
  t0.direccion AS direccion_8,
  t0.telefono AS telefono_9,
  t0.horario AS horario_10,
  t0.web AS web_11,
  t0.localizacion AS localizacion_12,
  t0.destacada AS destacada_13,
  t0.position AS position_14,
  ST_AsEWKT(t0.point) AS point_15,
  t0.deleted_at AS deleted_at_16,
  t0.ciudad_id AS ciudad_id_17,
  t0.tipo_poi_id AS tipo_poi_id_18,
  t0.ruta_id AS ruta_id_19,
  t0.visitavirtual_id AS visitavirtual_id_20
FROM
  poi t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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.descripcion_corta AS descripcion_corta_6, t0.descripcion_larga AS descripcion_larga_7, t0.direccion AS direccion_8, t0.telefono AS telefono_9, t0.horario AS horario_10, t0.web AS web_11, t0.localizacion AS localizacion_12, t0.destacada AS destacada_13, t0.position AS position_14, ST_AsEWKT(t0.point) AS point_15, t0.deleted_at AS deleted_at_16, t0.ciudad_id AS ciudad_id_17, t0.tipo_poi_id AS tipo_poi_id_18, t0.ruta_id AS ruta_id_19, t0.visitavirtual_id AS visitavirtual_id_20 FROM poi t0 WHERE t0.id = 58 AND ((t0.deleted_at IS NULL));

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 = ?

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 = 58;

SELECT
  p0_.id AS id_0,
  p0_.locale AS locale_1,
  p0_.field AS field_2,
  p0_.content AS content_3,
  p0_.object_id AS object_id_4
FROM
  poi_translations p0_
WHERE
  p0_.object_id = ?
  AND p0_.locale = ?
  AND p0_.field = 'descripcionLarga'
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.locale AS locale_1, p0_.field AS field_2, p0_.content AS content_3, p0_.object_id AS object_id_4 FROM poi_translations p0_ WHERE p0_.object_id = 58 AND p0_.locale = 'es' AND p0_.field = 'descripcionLarga' ORDER BY p0_.id DESC;

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

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;

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 = ?

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 = 2;

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 = ?

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 = 1;

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 = ?

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 = 7;