SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (
    7448, 
    7449, 
    7450, 
    7451, 
    7452, 
    7453, 
    7454, 
    7455, 
    7456, 
    7457, 
    7458, 
    7459, 
    7460, 
    7461, 
    7462, 
    7463, 
    7484, 
    7485, 
    7486, 
    7487, 
    7488, 
    7489, 
    7490, 
    7491, 
    2969, 
    2970, 
    2912, 
    6554, 
    2981, 
    6647, 
    3069, 
    6557, 
    6561, 
    2976, 
    6558, 
    2977, 
    2980, 
    6553, 
    6562, 
    2481, 
    6081, 
    6082, 
    2482, 
    2638, 
    6231, 
    2639, 
    6232, 
    6141, 
    2549, 
    6142, 
    2550, 
    6145, 
    2553, 
    6146, 
    2554, 
    2370, 
    5970, 
    5971, 
    2371, 
    2642, 
    6235, 
    6380, 
    6497, 
    2916, 
    6381, 
    6560, 
    6501, 
    2978, 
    6502, 
    6866, 
    2795, 
    6564, 
    2983, 
    6645, 
    6498, 
    2794, 
    6559, 
    2913, 
    2979, 
    2917, 
    3070, 
    3311, 
    6648, 
    6555, 
    3066, 
    6649, 
    2971, 
    6556, 
    2982, 
    6644, 
    6563, 
    3067, 
    2972, 
    6236, 
    2643, 
    2479, 
    6079, 
    6080, 
    2480, 
    2483, 
    6083, 
    6084, 
    2484, 
    3621, 
    421, 
    422, 
    3622, 
    2910, 
    6495, 
    6496, 
    2911, 
    3619, 
    419, 
    420, 
    3620, 
    2636, 
    6229, 
    2637, 
    6230, 
    6139, 
    2547, 
    2914, 
    6499, 
    6500, 
    2915, 
    3064, 
    6140, 
    2548, 
    6143, 
    2551, 
    6144, 
    2552, 
    2368, 
    5968, 
    5969, 
    2369, 
    2640, 
    6233, 
    6234, 
    6642, 
    3065, 
    6643, 
    2792, 
    6378, 
    2641, 
    6379, 
    2477, 
    2793, 
    6077, 
    3068, 
    6078, 
    6646, 
    2478
  )

Query time 0.00144

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "31.59"
    },
    "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": 153,
      "rows_produced_per_join": 153,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "16.29",
        "eval_cost": "15.30",
        "prefix_cost": "31.59",
        "data_read_per_join": "4K"
      },
      "used_columns": [
        "product_id"
      ],
      "attached_condition": "(`gaseus`.`cscart_product_popularity`.`product_id` in (7448,7449,7450,7451,7452,7453,7454,7455,7456,7457,7458,7459,7460,7461,7462,7463,7484,7485,7486,7487,7488,7489,7490,7491,2969,2970,2912,6554,2981,6647,3069,6557,6561,2976,6558,2977,2980,6553,6562,2481,6081,6082,2482,2638,6231,2639,6232,6141,2549,6142,2550,6145,2553,6146,2554,2370,5970,5971,2371,2642,6235,6380,6497,2916,6381,6560,6501,2978,6502,6866,2795,6564,2983,6645,6498,2794,6559,2913,2979,2917,3070,3311,6648,6555,3066,6649,2971,6556,2982,6644,6563,3067,2972,6236,2643,2479,6079,6080,2480,2483,6083,6084,2484,3621,421,422,3622,2910,6495,6496,2911,3619,419,420,3620,2636,6229,2637,6230,6139,2547,2914,6499,6500,2915,3064,6140,2548,6143,2551,6144,2552,2368,5968,5969,2369,2640,6233,6234,6642,3065,6643,2792,6378,2641,6379,2477,2793,6077,3068,6078,6646,2478))"
    }
  }
}

Result

product_id
419
420
421
422
2368
2369
2370
2371
2477
2478
2479
2480
2481
2482
2483
2484
2547
2548
2549
2550
2551
2552
2553
2554
2636
2637
2638
2639
2640
2641
2642
2643
2792
2793
2794
2795
2910
2911
2912
2913
2914
2915
2916
2917
2969
2970
2971
2972
2976
2977
2978
2979
2980
2981
2982
2983
3064
3065
3066
3067
3068
3069
3070
3311
3619
3620
3621
3622
5968
5969
5970
5971
6077
6078
6079
6080
6081
6082
6083
6084
6139
6140
6141
6142
6143
6144
6145
6146
6229
6230
6231
6232
6233
6234
6235
6236
6378
6379
6380
6381
6495
6496
6497
6498
6499
6500
6501
6502
6553
6554
6555
6556
6557
6558
6559
6560
6561
6562
6563
6564
6642
6643
6644
6645
6646
6647
6648
6649
6866
7448
7449
7450
7451
7452
7453
7454
7455
7456
7457
7458
7459
7460
7461
7462
7463
7484
7485
7486
7487
7488
7489
7490
7491