具有外键和范围的查询的索引设计

I'm using MySQL 5.6 and am having some trouble with performance of queries in some very large tables. Specifically I'm unsure how to index my tables properly when there are both references between the tables as well as an in() condition.I'm using MySQL 5.6 and am having some trouble