public class Song extends RealmObject implements Serializable {
	public String songBM;
	public String songName;
	public String singer;
	public int songType;
	public int singingProgram;//act program
	public int lang;
	public String path;
	public String fileName;
	public String spell;
	public long zs;
	@Index
	public long orderTimes;
	public long musicTrack;
	public long maxVol;
	public long minVol;
	public long volume;
	public int cloud;
	public long mediaInfo;
	public long movie;
	public long newSong;
	public Date createAT;
}

public  List<Song> getAllKsong(final Query q,Realm realm) {
		final Query query;
		if(!PhoneInfo.isOnline(App.getInstance().getApplicationContext())){
			query = (Query) q.clone();
			query.cloud = KtvAddPlay.NATIVE; //lessthan so this set cloud
		} else {
			query = (Query) q.clone();
			query.cloud = KtvAddPlay.ALL;
		}

		List<Song> ret = new ArrayList<>();
		long start = System.currentTimeMillis();
		RealmResults<Song> results = realm.where(Song.class)
				.beginsWith("spell",query.spell)
				.contains("songName",query.songName)
				.lessThanOrEqualTo("cloud",query.cloud)
				.findAll();

		OrderedRealmCollectionSnapshot<Song> resultsSnapshot = results.createSnapshot();
		if (resultsSnapshot.size() == 0){
			return ret;
		}
		try {
			for (int i = query.startIndex; i < query.startIndex + query.show_limit; i++) {

				if (i >= resultsSnapshot.size()) {
					break;
				}
				Song temp = realm.copyFromRealm(resultsSnapshot.get(i));
				ret.add(temp);

			}
			long end = System.currentTimeMillis();
			long time = end - start;
			Log.e("TTTTTTT", time + "ms");
			return ret;
		}catch (Exception e){
			e.printStackTrace();
		}
		return ret;
	}

public  List<Song> getAllKsong(final Query q,Realm realm) {
		List<Song> ret = new ArrayList<>();
		long start = System.currentTimeMillis();
		RealmResults<Song> results = realm.where(Song.class)
                                .sort("orderTimes")
				.findAll();
		OrderedRealmCollectionSnapshot<Song> resultsSnapshot = results.createSnapshot();
		if (resultsSnapshot.size() == 0){
			return ret;
		}
		try {
			for (int i = query.startIndex; i < query.startIndex + query.show_limit; i++) {

				if (i >= resultsSnapshot.size()) {
					break;
				}
				Song temp = realm.copyFromRealm(resultsSnapshot.get(i));
				ret.add(temp);

			}
			long end = System.currentTimeMillis();
			long time = end - start;
			Log.e("TTTTTTT", time + "ms");
			return ret;
		}catch (Exception e){
			e.printStackTrace();
		}
		return ret;
	}