[Sam Bauers]

Do you use mysql query cache? The query you are talking about would benefit from query caching as it is hit often.