My website is using up too many resources - Fix please

The MySQL queries that are being made are a problem. Each time they run, several thousand rows are returned at random, which can take quite some time when several of them are being made at once.

I need someone who can fix this as soon as possible. If you are interested, more details will be given via PM.

EDIT: PERSON FOUND, THANKS.