SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    5549, 40434, 4122, 37318, 46737, 34671, 
    2922, 4121, 47658, 47010, 38135, 41397, 
    2964, 31640, 3180, 40440, 5506, 34053, 
    3586, 45507, 27354, 389, 803, 5445, 
    1713, 19348, 3388, 44422, 47984, 2278, 
    3874, 38134
  )

Query time 0.00584

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 (5549,40434,4122,37318,46737,34671,2922,4121,47658,47010,38135,41397,2964,31640,3180,40440,5506,34053,3586,45507,27354,389,803,5445,1713,19348,3388,44422,47984,2278,3874,38134)"
        }
      }
    ]
  }
}