Advanced Computing and Related Applications Leveraging Brain-inspired Spiking Neural Networks