SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 124701 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 124701 [ RunTime:0.002081s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (445602,116072,15410,743400,49542,850330,68811,684709,772162,270914,1005249,664395,258650,204035,183361,681114,466132,1030427,589641,596818,831124,338593,988316,1033637,274282,429040,256350,883333,918471,486537,135500,112768,1006474,394942,61316,56523,244868,162780,29085,632600,575894,780718,192562,214606,867129,839479,98425,143048,629337,858350,836783,767337,389396,797306,501328,778631,821007,490671,431884,78783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 124701 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 124701 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001274s ]