Yes it does. One of the computers I have will have this LED inside it glow even though the computer is powered off.
It's almost like a wall-wart or adapter; it's plugged in but there is still power dissipation across the transformer, rectification diodes, and filteration caps. But the power consumption isn't very much, it will significantly increase when a load is applied.