This website uses cookies to store information on your device, cookies can enhance your user experience and help our website work normally. For more information, please read our
Cookie Policy and Privacy Policy.
Accept
基本文件流程错误SQL调试
请求信息 : 2024-05-04 23:58:21 HTTP/2.0 GET : https://zkteco.com.pk/announcement
[ DB ] CONNECT:[ UseTime:0.000227s ] mysql:host=127.0.0.1;dbname=zkteco;charset=utf8
[ SQL ] SHOW COLUMNS FROM `jie_category` [ RunTime:0.000868s ]
[ SQL ] SELECT * FROM `jie_category` WHERE `catdir` = 'announcement' LIMIT 1 [ RunTime:0.000517s ]
[ DB ] CONNECT:[ UseTime:0.000142s ] mysql:host=127.0.0.1;dbname=zkteco;charset=utf8
[ SQL ] SELECT * FROM `jie_category` WHERE `id` = 123 LIMIT 1 [ RunTime:0.000354s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 0 AND (FIND_IN_SET('3', isshow)) ) ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.000948s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND (FIND_IN_SET('1', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000827s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 12 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000785s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 12 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000626s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 153 ) ORDER BY `listorder` ASC [ RunTime:0.000768s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 169 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000666s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 156 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000606s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 157 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000668s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 376 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000541s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 377 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000495s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 378 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000521s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 379 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000587s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 553 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000564s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 13 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000519s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 13 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000590s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 17 ) ORDER BY `listorder` ASC [ RunTime:0.000675s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 18 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000641s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 19 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000613s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 20 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000635s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 21 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000604s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 22 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000684s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 23 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000633s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 24 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000623s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 15 ) ORDER BY `listorder` ASC [ RunTime:0.000586s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 173 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000611s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 14 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000586s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 14 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000592s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 182 ) ORDER BY `listorder` ASC [ RunTime:0.000517s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 192 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000647s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 360 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000614s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 499 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000610s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 180 ) ORDER BY `listorder` ASC [ RunTime:0.000591s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 197 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000582s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 493 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000597s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 522 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000547s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 524 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000567s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 177 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000622s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 177 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000605s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 381 ) ORDER BY `listorder` ASC [ RunTime:0.000614s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 382 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000570s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 383 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000548s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 308 ) ORDER BY `listorder` ASC [ RunTime:0.000659s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 357 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000611s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 489 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000560s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 537 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000566s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 555 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000614s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 501 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000626s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 501 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000776s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 523 ) ORDER BY `listorder` ASC [ RunTime:0.000657s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 504 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000629s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 518 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000636s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 520 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000647s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 502 ) ORDER BY `listorder` ASC [ RunTime:0.000637s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 503 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000592s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 526 ) ORDER BY `listorder` ASC [ RunTime:0.000572s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 527 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000605s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 530 ) ORDER BY `listorder` ASC LIMIT 5 [ RunTime:0.000622s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 294 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000634s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 295 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000679s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 296 ) ORDER BY `listorder` ASC LIMIT 3 [ RunTime:0.000753s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 297 ) ORDER BY `listorder` ASC LIMIT 4 [ RunTime:0.000598s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 123 ) ORDER BY `listorder` ASC [ RunTime:0.000582s ]
[ SQL ] SHOW COLUMNS FROM `jie_model` [ RunTime:0.000859s ]
[ SQL ] SELECT * FROM `jie_model` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000372s ]
[ SQL ] SHOW COLUMNS FROM `jie_announcement` [ RunTime:0.000745s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `jie_announcement` WHERE ( `status`=1 AND `catid` in(124,125,123) ) [ RunTime:0.000369s ]
[ SQL ] SELECT * FROM `jie_announcement` WHERE ( `status`=1 AND `catid` in(124,125,123) ) ORDER BY `listorder` ASC,`inputtime` DESC LIMIT 0,12 [ RunTime:0.000402s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 0 AND (FIND_IN_SET('2', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000770s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 32 AND (FIND_IN_SET('2', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000687s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 2 AND (FIND_IN_SET('2', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000654s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 63 AND (FIND_IN_SET('2', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000626s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 64 AND (FIND_IN_SET('2', isshow)) ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000622s ]
[ SQL ] SHOW COLUMNS FROM `jie_links` [ RunTime:0.000693s ]
[ SQL ] SELECT * FROM `jie_links` WHERE ( status=1 ) ORDER BY `listorder` ASC LIMIT 6 [ RunTime:0.000329s ]
[ SQL ] SELECT * FROM `jie_category` WHERE ( `status`=1 AND `parentid` = 57 ) ORDER BY `listorder` ASC LIMIT 10 [ RunTime:0.000702s ]
[ DB ] CONNECT:[ UseTime:0.000163s ] mysql:host=127.0.0.1;dbname=zkteco;charset=utf8
[ SQL ] SELECT * FROM `jie_category` WHERE `id` = 60 LIMIT 1 [ RunTime:0.000424s ]
[ DB ] CONNECT:[ UseTime:0.000113s ] mysql:host=127.0.0.1;dbname=zkteco;charset=utf8
[ SQL ] SELECT * FROM `jie_category` WHERE `id` = 59 LIMIT 1 [ RunTime:0.000333s ]