SELECT 
  * 
FROM 
  tmall_product_feature_variants 
WHERE 
  variant_id IN (
    91, 104, 111, 102, 135, 108, 103, 115, 
    136, 109, 117, 110, 100, 89, 121, 114, 
    101, 106, 112, 84, 55, 66, 73, 76, 78, 
    69, 39, 77, 83, 80, 65, 71, 67, 68, 74, 
    70, 45, 79, 81, 54, 75, 48, 82, 72
  )

Query time 0.00778

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost": 0.03874171,
    "nested_loop": [
      {
        "table": {
          "table_name": "tmall_product_feature_variants",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "loops": 1,
          "rows": 182,
          "cost": 0.03874171,
          "filtered": 24.17582512,
          "attached_condition": "tmall_product_feature_variants.variant_id in (91,104,111,102,135,108,103,115,136,109,117,110,100,89,121,114,101,106,112,84,55,66,73,76,78,69,39,77,83,80,65,71,67,68,74,70,45,79,81,54,75,48,82,72)"
        }
      }
    ]
  }
}