SELECT 
  product_id, 
  amount 
FROM 
  cscart_warehouses_sum_products_amount 
WHERE 
  1 
  AND product_id IN (
    10, 9, 142, 59, 60, 62, 141, 27, 22, 23, 
    14, 13, 17, 18, 16, 106, 105, 58, 57, 113, 
    51344, 120, 51345, 119, 51346, 118, 
    114, 4, 5, 6, 51348, 121, 51349, 122, 
    61, 51350, 123, 15
  )

Query time 0.00070

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "45.96"
    },
    "table": {
      "table_name": "cscart_warehouses_sum_products_amount",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 81,
      "rows_produced_per_join": 81,
      "filtered": "100.00",
      "index_condition": "(`test_uchur_k`.`cscart_warehouses_sum_products_amount`.`product_id` in (10,9,142,59,60,62,141,27,22,23,14,13,17,18,16,106,105,58,57,113,51344,120,51345,119,51346,118,114,4,5,6,51348,121,51349,122,61,51350,123,15))",
      "cost_info": {
        "read_cost": "37.86",
        "eval_cost": "8.10",
        "prefix_cost": "45.96",
        "data_read_per_join": "1K"
      },
      "used_columns": [
        "product_id",
        "amount"
      ]
    }
  }
}

Result

product_id amount
4 15
4 15
5 13
5 13
6 29
6 29
9 36
9 36
10 38
10 38
13 20
13 20
14 29
14 29
15 31
15 31
16 23
16 23
17 32
17 32
18 34
18 34
22 8
22 8
23 19
23 19
27 4
27 4
57 35
57 35
58 35
58 35
59 14
59 14
60 29
60 29
61 12
61 12
62 20
62 20
105 25
105 25
106 22
106 22
113 37
113 37
114 25
114 25
118 20
118 20
119 27
119 27
120 25
120 25
121 22
121 22
122 30
122 30
123 21
123 21
141 11
141 11
142 12
142 12
51344 15
51344 15
51345 20
51345 20
51346 10
51346 10
51348 10
51348 10
51349 30
51349 30
51350 20
51350 20