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-12-22 14:54:29 HTTP/2.0 GET : https://zkteco.com.pk/event/ISC-WEST-2022
[ DB ] CONNECT:[ UseTime:0.000232s ] mysql:host=127.0.0.1;dbname=zkteco;charset=utf8
[ SQL ] SHOW COLUMNS FROM `jie_category` [ RunTime:0.000820s ]
[ SQL ] SELECT * FROM `jie_category` WHERE `catdir` = 'event' LIMIT 1 [ RunTime:0.000420s ]
[ SQL ] SHOW COLUMNS FROM `jie_article` [ RunTime:0.000641s ]
[ SQL ] SELECT * FROM `jie_article` WHERE ( customurl='ISC-WEST-2022' ) LIMIT 1 [ RunTime:0.000899s ]
[ SQL ] UPDATE `jie_article` SET `hits` = `hits` + 1 WHERE `id` = 55 [ RunTime:0.003148s ]
[ SQL ] SELECT * FROM `jie_article` WHERE ( `id` = 55 ) LIMIT 1 [ RunTime:0.000620s ]
[ SQL ] SELECT * FROM `jie_article` WHERE ( `catid` = 6 AND `status` = 1 AND `id` != 55 AND `listorder` < 100 ) ORDER BY `listorder` DESC,`inputtime` LIMIT 1 [ RunTime:0.002564s ]
[ SQL ] SELECT * FROM `jie_article` WHERE ( `catid` = 6 AND `status` = 1 AND `id` != 55 AND `listorder` <= 100 AND `inputtime` > 1646114877 ) ORDER BY `listorder` DESC,`inputtime` LIMIT 1 [ RunTime:0.001765s ]
[ SQL ] SELECT * FROM `jie_article` WHERE ( `id` = 55 ) LIMIT 1 [ RunTime:0.000504s ]
[ SQL ] SELECT * FROM `jie_article` WHERE ( `catid` = 6 AND `status` = 1 AND `id` != 55 AND `listorder` > 100 ) ORDER BY `listorder`,`inputtime` DESC LIMIT 1 [ RunTime:0.002049s ]
[ SQL ] SELECT * FROM `jie_article` WHERE ( `catid` = 6 AND `status` = 1 AND `id` != 55 AND `listorder` >= 100 AND `inputtime` < 1646114877 ) ORDER BY `listorder`,`inputtime` DESC LIMIT 1 [ RunTime:0.001700s ]
[ SQL ] SELECT * FROM `jie_article` WHERE ( `id` != 55 AND `status`=1 AND (FIND_IN_SET('3', flag)) AND `catid` = 6 ) ORDER BY `listorder` ASC,`inputtime` DESC LIMIT 4 [ RunTime:0.001711s ]
[ SQL ] SELECT * FROM `jie_article` WHERE ( `id` != 55 AND `status`=1 AND (FIND_IN_SET('2', flag)) AND `catid` = 6 ) ORDER BY `listorder` ASC,`inputtime` DESC LIMIT 4 [ RunTime:0.001691s ]
[ SQL ] SHOW COLUMNS FROM `jie_links` [ RunTime:0.000867s ]
[ SQL ] SELECT * FROM `jie_links` WHERE ( status=1 ) ORDER BY `listorder` ASC LIMIT 6 [ RunTime:0.000378s ]