SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.000998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412342 LIMIT 1 [ RunTime:0.000448s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412342 [ RunTime:0.002710s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728576,867273,889777,250829,1000415,248815,480145,274314,1034424,725677,530570,23983,763952,723697,833945,1030802,117400,40571,407220,85918,933910,302670,633123,785451,849174,346628,7431,771547,766583,114152,453043,329559,741981,123669,512669,187604,350868,487758,414249,922815,211250,407665,876419,1002558,944837,236015,919497,474127,349559,201264,898547,135794,847860,109865,803842,897361,46609,659725,1046477,832941) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412342 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000630s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412342 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]