MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time:	50 ms	No. DB Queries:	14
PHP Processing Time:	22 ms (43.67%)	DB Processing Time:	28 ms (56.33%)
Extensions Used:	mysqli, xml	Global.php Processing Time:	30 ms
PHP Version:	7.2.34	Server Load:	1.84
GZip Encoding Status:	Enabled	No. Templates Used:	162 (162 Cached / 0 Manually Loaded)
Memory Usage:	2 MB (2097152 bytes)	Memory Limit:	512M

Database Connections (1 Total)

[READ] mknex0_mybbs@localhost (Connected in 388 μs)

Database Queries (14 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 - Select Query
SELECT id FROM mybb_google_seo WHERE idtype=3 AND url='mortal-kombat-1-aka-12'
Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
mybb_google_seo	const	idtype	idtype	483	const,const	1
Query Time: 428 μs

#3 - Select Query
SELECT name,fid FROM mybb_forums WHERE fid IN (12)
Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
mybb_forums	const	PRIMARY	PRIMARY	2	const	1
Query Time: 259 μs

#4 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=3 AND id<=12 AND url IN ('Mortal-Kombat-1-AKA-12','Mortal-Kombat-1-AKA-12--12') AND EXISTS(SELECT fid FROM mybb_forums WHERE fid=id) ORDER BY id ASC
Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
mybb_google_seo	range	idtype,active	idtype	483		2	Using index condition; Using where; Using filesort
mybb_forums	eq_ref	PRIMARY	PRIMARY	2	mknex0_mybbs.mybb_google_seo.id	1	Using where; Using index
Query Time: 536 μs

#5 - Write Query

REPLACE INTO mybb_sessions SET `uid`=0,`sid`='4c5d355e4b428c546501f6627f1d5dfb',`time`=1768807907,`ip`=X'126109a8',`location`='/forums/forumdisplay.php?fid=12&debug=1',`useragent`='CCBot/2.0 (https://commoncrawl.org/faq/)',`location1`=12,`location2`=0,`nopermission`=0

Query Time: 14 ms

#6 - 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_forumsort' ,'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' ,'forumdisplay_threadlist_subscription' ,'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

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

#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					2	Using where
Query Time: 316 μ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					55	Using where; Using filesort
Query Time: 547 μs

#10 - Select Query
SELECT COUNT(DISTINCT ip) AS guestcount FROM mybb_sessions WHERE uid = 0 AND time > 1768807007 AND location1 = 12 AND nopermission != 1
Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
mybb_sessions	ref\|filter	location,time,uid	location\|time	4\|4	const	446 (1%)	Using where; Using rowid filter
Query Time: 3 ms

#11 - 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.uid != 0 AND s.time > 1768807007 AND location1 = 12 AND nopermission != 1 ORDER BY u.username ASC, s.time DESC
Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
s	range	location,time,uid	uid	4		2	Using index condition; Using where; Using temporary; Using filesort
u	eq_ref	PRIMARY	PRIMARY	4	mknex0_mybbs.s.uid	1
Query Time: 657 μs

#12 - Select Query
SELECT threads, unapprovedthreads, deletedthreads FROM mybb_forums WHERE fid=12
Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
mybb_forums	const	PRIMARY	PRIMARY	2	const	1
Query Time: 398 μs

#13 - 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='12' AND (t.visible IN (1)) ORDER BY t.sticky DESC, t.lastpost desc LIMIT 0, 63
Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
t	ref	fid	fid	3	const,const	49	Using where; Using filesort
u	eq_ref	PRIMARY	PRIMARY	4	mknex0_mybbs.t.uid	1
Query Time: 1 ms

#14 - Select Query
SELECT LOWER(url) AS url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=3 AND id IN (3,7,5,6,4,8,10,9,11,51,52,50,12,16,13,15,14,53,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,56,54,55)) OR (idtype=1 AND id IN (2)) OR (idtype=4 AND id IN (4802,4920,4918,4916,4915,4914,4913,4911,4910,4905,4903,4901,4873,4864,4852,4851,4850,4848,4847,4846,4843,4842,4841,4840,4839,4837,4836,4835,4834,4831,4829,4828,4826,4825,4821,4820,4819,4818,4815,4814,4813,4808,4807,4806,4803,4801,4800,4797,4796,4795)))
Table	Type	Possible Keys	Key	Key Length	Ref	Rows	Extra
mybb_google_seo	range	idtype,active	active	7		106	Using index condition
Query Time: 2 ms

Template Statistics

Templates Used (Loaded for this Page) - 162 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, 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_forumsort, 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_deleted, 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_threadlist_subscription, forumdisplay_threads_sep, forumdisplay_usersbrowsing, forumdisplay_usersbrowsing_user, forumjump_advanced, forumjump_bit, forumjump_special, 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_breadcrumb, 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, 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