[ DB ] CONNECT:[ UseTime:0.000321s ] mysql:dbname=xiaobaijidi.com;host=127.0.0.1;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tag` [ RunTime:0.000695s ]
[ SQL ] SELECT * FROM `tag` WHERE `fid` = 3 AND `kaifang` = 1 [ RunTime:0.000273s ]
[ SQL ] SELECT * FROM `tag` WHERE `fid` = 5 AND `kaifang` = 1 [ RunTime:0.000246s ]
[ SQL ] SELECT * FROM `tag` WHERE `fid` = 6 AND `kaifang` = 1 [ RunTime:0.000218s ]
[ SQL ] SELECT * FROM `tag` WHERE `fid` = 7 AND `kaifang` = 1 [ RunTime:0.000198s ]
[ SQL ] SELECT * FROM `tag` WHERE `fid` = 9 AND `kaifang` = 1 [ RunTime:0.000246s ]
[ SQL ] SHOW COLUMNS FROM `img` [ RunTime:0.000462s ]
[ SQL ] SELECT * FROM `img` WHERE `pid` = 1002 ORDER BY id desc [ RunTime:0.000257s ]
[ SQL ] SHOW COLUMNS FROM `page` [ RunTime:0.000487s ]
[ SQL ] SELECT * FROM `page` WHERE `id` = 1002 LIMIT 1 [ RunTime:0.000200s ]
[ SQL ] SHOW COLUMNS FROM `user` [ RunTime:0.000446s ]
[ SQL ] SELECT * FROM `user` WHERE `id` = 11047 LIMIT 1 [ RunTime:0.000148s ]
[ SQL ] SHOW COLUMNS FROM `pinglun` [ RunTime:0.000446s ]
[ SQL ] SELECT a.pid,a.shenhe,a.content,a.uid,b.name,a.time,b.touxiang FROM pinglun a INNER JOIN user b ON b.id= a.uid WHERE `pid` = 1002 ORDER BY a.id desc [ RunTime:0.000847s ]
[ SQL ] UPDATE `page` SET `liulancishu`=liulancishu+1 WHERE `id` = 1002 [ RunTime:0.000212s ]
[ SQL ] SELECT `id`,`title`,`liulancishu`,`cover`,`time` FROM `page` WHERE `tid` = 7 ORDER BY liulancishu desc LIMIT 20 [ RunTime:0.000902s ]
[ SQL ] SELECT * FROM `tag` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000148s ]
[ SQL ] SHOW COLUMNS FROM `xiazaijilu` [ RunTime:0.000442s ]
[ SQL ] SELECT a.uid,a.pid,a.time,a.price,b.touxiang,b.name FROM xiazaijilu a INNER JOIN user b ON a.uid=b.id WHERE a.pid = '1002' ORDER BY a.time desc LIMIT 100 [ RunTime:0.000156s ]
0.026150s
基本文件流程错误SQL调试
请求信息 : 2021-03-07 19:21:02 HTTP/1.1 GET : www.xuebawang.net/article/437
[ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;port=3306;dbname=xuebawang_net;charset=utf8
[ SQL ] SHOW COLUMNS FROM `fenlei` [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `fenlei` ORDER BY `paixu` DESC [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `tag` [ RunTime:0.015625s ]
[ SQL ] SELECT * FROM `tag` WHERE `fid` = 3 AND `kaifang` = 1 ORDER BY `paixu` DESC [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `tag` WHERE `fid` = 5 AND `kaifang` = 1 ORDER BY `paixu` DESC [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `tag` WHERE `fid` = 6 AND `kaifang` = 1 ORDER BY `paixu` DESC [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `tag` WHERE `fid` = 7 AND `kaifang` = 1 ORDER BY `paixu` DESC [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `tag` WHERE `fid` = 9 AND `kaifang` = 1 ORDER BY `paixu` DESC [ RunTime:0.000000s ]
[ SQL ] SHOW COLUMNS FROM `article` [ RunTime:0.000000s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `article` LIMIT 1 [ RunTime:0.000000s ]
[ SQL ] SELECT * FROM `article` WHERE `id` IN (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,0) [ RunTime:0.000000s ]