SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001405s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305243 LIMIT 1 [ RunTime:0.000475s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305243 [ RunTime:0.001753s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (573815,275135,953037,436385,78148,731940,575916,659244,848293,174010,976355,647296,929795,98535,992179,524850,519267,935923,209946,880378,742919,43032,827769,863009,328066,434332,696467,776573,379267,367088,300034,804847,225388,563654,500649,50223,1025419,688110,740171,180838,699394,476915,458220,864941,692415,934271,941012,409118,818258,341853,867545,411326,768395,134227,402468,999640,598444,335420,401931,396308) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000444s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000607s ]