SELECT 
  product_id 
FROM 
  cscart_product_popularity 
WHERE 
  product_id IN (
    35810, 35811, 35812, 35813, 35814, 35815, 
    35816, 35817, 35818, 35819, 35820, 
    35821, 35822, 35823, 35824, 35825, 
    35826, 35827, 35828, 35829, 35830, 
    35831, 35832, 35833, 35834, 35835, 
    35836, 35837, 35838, 35839, 35840, 
    35841, 35842, 35843
  )

Query time 0.00109

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": 34,
          "filtered": 100,
          "attached_condition": "cscart_product_popularity.product_id in (35810,35811,35812,35813,35814,35815,35816,35817,35818,35819,35820,35821,35822,35823,35824,35825,35826,35827,35828,35829,35830,35831,35832,35833,35834,35835,35836,35837,35838,35839,35840,35841,35842,35843)",
          "using_index": true
        }
      }
    ]
  }
}