SELECT 
  * 
FROM 
  cscart_product_feature_variants 
WHERE 
  variant_id IN (
    5180, 5179, 4790, 4778, 4766, 4807, 4763, 
    4783, 4773, 4776, 4780, 5163, 5164, 
    4862, 3095, 3097, 3096, 3099, 3098, 
    4922, 4981, 5139, 3100, 3101, 5074, 
    3103, 4974, 5063, 4983, 3085, 4915, 
    3686, 3087, 3088, 3089, 3092, 3093, 
    3094, 3104, 3084, 4904, 1870, 0
  )

Query time 0.00083

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": 43,
          "filtered": 100,
          "index_condition": "cscart_product_feature_variants.variant_id in (5180,5179,4790,4778,4766,4807,4763,4783,4773,4776,4780,5163,5164,4862,3095,3097,3096,3099,3098,4922,4981,5139,3100,3101,5074,3103,4974,5063,4983,3085,4915,3686,3087,3088,3089,3092,3093,3094,3104,3084,4904,1870,0)"
        }
      }
    ]
  }
}

Result

variant_id feature_id url color position abt__ut2_color_style abt__ut2_multicolor
1870 70 0 default
3084 84 #001 0 default
3085 84 #fff2cc 0 default
3087 84 #ff9900 0 default
3088 84 #ffffff 0 default
3089 84 #efbadb 0 default
3092 84 #999999 0 default
3093 84 #0000ff 0 default
3094 84 #8e7cc3 0 default
3095 84 #ffffff 0 default
3096 84 #e6b8af 0 default
3097 84 #00ffff 0 default
3098 84 #85200c 0 default
3099 84 #6fa8dc 0 default
3100 84 #ffff00 0 default
3101 84 #00ff00 0 default
3103 84 #b45f06 0 default
3104 84 #ff0000 0 default
3686 84 0 default
4763 155 30 default
4766 155 #ffffff 15 default
4773 155 #ffffff 100 default
4776 155 #ffffff 200 default
4778 155 #ffffff 14 default
4780 155 #ffffff 250 default
4783 155 #ffffff 50 default
4790 155 #ffffff 9 default
4807 155 #ffffff 17 default
4862 69 0 default
4904 47 0 default
4915 84 0 default
4922 84 0 default
4974 84 0 default
4981 84 0 default
4983 84 0 default
5063 84 0 default
5074 84 0 default
5139 84 0 default
5163 177 0 default
5164 177 #ffffff 0 default
5179 178 #ffffff 0 default
5180 178 #ffffff 0 default