SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001341s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 196836 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 196836 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (519867,66204,613857,132383,56782,179240,213628,319109,462123,774066,94539,627125,120436,880731,599677,566783,690863,279507,335358,404550,826549,912409,815286,907661,283901,490113,200230,858828,875294,788218,733924,819765,756059,495617,437360,681228,305289,927097,40225,125746,553188,630121,321445,112270,75159,552369,706515,244962,471311,951004,487417,526196,442093,692134,270675,765330,589465,1025465,348579,366440) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001351s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 196836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 196836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]