SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    41, 332, 330, 333, 329, 327, 504, 1008, 
    758, 1817, 1819, 1172, 1196, 1908, 1809, 
    1405, 1851, 730, 1481, 382, 453, 425, 
    360, 1479, 1478, 414, 1866, 788, 1084, 
    1903, 538, 759
  )

Query time 0.00139

JSON explain

{
  "query_block": {
    "select_id": 1,
    "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 (41,332,330,333,329,327,504,1008,758,1817,1819,1172,1196,1908,1809,1405,1851,730,1481,382,453,425,360,1479,1478,414,1866,788,1084,1903,538,759)"
    }
  }
}