AutoCompleteTextViewで選択した行のデータではなく最後に登録したデータが表示される

SQLiteの登録情報の反映をさせたAutoCompleteTextViewでデータ１（列0）の情報を選択して、ボタンを押下すると
textViewに列2、列3、、、と反映されて表示させたいです
しかし、ボタン押下後に表示されるデータが他の行のデータのものになってしまいます。
選択した行のデータを反映させる方法についてご教授お願い致します。

errormsg
1android.database.CursorIndexOutOfBoundsException: Index 11 requested, with a size of 11

pagefragment1
1public class PageFragment1 extends Fragment {
2
3    private String foodName = "";
4    private int id = 0;
5    private double foodgram = 0.0d;
6    private double calorie = 0.0d;
7    private double protain = 0.0d;
8    private double carbon = 0.0d;
9    private double fat = 0.0d;
10
11@Override
12    public void onViewCreated(View view, Bundle savedInstanceState) {
13        super.onViewCreated(view, savedInstanceState);
14
15        //データベースの取り込み
16        mydb = new MySQLiteOpenHelper(requireActivity());
17        db = mydb.getReadableDatabase();
18        final String [] mydata;
19        ArrayList<String> array = new ArrayList<>();
20        String sql = "SELECT * FROM Products";
21        Cursor cr = db.rawQuery(sql, null);
22        cr.moveToFirst();
23        mydata = new String[cr.getCount()];
24        int i = 0;
25        while (cr.moveToNext()) {
26
27             id = cr.getInt(0);
28            mydata[i] = cr.getString(1);
29            i ++;
30             foodName = cr.getString(1);
31             foodgram = cr.getDouble(2);
32             calorie = cr.getDouble(3);
33             protain = cr.getDouble(4);
34             carbon = cr.getDouble(5);
35             fat = cr.getDouble(6);
36
37        }
38
39        ArrayAdapter<String> adapter = new ArrayAdapter<String>(this.requireActivity(),
40                android.R.layout.simple_dropdown_item_1line, mydata);
41        foodlist1.setAdapter(adapter);
42        foodlist2.setAdapter(adapter);
43        foodlist3.setAdapter(adapter);
44        foodlist4.setAdapter(adapter);
45
46}
47
48 @Override
49    public void onResume() {
50        super.onResume();
51
52        mydb = new MySQLiteOpenHelper(requireActivity());
53        db = mydb.getReadableDatabase();
54        final String [] mydata;
55        ArrayList<String> array = new ArrayList<>();
56        String sql = "SELECT * FROM Products";
57        Cursor cr = db.rawQuery(sql, null);
58        cr.moveToFirst();
59        mydata = new String[cr.getCount()];
60        int i = 0;
61        do {
62            mydata[i] = cr.getString(1);
63            i ++;
64        }while (cr.moveToNext());
65        ArrayAdapter<String> adapter = new ArrayAdapter<String>(this.requireActivity(),
66                android.R.layout.simple_dropdown_item_1line, mydata);
67        foodlist1.setAdapter(adapter);
68        foodlist2.setAdapter(adapter);
69        foodlist3.setAdapter(adapter);
70        foodlist4.setAdapter(adapter);
71    }
72
73}