SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 687910 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 687910 [ RunTime:0.001488s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000066,162507,405712,686208,790244,898557,556148,12679,490178,225443,261573,444612,946909,401860,499380,710253,374007,352394,717024,771801,656280,605608,786310,116996,861978,630412,419262,884762,474924,553098,642404,774022,961795,713171,840234,563336,802533,782421,197807,1028969,844284,141189,890926,511979,749032,788243,880340,354608,13731,735823,708590,8475,446779,901135,138699,310040,623464,358811,80483,342130) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000989s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 687910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 687910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000507s ]