MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 81 ms No. DB Queries: 18
PHP Processing Time: 63 ms (77.27%) DB Processing Time: 18 ms (22.73%)
Extensions Used: mysqli, xml Global.php Processing Time: 70 ms
PHP Version: 7.1.33 Server Load: 9.13
GZip Encoding Status: Disabled No. Templates Used: 180 (180 Cached / 1 Manually Loaded)
Memory Usage: 8 MB (8388608 bytes) Memory Limit: 256M

Database Connections (1 Total)

[READ] [email protected] (Connected in 1 ms)

Database Queries (18 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: 1 ms

#2 - Select Query
SELECT id FROM mybb_google_seo WHERE idtype=1 AND url='varella'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype idtype 363 const,const 1
Query Time: 444 μs

#3 - Select Query
SELECT username,uid FROM mybb_users WHERE uid IN (600)
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 351 μs

#4 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=1 AND id<=600 AND url IN ('varella','varella--600') AND EXISTS(SELECT uid FROM mybb_users WHERE uid=id) ORDER BY id ASC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo range idtype,active idtype 363 2 Using index condition; Using where; Using filesort
mybb_users eq_ref PRIMARY PRIMARY 4 u670226841_yvygy.mybb_google_seo.id 1 Using index
Query Time: 431 μs

#5 - Write Query
DELETE FROM mybb_sessions WHERE ip=X'12e87d1d'
Query Time: 494 μs

#6 - Write Query
REPLACE INTO mybb_sessions SET `uid`=0,`sid`='5b69b2a40cca7ecd811878d283b0c25c',`time`=1582814921,`ip`=X'12e87d1d',`location`='/member.php?action=profile&amp;uid=600&amp;debug=1',`useragent`='CCBot/2.0 (https://commoncrawl.org/faq/)',`location1`=0,`location2`=0,`nopermission`=0
Query Time: 210 μs

#7 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'member_register' ,'member_register_hiddencaptcha' ,'member_register_coppa' ,'member_register_agreement_coppa' ,'member_register_agreement' ,'member_register_customfield' ,'member_register_requiredfields' ,'member_profile_findthreads' ,'member_loggedin_notice' ,'member_profile_away' ,'member_register_regimage' ,'member_register_regimage_recaptcha_invisible' ,'member_register_regimage_nocaptcha' ,'post_captcha_hidden' ,'post_captcha' ,'member_register_referrer' ,'member_profile_email' ,'member_profile_offline' ,'member_profile_reputation' ,'member_profile_warn' ,'member_profile_warninglevel' ,'member_profile_customfields_field' ,'member_profile_customfields' ,'member_profile_adminoptions' ,'member_profile' ,'member_profile_signature' ,'member_profile_avatar' ,'member_profile_groupimage' ,'member_profile_referrals' ,'member_profile_website' ,'member_profile_reputation_vote' ,'member_activate' ,'member_lostpw' ,'member_register_additionalfields' ,'member_profile_modoptions_manageuser' ,'member_profile_modoptions_editprofile' ,'member_profile_modoptions_banuser' ,'member_profile_modoptions_viewnotes' ,'member_profile_modoptions_editnotes' ,'member_profile_modoptions_purgespammer' ,'usercp_profile_profilefields_select_option' ,'usercp_profile_profilefields_multiselect' ,'usercp_profile_profilefields_select' ,'usercp_profile_profilefields_textarea' ,'usercp_profile_profilefields_radio' ,'member_viewnotes' ,'member_register_question' ,'member_register_question_refresh' ,'usercp_options_timezone' ,'usercp_options_timezone_option' ,'usercp_options_language_option' ,'member_profile_customfields_field_multi_item' ,'member_profile_customfields_field_multi' ,'member_profile_contact_fields_google' ,'member_profile_contact_fields_icq' ,'member_profile_contact_fields_skype' ,'member_profile_contact_fields_yahoo' ,'member_profile_pm' ,'member_profile_contact_details' ,'member_profile_banned_remaining' ,'member_profile_addremove' ,'member_emailuser_guest' ,'member_register_day' ,'usercp_options_tppselect_option' ,'postbit_warninglevel_formatted' ,'member_profile_userstar' ,'member_profile_findposts' ,'usercp_options_tppselect' ,'usercp_options_pppselect' ,'member_resetpassword' ,'member_login' ,'member_profile_online' ,'usercp_options_pppselect_option' ,'postbit_reputation_formatted' ,'member_emailuser' ,'usercp_profile_profilefields_text' ,'member_profile_modoptions_ipaddress' ,'member_profile_modoptions' ,'member_profile_banned' ,'member_register_language' ,'member_resendactivation' ,'usercp_profile_profilefields_checkbox' ,'member_register_password' ,'member_coppa_form' ,'member_profile_modoptions_manageban' ,'automedia_codebuttons' ,'automedia_codebuttons_footer' ,'automedia_codebuttons_private' ,'automedia_footer' ,'automedia_player_styles' ,'' ,'global_country' ,'member_register_country' ,'member_register_country_country' ,'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: 11 ms

#8 - 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: 606 μs

(Plugin Hook: member_profile_start)
#9 - Select Query
SELECT referrals,referrer FROM mybb_users WHERE uid=600 LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 296 μs

(Plugin Hook: member_profile_start)
#10 - Select Query
SELECT uid,username,usergroup,displaygroup FROM mybb_users WHERE referrer=600 ORDER BY uid DESC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users ALL 112 Using where; Using filesort
Query Time: 317 μs

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

(Plugin Hook: member_profile_start)
#12 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (655)))
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

(Plugin Hook: member_profile_start)
#13 - Select Query
SELECT username FROM mybb_users WHERE uid=30 LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 130 μs

(Plugin Hook: member_profile_start)
#14 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (30)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 143 μs

#15 - Select Query
SELECT * FROM mybb_users WHERE uid = '600'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 231 μs

#16 - Select Query
SELECT location,nopermission FROM mybb_sessions WHERE uid='600' AND time>'1582814021' ORDER BY time DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_sessions ref time,uid uid 4 const 1 Using where; Using filesort
Query Time: 225 μs

#17 - Select Query
SELECT template FROM mybb_templates WHERE title='member_referrals_link' AND sid IN ('-2','-1','8') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using where
Query Time: 341 μs

#18 - Select Query
SELECT * FROM mybb_userfields WHERE ufid = '600'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_userfields const PRIMARY PRIMARY 4 const 1
Query Time: 497 μs

Template Statistics

Templates Used (Loaded for this Page) - 180 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, member_activate, member_coppa_form, member_emailuser, member_emailuser_guest, member_loggedin_notice, member_login, member_lostpw, member_profile, member_profile_addremove, member_profile_adminoptions, member_profile_avatar, member_profile_away, member_profile_banned, member_profile_banned_remaining, member_profile_contact_details, member_profile_contact_fields_google, member_profile_contact_fields_icq, member_profile_contact_fields_skype, member_profile_contact_fields_yahoo, member_profile_customfields, member_profile_customfields_field, member_profile_customfields_field_multi, member_profile_customfields_field_multi_item, member_profile_email, member_profile_findposts, member_profile_findthreads, member_profile_groupimage, member_profile_modoptions, member_profile_modoptions_banuser, member_profile_modoptions_editnotes, member_profile_modoptions_editprofile, member_profile_modoptions_ipaddress, member_profile_modoptions_purgespammer, member_profile_modoptions_manageuser, member_profile_modoptions_viewnotes, member_profile_offline, member_profile_online, member_profile_pm, member_profile_referrals, member_profile_reputation, member_profile_reputation_vote, member_profile_signature, member_profile_userstar, member_profile_warn, member_profile_warninglevel, member_profile_website, member_register, member_register_additionalfields, member_register_agreement, member_register_agreement_coppa, member_register_coppa, member_register_customfield, member_register_day, member_register_hiddencaptcha, member_register_language, member_register_password, member_register_question, member_register_question_refresh, member_register_referrer, member_register_regimage, member_register_regimage_recaptcha_invisible, member_register_regimage_nocaptcha, member_register_requiredfields, member_resendactivation, member_resetpassword, member_viewnotes, 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, post_captcha, post_captcha_hidden, postbit_reputation_formatted, postbit_warninglevel_formatted, modal, smilieinsert, smilieinsert_getmore, smilieinsert_row, smilieinsert_row_empty, smilieinsert_smilie, usercp_options_language_option, usercp_options_pppselect, usercp_options_pppselect_option, usercp_options_timezone, usercp_options_timezone_option, usercp_options_tppselect, usercp_options_tppselect_option, usercp_profile_profilefields_checkbox, usercp_profile_profilefields_multiselect, usercp_profile_profilefields_radio, usercp_profile_profilefields_select, usercp_profile_profilefields_select_option, usercp_profile_profilefields_text, usercp_profile_profilefields_textarea, 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, automedia_footer, automedia_player_styles, automedia_codebuttons, automedia_codebuttons_private, automedia_codebuttons_footer, header_welcomeblock_guest_login_modal_lockout, video_mixer_embed, global_modqueue, global_modqueue_notice, member_profile_modoptions_manageban, global_share, global_share_twitter, global_share_facebook_header, global_share_facebook, global_share_google_header, global_share_google, global_share_linkedin, global_country, member_register_country, member_register_country_country, member_referrals_link

Templates Requiring Additional Calls (Not Cached at Startup) - 1 Total
member_referrals_link