SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505084 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505084 [ RunTime:0.001954s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885581,47503,249166,560207,726358,218760,398335,643134,360197,496700,816123,715791,29538,347627,98281,497374,303285,246432,912567,521203,82831,676885,563870,245648,296260,973100,477937,1006722,490631,891662,855147,497607,288143,537284,463747,601212,696927,661489,831959,209382,748739,700190,175844,351111,580155,71298,731850,25495,537902,695670,594514,468988,139513,925218,519171,909792,178180,231486,670590,475316) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001219s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]