SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001331s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419464 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419464 [ RunTime:0.001856s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117135,470413,286404,10301,340640,445018,842900,503875,263101,547857,835069,1022929,757404,1012066,682006,1025408,955490,269187,1016768,226907,550359,188743,630875,650510,315880,77084,430131,842911,268703,333721,572642,308794,742174,179355,449502,477409,785611,592189,781009,875789,791489,908089,425263,962687,637174,132078,613684,758168,87326,625653,699727,420574,149302,279398,387388,739462,372596,593189,187015,575036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419464 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419464 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000637s ]