Db::table('shop')->limit(20)->page(1)->column('id')
^ array:20 [▼
0 => 1
1 => 5
2 => 7
3 => 9
4 => 11
5 => 13
6 => 15
7 => 16
8 => 17
9 => 19
10 => 21
11 => 24
12 => 26
13 => 27
14 => 28
15 => 29
16 => 30
17 => 31
18 => 32
19 => 33
]
不排序查询20条数据：每页10条，第一页
Db::table('shop')->limit(10)->page(1)->column('id')
^ array:10 [▼
0 => 1
1 => 5
2 => 7
3 => 9
4 => 11
5 => 13
6 => 15
7 => 16
8 => 17
9 => 19
]
不排序查询20条数据：每页10条，第二页
Db::table('shop')->limit(10)->page(2)->column('id')
^ array:10 [▼
0 => 21
1 => 24
2 => 26
3 => 27
4 => 28
5 => 29
6 => 30
7 => 31
8 => 32
9 => 33
]
按字段store_id排序查询20条数据：分页就会出问题！先查询20条
Db::table('shop')->limit(20)->page(1)->order('store_id','asc')->column('id')
^ array:20 [▼
0 => 21
1 => 35
2 => 37
3 => 32
4 => 31
5 => 39
6 => 38
7 => 36
8 => 26
9 => 24
10 => 1
11 => 19
12 => 17
13 => 16
14 => 15
15 => 13
16 => 11
17 => 9
18 => 7
19 => 5
]
按字段store_id排序查询20条数据：分页就会出问题！第一页
Db::table('shop')->limit(10)->page(1)->order('store_id','asc')->column('id')
^ array:10 [▼
0 => 1
1 => 5
2 => 7
3 => 9
4 => 11
5 => 13
6 => 15
7 => 16
8 => 17
9 => 19
]
按字段store_id排序查询20条数据：分页就会出问题！第二页
Db::table('shop')->limit(10)->page(2)->order('store_id','asc')->column('id')
^ array:10 [▼
0 => 1
1 => 19
2 => 17
3 => 16
4 => 15
5 => 13
6 => 11
7 => 9
8 => 7
9 => 5
]
一次读20条和每次读10条读两次差距咋这么大呢？
并且第一页和第二页数据有重复！
请问是什么原因？
store_id是有重复的，是这个原因吗？
最佳答案
