请问一下，这条SQL 能优化吗？

[Www_XSimon_cN]

set @x_sum_zs=(SELECT id from __TABLE__ order by rq desc limit 1)+1;
set @x_sum_px=@x_sum_zs;

select *,@x_sum_px:=(@x_sum_px-1) as sum_px,
(SELECT SUM(hsl) from __TABLE__ where id between @x_sum_px and @x_sum_zs ) as hsl_sum ,
(SELECT SUM(cjl) from __TABLE__ where id between @x_sum_px and @x_sum_zs ) as cjl_sum ,
(SELECT SUM(zdf) from __TABLE__ where id between @x_sum_px and @x_sum_zs ) as zdf_sum ,
(SELECT SUM(cjje) from __TABLE__ where id between @x_sum_px and @x_sum_zs ) as cjje_sum
from __TABLE__ order by id desc limit 370

[Www_XSimon_cN]

晕，，，看来真的不能优化了~

[文修]

楼主你好 确实不能优化，如果执行时间不是很长的话，可以不用优化

[LongRui888]

你这个 (SELECT SUM(hsl) from __TABLE__ where id between @x_sum_px and @x_sum_zs ) as hsl_sum 是什么意思，而你后面又是 limit 370 你是不想让 limit 370 影响到 上面求sum，才这么写的吗？