SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 521280 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 521280 [ RunTime:0.002070s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124820,43556,694413,397474,691662,773828,411187,189780,102609,644763,26124,38432,760704,111473,165654,306640,85847,133197,362004,464642,244181,483056,657255,465040,379926,324936,423312,811921,21462,706914,556900,965976,929960,301760,273570,134173,273456,833169,45918,898499,914341,199520,123512,42852,160694,432840,247851,855614,383820,701464,315988,442092,578428,573703,18974,524465,480929,531445,978619,503032) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 521280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 521280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000412s ]