MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 0.0840480327606 seconds No. DB Queries: 19
PHP Processing Time: 0.0767293 seconds (91.29%) DB Processing Time: 0.0073187 seconds (8.71%)
Extensions Used: mysqli, xml Global.php Processing Time: 0.0310020 seconds
PHP Version: 5.2.12 Server Load: Nieznany
GZip Encoding Status: Enabled No. Templates Used: 39 (44 Cached / 2 Manually Loaded)
Memory Usage: 9 MB (9437184 bytes) Memory Limit: 256M

Database Connections (1 Total)

[READ] jacerpro_wojtek@localhost (Connected in 0s)

Database Queries (19 Total)

#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.000105142593384

#2 - Select Query
SELECT * FROM mybb_sessions WHERE sid='abbe5b9b09b273961a43ae498e8cc04b' AND ip='83.26.187.104' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_sessions const PRIMARY,ip PRIMARY 98 const 1
Query Time: 0.000114917755127

#3 - Select Query
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='1' 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.000341892242432

#4 - Write Query
UPDATE mybb_sessions SET `uid`='1', `time`='1267298585', `location`='/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.9.2) Gecko/20100115 Firefox/3.6 (.NET CLR 3.5.3072', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='abbe5b9b09b273961a43ae498e8cc04b' LIMIT 1
Query Time: 0.000952005386353

#5 - Select Query
SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE tid='32' LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_themes const PRIMARY PRIMARY 2 const 1
Query Time: 6.38961791992E-5

#6 - 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' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error') AND sid IN ('-2','-1','18') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 1444 Using where; Using filesort
Query Time: 9.29832458496E-5

#7 - Select Query
SELECT * FROM mybb_google_searches ORDER BY hits DESC limit 240
table type possible_keys key key_len ref rows Extra
mybb_google_searches ALL 2355 Using filesort
Query Time: 0.000117063522339

(Plugin Hook: global_end)
#8 - Select Query
SELECT mood FROM mybb_mysb_bot WHERE bid='1'
table type possible_keys key key_len ref rows Extra
mybb_mysb_bot system PRIMARY 1
Query Time: 6.19888305664E-5

(Plugin Hook: global_end)
#9 - Select Query
SELECT bot_state FROM mybb_mysb_bot WHERE bid='1'
table type possible_keys key key_len ref rows Extra
mybb_mysb_bot system PRIMARY 1
Query Time: 4.50611114502E-5

(Plugin Hook: global_end)
#10 - Select Query
SELECT template FROM mybb_templates WHERE title='mysb_smilieinsert' AND sid IN ('-2','-1','18') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 1444 Using where; Using filesort
Query Time: 4.91142272949E-5

(Plugin Hook: global_end)
#11 - Select Query
SELECT template FROM mybb_templates WHERE title='mysb_shoutbox_bot_disabled' AND sid IN ('-2','-1','18') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
mybb_templates ALL 1444 Using where; Using filesort
Query Time: 6.69956207275E-5

#12 - 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>'1267297685' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 21 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 jacerpro_mybb.s.uid 1
Query Time: 0.000401973724365

#13 - Select Query
SELECT uid FROM mybb_sessions WHERE uid != '0' AND time > '1267297685'
table type possible_keys key key_len ref rows Extra
mybb_sessions range time,uid time 8 21 Using where
Query Time: 0.00100684165955

#14 - Select Query
SELECT LOWER(url) AS url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (1949,301,1)
table type possible_keys key key_len ref rows Extra
mybb_google_seo range idtype,active active 7 3 Using where
Query Time: 0.000452041625977

#15 - 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='1') WHERE f.active != 0 ORDER BY pid, disporder
table type possible_keys key key_len ref rows Extra
f ALL 107 Using where; Using filesort
fr eq_ref fid fid 8 jacerpro_mybb.f.fid,const 1
Query Time: 0.000172138214111

#16 - Select Query
SELECT LOWER(url) AS url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id IN (9,3,12,18,75,121,141,26,30,81,45,52,108,97,62,11,120,137,13,14,15,16,100,85,19,23,33,20,21,84,83,24,25,89,27,28,29,32,96,110,31,112,102,103,104,46,47,48,49,50,63,53,54,111,76,77,78,79,80,119,118,4,5,6,7,8,17,86,87,88,98,99,101,109,113,114,115,116,117,122,130,123,124,125,126,127,128,129,131,132,133,134,135,136,138,139,140,142,146,105,143,144,145,149,150,147,148)
table type possible_keys key key_len ref rows Extra
mybb_google_seo ref idtype,active active 3 const,const 14 Using where
Query Time: 0.000886917114258

#17 - Select Query
SELECT LOWER(url) AS url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id IN (2490,2492,2413,1507,2494,1686,78,2077,1556,2478,1543,913,1310,123,1898,2434,1291,995,28,1003,1032,2273,2462,2468,1733,1978,1945,2433,2471,2486,2166,2366,2291,2465,2361,2455,2484,2404,2483,2064,1988,2485,2365,2282,2452,2297,393,928,2010,929,1753,1272,1891,1710,1723,2241,1713,2382,2385,2441,2400,2320,2325,2304,2343,2448,2318,2344,2323,2347,2489,2429,1569,2456,2445,2444)
table type possible_keys key key_len ref rows Extra
mybb_google_seo range idtype,active active 7 76 Using where
Query Time: 0.00168585777283

#18 - Select Query
SELECT LOWER(url) AS url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (131,301,1,1949,109,1015,39,1873,1888,2,1934,1064,33,925,1917,995,1488,1640,1915,1662,1900,25,12,1691,1571,201,1117,1001,276)
table type possible_keys key key_len ref rows Extra
mybb_google_seo range idtype,active active 7 29 Using where
Query Time: 0.000155925750732

#19 - Select Query
SELECT LOWER(url) AS url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id IN (80)
table type possible_keys key key_len ref rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 0.0001540184021

Template Statistics

Templates Used (Loaded for this Page) - 39 Total
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, 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, mysb_smilieinsert, mysb_shoutbox_bot_disabled

Templates Requiring Additional Calls (Not Cached at Startup) - 2 Total
mysb_smilieinsert, mysb_shoutbox_bot_disabled