Slow queries : what can I do?

Can you also share the query / request that you use?