SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001378s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002980 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002980 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (242603,285766,423104,412133,400891,875887,201749,741422,852155,715415,582148,540902,17463,496695,904256,705344,509001,470722,955180,811551,153279,613195,133955,714658,7780,601379,792391,492508,57051,419543,149260,648321,424021,210718,289314,535936,48321,845859,945097,330807,493420,959954,750482,583299,316660,131580,154233,212799,129596,797528,810337,747268,742728,530858,1031252,167104,590475,425468,762503,976118) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002980 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002980 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000504s ]