SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    35730, 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.00662

JSON explain

{
  "query_block": {
    "select_id": 1,
    "nested_loop": [
      {
        "table": {
          "table_name": "cscart_products",
          "access_type": "range",
          "possible_keys": ["PRIMARY"],
          "key": "PRIMARY",
          "key_length": "3",
          "used_key_parts": ["product_id"],
          "rows": 35,
          "filtered": 100,
          "index_condition": "cscart_products.product_id in (35730,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)"
        }
      }
    ]
  }
}