D:\ZkeysSoft\MySql\MySQL Server 5.0\bin\mysqld-nt.exe, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
# Time: 091002 13:36:25
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 15 Rows_examined: 15
use feifei;
SELECT p.*
FROM cdb_posts p
WHERE p.tid=220297 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=175808 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
# Time: 091002 13:36:29
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=183233 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
# Time: 091002 13:36:30
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=214207 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
# Time: 091002 13:36:32
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 6 Rows_examined: 6
SELECT * FROM uchome_userapp WHERE uid='721232' ORDER BY menuorder DESC;
# Time: 091002 13:36:33
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=142984 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 12 Rows_examined: 12
SELECT p.*
FROM cdb_posts p
WHERE p.tid=235392 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 3 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=999625 LIMIT 0,1;
# Time: 091002 13:36:34
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 8 Rows_examined: 8
SELECT p.*
FROM cdb_posts p
WHERE p.tid=222973 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
# Time: 091002 13:36:35
@ localhost [127.0.0.1]
# Query_time: 3 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=648556 LIMIT 0,1;
# Time: 091002 13:36:36
@ localhost [127.0.0.1]
# Query_time: 3 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=957032 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 0 Rows_sent: 9 Rows_examined: 9
SELECT p.*
FROM cdb_posts p
WHERE p.tid=62352 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
# Time: 091002 13:36:37
@ localhost [127.0.0.1]
# Query_time: 7 Lock_time: 0 Rows_sent: 34 Rows_examined: 3456
SELECT t.* FROM cdb_threads t
WHERE t.fid='21' AND t.displayorder IN (0, 1)
ORDER BY displayorder DESC, dateline DESC
LIMIT 34;
@ localhost [127.0.0.1]
# Query_time: 11 Lock_time: 1 Rows_sent: 1 Rows_examined: 77
SELECT count(*) FROM `feifei`.uc_pms WHERE (related='0' AND msgfromid>'0' OR msgfromid='0') AND msgtoid='604507' AND folder='inbox' AND new='1';
@ localhost [127.0.0.1]
# Query_time: 15 Lock_time: 0 Rows_sent: 1 Rows_examined: 77
SELECT count(*) FROM `feifei`.uc_pms WHERE (related='0' AND msgfromid>'0' OR msgfromid='0') AND msgtoid='604507' AND folder='inbox' AND new='1';
# Time: 091002 13:36:40
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 5 Rows_examined: 5
SELECT p.*
FROM cdb_posts p
WHERE p.tid=219353 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
# Time: 091002 13:36:42
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT a.*, p.invisible FROM cdb_attachments a LEFT JOIN cdb_posts p ON a.pid=p.pid WHERE aid='248732';
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 0 Rows_examined: 0
SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, m.uid AS discuz_uid, m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques,
m.adminid, m.groupid, m.groupexpiry, m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, 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.timeformat, m.dateformat, m.pmsound, m.sigstatus, m.invisible,
m.lastvisit, m.lastactivity, m.lastpost, m.prompt, m.accessmasks, m.editormode, m.customshow, m.customaddfeed
FROM cdb_sessions s, cdb_members m
WHERE m.uid=s.uid AND s.sid='1rnLLo' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='222.216.82.237' AND m.uid='158280'
AND m.password='dd928376a287fc89babd31720a89a44e' AND m.secques='';
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 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=287380 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 3 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=995451 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 3 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=1123377 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 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=888143 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 3
SELECT COUNT(*) FROM cdb_posts WHERE tid='224151' AND dateline<='1254375399';
# Time: 091002 13:36:43
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT count, lastupdate FROM cdb_failedlogins WHERE ip='59.175.204.238';
@ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT a.*, p.invisible FROM cdb_attachments a LEFT JOIN cdb_posts p ON a.pid=p.pid WHERE aid='248732';
# Time: 091002 13:36:44
@ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 1 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=94709 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 1 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=683919 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 0 Rows_sent: 5 Rows_examined: 5
SELECT p.*
FROM cdb_posts p
WHERE p.tid=110626 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
# Time: 091002 13:36:45
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 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='659452';
@ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 2 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=15498 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 0 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=166120 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 6 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=179896 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 8 Lock_time: 0 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=166120 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 7 Lock_time: 0 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=161063 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 6 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=871265 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 7 Lock_time: 2 Rows_sent: 0 Rows_examined: 0
SELECT s.sid, s.styleid, s.groupid='6' AS ipbanned, s.pageviews AS spageviews, s.lastolupdate, s.seccode, m.uid AS discuz_uid, m.username AS discuz_user, m.password AS discuz_pw, m.secques AS discuz_secques,
m.adminid, m.groupid, m.groupexpiry, m.extgroupids, m.email, m.timeoffset, m.tpp, m.ppp, 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.timeformat, m.dateformat, m.pmsound, m.sigstatus, m.invisible,
m.lastvisit, m.lastactivity, m.lastpost, m.prompt, m.accessmasks, m.editormode, m.customshow, m.customaddfeed
FROM cdb_sessions s, cdb_members m
WHERE m.uid=s.uid AND s.sid='H56pOC' AND CONCAT_WS('.',s.ip1,s.ip2,s.ip3,s.ip4)='60.175.112.250' AND m.uid='1189833'
AND m.password='5c230e5fa09467b055437ce7f0ecc324' AND m.secques='';
# Time: 091002 13:36:49
@ localhost [127.0.0.1]
# Query_time: 3 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=581857 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 3 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=377954 LIMIT 0,1;
# Time: 091002 13:36:50
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT sid, groupid, groupid='6' AS ipbanned, pageviews AS spageviews, styleid, lastolupdate, seccode
FROM cdb_sessions WHERE sid='eaEEEl' AND CONCAT_WS('.',ip1,ip2,ip3,ip4)='61.164.97.68';
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 34 Rows_examined: 34
SELECT t.* FROM cdb_threads t
WHERE t.fid='308' AND t.displayorder IN (0, 1)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 34;
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT tid, fid, price, special FROM cdb_threads WHERE tid='231172' AND displayorder>='0';
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
DELETE FROM cdb_sessions WHERE sid='4CvQcT' OR lastactivity<(1254461800-1800) OR ('0'<>'0' AND uid='0') OR (uid='0' AND ip1='222' AND ip2='222' AND ip3='127' AND ip4='86' AND lastactivity>1254461800-60);
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
UPDATE cdb_sessions SET uid='0', username='', groupid='7', styleid='31', invisible='0', action='6', lastactivity='1254461800', lastolupdate='0', seccode='441962', fid='0', tid='0' WHERE sid='OJMJtj';
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 11 Rows_examined: 11
SELECT p.*
FROM cdb_posts p
WHERE p.tid=235588 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ 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='136464' AND t.displayorder>='0' LIMIT 1;
@ localhost [127.0.0.1]
# Query_time: 3 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=508170 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 3 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=617778 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 0 Rows_examined: 0
SELECT sid, groupid, groupid='6' AS ipbanned, pageviews AS spageviews, styleid, lastolupdate, seccode
FROM cdb_sessions WHERE sid='CDCGcG' AND CONCAT_WS('.',ip1,ip2,ip3,ip4)='219.131.69.58';
@ 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=916927 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 3 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=995451 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 3 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='145453' ORDER BY dateline DESC LIMIT 1;
@ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 1 Rows_sent: 12 Rows_examined: 12
SELECT p.*
FROM cdb_posts p
WHERE p.tid=196973 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 40 Rows_examined: 6410
SELECT t.* FROM cdb_threads t
WHERE t.fid='4' AND t.displayorder IN (0, 1)
ORDER BY t.displayorder DESC, t.dateline DESC
LIMIT 34, 40;
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 1
SELECT p.*
FROM cdb_posts p
WHERE p.tid=233060 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=88975 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 3 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=742532 LIMIT 0,1;
# Time: 091002 13:36:53
@ localhost [127.0.0.1]
# Query_time: 3 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=1185999 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 3 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=93164 LIMIT 0,1;
@ 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='191493' AND t.displayorder>='0' LIMIT 1;
@ localhost [127.0.0.1]
# Query_time: 3 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=813433 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 30 Rows_examined: 95
SELECT t.* FROM cdb_threads t
WHERE t.fid='654' AND t.displayorder IN (0, 1)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 30;
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 0
SELECT a.*, p.invisible FROM cdb_attachments a LEFT JOIN cdb_posts p ON a.pid=p.pid WHERE aid='249851';
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 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=726471 LIMIT 0,1;
@ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 2 Rows_sent: 4 Rows_examined: 4
SELECT * FROM uchome_space WHERE uid IN (23520, 6, 19974, 23696, 16576, 11419, 1350, 1186759, 94966, 39383);
@ localhost [127.0.0.1]
# Query_time: 8 Lock_time: 2 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=226359 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 0 Rows_sent: 10 Rows_examined: 10
SELECT p.*
FROM cdb_posts p
WHERE p.tid=196844 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 5 Lock_time: 2 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=235313 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
# Time: 091002 13:36:54
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 34 Rows_examined: 34
SELECT t.* FROM cdb_threads t
WHERE t.fid='22' AND t.displayorder IN (0, 1)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 34;
@ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 3 Rows_examined: 3
SELECT p.*
FROM cdb_posts p
WHERE p.tid=235169 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 463
SELECT COUNT(*) FROM cdb_threads WHERE fid='4' AND typeid='4' AND displayorder>='0';
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 35 Rows_examined: 1164
SELECT t.* FROM cdb_threads t
WHERE t.fid='147' AND t.displayorder IN (0, 1)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 35;
# Time: 091002 13:36:55
@ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 1 Rows_sent: 35 Rows_examined: 35
SELECT t.* FROM cdb_threads t
WHERE t.fid='15' AND t.displayorder IN (0, 1)
ORDER BY displayorder DESC, lastpost DESC
LIMIT 35;
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 9 Rows_examined: 9
SELECT p.*
FROM cdb_posts p
WHERE p.tid=136464 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 1 Rows_sent: 12 Rows_examined: 12
SELECT p.*
FROM cdb_posts p
WHERE p.tid=151861 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 8 Lock_time: 3 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=36431 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 8 Lock_time: 0 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=205045 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
# Time: 091002 13:36:57
@ localhost [127.0.0.1]
# Query_time: 7 Lock_time: 0 Rows_sent: 15 Rows_examined: 15
SELECT p.*
FROM cdb_posts p
WHERE p.tid=230515 AND p.invisible=0 ORDER BY dateline LIMIT 0, 15;
@ localhost [127.0.0.1]
# Query_time: 6 Lock_time: 2 Rows_sent: 15 Rows_examined: 15
SELECT p.*
懂得人帮我分析一下 |
