SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (
    2905, 
    7530, 
    7531, 
    7532, 
    7533, 
    7534, 
    7535, 
    7536, 
    7537, 
    7538, 
    7539, 
    7540, 
    7541, 
    7542, 
    7543, 
    7544, 
    7545, 
    7546, 
    7547, 
    7548, 
    7549, 
    7550, 
    7551, 
    7552, 
    7553, 
    7554, 
    7555, 
    7556, 
    7557, 
    7558, 
    7559, 
    7560, 
    7561, 
    7562, 
    7563, 
    7564, 
    7565, 
    7566, 
    7567, 
    7568, 
    7569, 
    7570, 
    7571, 
    7572, 
    7573, 
    7574, 
    7575, 
    7576, 
    7577, 
    7578, 
    7579, 
    7580, 
    7581, 
    7582, 
    7583, 
    7586, 
    7587, 
    7588, 
    7589, 
    7590, 
    7591, 
    7592, 
    7593, 
    7594, 
    7595, 
    7596, 
    7597, 
    7598, 
    7599, 
    7600, 
    7618, 
    7617, 
    7616, 
    7615, 
    7614, 
    7613, 
    7612, 
    7611, 
    7610, 
    7609, 
    7608, 
    7607, 
    7606, 
    7605, 
    7604, 
    7603, 
    7602, 
    7601, 
    7619, 
    7620, 
    7621, 
    7624, 
    7625, 
    7626, 
    7627, 
    7628, 
    7629, 
    7630, 
    7631, 
    7632, 
    7633, 
    7634, 
    7635, 
    7636, 
    7637, 
    7638, 
    7639, 
    7640, 
    7641, 
    7642, 
    7643, 
    7644, 
    7645, 
    7646, 
    7647, 
    7648, 
    7649, 
    7650, 
    7651, 
    7652, 
    7653, 
    7654, 
    7655, 
    7656, 
    7657, 
    7658, 
    7659, 
    7662, 
    7663, 
    7664, 
    7665, 
    7666, 
    7667, 
    7668, 
    7669, 
    7670, 
    7671, 
    7672, 
    7673, 
    7674, 
    7675, 
    7676, 
    7677, 
    7678, 
    7679, 
    7680, 
    7681, 
    7682, 
    7683, 
    7684, 
    7685, 
    7686, 
    7687, 
    7688, 
    7689, 
    7690, 
    7691, 
    7692, 
    7693, 
    7694, 
    7695, 
    7696, 
    7697, 
    6485, 
    463, 
    2898, 
    3626, 
    6482, 
    6475, 
    2900, 
    2888, 
    2899, 
    6472, 
    2890, 
    4268, 
    6476, 
    462, 
    6484, 
    4267, 
    2897, 
    6481, 
    464, 
    6483, 
    6493, 
    2906, 
    6490, 
    6492, 
    2907, 
    6491, 
    4269, 
    6473, 
    461, 
    2891, 
    4266, 
    2909, 
    2908, 
    6494, 
    6640, 
    3060, 
    6637, 
    6639, 
    3061, 
    6638, 
    3063, 
    3062, 
    2967, 
    6549, 
    2363, 
    5961, 
    5962, 
    2791, 
    3513, 
    3518, 
    3515, 
    2964, 
    2966, 
    6550, 
    5898, 
    2296, 
    5895, 
    5897, 
    2297, 
    5896, 
    6130, 
    5899, 
    6133, 
    2538, 
    2299, 
    2298, 
    6058, 
    2458, 
    6060, 
    6059, 
    2541, 
    2540, 
    6134, 
    2630, 
    6132, 
    2539, 
    6131, 
    2461, 
    2471, 
    6068, 
    2468, 
    2470, 
    6069, 
    2469, 
    6071, 
    6070, 
    2472, 
    2360, 
    2633, 
    6225, 
    2635, 
    2634, 
    6228, 
    6064, 
    2462, 
    6061, 
    6063, 
    2463, 
    6062, 
    2465, 
    2464, 
    6065, 
    6075, 
    2473, 
    6072, 
    6074, 
    2474, 
    6073, 
    2476, 
    2475, 
    6076, 
    5964, 
    2365, 
    5965, 
    5963, 
    2364, 
    5966, 
    3852, 
    6377, 
    2790, 
    459, 
    4262, 
    456, 
    458, 
    4263, 
    457, 
    4265, 
    4264, 
    460, 
    2886, 
    6468, 
    2883, 
    2885, 
    6469, 
    2884, 
    6471, 
    6470, 
    2887, 
    2895, 
    6477, 
    2892, 
    2894, 
    6478, 
    2893, 
    6480, 
    6479, 
    2896, 
    2904, 
    6486, 
    2901, 
    2903, 
    6487, 
    2459, 
    2457, 
    6220, 
    2627, 
    2629, 
    6221, 
    2628, 
    6223, 
    6222, 
    2631, 
    2460, 
    6057, 
    3058, 
    6633, 
    3055, 
    3057, 
    6634, 
    2965, 
    6552, 
    6551, 
    2968, 
    3517, 
    3516, 
    2902, 
    6135, 
    5900, 
    2542, 
    2300, 
    2544, 
    2302, 
    6136, 
    5901, 
    2543, 
    3056, 
    6636, 
    6635, 
    3059, 
    6489, 
    6488, 
    6227, 
    2632, 
    6224, 
    6226, 
    2546, 
    5967, 
    5902, 
    2366, 
    2304, 
    2367, 
    2545, 
    2303, 
    2301, 
    6138, 
    5903, 
    6137, 
    5960, 
    2361, 
    2359, 
    5959, 
    2362, 
    6547, 
    2960, 
    6544, 
    6546, 
    2961, 
    6545, 
    2963, 
    2962, 
    6548, 
    2788, 
    6376, 
    2789, 
    6474, 
    2889, 
    2787, 
    6375, 
    3851, 
    3511, 
    3514, 
    3512
  )

Query time 0.00732

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "81.15"
    },
    "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": 395,
      "rows_produced_per_join": 395,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "41.65",
        "eval_cost": "39.50",
        "prefix_cost": "81.15",
        "data_read_per_join": "12K"
      },
      "used_columns": [
        "product_id"
      ],
      "attached_condition": "(`test2_gaseus`.`cscart_product_popularity`.`product_id` in (2905,7530,7531,7532,7533,7534,7535,7536,7537,7538,7539,7540,7541,7542,7543,7544,7545,7546,7547,7548,7549,7550,7551,7552,7553,7554,7555,7556,7557,7558,7559,7560,7561,7562,7563,7564,7565,7566,7567,7568,7569,7570,7571,7572,7573,7574,7575,7576,7577,7578,7579,7580,7581,7582,7583,7586,7587,7588,7589,7590,7591,7592,7593,7594,7595,7596,7597,7598,7599,7600,7618,7617,7616,7615,7614,7613,7612,7611,7610,7609,7608,7607,7606,7605,7604,7603,7602,7601,7619,7620,7621,7624,7625,7626,7627,7628,7629,7630,7631,7632,7633,7634,7635,7636,7637,7638,7639,7640,7641,7642,7643,7644,7645,7646,7647,7648,7649,7650,7651,7652,7653,7654,7655,7656,7657,7658,7659,7662,7663,7664,7665,7666,7667,7668,7669,7670,7671,7672,7673,7674,7675,7676,7677,7678,7679,7680,7681,7682,7683,7684,7685,7686,7687,7688,7689,7690,7691,7692,7693,7694,7695,7696,7697,6485,463,2898,3626,6482,6475,2900,2888,2899,6472,2890,4268,6476,462,6484,4267,2897,6481,464,6483,6493,2906,6490,6492,2907,6491,4269,6473,461,2891,4266,2909,2908,6494,6640,3060,6637,6639,3061,6638,3063,3062,2967,6549,2363,5961,5962,2791,3513,3518,3515,2964,2966,6550,5898,2296,5895,5897,2297,5896,6130,5899,6133,2538,2299,2298,6058,2458,6060,6059,2541,2540,6134,2630,6132,2539,6131,2461,2471,6068,2468,2470,6069,2469,6071,6070,2472,2360,2633,6225,2635,2634,6228,6064,2462,6061,6063,2463,6062,2465,2464,6065,6075,2473,6072,6074,2474,6073,2476,2475,6076,5964,2365,5965,5963,2364,5966,3852,6377,2790,459,4262,456,458,4263,457,4265,4264,460,2886,6468,2883,2885,6469,2884,6471,6470,2887,2895,6477,2892,2894,6478,2893,6480,6479,2896,2904,6486,2901,2903,6487,2459,2457,6220,2627,2629,6221,2628,6223,6222,2631,2460,6057,3058,6633,3055,3057,6634,2965,6552,6551,2968,3517,3516,2902,6135,5900,2542,2300,2544,2302,6136,5901,2543,3056,6636,6635,3059,6489,6488,6227,2632,6224,6226,2546,5967,5902,2366,2304,2367,2545,2303,2301,6138,5903,6137,5960,2361,2359,5959,2362,6547,2960,6544,6546,2961,6545,2963,2962,6548,2788,6376,2789,6474,2889,2787,6375,3851,3511,3514,3512))"
    }
  }
}

Result

product_id
456
457
458
459
460
461
462
463
464
2296
2297
2298
2299
2300
2301
2302
2303
2304
2359
2360
2361
2362
2363
2364
2365
2366
2367
2457
2458
2459
2460
2461
2462
2463
2464
2465
2468
2469
2470
2471
2472
2473
2474
2475
2476
2538
2539
2540
2541
2542
2543
2544
2545
2546
2627
2628
2629
2630
2631
2632
2633
2634
2635
2787
2788
2789
2790
2791
2883
2884
2885
2886
2887
2888
2889
2890
2891
2892
2893
2894
2895
2896
2897
2898
2899
2900
2901
2902
2903
2904
2905
2906
2907
2908
2909
2960
2961
2962
2963
2964
2965
2966
2967
2968
3055
3056
3057
3058
3059
3060
3061
3062
3063
3511
3512
3513
3514
3515
3516
3517
3518
3626
3851
3852
4262
4263
4264
4265
4266
4267
4268
4269
5895
5896
5897
5898
5899
5900
5901
5902
5903
5959
5960
5961
5962
5963
5964
5965
5966
5967
6057
6058
6059
6060
6061
6062
6063
6064
6065
6068
6069
6070
6071
6072
6073
6074
6075
6076
6130
6131
6132
6133
6134
6135
6136
6137
6138
6220
6221
6222
6223
6224
6225
6226
6227
6228
6375
6376
6377
6468
6469
6470
6471
6472
6473
6474
6475
6476
6477
6478
6479
6480
6481
6482
6483
6484
6485
6486
6487
6488
6489
6490
6491
6492
6493
6494
6544
6545
6546
6547
6548
6549
6550
6551
6552
6633
6634
6635
6636
6637
6638
6639
6640
7530
7531
7532
7533
7534
7535
7536
7537
7538
7539
7540
7541
7542
7543
7544
7545
7546
7547
7548
7549
7550
7551
7552
7553
7554
7555
7556
7557
7558
7559
7560
7561
7562
7563
7564
7565
7566
7567
7568
7569
7570
7571
7572
7573
7574
7575
7576
7577
7578
7579
7580
7581
7582
7583
7586
7587
7588
7589
7590
7591
7592
7593
7594
7595
7596
7597
7598
7599
7600
7601
7602
7603
7604
7605
7606
7607
7608
7609
7610
7611
7612
7613
7614
7615
7616
7617
7618
7619
7620
7621
7624
7625
7626
7627
7628
7629
7630
7631
7632
7633
7634
7635
7636
7637
7638
7639
7640
7641
7642
7643
7644
7645
7646
7647
7648
7649
7650
7651
7652
7653
7654
7655
7656
7657
7658
7659
7662
7663
7664
7665
7666
7667
7668
7669
7670
7671
7672
7673
7674
7675
7676
7677
7678
7679
7680
7681
7682
7683
7684
7685
7686
7687
7688
7689
7690
7691
7692
7693
7694
7695
7696
7697