针对这条语句查表时很慢,怎么才能快一些$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/11/24 13:52:33
针对这条语句查表时很慢,怎么才能快一些$orderdetail['yk']=$db->execute(
x){9/|6wk/}6鋅+Mt_dzE:xyhxkJ~QJ*$fDWfڪ$ڥV&j(&(j$V&g$楧A(H^iBbBeBZQ~JԢT4A=y y PKp `MR>aА4 ɰJ=T5@%0@sjADIfn-J cRKS2SlT ,=%MM%M]ԜbHxZٌDdZMw]XdwȻ0{<;PpZ

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