Symfony Profiler

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_.deleted_at AS deleted_at_17,
  r0_.ciudad_id AS ciudad_id_18
FROM
  ruta r0_
WHERE
  (
    r0_.code = ?
    AND r0_.enabled = true
  )
  AND (r0_.deleted_at IS NULL)

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_.deleted_at AS deleted_at_17, r0_.ciudad_id AS ciudad_id_18 FROM ruta r0_ WHERE (r0_.code = 'rutacsfpamplona' AND r0_.enabled = true) AND (r0_.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 = 4;

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 = 4 AND r0_.locale = 'en' 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 = ?
  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 = 4 AND r0_.locale = 'en' AND r0_.field = 'descripcionLarga' 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.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
  INNER JOIN pois_rutas ON t0.id = pois_rutas.poi_id
WHERE
  pois_rutas.ruta_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 INNER JOIN pois_rutas ON t0.id = pois_rutas.poi_id WHERE pois_rutas.ruta_id = 4 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 = 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
  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 = 25;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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