Understanding the MySQL Performance Issue on Simple Join with No Indexes

Optimizing MySQL Queries with the IN Clause: Understanding Performance Variance and Strategies for Improvement