服务器上的网站内存经常突然增加到300以上就很卡
主要是DZ应用池内存使用异常 其他2个网站有时候也异常 慢查询日志非常多FROM cdb_members m LEFT JOIN cdb_usergroups u USING (groupid)
WHERE m.uid='998075';
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
INSERT INTO cdb_sessions (sid, ip1, ip2, ip3, ip4, uid, username, groupid, styleid, invisible, action, lastactivity, lastolupdate, seccode, fid, tid)
VALUES ('BULe3Q', '124', '72', '220', '248', '0', '', '7', '31', '0', '254', '1254486244', '0', '767473', '0', '0');
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
use ffzl;
select downpath,id,title from phome_ecms_download where id='2170' and classid='63';
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
select tbname from phome_enewsclass where classid='63' limit 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
use feifei;
SELECT * FROM cdb_threads t WHERE tid='219661' AND displayorder>='0';
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 1 Rows_examined: 0
use ffzl;
select tbname,checkpl from phome_enewsclass where classid='63' limit 1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 1 Rows_examined: 0
select tbname from phome_enewsclass where classid='63' limit 1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 1 Rows_examined: 0
select tbname from phome_enewsclass where classid='73' limit 1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 1 Rows_examined: 0
select tbname from phome_enewsclass where classid='73' limit 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
use feifei;
SELECT 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_memberfields AS mf WHERE uid=525547 LIMIT 0,1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 0 Rows_examined: 0
use ffzl;
update phome_ecms_download set onclick=onclick+1 where id='2186';
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
use feifei;
SELECT 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_memberfields AS mf WHERE uid=433792 LIMIT 0,1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 1
SELECT uid AS moduid, username AS modusername, dateline AS moddateline, action AS modaction, magicid
FROM cdb_threadsmod
WHERE tid='175634' ORDER BY dateline DESC LIMIT 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 1 Rows_examined: 0
SELECT sf.*, s.* FROM uchome_space s LEFT JOIN uchome_spacefield sf ON sf.uid=s.uid WHERE s.uid='1125319';
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
use ffzl;
select downpath,id,title from phome_ecms_download where id='2038' and classid='63';
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
select tbname,checkpl from phome_enewsclass where classid='72' limit 1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
select tbname from phome_enewsclass where classid='69' limit 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use feifei;
SELECT value FROM `feifei`.uc_vars WHERE name='mailexists';
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 18
SELECT groupid, allownickname, allowcstatus, allowcusbbcode, allowsigbbcode, allowsigimgcode, maxsigsize FROM cdb_usergroups WHERE creditshigher<=0 AND 0<creditslower LIMIT 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 3 Rows_sent: 1 Rows_examined: 3
SELECT f.fid, f.fup, f.type, f.name, f.threads, f.posts, f.todayposts, f.lastpost, ff.description, ff.moderators, ff.icon, ff.viewperm FROM cdb_forums f
LEFT JOIN cdb_forumfields ff USING(fid)
WHERE f.fup='600' AND f.status>0 AND f.type='sub' ORDER BY f.displayorder;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT t.tid, t.closed, t.dateline, t.special, t.lastpost AS lastthreadpost, f.*, ff.* , f.fid AS fid
FROM cdb_threads t
INNER JOIN cdb_forums f ON f.fid=t.fid
LEFT JOIN cdb_forumfields ff ON ff.fid=f.fid
WHERE t.tid='230089' AND t.displayorder>='0' LIMIT 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 6 Rows_examined: 12
SELECT t.* FROM cdb_threads t
WHERE t.tid IN (231727,232847,235107,235313,235507,223656) AND t.displayorder IN (2, 3)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 0, 6;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT 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
FROM cdb_members As m WHERE m.uid=52702 LIMIT 0,1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 0 Rows_examined: 0
SELECT sid, uid AS sessionuid, groupid, groupid='6' AS ipbanned, pageviews AS spageviews, styleid, lastolupdate, seccode
FROM cdb_sessions WHERE sid='FFCXpG' AND CONCAT_WS('.',ip1,ip2,ip3,ip4)='220.232.100.192';
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 3 Rows_sent: 1 Rows_examined: 0
use ffzl;
select tbname,checkpl from phome_enewsclass where classid='72' limit 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
use feifei;
SELECT 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
FROM cdb_members As m WHERE m.uid=1 LIMIT 0,1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
use ffzl;
select tbname,checkpl from phome_enewsclass where classid='64' limit 1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
select tbname,checkpl from phome_enewsclass where classid='63' limit 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
use feifei;
SELECT tid, fid, price, special FROM cdb_threads WHERE tid='141152' AND displayorder>='0';
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT 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_memberfields AS mf WHERE uid=662104 LIMIT 0,1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT 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
FROM cdb_members As m WHERE m.uid=926352 LIMIT 0,1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT 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_memberfields AS mf WHERE uid=656861 LIMIT 0,1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 3 Rows_examined: 3
SELECT p.*
FROM cdb_posts p
WHERE p.tid=190564 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 30 Rows_examined: 791
SELECT t.* FROM cdb_threads t
WHERE t.fid='607' AND t.displayorder IN (0, 1)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 30;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT 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
FROM cdb_members As m WHERE m.uid=988621 LIMIT 0,1;
主要是DZ应用池内存使用异常 其他2个网站有时候也异常 慢查询日志非常多FROM cdb_members m LEFT JOIN cdb_usergroups u USING (groupid)
WHERE m.uid='998075';
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
INSERT INTO cdb_sessions (sid, ip1, ip2, ip3, ip4, uid, username, groupid, styleid, invisible, action, lastactivity, lastolupdate, seccode, fid, tid)
VALUES ('BULe3Q', '124', '72', '220', '248', '0', '', '7', '31', '0', '254', '1254486244', '0', '767473', '0', '0');
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
use ffzl;
select downpath,id,title from phome_ecms_download where id='2170' and classid='63';
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
select tbname from phome_enewsclass where classid='63' limit 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
use feifei;
SELECT * FROM cdb_threads t WHERE tid='219661' AND displayorder>='0';
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 1 Rows_examined: 0
use ffzl;
select tbname,checkpl from phome_enewsclass where classid='63' limit 1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 1 Rows_examined: 0
select tbname from phome_enewsclass where classid='63' limit 1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 1 Rows_examined: 0
select tbname from phome_enewsclass where classid='73' limit 1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 1 Rows_examined: 0
select tbname from phome_enewsclass where classid='73' limit 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
use feifei;
SELECT 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_memberfields AS mf WHERE uid=525547 LIMIT 0,1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 0 Rows_examined: 0
use ffzl;
update phome_ecms_download set onclick=onclick+1 where id='2186';
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
use feifei;
SELECT 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_memberfields AS mf WHERE uid=433792 LIMIT 0,1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 1
SELECT uid AS moduid, username AS modusername, dateline AS moddateline, action AS modaction, magicid
FROM cdb_threadsmod
WHERE tid='175634' ORDER BY dateline DESC LIMIT 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 1 Rows_examined: 0
SELECT sf.*, s.* FROM uchome_space s LEFT JOIN uchome_spacefield sf ON sf.uid=s.uid WHERE s.uid='1125319';
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
use ffzl;
select downpath,id,title from phome_ecms_download where id='2038' and classid='63';
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
select tbname,checkpl from phome_enewsclass where classid='72' limit 1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
select tbname from phome_enewsclass where classid='69' limit 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
use feifei;
SELECT value FROM `feifei`.uc_vars WHERE name='mailexists';
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 18
SELECT groupid, allownickname, allowcstatus, allowcusbbcode, allowsigbbcode, allowsigimgcode, maxsigsize FROM cdb_usergroups WHERE creditshigher<=0 AND 0<creditslower LIMIT 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 3 Rows_sent: 1 Rows_examined: 3
SELECT f.fid, f.fup, f.type, f.name, f.threads, f.posts, f.todayposts, f.lastpost, ff.description, ff.moderators, ff.icon, ff.viewperm FROM cdb_forums f
LEFT JOIN cdb_forumfields ff USING(fid)
WHERE f.fup='600' AND f.status>0 AND f.type='sub' ORDER BY f.displayorder;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT t.tid, t.closed, t.dateline, t.special, t.lastpost AS lastthreadpost, f.*, ff.* , f.fid AS fid
FROM cdb_threads t
INNER JOIN cdb_forums f ON f.fid=t.fid
LEFT JOIN cdb_forumfields ff ON ff.fid=f.fid
WHERE t.tid='230089' AND t.displayorder>='0' LIMIT 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 6 Rows_examined: 12
SELECT t.* FROM cdb_threads t
WHERE t.tid IN (231727,232847,235107,235313,235507,223656) AND t.displayorder IN (2, 3)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 0, 6;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT 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
FROM cdb_members As m WHERE m.uid=52702 LIMIT 0,1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 0 Rows_examined: 0
SELECT sid, uid AS sessionuid, groupid, groupid='6' AS ipbanned, pageviews AS spageviews, styleid, lastolupdate, seccode
FROM cdb_sessions WHERE sid='FFCXpG' AND CONCAT_WS('.',ip1,ip2,ip3,ip4)='220.232.100.192';
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 3 Rows_sent: 1 Rows_examined: 0
use ffzl;
select tbname,checkpl from phome_enewsclass where classid='72' limit 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
use feifei;
SELECT 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
FROM cdb_members As m WHERE m.uid=1 LIMIT 0,1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
use ffzl;
select tbname,checkpl from phome_enewsclass where classid='64' limit 1;
# User@Host: ffzl[ffzl] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
select tbname,checkpl from phome_enewsclass where classid='63' limit 1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 1 Rows_examined: 0
use feifei;
SELECT tid, fid, price, special FROM cdb_threads WHERE tid='141152' AND displayorder>='0';
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT 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_memberfields AS mf WHERE uid=662104 LIMIT 0,1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT 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
FROM cdb_members As m WHERE m.uid=926352 LIMIT 0,1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT 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_memberfields AS mf WHERE uid=656861 LIMIT 0,1;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 3 Rows_examined: 3
SELECT p.*
FROM cdb_posts p
WHERE p.tid=190564 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 30 Rows_examined: 791
SELECT t.* FROM cdb_threads t
WHERE t.fid='607' AND t.displayorder IN (0, 1)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 30;
# User@Host: feifeibbs[feifeibbs] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT 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
FROM cdb_members As m WHERE m.uid=988621 LIMIT 0,1;
解决方案 »
- 写一个触发器
- sql server 批量添加问题
- 请问连接远程sql服务器,返回错误信息:Connection reset,怎么回事?
- inner join 和 left join 的问题
- SQL SERVER 2000 支持 XML schema 不?
- 紧急,数据库日志满如何释放?
- 如何实现数据库记录的自动合并?求救于各位大吓。高分相送!
- 请教:怎样实现"定时同步两个(同一服务器)数据库的数据"?在线给分
- VFP:在用户确认(密码)中,为什么locate for 语句不能找到所要的字段值?(表中已有数据)
- sqlDbx 中文版,绝对强大的工具,顺便散散分...
- 补树断链的问题求解???
- 怎么做网站数据库
把数据和结果贴出来