MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 61 ms No. DB Queries: 16
PHP Processing Time: 51 ms (83.76%) DB Processing Time: 10 ms (16.24%)
Extensions Used: mysqli, xml Global.php Processing Time: 17 ms
PHP Version: 7.1.30 Server Load: 0.35
GZip Encoding Status: Enabled No. Templates Used: 113 (115 Cached / 1 Manually Loaded)
Memory Usage: 4 MB (4194304 bytes) Memory Limit: 128M

Database Connections (1 Total)

[READ] us_db_agexpl@localhost (Connected in 288 μ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 40
Query Time: 353 μ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: 89 μs

#3 - Write Query
DELETE FROM mybb_sessions WHERE ip=X'36d29ea3'
Query Time: 188 μs

#4 - Write Query
REPLACE INTO mybb_sessions SET `uid`=0,`sid`='d21c892d099f00d6af07993ae229e936',`time`=1560934146,`ip`=X'36d29ea3',`location`='/index.php?debug=1',`useragent`='CCBot/2.0 (https://commoncrawl.org/faq/)',`location1`=0,`location2`=0,`nopermission`=0
Query Time: 129 μ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: 50 μ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: 418 μs

#7 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'forumbit_moderators' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_logoutlink' ,'index_statspage' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'forumbit_depth2_forum_lastpost_never' ,'forumbit_depth2_forum_viewers' ,'forumbit_moderators_group' ,'forumbit_moderators_user' ,'forumbit_depth2_forum_lastpost_hidden' ,'forumbit_subforums' ,'forumbit_depth2_forum_unapproved_posts' ,'forumbit_depth2_forum_unapproved_threads' ,'myalerts_headericon' ,'myalerts_modal' ,'myalerts_popup_row' ,'myalerts_alert_row_no_alerts' ,'myalerts_js_popup' ,'dvz_shoutbox' ,'dvz_shoutbox_panel' ,'forumteamonline' ,'forumteamonline_row' ,'forumteamonline_row_avatar' ,'forumteamonline_row_noone' ,'forumteamonline_row_novisible' ,'forumteamonline_row_stats' ,'' ,'dvzstream_event' ,'dvzstream_event_user_avatar' ,'dvzstream_widget' ,'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 range sid sid 364 367 Using index condition
Query Time: 5 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: 102 μs

#9 - Select Query
SELECT template FROM mybb_templates WHERE title='index_showteamlink' AND sid IN ('-2','-1','20') 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: 177 μs

#10 - 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 > '1560933246' ORDER BY s.time DESC, u.username ASC
Table Type Possible Keys Key Key Length Ref Rows Extra
s range time time 4 30 Using index condition; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 db_agexpl.s.uid 1
Query Time: 473 μs

#11 - 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 82 Using where; Using filesort
Query Time: 585 μs

(Plugin Hook: index_end)
#12 - Select Query
SELECT s.*, u.username, u.usergroup, u.displaygroup, u.avatar FROM mybb_dvz_shoutbox s LEFT JOIN mybb_users u ON u.uid = s.uid WHERE s.text IS NOT NULL ORDER BY s.id DESC LIMIT 50
Table Type Possible Keys Key Key Length Ref Rows Extra
s index PRIMARY 4 50 Using where
u eq_ref PRIMARY PRIMARY 4 db_agexpl.s.uid 1 Using where
Query Time: 372 μs

#13 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.usergroup, u.displaygroup, u.uid, u.avatar, u.avatardimensions, u.invisible, g.usertitle, g.showforumteam, g.disporder FROM mybb_sessions s INNER JOIN mybb_users u ON (s.uid=u.uid) INNER JOIN mybb_usergroups g ON (u.usergroup=g.gid) WHERE s.time > 1560933246 AND g.showforumteam = '1' ORDER BY u.uid ASC, u.usergroup ASC LIMIT 0, 10
Table Type Possible Keys Key Key Length Ref Rows Extra
s range time,uid time 4 30 Using index condition; Using temporary; Using filesort
u eq_ref PRIMARY,usergroup PRIMARY 4 db_agexpl.s.uid 1
g eq_ref PRIMARY PRIMARY 2 db_agexpl.u.usergroup 1 Using where
Query Time: 425 μs

#14 - Select Query
SELECT p.pid, p.dateline, t.tid, t.subject, t.fid, t.prefix, u.uid, u.username, u.usergroup, u.displaygroup, u.avatar FROM mybb_posts p LEFT JOIN mybb_users u ON p.uid = u.uid LEFT JOIN mybb_threads t ON p.tid = t.tid LEFT JOIN mybb_forums f ON p.fid = f.fid WHERE p.pid > 0 AND p.replyto != 0 AND p.visible = 1 AND f.password = '' AND f.fid NOT IN (57,55,4,56) ORDER BY p.pid DESC LIMIT 6
Table Type Possible Keys Key Key Length Ref Rows Extra
p range PRIMARY,visible PRIMARY 4 22870 Using where
f eq_ref PRIMARY PRIMARY 2 db_agexpl.p.fid 1 Using where
u eq_ref PRIMARY PRIMARY 4 db_agexpl.p.uid 1
t eq_ref PRIMARY PRIMARY 4 db_agexpl.p.tid 1
Query Time: 343 μs

#15 - Select Query
SELECT t.tid, t.subject, t.fid, t.dateline, t.prefix, u.uid, u.username, u.usergroup, u.displaygroup, u.avatar FROM mybb_threads t LEFT JOIN mybb_users u ON t.uid = u.uid LEFT JOIN mybb_forums f ON t.fid = f.fid WHERE t.tid > 0 AND t.visible = 1 AND t.firstpost != 0 AND f.password = '' AND f.fid NOT IN (57,55,4,56) ORDER BY t.tid DESC LIMIT 6
Table Type Possible Keys Key Key Length Ref Rows Extra
t range PRIMARY,fid,firstpost PRIMARY 4 673 Using where
f eq_ref PRIMARY PRIMARY 2 db_agexpl.t.fid 1 Using where
u eq_ref PRIMARY PRIMARY 4 db_agexpl.t.uid 1
Query Time: 320 μs

#16 - Select Query
SELECT u.uid, u.regdate, u.username, u.usergroup, u.displaygroup, u.avatar FROM mybb_users u WHERE u.uid > 0 AND u.invisible = 0 ORDER BY u.uid DESC LIMIT 6
Table Type Possible Keys Key Key Length Ref Rows Extra
u range PRIMARY PRIMARY 4 114 Using where
Query Time: 144 μs

Template Statistics

Templates Used (Loaded for this Page) - 113 Total
debug_summary, dvzstream_event, dvzstream_event_user_avatar, dvzstream_widget, error, error_inline, error_inline_item, 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, forumteamonline, forumteamonline_row, forumteamonline_row_avatar, forumteamonline_row_noone, forumteamonline_row_novisible, forumteamonline_row_stats, 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, index, index_birthdays, index_birthdays_birthday, index_boardstats, index_logoutlink, index_stats, index_statspage, index_whosonline, index_whosonline_memberbit, 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, 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, dvz_shoutbox, dvz_shoutbox_panel, index_showteamlink

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