SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 557809 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 557809 [ RunTime:0.002342s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (349262,782734,792854,118194,628608,718290,791591,230866,688340,222650,187924,895512,912876,934970,786719,755202,81302,410421,700011,1020044,311050,358365,605808,384014,1033022,864741,959977,219041,342972,229094,119778,386718,581162,389341,702634,340443,267307,699359,364498,317028,176458,743600,558168,14455,314644,173035,815109,365591,509452,321906,74903,560968,253910,488285,370581,918452,1000485,746410,112331,727049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000993s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 557809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 557809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]