Sandbox

SELECT 
  product_id, 
  amount 
FROM 
  cscart_warehouses_sum_products_amount 
WHERE 
  1 
  AND product_id IN (
    122, 58, 5, 22, 18, 27, 119, 121, 141, 23, 
    4, 142, 120, 62, 108, 107
  )

Query time 0.00037

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "17.51"
    },
    "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": 30,
      "rows_produced_per_join": 30,
      "filtered": "100.00",
      "index_condition": "(`test_uchur_k`.`cscart_warehouses_sum_products_amount`.`product_id` in (122,58,5,22,18,27,119,121,141,23,4,142,120,62,108,107))",
      "cost_info": {
        "read_cost": "14.51",
        "eval_cost": "3.00",
        "prefix_cost": "17.51",
        "data_read_per_join": "480"
      },
      "used_columns": [
        "product_id",
        "amount"
      ]
    }
  }
}

Result

product_id	amount
4	15
4	15
5	13
5	13
18	34
18	34
22	8
22	8
23	19
23	19
27	4
27	4
58	35
58	35
62	20
62	20
107	17
107	17
108	10
108	10
119	27
119	27
120	25
120	25
121	22
121	22
122	30
122	30
141	11
141	11
142	12
142	12

product_id	amount
4	15
4	15
5	13
5	13
18	34
18	34
22	8
22	8
23	19
23	19
27	4
27	4
58	35
58	35
62	20
62	20
107	17
107	17
108	10
108	10
119	27
119	27
120	25
120	25
121	22
121	22
122	30
122	30
141	11
141	11
142	12
142	12

product_id	amount
4	15
4	15
5	13
5	13
18	34
18	34
22	8
22	8
23	19
23	19
27	4
27	4
58	35
58	35
62	20
62	20
107	17
107	17
108	10
108	10
119	27
119	27
120	25
120	25
121	22
121	22
122	30
122	30
141	11
141	11
142	12
142	12

product_id	amount
4	15
4	15
5	13
5	13
18	34
18	34
22	8
22	8
23	19
23	19
27	4
27	4
58	35
58	35
62	20
62	20
107	17
107	17
108	10
108	10
119	27
119	27
120	25
120	25
121	22
121	22
122	30
122	30
141	11
141	11
142	12
142	12