Limit  (cost=229.07..229.08 rows=1 width=53) (actual
time=331.279..331.280 rows=1 loops=1)
   ->  Sort  (cost=229.07..229.08 rows=1 width=53) (actual
time=331.276..331.276 rows=1 loops=1)
         Sort Key: clasificados.destacado, clasificados.fecha,
clasificados.hora
         ->  Nested Loop  (cost=12.80..229.06 rows=1 width=53) (actual
time=125.383..331.246 rows=2 loops=1)
               ->  HashAggregate  (cost=1.60..1.61 rows=1 width=4)
(actual time=0.038..0.047 rows=3 loops=1)
                     ->  Seq Scan on categorias  (cost=0.00..1.60 rows=1
width=4) (actual time=0.021..0.031 rows=3loops=1)
                           Filter: (grupo = 3)
               ->  Bitmap Heap Scan on clasificados  (cost=11.19..227.29
rows=13 width=55) (actual time=110.207..110.379 rows=1 loops=3)
                     Recheck Cond: (clasificados.categoria = "outer".codigo)
                     Filter: ((foto1 <> ''::text) AND (estado = 3) AND
muestrainicio AND destacado AND (categoria <> 59) AND (categoria <> 60)
AND (categoria <> 61) AND (categoria <> 62) AND (categoria <> 63) AND
(categoria <> 64) AND (categoria <> 65) AND (categoria <> 66) AND
(categoria <> 80) AND (referencia <> 613))
                     ->  Bitmap Index Scan on clascate 
(cost=0.00..11.19 rows=55 width=0) (actual time=11.455..11.455
rows=50531 loops=3)
                           Index Cond: (clasificados.categoria =
"outer".codigo)
 Total runtime: 331.426 ms
(13 filas)