Merge pull request #29639 from marination/item-variants-perf

perf: Weed out disabled variants via sql query instead of pythonic looping separately