php+mysql sql语句里分组3次 卡到崩 求大神指导

Question

$sql = "select O.actor_user,O.game_id,C.option_id,sum(C.num)as numbers from gift_order as O
       left join gift_card_option as C on O.id = C.order_id
       where O.state = 1
       and O.created_date>'2017-08-11 0:0:0'
       and O.created_date<'2017-08-11 11:40:08'
       group by O.actor_user,O.game_id,C.option_id limit 0,30";

能用php和或者优化sql    求大神帮忙 谢谢

Answer 1

首先这个是一条再平常不过的sql语句了，你卡的话只能是电脑卡，mysql处理这样的语句的时候，况且才只是30条记录，你不用担心