SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516873 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516873 [ RunTime:0.001727s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (403347,365428,401055,12031,733760,340591,765045,261959,696081,716973,117868,1042100,732947,949123,886349,315903,900472,36008,685959,765805,554088,767785,705458,592633,740888,375127,681357,110169,92669,250654,109148,558937,1006346,720023,120726,672670,806425,880615,126586,929695,77122,226816,568794,626086,1003012,401767,132774,594295,918759,585327,715825,561800,310136,937481,440256,10859,146837,320913,627710,524299) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]