For urban combat, you would want the CQB barrel. Generally, shorter weapons are better in urban combat (easier to move in tight places and accuracy isn't a huge requirement as ranges are very close).
If you were looking for a general survival barrel with mixed urban and country with possible long range engagements, I would have to go with the standard length barrel as accuracy is needed by mobility is also needed. The long barrel would not be good in an urban environment and the short barrel would not be that great for longer range engagements (particularly greater that 3-400 yards).