Page Generation Statistics | |||
Page Generation Time: | 0.193706989288 seconds | No. DB Queries: | 12 |
PHP Processing Time: | 0.1907437 seconds (98.47%) | DB Processing Time: | 0.0029633 seconds (1.53%) |
Extensions Used: | mysql, xml | Global.php Processing Time: | 0.0369959 seconds |
PHP Version: | 5.2.17 | Server Load: | 1.6 |
GZip Encoding Status: | Disabled | No. Templates Used: | 39 (46 Cached / 1 Manually Loaded) |
Memory Usage: | 10.25 MB (10747904 bytes) | Memory Limit: | 128M |
[READ] garrysmo_forum@localhost (Connected in 0s) |
#1 - Write Query |
SET NAMES 'utf8' |
Query Time: 5.00679016113E-5 |
#2 - Select Query |
|||||||
SELECT value, name FROM mybb_settings ORDER BY title ASC | |||||||
table | type | possible_keys | key | key_len | ref | rows | Extra |
mybb_settings | ALL | 333 | Using filesort | ||||
Query Time: 0.000110864639282 |
#3 - Select Query |
|||||||
SELECT * FROM mybb_sessions WHERE sid='93c3785d32720243da1828f9fb5552b7' AND ip='85.237.167.172' LIMIT 1 | |||||||
table | type | possible_keys | key | key_len | ref | rows | Extra |
mybb_sessions | const | PRIMARY,ip | PRIMARY | 98 | const | 1 | |
Query Time: 0.000149965286255 |
#4 - Select Query |
|||||||
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='118' LIMIT 1 | |||||||
table | type | possible_keys | key | key_len | ref | rows | Extra |
u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
f | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Query Time: 0.000321865081787 |
#5 - Write Query |
UPDATE mybb_sessions SET `uid`='118', `time`='1313311749', `location`='/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/535.1 (KHTML, like Gecko) Chrome/13.0.782.112 Safari', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='93c3785d32720243da1828f9fb5552b7' LIMIT 1 |
Query Time: 0.000350952148438 |
(Plugin Hook: global_start) #6 - Select Query |
|||||||
SELECT * FROM mybb_ems ORDER BY `order` ASC | |||||||
table | type | possible_keys | key | key_len | ref | rows | Extra |
mybb_ems | system | 1 | |||||
Query Time: 0.000114917755127 |
(Plugin Hook: global_start) #7 - Select Query |
|||||||
SELECT template FROM mybb_templates WHERE title='boardmessage_styles' AND sid IN ('-2','-1','') ORDER BY sid DESC LIMIT 1 | |||||||
table | type | possible_keys | key | key_len | ref | rows | Extra |
mybb_templates | ALL | 2076 | Using where; Using filesort | ||||
Query Time: 9.82284545898E-5 |
#8 - Select Query |
|||||||
SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE tid='48' LIMIT 1 | |||||||
table | type | possible_keys | key | key_len | ref | rows | Extra |
mybb_themes | const | PRIMARY | PRIMARY | 2 | const | 1 | |
Query Time: 0.000955104827881 |
#9 - Select Query |
|||||||
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_welcomemembertext' ,'index_welcomeguest' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'index_modcolumn' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_welcomeguesttext' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_pms' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'css' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'' ,'global_pending_joinrequests' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error') AND sid IN ('-2','-1','34') ORDER BY sid ASC | |||||||
table | type | possible_keys | key | key_len | ref | rows | Extra |
mybb_templates | ALL | 2076 | Using where; Using filesort | ||||
Query Time: 8.9168548584E-5 |
#10 - Select Query |
|||||||
SELECT COUNT(uid) as total FROM mybb_joinrequests WHERE gid IN (0,4) | |||||||
table | type | possible_keys | key | key_len | ref | rows | Extra |
Impossible WHERE noticed after reading const tables | |||||||
Query Time: 4.10079956055E-5 |
#11 - Select Query |
|||||||
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1313310849' ORDER BY u.username ASC, s.time DESC | |||||||
table | type | possible_keys | key | key_len | ref | rows | Extra |
s | range | time | time | 8 | 6 | Using where; Using temporary; Using filesort | |
u | eq_ref | PRIMARY | PRIMARY | 4 | garrysmo_forum.s.uid | 1 | |
Query Time: 0.000323057174683 |
#12 - Select Query |
|||||||
SELECT f.*, fr.dateline AS lastread FROM mybb_forums f LEFT JOIN mybb_forumsread fr ON (fr.fid=f.fid AND fr.uid='118') WHERE f.active != 0 ORDER BY pid, disporder | |||||||
table | type | possible_keys | key | key_len | ref | rows | Extra |
f | ALL | 70 | Using where; Using filesort | ||||
fr | eq_ref | fid | fid | 8 | garrysmo_forum.f.fid,const | 1 | |
Query Time: 0.000121116638184 |
Templates Used (Loaded for this Page) - 39 Total |
boardmessage_styles, global_pm_alert, index, header_welcomeblock_member, header_welcomeblock_member_moderator, header_welcomeblock_member_admin, redirect, gobutton, forumbit_depth2_forum, forumbit_depth3, forumbit_depth3_statusicon, forumbit_subforums, footer, headerinclude, nav_sep, nav_sep_active, header_welcomeblock_guest, header, forumbit_depth1_cat, global_unreadreports, global_pending_joinrequests, index_loginform, index_whosonline, index_stats, index_birthdays_birthday, forumbit_moderators, index_birthdays, index_logoutlink, error, index_whosonline_memberbit, forumbit_depth2_cat, nav, nav_bit, nav_bit_active, htmldoctype, footer_languageselect, index_boardstats, forumbit_depth2_forum_lastpost, forumbit_depth1_forum_lastpost |
Templates Requiring Additional Calls (Not Cached at Startup) - 1 Total |
boardmessage_styles |