phpsql不履行技巧_thinkphp6 查询前提为空时部分sql语句不实行问题

$list = self::where($where)->order($sort,$order)->page(PAGE, LIMIT)->select()->toArray();$count=self::where($where)->field("sum(money) as money, sum(tax_money) as tax_money,sum(number) as number, count(id) as count")->find();

如果$where是空数组，那么$count是查不到数据的，但是$list能有值；我用

var_dump(self::getLastSql());

打印sql，只能打印$list 的sql，$count该当就没实行；但是这样写是没问题的：

$list = self::where($where)->order($sort,$order)->page(PAGE, LIMIT)->select()->toArray(); $count = self::where($where)->count();

$count是能查询到值的，我搜索了一下，thinkphp客服回答是这样的：6.0便是这么设计的 没有查询条件 是不会实际进行查询的。

也便是说须要查询条件才能正常查询，那么给啥通用的查询条件？可以这么写：

$list = self::where($where)->order($sort,$order)->page(PAGE, LIMIT)->select()->toArray(); $count=self::where($where)->field("sum(money) as money, sum(tax_money) as tax_money,sum(number) as number, count(id) as count")->order("id desc")->find();

$count 加上一个order就能查询到数据了。