Symfony Profiler

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_.enabled = true)
  AND (c0_.deleted_at IS NULL)
ORDER BY
  c0_.position ASC

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_.enabled = true) AND (c0_.deleted_at IS NULL) ORDER BY c0_.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
  ciudad_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 ciudad_translations t0 WHERE t0.object_id = 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_.position ASC

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_.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
  tipo_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 tipo_poi_translations t0 WHERE t0.object_id = 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 = ?

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

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

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

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

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

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

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

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

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 = 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
  tipo_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 tipo_poi_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
  tipo_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 tipo_poi_translations t0 WHERE t0.object_id = 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
  tipo_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 tipo_poi_translations t0 WHERE t0.object_id = 4;

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

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

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

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

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

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

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

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

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

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

SELECT
  r0_.id AS id_0,
  r0_.code AS code_1,
  r0_.nombre AS nombre_2,
  r0_.enabled AS enabled_3,
  r0_.disabletranslation AS disabletranslation_4,
  r0_.color AS color_5,
  r0_.descripcion_corta AS descripcion_corta_6,
  r0_.descripcion_larga AS descripcion_larga_7,
  r0_.folleto AS folleto_8,
  r0_.folleto_url AS folleto_url_9,
  r0_.folletopdf AS folletopdf_10,
  r0_.folletopdf_url AS folletopdf_url_11,
  r0_.geojson AS geojson_12,
  r0_.destacada AS destacada_13,
  r0_.position AS position_14,
  ST_AsEWKT(r0_.linestring) AS linestring_15,
  r0_.distancia AS distancia_16,
  r0_.tiempo AS tiempo_17,
  r0_.dificultad AS dificultad_18,
  r0_.deleted_at AS deleted_at_19,
  r0_.ciudad_id AS ciudad_id_20
FROM
  ruta r0_
WHERE
  (r0_.enabled = true)
  AND (r0_.deleted_at IS NULL)
ORDER BY
  r0_.position ASC

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.nombre AS nombre_2, r0_.enabled AS enabled_3, r0_.disabletranslation AS disabletranslation_4, r0_.color AS color_5, r0_.descripcion_corta AS descripcion_corta_6, r0_.descripcion_larga AS descripcion_larga_7, r0_.folleto AS folleto_8, r0_.folleto_url AS folleto_url_9, r0_.folletopdf AS folletopdf_10, r0_.folletopdf_url AS folletopdf_url_11, r0_.geojson AS geojson_12, r0_.destacada AS destacada_13, r0_.position AS position_14, ST_AsEWKT(r0_.linestring) AS linestring_15, r0_.distancia AS distancia_16, r0_.tiempo AS tiempo_17, r0_.dificultad AS dificultad_18, r0_.deleted_at AS deleted_at_19, r0_.ciudad_id AS ciudad_id_20 FROM ruta r0_ WHERE (r0_.enabled = true) AND (r0_.deleted_at IS NULL) ORDER BY r0_.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
  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 = 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
  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 = 4;

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

SELECT
  p0_.id AS id_0,
  p0_.code AS code_1,
  p0_.nombre AS nombre_2,
  p0_.enabled AS enabled_3,
  p0_.accesible AS accesible_4,
  p0_.disabletranslation AS disabletranslation_5,
  p0_.descripcion_corta AS descripcion_corta_6,
  p0_.descripcion_larga AS descripcion_larga_7,
  p0_.direccion AS direccion_8,
  p0_.telefono AS telefono_9,
  p0_.horario AS horario_10,
  p0_.web AS web_11,
  p0_.localizacion AS localizacion_12,
  p0_.destacada AS destacada_13,
  p0_.position AS position_14,
  ST_AsEWKT(p0_.point) AS point_15,
  p0_.deleted_at AS deleted_at_16,
  p0_.ciudad_id AS ciudad_id_17,
  p0_.tipo_poi_id AS tipo_poi_id_18,
  p0_.ruta_id AS ruta_id_19,
  p0_.visitavirtual_id AS visitavirtual_id_20
FROM
  poi p0_
WHERE
  (p0_.enabled = true)
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.position ASC

SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.nombre AS nombre_2, p0_.enabled AS enabled_3, p0_.accesible AS accesible_4, p0_.disabletranslation AS disabletranslation_5, p0_.descripcion_corta AS descripcion_corta_6, p0_.descripcion_larga AS descripcion_larga_7, p0_.direccion AS direccion_8, p0_.telefono AS telefono_9, p0_.horario AS horario_10, p0_.web AS web_11, p0_.localizacion AS localizacion_12, p0_.destacada AS destacada_13, p0_.position AS position_14, ST_AsEWKT(p0_.point) AS point_15, p0_.deleted_at AS deleted_at_16, p0_.ciudad_id AS ciudad_id_17, p0_.tipo_poi_id AS tipo_poi_id_18, p0_.ruta_id AS ruta_id_19, p0_.visitavirtual_id AS visitavirtual_id_20 FROM poi p0_ WHERE (p0_.enabled = true) AND (p0_.deleted_at IS NULL) ORDER BY p0_.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
  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 = 17;

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