laravel 原生查询与实际结果不符

Question

如题，项目中需要使用原生查询，现在发现查询结果与原生语句在数据库中的执行结果不符合，
使用的的 sql 语句是日志记录的组装语句

$per_page = 39;
$start = ($page - 1) * $per_page;
$sni = " BETWEEN $time[0] AND $time[1]";
if ($time[0] == $time[1]) {

        $sni = " = $time[0]";
}
$inside_sql = "(SELECT *, SUM(quantity) AS qt FROM amt_day_goods WHERE site = '{$site}'
AND group_date {$sni} GROUP BY goods_id) AS q ";
$content_sql  = "SELECT * FROM {$inside_sql} ORDER BY q.qt DESC LIMIT {$start}, {$per_page}";

sql 大概这样子：
SELECT * FROM (SELECT *, SUM(quantity) AS qt FROM amt_day_goods WHERE site = 'bbbb' AND group_date BETWEEN 20190722 AND 20190726 GROUP BY goods_id) AS q ORDER BY q.qt DESC LIMIT 117, 39;

有遇到相关的问题的同学没，麻烦帮忙看看 感谢 ~

Answer 1

BETWEEN 20190722 AND 20190726我想是和你的这个日期格式有关