针对这条语句查表时很慢,怎么才能快一些$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/05/16 23:38:18
针对这条语句查表时很慢,怎么才能快一些$orderdetail[''yk'']=$db->execute("selectsum(tb_moneychange.changemoneynum)asykfrom

针对这条语句查表时很慢,怎么才能快一些$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
你的数据库是什么数据库?