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

$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}";

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;