Query not returning results if selecting by indexed columns (Mysql 5.6)
I wonder what would happen if you ran OPTIMIZE TABLE product; on your MySQL server. OPTIMIZE TABLE will “rebuild” the physical storage of your table, including the indexes. 

https://dev.mysql.com/doc/refman/8.0/en/optimize-table.html