SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 861082 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 861082 [ RunTime:0.001382s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1045278,964090,25916,325322,321814,209058,27169,247200,333584,919167,372377,131768,901586,337834,828039,119544,923292,298110,50234,697280,714695,532251,203472,1029681,176666,17486,1971,288486,184922,450474,864146,845638,438032,528180,778136,227755,524114,196323,154978,279365,20386,227779,714525,599049,857117,928176,123490,229851,607196,753471,612125,678492,825269,694415,38624,389918,955973,1031307,476648,791879) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000943s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 861082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 861082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]