SELECT 
  product_id, 
  amount 
FROM 
  cscart_warehouses_sum_products_amount 
WHERE 
  1 
  AND product_id IN (
    51567, 
    51480, 
    51565, 
    51564, 
    51479, 
    139, 
    129, 
    51566, 
    51301, 
    51494, 
    51, 
    50, 
    51497, 
    51498, 
    51495, 
    51563, 
    53, 
    22713, 
    21, 
    22714, 
    22712, 
    46, 
    22715, 
    22716, 
    51496, 
    21567, 
    91, 
    50989, 
    105, 
    48, 
    49, 
    92, 
    137, 
    88, 
    126, 
    31, 
    51358, 
    115, 
    80, 
    37, 
    11, 
    140, 
    41, 
    30, 
    90, 
    38, 
    124, 
    81, 
    56, 
    82, 
    116, 
    117, 
    125, 
    106, 
    39, 
    193, 
    40, 
    22710, 
    22711, 
    17, 
    57, 
    122, 
    58, 
    5, 
    22, 
    18, 
    119, 
    27, 
    121, 
    23, 
    141, 
    4, 
    142, 
    120, 
    62, 
    108, 
    107, 
    94, 
    8, 
    86, 
    54, 
    132, 
    10, 
    93, 
    12, 
    32, 
    7, 
    130, 
    35, 
    16, 
    112, 
    3, 
    78, 
    33, 
    2, 
    110, 
    34, 
    89, 
    114, 
    77, 
    147, 
    36, 
    87, 
    128, 
    96, 
    20, 
    52, 
    84, 
    109, 
    66, 
    118, 
    131, 
    13, 
    19, 
    61, 
    146, 
    95, 
    15, 
    9, 
    85, 
    22421, 
    83, 
    111, 
    59, 
    22424, 
    144, 
    123, 
    60
  )

Query time 0.00155

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "143.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": 247,
      "rows_produced_per_join": 247,
      "filtered": "100.00",
      "index_condition": "(`test_uchur_k`.`cscart_warehouses_sum_products_amount`.`product_id` in (51567,51480,51565,51564,51479,139,129,51566,51301,51494,51,50,51497,51498,51495,51563,53,22713,21,22714,22712,46,22715,22716,51496,21567,91,50989,105,48,49,92,137,88,126,31,51358,115,80,37,11,140,41,30,90,38,124,81,56,82,116,117,125,106,39,193,40,22710,22711,17,57,122,58,5,22,18,119,27,121,23,141,4,142,120,62,108,107,94,8,86,54,132,10,93,12,32,7,130,35,16,112,3,78,33,2,110,34,89,114,77,147,36,87,128,96,20,52,84,109,66,118,131,13,19,61,146,95,15,9,85,22421,83,111,59,22424,144,123,60))",
      "cost_info": {
        "read_cost": "118.46",
        "eval_cost": "24.70",
        "prefix_cost": "143.16",
        "data_read_per_join": "3K"
      },
      "used_columns": [
        "product_id",
        "amount"
      ]
    }
  }
}

Result

product_id amount
2 120
2 120
3 8
3 8
4 15
4 15
5 13
5 13
7 2
7 2
8 3
8 3
9 36
9 36
10 38
10 38
11 100
11 100
12 3
12 3
13 20
13 20
15 31
15 31
16 23
16 23
17 32
17 32
18 34
18 34
19 3
19 3
20 2
20 2
21 2
21 2
22 8
22 8
23 19
23 19
27 4
27 4
30 4
30 4
31 3
31 3
32 1
32 1
33 2
33 2
34 3
34 3
35 3
35 3
36 3
36 3
37 1
37 1
38 2
38 2
39 3
39 3
40 3
40 3
41 3
41 3
46 16
46 16
48 1
48 1
49 1
49 1
50 4
50 4
51 4
51 4
52 2
52 2
53 5
53 5
54 3
54 3
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
66 9
66 9
77 3
77 3
78 3
78 3
80 3
80 3
81 31
81 31
83 1
83 1
84 18
84 18
85 70
85 70
86 27
86 27
87 9
87 9
88 18
88 18
89 8
89 8
90 1
90 1
91 1
91 1
92 1
92 1
93 1
93 1
94 1
94 1
95 13
95 13
96 4
96 4
105 25
105 25
106 22
106 22
107 17
107 17
108 10
108 10
109 3
109 3
110 3
110 3
111 1
111 1
112 10
112 10
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
124 7
124 7
125 6
125 6
126 108
126 108
128 3
128 3
129 3
129 3
130 2
130 2
131 2
131 2
132 53
132 53
137 1
137 1
139 7
139 7
140 7
140 7
141 11
141 11
142 12
142 12
144 4
144 4
146 4
146 4
147 2
147 2
22421 4
22421 4
22424 2
22424 2
22710 16
22710 16
22711 12
22711 12
22712 5
22712 5
22713 4
22713 4
22714 4
22714 4
22715 2
22715 2
22716 5
22716 5
50989 13
50989 13
51301 8
51301 8
51358 9
51358 9
51479 148
51479 148
51480 147
51480 147
51494 52
51494 52
51495 52
51495 52
51496 30
51496 30
51497 30
51497 30
51498 30
51498 30
51563 199
51563 199
51564 1
51564 1
51565 1
51565 1
51566 2
51566 2
51567 2
51567 2