SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149081 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149081 [ RunTime:0.002641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037197,300346,943238,108286,806094,429399,322520,572852,882458,732570,648573,849516,125256,818970,801637,539068,904363,29797,429839,1009187,478994,82046,689786,825834,306795,268940,629566,495871,740826,638377,664167,1019167,550063,702649,454475,748011,315067,949748,102154,638747,480267,976024,310370,997181,674083,909144,780643,65182,258959,837704,1002,839762,135211,482782,660658,490532,1003489,657118,38648,46199) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000623s ]