SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1045581 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1045581 [ RunTime:0.002194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (61753,890057,965324,221777,886992,122202,914848,685376,223739,655265,350718,890283,350315,676244,559179,304694,348445,117782,643236,897661,253354,955939,817831,441971,812751,1038023,878036,995765,159815,181079,534433,167626,612528,105321,394765,303406,874341,730443,284495,281156,97375,685492,593739,601815,980503,442266,989991,496744,421674,126638,896152,626300,35648,322133,195858,311385,265594,730678,943347,184315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1045581 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1045581 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000554s ]