- 论坛徽章:
- 0
|
还有这个
mysql> explain SELECT p.*, m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.digestposts, m.oltime,
-> m.pageviews, m.credits, m.extcredits1, m.extcredits2, m.extcredits3, m.extcredits4, m.extcredits5, m.extcredits6,
-> m.extcredits7, m.extcredits8, m.email, m.gender, m.showemail, m.invisible, mf.nickname, mf.site,
-> mf.icq, mf.qq, mf.yahoo, mf.msn, mf.taobao, mf.alipay, mf.location, mf.fromcity, mf.fromtown, mf.nowcity, mf.nowtown, mf.medals,
-> mf.sightml AS signature, mf.customstatus, mf.spacename
-> FROM cdb_posts p
-> LEFT JOIN cdb_members m ON m.uid=p.authorid
-> LEFT JOIN cdb_memberfields mf ON mf.uid=m.uid
-> WHERE p.tid='21220' AND p.invisible='0' ORDER BY dateline LIMIT 10, 10 \G;
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: p
type: ref
possible_keys: invisible,displayorder,first
key: displayorder
key_len: 4
ref: const,const
rows: 38
Extra: Using where
*************************** 2. row ***************************
id: 1
select_type: SIMPLE
table: m
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 3
ref: szxndiscuz.p.authorid
rows: 1
Extra:
*************************** 3. row ***************************
id: 1
select_type: SIMPLE
table: mf
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 3
ref: szxndiscuz.m.uid
rows: 1
Extra:
3 rows in set (0.00 sec)
ERROR:
No query specified |
|