请问一下大量的查询是否存在的怎么优化
select
exists(
select
*
from
`follows`
where
`follows`.`member_id` = 6674124840015757312
and (
`member_id` = 6674124840015757312
and `follow_member_id` = 6680053333551480832
)
and `follows`.`deleted_at` is null
) as `exists`
这是一个检查好友关系的
member 定义了这个检查好友关系
public function isFriendships($follow_member_id)
{
$member_id = $this->attributes['id'];
if ($member_id == $follow_member_id) {
return 2;
}
$m = $this->Follows()->where([
['member_id', '=', $member_id],
['follow_member_id', '=', $follow_member_id]
])
->exists();
if ($m) {
return 1;
} else {
return 0;
}
}
我在MemberResource api资源的里面查询 导致一堆查询的sql语句 代码怎么写才优雅
$friendships = $user->isFriendships($this->id);
请教一下大佬怎么优化~
我写在了 api资源上~~查询好友关系