SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418100 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418100 [ RunTime:0.001604s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (152741,475332,238320,146060,842069,436419,432211,674359,455310,171437,999918,336552,920732,1013703,123212,664250,727122,57292,32482,201815,390752,267358,819410,719418,918346,504659,46269,322741,468393,925832,831684,356484,215948,324057,159804,884440,107768,909086,992948,57684,299736,805049,120239,222748,360099,156233,564664,819522,13345,511315,467407,212543,263543,391715,418030,441743,466315,610036,328947,735153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418100 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418100 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000652s ]