SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (
    7464, 
    7465, 
    7466, 
    7467, 
    7468, 
    7469, 
    7470, 
    7478, 
    7479, 
    7480, 
    7481, 
    7482, 
    7483, 
    470, 
    482, 
    483, 
    484, 
    3645, 
    485, 
    3646, 
    486, 
    3647, 
    3648, 
    3632, 
    3627, 
    465, 
    3628, 
    466, 
    467, 
    468, 
    471, 
    478, 
    479, 
    3640, 
    3641, 
    480, 
    3642, 
    469, 
    3629, 
    3630, 
    3631, 
    475, 
    476, 
    3637, 
    3638, 
    477, 
    3639, 
    472, 
    3633, 
    473, 
    3634, 
    3635, 
    3636, 
    474, 
    3643, 
    481, 
    3644, 
    3649, 
    487, 
    3650, 
    489, 
    488, 
    3651, 
    3652, 
    490, 
    3504, 
    3506, 
    504, 
    3665, 
    505, 
    3666, 
    3667, 
    3668, 
    506, 
    3669, 
    507, 
    3670, 
    508, 
    509, 
    510, 
    3671, 
    3854, 
    3855, 
    2973, 
    2974, 
    3856, 
    2975, 
    3656, 
    3657, 
    494, 
    495, 
    496, 
    3658, 
    3659, 
    497, 
    3660, 
    498, 
    499, 
    500, 
    3661, 
    423, 
    3623, 
    424, 
    3624, 
    3625, 
    4231, 
    425, 
    491, 
    492, 
    3653, 
    3654, 
    493, 
    3655, 
    516, 
    517, 
    3677, 
    3678, 
    518, 
    4271, 
    3662, 
    3663, 
    501, 
    502, 
    3664, 
    503, 
    3508, 
    3507, 
    3510, 
    3509
  )

Query time 0.00105

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "26.67"
    },
    "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": 129,
      "rows_produced_per_join": 129,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "13.78",
        "eval_cost": "12.90",
        "prefix_cost": "26.68",
        "data_read_per_join": "4K"
      },
      "used_columns": [
        "product_id"
      ],
      "attached_condition": "(`gaseus`.`cscart_product_popularity`.`product_id` in (7464,7465,7466,7467,7468,7469,7470,7478,7479,7480,7481,7482,7483,470,482,483,484,3645,485,3646,486,3647,3648,3632,3627,465,3628,466,467,468,471,478,479,3640,3641,480,3642,469,3629,3630,3631,475,476,3637,3638,477,3639,472,3633,473,3634,3635,3636,474,3643,481,3644,3649,487,3650,489,488,3651,3652,490,3504,3506,504,3665,505,3666,3667,3668,506,3669,507,3670,508,509,510,3671,3854,3855,2973,2974,3856,2975,3656,3657,494,495,496,3658,3659,497,3660,498,499,500,3661,423,3623,424,3624,3625,4231,425,491,492,3653,3654,493,3655,516,517,3677,3678,518,4271,3662,3663,501,502,3664,503,3508,3507,3510,3509))"
    }
  }
}

Result

product_id
423
424
425
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
516
517
518
2973
2974
2975
3504
3506
3507
3508
3509
3510
3623
3624
3625
3627
3628
3629
3630
3631
3632
3633
3634
3635
3636
3637
3638
3639
3640
3641
3642
3643
3644
3645
3646
3647
3648
3649
3650
3651
3652
3653
3654
3655
3656
3657
3658
3659
3660
3661
3662
3663
3664
3665
3666
3667
3668
3669
3670
3671
3677
3678
3854
3855
3856
4231
4271
7464
7465
7466
7467
7468
7469
7470
7478
7479
7480
7481
7482
7483