the "in" use in mysql

use in in mysql,if the field is indexed,the index is still useful,but when the data quantity is small relative to the param in "in" parentheses,mysql optimizer will use ALL TABLE SCAN instead.