SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (
    7279, 
    7280, 
    7281, 
    7282, 
    7283, 
    7284, 
    7285, 
    7286, 
    7287, 
    7288, 
    7289, 
    7290, 
    7291, 
    7292, 
    7293, 
    7294, 
    7295, 
    7296, 
    7297, 
    7298, 
    7299, 
    7300, 
    7301, 
    7302, 
    7303, 
    7304, 
    7305, 
    7306, 
    7307, 
    7308, 
    7309, 
    7310, 
    7311, 
    7312, 
    7313, 
    7314, 
    7315, 
    7316, 
    7317, 
    7318, 
    7319, 
    7320, 
    7321, 
    7322, 
    7323, 
    7324, 
    7325, 
    7326, 
    7344, 
    7343, 
    7342, 
    7341, 
    7340, 
    7339, 
    7338, 
    7337, 
    7336, 
    7335, 
    7334, 
    7333, 
    7332, 
    7331, 
    7330, 
    7329, 
    7328, 
    7327, 
    7358, 
    7356, 
    7354, 
    7352, 
    7346, 
    7345, 
    4408, 
    657, 
    658, 
    4409, 
    659, 
    4410, 
    4411, 
    660, 
    4412, 
    661, 
    4429, 
    678, 
    679, 
    4430, 
    680, 
    4431, 
    4432, 
    681, 
    4433, 
    682, 
    667, 
    668, 
    4419, 
    669, 
    4420, 
    4418, 
    4421, 
    4422, 
    670, 
    4423, 
    671, 
    688, 
    689, 
    4440, 
    690, 
    4441, 
    4439, 
    4442, 
    4443, 
    691, 
    4444, 
    692, 
    699, 
    700, 
    4451, 
    701, 
    4452, 
    4450, 
    4453, 
    4454, 
    702, 
    4455, 
    703, 
    4413, 
    662, 
    663, 
    4414, 
    664, 
    4415, 
    4416, 
    665, 
    4417, 
    666, 
    4434, 
    683, 
    684, 
    4435, 
    685, 
    4436, 
    4437, 
    686, 
    4438, 
    687, 
    4424, 
    4425, 
    673, 
    4426, 
    674, 
    672, 
    675, 
    676, 
    4427, 
    677, 
    4428, 
    4445, 
    4446, 
    694, 
    4447, 
    695, 
    693, 
    696, 
    697, 
    4448, 
    698, 
    4449, 
    4456, 
    4457, 
    705, 
    4458, 
    706, 
    704, 
    707, 
    708, 
    4459, 
    709, 
    4460, 
    1326, 
    5072, 
    5976, 
    2579, 
    6089, 
    2377, 
    6171, 
    2489, 
    5975, 
    2578, 
    6088, 
    2376, 
    2375, 
    6170, 
    2488, 
    2305, 
    2306, 
    5905, 
    2307, 
    5906, 
    5904, 
    5907, 
    5908, 
    2308, 
    5909, 
    2309, 
    3170, 
    6147, 
    2555, 
    2691, 
    6280, 
    2692, 
    3078, 
    3079, 
    6656, 
    3080, 
    6657, 
    6655, 
    6658, 
    6659, 
    3081, 
    6660, 
    3082, 
    6570, 
    2989, 
    2990, 
    6571, 
    2991, 
    6572, 
    6573, 
    2992, 
    6574, 
    2993, 
    6387, 
    6592, 
    433, 
    6389, 
    3011, 
    4239, 
    2804, 
    6591, 
    432, 
    6388, 
    3010, 
    4238, 
    2803, 
    3009, 
    4237, 
    2802, 
    6590, 
    431, 
    772, 
    773, 
    4524, 
    774, 
    4525, 
    4523, 
    4526, 
    4527, 
    775, 
    4528, 
    776, 
    4355, 
    4356, 
    603, 
    4357, 
    604, 
    602, 
    605, 
    606, 
    4358, 
    607, 
    4359, 
    4471, 
    720, 
    721, 
    4472, 
    722, 
    4473, 
    4474, 
    723, 
    4475, 
    724, 
    730, 
    731, 
    4482, 
    732, 
    4483, 
    4481, 
    4484, 
    4485, 
    2582, 
    2380, 
    733, 
    4486, 
    734, 
    761, 
    762, 
    4513, 
    763, 
    4514, 
    4512, 
    4515, 
    4516, 
    764, 
    4517, 
    765, 
    4461, 
    710, 
    6173, 
    2491, 
    5978, 
    2581, 
    6091, 
    2379, 
    2580, 
    6090, 
    2378, 
    6172, 
    2490, 
    6386, 
    3008, 
    4236, 
    2801, 
    6589, 
    430, 
    6385, 
    3007, 
    4235, 
    2800, 
    429, 
    2799, 
    6588, 
    4242, 
    4243, 
    437, 
    4244, 
    438, 
    436, 
    439, 
    440, 
    4245, 
    441, 
    4246, 
    6819, 
    6259, 
    6260, 
    2672, 
    6261, 
    2673, 
    2671, 
    2674, 
    2675, 
    6262, 
    2676, 
    6263, 
    6270, 
    6271, 
    2683, 
    6272, 
    2684, 
    2682, 
    2685, 
    2686, 
    5844, 
    5842, 
    5843, 
    2232, 
    2233, 
    5833, 
    5834, 
    2241, 
    5832, 
    5979, 
    2245, 
    5977, 
    6174, 
    2492, 
    6092, 
    3836, 
    2242, 
    2243, 
    2230, 
    2234, 
    2235, 
    5841, 
    2244, 
    3835, 
    711, 
    4462, 
    712, 
    4463, 
    4464, 
    713, 
    4465, 
    6279, 
    6273, 
    2687, 
    6274, 
    3277, 
    6825, 
    6822, 
    6650, 
    6651, 
    3073, 
    6652, 
    3074, 
    3072, 
    3075, 
    3076, 
    6653, 
    3077, 
    6654, 
    3293, 
    6565, 
    2984, 
    2985, 
    6566, 
    2986, 
    6567, 
    6568, 
    2987, 
    6569, 
    2988, 
    3287, 
    6834, 
    2796, 
    6587, 
    428, 
    2798, 
    3006, 
    4234, 
    6384, 
    6586, 
    427, 
    2797, 
    3005, 
    4233, 
    6383, 
    3004, 
    4232, 
    6382, 
    6585, 
    426, 
    2806, 
    3013, 
    4241, 
    6392, 
    6594, 
    435, 
    2805, 
    3012, 
    4240, 
    6391, 
    434, 
    6390, 
    6593, 
    442, 
    443, 
    4248, 
    444, 
    4249, 
    4247, 
    4250, 
    4251, 
    445, 
    4252, 
    446, 
    2677, 
    2678, 
    6265, 
    2679, 
    6266, 
    6264, 
    6267, 
    6268, 
    2680, 
    6269, 
    2681, 
    2688, 
    2689, 
    6276, 
    2690, 
    6277, 
    6275, 
    6278, 
    5974, 
    6168, 
    2486, 
    2373, 
    2576, 
    6086, 
    5973, 
    2575, 
    6085, 
    5972, 
    6167, 
    2485, 
    2382, 
    2584, 
    6094, 
    5982, 
    6176, 
    2494, 
    2381, 
    2583, 
    6093, 
    5981, 
    5980, 
    6175, 
    2493, 
    5910, 
    5911, 
    2311, 
    5912, 
    2312, 
    2310, 
    2313, 
    2314, 
    5913, 
    2315, 
    5914, 
    6152, 
    2560, 
    2561, 
    6153, 
    2562, 
    6154, 
    6155, 
    2563, 
    6156, 
    2564, 
    2650, 
    2651, 
    6243, 
    2652, 
    6244, 
    6242, 
    6245, 
    6246, 
    2653, 
    6247, 
    2654, 
    5830, 
    5831, 
    2231, 
    6087, 
    6750, 
    3179, 
    2372, 
    6169, 
    2487, 
    2374, 
    2577, 
    5837, 
    5835, 
    5838, 
    5839, 
    2240, 
    6768, 
    2239, 
    5840, 
    5836, 
    2236, 
    2238, 
    2237, 
    2556, 
    6148, 
    2557, 
    6149, 
    6150, 
    2558, 
    6151, 
    2559, 
    6764, 
    3189, 
    6761, 
    3173, 
    6237, 
    6238, 
    2645, 
    6239, 
    2646, 
    2644, 
    2647, 
    2648, 
    6240, 
    2649, 
    6241, 
    2225, 
    2226, 
    5825, 
    2227, 
    5826, 
    5824, 
    5827, 
    5828, 
    2228, 
    5829, 
    2229, 
    714, 
    4502, 
    751, 
    752, 
    4503, 
    753, 
    4504, 
    4505, 
    754, 
    4506, 
    755, 
    4492, 
    741, 
    742, 
    4493, 
    743, 
    4494, 
    4495, 
    744, 
    4496, 
    745, 
    6850, 
    4529, 
    4530, 
    778, 
    4531, 
    779, 
    777, 
    780, 
    781, 
    4532, 
    782, 
    4533, 
    608, 
    609, 
    4361, 
    610, 
    4362, 
    4360, 
    4363, 
    611, 
    3679, 
    612, 
    3680, 
    6859, 
    4476, 
    725, 
    726, 
    4477, 
    727, 
    4478, 
    4479, 
    728, 
    4480, 
    729, 
    4487, 
    4488, 
    736, 
    4489, 
    737, 
    735, 
    738, 
    739, 
    4490, 
    740, 
    4491, 
    3316, 
    4518, 
    768, 
    769, 
    766, 
    4520, 
    767, 
    4519, 
    4521, 
    770, 
    771, 
    4522, 
    4466, 
    715, 
    716, 
    4467, 
    717, 
    4468, 
    4469, 
    718, 
    4470, 
    719, 
    4507, 
    756, 
    757, 
    4508, 
    758, 
    4509, 
    4510, 
    759, 
    4511, 
    760, 
    4497, 
    746, 
    747, 
    4498, 
    748, 
    4499, 
    4500, 
    749, 
    4501, 
    750, 
    1330
  )

Query time 0.00457

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "145.05"
    },
    "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": 707,
      "rows_produced_per_join": 707,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "74.35",
        "eval_cost": "70.70",
        "prefix_cost": "145.05",
        "data_read_per_join": "22K"
      },
      "used_columns": [
        "product_id"
      ],
      "attached_condition": "(`gaseus`.`cscart_product_popularity`.`product_id` in (7279,7280,7281,7282,7283,7284,7285,7286,7287,7288,7289,7290,7291,7292,7293,7294,7295,7296,7297,7298,7299,7300,7301,7302,7303,7304,7305,7306,7307,7308,7309,7310,7311,7312,7313,7314,7315,7316,7317,7318,7319,7320,7321,7322,7323,7324,7325,7326,7344,7343,7342,7341,7340,7339,7338,7337,7336,7335,7334,7333,7332,7331,7330,7329,7328,7327,7358,7356,7354,7352,7346,7345,4408,657,658,4409,659,4410,4411,660,4412,661,4429,678,679,4430,680,4431,4432,681,4433,682,667,668,4419,669,4420,4418,4421,4422,670,4423,671,688,689,4440,690,4441,4439,4442,4443,691,4444,692,699,700,4451,701,4452,4450,4453,4454,702,4455,703,4413,662,663,4414,664,4415,4416,665,4417,666,4434,683,684,4435,685,4436,4437,686,4438,687,4424,4425,673,4426,674,672,675,676,4427,677,4428,4445,4446,694,4447,695,693,696,697,4448,698,4449,4456,4457,705,4458,706,704,707,708,4459,709,4460,1326,5072,5976,2579,6089,2377,6171,2489,5975,2578,6088,2376,2375,6170,2488,2305,2306,5905,2307,5906,5904,5907,5908,2308,5909,2309,3170,6147,2555,2691,6280,2692,3078,3079,6656,3080,6657,6655,6658,6659,3081,6660,3082,6570,2989,2990,6571,2991,6572,6573,2992,6574,2993,6387,6592,433,6389,3011,4239,2804,6591,432,6388,3010,4238,2803,3009,4237,2802,6590,431,772,773,4524,774,4525,4523,4526,4527,775,4528,776,4355,4356,603,4357,604,602,605,606,4358,607,4359,4471,720,721,4472,722,4473,4474,723,4475,724,730,731,4482,732,4483,4481,4484,4485,2582,2380,733,4486,734,761,762,4513,763,4514,4512,4515,4516,764,4517,765,4461,710,6173,2491,5978,2581,6091,2379,2580,6090,2378,6172,2490,6386,3008,4236,2801,6589,430,6385,3007,4235,2800,429,2799,6588,4242,4243,437,4244,438,436,439,440,4245,441,4246,6819,6259,6260,2672,6261,2673,2671,2674,2675,6262,2676,6263,6270,6271,2683,6272,2684,2682,2685,2686,5844,5842,5843,2232,2233,5833,5834,2241,5832,5979,2245,5977,6174,2492,6092,3836,2242,2243,2230,2234,2235,5841,2244,3835,711,4462,712,4463,4464,713,4465,6279,6273,2687,6274,3277,6825,6822,6650,6651,3073,6652,3074,3072,3075,3076,6653,3077,6654,3293,6565,2984,2985,6566,2986,6567,6568,2987,6569,2988,3287,6834,2796,6587,428,2798,3006,4234,6384,6586,427,2797,3005,4233,6383,3004,4232,6382,6585,426,2806,3013,4241,6392,6594,435,2805,3012,4240,6391,434,6390,6593,442,443,4248,444,4249,4247,4250,4251,445,4252,446,2677,2678,6265,2679,6266,6264,6267,6268,2680,6269,2681,2688,2689,6276,2690,6277,6275,6278,5974,6168,2486,2373,2576,6086,5973,2575,6085,5972,6167,2485,2382,2584,6094,5982,6176,2494,2381,2583,6093,5981,5980,6175,2493,5910,5911,2311,5912,2312,2310,2313,2314,5913,2315,5914,6152,2560,2561,6153,2562,6154,6155,2563,6156,2564,2650,2651,6243,2652,6244,6242,6245,6246,2653,6247,2654,5830,5831,2231,6087,6750,3179,2372,6169,2487,2374,2577,5837,5835,5838,5839,2240,6768,2239,5840,5836,2236,2238,2237,2556,6148,2557,6149,6150,2558,6151,2559,6764,3189,6761,3173,6237,6238,2645,6239,2646,2644,2647,2648,6240,2649,6241,2225,2226,5825,2227,5826,5824,5827,5828,2228,5829,2229,714,4502,751,752,4503,753,4504,4505,754,4506,755,4492,741,742,4493,743,4494,4495,744,4496,745,6850,4529,4530,778,4531,779,777,780,781,4532,782,4533,608,609,4361,610,4362,4360,4363,611,3679,612,3680,6859,4476,725,726,4477,727,4478,4479,728,4480,729,4487,4488,736,4489,737,735,738,739,4490,740,4491,3316,4518,768,769,766,4520,767,4519,4521,770,771,4522,4466,715,716,4467,717,4468,4469,718,4470,719,4507,756,757,4508,758,4509,4510,759,4511,760,4497,746,747,4498,748,4499,4500,749,4501,750,1330))"
    }
  }
}

Result

product_id
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
602
603
604
605
606
607
608
609
610
611
612
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
1326
1330
2225
2226
2227
2228
2229
2230
2231
2232
2233
2234
2235
2236
2237
2238
2239
2240
2241
2242
2243
2244
2245
2305
2306
2307
2308
2309
2310
2311
2312
2313
2314
2315
2372
2373
2374
2375
2376
2377
2378
2379
2380
2381
2382
2485
2486
2487
2488
2489
2490
2491
2492
2493
2494
2555
2556
2557
2558
2559
2560
2561
2562
2563
2564
2575
2576
2577
2578
2579
2580
2581
2582
2583
2584
2644
2645
2646
2647
2648
2649
2650
2651
2652
2653
2654
2671
2672
2673
2674
2675
2676
2677
2678
2679
2680
2681
2682
2683
2684
2685
2686
2687
2688
2689
2690
2691
2692
2796
2797
2798
2799
2800
2801
2802
2803
2804
2805
2806
2984
2985
2986
2987
2988
2989
2990
2991
2992
2993
3004
3005
3006
3007
3008
3009
3010
3011
3012
3013
3072
3073
3074
3075
3076
3077
3078
3079
3080
3081
3082
3170
3173
3179
3189
3277
3287
3293
3316
3679
3680
3835
3836
4232
4233
4234
4235
4236
4237
4238
4239
4240
4241
4242
4243
4244
4245
4246
4247
4248
4249
4250
4251
4252
4355
4356
4357
4358
4359
4360
4361
4362
4363
4408
4409
4410
4411
4412
4413
4414
4415
4416
4417
4418
4419
4420
4421
4422
4423
4424
4425
4426
4427
4428
4429
4430
4431
4432
4433
4434
4435
4436
4437
4438
4439
4440
4441
4442
4443
4444
4445
4446
4447
4448
4449
4450
4451
4452
4453
4454
4455
4456
4457
4458
4459
4460
4461
4462
4463
4464
4465
4466
4467
4468
4469
4470
4471
4472
4473
4474
4475
4476
4477
4478
4479
4480
4481
4482
4483
4484
4485
4486
4487
4488
4489
4490
4491
4492
4493
4494
4495
4496
4497
4498
4499
4500
4501
4502
4503
4504
4505
4506
4507
4508
4509
4510
4511
4512
4513
4514
4515
4516
4517
4518
4519
4520
4521
4522
4523
4524
4525
4526
4527
4528
4529
4530
4531
4532
4533
5072
5824
5825
5826
5827
5828
5829
5830
5831
5832
5833
5834
5835
5836
5837
5838
5839
5840
5841
5842
5843
5844
5904
5905
5906
5907
5908
5909
5910
5911
5912
5913
5914
5972
5973
5974
5975
5976
5977
5978
5979
5980
5981
5982
6085
6086
6087
6088
6089
6090
6091
6092
6093
6094
6147
6148
6149
6150
6151
6152
6153
6154
6155
6156
6167
6168
6169
6170
6171
6172
6173
6174
6175
6176
6237
6238
6239
6240
6241
6242
6243
6244
6245
6246
6247
6259
6260
6261
6262
6263
6264
6265
6266
6267
6268
6269
6270
6271
6272
6273
6274
6275
6276
6277
6278
6279
6280
6382
6383
6384
6385
6386
6387
6388
6389
6390
6391
6392
6565
6566
6567
6568
6569
6570
6571
6572
6573
6574
6585
6586
6587
6588
6589
6590
6591
6592
6593
6594
6650
6651
6652
6653
6654
6655
6656
6657
6658
6659
6660
6750
6761
6764
6768
6819
6822
6825
6834
6850
6859
7279
7280
7281
7282
7283
7284
7285
7286
7287
7288
7289
7290
7291
7292
7293
7294
7295
7296
7297
7298
7299
7300
7301
7302
7303
7304
7305
7306
7307
7308
7309
7310
7311
7312
7313
7314
7315
7316
7317
7318
7319
7320
7321
7322
7323
7324
7325
7326
7327
7328
7329
7330
7331
7332
7333
7334
7335
7336
7337
7338
7339
7340
7341
7342
7343
7344
7345
7346
7352
7354
7356
7358