SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201316 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201316 [ RunTime:0.001889s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (783101,760058,313767,733427,811839,692636,819592,785888,353700,139051,816266,992749,697515,803522,80295,381400,632000,748004,660004,786505,973058,357377,1019109,805079,600648,378564,344237,863406,605265,906163,778831,787583,470909,686945,149402,310214,722225,873200,269529,465405,742656,922955,86250,491457,170203,949957,254670,980492,995680,841769,1014520,21046,807053,414108,425694,894129,84026,341791,188714,347370) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000596s ]