MySQL GROUP BY query drastically slow down when after data reaches a certain amount
I solved the problem. I needed a single-column index on t1.item. It had a multi-column index that was doing nothing for the query.