2018-03-11, 01:52 AM
2018-03-11, 04:04 AM
(2018-03-11, 01:52 AM)labrocca Wrote: [ -> ]Quote:SQL Queries: 111
That's just terrible and you should do something about it.
I originally read that as "SQL Queries: 11" and thought 'oh, that's not so bad, I've seen worse' - like 111, for example. Absolutely pitiful.
Every SQL query takes time - and time adds up. Throwing more resources at it isn't a solution, it's a band-aid. It's like avoiding the problem, or... going to the doctor for some amoxicillin when you have a virus, despite the fact it won't do anything.
2018-03-11, 02:00 PM
But it does do something. Since adding more CPU the site shows signs, whereas amoxicillin wouldnt shows any signs for a virus.
The number of queries probably results in the number of plugins we have installed (56+ plugins activated). Thats just the way we want it customized. And we couldnt imagine the forum without most of them.
Most likely we will reinstall everything when 1.10 or 2.0 comes out (or a year or so after to work out bugs and get plugins). And redo everything proper again when the forum is already down. But most likely we will install a good number of those plugins again when they become available for that resulting in the same thing later.
If throwing more resources at it fixes it, why not?
The number of queries probably results in the number of plugins we have installed (56+ plugins activated). Thats just the way we want it customized. And we couldnt imagine the forum without most of them.
Most likely we will reinstall everything when 1.10 or 2.0 comes out (or a year or so after to work out bugs and get plugins). And redo everything proper again when the forum is already down. But most likely we will install a good number of those plugins again when they become available for that resulting in the same thing later.
If throwing more resources at it fixes it, why not?
2018-03-11, 06:39 PM
Quote:The number of queries probably results in the number of plugins we have installed (56+ plugins activated). Thats just the way we want it customized. And we couldnt imagine the forum without most of them.
Having 56 plugins isn't a big deal. At HF I currently have 71 activated plugins.
You should be working to figure out how to lower those queries to something manageable like 30 or less.
Quote:If throwing more resources at it fixes it, why not?
1. It's a waste of money.
2. Your site will load better if it's optimized.
3. If the current VPS/Host can't handle the load then you have to move the site. That means downtime.
4. It's much easier to DDOS attack you.
The plugins you're using either loop poorly or don't use the cache system. I've seen so many plugins not use $cache in places like checking the forum structure or permissions. And I see a lot of plugins loop showthread queries in postbit when they can do it all with one query instead of 20. It takes just 3 plugins to do badly to add 60 extra queries. And then there is templates which for each one they will get a query unless properly hooked.
2018-03-11, 07:02 PM
In that case its def one or more of the plugins. Some pugins i am using are for 1.6 and never have been upgraded to 1.8 and are not being maintained. It wouldnt surprise me if they didnt optimise them fully. I dont program php to be able tofix them.
2018-03-11, 07:14 PM
Quote:Some pugins i am using are for 1.6 and never have been upgraded to 1.8
That honestly shouldn't matter that much what version of MyBB they are for.
If you worked from the debug page you could quickly fix the issues.
2018-03-11, 08:58 PM
well my assumption was if they never updated them for 1.8 and no longer work on them, then there are old methods in their plugins, and/or bad practices not fixed if they did get exposed.
What debug page? All the plugins do it differently, some through github, some here, etc.
What debug page? All the plugins do it differently, some through github, some here, etc.
2018-03-12, 12:08 AM
(2018-03-11, 08:58 PM)metulburr Wrote: [ -> ]What debug page? All the plugins do it differently, some through github, some here, etc.
That'd be the main one - yourdomain.com/?debug=1 - which shows every query that's being done.
2018-03-12, 02:34 AM
Quote:That'd be the main one - yourdomain.com/?debug=1 - which shows every query that's being done.
Enable debug in your acp settings. You want a few main pages to be checked on.
index.php
showthread.php
member.php
Start there. Learn to use the debug then figure out which plugins are causing the extra queries and how you can improve it. Even post here and I'm sure someone will help.
2018-03-12, 12:14 PM
On thread listing i get roughly 60 sql querues, on an actual thread is where i get more such as 100+ querues
This is a random thread. Please remove for me if there is sensitive info on it. Im not really sure what to make of this. Or how do i point it to a certain plugin? OR which ones are acceptable and which are ridiculous?
This is a random thread. Please remove for me if there is sensitive info on it. Im not really sure what to make of this. Or how do i point it to a certain plugin? OR which ones are acceptable and which are ridiculous?
MyBB Debug Information
Page Generation
Page Generation Statistics
Page Generation Time: 81 ms No. DB Queries: 113
PHP Processing Time: 36 ms (44.08%) DB Processing Time: 45 ms (55.92%)
Extensions Used: mysqli, xml Global.php Processing Time: 30 ms
PHP Version: 5.5.9-1ubuntu4.23 Server Load: 0.01
GZip Encoding Status: Disabled No. Templates Used: 228 (213 Cached / 16 Manually Loaded)
Memory Usage: 5.5 MB (5767168 bytes) Memory Limit: 128M
Database Connections (1 Total)
[READ] mybbuser@localhost (Connected in 191 μs)
Database Queries (113 Total)
#1 - Select Query
SELECT title,cache FROM mybb_datacache
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_datacache ALL 46
Query Time: 241 μs
#2 - Select Query
SELECT id FROM mybb_google_seo WHERE idtype=4 AND url='Open-PDF-in-certain-page'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype idtype 363 const,const 1
Query Time: 65 μs
#3 - Select Query
SELECT subject,tid,prefix FROM mybb_threads WHERE tid IN (7789)
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads const PRIMARY PRIMARY 4 const 1
Query Time: 157 μs
#4 - Select Query
SELECT url,id FROM mybb_google_seo WHERE active=1 AND idtype=4 AND id<=7789 AND url IN ('Open-PDF-in-certain-page','Open-PDF-in-certain-page--7789') AND EXISTS(SELECT tid FROM mybb_threads WHERE tid=id) ORDER BY id ASC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo range idtype,active idtype 363 2 Using where; Using filesort
mybb_threads eq_ref PRIMARY PRIMARY 4 mybb2.mybb_google_seo.id 1 Using index
Query Time: 374 μs
#5 - Select Query
SELECT * FROM mybb_sessions WHERE sid='d4ca5309c1c1046449df3220e4a1adee' AND ip=X'18c6c8ad'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_sessions const PRIMARY,ip PRIMARY 98 const 1
Query Time: 66 μs
#6 - Select Query
SELECT u.*, f.* FROM mybb_users u LEFT JOIN mybb_userfields f ON (f.ufid=u.uid) WHERE u.uid='1' LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
u const PRIMARY PRIMARY 4 const 1
f const PRIMARY PRIMARY 4 const 1
Query Time: 428 μs
#7 - Select Query
SELECT * FROM mybb_threads WHERE tid = '7789'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads const PRIMARY PRIMARY 4 const 1
Query Time: 198 μs
#8 - Write Query
UPDATE mybb_sessions SET `uid`='1', `time`=1520856684, `location`='/showthread.php?tid=7789&debug=1', `useragent`='Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.108 Safari/537.36', `location1`=8, `location2`=7789, `nopermission`=0 WHERE sid='d4ca5309c1c1046449df3220e4a1adee'
Query Time: 255 μs
(Plugin Hook: global_start)
#9 - Select Query
SELECT * FROM mybb_announcement WHERE Global='1' AND Enabled='1' ORDER BY Sort
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_announcement ALL 3 Using where; Using filesort
Query Time: 64 μs
#10 - Select Query
SELECT fid FROM mybb_threads WHERE tid = '7789' LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads const PRIMARY PRIMARY 4 const 1
Query Time: 135 μs
#11 - Select Query
SELECT name, tid, properties, stylesheets, allowedgroups FROM mybb_themes WHERE tid = '2' LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_themes const PRIMARY PRIMARY 2 const 1
Query Time: 45 μs
#12 - Select Query
SELECT name FROM mybb_themestylesheets WHERE sid=21
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_themestylesheets const PRIMARY PRIMARY 4 const 1
Query Time: 47 μs
#13 - 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' ,'postbit_signature' ,'postbit_online' ,'postbit_offline' ,'postbit_away' ,'showthread_ratethread' ,'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_inlinemoderation_restore' ,'showthread_inlinemoderation_delete' ,'postbit_posturl' ,'postbit_icon' ,'postbit_editedby' ,'showthread_similarthreads' ,'showthread_similarthreads_bit' ,'postbit_iplogged_show' ,'postbit_iplogged_hiden' ,'postbit_profilefield' ,'showthread_quickreply' ,'showthread_add_poll' ,'showthread_send_thread' ,'showthread_poll_editpoll' ,'showthread_poll_undovote' ,'showthread_moderationoptions_standard' ,'postbit_editedby_editreason' ,'forumjump_advanced' ,'forumjump_special' ,'forumjump_bit' ,'postbit_reputation' ,'postbit_quickdelete' ,'postbit_attachments' ,'postbit_attachments_attachment' ,'postbit_attachments_thumbnails' ,'postbit_attachments_images_image' ,'postbit_attachments_images' ,'showthread_quickreply_options_stick' ,'showthread_quickreply_options_close' ,'attachment_icon' ,'postbit_inlinecheck' ,'showthread_inlinemoderation' ,'postbit_attachments_thumbnails_thumbnail' ,'postbit_ignored' ,'postbit_groupimage' ,'postbit_multiquote' ,'showthread_search' ,'showthread_moderationoptions_custom_tool' ,'showthread_moderationoptions_custom' ,'showthread_inlinemoderation_custom_tool' ,'showthread_inlinemoderation_custom' ,'showthread_usersbrowsing' ,'showthread_usersbrowsing_user' ,'showthread_poll_option_multiple' ,'showthread_poll_option' ,'showthread_poll' ,'showthread_quickreply_options_signature' ,'showthread_threaded_bitactive' ,'showthread_threaded_bit' ,'postbit_attachments_attachment_unapproved' ,'showthread_threadnotes' ,'showthread_threadnotes_viewnotes' ,'showthread_moderationoptions_openclose' ,'showthread_moderationoptions_stickunstick' ,'showthread_moderationoptions_delete' ,'showthread_moderationoptions_threadnotes' ,'showthread_moderationoptions_manage' ,'showthread_moderationoptions_deletepoll' ,'showthread_threadnoteslink' ,'showthread_poll_results' ,'showthread_classic_header' ,'postbit_warn' ,'postbit_userstar' ,'postbit_reputation_formatted_link' ,'postbit_warninglevel_formatted' ,'postbit_quickrestore' ,'forumdisplay_password' ,'forumdisplay_password_wrongpass' ,'postbit_classic' ,'postbit_purgespammer' ,'showthread_inlinemoderation_approve' ,'forumdisplay_thread_icon' ,'showthread_poll_resultbit' ,'postbit_warninglevel' ,'postbit_gotopost' ,'showthread_moderationoptions_softdelete' ,'showthread_moderationoptions_restore' ,'post_captcha' ,'post_captcha_recaptcha' ,'post_captcha_nocaptcha' ,'showthread_moderationoptions' ,'showthread_inlinemoderation_standard' ,'showthread_threadedbox' ,'postbit_rep_button' ,'showthread_inlinemoderation_manage' ,'global_moderation_notice' ,'postbit_edithistory' ,'showthread_favorite' ,'unreadPosts_link' ,'unreadPosts_counter' ,'unreadPosts_linkCounter' ,'unreadPosts_postbit' ,'' ,'simplelikes_likebutton' ,'simplelikes_likebar' ,'moderationactionspreview_ip' ,'moderationactionspreview_avatar' ,'moderationactionspreview_post' ,'moderationactionspreview_postbit_row' ,'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' ,'notemoderator_post' ,'notemoderator_normal' ,'notemoderator_information' ,'notemoderator_warn' ,'notemoderator_buttons' ,'notemoderator_postbit_button' ,'rinbutquick' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'error' ,'footer_languageselect_option' ,'footer_contactus' ,'global_pending_joinrequests' ,'global_awaiting_activation' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'footer_themeselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'header_menu_calendar' ,'nav_dropdown' ,'footer_themeselector' ,'task_image' ,'global_boardclosed_warning' ,'global_bannedwarning' ,'error_inline' ,'error_nopermission_loggedin' ,'error_nopermission' ,'debug_summary' ,'header_quicksearch' ,'header_menu_search' ,'header_menu_portal' ,'header_menu_memberlist' ,'usercp_themeselector_option' ,'smilie' ,'global_board_offline_modal' ,'video_dailymotion_embed' ,'video_facebook_embed' ,'video_liveleak_embed' ,'video_metacafe_embed' ,'video_myspacetv_embed' ,'video_veoh_embed' ,'video_vimeo_embed' ,'video_yahoo_embed' ,'video_youtube_embed') AND sid IN ('-2','-1','1') ORDER BY sid ASC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_templates ALL sid 1338 Using where; Using filesort
Query Time: 246 μs
#14 - 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 5 Using where
Query Time: 77 μs
(Plugin Hook: global_end)
#15 - Write Query
UPDATE mybb_users SET last_useragent='Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.108 Safari/537.36' WHERE uid=1
Query Time: 127 μs
#16 - Select Query
SELECT threads, unapprovedthreads FROM mybb_forums WHERE fid = '8' LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_forums const PRIMARY PRIMARY 2 const 1
Query Time: 43 μs
#17 - Select Query
SELECT COUNT(tid) as threads FROM mybb_threads WHERE fid = '8' AND (lastpost >= '1520852310' OR sticky=1) AND visible IN (-1,0,1) ORDER BY lastpost DESC
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads ref fid,lastpost fid 2 const 4032 Using where
Query Time: 6 ms
(Plugin Hook: showthread_start)
#18 - Select Query
SELECT tid FROM mybb_favorites WHERE tid='7789' AND uid='1' LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_favorites ref uid uid 4 const 5 Using where
Query Time: 45 μs
(Plugin Hook: showthread_start)
#19 - Write Query
REPLACE INTO mybb_threadsread_users SET tid = '7789', uid = '1', dateline = '1520856684'
Query Time: 2 ms
(Plugin Hook: showthread_start)
#20 - Select Query
SELECT * FROM mybb_announcement WHERE Global='' AND Enabled='1' ORDER BY Sort
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_announcement ALL 3 Using where; Using filesort
Query Time: 53 μs
(Plugin Hook: showthread_start)
#21 - Select Query
SELECT dateline FROM mybb_threadsread WHERE uid='1' AND tid='7789'
Table Type Possible Keys Key Key Length Ref Rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 64 μs
(Plugin Hook: showthread_start)
#22 - Select Query
SELECT dateline FROM mybb_forumsread WHERE fid='8' AND uid='1'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_forumsread const fid fid 8 const,const 1
Query Time: 43 μs
#23 - Select Query
SELECT COUNT(*) AS replies FROM mybb_posts p WHERE p.tid='7789' AND p.visible IN (-1,0,1)
Table Type Possible Keys Key Key Length Ref Rows Extra
p ref tid,visible,tiddate tid 4 const 6 Using where
Query Time: 58 μs
#24 - Select Query
SELECT p.pid FROM mybb_posts p WHERE p.tid='7789' AND p.visible IN (-1,0,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 6 Using where
Query Time: 75 μs
#25 - Select Query
SELECT * FROM mybb_attachments WHERE pid IN('37446','37448','41975','41982')
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_attachments range pid pid 4 4 Using where
Query Time: 45 μs
#26 - 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('37446','37448','41975','41982') ORDER BY p.dateline
Table Type Possible Keys Key Key Length Ref Rows Extra
p range PRIMARY PRIMARY 4 4 Using where; Using filesort
u eq_ref PRIMARY PRIMARY 4 mybb2.p.uid 1
f eq_ref PRIMARY PRIMARY 4 mybb2.u.uid 1
eu eq_ref PRIMARY PRIMARY 4 mybb2.p.edituid 1
Query Time: 699 μs
#27 - Select Query
SELECT * FROM mybb_users WHERE uid = '6969'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 218 μs
(Plugin Hook: postbit)
#28 - Select Query
SELECT template FROM mybb_templates WHERE title='fastQuote_button' AND sid IN ('-2','-1','1') 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: 47 μs
(Plugin Hook: postbit)
#29 - Select Query
SELECT l.*, u.username, u.avatar, u.usergroup, u.displaygroup FROM mybb_post_likes l LEFT JOIN mybb_users u ON (l.user_id = u.uid) WHERE l.post_id IN('37446','37448','41975','41982')
Table Type Possible Keys Key Key Length Ref Rows Extra
l range unique_post_user_id,post_id_index unique_post_user_id 4 4 Using where
u eq_ref PRIMARY PRIMARY 4 mybb2.l.user_id 1
Query Time: 326 μs
(Plugin Hook: postbit)
#30 - Select Query
SELECT p.uid, (SELECT COUNT(*) FROM mybb_post_likes l LEFT JOIN mybb_posts mp ON (l.post_id = mp.pid) WHERE mp.uid = p.uid) AS count FROM mybb_posts p WHERE pid IN('37446','37448','41975','41982') GROUP BY p.uid
Table Type Possible Keys Key Key Length Ref Rows Extra
p range PRIMARY PRIMARY 4 4 Using where; Using temporary; Using filesort
mp ref PRIMARY,uid uid 4 func 11 Using where
l ref unique_post_user_id,post_id_index unique_post_user_id 4 mybb2.mp.pid 1 Using where; Using index
Query Time: 47 μs
(Plugin Hook: postbit)
#31 - Select Query
SELECT dateline, pid FROM mybb_posts WHERE tid = 7789 AND visible IN(-1,0,1) ORDER BY dateline LIMIT 0, 10
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_posts ref tid,visible,tiddate tiddate 4 const 6 Using where
Query Time: 37 μs
(Plugin Hook: postbit)
#32 - Select Query
SELECT u.username, u.usergroup, u.displaygroup, u.avatar, u.avatardimensions, m.dateline, m.uid, m.action, m.pid FROM mybb_moderatorlog m LEFT JOIN mybb_users u ON(u.uid = m.uid) WHERE m.tid = 7789
Table Type Possible Keys Key Key Length Ref Rows Extra
m ref tid tid 4 const 1
u eq_ref PRIMARY PRIMARY 4 mybb2.m.uid 1
Query Time: 144 μs
(Plugin Hook: postbit)
#33 - Select Query
SELECT nm.*, u.uid, u.username, u.usergroup, u.displaygroup FROM mybb_notemoderator nm LEFT JOIN mybb_users u ON (nm.uid=u.uid) WHERE pid IN('37446','37448','41975','41982') ORDER BY nm.dateline DESC
Table Type Possible Keys Key Key Length Ref Rows Extra
nm range pid pid 4 4 Using where; Using filesort
u eq_ref PRIMARY PRIMARY 4 mybb2.nm.uid 1
Query Time: 180 μs
(Plugin Hook: postbit)
#34 - Select Query
SELECT issuedby, dateline, title FROM mybb_warnings WHERE revokedby=0 AND pid=37446 ORDER BY wid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings index PRIMARY 4 1 Using where
Query Time: 44 μs
(Plugin Hook: postbit)
#35 - Select Query
SELECT issuedby, dateline, title FROM mybb_warnings WHERE revokedby=0 AND pid=37448 ORDER BY wid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings index PRIMARY 4 1 Using where
Query Time: 64 μs
(Plugin Hook: postbit)
#36 - Select Query
SELECT issuedby, dateline, title FROM mybb_warnings WHERE revokedby=0 AND pid=41975 ORDER BY wid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings index PRIMARY 4 1 Using where
Query Time: 71 μs
(Plugin Hook: postbit)
#37 - Select Query
SELECT issuedby, dateline, title FROM mybb_warnings WHERE revokedby=0 AND pid=41982 ORDER BY wid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_warnings index PRIMARY 4 1 Using where
Query Time: 71 μs
#38 - Select Query
SELECT t.*, t.username AS threadusername, u.username, MATCH (t.subject) AGAINST ('Open PDF in certain page') AS relevance FROM mybb_threads t LEFT JOIN mybb_users u ON (u.uid = t.uid) WHERE t.fid='8' AND t.tid!='7789' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('Open PDF in certain page') >= '5' 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 mybb2.t.uid 1
Query Time: 657 μs
#39 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (190)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 40 μs
#40 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8650)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 54 μs
#41 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (7249)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 69 μs
#42 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8590)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 45 μs
#43 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (3600)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 53 μs
#44 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (7865)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 46 μs
#45 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (7585)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 53 μs
#46 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8390)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 42 μs
#47 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (7396)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 46 μs
#48 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (8219)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 49 μs
#49 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (7341)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 47 μs
#50 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (6505)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 52 μs
#51 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (7351)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 48 μs
#52 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (6412)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 46 μs
#53 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (7286)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 53 μs
#54 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (5652)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 70 μs
#55 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (7248)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 43 μs
#56 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (6098)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 59 μs
#57 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=4 AND id IN (6957)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 49 μs
#58 - Select Query
SELECT pid FROM mybb_posts WHERE tid='7789' ORDER BY pid DESC LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_posts ref tid,tiddate tid 4 const 6 Using where; Using filesort
Query Time: 42 μs
#59 - Select Query
SELECT tid, name, type FROM mybb_modtools WHERE (CONCAT(',',forums,',') LIKE '%,8,%' OR CONCAT(',',forums,',') LIKE '%,-1,%' OR forums='') AND (groups='' OR CONCAT(',',groups,',') LIKE '%,-1,%' OR CONCAT(',',groups,',') LIKE '%,4,%')
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_modtools ALL 11 Using where
Query Time: 88 μs
#60 - Select Query
SELECT tid FROM mybb_threadsubscriptions WHERE tid='7789' AND uid='1' LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threadsubscriptions ref uid,tid tid 4 const 2 Using where
Query Time: 59 μs
#61 - 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 > '1520856384' AND location2='7789' 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 63 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 mybb2.s.uid 1
Query Time: 452 μs
(Plugin Hook: showthread_end)
#62 - Select Query
SELECT * FROM mybb_posts WHERE pid = '37446'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_posts const PRIMARY PRIMARY 4 const 1
Query Time: 52 μs
(Plugin Hook: pre_output_page)
#63 - Select Query
SELECT tu.uid, tu.username, tu.usergroup, tu.displaygroup, tubt.dateline FROM mybb_threadsread_users AS tubt INNER JOIN mybb_users AS tu ON tubt.uid = tu.uid WHERE tubt.tid = '7789' ORDER BY username ASC
Table Type Possible Keys Key Key Length Ref Rows Extra
tubt ref tid tid 4 const 14 Using temporary; Using filesort
tu eq_ref PRIMARY PRIMARY 4 mybb2.tubt.uid 1
Query Time: 607 μs
(Plugin Hook: pre_output_page)
#64 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (6970)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 49 μs
(Plugin Hook: pre_output_page)
#65 - Select Query
SELECT template FROM mybb_templates WHERE title='usersBrowsedUser' AND sid IN ('-2','-1','1') 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: 54 μs
(Plugin Hook: pre_output_page)
#66 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (6925)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 70 μs
(Plugin Hook: pre_output_page)
#67 - Select Query
SELECT url,id,idtype FROM mybb_google_seo WHERE active=1 AND ((idtype=1 AND id IN (6847)))
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_google_seo const idtype,active active 7 const,const,const 1
Query Time: 71 μs
(Plugin Hook: pre_output_page)
#68 - Select Query
SELECT template FROM mybb_templates WHERE title='usersBrowsed' AND sid IN ('-2','-1','1') 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: 41 μs
(Plugin Hook: pre_output_page)
#69 - Select Query
SELECT 1 FROM mybb_threads WHERE replies = 0 AND visible = 1 AND closed NOT LIKE 'moved|%' LIMIT 1
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_threads ALL 7432 Using where
Query Time: 45 μs
(Plugin Hook: pre_output_page)
#70 - Select Query
SELECT template FROM mybb_templates WHERE title='unansweredPosts_link' AND sid IN ('-2','-1','1') 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: 36 μs
(Plugin Hook: pre_output_page)
#71 - Select Query
SELECT * FROM mybb_moderators WHERE ((id IN (4) AND isgroup='1') OR (id='1' AND isgroup='0'))
Table Type Possible Keys Key Key Length Ref Rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 70 μs
(Plugin Hook: pre_output_page)
#72 - 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='1') LEFT JOIN mybb_threadprefixes tp ON (tp.pid = t.prefix) LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE (t.visible = '1' OR '1'='1' ) AND t.fid NOT IN ('30','28','29') AND t.closed NOT LIKE 'moved|%' AND t.visible != '-2' AND f.active = '1' ORDER BY t.lastpost DESC LIMIT 0,11
Table Type Possible Keys Key Key Length Ref Rows Extra
t index fid lastpost 6 11 Using where
tr eq_ref tid tid 8 mybb2.t.tid,const 1
tp eq_ref PRIMARY PRIMARY 4 mybb2.t.prefix 1
f eq_ref PRIMARY PRIMARY 2 mybb2.t.fid 1 Using where
Query Time: 45 μs
(Plugin Hook: pre_output_page)
#73 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_latest_posts' AND sid IN ('-2','-1','1') 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: 42 μs
(Plugin Hook: pre_output_page)
#74 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_date' AND sid IN ('-2','-1','1') 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: 37 μs
(Plugin Hook: pre_output_page)
#75 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_starter' AND sid IN ('-2','-1','1') 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: 37 μs
(Plugin Hook: pre_output_page)
#76 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_last_sender' AND sid IN ('-2','-1','1') 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: 60 μs
(Plugin Hook: pre_output_page)
#77 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_head_forum' AND sid IN ('-2','-1','1') 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: 56 μs
(Plugin Hook: pre_output_page)
#78 - 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: 159 μs
(Plugin Hook: pre_output_page)
#79 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '9'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 137 μs
(Plugin Hook: pre_output_page)
#80 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_latest_posts' AND sid IN ('-2','-1','1') 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: 46 μs
(Plugin Hook: pre_output_page)
#81 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_date' AND sid IN ('-2','-1','1') 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: 50 μs
(Plugin Hook: pre_output_page)
#82 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_starter' AND sid IN ('-2','-1','1') 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: 53 μs
(Plugin Hook: pre_output_page)
#83 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_last_sender' AND sid IN ('-2','-1','1') 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: 50 μs
(Plugin Hook: pre_output_page)
#84 - Select Query
SELECT template FROM mybb_templates WHERE title='prostats_newestposts_forum' AND sid IN ('-2','-1','1') 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: 49 μs
(Plugin Hook: pre_output_page)
#85 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '6969'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 161 μs
(Plugin Hook: pre_output_page)
#86 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '6440'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 176 μs
(Plugin Hook: pre_output_page)
#87 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '8156'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 125 μs
(Plugin Hook: pre_output_page)
#88 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '8156'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 35 μs
(Plugin Hook: pre_output_page)
#89 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '8154'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 117 μs
(Plugin Hook: pre_output_page)
#90 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '50'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 98 μs
(Plugin Hook: pre_output_page)
#91 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '7880'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 184 μs
(Plugin Hook: pre_output_page)
#92 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '9'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 36 μs
(Plugin Hook: pre_output_page)
#93 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '8153'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 138 μs
(Plugin Hook: pre_output_page)
#94 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '8153'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 42 μs
(Plugin Hook: pre_output_page)
#95 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '8089'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 122 μs
(Plugin Hook: pre_output_page)
#96 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '8089'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 33 μs
(Plugin Hook: pre_output_page)
#97 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '6232'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 163 μs
(Plugin Hook: pre_output_page)
#98 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '9'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 37 μs
(Plugin Hook: pre_output_page)
#99 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '8147'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 125 μs
(Plugin Hook: pre_output_page)
#100 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '5'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 118 μs
(Plugin Hook: pre_output_page)
#101 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '7118'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 120 μs
(Plugin Hook: pre_output_page)
#102 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '5'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 35 μs
(Plugin Hook: pre_output_page)
#103 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '5810'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 114 μs
(Plugin Hook: pre_output_page)
#104 - Select Query
SELECT username,usergroup,displaygroup FROM mybb_users WHERE uid = '5810'
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users const PRIMARY PRIMARY 4 const 1
Query Time: 34 μs
(Plugin Hook: pre_output_page)
#105 - Select Query
SELECT username,threadnum,uid,usergroup,displaygroup FROM mybb_users ORDER BY threadnum DESC LIMIT 0,5
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users ALL 4013 Using filesort
Query Time: 6 ms
(Plugin Hook: pre_output_page)
#106 - Select Query
SELECT u.uid,u.username,u.usergroup,u.displaygroup,count(*) as refcount FROM mybb_users u LEFT JOIN mybb_users r ON (r.referrer = u.uid) WHERE r.referrer = u.uid GROUP BY r.referrer DESC ORDER BY refcount DESC LIMIT 0 ,5
Table Type Possible Keys Key Key Length Ref Rows Extra
r ALL 4013 Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 mybb2.r.referrer 1
Query Time: 5 ms
(Plugin Hook: pre_output_page)
#107 - Select Query
SELECT uid,regdate,username,usergroup,displaygroup FROM mybb_users ORDER BY uid DESC LIMIT 0,5
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users index PRIMARY 4 5
Query Time: 283 μs
(Plugin Hook: pre_output_page)
#108 - Select Query
SELECT username,postnum,uid,usergroup,displaygroup FROM mybb_users ORDER BY postnum DESC LIMIT 0,5
Table Type Possible Keys Key Key Length Ref Rows Extra
mybb_users ALL 4013 Using filesort
Query Time: 6 ms
(Plugin Hook: pre_output_page)
#109 - Select Query
SELECT t.subject,t.tid,t.fid,t.replies,t.lastpost,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='1') LEFT JOIN mybb_forums f ON (f.fid = t.fid) WHERE (t.visible = '1' OR '1'='1' ) AND t.fid NOT IN ('30','28','29') AND t.closed NOT LIKE 'moved|%' AND t.visible != '-2' AND f.active = '1' ORDER BY t.replies DESC LIMIT 0,5
Table Type Possible Keys Key Key Length Ref Rows Extra
t range fid fid 2 7193 Using where; Using filesort
f eq_ref PRIMARY PRIMARY 2 mybb2.t.fid 1 Using where
tr eq_ref tid tid 8 mybb2.t.tid,const 1
Query Time: 51 μs
(Plugin Hook: pre_output_page)
#110 - Select Query
SELECT u.uid,u.reputation,u.username,u.usergroup,u.displaygroup FROM mybb_users u LEFT JOIN mybb_usergroups ug ON (u.usergroup = ug.gid) WHERE ug.usereputationsystem='1' ORDER BY u.reputation DESC LIMIT 0,5
Table Type Possible Keys Key Key Length Ref Rows Extra
u ALL usergroup 4013 Using filesort
ug eq_ref PRIMARY PRIMARY 2 mybb2.u.usergroup 1 Using where
Query Time: 8 ms
(Plugin Hook: pre_output_page)
#111 - Select Query
SELECT template FROM mybb_templates WHERE title='unreadPosts_threadCSSCode' AND sid IN ('-2','-1','1') 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: 117 μs
(Plugin Hook: pre_output_page)
#112 - Select Query
SELECT 1 FROM mybb_posts p INNER JOIN mybb_threads t ON (p.tid = t.tid) LEFT JOIN mybb_threadsread tr ON (tr.uid = 1 AND t.tid = tr.tid) LEFT JOIN mybb_forumsread fr ON (fr.uid = 1 AND t.fid = fr.fid) WHERE p.visible = 1 AND t.visible = 1 AND p.dateline > IFNULL(tr.dateline,1520854777) AND p.dateline > IFNULL(fr.dateline,1520854777) AND p.dateline > 1520854777 LIMIT 501
Table Type Possible Keys Key Key Length Ref Rows Extra
p range tid,visible,dateline,tiddate dateline 4 3 Using where
t eq_ref PRIMARY PRIMARY 4 mybb2.p.tid 1 Using where
tr eq_ref tid tid 8 mybb2.t.tid,const 1 Using where
fr eq_ref fid fid 8 mybb2.t.fid,const 1 Using where
Query Time: 68 μs
(Plugin Hook: pre_output_page)
#113 - Select Query
SELECT template FROM mybb_templates WHERE title='codebuttons' AND sid IN ('-2','-1','1') 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: 78 μs
Template Statistics
Templates Used (Loaded for this Page) - 228 Total
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_member, 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, post_captcha, post_captcha_recaptcha, 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_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, usercp_themeselector_option, video_metacafe_embed, video_dailymotion_embed, video_facebook_embed, video_liveleak_embed, video_myspacetv_embed, video_youtube_embed, video_veoh_embed, video_vimeo_embed, video_yahoo_embed, attachment_icon, debug_summary, gobutton, headerinclude, htmldoctype, redirect, task_image, smilie, global_board_offline_modal, simplelikes_likebar, simplelikes_likebutton, moderationactionspreview_ip, moderationactionspreview_avatar, moderationactionspreview_post, moderationactionspreview_postbit_row, notemoderator_post, notemoderator_normal, notemoderator_information, notemoderator_warn, notemoderator_buttons, notemoderator_postbit_button, prostats_topdownloads_row, prostats_topdownloads, prostats_newmembers_row, prostats_newmembers, prostats_mostviews_row, prostats_mostviews, prostats_mostthanks, prostats_mostthanks_row, unreadPosts_link, unreadPosts_linkCounter, unreadPosts_counter, unreadPosts_postbit, postbit_edithistory, showthread_favorite, prostats_mostreputation_row, prostats_mostreputation, prostats_mostreplies_row, prostats_mostreplies, prostats_newestposts_specialchar, prostats_topposters, prostats_topposters_row, prostats_topthreadposters, prostats_topthreadposters_row, prostats_topreferrers, prostats_topreferrers_row, prostats_message, prostats_onerowextra, prostats_tworowextra, prostats_newestposts_row, prostats_newestposts, prostats_readstate_icon, prostats, rinbutquick, fastQuote_button, usersBrowsedUser, usersBrowsed, unansweredPosts_link, prostats_newestposts_head_latest_posts, prostats_newestposts_head_date, prostats_newestposts_head_starter, prostats_newestposts_head_last_sender, prostats_newestposts_head_forum, prostats_newestposts_latest_posts, prostats_newestposts_date, prostats_newestposts_starter, prostats_newestposts_last_sender, prostats_newestposts_forum, unreadPosts_threadCSSCode, codebuttons
Templates Requiring Additional Calls (Not Cached at Startup) - 16 Total
fastQuote_button, usersBrowsedUser, usersBrowsed, unansweredPosts_link, prostats_newestposts_head_latest_posts, prostats_newestposts_head_date, prostats_newestposts_head_starter, prostats_newestposts_head_last_sender, prostats_newestposts_head_forum, prostats_newestposts_latest_posts, prostats_newestposts_date, prostats_newestposts_starter, prostats_newestposts_last_sender, prostats_newestposts_forum, unreadPosts_threadCSSCode, codebuttons