SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 694570 LIMIT 1 [ RunTime:0.002154s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 694570 [ RunTime:0.004774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (286048,555465,356142,211427,1046226,37761,857032,776550,733882,937136,792673,871313,925315,514370,808168,654688,97032,873067,1030062,762926,910846,240739,780326,970023,146125,561048,455158,461173,833202,30175,175181,657030,423151,847444,583326,115814,1020355,823763,176439,660125,290806,98880,371571,721677,480653,604554,515008,747179,535549,285475,804045,16483,180475,198359,771515,983102,1012595,919056,65179,255969) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 694570 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000712s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 694570 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000845s ]