SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 329250 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 329250 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (986282,314814,578193,407616,741532,269610,836756,748948,142683,940980,326945,798834,619964,553564,824368,908786,496241,1036037,481576,702181,206287,406862,811792,78273,674784,466773,216459,265762,471915,168474,982749,40411,105033,829849,81125,393979,883787,816228,560864,465506,257582,75225,864339,471322,476708,612700,892714,293924,201497,262920,83290,150249,522849,400454,485951,704272,332168,922170,146988,534988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 329250 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 329250 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]