SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438573 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438573 [ RunTime:0.001735s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (691184,213532,591639,204354,458367,68417,571254,646969,933220,542887,335548,281844,378089,55192,57152,598225,844513,860486,203220,633420,640109,4769,586160,633443,600751,291658,86072,511553,1042650,1026349,953680,262983,148488,619891,335748,245382,675141,567707,437014,436752,802878,805758,308550,469965,378953,388134,249766,880477,473244,43864,674889,544152,84551,873595,331468,472983,383619,610453,430050,502201) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438573 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438573 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]