SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 598328 LIMIT 1 [ RunTime:0.000478s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 598328 [ RunTime:0.002760s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (781624,647493,820489,37476,517582,117121,797830,759310,167477,304946,330938,285897,99953,100655,986147,342226,623035,43033,963686,733788,340031,601586,994326,301707,826503,266192,472100,813837,108761,343146,117714,284134,201889,803530,26381,613497,174556,640592,50484,295191,575789,1026510,160462,597678,1002989,770656,52142,297749,672865,748177,67684,423132,983138,306816,876365,373433,279407,604410,953352,891749) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 598328 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000508s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 598328 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000464s ]