SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (
    2534, 
    6126, 
    2533, 
    7508, 
    7509, 
    7510, 
    7511, 
    7525, 
    7524, 
    7523, 
    7522, 
    7521, 
    7520, 
    7519, 
    7518, 
    7517, 
    7516, 
    7515, 
    7514, 
    7513, 
    7512, 
    2882, 
    2881, 
    6467, 
    6373, 
    2204, 
    5804, 
    2206, 
    2205, 
    6329, 
    2741, 
    6331, 
    6330, 
    6128, 
    6127, 
    2536, 
    5956, 
    6216, 
    2623, 
    6215, 
    2625, 
    2624, 
    6218, 
    6046, 
    2444, 
    2446, 
    6055, 
    2447, 
    2783, 
    6370, 
    6372, 
    2784, 
    6371, 
    2786, 
    2785, 
    2354, 
    6374, 
    6631, 
    3051, 
    6628, 
    6630, 
    3052, 
    6629, 
    2744, 
    6457, 
    2870, 
    6454, 
    6456, 
    2871, 
    6455, 
    2873, 
    2872, 
    6458, 
    6466, 
    5953, 
    5955, 
    2355, 
    5954, 
    2357, 
    2356, 
    5957, 
    6217, 
    3054, 
    3053, 
    6632, 
    2958, 
    6540, 
    2955, 
    2957, 
    6541, 
    2956, 
    6543, 
    6542, 
    2959, 
    2201, 
    5799, 
    2198, 
    2200, 
    5800, 
    2199, 
    5801, 
    2202, 
    5806, 
    2203, 
    5803, 
    2879, 
    6463, 
    2453, 
    6054, 
    6047, 
    2868, 
    6627, 
    6450, 
    6626, 
    2865, 
    6368, 
    6323, 
    2782, 
    6325, 
    2877, 
    2954, 
    6459, 
    2953, 
    2874, 
    6539, 
    2876, 
    3050, 
    2867, 
    6465, 
    2880, 
    6464, 
    2742, 
    3048, 
    2738, 
    6625, 
    6327, 
    3047, 
    3049, 
    2737, 
    6624, 
    6324, 
    3046, 
    2739, 
    2952, 
    2869, 
    6536, 
    6043, 
    6045, 
    2445, 
    6044, 
    2622, 
    6214, 
    6538, 
    6451, 
    2951, 
    2866, 
    6535, 
    6453, 
    6537, 
    6452, 
    2778, 
    6056, 
    2780, 
    6848, 
    6367, 
    2779, 
    6326, 
    6369, 
    2736, 
    6462, 
    2454, 
    6461, 
    6053, 
    2878, 
    2781, 
    2456, 
    6366, 
    2455, 
    2743, 
    6460, 
    6328, 
    2875, 
    2740, 
    6052, 
    2288, 
    6048, 
    2289, 
    2451, 
    5886, 
    2443, 
    2287, 
    5888, 
    2441, 
    2439, 
    6039, 
    2618, 
    6211, 
    2619, 
    5951, 
    5952, 
    2350, 
    2352, 
    6124, 
    2530, 
    6041, 
    5887, 
    6042, 
    5885, 
    2440, 
    2286, 
    6040, 
    2442, 
    2621, 
    6212, 
    6213, 
    2617, 
    6210, 
    2620, 
    2353, 
    5950, 
    2351, 
    2349, 
    5949, 
    6120, 
    2528, 
    6123, 
    5889, 
    2531, 
    6121, 
    2529, 
    6122, 
    2449, 
    6050, 
    6051, 
    6049, 
    2450, 
    2448, 
    5891, 
    2532, 
    2292, 
    6125, 
    2535, 
    2290, 
    2294, 
    5890, 
    5892, 
    2293, 
    5893, 
    2452, 
    2291, 
    5805
  )

Query time 0.00103

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "51.66"
    },
    "table": {
      "table_name": "cscart_product_popularity",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "total"
      ],
      "key": "PRIMARY",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 251,
      "rows_produced_per_join": 251,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "26.56",
        "eval_cost": "25.10",
        "prefix_cost": "51.66",
        "data_read_per_join": "7K"
      },
      "used_columns": [
        "product_id"
      ],
      "attached_condition": "(`gaseus`.`cscart_product_popularity`.`product_id` in (2534,6126,2533,7508,7509,7510,7511,7525,7524,7523,7522,7521,7520,7519,7518,7517,7516,7515,7514,7513,7512,2882,2881,6467,6373,2204,5804,2206,2205,6329,2741,6331,6330,6128,6127,2536,5956,6216,2623,6215,2625,2624,6218,6046,2444,2446,6055,2447,2783,6370,6372,2784,6371,2786,2785,2354,6374,6631,3051,6628,6630,3052,6629,2744,6457,2870,6454,6456,2871,6455,2873,2872,6458,6466,5953,5955,2355,5954,2357,2356,5957,6217,3054,3053,6632,2958,6540,2955,2957,6541,2956,6543,6542,2959,2201,5799,2198,2200,5800,2199,5801,2202,5806,2203,5803,2879,6463,2453,6054,6047,2868,6627,6450,6626,2865,6368,6323,2782,6325,2877,2954,6459,2953,2874,6539,2876,3050,2867,6465,2880,6464,2742,3048,2738,6625,6327,3047,3049,2737,6624,6324,3046,2739,2952,2869,6536,6043,6045,2445,6044,2622,6214,6538,6451,2951,2866,6535,6453,6537,6452,2778,6056,2780,6848,6367,2779,6326,6369,2736,6462,2454,6461,6053,2878,2781,2456,6366,2455,2743,6460,6328,2875,2740,6052,2288,6048,2289,2451,5886,2443,2287,5888,2441,2439,6039,2618,6211,2619,5951,5952,2350,2352,6124,2530,6041,5887,6042,5885,2440,2286,6040,2442,2621,6212,6213,2617,6210,2620,2353,5950,2351,2349,5949,6120,2528,6123,5889,2531,6121,2529,6122,2449,6050,6051,6049,2450,2448,5891,2532,2292,6125,2535,2290,2294,5890,5892,2293,5893,2452,2291,5805))"
    }
  }
}

Result

product_id
2198
2199
2200
2201
2202
2203
2204
2205
2206
2286
2287
2288
2289
2290
2291
2292
2293
2294
2349
2350
2351
2352
2353
2354
2355
2356
2357
2439
2440
2441
2442
2443
2444
2445
2446
2447
2448
2449
2450
2451
2452
2453
2454
2455
2456
2528
2529
2530
2531
2532
2533
2534
2535
2536
2617
2618
2619
2620
2621
2622
2623
2624
2625
2736
2737
2738
2739
2740
2741
2742
2743
2744
2778
2779
2780
2781
2782
2783
2784
2785
2786
2865
2866
2867
2868
2869
2870
2871
2872
2873
2874
2875
2876
2877
2878
2879
2880
2881
2882
2951
2952
2953
2954
2955
2956
2957
2958
2959
3046
3047
3048
3049
3050
3051
3052
3053
3054
5799
5800
5801
5803
5804
5805
5806
5885
5886
5887
5888
5889
5890
5891
5892
5893
5949
5950
5951
5952
5953
5954
5955
5956
5957
6039
6040
6041
6042
6043
6044
6045
6046
6047
6048
6049
6050
6051
6052
6053
6054
6055
6056
6120
6121
6122
6123
6124
6125
6126
6127
6128
6210
6211
6212
6213
6214
6215
6216
6217
6218
6323
6324
6325
6326
6327
6328
6329
6330
6331
6366
6367
6368
6369
6370
6371
6372
6373
6374
6450
6451
6452
6453
6454
6455
6456
6457
6458
6459
6460
6461
6462
6463
6464
6465
6466
6467
6535
6536
6537
6538
6539
6540
6541
6542
6543
6624
6625
6626
6627
6628
6629
6630
6631
6632
6848
7508
7509
7510
7511
7512
7513
7514
7515
7516
7517
7518
7519
7520
7521
7522
7523
7524
7525