SELECT 
  * 
FROM 
  cscart_product_feature_variants 
WHERE 
  variant_id IN (
    4775, 4764, 3953, 3745, 2140, 1966, 2202, 
    2331, 3709, 4862, 2747, 1934, 1913, 
    1862, 1882, 1855, 4755, 1878, 1939, 
    2470, 1987, 1880, 2426, 1874, 2667, 
    1869, 3096, 3084, 3093, 3102, 3101, 
    3090, 3086, 3087, 3686, 4969, 3089, 
    3104, 3091, 3088, 3094, 3095, 3100, 
    187, 495, 2030, 1856, 1870, 1859, 0, 
    229, 231, 723, 511, 461, 658, 17, 389, 
    388, 428, 712, 1478, 1877
  )

Query time 0.00097

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": 63,
          "filtered": 100,
          "index_condition": "cscart_product_feature_variants.variant_id in (4775,4764,3953,3745,2140,1966,2202,2331,3709,4862,2747,1934,1913,1862,1882,1855,4755,1878,1939,2470,1987,1880,2426,1874,2667,1869,3096,3084,3093,3102,3101,3090,3086,3087,3686,4969,3089,3104,3091,3088,3094,3095,3100,187,495,2030,1856,1870,1859,0,229,231,723,511,461,658,17,389,388,428,712,1478,1877)"
        }
      }
    ]
  }
}

Result

variant_id feature_id url color position abt__ut2_color_style abt__ut2_multicolor
17 6 0 default
187 18 0 default
229 6 0 default
231 6 0 default
388 6 0 default
389 6 0 default
428 6 0 default
461 6 0 default
495 44 0 default
511 6 0 default
658 6 0 default
712 6 0 default
723 6 0 default
1478 6 0 default
1855 69 0 default
1856 70 0 default
1859 70 0 default
1862 69 0 default
1869 69 0 default
1870 70 0 default
1874 69 0 default
1877 78 0 default
1878 69 0 default
1880 69 0 default
1882 69 0 default
1913 69 0 default
1934 69 0 default
1939 69 0 default
1966 69 0 default
1987 69 0 default
2030 70 0 default
2140 69 0 default
2202 69 0 default
2331 69 0 default
2426 69 0 default
2470 69 0 default
2667 69 0 default
2747 69 0 default
3084 84 #001 0 default
3086 84 #f4cccc 0 default
3087 84 #ff9900 0 default
3088 84 #ffffff 0 default
3089 84 #efbadb 0 default
3090 84 #00ff00 0 default
3091 84 #d9d9d9 0 default
3093 84 #0000ff 0 default
3094 84 #8e7cc3 0 default
3095 84 #ffffff 0 default
3096 84 #e6b8af 0 default
3100 84 #ffff00 0 default
3101 84 #00ff00 0 default
3102 84 #ffd966 0 default
3104 84 #ff0000 0 default
3686 84 0 default
3709 69 0 default
3745 69 0 default
3953 155 #ffffff 10 default
4755 69 0 default
4764 155 #ffffff 8 default
4775 155 5 default
4862 69 0 default
4969 84 0 default