SMF avoids using 'IN' in the query, for the query to use the index instead. There's only an index on id_member iirc however.