SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    19722, 19583, 19824, 19791, 19585, 19587, 
    19825, 19752, 19588, 19753, 19765, 
    19755, 19754, 19764, 19586, 19593, 
    19594, 19624, 19595, 19626, 19627, 
    19625
  )

Query time 0.00117

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": 22,
      "filtered": 100,
      "index_condition": "cscart_products.product_id in (19722,19583,19824,19791,19585,19587,19825,19752,19588,19753,19765,19755,19754,19764,19586,19593,19594,19624,19595,19626,19627,19625)"
    }
  }
}