即使使用INNER JOIN而不是IN，MySQL查询也非常慢

I have three tables：product (10k records), product_attribute (4k records), and product_value (2m records). product and product_attribute are connected via product_value. I want to retrieve a specific product (e.g., product_id = 001) and its respective attribute name and attribute value. At first, I try I have three tables：product (10k records), prod