Database Optimisation Techniques Add Listener for full query debug Chunking Results Using Transactions Single values & Aggregates Join Grouping Sub-Query Joins Eloquent Relationship Loading Global Scopes Observers