MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 419 ms No. DB Queries: 28
PHP Processing Time: -42,147 μs (-10.05%) DB Processing Time: 462 ms (110.05%)
Extensions Used: mysqli, xml Global.php Processing Time: 389 ms
PHP Version: 7.2.30 Server Load: 2.64
GZip Encoding Status: Disabled No. Templates Used: 146 (142 Cached / 8 Manually Loaded)
Memory Usage: 2 MB (2097152 bytes) Memory Limit: 256M

Database Connections (1 Total)

[READ] islesaboverpg@mysql-ia.islesabove-rpg.com (Connected in 29 ms)

Database Queries (28 Total)

#1 - Select Query
SELECT title,cache FROM mybb_datacache
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_datacache ALL 49
Query Time: 188 ms

#2 - Select Query
SELECT uid FROM mybb_users WHERE username = 'test'
Table Type Possible Keys Key Key Length Ref Rows Extra
no matching row in const table
Query Time: 9 ms

#3 - Write Query
DELETE FROM mybb_sessions WHERE ip=X'4b65adec'
Query Time: 7 ms

#4 - Write Query
REPLACE INTO mybb_sessions SET `uid`=0,`sid`='c7a08210225ecaa5ed12a14266042ff0',`time`=1596938638,`ip`=X'4b65adec',`location`='/online.php?debug=1',`useragent`='CCBot/2.0 (https://commoncrawl.org/faq/)',`location1`=0,`location2`=0,`nopermission`=0
Query Time: 8 ms

#5 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'online' ,'online_row' ,'online_row_ip' ,'online_today' ,'online_today_row' ,'online_row_ip_lookup' ,'online_refresh' ,'multipage' ,'multipage_end' ,'multipage_start' ,'multipage_jump_page' ,'multipage_nextpage' ,'multipage_page' ,'multipage_page_current' ,'multipage_page_link_current' ,'multipage_prevpage' ,'' ,'accountswitcher_header_userbit' ,'accountswitcher_header_dropdown_userbit' ,'accountswitcher_header' ,'accountswitcher_header_dropdown' ,'accountswitcher_header_accountlist' ,'accountswitcher_newpm_messagebit' ,'accountswitcher_newpm_message' ,'accountswitcher_footer' ,'accountswitcher_post_userbit' ,'accountswitcher_post' ,'accountswitcher_sec_accountsbit' ,'accountswitcher_shared_accountsbit' ,'accountswitcher_sidebar_userbit' ,'accountswitcher_sidebar' ,'accountswitcher_avatar' ,'ougcawards_js' ,'ougcawards_global_menu' ,'ougcawards_global_notification' ,'ougcawards_welcomeblock' ,'ougcawards_award_image' ,'' ,'myalerts_headericon' ,'myalerts_modal' ,'myalerts_popup_row' ,'myalerts_alert_row_no_alerts' ,'myalerts_js_popup' ,'prostats' ,'prostats_readstate_icon' ,'prostats_newmembers' ,'prostats_newmembers_row' ,'prostats_topposters' ,'prostats_topposters_row' ,'prostats_topthreadposters' ,'prostats_topthreadposters_row' ,'prostats_topreferrers' ,'prostats_topreferrers_row' ,'prostats_mostthanks' ,'prostats_mostthanks_row' ,'prostats_newestposts' ,'prostats_newestposts_row' ,'prostats_newestposts_specialchar' ,'prostats_mostreplies' ,'prostats_mostreplies_row' ,'prostats_mostviews' ,'prostats_mostviews_row' ,'prostats_topdownloads' ,'prostats_topdownloads_row' ,'prostats_mostreputation' ,'prostats_mostreputation_row' ,'prostats_message' ,'prostats_onerowextra' ,'prostats_tworowextra' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_member_user' ,'header_welcomeblock_member_moderator' ,'header_welcomeblock_member_admin' ,'error' ,'global_pending_joinrequests' ,'global_awaiting_activation' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'footer_themeselect' ,'global_unreadreports' ,'footer_contactus' ,'global_boardclosed_warning' ,'global_bannedwarning' ,'error_inline' ,'error_inline_item' ,'error_nopermission_loggedin' ,'error_nopermission' ,'global_pm_alert' ,'header_menu_search' ,'header_menu_portal' ,'redirect' ,'footer_languageselect_option' ,'video_dailymotion_embed' ,'video_facebook_embed' ,'video_liveleak_embed' ,'video_metacafe_embed' ,'video_myspacetv_embed' ,'video_mixer_embed' ,'video_vimeo_embed' ,'video_yahoo_embed' ,'video_youtube_embed' ,'debug_summary' ,'smilieinsert_row' ,'smilieinsert_row_empty' ,'smilieinsert' ,'smilieinsert_getmore' ,'smilieinsert_smilie' ,'global_board_offline_modal' ,'footer_themeselector' ,'task_image' ,'usercp_themeselector_option' ,'php_warnings' ,'mycode_code' ,'mycode_email' ,'mycode_img' ,'mycode_php' ,'mycode_quote_post' ,'mycode_size_int' ,'mycode_url' ,'global_no_permission_modal' ,'global_boardclosed_reason' ,'nav_dropdown' ,'global_remote_avatar_notice' ,'header_welcomeblock_member_pms' ,'header_welcomeblock_member_search' ,'header_welcomeblock_guest' ,'header_welcomeblock_guest_login_modal' ,'header_welcomeblock_guest_login_modal_lockout' ,'header_menu_calendar' ,'header_menu_memberlist' ,'global_dst_detection' ,'header_quicksearch' ,'smilie') AND sid IN ('-2','-1','3') ORDER BY sid ASC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 423 Using index condition
Query Time: 91 ms

#6 - Select Query
SELECT tid, name, pid, allowedgroups FROM mybb_themes WHERE pid!='0'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_themes ALL 4 Using where
Query Time: 1 ms

#7 - Select Query
SELECT COUNT(sid) as online FROM mybb_sessions WHERE time > 1596937738
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_sessions range time time 4 2 Using index condition
Query Time: 2 ms

#8 - Select Query
SELECT DISTINCT s.sid, s.ip, s.uid, s.time, s.location, u.username, s.nopermission, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time>'1596937738' ORDER BY IF( s.uid >0, 1, 0 ) DESC, s.time DESC LIMIT 0, 20
Table Type Possible Keys Key Key Length Ref Rows Extra
s range time time 4 2 Using index condition; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 islesaboverpg.s.uid 1
Query Time: 3 ms

(Plugin Hook: pre_output_page)
#9 - Select Query
SELECT t.subject,t.username,t.uid,t.tid,t.fid,t.lastpost,t.lastposter,t.lastposteruid,t.replies,t.visible,tr.uid AS truid,tr.dateline,tp.displaystyle AS styledprefix,f.name FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='0') LEFT JOIN mybb_threadprefixes tp ON (tp.pid = t.prefix) LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE (t.visible = '1' ) AND t.fid NOT IN (21,10,18,22,23,'21','22','23','10','18') AND t.closed NOT LIKE 'moved|%' AND t.visible != '-2' AND f.active = '1' ORDER BY t.lastpost DESC LIMIT 0,50
Table Type Possible Keys Key Key Length Ref Rows Extra
t ALL fid 13 Using where; Using filesort
tr eq_ref tid tid 8 islesaboverpg.t.tid,const 1
tp eq_ref PRIMARY PRIMARY 4 islesaboverpg.t.prefix 1 Using where
f eq_ref PRIMARY PRIMARY 2 islesaboverpg.t.fid 1 Using where
Query Time: 8 ms

(Plugin Hook: pre_output_page)
#10 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_latest_posts' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 5 ms

(Plugin Hook: pre_output_page)
#11 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_date' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 7 ms

(Plugin Hook: pre_output_page)
#12 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_last_sender' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 7 ms

(Plugin Hook: pre_output_page)
#13 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_forum' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 7 ms

(Plugin Hook: pre_output_page)
#14 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 8 ms

(Plugin Hook: pre_output_page)
#15 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_latest_posts' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 6 ms

(Plugin Hook: pre_output_page)
#16 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_date' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 6 ms

(Plugin Hook: pre_output_page)
#17 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_last_sender' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 2 ms

(Plugin Hook: pre_output_page)
#18 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_forum' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 2 ms

(Plugin Hook: pre_output_page)
#19 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '3'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 3 ms

(Plugin Hook: pre_output_page)
#20 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7 ms

(Plugin Hook: pre_output_page)
#21 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 9 ms

(Plugin Hook: pre_output_page)
#22 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 8 ms

(Plugin Hook: pre_output_page)
#23 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 9 ms

(Plugin Hook: pre_output_page)
#24 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7 ms

(Plugin Hook: pre_output_page)
#25 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 7 ms

(Plugin Hook: pre_output_page)
#26 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 6 ms

(Plugin Hook: pre_output_page)
#27 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 8 ms

(Plugin Hook: pre_output_page)
#28 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 2 ms

Template Statistics

Templates Used (Loaded for this Page) - 146 Total
accountswitcher_avatar, accountswitcher_footer, accountswitcher_header, accountswitcher_header_accountlist, accountswitcher_header_dropdown, accountswitcher_header_dropdown_userbit, accountswitcher_header_userbit, accountswitcher_newpm_message, accountswitcher_newpm_messagebit, accountswitcher_post, accountswitcher_post_userbit, accountswitcher_sec_accountsbit, accountswitcher_shared_accountsbit, accountswitcher_sidebar, accountswitcher_sidebar_userbit, debug_summary, error, error_inline, error_inline_item, error_nopermission, error_nopermission_loggedin, footer, footer_contactus, footer_languageselect, footer_languageselect_option, footer_themeselect, footer_themeselector, global_awaiting_activation, global_bannedwarning, global_boardclosed_reason, global_boardclosed_warning, global_board_offline_modal, global_dst_detection, global_no_permission_modal, global_pending_joinrequests, global_pm_alert, global_remote_avatar_notice, global_unreadreports, gobutton, header, headerinclude, header_menu_calendar, header_menu_memberlist, header_menu_portal, header_menu_search, header_quicksearch, header_welcomeblock_guest, header_welcomeblock_guest_login_modal, header_welcomeblock_guest_login_modal_lockout, header_welcomeblock_member, header_welcomeblock_member_admin, header_welcomeblock_member_moderator, header_welcomeblock_member_pms, header_welcomeblock_member_search, header_welcomeblock_member_user, htmldoctype, multipage, multipage_end, multipage_jump_page, multipage_nextpage, multipage_page, multipage_page_current, multipage_page_link_current, multipage_prevpage, multipage_start, myalerts_alert_row_no_alerts, myalerts_headericon, myalerts_js_popup, mycode_code, mycode_email, mycode_img, mycode_php, mycode_quote_post, mycode_size_int, mycode_url, nav, nav_bit, nav_bit_active, nav_dropdown, nav_sep, nav_sep_active, online, online_refresh, online_row, online_row_ip, online_row_ip_lookup, online_today, online_today_row, ougcawards_award_image, ougcawards_global_menu, ougcawards_global_notification, ougcawards_js, ougcawards_welcomeblock, php_warnings, redirect, smilie, smilieinsert, smilieinsert_getmore, smilieinsert_row, smilieinsert_row_empty, smilieinsert_smilie, task_image, usercp_themeselector_option, video_dailymotion_embed, video_facebook_embed, video_liveleak_embed, video_metacafe_embed, video_mixer_embed, video_myspacetv_embed, video_vimeo_embed, video_yahoo_embed, video_youtube_embed, prostats, prostats_message, prostats_mostreplies, prostats_mostreplies_row, prostats_mostreputation, prostats_mostreputation_row, prostats_mostthanks, prostats_mostthanks_row, prostats_mostviews, prostats_mostviews_row, prostats_newestposts, prostats_newestposts_row, prostats_newestposts_specialchar, prostats_newmembers, prostats_newmembers_row, prostats_onerowextra, prostats_readstate_icon, prostats_topdownloads, prostats_topdownloads_row, prostats_topposters, prostats_topposters_row, prostats_topreferrers, prostats_topreferrers_row, prostats_topthreadposters, prostats_topthreadposters_row, prostats_tworowextra, prostats_newestposts_head_latest_posts, prostats_newestposts_head_date, prostats_newestposts_head_last_sender, prostats_newestposts_head_forum, prostats_newestposts_latest_posts, prostats_newestposts_date, prostats_newestposts_last_sender, prostats_newestposts_forum

Templates Requiring Additional Calls (Not Cached at Startup) - 8 Total
prostats_newestposts_head_latest_posts, prostats_newestposts_head_date, prostats_newestposts_head_last_sender, prostats_newestposts_head_forum, prostats_newestposts_latest_posts, prostats_newestposts_date, prostats_newestposts_last_sender, prostats_newestposts_forum