Eager vs Explicit Loading

Give a real production-style example of using Eager vs Explicit Loading. Walk through the scenario end-to-end.

Answers use simple, clear English.