猝不及防的犯了个基础问题

错误代码

// 统计的模型        
$modelCount = AdminSms::Where('is_refuse',AdminSms::NO);
$count = [
    'a' => $modelCount->where('msg','!=','')->count(),
    'b' => $modelCount->where('msg_b','!=','')->count(),
    'a_code' => $modelCount->where('getcodetime','!=',0)->count(),
    'b_code' => $modelCount->where('getcodetime_b','!=',0)->count(),
];

4次sql执行

1. select * from admin_sms where is_refuse = 1 and msg != '';

2. select * from admin_sms where is_refuse = 1 and msg != '' & msg_b != '';

3. select * from admin_sms where is_refuse = 1 and msg != '' & msg_b != '' & getcodetime != 0;

4. select * from admin_sms where is_refuse = 1 and msg != '' & msg_b != '' & getcodetime != 0 & getcodetime != 0;

忘记 $modelCount 是一个存在的变量了,导致一直叠加 where。

改正代码

// 统计的模型
$modelCount = AdminSms::Where('is_refuse',AdminSms::NO);
$count = [
    'a' => (clone $modelCount)->where('msg','!=','')->count(),
    'b' => (clone $modelCount)->where('msg_b','!=','')->count(),
    'a_code' => (clone $modelCount)->where('getcodetime','!=',0)->count(),
    'b_code' => (clone $modelCount)->where('getcodetime_b','!=',0)->count(),
];