SQL Server（2014）来自IN（列表）变体的奇怪行为

I've been looking at trying to optimise (or at least change) some EF code in C# to use stored procedures, and found what seems to be an anomaly (or something new to me) when finding rows matching a constant list. The typical manually-generated short query would be something like...I've been looking at trying to optimise (or at