SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    47011, 47012, 47013, 47014, 47015, 47016, 
    47017, 47018, 47019, 47020, 47022, 
    47023, 47024, 47004, 46993, 46991, 
    46982, 46822, 46751, 46749, 46694, 
    46696, 46709, 46714, 46715, 46716, 
    46717, 46718, 46719, 46720
  )

Query time 0.00229

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": 30,
          "filtered": 100,
          "index_condition": "cscart_products.product_id in (47011,47012,47013,47014,47015,47016,47017,47018,47019,47020,47022,47023,47024,47004,46993,46991,46982,46822,46751,46749,46694,46696,46709,46714,46715,46716,46717,46718,46719,46720)"
        }
      }
    ]
  }
}