SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    41291, 5785, 737, 35740, 33702, 41294, 
    1484, 37096, 26899, 2157, 1519, 45357, 
    23267, 47014, 26872, 27039, 502, 46548, 
    26871, 1895, 47015, 1715, 26898, 47657, 
    47654, 26870, 26874, 6360, 47011, 5547, 
    5832, 43823
  )

Query time 0.00182

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 (41291,5785,737,35740,33702,41294,1484,37096,26899,2157,1519,45357,23267,47014,26872,27039,502,46548,26871,1895,47015,1715,26898,47657,47654,26870,26874,6360,47011,5547,5832,43823)"
        }
      }
    ]
  }
}