SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 544710 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 544710 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (273036,279784,13698,820784,360179,483916,180003,798214,905237,558598,160800,476866,572632,966878,469985,171804,242566,569337,290033,738590,858075,318859,585122,712057,1020821,880347,687192,578912,349035,227186,54289,978274,458821,933133,621237,716377,6071,184636,201295,268763,972093,1039545,161162,396585,868226,1036863,747261,591918,72521,524247,628998,120890,674943,713810,146668,439345,469668,338204,442024,964542) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001037s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 544710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 544710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]