SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001366s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548099 LIMIT 1 [ RunTime:0.000636s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548099 [ RunTime:0.002978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (285045,156796,837329,291430,410271,145695,733924,956571,440237,419015,762897,46369,207320,592799,851127,312609,77087,417946,640462,378803,613182,687792,872523,644732,781695,36066,703750,987552,593130,426324,561723,1021818,279814,481103,780109,473278,342943,38315,134659,749655,568986,842244,1004902,698151,304741,528990,657528,723063,10811,108299,360970,752121,403314,348737,693197,774541,124600,467660,915444,18961) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548099 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548099 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000750s ]