Symfony Profiler

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 = 'negocios' 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 = ?
  AND c0_.padre_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_.padre_id = 27 ORDER BY c0_.orden ASC LIMIT 8;

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 = 'es' AND a0_.visible_seccion = 1 AND (c4_.id = 27 OR c4_.id IS NULL) ORDER BY a0_.orden ASC;