SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001112s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526800 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526800 [ RunTime:0.001557s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (321195,217594,930638,765786,671534,777349,855398,614080,210947,479581,251680,234278,708604,557555,77849,414621,407946,554677,625965,364221,552783,1029063,602210,555715,295761,32944,973722,249561,209636,600471,785522,160090,800250,1041406,227196,728798,311878,750237,907504,605772,972149,455295,321513,610117,574270,482836,272098,584058,661582,56853,547351,397175,956617,144945,291866,458106,517943,571883,705513,91138) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001067s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002192s ]