SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031986 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031986 [ RunTime:0.002547s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (38151,802819,486100,384730,240560,738801,446260,267369,47854,448461,87355,124185,532654,870683,622875,113074,553326,555192,159896,505939,862867,39781,160800,1040671,66619,857339,464363,820798,389850,612425,899082,337910,861984,518019,124574,806316,97443,444294,99128,996532,345413,110974,839696,127615,540581,249562,1010503,1018822,30405,265226,661699,160465,48407,592570,56236,628347,687874,615258,303500,153999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001889s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000836s ]