SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    29815, 4190, 32316, 19343, 6104, 4339, 
    27952, 41008, 32313, 41009, 32406, 
    4179, 4364, 31739, 45571, 35482, 28118, 
    4466, 49199, 1761, 3851, 40915, 5236, 
    1272, 46272, 37413, 40367, 47967, 47594, 
    43461, 35486, 4187
  )

Query time 0.00112

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 (29815,4190,32316,19343,6104,4339,27952,41008,32313,41009,32406,4179,4364,31739,45571,35482,28118,4466,49199,1761,3851,40915,5236,1272,46272,37413,40367,47967,47594,43461,35486,4187)"
        }
      }
    ]
  }
}