MySQL command Explain ignore LIMIT?
here a good link of article about MySQL EXPLAIN limits and errors
LIMIT is not taken into account while estimating number of rows Even if you have LIMIT which restricts how many rows will be examined MySQL will still print full number