Nothing groundbreaking in the plan. It shows a Clustered Index Scan -> Compute Scalar (I think it's resolving *)-> SELECT.

The Clustered Index Scan get 100% of cost. Estimated rows is correct.

One of the symptoms has changed. The following query is also short records now:

SELECT * FROM Product;

So possibly this problem is to do with the * wildcard? or one of the columns in the table?