Understanding the mechanism of tunable-barrier single-electron pumping: Mechanism crossover and optimal accuracy