MySQL Index Condition Pushdown: Why Your Index Scan Still Reads Too Many Rows
Your query uses an index but still performs too many full-row reads. MySQL's Index Condition Pushdown can filter rows inside InnoDB before fetching them—if your predicates qualify.