SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681493 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681493 [ RunTime:0.001569s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891095,426591,178532,252090,839139,141062,76314,189616,1032257,268619,149468,585687,523933,144860,937601,247811,935321,537755,609233,954173,375740,148559,496278,192357,595974,373870,91270,646728,514889,646028,648040,595867,818331,314788,893397,1004161,822938,869172,446794,237128,306481,861030,1036933,381612,52259,464414,759600,682539,843141,409395,314924,955180,225657,453146,579360,367502,897771,930384,964458,626667) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681493 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681493 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]