SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (
    148882, 148883, 148884, 148885, 148886, 
    148887, 148888, 148889, 148890, 148891, 
    148892, 148893, 148894, 148895, 148896, 
    148897, 148898, 148899, 148900, 148901, 
    148902, 148903, 148904, 148905, 148906, 
    148907, 148908, 148909, 148910, 148911, 
    148912, 148913, 148914, 148915, 148916, 
    148917, 148918, 148919, 148920, 148921, 
    148922, 148923, 148924, 148925, 148926, 
    148927, 148928, 148929, 148930, 148931
  )

Query time 0.00171

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 (148882,148883,148884,148885,148886,148887,148888,148889,148890,148891,148892,148893,148894,148895,148896,148897,148898,148899,148900,148901,148902,148903,148904,148905,148906,148907,148908,148909,148910,148911,148912,148913,148914,148915,148916,148917,148918,148919,148920,148921,148922,148923,148924,148925,148926,148927,148928,148929,148930,148931))"
    }
  }
}