Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c1_.nombre AS nombre_2,
  GROUP_CONCAT(
    JSON_OBJECT(
      'id', c2_.id, 'slug', c2_.slug, 'orden',
      c2_.orden, 'locale', l3_.locale,
      'nombre', c4_.nombre
    )
  ) AS sclr_3
FROM
  categoria_propiedades c0_
  LEFT JOIN categoria_translation c1_ ON c0_.id = c1_.categoria_propiedades_id
  LEFT JOIN locale l5_ ON c1_.locale_id = l5_.id
  LEFT JOIN categoria_propiedades c2_ ON c0_.id = c2_.padre_id
  AND (c2_.visible = 1)
  LEFT JOIN categoria_translation c4_ ON c2_.id = c4_.categoria_propiedades_id
  LEFT JOIN locale l3_ ON c4_.locale_id = l3_.id
WHERE
  c0_.padre_id IS NULL
  AND c0_.visible = 1
  AND l5_.locale = ?
GROUP BY
  c0_.id
ORDER BY
  c0_.orden ASC

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c1_.nombre AS nombre_2, GROUP_CONCAT(JSON_OBJECT('id', c2_.id, 'slug', c2_.slug, 'orden', c2_.orden, 'locale', l3_.locale, 'nombre', c4_.nombre)) AS sclr_3 FROM categoria_propiedades c0_ LEFT JOIN categoria_translation c1_ ON c0_.id = c1_.categoria_propiedades_id LEFT JOIN locale l5_ ON c1_.locale_id = l5_.id LEFT JOIN categoria_propiedades c2_ ON c0_.id = c2_.padre_id AND (c2_.visible = 1) LEFT JOIN categoria_translation c4_ ON c2_.id = c4_.categoria_propiedades_id LEFT JOIN locale l3_ ON c4_.locale_id = l3_.id WHERE c0_.padre_id IS NULL AND c0_.visible = 1 AND l5_.locale = 'en' GROUP BY c0_.id ORDER BY c0_.orden ASC;

SELECT
  p0_.id AS id_0,
  p1_.nombre AS nombre_1,
  p1_.subtitulo AS subtitulo_2,
  c2_.image AS image_3,
  p0_.lat AS lat_4,
  p0_.lng AS lng_5,
  GROUP_CONCAT(
    JSON_OBJECT(
      'nombre', s3_.nombre, 'image', s3_.image
    )
  ) AS sclr_6
FROM
  propiedades p0_
  INNER JOIN categoria_propiedades_propiedades c5_ ON p0_.id = c5_.propiedades_id
  INNER JOIN categoria_propiedades c4_ ON c4_.id = c5_.categoria_propiedades_id
  LEFT JOIN core_image c2_ ON p0_.id = c2_.propiedades_id
  AND (c2_.principal = 1)
  LEFT JOIN propiedad_translation p1_ ON p0_.id = p1_.objeto_id
  LEFT JOIN servicios_publicos_propiedades s6_ ON p0_.id = s6_.propiedades_id
  LEFT JOIN servicios_publicos s3_ ON s3_.id = s6_.servicios_publicos_id
  LEFT JOIN locale l7_ ON p1_.locale_id = l7_.id
WHERE
  c4_.id = ?
  AND l7_.locale = ?
  AND p0_.visible = 1
  AND p0_.verificada = 1
GROUP BY
  p0_.id
ORDER BY
  c4_.orden ASC

SELECT p0_.id AS id_0, p1_.nombre AS nombre_1, p1_.subtitulo AS subtitulo_2, c2_.image AS image_3, p0_.lat AS lat_4, p0_.lng AS lng_5, GROUP_CONCAT(JSON_OBJECT('nombre', s3_.nombre, 'image', s3_.image)) AS sclr_6 FROM propiedades p0_ INNER JOIN categoria_propiedades_propiedades c5_ ON p0_.id = c5_.propiedades_id INNER JOIN categoria_propiedades c4_ ON c4_.id = c5_.categoria_propiedades_id LEFT JOIN core_image c2_ ON p0_.id = c2_.propiedades_id AND (c2_.principal = 1) LEFT JOIN propiedad_translation p1_ ON p0_.id = p1_.objeto_id LEFT JOIN servicios_publicos_propiedades s6_ ON p0_.id = s6_.propiedades_id LEFT JOIN servicios_publicos s3_ ON s3_.id = s6_.servicios_publicos_id LEFT JOIN locale l7_ ON p1_.locale_id = l7_.id WHERE c4_.id = 15 AND l7_.locale = 'en' AND p0_.visible = 1 AND p0_.verificada = 1 GROUP BY p0_.id ORDER BY c4_.orden 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 = ?
  AND c0_.slug = ?
ORDER BY
  c0_.orden ASC
LIMIT
  8

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' AND c0_.slug = '15' ORDER BY c0_.orden ASC LIMIT 8;

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;

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.link AS link_1,
  a0_.orden AS orden_2,
  a1_.titulo AS titulo_3,
  a1_.frase AS frase_4,
  c2_.image AS image_5
FROM
  anuncio a0_
  INNER JOIN anuncio_translation a1_ ON a0_.id = a1_.objeto_id
  INNER JOIN locale l3_ ON a1_.locale_id = l3_.id
  LEFT JOIN core_image c2_ ON a0_.image_id = c2_.id
  LEFT JOIN anuncio_categoria_propiedades a5_ ON a0_.id = a5_.anuncio_id
  LEFT JOIN categoria_propiedades c4_ ON c4_.id = a5_.categoria_propiedades_id
  LEFT JOIN anuncio_propiedades a7_ ON a0_.id = a7_.anuncio_id
  LEFT JOIN propiedades p6_ ON p6_.id = a7_.propiedades_id
WHERE
  l3_.locale = ?
  AND a0_.visible_seccion = 1
  AND (
    c4_.id = ?
    OR c4_.id IS NULL
  )
ORDER BY
  a0_.orden ASC

SELECT DISTINCT a0_.id AS id_0, a0_.link AS link_1, a0_.orden AS orden_2, a1_.titulo AS titulo_3, a1_.frase AS frase_4, c2_.image AS image_5 FROM anuncio a0_ INNER JOIN anuncio_translation a1_ ON a0_.id = a1_.objeto_id INNER JOIN locale l3_ ON a1_.locale_id = l3_.id LEFT JOIN core_image c2_ ON a0_.image_id = c2_.id LEFT JOIN anuncio_categoria_propiedades a5_ ON a0_.id = a5_.anuncio_id LEFT JOIN categoria_propiedades c4_ ON c4_.id = a5_.categoria_propiedades_id LEFT JOIN anuncio_propiedades a7_ ON a0_.id = a7_.anuncio_id LEFT JOIN propiedades p6_ ON p6_.id = a7_.propiedades_id WHERE l3_.locale = 'en' AND a0_.visible_seccion = 1 AND (c4_.id = 15 OR c4_.id IS NULL) ORDER BY a0_.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 = ?
  AND c0_.id = ?
ORDER BY
  c0_.orden ASC
LIMIT
  8

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' AND c0_.id = 15 ORDER BY c0_.orden ASC LIMIT 8;