The nearest neutron star candidate in a binary revealed by optical time-domain surveys