includes vs joins vs preload vs eager_load in Rails

These four all deal with associations, and they're easy to mix up. The way I keep them straight is to ask two questions about each: what SQL does it run, and does it actually pull the associated recor...