SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466992 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466992 [ RunTime:0.001508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (900781,1017552,1000016,962475,404238,391059,422458,837640,143018,383703,184281,199775,839449,435212,439081,393859,693052,1012422,1035868,1038584,167947,42529,421962,769450,583431,808882,214827,221681,765983,585103,591820,471820,537574,849906,84827,794163,1044002,483227,164449,214803,41846,321037,671336,121475,451226,98128,901946,521971,988889,790159,881918,251532,734399,381453,626089,703819,984791,1010887,955987,682589) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]