SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 548481 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 548481 [ RunTime:0.002433s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (701817,193794,291335,873649,364263,668169,194708,61523,715489,1017676,107968,58384,175068,69849,586094,285096,902477,903239,201309,595059,797461,188176,163448,503345,238242,89505,455268,261404,635103,134052,766751,704068,50644,951524,745857,218541,5760,158474,307797,474472,174649,567702,829428,728652,360428,243755,73799,1039934,227676,601560,282541,423028,157827,404183,440863,798109,378460,344668,125145,524115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 548481 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 548481 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]