SELECT 
  * 
FROM 
  cscart_product_feature_variants 
WHERE 
  variant_id IN (
    2526, 1892, 1855, 1930, 617, 75, 474, 
    654, 47, 613, 837, 1699, 633, 125, 50, 
    1765, 540, 636, 604, 49, 612, 890, 602, 
    600, 601, 59, 611, 48, 422, 1354, 905, 
    64, 58, 473, 2982, 1856, 1870, 0, 2986, 
    590, 91, 2987
  )

Query time 0.00057

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_feature_variants",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["variant_id"],
          "rows": 42,
          "filtered": 100,
          "index_condition": "cscart_product_feature_variants.variant_id in (2526,1892,1855,1930,617,75,474,654,47,613,837,1699,633,125,50,1765,540,636,604,49,612,890,602,600,601,59,611,48,422,1354,905,64,58,473,2982,1856,1870,0,2986,590,91,2987)"
        }
      }
    ]
  }
}

Result

variant_id feature_id url color position abt__ut2_color_style abt__ut2_multicolor
47 26 0 default
48 26 0 default
49 26 0 default
50 26 0 default
58 26 0 default
59 26 0 default
64 26 0 default
75 26 0 default
91 1 0 default
125 26 0 default
422 26 0 default
473 26 0 default
474 26 0 default
540 26 0 default
590 1 0 default
600 26 0 default
601 26 0 default
602 26 0 default
604 26 0 default
611 26 0 default
612 26 0 default
613 26 0 default
617 26 0 default
633 26 0 default
636 26 0 default
654 26 0 default
837 26 0 default
890 26 0 default
905 26 0 default
1354 26 0 default
1699 26 0 default
1765 26 0 default
1855 69 0 default
1856 70 0 default
1870 70 0 default
1892 69 0 default
1930 69 0 default
2526 69 0 default
2982 49 0 default
2986 6 0 default
2987 78 0 default