SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402157 LIMIT 1 [ RunTime:0.000492s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402157 [ RunTime:0.001453s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80410,730140,660296,465560,135423,755703,595809,298109,300471,35601,138524,710239,314621,651286,348606,35757,1042147,492253,777981,671198,484126,314236,408857,553033,311980,707267,536497,163417,848538,275629,701036,632416,151606,256110,360083,708427,301973,796314,994649,98528,981833,318677,38331,93815,662002,944281,511195,526285,119108,795524,258515,638859,597187,222857,397816,408634,551152,626027,570914,325126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402157 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402157 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001308s ]