SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 191194 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 191194 [ RunTime:0.002800s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (567676,423562,811074,838828,644082,194902,595287,472341,468943,972419,428503,56093,559804,963814,771088,184323,123843,328424,12984,681165,121191,436673,1010464,239028,292522,485497,681972,252518,384597,244449,220438,468971,993514,1019360,458406,375286,200239,923475,1047414,705079,947926,444344,809484,876011,423668,276245,974150,683120,621981,944164,484571,930076,755758,442214,411397,1001434,931878,87248,984320,585380) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 191194 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 191194 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]