SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (
    6828, 7008, 7009, 7032, 7033, 7071, 7034, 
    7110, 7096, 7095, 7072, 7111, 7112, 
    7113, 7180, 7181, 7182, 7223, 3190, 
    6757, 6745, 3197, 6769, 6751, 6835, 
    3288, 6831, 3294, 3168, 6740, 3169, 
    6741, 3273, 3284, 6821, 3280, 3180, 
    6752, 3181, 3272, 6820, 3278, 6826, 
    3279, 6827, 6837, 6838, 3275, 6839, 
    6823, 6842, 3295, 3281, 6762, 3187, 
    3176, 6766, 3195, 6739, 6737, 3167, 
    3166, 6738, 3193, 6755, 3198, 6763, 
    3282, 6746, 3185, 6836, 3289, 6830, 
    3283, 3271, 6832, 3177, 6756, 3192, 
    3183, 3174, 3191, 6748, 3171, 6754, 
    6758, 3194, 3182, 6759, 6743, 6747, 
    3172, 6753, 3184, 6742, 3865, 3186, 
    6765, 3175, 6829, 3291
  )

Query time 0.00130

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "20.94"
    },
    "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": 101,
      "rows_produced_per_join": 101,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "10.84",
        "eval_cost": "10.10",
        "prefix_cost": "20.94",
        "data_read_per_join": "3K"
      },
      "used_columns": [
        "product_id"
      ],
      "attached_condition": "(`test2_gaseus`.`cscart_product_popularity`.`product_id` in (6828,7008,7009,7032,7033,7071,7034,7110,7096,7095,7072,7111,7112,7113,7180,7181,7182,7223,3190,6757,6745,3197,6769,6751,6835,3288,6831,3294,3168,6740,3169,6741,3273,3284,6821,3280,3180,6752,3181,3272,6820,3278,6826,3279,6827,6837,6838,3275,6839,6823,6842,3295,3281,6762,3187,3176,6766,3195,6739,6737,3167,3166,6738,3193,6755,3198,6763,3282,6746,3185,6836,3289,6830,3283,3271,6832,3177,6756,3192,3183,3174,3191,6748,3171,6754,6758,3194,3182,6759,6743,6747,3172,6753,3184,6742,3865,3186,6765,3175,6829,3291))"
    }
  }
}