SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 335586 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 335586 [ RunTime:0.001478s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1025079,101540,72417,428999,386557,86218,329838,892769,955012,193574,783093,322454,801103,986101,257049,512360,883357,40831,515275,268494,409168,110895,601913,160217,102802,34060,415718,634384,102297,1024476,197879,103499,571107,252858,14295,449220,891588,82246,721931,912625,718653,696789,941490,668095,357615,80515,180360,291849,323949,96566,209899,328995,682212,854636,252010,1045934,367993,785914,651310,786029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 335586 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 335586 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]