SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 781917 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 781917 [ RunTime:0.003853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (558840,362007,1028957,338186,645831,835405,283062,110058,692151,687825,757485,255730,197873,831003,543047,808298,686562,605490,46206,512856,741987,712203,450992,336199,566591,256606,55124,759448,850731,173862,695893,27805,531379,950346,740113,954269,593211,85786,587537,655704,663143,789811,477456,820048,588989,88467,430722,419120,633397,432694,32322,357140,1023540,810419,1005092,998141,560743,920746,522837,218138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003611s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 781917 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000844s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 781917 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]