分页前，需要获取记录条数

$count = M('abc')->where($where)->count();

但是, 如果查询还需要使用到 GROUP BY的话

$count = M('video_log')->where($where)->group('ip')->count();

这样是等不到正确条数的，得到的还是总条数

怎样实现呢，需要借助原生sql语句

方法1：参考网址https://www.qiusuoweb.com/71.html

//SQL_CALC_FOUND_ROWS记录查询条数
//在测试中发现，mysql5.7中添加关键词SQL_CALC_FOUND_ROWS不是必须的。
Db::query("select SQL_CALC_FOUND_ROWS date('time') as date from users group by date");
//found_rows()获取以上查询记录的条数
$count = Db::query("select found_rows() as count");

自己用

Db::query("select * from my_video_log group by ip");
$count = Db::query("select found_rows() as count");

方法2：参考网址https://blog.csdn.net/weixin_37946518/article/details/89550409

SELECT COUNT(DISTINCT column_1, column_2) FROM tablename WHERE conditions
其中第二条的 column_1, column_2与第一条的GROUP BY 后的字段要保持一致(字段数量和顺序)

自己用

$rs = Db::query("SELECT COUNT(DISTINCT ip) as count FROM my_video_log");
$count = $rs[0]['count'];