SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 983307 LIMIT 1 [ RunTime:0.001554s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 983307 [ RunTime:0.002533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1016404,438396,563884,278459,250777,803230,677480,934984,573773,177942,930442,536125,623264,909384,668967,83697,808932,676912,594116,1006745,12936,466320,392140,673342,1008931,417712,512375,587044,800886,544527,1024018,903560,858787,790258,708832,394003,1035699,749326,49083,761422,770564,292150,358275,175458,86087,712484,651731,374190,1007929,918433,98131,534820,835482,560562,55720,558318,54184,861659,425586,656517) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 983307 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 983307 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]