SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001026s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 491983 LIMIT 1 [ RunTime:0.001799s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491983 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (441243,744466,682475,654832,528013,429471,687397,788751,429060,710844,355188,1046664,564256,288956,172103,7229,304690,80001,302944,841629,126586,367477,702769,308988,791913,89197,72320,365479,155046,279331,24719,17455,233454,564288,259740,956239,508229,995172,761965,432918,123925,80648,212409,230656,631144,568709,570567,266337,160176,253853,45295,607985,980900,357692,795284,917750,250548,590107,1022867,997874) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491983 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491983 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]