How to get sql query from laravel query

Syntax:-
DB::enableQueryLog();

.....................Query
.....................................

DB::getQueryLog();


  DB::enableQueryLog();

                $final_result = CompleteSingleDayWorkout::where('annual_training_program_id', $this->annual_training_program_id)
                    ->where('user_id', $request->user_id)
                    ->whereHas('weekDays', function ($q) use ($start_date, $end_date) {
                        $q->whereBetween('day_date', [$start_date, $end_date])
                            ->where('annual_training_program_id', $this->annual_training_program_id)
                            ->where('annual_training_program_week_id', $this->id);
                    })->get()->count();
                    dd(DB::getQueryLog());

Comments