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` = 338032 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338032 [ RunTime:0.001820s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200937,447299,883324,84273,655969,881981,726986,14741,508830,492308,152171,301514,985779,739046,38592,744347,669795,121610,527883,822223,268107,390307,440626,774017,199428,755050,286132,95706,722361,650759,891002,157375,593646,1025259,908765,1029437,769683,74924,891638,739621,416214,39637,135059,797136,731091,349293,99187,370160,140145,974308,487529,684499,818242,478652,880,611315,504019,410578,173350,364157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338032 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338032 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]