假设我有这个，它产生50,000行:SELECTphotoIDFROMphotoSearchWHEREphotoIDBETWEEN1AND50000;我打算针对刚刚返回的那些photoID运行此查询。SELECTCOUNT(people)AStotalPeople,peopleFROMpeopleINNERJOINphotopeopleONphotoPeople.peopleID=people.PeopleIDWHEREphotoidIN('ID'sfromresults')GROUPBYpeopleORDERBYtotalPeopleDESC但我从其他人和资源中了解到，IN子句不会很