Someone

SELECT 'category.php', pid, user_id, 	(select username from users where users.user_id=pictures.user_id) as username, title, image_type, get_picture_genres(pid) as genres, 	pictures.rating_nudity, pictures.rating_violence, pictures.rating_sex, 	pictures.rating_racism, pictures.rating_spoilers, pictures.rating_yuri, pictures.rating_yaoi from pictures inner join picture_categories using(pid) where cat_id='122' and pictures.rating_nudity <= '1' and pictures.rating_violence <= '1' and pictures.rating_sex <= '1' 	and pictures.rating_yaoi = 0 and pictures.rating_racism <= '1' and pictures.rating_spoilers <= '1' 	and pictures.rating_profanity <= '1' and pictures.rating_yuri = 0 and pictures.approved > 0 order by date_submitted desc limit 25 offset 75Limit  (cost=35823.31..35823.38 rows=25 width=55) (actual time=795.163..795.442 rows=25 loops=1)  ->  Sort  (cost=35823.13..35829.88 rows=2701 width=55) (actual time=794.582..794.961 rows=100 loops=1)        Sort Key: pictures.date_submitted        ->  Nested Loop  (cost=18.35..35669.18 rows=2701 width=55) (actual time=2.920..759.420 rows=1753 loops=1)              ->  Bitmap Heap Scan on picture_categories  (cost=18.35..1729.15 rows=2957 width=4) (actual time=1.900..72.593 rows=1833 loops=1)                    Recheck Cond: (cat_id = 122)                    ->  Bitmap Index Scan on idx_picture_categories_cat_id  (cost=0.00..18.35 rows=2957 width=0) (actual time=1.562..1.562 rows=1833 loops=1)                          Index Cond: (cat_id = 122)              ->  Index Scan using pictures_pkey on pictures  (cost=0.00..6.02 rows=1 width=55) (actual time=0.104..0.110 rows=1 loops=1833)                    Index Cond: (pictures.pid = "outer".pid)                    Filter: ((rating_nudity <= 1::smallint) AND (rating_violence <= 1::smallint) AND (rating_sex <= 1::smallint) AND (rating_yaoi = 0) AND (rating_racism <= 1::smallint) AND (rating_spoilers <= 1::smallint) AND (rating_profanity <= 1::smallint) AND (rating_yuri = 0) AND (approved > 0))              SubPlan                ->  Index Scan using users_pkey on users  (cost=0.00..5.96 rows=1 width=15) (actual time=0.040..0.047 rows=1 loops=1753)                      Index Cond: (user_id = $0)Total runtime: 796.525 ms