SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (
    149050, 149051, 149052, 149053, 149054, 
    149055, 149056, 149057, 149058, 149059, 
    149060, 149061, 149062, 149063, 149064, 
    149065, 149066, 149067, 149068, 149069, 
    149070, 149071, 149072, 149073, 149074, 
    149075, 149076, 149077, 149078, 149079, 
    149080, 149081, 149082, 149083, 149084, 
    149085, 149086, 149087, 149088, 149089, 
    149090, 149091, 149092, 149093, 149094, 
    149095, 149096, 149097, 149098, 149099
  )

Query time 0.00119

JSON explain

{
  "query_block": {
    "select_id": 1,
    "cost_info": {
      "query_cost": "21.07"
    },
    "table": {
      "table_name": "cscart_product_popularity",
      "access_type": "range",
      "possible_keys": [
        "PRIMARY",
        "total"
      ],
      "key": "total",
      "used_key_parts": [
        "product_id"
      ],
      "key_length": "3",
      "rows_examined_per_scan": 50,
      "rows_produced_per_join": 50,
      "filtered": "100.00",
      "using_index": true,
      "cost_info": {
        "read_cost": "11.07",
        "eval_cost": "10.00",
        "prefix_cost": "21.07",
        "data_read_per_join": "1K"
      },
      "used_columns": [
        "product_id"
      ],
      "attached_condition": "(`webmarco`.`cscart_product_popularity`.`product_id` in (149050,149051,149052,149053,149054,149055,149056,149057,149058,149059,149060,149061,149062,149063,149064,149065,149066,149067,149068,149069,149070,149071,149072,149073,149074,149075,149076,149077,149078,149079,149080,149081,149082,149083,149084,149085,149086,149087,149088,149089,149090,149091,149092,149093,149094,149095,149096,149097,149098,149099))"
    }
  }
}

Result

product_id
149050
149051
149052
149053
149054
149055
149056
149057
149058
149059
149060
149061
149062
149063
149064
149065
149066
149067
149068
149069
149070
149071
149072
149073
149074
149075
149076
149077
149078
149079
149080
149081
149082
149083
149084
149085
149086
149087
149088
149089
149090
149091
149092
149093
149094
149095
149096
149097
149098
149099