SELECT 
  * 
FROM 
  cscart_product_feature_variants 
WHERE 
  variant_id IN (
    5180, 5179, 2998, 4796, 4792, 4766, 4763, 
    4779, 4784, 5163, 5164, 4754, 1882, 
    3095, 3097, 3096, 3099, 3098, 4981, 
    3100, 3101, 3102, 5176, 4974, 5029, 
    5063, 4983, 3085, 4915, 3686, 3087, 
    3088, 3089, 3092, 3090, 3093, 3091, 
    3094, 3104, 3084, 5182, 1273, 1404, 
    4904, 4894, 1856, 1870, 4905, 0
  )

Query time 0.00054

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": 49,
          "filtered": 100,
          "index_condition": "cscart_product_feature_variants.variant_id in (5180,5179,2998,4796,4792,4766,4763,4779,4784,5163,5164,4754,1882,3095,3097,3096,3099,3098,4981,3100,3101,3102,5176,4974,5029,5063,4983,3085,4915,3686,3087,3088,3089,3092,3090,3093,3091,3094,3104,3084,5182,1273,1404,4904,4894,1856,1870,4905,0)"
        }
      }
    ]
  }
}