Attachments are usually going to be recalled from the database by their comment_id. Is there a reason why you made the index on user_id and comment_id?  I would suggest you make it just comment_id