SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001207s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 105354 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105354 [ RunTime:0.003275s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (795846,476436,864891,956965,255002,589958,1027168,251001,244590,712876,309685,540187,648742,199556,542520,742887,33029,559140,880229,2976,1047513,400862,10662,636819,357107,1012368,9152,1042118,598698,284815,758835,932399,849033,43714,164078,580606,446472,23226,566775,996703,162468,303131,684330,508789,698908,300282,605998,513464,296664,638182,376201,677756,502379,1003912,137118,1039142,601587,916872,497807,442152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105354 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105354 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000731s ]