The LOFAR window on star-forming galaxies and AGNs - curved radio SEDs and IR-radio correlation at 0