SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409615 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409615 [ RunTime:0.001934s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (249541,330764,990237,224487,618823,270814,247242,259846,931648,798384,105771,211806,17713,79565,685896,483429,824358,718049,531352,540016,288316,477906,973338,826708,757426,70219,1000180,961752,87639,933663,347785,541122,98684,752746,759758,291608,223106,217496,774922,950447,677049,190698,159890,382572,451955,534777,918112,586249,738692,737699,483881,139374,36935,458899,656372,852153,27325,706276,343567,489252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000431s ]