Neurobiological Highlights of Cognitive Impairment in Psychiatric Disorders