Insight into the performance of GGA functionals for solid-state calculations