SELECT 
  product_id, 
  amount 
FROM 
  cscart_warehouses_sum_products_amount 
WHERE 
  1 
  AND product_id IN (
    51497, 51498, 51496, 105, 126, 115, 11, 
    81, 56, 135, 82, 116, 117, 106, 17, 57, 
    122, 58, 5, 22, 18, 27, 119, 121, 141, 
    23, 4, 142, 120, 62, 108, 107, 10, 16, 
    114, 118, 13, 61, 15, 9, 59, 123, 60, 113, 
    6, 14, 63
  )

Query time 0.00061

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "53.16"
    },
    "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": 92,
      "rows_produced_per_join": 92,
      "filtered": "100.00",
      "index_condition": "(`test_uchur_k`.`cscart_warehouses_sum_products_amount`.`product_id` in (51497,51498,51496,105,126,115,11,81,56,135,82,116,117,106,17,57,122,58,5,22,18,27,119,121,141,23,4,142,120,62,108,107,10,16,114,118,13,61,15,9,59,123,60,113,6,14,63))",
      "cost_info": {
        "read_cost": "43.96",
        "eval_cost": "9.20",
        "prefix_cost": "53.16",
        "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
11 100
11 100
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
56 103
56 103
57 35
57 35
58 35
58 35
59 14
59 14
60 29
60 29
61 12
61 12
62 20
62 20
63 5
63 5
81 31
81 31
105 25
105 25
106 22
106 22
107 17
107 17
108 10
108 10
113 37
113 37
114 25
114 25
115 7
115 7
116 3
116 3
117 13
117 13
118 20
118 20
119 27
119 27
120 25
120 25
121 22
121 22
122 30
122 30
123 21
123 21
126 108
126 108
135 6
135 6
141 11
141 11
142 12
142 12
51496 30
51496 30
51497 30
51497 30
51498 30
51498 30