MyBB Debug Information

Page Generation

Page Generation Statistics
Page Generation Time: 184 ms No. DB Queries: 43
PHP Processing Time: 151 ms (82.41%) DB Processing Time: 32 ms (17.59%)
Extensions Used: mysqli, xml Global.php Processing Time: 149 ms
PHP Version: 7.0.33 Server Load: 3
GZip Encoding Status: Disabled No. Templates Used: 273 (267 Cached / 10 Manually Loaded)
Memory Usage: 4 MB (4194304 bytes) Memory Limit: 90M

Database Connections (1 Total)

[READ] islesaboverpg@mysql-ia.islesabove-rpg.com (Connected in 2 ms)

Database Queries (43 Total)

#1 - Select Query
SELECT title,cache FROM mybb_datacache
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_datacache ALL 49
Query Time: 2 ms

#2 - Select Query
SELECT uid FROM mybb_users WHERE username = 'test'
Table Type Possible Keys Key Key Length Ref Rows Extra
no matching row in const table
Query Time: 480 μs

#3 - Select Query
SELECT * FROM mybb_threads WHERE tid = '10'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads const PRIMARY PRIMARY 4 const 1
Query Time: 487 μs

#4 - Write Query
DELETE FROM mybb_sessions WHERE ip=X'12e8bcfb'
Query Time: 493 μs

#5 - Write Query
REPLACE INTO mybb_sessions SET `uid`=0,`sid`='d6e0c53fbe0025515daf97acae7db78b',`time`=1586140642,`ip`=X'12e8bcfb',`location`='/showthread.php?tid=10&pid=29&debug=1',`useragent`='CCBot/2.0 (https://commoncrawl.org/faq/)',`location1`=11,`location2`=10,`nopermission`=0
Query Time: 298 μs

#6 - Select Query
SELECT fid FROM mybb_posts WHERE pid = '29' LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_posts const PRIMARY PRIMARY 4 const 1
Query Time: 448 μs

#7 - 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' ,'newpoints_postbit' ,'newpoints_donate_inline' ,'' ,'ougcawards_js' ,'ougcawards_global_menu' ,'ougcawards_global_notification' ,'ougcawards_welcomeblock' ,'ougcawards_award_image' ,'ougcawards_postbit' ,'ougcawards_stats_user_viewall' ,'accountswitcher_header_userbit' ,'accountswitcher_header_dropdown_userbit' ,'accountswitcher_header' ,'accountswitcher_header_dropdown' ,'accountswitcher_header_accountlist' ,'accountswitcher_newpm_messagebit' ,'accountswitcher_newpm_message' ,'accountswitcher_footer' ,'accountswitcher_post_userbit' ,'accountswitcher_post' ,'accountswitcher_sec_accountsbit' ,'accountswitcher_shared_accountsbit' ,'accountswitcher_sidebar_userbit' ,'accountswitcher_sidebar' ,'accountswitcher_avatar' ,'accountswitcher_postbit_switch' ,'accountswitcher_postbit_link' ,'accountswitcher_postbit' ,'accountswitcher_author_button' ,'accountswitcher_author_button_admin' ,'' ,'accountswitcher_author_button_attached' ,'accountswitcher_author_userbit' ,'accountswitcher_author_selfbit' ,'accountswitcher_author_admin' ,'accountswitcher_author_change' ,'accountswitcher_attached_postcount' ,'myalerts_headericon' ,'myalerts_modal' ,'myalerts_popup_row' ,'myalerts_alert_row_no_alerts' ,'myalerts_js_popup' ,'prostats' ,'prostats_readstate_icon' ,'prostats_newmembers' ,'prostats_newmembers_row' ,'prostats_topposters' ,'prostats_topposters_row' ,'prostats_topthreadposters' ,'prostats_topthreadposters_row' ,'prostats_topreferrers' ,'prostats_topreferrers_row' ,'prostats_mostthanks' ,'prostats_mostthanks_row' ,'prostats_newestposts' ,'prostats_newestposts_row' ,'prostats_newestposts_specialchar' ,'prostats_mostreplies' ,'prostats_mostreplies_row' ,'prostats_mostviews' ,'prostats_mostviews_row' ,'prostats_topdownloads' ,'prostats_topdownloads_row' ,'prostats_mostreputation' ,'prostats_mostreputation_row' ,'prostats_message' ,'prostats_onerowextra' ,'prostats_tworowextra' ,'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','3') ORDER BY sid ASC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates ALL sid 2867 Using where; Using filesort
Query Time: 9 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 4 Using where
Query Time: 453 μs

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

#10 - Select Query
SELECT COUNT(tid) as threads FROM mybb_threads WHERE fid = '11' AND (lastpost >= '1580295881' 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 1 Using where
Query Time: 324 μs

#11 - Select Query
SELECT lastpost, tid, fid FROM mybb_threads WHERE visible=1 AND closed NOT LIKE 'moved|%' AND fid IN (11) AND lastpost > '1585535842' LIMIT 100
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads ref fid,lastpost fid 3 const,const 1 Using where
Query Time: 370 μs

#12 - Select Query
SELECT * FROM mybb_posts WHERE pid = '29'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_posts const PRIMARY PRIMARY 4 const 1
Query Time: 296 μs

#13 - Select Query
SELECT COUNT(p.dateline) AS count FROM mybb_posts p WHERE p.tid = '10' AND p.dateline <= '1580295881' AND p.visible='1'
Table Type Possible Keys Key Key Length Ref Rows Extra
p ref tid,visible,dateline,tiddate tid 4 const 3 Using where
Query Time: 348 μs

#14 - Select Query
SELECT p.pid FROM mybb_posts p WHERE p.tid='10' 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 3 Using index condition; Using where
Query Time: 339 μs

#15 - 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('11','28','29') ORDER BY p.dateline
Table Type Possible Keys Key Key Length Ref Rows Extra
p range PRIMARY PRIMARY 4 3 Using index condition; Using filesort
u eq_ref PRIMARY PRIMARY 4 islesaboverpg.p.uid 1
f eq_ref PRIMARY PRIMARY 4 islesaboverpg.u.uid 1
eu eq_ref PRIMARY PRIMARY 4 islesaboverpg.p.edituid 1
Query Time: 1 ms

(Plugin Hook: postbit)
#16 - Select Query
SELECT a.aid, a.name, a.image, ag.* FROM mybb_ougc_awards a JOIN mybb_ougc_awards_users ag ON (ag.aid=a.aid) JOIN mybb_posts p ON (p.uid=ag.uid) WHERE ag.visible=1 AND p.pid IN ('11','28','29') AND a.visible='1' AND a.type!='1' AND a.cid IN ('') ORDER BY ag.disporder, ag.date desc
Table Type Possible Keys Key Key Length Ref Rows Extra
no matching row in const table
Query Time: 586 μs

(Plugin Hook: postbit)
#17 - Select Query
SELECT iid,name,icon FROM mybb_newpoints_shop_items WHERE visible=1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_newpoints_shop_items ALL 4 Using where
Query Time: 389 μs

(Plugin Hook: postbit)
#18 - Select Query
SELECT template FROM mybb_templates WHERE title='newpoints_shop_postbit' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 520 μs

#19 - Select Query
SELECT template FROM mybb_templates WHERE title='showthread_printthread' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 451 μs

#20 - 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 > '1586139742' AND location2='10' 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 2 Using index condition; Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 islesaboverpg.s.uid 1
Query Time: 443 μs

(Plugin Hook: pre_output_page)
#21 - Select Query
SELECT uid,username,usergroup,displaygroup FROM mybb_users WHERE username IN ('test','testing','camy')
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users range username username 362 3 Using index condition
Query Time: 338 μs

(Plugin Hook: pre_output_page)
#22 - Select Query
SELECT t.subject,t.username,t.uid,t.tid,t.fid,t.lastpost,t.lastposter,t.lastposteruid,t.replies,t.visible,tr.uid AS truid,tr.dateline,tp.displaystyle AS styledprefix,f.name FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='0') LEFT JOIN mybb_threadprefixes tp ON (tp.pid = t.prefix) LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE (t.visible = '1' ) AND t.fid NOT IN (21,10,18,22,23,'21','22','23','10','18') AND t.closed NOT LIKE 'moved|%' AND t.visible != '-2' AND f.active = '1' ORDER BY t.lastpost DESC LIMIT 0,50
Table Type Possible Keys Key Key Length Ref Rows Extra
t ALL fid 13 Using where; Using filesort
tr eq_ref tid tid 8 islesaboverpg.t.tid,const 1
tp eq_ref PRIMARY PRIMARY 4 islesaboverpg.t.prefix 1 Using where
f eq_ref PRIMARY PRIMARY 2 islesaboverpg.t.fid 1 Using where
Query Time: 924 μs

(Plugin Hook: pre_output_page)
#23 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_latest_posts' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 519 μs

(Plugin Hook: pre_output_page)
#24 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_date' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 357 μs

(Plugin Hook: pre_output_page)
#25 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_last_sender' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 391 μs

(Plugin Hook: pre_output_page)
#26 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_forum' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 380 μs

(Plugin Hook: pre_output_page)
#27 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '11'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 270 μs

(Plugin Hook: pre_output_page)
#28 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_latest_posts' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 490 μs

(Plugin Hook: pre_output_page)
#29 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_date' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 394 μs

(Plugin Hook: pre_output_page)
#30 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_last_sender' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 2 ms

(Plugin Hook: pre_output_page)
#31 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_forum' AND sid IN ('-2','-1','3') ORDER BY sid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates range sid sid 364 3 Using index condition
Query Time: 393 μs

(Plugin Hook: pre_output_page)
#32 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '3'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 297 μs

(Plugin Hook: pre_output_page)
#33 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 282 μs

(Plugin Hook: pre_output_page)
#34 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 253 μs

(Plugin Hook: pre_output_page)
#35 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 276 μs

(Plugin Hook: pre_output_page)
#36 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 279 μs

(Plugin Hook: pre_output_page)
#37 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 280 μs

(Plugin Hook: pre_output_page)
#38 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 269 μs

(Plugin Hook: pre_output_page)
#39 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 271 μs

(Plugin Hook: pre_output_page)
#40 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 272 μs

(Plugin Hook: pre_output_page)
#41 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 265 μs

(Plugin Hook: pre_output_page)
#42 - Select Query
SELECT username,postnum,uid,usergroup,displaygroup FROM mybb_users ORDER BY postnum DESC LIMIT 0,24
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users ALL 10 Using filesort
Query Time: 346 μs

(Plugin Hook: pre_output_page)
#43 - Select Query
SELECT t.subject,t.tid,t.fid,t.lastpost,t.views,t.visible,tr.uid AS truid,tr.dateline FROM mybb_threads t LEFT JOIN mybb_threadsread tr ON (tr.tid=t.tid AND tr.uid='0') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE (t.visible = '1' ) AND t.fid NOT IN (21,10,18,22,23,'21','22','23','10','18') AND t.closed NOT LIKE 'moved|%' AND t.visible != '-2' AND f.active = '1' ORDER BY t.views DESC LIMIT 0,25
Table Type Possible Keys Key Key Length Ref Rows Extra
t ALL fid 13 Using where; Using filesort
tr eq_ref tid tid 8 islesaboverpg.t.tid,const 1
f eq_ref PRIMARY PRIMARY 2 islesaboverpg.t.fid 1 Using where
Query Time: 686 μs

Template Statistics

Templates Used (Loaded for this Page) - 273 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_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_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_admin, header_welcomeblock_member_moderator, 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, post_captcha, post_captcha_recaptcha_invisible, 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_deleted, postbit_deleted_member, postbit_edit, postbit_editedby, postbit_editedby_editreason, postbit_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_status, 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_approve, 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_moderationoptions_unapprove, 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_subscription, showthread_threaded_bit, showthread_threaded_bitactive, showthread_threadedbox, showthread_threadnotes, showthread_threadnotes_viewnotes, showthread_threadnoteslink, showthread_usersbrowsing, showthread_usersbrowsing_user, 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_vimeo_embed, video_yahoo_embed, attachment_icon, debug_summary, gobutton, headerinclude, htmldoctype, redirect, task_image, smilie, ougcawards_postbit, ougcawards_welcomeblock, accountswitcher_avatar, accountswitcher_sec_accountsbit, accountswitcher_shared_accountsbit, accountswitcher_author_button, accountswitcher_author_button_attached, accountswitcher_sidebar_userbit, accountswitcher_sidebar, accountswitcher_author_change, accountswitcher_author_selfbit, accountswitcher_author_userbit, accountswitcher_author_admin, accountswitcher_postbit_switch, accountswitcher_header_userbit, accountswitcher_header_dropdown_userbit, accountswitcher_header, accountswitcher_header_dropdown, accountswitcher_header_accountlist, accountswitcher_newpm_messagebit, accountswitcher_newpm_message, accountswitcher_post_userbit, accountswitcher_post, accountswitcher_footer, accountswitcher_postbit_link, accountswitcher_postbit, accountswitcher_author_button_admin, myalerts_js_popup, myalerts_headericon, myalerts_alert_row_no_alerts, ougcawards_award_image, ougcawards_global_menu, ougcawards_js, ougcawards_stats_user_viewall, ougcawards_global_notification, accountswitcher_attached_postcount, header_welcomeblock_guest_login_modal_lockout, video_mixer_embed, newpoints_postbit, newpoints_donate_inline, prostats, prostats_readstate_icon, prostats_newestposts, prostats_newestposts_row, prostats_newestposts_specialchar, prostats_mostreplies, prostats_mostreplies_row, prostats_mostreputation, prostats_mostreputation_row, prostats_mostthanks, prostats_mostthanks_row, prostats_mostviews, prostats_mostviews_row, prostats_newmembers, prostats_newmembers_row, prostats_topdownloads, prostats_topdownloads_row, prostats_topposters, prostats_topposters_row, prostats_topthreadposters, prostats_topthreadposters_row, prostats_topreferrers, prostats_topreferrers_row, prostats_message, prostats_onerowextra, prostats_tworowextra, newpoints_shop_postbit, showthread_printthread, prostats_newestposts_head_latest_posts, prostats_newestposts_head_date, prostats_newestposts_head_last_sender, prostats_newestposts_head_forum, prostats_newestposts_latest_posts, prostats_newestposts_date, prostats_newestposts_last_sender, prostats_newestposts_forum

Templates Requiring Additional Calls (Not Cached at Startup) - 10 Total
newpoints_shop_postbit, showthread_printthread, prostats_newestposts_head_latest_posts, prostats_newestposts_head_date, prostats_newestposts_head_last_sender, prostats_newestposts_head_forum, prostats_newestposts_latest_posts, prostats_newestposts_date, prostats_newestposts_last_sender, prostats_newestposts_forum