SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 467126 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 467126 [ RunTime:0.001880s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (658081,207670,606137,143982,716079,494839,109886,453795,680929,307513,481142,142408,13418,446228,736646,217150,793751,1046310,711811,971890,1046694,338608,545998,927239,441436,899233,108412,65510,863224,990707,1011629,425349,1047566,214025,607900,506095,223226,761317,42134,789251,982546,616331,114215,84835,361671,12434,337752,1028780,214806,366321,1017284,275998,193920,882618,947616,214269,665764,304926,951246,800807) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 467126 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000413s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 467126 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000813s ]