thinkphp6 where优先级查询

$map[] = ['id','>',0];
$map[] = ['sex',1];
$map[] = ['color','blue'];

Db::name('student')
    ->where($map)
    ->where(['name','like','%efs%'])
    ->select();

SELECT * FROM `student` WHERE `id` > 0 AND `sex` = 1 AND `color` = 'blue' AND 'name' LIKE '%efs%';

Db::name('student')
    ->where([$map])
    ->where(['name','like','%efs%'])
    ->select();

SELECT * FROM `student` WHERE ( `id` > 0 AND `sex` = 1 AND `color` = 'blue' ) AND 'name' LIKE '%efs%';

一般情况下,where()连缀生成的sql语句是并列AND条件的,当出现优先时,如上所示,如要优先查询$map中的条件再查询'name'条件,只需在where()中加入'[]'即可