What technology in combination with what $5/month hosting company could you possibly have used to achieve such terrible results?
Remember that you will need to add indexes to the database manually. Cake won't screw with your database by adding them itself.
Still, I'd be worried if a single-query homepage like yours was showing even a hint of a load spike under that sort of traffic. It's amazing that even cheapo hosting can really be that bad.