SELECT 
  cscart_products.* 
FROM 
  cscart_products 
WHERE 
  cscart_products.product_id IN (
    47165, 29733, 37313, 31736, 44768, 47166, 
    46165, 37334, 48065, 37337, 36504, 
    47608, 43463, 45362, 43458, 38795, 
    38123, 44800, 32315, 1415, 37417, 37423, 
    48676, 28439, 32314, 41006, 46187, 
    40917, 36282, 37326, 37414, 38766
  )

Query time 0.00145

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": 32,
          "filtered": 100,
          "index_condition": "cscart_products.product_id in (47165,29733,37313,31736,44768,47166,46165,37334,48065,37337,36504,47608,43463,45362,43458,38795,38123,44800,32315,1415,37417,37423,48676,28439,32314,41006,46187,40917,36282,37326,37414,38766)"
        }
      }
    ]
  }
}