SELECT 
  * 
FROM 
  tmall_product_feature_variants 
WHERE 
  variant_id IN (
    116, 92, 86, 129, 91, 120, 88, 131, 124, 
    125, 130, 104, 96, 111, 95, 113, 102, 
    135, 93, 108, 99, 103, 115, 94, 136, 133, 
    109, 122, 123, 87, 117, 110, 98, 100, 
    126, 107, 105, 89, 121, 114, 127, 134, 
    101, 106, 97, 90, 118, 119, 128, 132, 
    112, 1199, 1200, 1201, 1193, 1194, 1195, 
    84, 55, 66, 52, 58, 73, 76, 78, 49, 46, 
    69, 39, 63, 61, 59, 77, 51, 41, 83, 80, 
    65, 71, 67, 68, 74, 70, 56, 53, 44, 45, 
    47, 64, 79, 81, 50, 54, 75, 48, 82, 60, 
    62, 72
  )

Query time 0.00965

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": 54.39560318,
          "attached_condition": "tmall_product_feature_variants.variant_id in (116,92,86,129,91,120,88,131,124,125,130,104,96,111,95,113,102,135,93,108,99,103,115,94,136,133,109,122,123,87,117,110,98,100,126,107,105,89,121,114,127,134,101,106,97,90,118,119,128,132,112,1199,1200,1201,1193,1194,1195,84,55,66,52,58,73,76,78,49,46,69,39,63,61,59,77,51,41,83,80,65,71,67,68,74,70,56,53,44,45,47,64,79,81,50,54,75,48,82,60,62,72)"
        }
      }
    ]
  }
}