afaik the query is really simple and it shouldnt be slow.
first action would probably be to atleast index variantID and perhaps other fields as well.
if that doesnt help it might help to set up a query cache, but i would try with indexes first