php搜索如何优化,Thinkphp where() 方法的 查找数据优化

第一种方式

$bank = array(12) {

["bank_id"] => string(1) "9"

["bank_type"] => string(1) "1"

["bank_operator_id"] => string(1) "2"

["bank_operator_name"] => string(9) "唐新朋"

["bank_operator_type"] => string(1) "3"

["bank_accept_id"] => string(1) "1"

["bank_accept_name"] => string(9) "汪昌宁"

["bank_accept_type"] => string(1) "1"

["bank_sum"] => string(5) "50000"

["bank_mark"] => string(3) "500"

["bank_confirm"] => string(1) "0"

["bank_create_time"] => string(10) "1467113725"

}

$m->where($bank)->setField('bank_confirm','1');

第二种方式

$bank = array(12) {

["bank_id"] => string(1) "9"

["bank_type"] => string(1) "1"

["bank_operator_id"] => string(1) "2"

["bank_operator_name"] => string(9) "唐新朋"

["bank_operator_type"] => string(1) "3"

["bank_accept_id"] => string(1) "1"

["bank_accept_name"] => string(9) "汪昌宁"

["bank_accept_type"] => string(1) "1"

["bank_sum"] => string(5) "50000"

["bank_mark"] => string(3) "500"

["bank_confirm"] => string(1) "0"

["bank_create_time"] => string(10) "1467113725"

}

$condition['bank_id'] = $bank["bank_id"];

$m->where($condition)->setField('bank_confirm','1');

这两种方法都可以实现我想要的操作但是

第一种方法是否会对服务器或数据库造成压力

第二种是可以多写这一行代码

$condition['bank_id'] = $bank["bank_id"];

纠结中(⊙﹏⊙)