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条记录，你不用担心