MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 28 ms No. DB Queries: 12
PHP Processing Time: 18 ms (64.01%) DB Processing Time: 10 ms (35.99%)
Extensions Used: mysqli, xml Global.php Processing Time: 20 ms
PHP Version: 7.1.31 Server Load: 0.37
GZip Encoding Status: Enabled No. Templates Used: 157 (160 Cached / 0 Manually Loaded)
Memory Usage: 4 MB (4194304 bytes) Memory Limit: 128M

Database Connections (1 Total)

[READ] us_db_agexpl@localhost (Connected in 220 μs)

Database Queries (12 Total)

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

#2 - Select Query
SELECT uid FROM mybb_users WHERE username = 'test'
Table Type Possible Keys Key Key Length Ref Rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 100 μs

#3 - Write Query
DELETE FROM mybb_sessions WHERE ip=X'22efa23d'
Query Time: 164 μs

#4 - Write Query
REPLACE INTO mybb_sessions SET `uid`=0,`sid`='422e364c47b449f3d465c7ca48ff8ffc',`time`=1566042241,`ip`=X'22efa23d',`location`='/forumdisplay.php?fid=81&debug=1',`useragent`='CCBot/2.0 (https://commoncrawl.org/faq/)',`location1`=81,`location2`=0,`nopermission`=0
Query Time: 101 μs

(Plugin Hook: global_start)
#5 - Select Query
SELECT VERSION() as version
Table Type Possible Keys Key Key Length Ref Rows Extra
No tables used
Query Time: 70 μs

(Plugin Hook: global_start)
#6 - Write Query
SHOW FULL TABLES FROM `db_agexpl` WHERE table_type = 'BASE TABLE' AND `Tables_in_db_agexpl` = 'mybb_alerts'
Query Time: 431 μs

#7 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'forumdisplay' ,'forumdisplay_thread' ,'forumbit_depth1_cat' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumdisplay_subforums' ,'forumdisplay_threadlist' ,'forumdisplay_moderatedby' ,'forumdisplay_searchforum' ,'forumdisplay_thread_rating' ,'forumdisplay_threadlist_rating' ,'forumbit_depth1_forum_lastpost' ,'forumdisplay_thread_multipage_page' ,'forumdisplay_thread_multipage' ,'forumdisplay_thread_multipage_more' ,'forumdisplay_thread_gotounread' ,'forumbit_depth2_forum_lastpost' ,'forumdisplay_rules_link' ,'forumdisplay_orderarrow' ,'forumdisplay_newthread' ,'multipage' ,'multipage_breadcrumb' ,'multipage_end' ,'multipage_jump_page' ,'multipage_nextpage' ,'multipage_page' ,'multipage_page_current' ,'multipage_page_link_current' ,'multipage_prevpage' ,'multipage_start' ,'forumdisplay_thread_unapproved_posts' ,'forumdisplay_nothreads' ,'forumjump_advanced' ,'forumjump_special' ,'forumjump_bit' ,'forumdisplay_password_wrongpass' ,'forumdisplay_password' ,'forumdisplay_inlinemoderation_custom_tool' ,'forumbit_subforums' ,'forumbit_moderators' ,'forumbit_depth2_forum_lastpost_never' ,'forumbit_depth2_forum_lastpost_hidden' ,'forumdisplay_usersbrowsing_user' ,'forumdisplay_usersbrowsing' ,'forumdisplay_inlinemoderation' ,'forumdisplay_thread_modbit' ,'forumdisplay_inlinemoderation_col' ,'forumdisplay_inlinemoderation_selectall' ,'forumdisplay_threadlist_clearpass' ,'forumdisplay_thread_rating_moved' ,'forumdisplay_announcements_announcement' ,'forumdisplay_announcements' ,'forumdisplay_threads_sep' ,'forumbit_depth3_statusicon' ,'forumbit_depth3' ,'forumdisplay_sticky_sep' ,'forumdisplay_thread_attachment_count' ,'forumdisplay_rssdiscovery' ,'forumbit_moderators_group' ,'forumdisplay_inlinemoderation_openclose' ,'forumdisplay_inlinemoderation_stickunstick' ,'forumdisplay_inlinemoderation_softdelete' ,'forumdisplay_inlinemoderation_restore' ,'forumdisplay_inlinemoderation_delete' ,'forumdisplay_inlinemoderation_manage' ,'forumdisplay_nopermission' ,'forumbit_depth2_forum_unapproved_posts' ,'forumbit_depth2_forum_unapproved_threads' ,'forumbit_moderators_user' ,'forumdisplay_inlinemoderation_standard' ,'forumdisplay_threadlist_prefixes_prefix' ,'forumdisplay_threadlist_prefixes' ,'forumdisplay_thread_icon' ,'forumdisplay_rules' ,'forumdisplay_thread_deleted' ,'forumdisplay_announcements_announcement_modbit' ,'forumbit_depth2_forum_viewers' ,'forumdisplay_threadlist_sortrating' ,'forumdisplay_inlinemoderation_custom' ,'forumdisplay_announcement_rating' ,'forumdisplay_inlinemoderation_approveunapprove' ,'myalerts_headericon' ,'myalerts_modal' ,'myalerts_popup_row' ,'myalerts_alert_row_no_alerts' ,'myalerts_js_popup' ,'' ,'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','20') ORDER BY sid ASC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates ALL sid 2382 Using where; Using filesort
Query Time: 7 ms

#8 - 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 6 Using where
Query Time: 95 μs

#9 - Select Query
SELECT * FROM mybb_forums WHERE active != 0 ORDER BY pid, disporder
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_forums ALL 84 Using where; Using filesort
Query Time: 587 μs

#10 - Select Query
SELECT s.ip, s.uid, u.username, s.time, u.invisible, u.usergroup, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE s.time > '1566041341' AND location1='81' AND nopermission != 1 ORDER BY u.username ASC, s.time DESC
Table Type Possible Keys Key Key Length Ref Rows Extra
s ref location,time location 4 const 1 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 db_agexpl.s.uid 1
Query Time: 201 μs

#11 - Select Query
SELECT COUNT(tid) AS threads FROM mybb_threads WHERE fid = '81' AND visible='1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads ref fid fid 3 const,const 1
Query Time: 100 μs

#12 - Select Query
SELECT t.*, (t.totalratings/t.numratings) AS averagerating, t.username AS threadusername, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='81' AND t.visible='1' ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 25
Table Type Possible Keys Key Key Length Ref Rows Extra
t ref fid fid 3 const,const 1 Using where; Using filesort
u eq_ref PRIMARY PRIMARY 4 db_agexpl.t.uid 1
Query Time: 141 μs

Template Statistics

Templates Used (Loaded for this Page) - 157 Total
error_inline_item, error, error_inline, error_nopermission, error_nopermission_loggedin, footer, footer_contactus, footer_languageselect, footer_languageselect_option, footer_themeselect, footer_themeselector, forumbit_depth1_cat, forumbit_depth1_forum_lastpost, forumbit_depth2_cat, forumbit_depth2_forum, forumbit_depth2_forum_lastpost, forumbit_depth2_forum_lastpost_hidden, forumbit_depth2_forum_lastpost_never, forumbit_depth2_forum_unapproved_posts, forumbit_depth2_forum_unapproved_threads, forumbit_depth2_forum_viewers, forumbit_depth3, forumbit_depth3_statusicon, forumbit_moderators, forumbit_moderators_group, forumbit_moderators_user, forumbit_subforums, forumdisplay, forumdisplay_announcement_rating, forumdisplay_announcements, forumdisplay_announcements_announcement, forumdisplay_announcements_announcement_modbit, forumdisplay_inlinemoderation, forumdisplay_inlinemoderation_approveunapprove, forumdisplay_inlinemoderation_col, forumdisplay_inlinemoderation_custom, forumdisplay_inlinemoderation_custom_tool, forumdisplay_inlinemoderation_delete, forumdisplay_inlinemoderation_manage, forumdisplay_inlinemoderation_openclose, forumdisplay_inlinemoderation_restore, forumdisplay_inlinemoderation_selectall, forumdisplay_inlinemoderation_softdelete, forumdisplay_inlinemoderation_standard, forumdisplay_inlinemoderation_stickunstick, forumdisplay_moderatedby, forumdisplay_newthread, forumdisplay_nopermission, forumdisplay_nothreads, forumdisplay_orderarrow, forumdisplay_password, forumdisplay_password_wrongpass, forumdisplay_rssdiscovery, forumdisplay_rules, forumdisplay_rules_link, forumdisplay_searchforum, forumdisplay_sticky_sep, forumdisplay_subforums, forumdisplay_thread, forumdisplay_thread_attachment_count, forumdisplay_thread_gotounread, forumdisplay_thread_icon, forumdisplay_thread_modbit, forumdisplay_thread_multipage, forumdisplay_thread_multipage_more, forumdisplay_thread_multipage_page, forumdisplay_thread_rating, forumdisplay_thread_rating_moved, forumdisplay_thread_unapproved_posts, forumdisplay_threadlist, forumdisplay_threadlist_clearpass, forumdisplay_threadlist_prefixes, forumdisplay_threadlist_prefixes_prefix, forumdisplay_threadlist_rating, forumdisplay_threadlist_sortrating, forumdisplay_threads_sep, forumdisplay_usersbrowsing, forumdisplay_usersbrowsing_user, forumjump_advanced, forumjump_bit, forumjump_special, global_bannedwarning, global_boardclosed_warning, global_pending_joinrequests, global_pm_alert, 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_pms, header_welcomeblock_member_search, header_welcomeblock_member_admin, header_welcomeblock_member_moderator, multipage, multipage_breadcrumb, multipage_end, multipage_jump_page, multipage_nextpage, multipage_page, multipage_page_current, multipage_page_link_current, multipage_prevpage, multipage_start, nav, nav_bit, nav_bit_active, nav_dropdown, nav_sep, nav_sep_active, php_warnings, smilieinsert, smilieinsert_getmore, smilieinsert_smilie, 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, global_board_offline_modal, smilieinsert_row, smilieinsert_row_empty, mycode_size_int, mycode_url, mycode_quote_post, mycode_php, mycode_img, mycode_code, mycode_email, global_boardclosed_reason, global_dst_detection, global_no_permission_modal, forumdisplay_thread_deleted, global_remote_avatar_notice, header_welcomeblock_member_user, header_welcomeblock_guest_login_modal_lockout, myalerts_js_popup, myalerts_alert_row_no_alerts, myalerts_headericon, video_mixer_embed