Symfony Profiler

SELECT
  p0_.id AS id_0,
  p1_.nombre AS nombre_1
FROM
  pais p0_
  LEFT JOIN pais_translation p1_ ON p0_.id = p1_.objeto_id
  LEFT JOIN locale l2_ ON p1_.locale_id = l2_.id
WHERE
  l2_.locale = ?
GROUP BY
  p0_.id
ORDER BY
  p1_.nombre ASC

SELECT p0_.id AS id_0, p1_.nombre AS nombre_1 FROM pais p0_ LEFT JOIN pais_translation p1_ ON p0_.id = p1_.objeto_id LEFT JOIN locale l2_ ON p1_.locale_id = l2_.id WHERE l2_.locale = 'en' GROUP BY p0_.id ORDER BY p1_.nombre ASC;

SELECT
  d0_.id AS id_0,
  d1_.nombre AS nombre_1
FROM
  document_type d0_
  LEFT JOIN document_type_translation d1_ ON d0_.id = d1_.object_id
  LEFT JOIN locale l2_ ON d1_.locale_id = l2_.id
WHERE
  l2_.locale = ?
GROUP BY
  d0_.id
ORDER BY
  d1_.nombre ASC

SELECT d0_.id AS id_0, d1_.nombre AS nombre_1 FROM document_type d0_ LEFT JOIN document_type_translation d1_ ON d0_.id = d1_.object_id LEFT JOIN locale l2_ ON d1_.locale_id = l2_.id WHERE l2_.locale = 'en' GROUP BY d0_.id ORDER BY d1_.nombre ASC;

SELECT
  t0_.llave AS llave_0,
  t1_.valor AS valor_1,
  t0_.url AS url_2
FROM
  texto t0_
  LEFT JOIN texto_translation t1_ ON t0_.id = t1_.objeto_id
  LEFT JOIN locale l2_ ON t1_.locale_id = l2_.id
WHERE
  l2_.locale = ?

SELECT t0_.llave AS llave_0, t1_.valor AS valor_1, t0_.url AS url_2 FROM texto t0_ LEFT JOIN texto_translation t1_ ON t0_.id = t1_.objeto_id LEFT JOIN locale l2_ ON t1_.locale_id = l2_.id WHERE l2_.locale = 'en';

SELECT
  c0_.id AS id_0,
  c0_.imagen AS imagen_1,
  c1_.nombre AS nombre_2,
  c1_.resumen AS resumen_3,
  c0_.enlace AS enlace_4,
  c0_.slug AS slug_5,
  c0_.padre_id AS sclr_6,
  c0_.ordenmenu AS ordenmenu_7
FROM
  categoria_propiedades c0_
  LEFT JOIN categoria_translation c1_ ON c0_.id = c1_.categoria_propiedades_id
  LEFT JOIN locale l2_ ON c1_.locale_id = l2_.id
WHERE
  c0_.visible = 1
  AND l2_.locale = ?
ORDER BY
  c0_.orden ASC

SELECT c0_.id AS id_0, c0_.imagen AS imagen_1, c1_.nombre AS nombre_2, c1_.resumen AS resumen_3, c0_.enlace AS enlace_4, c0_.slug AS slug_5, c0_.padre_id AS sclr_6, c0_.ordenmenu AS ordenmenu_7 FROM categoria_propiedades c0_ LEFT JOIN categoria_translation c1_ ON c0_.id = c1_.categoria_propiedades_id LEFT JOIN locale l2_ ON c1_.locale_id = l2_.id WHERE c0_.visible = 1 AND l2_.locale = 'es' ORDER BY c0_.orden ASC;