1能用最好不要用关联查询:比如 select xxx from a left join b on a.bid=b.id;可以写成select xxx from a,b where a.bid=b.id
2把确定的条件放在前面:比如where time>now() and a=1;可以写成where a=1 and time>now()
持续更新
1能用最好不要用关联查询:比如 select xxx from a left join b on a.bid=b.id;可以写成select xxx from a,b where a.bid=b.id
2把确定的条件放在前面:比如where time>now() and a=1;可以写成where a=1 and time>now()
持续更新