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_.code = ?
    AND 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_.code = 'agoncillo' AND 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
  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

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

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

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

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nombre AS nombre_3,
  t0.enabled AS enabled_4,
  t0.accesible AS accesible_5,
  t0.disabletranslation AS disabletranslation_6,
  t0.descripcion_corta AS descripcion_corta_7,
  t0.descripcion_larga AS descripcion_larga_8,
  t0.direccion AS direccion_9,
  t0.telefono AS telefono_10,
  t0.horario AS horario_11,
  t0.web AS web_12,
  t0.localizacion AS localizacion_13,
  t0.destacada AS destacada_14,
  t0.position AS position_15,
  ST_AsEWKT(t0.point) AS point_16,
  t0.deleted_at AS deleted_at_17,
  t0.ciudad_id AS ciudad_id_18,
  t0.tipo_poi_id AS tipo_poi_id_19,
  t0.ruta_id AS ruta_id_20,
  t0.visitavirtual_id AS visitavirtual_id_21
FROM
  poi t0
WHERE
  t0.ciudad_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.accesible AS accesible_5, t0.disabletranslation AS disabletranslation_6, t0.descripcion_corta AS descripcion_corta_7, t0.descripcion_larga AS descripcion_larga_8, t0.direccion AS direccion_9, t0.telefono AS telefono_10, t0.horario AS horario_11, t0.web AS web_12, t0.localizacion AS localizacion_13, t0.destacada AS destacada_14, t0.position AS position_15, ST_AsEWKT(t0.point) AS point_16, t0.deleted_at AS deleted_at_17, t0.ciudad_id AS ciudad_id_18, t0.tipo_poi_id AS tipo_poi_id_19, t0.ruta_id AS ruta_id_20, t0.visitavirtual_id AS visitavirtual_id_21 FROM poi t0 WHERE t0.ciudad_id = 1 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 = 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
  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 = 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
  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 = 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
  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 = 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
  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 = 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
  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;

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

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

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

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