SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (
    7360, 
    7361, 
    7362, 
    7363, 
    7364, 
    7365, 
    7366, 
    7367, 
    7368, 
    7369, 
    7370, 
    7371, 
    7372, 
    7373, 
    7374, 
    7375, 
    7376, 
    7377, 
    7378, 
    7379, 
    7380, 
    7381, 
    7382, 
    7383, 
    7384, 
    7385, 
    7407, 
    7406, 
    7405, 
    7404, 
    7403, 
    7402, 
    7401, 
    7400, 
    7399, 
    7398, 
    7397, 
    7396, 
    7395, 
    7394, 
    7393, 
    7392, 
    7391, 
    7390, 
    7389, 
    7388, 
    7387, 
    7386, 
    7429, 
    7428, 
    7427, 
    7426, 
    7425, 
    7424, 
    7423, 
    7422, 
    7421, 
    7420, 
    7419, 
    7418, 
    7417, 
    7416, 
    7415, 
    7414, 
    7413, 
    7412, 
    7411, 
    7410, 
    7409, 
    7408, 
    7430, 
    7431, 
    7432, 
    7433, 
    7434, 
    7435, 
    620, 
    618, 
    621, 
    622, 
    4373, 
    623, 
    4374, 
    4975, 
    4976, 
    1230, 
    4977, 
    1231, 
    4669, 
    4613, 
    862, 
    863, 
    4614, 
    864, 
    4615, 
    4616, 
    865, 
    4617, 
    866, 
    4654, 
    903, 
    904, 
    4655, 
    905, 
    4656, 
    4657, 
    906, 
    4658, 
    907, 
    4644, 
    893, 
    894, 
    4645, 
    895, 
    4646, 
    4647, 
    896, 
    4648, 
    897, 
    918, 
    4668, 
    916, 
    917, 
    913, 
    891, 
    939, 
    633, 
    4625, 
    882, 
    4384, 
    4626, 
    885, 
    4562, 
    811, 
    4561, 
    810, 
    809, 
    4560, 
    823, 
    4574, 
    822, 
    4573, 
    1229, 
    1232, 
    1233, 
    4978, 
    1234, 
    4979, 
    1155, 
    4902, 
    4903, 
    1156, 
    4904, 
    1157, 
    1158, 
    4905, 
    1159, 
    4906, 
    1186, 
    4932, 
    4933, 
    1187, 
    4934, 
    1188, 
    1189, 
    4935, 
    1190, 
    4936, 
    1176, 
    4922, 
    4923, 
    1177, 
    4924, 
    1178, 
    1179, 
    4925, 
    1180, 
    4926, 
    1165, 
    4911, 
    4912, 
    1166, 
    4913, 
    1167, 
    1168, 
    4915, 
    4914, 
    1170, 
    1169, 
    4942, 
    4943, 
    1197, 
    4944, 
    1198, 
    1196, 
    1199, 
    1200, 
    4945, 
    1201, 
    4946, 
    4953, 
    4954, 
    1208, 
    4955, 
    1209, 
    1207, 
    1210, 
    1211, 
    4956, 
    1212, 
    4957, 
    4964, 
    4965, 
    1219, 
    4966, 
    1220, 
    1218, 
    1221, 
    1222, 
    4967, 
    1223, 
    4968, 
    1235, 
    1236, 
    4961, 
    4962, 
    1216, 
    4963, 
    1217, 
    1224, 
    1225, 
    4970, 
    1226, 
    4971, 
    4969, 
    4972, 
    4973, 
    1227, 
    4974, 
    1228, 
    5060, 
    5061, 
    1315, 
    5062, 
    1316, 
    1314, 
    1317, 
    1318, 
    5063, 
    1319, 
    5064, 
    5038, 
    5039, 
    1293, 
    5040, 
    1294, 
    1292, 
    1295, 
    1296, 
    5041, 
    1297, 
    5042, 
    5049, 
    5050, 
    1304, 
    5051, 
    1305, 
    1303, 
    1306, 
    1307, 
    5052, 
    1308, 
    4981, 
    1237, 
    4982, 
    4980, 
    4983, 
    4984, 
    1238, 
    4985, 
    1239, 
    1160, 
    4907, 
    4908, 
    1161, 
    4909, 
    1162, 
    1163, 
    4910, 
    1164, 
    3686, 
    1191, 
    4937, 
    4938, 
    1192, 
    4939, 
    1193, 
    1194, 
    4940, 
    1195, 
    4941, 
    1181, 
    4927, 
    4928, 
    1182, 
    4929, 
    1183, 
    1184, 
    4930, 
    1185, 
    4931, 
    4916, 
    833, 
    834, 
    842, 
    843, 
    4595, 
    831, 
    4592, 
    832, 
    4371, 
    619, 
    4582, 
    830, 
    4583, 
    4596, 
    4594, 
    4370, 
    4584, 
    4585, 
    840, 
    844, 
    845, 
    829, 
    841, 
    4372, 
    4593, 
    7436, 
    4368, 
    855, 
    4538, 
    616, 
    4606, 
    787, 
    7446, 
    846, 
    4369, 
    856, 
    4565, 
    1171, 
    4919, 
    1175, 
    1174, 
    4921, 
    4920, 
    1202, 
    1203, 
    4948, 
    1204, 
    4949, 
    4947, 
    4950, 
    4951, 
    4635, 
    3312, 
    876, 
    887, 
    936, 
    925, 
    4623, 
    4634, 
    630, 
    872, 
    4383, 
    4689, 
    4678, 
    4665, 
    873, 
    883, 
    631, 
    937, 
    926, 
    4666, 
    4643, 
    4690, 
    4679, 
    634, 
    875, 
    886, 
    892, 
    940, 
    929, 
    928, 
    4687, 
    4676, 
    4680, 
    4381, 
    4385, 
    4627, 
    4637, 
    4688, 
    4677, 
    4382, 
    5053, 
    1240, 
    4986, 
    4987, 
    1241, 
    4988, 
    1242, 
    1243, 
    4989, 
    1244, 
    4990, 
    4996, 
    4997, 
    1251, 
    4998, 
    1252, 
    1250, 
    1253, 
    1254, 
    4999, 
    1255, 
    5000, 
    5027, 
    5028, 
    1282, 
    5029, 
    1283, 
    1281, 
    1284, 
    1285, 
    5030, 
    1286, 
    5031, 
    1271, 
    5017, 
    5018, 
    1272, 
    5019, 
    1273, 
    1274, 
    5020, 
    1275, 
    5021, 
    1261, 
    5007, 
    5008, 
    1262, 
    5009, 
    1263, 
    1264, 
    5010, 
    1265, 
    5011, 
    1320, 
    1321, 
    5066, 
    1322, 
    5067, 
    5065, 
    5068, 
    5069, 
    1323, 
    5070, 
    1324, 
    1298, 
    1299, 
    5044, 
    1300, 
    5045, 
    5043, 
    5046, 
    5047, 
    1301, 
    5048, 
    1213, 
    1214, 
    4959, 
    1205, 
    1215, 
    4960, 
    4952, 
    4958, 
    1206, 
    4591, 
    4543, 
    4555, 
    792, 
    839, 
    804, 
    835, 
    4550, 
    783, 
    797, 
    828, 
    813, 
    4570, 
    614, 
    4556, 
    784, 
    824, 
    613, 
    805, 
    836, 
    4638, 
    935, 
    924, 
    914, 
    4667, 
    4624, 
    4636, 
    629, 
    938, 
    927, 
    915, 
    874, 
    884, 
    632, 
    901, 
    4653, 
    889, 
    4640, 
    902, 
    890, 
    4639, 
    4641, 
    4642, 
    888, 
    858, 
    4609, 
    859, 
    4610, 
    4611, 
    860, 
    4612, 
    861, 
    4649, 
    898, 
    899, 
    4650, 
    900, 
    4651, 
    4652, 
    1302, 
    1309, 
    1310, 
    5055, 
    1311, 
    5056, 
    5054, 
    5057, 
    5058, 
    1312, 
    5059, 
    1313, 
    1245, 
    4991, 
    4992, 
    1246, 
    4993, 
    1247, 
    1248, 
    4994, 
    1249, 
    4995, 
    1256, 
    1257, 
    5002, 
    1258, 
    5003, 
    5001, 
    5004, 
    5005, 
    1259, 
    5006, 
    1260, 
    1287, 
    1288, 
    5033, 
    1289, 
    5034, 
    5032, 
    5035, 
    5036, 
    1290, 
    5037, 
    1291, 
    1276, 
    5022, 
    5023, 
    1277, 
    5024, 
    1278, 
    1279, 
    5025, 
    1280, 
    5026, 
    1266, 
    5012, 
    5013, 
    1267, 
    5014, 
    1268, 
    1269, 
    5015, 
    1270, 
    5016, 
    930, 
    931, 
    4682, 
    932, 
    4683, 
    4681, 
    4684, 
    4685, 
    933, 
    4686, 
    934, 
    919, 
    920, 
    4671, 
    921, 
    4672, 
    4670, 
    4673, 
    4674, 
    922, 
    4675, 
    923, 
    624, 
    625, 
    4376, 
    626, 
    4377, 
    4375, 
    4378, 
    4379, 
    627, 
    4380, 
    628, 
    4618, 
    867, 
    868, 
    4619, 
    869, 
    4620, 
    4621, 
    870, 
    4622, 
    871, 
    877, 
    878, 
    4629, 
    879, 
    4630, 
    4628, 
    4631, 
    4632, 
    880, 
    4633, 
    881, 
    908, 
    909, 
    4660, 
    910, 
    4661, 
    4659, 
    4662, 
    4663, 
    911, 
    4664, 
    912, 
    4608, 
    857, 
    4569, 
    4548, 
    4579, 
    4602, 
    4563, 
    796, 
    827, 
    850, 
    812, 
    4568, 
    7438, 
    849, 
    854, 
    4541, 
    817, 
    7437, 
    4590, 
    4542, 
    4597, 
    7439, 
    4540, 
    4567, 
    4605, 
    4600, 
    4604, 
    4601, 
    853, 
    851, 
    790, 
    4539, 
    815, 
    4603, 
    4599, 
    7441, 
    788, 
    4566, 
    7440, 
    789, 
    816, 
    852, 
    7445, 
    847, 
    7447, 
    4598, 
    7444, 
    7443, 
    4607, 
    814, 
    617, 
    848, 
    7442, 
    838, 
    791, 
    818, 
    4549, 
    4580, 
    4534, 
    4564, 
    819, 
    4551, 
    4365, 
    4535, 
    806, 
    615, 
    785, 
    4557, 
    4576, 
    4587, 
    820, 
    799, 
    4366, 
    4536, 
    4558, 
    826, 
    837, 
    4571, 
    4552, 
    825, 
    821, 
    4577, 
    4588, 
    800, 
    4367, 
    4547, 
    4575, 
    4537, 
    4364, 
    807, 
    4572, 
    4578, 
    4589, 
    808, 
    786, 
    4586, 
    4559, 
    4581, 
    793, 
    798, 
    794, 
    4545, 
    801, 
    795, 
    802, 
    4553, 
    803, 
    4546, 
    4554, 
    4544
  )

Query time 0.00280

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "160.82"
    },
    "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": 784,
      "rows_produced_per_join": 784,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "82.42",
        "eval_cost": "78.40",
        "prefix_cost": "160.82",
        "data_read_per_join": "24K"
      },
      "used_columns": [
        "product_id"
      ],
      "attached_condition": "(`gaseus`.`cscart_product_popularity`.`product_id` in (7360,7361,7362,7363,7364,7365,7366,7367,7368,7369,7370,7371,7372,7373,7374,7375,7376,7377,7378,7379,7380,7381,7382,7383,7384,7385,7407,7406,7405,7404,7403,7402,7401,7400,7399,7398,7397,7396,7395,7394,7393,7392,7391,7390,7389,7388,7387,7386,7429,7428,7427,7426,7425,7424,7423,7422,7421,7420,7419,7418,7417,7416,7415,7414,7413,7412,7411,7410,7409,7408,7430,7431,7432,7433,7434,7435,620,618,621,622,4373,623,4374,4975,4976,1230,4977,1231,4669,4613,862,863,4614,864,4615,4616,865,4617,866,4654,903,904,4655,905,4656,4657,906,4658,907,4644,893,894,4645,895,4646,4647,896,4648,897,918,4668,916,917,913,891,939,633,4625,882,4384,4626,885,4562,811,4561,810,809,4560,823,4574,822,4573,1229,1232,1233,4978,1234,4979,1155,4902,4903,1156,4904,1157,1158,4905,1159,4906,1186,4932,4933,1187,4934,1188,1189,4935,1190,4936,1176,4922,4923,1177,4924,1178,1179,4925,1180,4926,1165,4911,4912,1166,4913,1167,1168,4915,4914,1170,1169,4942,4943,1197,4944,1198,1196,1199,1200,4945,1201,4946,4953,4954,1208,4955,1209,1207,1210,1211,4956,1212,4957,4964,4965,1219,4966,1220,1218,1221,1222,4967,1223,4968,1235,1236,4961,4962,1216,4963,1217,1224,1225,4970,1226,4971,4969,4972,4973,1227,4974,1228,5060,5061,1315,5062,1316,1314,1317,1318,5063,1319,5064,5038,5039,1293,5040,1294,1292,1295,1296,5041,1297,5042,5049,5050,1304,5051,1305,1303,1306,1307,5052,1308,4981,1237,4982,4980,4983,4984,1238,4985,1239,1160,4907,4908,1161,4909,1162,1163,4910,1164,3686,1191,4937,4938,1192,4939,1193,1194,4940,1195,4941,1181,4927,4928,1182,4929,1183,1184,4930,1185,4931,4916,833,834,842,843,4595,831,4592,832,4371,619,4582,830,4583,4596,4594,4370,4584,4585,840,844,845,829,841,4372,4593,7436,4368,855,4538,616,4606,787,7446,846,4369,856,4565,1171,4919,1175,1174,4921,4920,1202,1203,4948,1204,4949,4947,4950,4951,4635,3312,876,887,936,925,4623,4634,630,872,4383,4689,4678,4665,873,883,631,937,926,4666,4643,4690,4679,634,875,886,892,940,929,928,4687,4676,4680,4381,4385,4627,4637,4688,4677,4382,5053,1240,4986,4987,1241,4988,1242,1243,4989,1244,4990,4996,4997,1251,4998,1252,1250,1253,1254,4999,1255,5000,5027,5028,1282,5029,1283,1281,1284,1285,5030,1286,5031,1271,5017,5018,1272,5019,1273,1274,5020,1275,5021,1261,5007,5008,1262,5009,1263,1264,5010,1265,5011,1320,1321,5066,1322,5067,5065,5068,5069,1323,5070,1324,1298,1299,5044,1300,5045,5043,5046,5047,1301,5048,1213,1214,4959,1205,1215,4960,4952,4958,1206,4591,4543,4555,792,839,804,835,4550,783,797,828,813,4570,614,4556,784,824,613,805,836,4638,935,924,914,4667,4624,4636,629,938,927,915,874,884,632,901,4653,889,4640,902,890,4639,4641,4642,888,858,4609,859,4610,4611,860,4612,861,4649,898,899,4650,900,4651,4652,1302,1309,1310,5055,1311,5056,5054,5057,5058,1312,5059,1313,1245,4991,4992,1246,4993,1247,1248,4994,1249,4995,1256,1257,5002,1258,5003,5001,5004,5005,1259,5006,1260,1287,1288,5033,1289,5034,5032,5035,5036,1290,5037,1291,1276,5022,5023,1277,5024,1278,1279,5025,1280,5026,1266,5012,5013,1267,5014,1268,1269,5015,1270,5016,930,931,4682,932,4683,4681,4684,4685,933,4686,934,919,920,4671,921,4672,4670,4673,4674,922,4675,923,624,625,4376,626,4377,4375,4378,4379,627,4380,628,4618,867,868,4619,869,4620,4621,870,4622,871,877,878,4629,879,4630,4628,4631,4632,880,4633,881,908,909,4660,910,4661,4659,4662,4663,911,4664,912,4608,857,4569,4548,4579,4602,4563,796,827,850,812,4568,7438,849,854,4541,817,7437,4590,4542,4597,7439,4540,4567,4605,4600,4604,4601,853,851,790,4539,815,4603,4599,7441,788,4566,7440,789,816,852,7445,847,7447,4598,7444,7443,4607,814,617,848,7442,838,791,818,4549,4580,4534,4564,819,4551,4365,4535,806,615,785,4557,4576,4587,820,799,4366,4536,4558,826,837,4571,4552,825,821,4577,4588,800,4367,4547,4575,4537,4364,807,4572,4578,4589,808,786,4586,4559,4581,793,798,794,4545,801,795,802,4553,803,4546,4554,4544))"
    }
  }
}

Result

product_id
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
1321
1322
1323
1324
3312
3686
4364
4365
4366
4367
4368
4369
4370
4371
4372
4373
4374
4375
4376
4377
4378
4379
4380
4381
4382
4383
4384
4385
4534
4535
4536
4537
4538
4539
4540
4541
4542
4543
4544
4545
4546
4547
4548
4549
4550
4551
4552
4553
4554
4555
4556
4557
4558
4559
4560
4561
4562
4563
4564
4565
4566
4567
4568
4569
4570
4571
4572
4573
4574
4575
4576
4577
4578
4579
4580
4581
4582
4583
4584
4585
4586
4587
4588
4589
4590
4591
4592
4593
4594
4595
4596
4597
4598
4599
4600
4601
4602
4603
4604
4605
4606
4607
4608
4609
4610
4611
4612
4613
4614
4615
4616
4617
4618
4619
4620
4621
4622
4623
4624
4625
4626
4627
4628
4629
4630
4631
4632
4633
4634
4635
4636
4637
4638
4639
4640
4641
4642
4643
4644
4645
4646
4647
4648
4649
4650
4651
4652
4653
4654
4655
4656
4657
4658
4659
4660
4661
4662
4663
4664
4665
4666
4667
4668
4669
4670
4671
4672
4673
4674
4675
4676
4677
4678
4679
4680
4681
4682
4683
4684
4685
4686
4687
4688
4689
4690
4902
4903
4904
4905
4906
4907
4908
4909
4910
4911
4912
4913
4914
4915
4916
4919
4920
4921
4922
4923
4924
4925
4926
4927
4928
4929
4930
4931
4932
4933
4934
4935
4936
4937
4938
4939
4940
4941
4942
4943
4944
4945
4946
4947
4948
4949
4950
4951
4952
4953
4954
4955
4956
4957
4958
4959
4960
4961
4962
4963
4964
4965
4966
4967
4968
4969
4970
4971
4972
4973
4974
4975
4976
4977
4978
4979
4980
4981
4982
4983
4984
4985
4986
4987
4988
4989
4990
4991
4992
4993
4994
4995
4996
4997
4998
4999
5000
5001
5002
5003
5004
5005
5006
5007
5008
5009
5010
5011
5012
5013
5014
5015
5016
5017
5018
5019
5020
5021
5022
5023
5024
5025
5026
5027
5028
5029
5030
5031
5032
5033
5034
5035
5036
5037
5038
5039
5040
5041
5042
5043
5044
5045
5046
5047
5048
5049
5050
5051
5052
5053
5054
5055
5056
5057
5058
5059
5060
5061
5062
5063
5064
5065
5066
5067
5068
5069
5070
7360
7361
7362
7363
7364
7365
7366
7367
7368
7369
7370
7371
7372
7373
7374
7375
7376
7377
7378
7379
7380
7381
7382
7383
7384
7385
7386
7387
7388
7389
7390
7391
7392
7393
7394
7395
7396
7397
7398
7399
7400
7401
7402
7403
7404
7405
7406
7407
7408
7409
7410
7411
7412
7413
7414
7415
7416
7417
7418
7419
7420
7421
7422
7423
7424
7425
7426
7427
7428
7429
7430
7431
7432
7433
7434
7435
7436
7437
7438
7439
7440
7441
7442
7443
7444
7445
7446
7447