Use SQL raw queries like whereRaw()
method, to make some DB-specific calculations directly in query, and not in Laravel, usually the result will be faster. Like, if you want to get users that were active 30+ days after their registration, here's the code:
1User::where('active', 1)2 ->whereRaw('TIMESTAMPDIFF(DAY, created_at, updated_at) > ?', 30)3 ->get();