SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    3777, 31919, 788, 18748, 4304, 3174, 
    33697, 43797, 992, 332, 276, 6603, 25777, 
    5434, 6046, 4299, 6649, 6044, 27940, 
    2460, 31917, 1747, 6087, 47904, 5277, 
    141, 5998, 5220, 5267, 1639, 5416, 5418
  )

Query time 0.00195

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_products",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "rows": 32,
          "filtered": 100,
          "index_condition": "cscart_products.product_id in (3777,31919,788,18748,4304,3174,33697,43797,992,332,276,6603,25777,5434,6046,4299,6649,6044,27940,2460,31917,1747,6087,47904,5277,141,5998,5220,5267,1639,5416,5418)"
        }
      }
    ]
  }
}