Android get contacts name and number query

I'm trying to retrieve both the display names and the phone numbers of all my contacts but I want it to return only the rows that have a number.

Currently I have it like this and it works:

ContentResolver cr = getContentResolver();
Cursor cur = cr.query(ContactsContract.Contacts.CONTENT_URI, null,null, null, ContactsContract.Contacts.DISPLAY_NAME+ " COLLATE NOCASE");
while (cur.moveToNext()) 
{           
    if ( Integer.parseInt(cur.getString(cur.getColumnIndex(ContactsContract.Contacts.HAS开发者_运维知识库_PHONE_NUMBER))) > 0) 
    {
                        String id = cur.getString(cur.getColumnIndex(ContactsContract.Contacts._ID));
                        String name = cur.getString(cur.getColumnIndex(ContactsContract.Contacts.DISPLAY_NAME));                    
                        contacts[index] = name;                                 

                        Cursor pCur = cr.query( ContactsContract.CommonDataKinds.Phone.CONTENT_URI, null, ContactsContract.CommonDataKinds.Phone.CONTACT_ID +" = ?", new String[]{id}, null);
                        pCur.moveToFirst();                                 
                        numbers[index] = pCur.getString( pCur.getColumnIndex(ContactsContract.CommonDataKinds.Phone.NUMBER));
                        index++;
                        pCur.close();
        }

The thing is that it takes something like 4-5 seconds to load as it is running the cr.query( ContactsContract.CommonDataKinds.Phone.CONTENT_URI, null, ContactsContract.CommonDataKinds.Phone.CONTACT_ID +" = ?", new String[]{id}, null); like 400 times.

Now my understanding is that the name and number of a contact are held in different tables and you need the id of the name in order to get the number.

Can this be done in any other way faster?

Thanks in advance

@mixkat I have figured out one more solution.

It is possible to get Name and Phone data using just one query.

Here is the code:

    String WHERE_CONDITION = ContactsContract.Data.MIMETYPE + " = '" +   ContactsContract.CommonDataKinds.Phone.CONTENT_ITEM_TYPE + "'";
    String[] PROJECTION = {ContactsContract.Data.DISPLAY_NAME, ContactsContract.Data.DATA1};
    String SORT_ORDER = ContactsContract.Data.DISPLAY_NAME;

    Cursor cur = context.getContentResolver().query(
            ContactsContract.Data.CONTENT_URI,
            PROJECTION,
            WHERE_CONDITION,
            null,
            SORT_ORDER);

In this case you query not Contact provider but Data provider directly.

I have the same problem. I resolved it by saving contacts in db first time user open app. And than I update data (it is up to you when app should update contacts).

So application uses contacts from my db table where name and number are in one row. It takes much less time.