SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001187s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 92007 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 92007 [ RunTime:0.002363s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (813910,140466,959100,551641,654388,144091,611459,582867,1002854,196172,741548,705846,69686,937421,79479,1023475,616106,195014,660942,581560,221340,237945,594196,638507,590801,1002625,138998,411188,532155,613953,156370,706098,200814,216605,508785,43355,837540,776557,880818,580220,134271,938431,552791,438703,188736,72183,506432,442804,56070,854553,404499,68245,10804,849796,218810,427321,1027831,907507,554407,96918) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 92007 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 92007 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000526s ]