Forum Home代码:
SELECT sessionhash, userid, lastactivity, location FROM mxb_session WHERE (sessionhash='dd73ee61aacc6a014f114616de8e241c' AND host='127.0.0.1')
SELECT ue.*,u.*,ue.id AS expandid FROM mxb_user u LEFT JOIN mxb_userexpand ue USING(id) WHERE u.id='1'
SELECT t.*, p.pagetext, p.hidepost, f.name AS forumname FROM mxb_thread t LEFT JOIN mxb_forum f ON (f.id=t.forumid) LEFT JOIN mxb_post p ON (p.pid=t.firstpostid) WHERE 1=1 AND t.forumid IN (-1,1,7,3,2,9,10,11,12,13,14,4,5,6,8) ORDER BY t.dateline DESC LIMIT 0, 20
UPDATE mxb_session SET username='admin', userid=1, usergroupid=4, inforum=0, inthread=0, invisible=0, lastactivity=1162405592, location='/1_1_thangcanhdep/diendan/rss.php?limit=20', badlocation=0, mobile=0 WHERE sessionhash='dd73ee61aacc6a014f114616de8e241c'
SELECT * FROM mxb_cron WHERE enabled = 1 AND nextrun <= 1162405593 ORDER BY nextrun ASC
UPDATE mxb_cron SET nextrun=1162409220 WHERE cronid =1
DELETE FROM mxb_antispam WHERE dateline < 1162383993
DELETE FROM mxb_session WHERE lastactivity < 1162404693
DELETE FROM mxb_search WHERE dateline < 1162319193
INSERT INTO mxb_cronlog (`title`, `dateline`, `description`) VALUES ('Hourly Cleanup', '1162405593', 'Failed validation number, session, search cleared')
UPDATE mxb_cron SET nextrun=1162409220 WHERE cronid =7
SELECT u.joindate, u.id, u.membergroupids, u.posts, u.reputation, u.usergroupid, u.name, up.joinusergroupid, up.posts AS jumpposts, up.reputation AS jumpreputation, up.date AS jumpdate, up.type, up.strategy, up.date_sign, up.posts_sign, up.reputation_sign, u.reputation FROM mxb_user u LEFT JOIN mxb_userpromotion up ON (u.usergroupid = up.usergroupid) WHERE u.lastactivity >= 1162319193
INSERT INTO mxb_cronlog (`title`, `dateline`, `description`) VALUES ('User Promotion', '1162405593', 'Member level executed.')
UPDATE mxb_cron SET nextrun=1162409220 WHERE cronid =11
SELECT * FROM mxb_thread WHERE sticky = 2 ORDER BY lastpost DESC
INSERT INTO mxb_cronlog (`title`, `dateline`, `description`) VALUES ('Rebuilt Global Sticky', '1162405593', 'Global sticky recached')
UPDATE mxb_cron SET nextrun=1162420020 WHERE cronid =8
SELECT u.id, u.name, u.usergroupid, u.cash, u.bank, u.reputation, e.loanreturn, e.loanamount, e.loaninterest FROM mxb_userextra e LEFT JOIN mxb_user u ON (e.id = u.id) WHERE e.loanamount > 0 AND e.loanreturn < 1162405593
INSERT INTO mxb_cronlog (`title`, `dateline`, `description`) VALUES ('Loan Check & Execution', '1162405593', 'Loan check and force execution compleated.')
UPDATE mxb_cron SET nextrun=1162486800 WHERE cronid =4
SELECT * FROM mxb_setting WHERE varname IN ( 'birthday_send', 'birthday_send_type' )
SELECT ue.*, u.id, u.name, u.email, u.usergroupid, u.birthday FROM mxb_user u LEFT JOIN mxb_userexpand ue USING (id) WHERE u.birthday LIKE '%-11-02'
INSERT INTO mxb_cronlog (`title`, `dateline`, `description`) VALUES ('Birthday List', '1162405593', '0 birthday members cached')
UPDATE mxb_cron SET nextrun=1162486800 WHERE cronid =12
UPDATE mxb_forum SET todaypost=0
SELECT count(pid) as post FROM mxb_post WHERE moderate != 1
SELECT count(tid) as thread FROM mxb_thread WHERE visible = 1
SELECT count(id) as users FROM mxb_user WHERE usergroupid <> 2
SELECT id, name FROM mxb_user WHERE usergroupid <> 2 ORDER BY id DESC LIMIT 0, 1
SELECT * FROM mxb_ad WHERE (endtime =0 OR endtime >= 1162405593) AND starttime <= 1162405593 ORDER BY type, displayorder
SELECT * FROM mxb_forum ORDER BY parentid, displayorder
UPDATE mxb_cron SET nextrun=1162486800 WHERE cronid =13
SELECT nextrun FROM mxb_cron WHERE filename = 'refreshjs.php'
SELECT * FROM mxb_javascript WHERE nextrun <= 1162486800 AND refresh != 0
SELECT * FROM mxb_javascript WHERE nextrun > 1162486800 AND refresh != 0 ORDER BY nextrun LIMIT 0, 1
UPDATE mxb_cron SET nextrun=1162490400 WHERE cronid =2
SELECT count(pid) as post FROM mxb_post WHERE moderate != 1
SELECT count(tid) as thread FROM mxb_thread WHERE visible = 1
SELECT count(id) as users FROM mxb_user WHERE usergroupid <> 2
SELECT id, name FROM mxb_user WHERE usergroupid <> 2 ORDER BY id DESC LIMIT 0, 1
SELECT SUM(todaypost) AS todaypost FROM mxb_forum
INSERT INTO mxb_cronlog (`title`, `dateline`, `description`) VALUES ('Daily Forum Stat', '1162405593', 'Forum stats updated')
SELECT nextrun FROM mxb_cron WHERE enabled = 1 ORDER BY nextrun ASC LIMIT 0, 1
Total: 43 mysql query (23 SELECT query). What is "3 queries"??? :bored:
此帖由 114v 在 2006-11-02 02:40 进行编辑...