[liwo]

I found another one that should propably be added:

ALTER TABLE `award` ADD INDEX `award_cat_id` ( `award_cat_id` )

Again, optimize table to fill the index:

OPTIMIZE TABLE `award`

That's all I spotted now. To further track down the issue I would suggest to turn on slow query log on the mysql server and enable the option "log-queries-not-using-indexes", which logs the querys to the slow query log. If you are on shared hosting, ask your provider to enable these options for you (normally they do such things as you are about to take load off their server ). If you run your own server I hope you know how to do this :P (if not, have a look at the documentation on mysql.com, search for the options and add them to my.cnf)