SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (
    34054, 34056, 34057, 34059, 34060, 34062, 
    34063, 34065, 34066, 34068, 34069, 
    34071, 34072, 34074, 34075, 34076, 
    34077, 34079, 34080, 34082, 34083, 
    34085, 34086, 34088, 34089, 34091, 
    34092, 34094, 34095, 34097, 34098, 
    34100, 34101
  )

Query time 0.00238

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_product_popularity",
          "access_type": "range",
          "possible_keys": ["PRIMARY", "total"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "rows": 33,
          "filtered": 100,
          "attached_condition": "cscart_product_popularity.product_id in (34054,34056,34057,34059,34060,34062,34063,34065,34066,34068,34069,34071,34072,34074,34075,34076,34077,34079,34080,34082,34083,34085,34086,34088,34089,34091,34092,34094,34095,34097,34098,34100,34101)",
          "using_index": true
        }
      }
    ]
  }
}