Re: Please help with slow easy query

[Rick James]

This looks like a typo:

    -> AND cc.category_id = cc.category_id

so I don't trust the EXPLAIN

What is this supposed to be?

'rub.'currency,

And this?

 i.enabled & ( i.quantity >1 ) AS onstock

Probably not good to have ids be NULLable.

Please try this on each table:

  ANALYZE TABLE tbl;

Looking back at the message of 2009-04-24 07:18, it appears that it picked the 'wrong' table to start with. The ANALYZE may fix that.

How many rows in the result set? If it is more than about 40,000, the strange behaviour may be explainable -- that is, a table scan is probably better than jumping back and forth between the index and the data.