MySQL没有使用带WHERE IN子句的索引?

I'm trying to optimize some of the database queries in my Rails app and I have several that have got me stumped. They are all using an IN in the WHERE clause and are all doing full table scans even though an appropriate index appears to be in place.I'm trying to optimize some of the database que