针对这条语句查表时很慢,怎么才能快一些$orderdetail['yk']=$db->execute("select sum(tb_moneychange.changemoneynum) as yk from tb_moneychange where tb_moneychange.orderno in (select tb_moneychange.orderno from tb_moneychange where tb_mo
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 16:40:18
![针对这条语句查表时很慢,怎么才能快一些$orderdetail['yk']=$db->execute(](/uploads/image/z/7939423-55-3.jpg?t=%E9%92%88%E5%AF%B9%E8%BF%99%E6%9D%A1%E8%AF%AD%E5%8F%A5%E6%9F%A5%E8%A1%A8%E6%97%B6%E5%BE%88%E6%85%A2%2C%E6%80%8E%E4%B9%88%E6%89%8D%E8%83%BD%E5%BF%AB%E4%B8%80%E4%BA%9B%24orderdetail%5B%27yk%27%5D%3D%24db-%3Eexecute%28%22select+sum%28tb_moneychange.changemoneynum%29+as+yk+from+tb_moneychange+where+tb_moneychange.orderno+in+%28select+tb_moneychange.orderno+from+tb_moneychange+where+tb_mo)
针对这条语句查表时很慢,怎么才能快一些$orderdetail['yk']=$db->execute("select sum(tb_moneychange.changemoneynum) as yk from tb_moneychange where tb_moneychange.orderno in (select tb_moneychange.orderno from tb_moneychange where tb_mo
针对这条语句查表时很慢,怎么才能快一些
$orderdetail['yk']=$db->execute("select sum(tb_moneychange.changemoneynum) as yk from tb_moneychange where tb_moneychange.orderno in (select tb_moneychange.orderno from tb_moneychange where tb_moneychange.id in(select tb_play.tb_moneychangeid from tb_play where tb_play.playtimeID=$orderdetail[playtimeID] and tb_play.userid=".$userid."))")->fields['yk'];
针对这条语句查表时很慢,怎么才能快一些$orderdetail['yk']=$db->execute("select sum(tb_moneychange.changemoneynum) as yk from tb_moneychange where tb_moneychange.orderno in (select tb_moneychange.orderno from tb_moneychange where tb_mo
你的数据库是什么数据库?