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);