dz 7.2 后台一审核回复 mysql就出现大量locked连接进程

用phpmyadmin看，是这个查询导致的

1. SELECT f.name AS forumname, f.allowsmilies, f.allowhtml, f.allowbbcode, f.allowimgcode, p.pid, p.fid, p.tid, p.author, p.authorid, p.subject, p.dateline, p.message, p.useip, p.attachment, p.htmlon, p.smileyoff, p.bbcodeoff, t.subject AS tsubject
   
2. FROM cdb_posts p
   
3. LEFT JOIN cdb_threads t ON t.tid = p.tid
   
4. LEFT JOIN cdb_forums f ON f.fid = p.fid
   
5. WHERE p.invisible = '-2'
   
6. AND p.first = '0'
   
7. ORDER BY p.dateline DESC
   
8. LIMIT 0 , 10

复制代码

大家有遇到过吗？


---
另，刚试了，全文搜索都没有导致数据库出大量locked


审核回复这个查询用了两个 left join ，是不是性能有问题？

试下使用
skip-external-locking
呢

回复 xiaoyuwxz 的帖子


    这个已经是加了的

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '1512462'
AND p.invisible = '0'
ORDER BY FIRST DESC , dateline DESC
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '153188'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '496786'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '260278'

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '201032'

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '209209'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '172200'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '1658303'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '360890'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 360 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '392012'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '2134310'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 20 , 10

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '261585'

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '483748'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '503064'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '1958760'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '1649815'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '261425'

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '101455'

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '194286'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 340 , 10

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '259931'

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '273873'
AND p.invisible = '0'
ORDER BY FIRST DESC , dateline DESC
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '805842'
AND p.invisible = '0'
ORDER BY dateline DESC
LIMIT 132 , 10

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '172888'

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '193471'

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '2164011'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '506001'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '1893387'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . *
FROM `clubdb`.`cdb_posts` p
WHERE p.tid = '14450'
AND p.invisible = '0'
ORDER BY p.dateline
LIMIT 0 , 21

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '2197300'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '488320'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '172103'

Locked
SELECT p.author, p.dateline, p.subject, p.message, p.anonymous, p.status, p.first, m.groupid
FROM cdb_posts p
LEFT JOIN cdb_members m ON p.authorid = m.uid
WHERE p.tid = '493317'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 20

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '256900'

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '193470'

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '152698'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '164611'

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '164629'

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '2175305'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '250179'

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '196237'

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '183339'

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '185709'

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '2105098'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

Locked
SELECT a . * , p.invisible
FROM cdb_attachments a
LEFT JOIN cdb_posts p ON a.pid = p.pid
WHERE aid = '76771'

Locked
SELECT p . * , m.uid, m.username, m.groupid, m.adminid, m.regdate, m.lastactivity, m.posts, m.threads, 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.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 = '1554398'
AND p.invisible = '0'
ORDER BY dateline
LIMIT 0 , 10

那就关闭了论坛访问再审核

楼主解决了吗？ 增加一些php的memory_limit 看看。

回复 enhand 的帖子

当前是 128M