SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001399s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424712 LIMIT 1 [ RunTime:0.000392s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424712 [ RunTime:0.001711s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (128409,555460,641440,721049,792699,269348,875151,983427,900005,329963,547375,716669,592307,848087,919489,643685,755351,642371,126619,838799,816,716079,489499,470020,267423,1011062,596220,816701,100485,422954,179448,816045,786249,796572,493299,256849,692406,482813,377692,285109,380372,889193,710138,221507,445251,777392,326639,90923,791973,1004303,4380,728859,57655,594635,615683,412564,639299,339421,1039383,706476) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]