tp3 报错最近一条sql到数据库 便于复查

1、 sql

CREATE TABLE `lastsql` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `path` varchar(255) DEFAULT NULL COMMENT '路径',
  `num` int(10) DEFAULT NULL COMMENT '行号',
  `sql` mediumtext COMMENT 'sql 语句',
  `create_time` int(11) DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=192 DEFAULT CHARSET=utf8 COMMENT='最近sql记录';

2、php

/**
 * @Author   tang1jun
 * @DateTime 2021-03-24
 * @version  [version]
 * @param    [type]     $path [description]
 * @param    [type]     $num  [description]
 * @param    string     $sql  [description]
 */
function addLastSql($path, $num, $sql = "")
{
    $debug = env('LYJDEBUG.SQL'); // 环境变量配置  调试模式则生效保存到数据库
    if($debug){
        if($sql == ""){
            $sql = M()->getLastSql();
        }

        $data['path'] = $path;
        $data['num'] = $num;
        $data['sql'] = $sql;
        $data['create_time'] = time();

        $res = M('lastsql',null)->add($data);
    }
}


/**
 * 最近的sql语句
 * @Author   tang1jun
 * @DateTime 2021-03-24
 * @version  [version]
 * @return   [type]
 */
function showLastSql()
{
    $list = M("lastsql",null)->limit(15)->order("create_time desc")->select();

    $data = array();
    foreach ($list as $key => $value) {
        $data[$key]['id'] = $value['id'];
        $data[$key]['path'] = $value['path'];
        $data[$key]['num'] = $value['num'];
        $data[$key]['sql'] = $value['sql'];
        $data[$key]['create_time'] = $value['create_time'];
        $data[$key]['create_time_str'] = date("Y-m-d H:i:s", $value['create_time']);

    }

    $res['status'] = 1;
    $res['data'] = $data;
    $res['msg'] = "最近sql";

    die(json_encode($res));
    dump($res);
}

3、 在需要的curd 后 插入 一下代码

addLastSql(FILE.’\’.FUNCTION,LINE)；