SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 339409 LIMIT 1 [ RunTime:0.000465s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 339409 [ RunTime:0.004385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1041711,934103,542633,34098,337957,809698,575099,800634,985923,118542,788638,362853,478493,330918,32026,256152,787669,843395,727596,763618,874379,257285,805010,903658,984396,342618,173924,435979,846653,371262,823935,684800,75419,68812,460428,592753,924134,751163,468998,695981,432355,123697,113133,93647,450724,653419,668620,439116,896295,330283,813701,201445,369377,660366,335443,916981,102809,610257,823716,347891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001275s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 339409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 339409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000679s ]