谢谢！who can tell me, 谁能告诉我这段查询有什么问题？

Question

select sum(order_line.数量) as sq1, sum(grouped_order.sales_qty) as sq2
from order_line, 
(select 订单号, sum(商品总价（元）) as sales_amt, sum(数量) as sales_qty
from order_line
where (财务状态 = '已付款' or 付款方式 = '货到付款')
and 创单时间 between '2021-01-01 00:00:00' and '2021-03-01 00:00:00'
group by 订单号) as grouped_order
where (order_line.财务状态 = '已付款' or order_line.付款方式 = '货到付款')
and order_line.创单时间 between '2021-01-01 00:00:00' and '2021-03-01 00:00:00'
;

因为执行之后不报错，但是用了比较长的时间仍然没有出结果，以上：

Answer 1

sql写的有问题，你的order_line、grouped_order表，没有join关联，产生笛卡尔积了，会生成大量数据，肯定很慢