A not so complex query was taking a huge time to complete (hours …).
I searched for an “EXPLAIN ANALYSE” a la PostgreSQL on MySQL … this does not exists.
They have a less featured command called “EXPLAIN EXTENDED” that outputs some interesting information.
I found that adding two indexes helped me to have the query processed in some seconds … 😉
 The EXTENDED argument did not change the ouput I had …