SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 102714 LIMIT 1 [ RunTime:0.000297s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 102714 [ RunTime:0.003449s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (825762,760527,268069,477377,134209,714539,183158,500098,165267,198474,784399,1036097,67370,128931,63307,540588,442618,382828,307414,783450,218530,609769,608718,878689,742092,545463,947154,96023,152925,688827,764608,419459,994376,585274,902761,455333,478831,947629,225470,356230,587658,687721,346108,687614,931393,730981,232133,892609,494983,420766,289359,199366,831061,967695,524032,1024355,829944,210785,114383,876400) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 102714 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000432s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 102714 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000937s ]