表结构
主表结构：
?
|
1
2
3
4
5
6
7
8
|
Create Table
CREATE TABLE `user` (
`uid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
`email` varbinary(255) NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=114001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
|
附表结构：
?
|
1
2
3
4
5
6
7
8
|
CREATE TABLE `user_options` (
`id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
`uid` mediumint(8) unsigned NOT NULL,
`age` tinyint(3) NOT NULL,
`sex` tinyint(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `options_key` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=114001 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
|
并使用seed插入随机数据10W条
测试
分别建立User,Options模型，并且建立一对一的关系，
代码如下：
?
|
1
2
3
4
5
6
7
8
9
|
User::with(['options'=>function($query){
$query->where('sex','=','1');
}])->paginate(15);
laravel的debug监控到的SQL运行如下：
select count(*) as aggregate from `user`
select * from `user` limit 15 offset 0
select * from `user_options` where `user_options`.`uid` in ('1', '2', '3', '4', '5', '6', '7', '8', '9', '10', '11', '12', '13', '14', '15') and `sex` = '1'
|
