得到执行SQL语句:
在需要监测之初加:$db->setTrace(TRUE);
结尾加:print_r($db->trace);
可以得到 数组
0为SQL;1为执行SQL语句所用时长;3为执行文件中SQL语句位置
如下:
[2] => Array(
[0] => SELECT id, count(*) as cnt FROM attendance_dw WHERE userID = '1' AND dw_time = '2018/11/1 5:56' AND dw_address like '%江苏省宿迁市宿豫区皂河镇运河路附近' LIMIT 1
[1] => 0.00035715103149414
[2] => MysqliDb->getOne() >> file "ttendance\import.php" line #7)