SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    2131, 1666, 6610, 38139, 6576, 637, 5407, 
    31899, 2553, 330, 1660, 38144, 6124, 
    3745, 20944, 5230, 3886, 296, 20932, 
    40154, 6529, 3785, 2130, 41232, 3601, 
    5205, 2462, 40148, 2512, 2013, 1437, 
    37847
  )

Query time 0.00176

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 (2131,1666,6610,38139,6576,637,5407,31899,2553,330,1660,38144,6124,3745,20944,5230,3886,296,20932,40154,6529,3785,2130,41232,3601,5205,2462,40148,2512,2013,1437,37847)"
        }
      }
    ]
  }
}