如何在三个表(40k行)中优化一个缓慢的“选择不同的”查询，只返回22个结果

So I have this query written by someone else that I'm trying to refactor, which pulls some features/materials for an item(shoes, generally). So I have this query written by someone else th