Should a 50k row query take 59-304 seconds?

[ZomgStuff]

So I come home from classes and I see that bluehost has shut me down because I've been quote on quote using too many of their system resources.

I have a forum that at most has maybe 30 people on (including both members and guests).

I'm looking at the sql_slow_queries log and I see a certain query taking anywhere from 59-304 seconds to execute? This is part of a rating mod that I have installed, and I've never had any problems with it before. Out of nowhere do I see this being a problem in the log. Is this a possible issue with my code, or is this bluehost having server hardware from 1999?

Here's an example

# Mon Jan 12 07:35:53 2009
# Query_time: 305 Lock_time: 0 Rows_sent: 1 Rows_examined: 51233
SELECT r.*, count(r.rating) as count
FROM erate AS r
LEFT JOIN post as p ON(r.pid = p.postid)
WHERE p.userid = 9272
GROUP BY r.rating
ORDER BY count DESC
LIMIT 1

Should it even take more than a second because it says "limit 1"?