MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 53 ms No. DB Queries: 16
PHP Processing Time: 44 ms (81.70%) DB Processing Time: 10 ms (18.30%)
Extensions Used: mysqli, xml Global.php Processing Time: 46 ms
PHP Version: 7.1.33 Server Load: 8.24
GZip Encoding Status: Disabled No. Templates Used: 89 (90 Cached / 0 Manually Loaded)
Memory Usage: 8 MB (8388608 bytes) Memory Limit: 256M

Database Connections (1 Total)

[READ] [email protected] (Connected in 840 μs)

Database Queries (16 Total)

#1 - Select Query
SELECT title,cache FROM mybb_datacache
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_datacache ALL 46
Query Time: 648 μs

#2 - Write Query
DELETE FROM mybb_sessions WHERE ip=X'035320ab'
Query Time: 360 μs

#3 - Write Query
REPLACE INTO mybb_sessions SET `uid`=0,`sid`='b63fe6428e98b6c3b4dc94def022ee9b',`time`=1579319803,`ip`=X'035320ab',`location`='/stats.php?debug=1',`useragent`='CCBot/2.0 (https://commoncrawl.org/faq/)',`location1`=0,`location2`=0,`nopermission`=0
Query Time: 217 μs

#4 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'stats' ,'stats_thread' ,'stats_topforum' ,'' ,'global_share' ,'global_share_twitter' ,'global_share_facebook_header' ,'global_share_facebook' ,'global_share_google_header' ,'global_share_google' ,'global_share_linkedin' ,'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_showteamlink' ,'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' ,'global_modqueue' ,'global_modqueue_notice' ,'header_welcomeblock_member_buddy' ,'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' ,'modal' ,'modal_button') AND sid IN ('-2','-1','8') ORDER BY sid ASC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates ALL sid 1307 Using where; Using filesort
Query Time: 5 ms

#5 - Select Query
SELECT permissions, uid FROM mybb_adminoptions WHERE (uid='0' OR uid='-1') AND permissions != '' ORDER BY uid DESC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_adminoptions range PRIMARY PRIMARY 4 2 Using where
Query Time: 255 μs

#6 - Select Query
SELECT regdate FROM mybb_users ORDER BY regdate LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users ALL 112 Using filesort
Query Time: 620 μs

#7 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (372)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 158 μs

#8 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (369)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 116 μs

#9 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (368)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 109 μs

#10 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (371)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 109 μs

#11 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (367)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 141 μs

#12 - Select Query
SELECT uid, username, referrals FROM mybb_users WHERE referrals>0 ORDER BY referrals DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users ALL 112 Using where; Using filesort
Query Time: 235 μs

#13 - Select Query
SELECT u.uid, u.username, COUNT(*) AS poststoday FROM mybb_posts p LEFT JOIN mybb_users u ON (p.uid=u.uid) WHERE p.dateline > 1579233403 AND p.visible=1 GROUP BY p.uid ORDER BY poststoday DESC
Table Type Possible Keys Key Key Length Ref Rows Extra
p range visible,dateline dateline 4 2 Using index condition; Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 u670226841_yvygy.p.uid 1
Query Time: 348 μs

#14 - Select Query
SELECT COUNT(uid) AS posters FROM mybb_users WHERE postnum>0
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users ALL 112 Using where
Query Time: 225 μs

#15 - Write Query
REPLACE INTO mybb_datacache SET `title`='statistics',`cache`='a:4:{s:4:\"time\";i:1579319803;s:12:\"top_referrer\";a:3:{s:3:\"uid\";s:1:\"4\";s:8:\"username\";s:7:\"skol360\";s:9:\"referrals\";s:2:\"65\";}s:10:\"top_poster\";a:0:{}s:7:\"posters\";s:2:\"43\";}'
Query Time: 146 μs

#16 - Select Query
SELECT fid, name, threads, posts FROM mybb_forums WHERE type='f'AND fid NOT IN (1,8,20,43,53,55,30,34,31,35,50,5,54,9,27,29,15,10,11,16,32,12,13,14,21,22,23,52) ORDER BY posts DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_forums ALL PRIMARY 33 Using where; Using filesort
Query Time: 383 μs

Template Statistics

Templates Used (Loaded for this Page) - 89 Total
footer_showteamlink, error_inline_item, error, error_inline, error_nopermission, error_nopermission_loggedin, footer, footer_contactus, footer_languageselect, footer_languageselect_option, footer_themeselect, footer_themeselector, 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, global_awaiting_activation, header, header_menu_calendar, header_menu_memberlist, header_menu_portal, header_menu_search, header_quicksearch, header_welcomeblock_guest, header_welcomeblock_guest_login_modal, header_welcomeblock_member, header_welcomeblock_member_buddy, header_welcomeblock_member_admin, header_welcomeblock_member_moderator, header_welcomeblock_member_pms, header_welcomeblock_member_search, header_welcomeblock_member_user, 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, modal_button, php_warnings, modal, smilieinsert, smilieinsert_getmore, smilieinsert_row, smilieinsert_row_empty, smilieinsert_smilie, stats, stats_thread, stats_topforum, usercp_themeselector_option, video_metacafe_embed, video_dailymotion_embed, video_facebook_embed, video_liveleak_embed, video_myspacetv_embed, video_youtube_embed, video_vimeo_embed, video_yahoo_embed, debug_summary, gobutton, headerinclude, htmldoctype, redirect, task_image, smilie, header_welcomeblock_guest_login_modal_lockout, video_mixer_embed, global_modqueue, global_modqueue_notice, global_share, global_share_twitter, global_share_facebook_header, global_share_facebook, global_share_google_header, global_share_google, global_share_linkedin