MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 100 ms No. DB Queries: 12
PHP Processing Time: 19 ms (18.71%) DB Processing Time: 81 ms (81.29%)
Extensions Used: mysqli, xml Global.php Processing Time: 15 ms
PHP Version: 7.2.34 Server Load: 1.43
GZip Encoding Status: Enabled No. Templates Used: 112 (112 Cached / 0 Manually Loaded)
Memory Usage: 2 MB (2097152 bytes) Memory Limit: 512M

Database Connections (1 Total)

[READ] mknex0_mybbs@localhost (Connected in 535 μ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 38
Query Time: 1 ms

#2 - Write Query
REPLACE INTO mybb_sessions SET `uid`=0,`sid`='4836a7ed184a984c19499ae337e80f5d',`time`=1768813596,`ip`=X'126109a8',`location`='/forums/portal.php?debug=1',`useragent`='CCBot/2.0 (https://commoncrawl.org/faq/)',`location1`=0,`location2`=0,`nopermission`=0
Query Time: 706 μs

#3 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'portal' ,'portal_welcome_membertext' ,'portal_stats' ,'portal_search' ,'portal_whosonline_memberbit' ,'portal_whosonline' ,'portal_latestthreads_thread' ,'portal_latestthreads' ,'portal_announcement_numcomments_no' ,'postbit_attachments_thumbnails_thumbnail' ,'postbit_attachments_images_image' ,'postbit_attachments_attachment' ,'postbit_attachments_thumbnails' ,'postbit_attachments_images' ,'postbit_attachments' ,'multipage' ,'multipage_end' ,'multipage_jump_page' ,'multipage_nextpage' ,'multipage_page' ,'multipage_page_current' ,'multipage_page_link_current' ,'multipage_prevpage' ,'multipage_start' ,'portal_announcement_send_item' ,'portal_stats_nobody' ,'portal_announcement_avatar' ,'portal_announcement_numcomments' ,'portal_announcement_icon' ,'portal_pms' ,'portal_welcome' ,'portal_announcement' ,'portal_welcome_guesttext' ,'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','1') ORDER BY sid ASC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates ALL sid 996 Using where; Using filesort
Query Time: 3 ms

#4 - 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: 417 μs

#5 - 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 2 Using where
Query Time: 367 μs

#6 - Select Query
SELECT COUNT(DISTINCT ip) AS guestcount FROM mybb_sessions WHERE uid = 0 AND time > 1768812696
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_sessions range time,uid time 4 3041 Using index condition; Using where
Query Time: 36 ms

#7 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, u.username, u.invisible, u.usergroup, u.displaygroup FROM mybb_sessions s LEFT JOIN mybb_users u ON (s.uid=u.uid) WHERE (s.uid != 0 OR SUBSTR(s.sid,4,1) = '=') AND s.time > 1768812696 ORDER BY u.username ASC, s.time DESC
Table Type Possible Keys Key Key Length Ref Rows Extra
s range time,uid time 4 3041 Using index condition; Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 mknex0_mybbs.s.uid 1
Query Time: 30 ms

#8 - Select Query
SELECT t.tid, t.fid, t.uid, t.lastpost, t.lastposteruid, t.lastposter, t.subject, t.replies, t.views, u.username FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid=t.uid) WHERE 1=1 AND t.fid NOT IN (15) AND t.fid NOT IN (7,57,51,16,15,14,57,47,46,24,20,30,36,18,27,39,40,38,31,23,42,29,19,35,22,34,49,32,44,17,26,28,25,21,37,41,33,43,45,48) AND t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.lastpost DESC LIMIT 0, 6
Table Type Possible Keys Key Key Length Ref Rows Extra
t index fid lastpost 6 6 Using where
u eq_ref PRIMARY PRIMARY 4 mknex0_mybbs.t.uid 1
Query Time: 790 μs

#9 - Select Query
SELECT LOWER(url) AS url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (2)) OR (idtype=4 AND id IN (4917,4916,4915,4914,4920,4918)) OR (idtype=3 AND id IN (11,12)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo range idtype,active active 7 9 Using index condition
Query Time: 665 μs

#10 - Select Query
SELECT COUNT(t.tid) AS threads FROM mybb_threads t WHERE t.visible='1' AND t.fid IN (10,11,12) AND t.fid NOT IN (15) AND t.fid NOT IN (7,57,51,16,15,14,57,47,46,24,20,30,36,18,27,39,40,38,31,23,42,29,19,35,22,34,49,32,44,17,26,28,25,21,37,41,33,43,45,48) AND t.closed NOT LIKE 'moved|%' LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
t range fid fid 3 987 Using index condition; Using where
Query Time: 6 ms

#11 - Select Query
SELECT p.pid, p.message, p.tid, p.smilieoff, t.attachmentcount FROM mybb_posts p LEFT JOIN mybb_threads t ON (t.tid=p.tid) WHERE t.visible='1' AND t.fid IN (10,11,12) AND t.fid NOT IN (15) AND t.fid NOT IN (7,57,51,16,15,14,57,47,46,24,20,30,36,18,27,39,40,38,31,23,42,29,19,35,22,34,49,32,44,17,26,28,25,21,37,41,33,43,45,48) AND t.closed NOT LIKE 'moved|%' AND t.firstpost=p.pid ORDER BY t.dateline DESC LIMIT 0, 6
Table Type Possible Keys Key Key Length Ref Rows Extra
t index PRIMARY,fid,firstpost dateline 4 29 Using where
p eq_ref PRIMARY,tid,tiddate PRIMARY 4 mknex0_mybbs.t.firstpost 1 Using where
Query Time: 633 μs

#12 - Select Query
SELECT t.*, t.username AS threadusername, u.username, u.avatar, u.avatardimensions FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.tid IN (0,'4920','4918','4917','4916','4915','4914') AND t.fid IN (10,11,12) AND t.fid NOT IN (15) AND t.fid NOT IN (7,57,51,16,15,14,57,47,46,24,20,30,36,18,27,39,40,38,31,23,42,29,19,35,22,34,49,32,44,17,26,28,25,21,37,41,33,43,45,48) AND t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.dateline DESC LIMIT 0, 6
Table Type Possible Keys Key Key Length Ref Rows Extra
t range PRIMARY,fid PRIMARY 4 7 Using index condition; Using where; Using filesort
u eq_ref PRIMARY PRIMARY 4 mknex0_mybbs.t.uid 1
Query Time: 704 μs

Template Statistics

Templates Used (Loaded for this Page) - 112 Total
error, error_inline, error_inline_item, error_nopermission, error_nopermission_loggedin, footer, footer_showteamlink, 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_modqueue, global_modqueue_notice, 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_guest_login_modal_lockout, header_welcomeblock_member, header_welcomeblock_member_admin, header_welcomeblock_member_moderator, header_welcomeblock_member_buddy, header_welcomeblock_member_pms, header_welcomeblock_member_search, header_welcomeblock_member_user, multipage, multipage_end, multipage_jump_page, multipage_nextpage, multipage_page, multipage_page_current, multipage_page_link_current, multipage_prevpage, multipage_start, 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, portal, portal_announcement, portal_announcement_avatar, portal_announcement_icon, portal_announcement_numcomments, portal_announcement_numcomments_no, portal_announcement_send_item, portal_latestthreads, portal_latestthreads_thread, portal_pms, portal_search, portal_stats, portal_stats_nobody, portal_welcome, portal_welcome_guesttext, portal_welcome_membertext, portal_whosonline, portal_whosonline_memberbit, postbit_attachments, postbit_attachments_attachment, postbit_attachments_images, postbit_attachments_images_image, postbit_attachments_thumbnails, postbit_attachments_thumbnails_thumbnail, modal, modal_button, smilieinsert, smilieinsert_getmore, smilieinsert_row, smilieinsert_row_empty, smilieinsert_smilie, usercp_themeselector_option, video_metacafe_embed, video_dailymotion_embed, video_facebook_embed, video_liveleak_embed, video_myspacetv_embed, video_youtube_embed, video_mixer_embed, video_vimeo_embed, video_yahoo_embed, debug_summary, gobutton, headerinclude, htmldoctype, redirect, task_image, smilie