SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 317521 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 317521 [ RunTime:0.001959s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (250110,108988,893088,577998,733977,710015,179680,299122,891347,941249,248362,843205,271482,887741,712897,417256,151739,853868,1003577,762142,203663,730388,40326,795180,102356,157913,453378,929913,926926,1000873,405739,117043,470318,133283,482030,857386,312552,482588,319368,657744,370135,364067,260413,725347,117020,958602,848705,367800,18108,707011,1037761,14465,646873,612523,470899,932065,503257,882900,534838,760716) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 317521 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 317521 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000791s ]