SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901280 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901280 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (771650,722071,441152,434127,238587,943603,680622,591612,875507,560681,815931,1026638,506669,747821,78907,415334,709726,563516,936450,154140,397678,160870,535403,135192,374653,318244,927585,871631,197715,787419,828315,777639,956012,832586,127341,29350,751135,468984,481279,896195,473544,866462,930100,388540,877267,78842,77310,66947,128231,285924,922627,492982,339088,902511,573568,161859,705410,920044,341739,16812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000928s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]