thinkphp5框架中在model层打印sql语句的方法

model层

<?php

namespace app\common\model;

use think\Model;
use app\common\model\Base;

class News extends Base
{

    /**
     * 后台自动化分页
     * @param array $data
     */
    public function getNews($data = []) {
        $data['status'] = [
            'neq', config('code.status_delete')
        ];
        $order = ['id' => 'desc'];
        // 查询
        $result = $this->where($data)
            ->order($order)
            ->paginate();
        // 调试打印sql语句
        echo $this->getLastSql();

        return $result;
    }

打印sql语句

echo $this->getLastSql();