SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419559 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419559 [ RunTime:0.001701s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (463669,81778,747623,748112,41043,866803,725002,848851,99934,82578,637612,24306,198749,268827,719626,604637,973906,115491,470733,880555,675149,127283,835865,123091,287780,484568,772151,282142,484256,520852,161807,66366,414814,652160,751520,256243,777242,316074,109959,630910,361178,639985,28647,814629,726652,144998,823417,365006,375824,546818,135366,37747,54999,548844,258691,797431,170800,59351,370291,785851) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419559 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419559 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000693s ]