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` = 491753 LIMIT 1 [ RunTime:0.001562s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 491753 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (375998,401709,975802,243000,875587,556194,575017,975510,64448,760289,646290,695072,972444,411086,369204,26477,259201,60555,891432,153648,555878,323308,23156,1027515,88393,279459,1034626,304002,282938,853135,188703,308370,723136,1019646,494664,825588,575452,956289,131226,530653,814957,1045353,897334,310319,416408,214900,994837,1240,715511,329463,575996,171140,906141,178844,754934,468566,228703,47523,399686,544776) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001053s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 491753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 491753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]