SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013860 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013860 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008722,341532,725725,23098,88292,395844,265207,179551,494256,627077,254427,314043,170636,861222,877241,174891,1017646,1004162,116195,419503,618891,473605,457753,23240,60621,24135,893932,356596,106656,842012,956306,976481,452449,677067,546649,526241,53856,665928,462220,286572,837490,129030,233515,776005,516130,123652,51668,449739,842960,697247,293874,896944,1024393,687969,446303,898147,274926,884934,367816,155455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000701s ]