Preload variants when checking order promotionability to avoid an N+1

Preload variants when checking order promotionability to avoid an N+1 #1248