SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    9783, 9786, 9788, 13031, 13032, 13033, 
    13034, 13035, 13036, 13037, 13038, 
    13039, 13040, 13041, 13042, 13043, 
    13044, 10840, 10841, 10842
  )

Query time 0.00045

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": 20,
      "filtered": 100,
      "index_condition": "cscart_products.product_id in (9783,9786,9788,13031,13032,13033,13034,13035,13036,13037,13038,13039,13040,13041,13042,13043,13044,10840,10841,10842)"
    }
  }
}