SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001183s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570921 LIMIT 1 [ RunTime:0.000325s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570921 [ RunTime:0.001702s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (945998,873657,874867,606670,481300,539674,45567,281585,450377,888603,90537,771750,426214,231287,918950,879696,522600,674617,414206,17924,363553,100403,902300,818691,200313,44024,893510,208298,493280,1034278,393133,322994,272045,135936,782847,369649,989371,632101,441200,221636,775068,513408,1044768,122355,78200,698994,962039,79880,834014,47980,994065,880537,173000,836029,526637,187758,766339,524596,81934,629696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]