SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 559041 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 559041 [ RunTime:0.001883s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549119,106296,641685,493043,121808,796114,77451,590874,524755,938140,805584,572738,405568,570685,418011,526377,995009,567619,169946,474205,922155,169970,387249,485042,342836,824619,712695,662457,988129,1003581,652378,801508,280743,671162,870401,248940,855180,938099,663824,416852,575530,339176,452128,829907,105320,839078,901304,535884,213985,250295,883856,60121,799258,537440,772235,75839,442551,570129,358354,55036) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 559041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 559041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002467s ]