SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    49002, 48629, 48690, 48239, 48526, 48622, 
    49289, 49288, 48276, 48627, 48631, 
    48048, 48275, 49578, 48623, 48258, 
    48542, 48625, 48271, 48270, 48328, 
    48628, 49156, 48242, 48238, 48657, 
    48240, 48949, 48539, 48266, 48269, 
    48630
  )

Query time 0.00388

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 (49002,48629,48690,48239,48526,48622,49289,49288,48276,48627,48631,48048,48275,49578,48623,48258,48542,48625,48271,48270,48328,48628,49156,48242,48238,48657,48240,48949,48539,48266,48269,48630)"
        }
      }
    ]
  }
}