SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    11896, 11262, 10061, 10355, 11386, 13306, 
    12990, 11385, 13301, 20483, 11226, 
    11902, 13307, 11905, 13599, 12988, 
    13600, 9371, 11384, 12240, 9468, 9816, 
    13687, 18467
  )

Query time 0.00085

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": 24,
          "filtered": 100,
          "index_condition": "cscart_products.product_id in (11896,11262,10061,10355,11386,13306,12990,11385,13301,20483,11226,11902,13307,11905,13599,12988,13600,9371,11384,12240,9468,9816,13687,18467)"
        }
      }
    ]
  }
}