SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    47855, 48852, 48322, 47197, 47176, 47853, 
    45256, 44881, 48122, 47607, 47622, 
    41012, 36472, 44752, 46195, 48791, 
    44574, 49185, 48776, 47367, 48033, 
    47166, 44756, 47185, 48790, 50699, 
    48065, 47177, 47897, 50698, 31318, 
    35705
  )

Query time 0.00179

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 (47855,48852,48322,47197,47176,47853,45256,44881,48122,47607,47622,41012,36472,44752,46195,48791,44574,49185,48776,47367,48033,47166,44756,47185,48790,50699,48065,47177,47897,50698,31318,35705)"
        }
      }
    ]
  }
}