MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 46 ms No. DB Queries: 31
PHP Processing Time: 31 ms (68.86%) DB Processing Time: 14 ms (31.14%)
Extensions Used: mysqli, xml Global.php Processing Time: 25 ms
PHP Version: 7.1.33 Server Load: 0.15
GZip Encoding Status: Enabled No. Templates Used: 210 (211 Cached / 1 Manually Loaded)
Memory Usage: 2 MB (2097152 bytes) Memory Limit: 128M

Database Connections (1 Total)

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

Database Queries (31 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: 361 μ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 - Select Query
SELECT * FROM mybb_threads WHERE tid = '203'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads const PRIMARY PRIMARY 4 const 1
Query Time: 138 μs

#4 - Write Query
DELETE FROM mybb_sessions WHERE ip=X'03ead671'
Query Time: 153 μs

#5 - Write Query
REPLACE INTO mybb_sessions SET `uid`=0,`sid`='97f2a83f663d595887aad58ac40f1d03',`time`=1575675055,`ip`=X'03ead671',`location`='/showthread.php?tid=203&debug=1',`useragent`='CCBot/2.0 (https://commoncrawl.org/faq/)',`location1`=34,`location2`=203,`nopermission`=0
Query Time: 80 μs

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

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

#8 - Select Query
SELECT fid FROM mybb_threads WHERE tid = '203' LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads const PRIMARY PRIMARY 4 const 1
Query Time: 93 μs

#9 - Select Query
SELECT name FROM mybb_themestylesheets WHERE sid=330
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_themestylesheets const PRIMARY PRIMARY 4 const 1
Query Time: 98 μs

#10 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'showthread' ,'postbit' ,'postbit_author_user' ,'postbit_author_guest' ,'showthread_newthread' ,'showthread_newreply' ,'showthread_newreply_closed' ,'postbit_avatar' ,'postbit_find' ,'postbit_pm' ,'postbit_www' ,'postbit_email' ,'postbit_edit' ,'postbit_quote' ,'postbit_report' ,'multipage' ,'multipage_breadcrumb' ,'multipage_end' ,'multipage_jump_page' ,'multipage_nextpage' ,'multipage_page' ,'multipage_page_current' ,'multipage_page_link_current' ,'multipage_prevpage' ,'multipage_start' ,'showthread_inlinemoderation_softdelete' ,'showthread_poll_editpoll' ,'postbit_editedby' ,'showthread_similarthreads' ,'showthread_similarthreads_bit' ,'postbit_iplogged_show' ,'postbit_iplogged_hiden' ,'postbit_profilefield' ,'showthread_quickreply' ,'showthread_add_poll' ,'showthread_send_thread' ,'showthread_inlinemoderation_restore' ,'forumjump_advanced' ,'forumjump_special' ,'forumjump_bit' ,'postbit_attachments' ,'postbit_attachments_attachment' ,'postbit_attachments_thumbnails' ,'postbit_attachments_images_image' ,'postbit_attachments_images' ,'showthread_quickreply_options_stick' ,'postbit_status' ,'postbit_inlinecheck' ,'showthread_inlinemoderation' ,'postbit_attachments_thumbnails_thumbnail' ,'postbit_ignored' ,'postbit_multiquote' ,'showthread_moderationoptions_custom_tool' ,'showthread_moderationoptions_custom' ,'showthread_inlinemoderation_custom_tool' ,'showthread_usersbrowsing' ,'showthread_usersbrowsing_user' ,'showthread_poll_option' ,'showthread_poll' ,'showthread_quickreply_options_signature' ,'showthread_threaded_bitactive' ,'showthread_threaded_bit' ,'postbit_attachments_attachment_unapproved' ,'showthread_moderationoptions_openclose' ,'showthread_moderationoptions_stickunstick' ,'showthread_moderationoptions_delete' ,'showthread_moderationoptions_threadnotes' ,'showthread_moderationoptions_manage' ,'showthread_moderationoptions_deletepoll' ,'postbit_userstar' ,'postbit_reputation_formatted_link' ,'postbit_warninglevel_formatted' ,'postbit_quickrestore' ,'forumdisplay_password' ,'forumdisplay_password_wrongpass' ,'postbit_purgespammer' ,'showthread_inlinemoderation_approve' ,'forumdisplay_thread_icon' ,'showthread_moderationoptions_softdelete' ,'showthread_moderationoptions_restore' ,'post_captcha' ,'post_captcha_recaptcha_invisible' ,'post_captcha_nocaptcha' ,'showthread_moderationoptions' ,'showthread_inlinemoderation_standard' ,'showthread_inlinemoderation_manage' ,'showthread_ratethread' ,'postbit_posturl' ,'postbit_icon' ,'postbit_editedby_editreason' ,'attachment_icon' ,'global_moderation_notice' ,'showthread_poll_option_multiple' ,'postbit_gotopost' ,'postbit_rep_button' ,'postbit_warninglevel' ,'showthread_threadnoteslink' ,'showthread_moderationoptions_approve' ,'showthread_moderationoptions_unapprove' ,'showthread_inlinemoderation_delete' ,'showthread_moderationoptions_standard' ,'showthread_quickreply_options_close' ,'showthread_inlinemoderation_custom' ,'showthread_search' ,'postbit_profilefield_multiselect_value' ,'postbit_profilefield_multiselect' ,'showthread_subscription' ,'postbit_deleted_member' ,'postbit_away' ,'postbit_warn' ,'postbit_classic' ,'postbit_reputation' ,'postbit_deleted' ,'postbit_offline' ,'postbit_online' ,'postbit_signature' ,'postbit_editreason' ,'postbit_quickdelete' ,'showthread_threadnotes_viewnotes' ,'showthread_threadedbox' ,'showthread_poll_resultbit' ,'showthread_poll_results' ,'showthread_threadnotes' ,'showthread_classic_header' ,'showthread_poll_undovote' ,'postbit_groupimage' ,'myalerts_headericon' ,'myalerts_modal' ,'myalerts_popup_row' ,'myalerts_alert_row_no_alerts' ,'myalerts_js_popup' ,'thankyoulike_users' ,'thankyoulike_postbit_author_user' ,'thankyoulike_postbit' ,'thankyoulike_postbit_classic' ,'thankyoulike_expcollapse' ,'thankyoulike_button_add' ,'thankyoulike_button_del' ,'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: 9 ms

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

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

#13 - Select Query
SELECT COUNT(tid) as threads FROM mybb_threads WHERE fid = '34' AND (lastpost >= '1479223558' OR sticky=1) AND visible=1 ORDER BY lastpost DESC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads ref fid,lastpost fid 3 const,const 20 Using where
Query Time: 225 μs

#14 - Select Query
SELECT lastpost, tid, fid FROM mybb_threads WHERE visible=1 AND closed NOT LIKE 'moved|%' AND fid IN (34) AND lastpost > '1575070255' LIMIT 100
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads range fid,lastpost lastpost 4 11 Using index condition; Using where
Query Time: 131 μs

#15 - Select Query
SELECT uid FROM mybb_threadratings WHERE tid='203' AND uid='0'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threadratings ref tid tid 8 const,const 1 Using index
Query Time: 69 μs

#16 - Select Query
SELECT p.pid FROM mybb_posts p WHERE p.tid='203' AND p.visible='1' ORDER BY p.dateline LIMIT 0, 10
Table Type Possible Keys Key Key Length Ref Rows Extra
p ref tid,visible,tiddate tiddate 4 const 21 Using where
Query Time: 156 μs

#17 - Select Query
SELECT u.*, u.username AS userusername, p.*, f.*, eu.username AS editusername FROM mybb_posts p LEFT JOIN mybb_users u ON (u.uid=p.uid) LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) LEFT JOIN mybb_users eu ON (eu.uid=p.edituid) WHERE pid IN('10667','11129','11133','11134','11135','11136','11137','11138','11139','11140') ORDER BY p.dateline
Table Type Possible Keys Key Key Length Ref Rows Extra
p range PRIMARY PRIMARY 4 10 Using index condition; Using filesort
u eq_ref PRIMARY PRIMARY 4 db_agexpl.p.uid 1
f eq_ref PRIMARY PRIMARY 4 db_agexpl.u.uid 1 Using where
eu eq_ref PRIMARY PRIMARY 4 db_agexpl.p.edituid 1
Query Time: 456 μs

(Plugin Hook: postbit)
#18 - Select Query
SELECT * FROM mybb_warnings WHERE `pid`='10667'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings ALL 48 Using where
Query Time: 106 μs

(Plugin Hook: postbit)
#19 - Select Query
SELECT u.username, u.usergroup, u.displaygroup, tyl.* FROM mybb_g33k_thankyoulike_thankyoulike tyl LEFT JOIN mybb_users u ON (u.uid=tyl.uid) WHERE tyl.pid IN('10667','11129','11133','11134','11135','11136','11137','11138','11139','11140') ORDER BY username ASC
Table Type Possible Keys Key Key Length Ref Rows Extra
tyl range pid pid 4 10 Using index condition; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 db_agexpl.tyl.uid 1
Query Time: 166 μs

(Plugin Hook: postbit)
#20 - Select Query
SELECT * FROM mybb_warnings WHERE `pid`='11129'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings ALL 48 Using where
Query Time: 113 μs

(Plugin Hook: postbit)
#21 - Select Query
SELECT * FROM mybb_warnings WHERE `pid`='11133'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings ALL 48 Using where
Query Time: 113 μs

(Plugin Hook: postbit)
#22 - Select Query
SELECT * FROM mybb_warnings WHERE `pid`='11134'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings ALL 48 Using where
Query Time: 114 μs

(Plugin Hook: postbit)
#23 - Select Query
SELECT * FROM mybb_warnings WHERE `pid`='11135'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings ALL 48 Using where
Query Time: 95 μs

(Plugin Hook: postbit)
#24 - Select Query
SELECT * FROM mybb_warnings WHERE `pid`='11136'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings ALL 48 Using where
Query Time: 90 μs

(Plugin Hook: postbit)
#25 - Select Query
SELECT * FROM mybb_warnings WHERE `pid`='11137'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings ALL 48 Using where
Query Time: 91 μs

(Plugin Hook: postbit)
#26 - Select Query
SELECT * FROM mybb_warnings WHERE `pid`='11138'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings ALL 48 Using where
Query Time: 88 μs

(Plugin Hook: postbit)
#27 - Select Query
SELECT * FROM mybb_warnings WHERE `pid`='11139'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings ALL 48 Using where
Query Time: 89 μs

(Plugin Hook: postbit)
#28 - Select Query
SELECT * FROM mybb_warnings WHERE `pid`='11140'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings ALL 48 Using where
Query Time: 88 μs

#29 - Select Query
SELECT t.*, t.username AS threadusername, u.username, MATCH (t.subject) AGAINST ('Patch 1.19 w open becie') AS relevance FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='34' AND t.tid!='203' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('Patch 1.19 w open becie') >= '1' ORDER BY t.lastpost DESC LIMIT 0, 10
Table Type Possible Keys Key Key Length Ref Rows Extra
t fulltext PRIMARY,fid,subject subject 0 1 Using where; Using filesort
u eq_ref PRIMARY PRIMARY 4 db_agexpl.t.uid 1
Query Time: 246 μs

#30 - Select Query
SELECT template FROM mybb_templates WHERE title='showthread_printthread' 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 4 Using where
Query Time: 194 μs

#31 - Select Query
SELECT s.ip, s.uid, s.time, 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 > '1575674155' AND location2='203' AND nopermission != 1 ORDER BY u.username ASC, s.time DESC
Table Type Possible Keys Key Key Length Ref Rows Extra
s range time time 4 23 Using index condition; Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 db_agexpl.s.uid 1
Query Time: 283 μs

Template Statistics

Templates Used (Loaded for this Page) - 210 Total
error_inline_item, error, error_inline, error_nopermission, error_nopermission_loggedin, footer, footer_contactus, footer_languageselect, footer_languageselect_option, footer_themeselect, footer_themeselector, forumdisplay_password, forumdisplay_password_wrongpass, forumdisplay_thread_icon, forumjump_advanced, forumjump_bit, forumjump_special, global_bannedwarning, global_boardclosed_warning, global_pending_joinrequests, global_pm_alert, global_unreadreports, global_moderation_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_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, post_captcha, post_captcha_nocaptcha, postbit, postbit_attachments, postbit_attachments_attachment, postbit_attachments_attachment_unapproved, postbit_attachments_images, postbit_attachments_images_image, postbit_attachments_thumbnails, postbit_attachments_thumbnails_thumbnail, postbit_author_guest, postbit_author_user, postbit_avatar, postbit_away, postbit_classic, postbit_edit, postbit_editedby, postbit_editedby_editreason, postbit_email, postbit_find, postbit_purgespammer, postbit_gotopost, postbit_groupimage, postbit_icon, postbit_ignored, postbit_inlinecheck, postbit_iplogged_hiden, postbit_iplogged_show, postbit_multiquote, postbit_offline, postbit_online, postbit_pm, postbit_posturl, postbit_profilefield, postbit_profilefield_multiselect, postbit_profilefield_multiselect_value, postbit_quickdelete, postbit_quickrestore, postbit_quote, postbit_rep_button, postbit_report, postbit_reputation, postbit_reputation_formatted_link, postbit_signature, postbit_userstar, postbit_warn, postbit_warninglevel, postbit_warninglevel_formatted, postbit_www, showthread, showthread_add_poll, showthread_classic_header, showthread_inlinemoderation, showthread_inlinemoderation_approve, showthread_inlinemoderation_custom, showthread_inlinemoderation_custom_tool, showthread_inlinemoderation_delete, showthread_inlinemoderation_manage, showthread_inlinemoderation_restore, showthread_inlinemoderation_standard, showthread_inlinemoderation_softdelete, showthread_moderationoptions, showthread_moderationoptions_custom, showthread_moderationoptions_custom_tool, showthread_moderationoptions_delete, showthread_moderationoptions_deletepoll, showthread_moderationoptions_manage, showthread_moderationoptions_openclose, showthread_moderationoptions_restore, showthread_moderationoptions_softdelete, showthread_moderationoptions_standard, showthread_moderationoptions_stickunstick, showthread_moderationoptions_threadnotes, showthread_newreply, showthread_newreply_closed, showthread_newthread, showthread_poll, showthread_poll_editpoll, showthread_poll_option, showthread_poll_option_multiple, showthread_poll_resultbit, showthread_poll_results, showthread_poll_undovote, showthread_quickreply, showthread_quickreply_options_close, showthread_quickreply_options_signature, showthread_quickreply_options_stick, showthread_ratethread, showthread_search, showthread_send_thread, showthread_similarthreads, showthread_similarthreads_bit, showthread_threaded_bit, showthread_threaded_bitactive, showthread_threadedbox, showthread_threadnotes, showthread_threadnotes_viewnotes, showthread_threadnoteslink, showthread_usersbrowsing, showthread_usersbrowsing_user, 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, attachment_icon, debug_summary, gobutton, headerinclude, htmldoctype, redirect, task_image, smilie, global_board_offline_modal, showthread_moderationoptions_unapprove, smilieinsert_row, smilieinsert_row_empty, showthread_moderationoptions_approve, 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, thankyoulike_users, thankyoulike_postbit, global_remote_avatar_notice, header_welcomeblock_member_user, post_captcha_recaptcha_invisible, postbit_deleted, postbit_deleted_member, postbit_editreason, postbit_status, showthread_subscription, thankyoulike_expcollapse, header_welcomeblock_guest_login_modal_lockout, myalerts_js_popup, myalerts_alert_row_no_alerts, myalerts_headericon, thankyoulike_postbit_author_user, video_mixer_embed, thankyoulike_postbit_classic, thankyoulike_button_del, thankyoulike_button_add, showthread_printthread

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