Spent an afternoon this week chasing down why a client's order dashboard took around 2.5s to load.
Turned out the page was firing 300+ database queries. Classic N+1 problem. Every order in the loop was making its own separate trip to the DB just to grab the customer and product.