SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548591 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548591 [ RunTime:0.002484s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (774510,162272,445038,474932,828399,310296,980646,472950,812016,1016212,851647,244675,767822,254198,467704,616756,562786,942784,602079,104705,735917,106138,101045,487609,363142,258113,81453,71509,234572,304953,343605,391298,400222,601133,366085,697195,219538,98193,134295,84457,651693,555892,628309,631642,596038,135059,300491,40406,977261,55531,439167,870581,607769,595279,228234,272082,281531,31857,867543,524254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548591 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548591 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000392s ]