Query log

\DB::listen(function($query) {
    $queryTime = $query->time;
    $sql = $query->sql;
    $bindings = $query->bindings;
});

you can also enable slow query log on your server so it will log all slow queries.

$this->query_list=$this->model->select('id', 'title')->orderBy('item_order', 'asc')->get()->toArray();

How can i execute that here?

i just want create a function to send me a email and save in db every time wich a query was executed

Just to complement @Cronix answer. https://laravel.com/docs/5.6/database#listening-for-query-events

But iam using eloquent

i just want create a function to send me a email and save in db every time wich a query was executed

Can you be more specific? For any query that runs? Or a specific query?

If you put this in your AppServiceProviders boot() method, it will monitor all queries. You can take an action if the query time took longer than your threshold.

$maxTime = 30;

\DB::listen(function($query) use ($maxTime) {

    if ($query->time > $maxTime) {
        // do something... log it, trigger an event, send an email, etc

        // log the query being run, the bindings (if any), and how long it took the query
        \Log::warning($query->sql, [
            'Bindings' => $query->bindings,
            'Time' => $query->time
        ]);
    }
});

But iam using eloquent

Which uses DB. It will get all queries run, whether using DB facade or Eloquent.

but can i use this in ELOQUENT? Sorry iam learning :)

OK got it Tanks