SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 285961 LIMIT 1 [ RunTime:0.000347s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 285961 [ RunTime:0.002810s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414326,686544,75425,409044,619088,20037,149983,512123,470652,555510,826162,249593,942526,393814,574328,643071,577376,124602,366119,865476,95352,654004,705034,889143,45256,245116,253903,96902,552973,671929,909447,611440,552330,668507,357427,906722,829036,159101,244467,997916,759794,318443,442233,423042,571317,891313,944671,471700,340022,479312,843995,85681,634171,346811,155498,455108,80971,905353,1041903,610056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 285961 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 285961 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000575s ]