SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1033643 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1033643 [ RunTime:0.001896s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (7008,672361,829101,540754,3421,422191,798878,174382,676656,419749,383657,541007,699113,1011599,368334,492740,353584,894933,615886,483326,684932,555716,121658,504294,966776,467740,411082,711967,930234,312249,39255,692329,340558,355907,312412,901075,423399,934591,324514,468656,744489,233248,92816,36131,297460,148827,659639,968983,38947,751174,230824,954758,248177,675651,137622,138302,654052,622293,857277,752774) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1033643 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1033643 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000505s ]