MYSQL Expert Needed - INDEX optimization

Hello,

I am currently experiencing some issues with slow queries in my database and everything seems to point in the direction of bad indexing practices .

I need someone to implement proper indexation to fix my queries slowness .

You need to master concepts such as :

- Using EXPLAIN to identify queries behavior
- Using explicit column lists
- Using covering index that allows the entire query to be returned using only indexes (which may well be in memory) rather than reading the table itself.

Please read requirements or your bid will be ignored , I need someone who really knows what they are doing in what comes to Indexing and Database optimization .