Hi, I would do a db design sanity check and then hit priority queries with MySQL explain, maybe even do a little bit of production profiling if that's an option.
All that info should give us an idea of where the bottlenecks are and what can be done to remedy them.