Discuz! X1.5 20110627 / php:5.3.8
firefox:8.0 mozilla:5.0
Memory usage 6,598,704 bytes, peak 7,097,528 bytes / Queries 13 in 0.220896s / Include files 16 / ModID forum::viewthread
[TOP] Queries Ajax Queries Envionment Include Files $_COOKIE | update.php
Memory usage 6,598,704 bytes, peak 7,097,528 bytes / Queries 13 in 0.220896s / Include files 16 / ModID forum::viewthread
[TOP] Queries Ajax Queries Envionment Include Files $_COOKIE | update.php
Queries: 13
0.001243s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('smilies','smileytypes','forums','usergroups','ranks','stamps','bbcodes','custominfo','groupicon','threadtableids','threadtable_info','usergroup_7','setting','style_default','cronnextrun')
0.000553s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('usergroup_10')
0.000905s • SELECT t.tid, t.closed, f.*, ff.* , f.fid AS fid
FROM pre_forum_thread t
INNER JOIN pre_forum_forum f ON f.fid=t.fid
LEFT JOIN pre_forum_forumfield ff ON ff.fid=f.fid
WHERE t.tid='29802' AND (t.displayorder>='0' OR (t.displayorder IN ('-4', '-3', '-2') AND t.authorid='0')) LIMIT 1
0.000608s • SELECT * FROM pre_forum_thread t WHERE tid='29802' AND (displayorder>='0' )
0.000654s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('threadsort_option_3','threadsort_template_3')
0.000310s • SELECT optionid, value, expiration FROM pre_forum_typeoptionvar WHERE tid='29802'
0.000584s • UPDATE LOW_PRIORITY pre_forum_thread SET views=views+1 WHERE tid='29802'
0.057817s • SELECT p.*
FROM pre_forum_post p
WHERE p.tid='29802' AND p.invisible='0' ORDER BY p.dateline LIMIT 0, 10
0.000545s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('bbcodes_display','smileycodes','icons','domainwhitelist')
0.107385s • SELECT m.uid, m.username, m.groupid, m.adminid, m.regdate, m.credits, m.email, m.status AS memberstatus,
ms.lastactivity, ms.lastactivity, ms.invisible AS authorinvisible,
mc.*, mp.gender, mp.site, mp.icq, mp.qq, mp.yahoo, mp.msn, mp.taobao, mp.alipay,
mf.medals, mf.sightml AS signature, mf.customstatus
FROM pre_common_member m
LEFT JOIN pre_common_member_field_forum mf USING(uid)
LEFT JOIN pre_common_member_status ms USING(uid)
LEFT JOIN pre_common_member_count mc USING(uid)
LEFT JOIN pre_common_member_profile mp USING(uid)
WHERE m.uid IN ('10540','14531','14440','13419')
0.000567s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('advs')
0.000471s • UPDATE pre_common_session SET `sid`='1b5JG2',`ip1`='127',`ip2`='0',`ip3`='0',`ip4`='1',`uid`='0',`username`='',`groupid`='7',`invisible`='0',`action`='2',`lastactivity`='1322638850',`fid`='17',`tid`='29802',`lastolupdate`='0' WHERE sid='1b5JG2'
-
0.000534s • SELECT * FROM pre_common_session WHERE sid='1b5JG2' AND CONCAT_WS('.', ip1,ip2,ip3,ip4)='127.0.0.1'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | pre_common_session | system | sid | 1 |
File | Line | Function |
source\class\class_core.php | 661 | db_mysql->query() |
source\class\class_core.php | 863 | db_mysql->fetch_first() |
source\class\class_core.php | 823 | DB->_execute() |
source\class\class_core.php | 1024 | DB->fetch_first() |
source\class\class_core.php | 331 | discuz_session->init() |
source\class\class_core.php | 68 | discuz_core->_init_session() |
forum.php | 50 | discuz_core->init() |
0.001243s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('smilies','smileytypes','forums','usergroups','ranks','stamps','bbcodes','custominfo','groupicon','threadtableids','threadtable_info','usergroup_7','setting','style_default','cronnextrun')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | pre_common_syscache | range | PRIMARY | PRIMARY | 66 | 15 | Using where |
File | Line | Function |
source\class\class_core.php | 863 | db_mysql->query() |
source\class\class_core.php | 837 | DB::_execute() |
source\function\function_core.php | 617 | DB::query() |
source\function\function_core.php | 557 | cachedata() |
source\class\class_core.php | 524 | loadcache() |
source\class\class_core.php | 69 | discuz_core->_init_setting() |
forum.php | 50 | discuz_core->init() |
0.000553s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('usergroup_10')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | pre_common_syscache | const | PRIMARY | PRIMARY | 66 | const | 1 |
File | Line | Function |
source\class\class_core.php | 863 | db_mysql->query() |
source\class\class_core.php | 837 | DB::_execute() |
source\function\function_core.php | 617 | DB::query() |
source\function\function_core.php | 557 | cachedata() |
source\class\class_core.php | 531 | loadcache() |
source\class\class_core.php | 69 | discuz_core->_init_setting() |
forum.php | 50 | discuz_core->init() |
0.000905s • SELECT t.tid, t.closed, f.*, ff.* , f.fid AS fid
FROM pre_forum_thread t
INNER JOIN pre_forum_forum f ON f.fid=t.fid
LEFT JOIN pre_forum_forumfield ff ON ff.fid=f.fid
WHERE t.tid='29802' AND (t.displayorder>='0' OR (t.displayorder IN ('-4', '-3', '-2') AND t.authorid='0')) LIMIT 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | t | const | PRIMARY,displayorder,typeid,authorid | PRIMARY | 3 | const | 1 | |
1 | SIMPLE | f | const | PRIMARY | PRIMARY | 3 | const | 1 | |
1 | SIMPLE | ff | const | PRIMARY | PRIMARY | 3 | const | 1 |
File | Line | Function |
source\class\class_core.php | 661 | db_mysql->query() |
source\class\class_core.php | 863 | db_mysql->fetch_first() |
source\class\class_core.php | 823 | DB::_execute() |
source\function\function_forum.php | 425 | DB::fetch_first() |
forum.php | 52 | loadforum() |
0.000608s • SELECT * FROM pre_forum_thread t WHERE tid='29802' AND (displayorder>='0' )
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | t | const | PRIMARY | PRIMARY | 3 | const | 1 |
File | Line | Function |
source\class\class_core.php | 661 | db_mysql->query() |
source\class\class_core.php | 863 | db_mysql->fetch_first() |
source\class\class_core.php | 823 | DB::_execute() |
source\module\forum\forum_viewthread.php | 33 | DB::fetch_first() |
forum.php | 59 | require() |
0.000654s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('threadsort_option_3','threadsort_template_3')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | pre_common_syscache | range | PRIMARY | PRIMARY | 66 | 2 | Using where |
File | Line | Function |
source\class\class_core.php | 863 | db_mysql->query() |
source\class\class_core.php | 837 | DB::_execute() |
source\function\function_core.php | 617 | DB::query() |
source\function\function_core.php | 557 | cachedata() |
source\function\function_threadsort.php | 267 | loadcache() |
source\module\forum\forum_viewthread.php | 175 | threadsortshow() |
forum.php | 59 | require() |
0.000310s • SELECT optionid, value, expiration FROM pre_forum_typeoptionvar WHERE tid='29802'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | pre_forum_typeoptionvar | ref | tid | tid | 3 | const | 11 |
File | Line | Function |
source\class\class_core.php | 863 | db_mysql->query() |
source\class\class_core.php | 837 | DB::_execute() |
source\function\function_threadsort.php | 273 | DB::query() |
source\module\forum\forum_viewthread.php | 175 | threadsortshow() |
forum.php | 59 | require() |
0.000584s • UPDATE LOW_PRIORITY pre_forum_thread SET views=views+1 WHERE tid='29802'
File | Line | Function |
source\class\class_core.php | 863 | db_mysql->query() |
source\class\class_core.php | 837 | DB::_execute() |
source\module\forum\forum_viewthread.php | 715 | DB::query() |
source\module\forum\forum_viewthread.php | 331 | viewthread_updateviews() |
forum.php | 59 | require() |
0.057817s • SELECT p.*
FROM pre_forum_post p
WHERE p.tid='29802' AND p.invisible='0' ORDER BY p.dateline LIMIT 0, 10
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | p | ref | invisible,displayorder,first | displayorder | 4 | const,const | 9 | Using where |
File | Line | Function |
source\class\class_core.php | 863 | db_mysql->query() |
source\class\class_core.php | 837 | DB::_execute() |
source\module\forum\forum_viewthread.php | 468 | DB::query() |
forum.php | 59 | require() |
0.000545s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('bbcodes_display','smileycodes','icons','domainwhitelist')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | pre_common_syscache | range | PRIMARY | PRIMARY | 66 | 4 | Using where |
File | Line | Function |
source\class\class_core.php | 863 | db_mysql->query() |
source\class\class_core.php | 837 | DB::_execute() |
source\function\function_core.php | 617 | DB::query() |
source\function\function_core.php | 557 | cachedata() |
source\function\function_post.php | 466 | loadcache() |
source\module\forum\forum_viewthread.php | 475 | messagecutstr() |
forum.php | 59 | require() |
0.107385s • SELECT m.uid, m.username, m.groupid, m.adminid, m.regdate, m.credits, m.email, m.status AS memberstatus,
ms.lastactivity, ms.lastactivity, ms.invisible AS authorinvisible,
mc.*, mp.gender, mp.site, mp.icq, mp.qq, mp.yahoo, mp.msn, mp.taobao, mp.alipay,
mf.medals, mf.sightml AS signature, mf.customstatus
FROM pre_common_member m
LEFT JOIN pre_common_member_field_forum mf USING(uid)
LEFT JOIN pre_common_member_status ms USING(uid)
LEFT JOIN pre_common_member_count mc USING(uid)
LEFT JOIN pre_common_member_profile mp USING(uid)
WHERE m.uid IN ('10540','14531','14440','13419')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | m | range | PRIMARY | PRIMARY | 3 | 4 | Using where | |
1 | SIMPLE | mf | eq_ref | PRIMARY | PRIMARY | 3 | ultrax.m.uid | 1 | |
1 | SIMPLE | ms | eq_ref | PRIMARY | PRIMARY | 3 | ultrax.m.uid | 1 | |
1 | SIMPLE | mc | eq_ref | PRIMARY | PRIMARY | 3 | ultrax.m.uid | 1 | |
1 | SIMPLE | mp | eq_ref | PRIMARY | PRIMARY | 3 | ultrax.m.uid | 1 |
File | Line | Function |
source\class\class_core.php | 863 | db_mysql->query() |
source\class\class_core.php | 837 | DB::_execute() |
source\module\forum\forum_viewthread.php | 501 | DB::query() |
forum.php | 59 | require() |
0.000567s • SELECT /*!40001 SQL_CACHE */ * FROM pre_common_syscache WHERE cname IN ('advs')
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
1 | SIMPLE | pre_common_syscache | const | PRIMARY | PRIMARY | 66 | const | 1 |
File | Line | Function |
source\class\class_core.php | 863 | db_mysql->query() |
source\class\class_core.php | 837 | DB::_execute() |
source\function\function_core.php | 617 | DB::query() |
source\function\function_core.php | 557 | cachedata() |
source\function\function_core.php | 1420 | loadcache() |
data\template\1_diy_forum_viewthread.tpl.php | 143 | adshow() |
source\module\forum\forum_viewthread.php | 673 | include() |
forum.php | 59 | require() |
0.000471s • UPDATE pre_common_session SET `sid`='1b5JG2',`ip1`='127',`ip2`='0',`ip3`='0',`ip4`='1',`uid`='0',`username`='',`groupid`='7',`invisible`='0',`action`='2',`lastactivity`='1322638850',`fid`='17',`tid`='29802',`lastolupdate`='0' WHERE sid='1b5JG2'
File | Line | Function |
source\class\class_core.php | 863 | db_mysql->query() |
source\class\class_core.php | 837 | DB->_execute() |
source\class\class_core.php | 800 | DB->query() |
source\class\class_core.php | 1072 | DB->update() |
source\function\function_core.php | 61 | discuz_session->update() |
data\template\1_diy_forum_viewthread.tpl.php | 1035 | updatesession() |
source\module\forum\forum_viewthread.php | 673 | include() |
forum.php | 59 | require() |