SQL optimization

I have big project on k2.
But when i USE all module it is bad for mysql
I have about 400 sql query.
My project is www.mezon.uz
I think i can help little
I can send to you my file if you give me email