SELECT 
  * 
FROM 
  cscart_product_feature_variants 
WHERE 
  variant_id IN (
    4793, 4786, 4764, 4790, 3953, 4792, 4777, 
    4778, 4766, 4783, 4773, 4799, 4779, 
    4810, 4776, 4780, 4806, 4782, 4784, 
    4797, 3745, 3719, 1938, 3709, 4754, 
    4862, 1978, 1934, 4753, 4867, 1912, 
    1895, 1858, 1862, 4755, 4879, 5162, 
    1939, 2970, 1987, 1970, 1941, 5137, 
    2144, 1870, 1859, 0
  )

Query time 0.00065

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": 47,
          "filtered": 100,
          "index_condition": "cscart_product_feature_variants.variant_id in (4793,4786,4764,4790,3953,4792,4777,4778,4766,4783,4773,4799,4779,4810,4776,4780,4806,4782,4784,4797,3745,3719,1938,3709,4754,4862,1978,1934,4753,4867,1912,1895,1858,1862,4755,4879,5162,1939,2970,1987,1970,1941,5137,2144,1870,1859,0)"
        }
      }
    ]
  }
}

Result

variant_id feature_id url color position abt__ut2_color_style abt__ut2_multicolor
1858 69 0 default
1859 70 0 default
1862 69 0 default
1870 70 0 default
1895 69 0 default
1912 69 0 default
1934 69 0 default
1938 69 0 default
1939 69 0 default
1941 69 0 default
1970 69 0 default
1978 69 0 default
1987 69 0 default
2144 69 0 default
2970 69 0 default
3709 69 0 default
3719 69 0 default
3745 69 0 default
3953 155 #ffffff 10 default
4753 69 0 default
4754 69 0 default
4755 69 0 default
4764 155 #ffffff 8 default
4766 155 #ffffff 15 default
4773 155 #ffffff 100 default
4776 155 #ffffff 200 default
4777 155 #ffffff 13 default
4778 155 #ffffff 14 default
4779 155 #ffffff 150 default
4780 155 #ffffff 250 default
4782 155 #ffffff 400 default
4783 155 #ffffff 50 default
4784 155 #ffffff 500 default
4786 155 #ffffff 6 default
4790 155 #ffffff 9 default
4792 155 #ffffff 12 default
4793 155 #ffffff 4 default
4797 155 #ffffff 1000 default
4799 155 #ffffff 125 default
4806 155 #ffffff 300 default
4810 155 #ffffff 160 default
4862 69 0 default
4867 69 0 default
4879 69 0 default
5137 69 0 default
5162 69 0 default