Mysql Query Optimization. 2

I´ve a website running LAMP.
My db size is over 5.5 gb.

I´ve a couple of queries that run extremely low.

Im looking for someone that given sql structure and queries can optimize then in order to achive good performance.