Snp show refactor

Less db hits, async loading of user_snps.