SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 683936 LIMIT 1 [ RunTime:0.001331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 683936 [ RunTime:0.001805s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420119,412019,964026,273600,629691,147750,789150,239406,338999,522139,962552,292052,515258,306969,106458,52077,369126,710525,201062,688,805796,59253,679448,530029,15139,212291,702843,76441,861315,815092,543764,573227,616303,127333,1007619,239571,672215,896350,456418,478099,402091,757131,642194,326237,626222,283041,938599,885802,534567,514767,265222,107381,832390,372897,558771,6901,615967,149689,929703,295212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000970s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 683936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 683936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]