SELECT 
  * 
FROM 
  vi_product_feature_variants 
WHERE 
  variant_id IN (
    92, 91, 88, 104, 111, 95, 102, 135, 93, 
    108, 99, 103, 115, 94, 136, 109, 117, 
    110, 98, 100, 89, 121, 114, 101, 106, 
    97, 112, 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.00018

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "vi_product_feature_variants",
          "access_type": "ALL",
          "possible_keys": ["PRIMARY"],
          "rows": 186,
          "filtered": 37.09677505,
          "attached_condition": "vi_product_feature_variants.variant_id in (92,91,88,104,111,95,102,135,93,108,99,103,115,94,136,109,117,110,98,100,89,121,114,101,106,97,112,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)"
        }
      }
    ]
  }
}