SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 34696 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 34696 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (287628,367127,535759,646364,325067,143080,40884,171585,38099,995633,129015,683330,635992,557217,758375,4700,721533,433036,383169,940239,173414,742511,413268,735203,187177,967416,807267,775305,376982,12126,22288,995298,801510,551814,122004,432859,1030297,865283,100429,101040,1041520,36804,465658,392184,364828,527176,260892,914277,336507,817281,643735,398925,356372,709808,791124,419943,640717,609736,938636,1046069) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 34696 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000544s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 34696 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]