MyBB Community Forums

Full Version: very high DB queries and high server load
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2
i have problem with mybb , I have very high DB queries and my forum is very slow

Number of queries :

Index is 219
Showthread is 66
Forumdisplay is 27

index Debug information:

Generated in 5.2223330 seconds (17.50% PHP / 82.50% MySQL)

i disable all plugin from General Configuration , but Mysql Load is 65% - 70%

Server load from 64 cpus is 30 - 41

I use hosting package , when server load is 11 - 20 , mysql is 20% - 35% , but when server load is high , load from mysql is Higher than 80%

can u help me please ?
That is a very large number of queries. Can you post a list of plugins that you have installed?
You're probably using a lot of plugin(s) used on index and thread pages.
i use :

MyFavicon
Last Post
Google seo 1.6.6
Sitemap generator
prostats
Alert PM
gomobile
form manager
attachmentlog
Thanks
contact
deletereason
logout ban
modpermissions
multiads
norightclick
onlinetoday
sceditor
vipmembership
whoviewedtopic



When I disable all plugins With Admin CP , But still On index SQL queries are 104 !!!!

Why is high Even when I disable all plugins ?

My forum have About 180.000 registred member and About 4,000 visitors per day

Database size is 180 MB
219?! I have 2 or 3 times more plugins than you on my test forum but they don't generate more than 30 queries, even though they seem to have more functionalities than yours.

I don't know most of your plugins, but I'll give you a few tips:
- my guesses for high amount of queries are: onlinetoday for index and whoviewedtopic for showthread. I can't say for 100% because I don't know their versions and who made them.
- MyFavicon is useless, I doubt it generates any query, but still it's not a reason to use a plugin for something that can be done by putting 1 line to headerinclude template. Similar thing goes for norightclick, I guess - right click block can be achieved by inserting JS to the same template.
- Sitemap generator is redundant if you use Google SEO
- multiads can possibly be replaced with simple template edits

As for large number of queries after disabling all plugins - did you do any core file edits? Check which files are edited with help of ACP -> Tools & Maintenance -> File Verification.

As you can see, you need to be careful when you're modifying your forum. I always check debug after installing new stuff and if a plugin fails, I try to optimise it. For example by caching its templates by adding them to $templatelist - many authors seem to miss it, I think MyBB should do that automatically.
(2013-12-08, 01:23 AM)Destroy666 Wrote: [ -> ]As for large number of queries after disabling all plugins - did you do any core file edits? Check which files are edited with help of ACP -> Tools & Maintenance -> File Verification.

Thanks for your reply

I Disable All plugin with General Configuration

in Tools & Maintenance -> File Verification:

This has changed

jscripts/thread.js	
jscripts/popup_menu.js	
jscripts/prototype.js	
jscripts/general.js	
inc/plugins/hello.php	
inc/functions.php	
inc/functions_forumlist.php	
images/dot_lockfolder.gif	
images/smilies/rolleyes.gif	
images/smilies/lightbulb.gif	
images/smilies/tongue.gif	
images/smilies/exclamation.gif	
images/smilies/huh.gif	
images/smilies/smile.gif	
images/smilies/biggrin.gif	
images/smilies/angry.gif	
images/smilies/undecided.gif	
images/smilies/blush.gif	
images/smilies/sad.gif	
images/smilies/sleepy.gif	
images/smilies/dodgy.gif	
images/smilies/confused.gif	
images/smilies/cool.gif	
images/smilies/wink.gif	
images/smilies/heart.gif	
images/smilies/shy.gif	
images/hotfolder.gif	
images/buddy_online.gif	
images/subscribe.gif	
images/icons/lightbulb.gif	
images/icons/tongue.gif	
images/icons/music.gif	
images/icons/exclamation.gif	
images/icons/rainbow.gif	
images/icons/thumbsdown.gif	
images/icons/smile.gif	
images/icons/brick.gif	
images/icons/biggrin.gif	
images/icons/information.gif	
images/icons/sad.gif	
images/icons/star.gif	
images/icons/thumbsup.gif	
images/icons/video.gif	
images/icons/question.gif	
images/icons/bug.gif	
images/icons/wink.gif	
images/icons/heart.gif	
images/icons/photo.gif	
images/icons/shocked.gif	
images/newfolder.gif	
images/dot_folder.gif	
images/thead_bg.gif	
images/send.gif	
images/collapse.gif	
images/dot_hotlockfolder.gif	
images/avatars/invalid_url.gif	
images/minion.gif	
images/buddy_away.gif	
images/usercp/composepm.gif	
images/usercp/options.gif	
images/usercp/fsubscriptions.gif	
images/usercp/subscriptions.gif	
images/usercp/password.gif	
images/usercp/editlists.gif	
images/usercp/drafts.gif	
images/usercp/usergroups.gif	
images/usercp/viewprofile.gif	
images/usercp/home.gif	
images/usercp/pmfolder.gif	
images/usercp/email.gif	
images/usercp/editfolders.gif	
images/usercp/profile.gif	
images/usercp/trash_pmfolder.gif	
images/usercp/pmtracking.gif	
images/usercp/sub_pmfolder.gif	
images/usercp/attachments.gif	
images/usercp/editsig.gif	
images/usercp/username.gif	
images/usercp/avatar.gif	
images/buddy_offline.gif	
images/off.gif	
images/star.gif	
images/collapse_collapsed.gif	
images/spinner_big.gif	
images/printable.gif	
images/lockfolder.gif	
images/pollbar-s.gif	
images/attachtypes/zip.gif	
images/offlock.gif	
images/hotlockfolder.gif	
images/minioff.gif	
images/dot_hotfolder.gif	
images/folder.gif	
images/on.gif	
images/pollbar-e.gif	
images/newhotfolder.gif	
images/pollbar.gif
Do you know why is inc/functions_forumlist.php modified? I'm almost sure that's the faulty one (1 or 2 queries per forum with many forums on index or something like that), so I'd reupload it from clean MyBB package of your version. If the file was modified by plugin it may cause errors, so make sure you disable lugin which edits it as well.
inc/functions.php can be the source of the issue too since it is required in global.php (which is required too in many other files). Check it out.
I've uploaded the original files , functions_forumlist.php and functions.php

But the problem is still .

I disable all plugin , on index its debug information :

can u help me for find problem ?

Page Generation Statistics
Page Generation Time:	9.00878095627 seconds	No. DB Queries:	105
PHP Processing Time:	1.8732493 seconds (20.79%)	DB Processing Time:	7.1355317 seconds (79.21%)
Extensions Used:	mysql, xml	Global.php Processing Time:	0.8396862 seconds
PHP Version:	5.3.27	Server Load:	27.53
GZip Encoding Status:	Enabled	No. Templates Used:	43 (43 Cached / 0 Manually Loaded)
Memory Usage:	37 MB (38797312 bytes)	Memory Limit:	512M
Database Connections (1 Total)

[READ] ----@localhost (Connected in 0s)

Database Queries (105 Total)

#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.000180959701538

#2 - Select Query
SELECT title,cache FROM mybb_datacache
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_datacache	ALL					38	
Query Time: 0.293926954269

#3 - Select Query
SELECT * FROM mybb_sessions WHERE sid='2f3d53eb8482c0e877373a09dddc0e62' AND ip='91.99.160.125' LIMIT 1
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_sessions	const	PRIMARY,ip	PRIMARY	98	const	1	
Query Time: 0.101246833801

#4 - 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_len	ref	rows	Extra
u	const	PRIMARY	PRIMARY	4	const	1	
f	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.103849887848

#5 - Write Query
UPDATE mybb_sessions SET `uid`='1', `time`='1386531145', `location`='/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/31.0.1650.63 Safar', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='2f3d53eb8482c0e877373a09dddc0e62' LIMIT 1
Query Time: 0.116302013397

#6 - Select Query
SELECT name, tid, properties, stylesheets FROM mybb_themes WHERE tid='244' LIMIT 1
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_themes	const	PRIMARY	PRIMARY	2	const	1	
Query Time: 0.0217070579529

#7 - Select Query
SELECT title,template FROM mybb_templates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'headerinclude' ,'header' ,'footer' ,'gobutton' ,'htmldoctype' ,'header_welcomeblock_member' ,'header_welcomeblock_guest' ,'header_welcomeblock_member_admin' ,'global_pm_alert' ,'global_unreadreports' ,'global_pending_joinrequests' ,'nav' ,'nav_sep' ,'nav_bit' ,'nav_sep_active' ,'nav_bit_active' ,'footer_languageselect' ,'header_welcomeblock_member_moderator' ,'redirect' ,'error' ,'global_boardclosed_warning' ,'global_bannedwarning' ,'error_inline' ,'error_nopermission_loggedin' ,'error_nopermission') AND sid IN ('-2','-1','238') ORDER BY sid ASC
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_templates	ALL					1238	Using where; Using filesort
Query Time: 0.0317769050598

#8 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, 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>'1386516745' ORDER BY u.username ASC, s.time DESC
table	type	possible_keys	key	key_len	ref	rows	Extra
s	ALL	time				5252	Using where; Using temporary; Using filesort
u	eq_ref	PRIMARY	PRIMARY	4	-----_MYBB.s.uid	1	
Query Time: 0.341291189194

#9 - Select Query
SELECT f.*, fr.dateline AS lastread FROM mybb_forums f LEFT JOIN mybb_forumsread fr ON (fr.fid=f.fid AND fr.uid='1') WHERE f.active != 0 ORDER BY pid, disporder
table	type	possible_keys	key	key_len	ref	rows	Extra
f	ALL					772	Using where; Using filesort
fr	eq_ref	fid	fid	8	------_MYBB.f.fid,const	1	
Query Time: 0.0460159778595

#10 - Select Query
SELECT * FROM mybb_threads WHERE tid='1836'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0359580516815

#11 - Select Query
SELECT * FROM mybb_threads WHERE tid='2103'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0699949264526

#12 - Select Query
SELECT * FROM mybb_threads WHERE tid='1912'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.169735908508

#13 - Select Query
SELECT * FROM mybb_threads WHERE tid='8726'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.101073980331

#14 - Select Query
SELECT * FROM mybb_threads WHERE tid='9587'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.116341114044

#15 - Select Query
SELECT * FROM mybb_threads WHERE tid='9655'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0427541732788

#16 - Select Query
SELECT * FROM mybb_threads WHERE tid='5523'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.095244884491

#17 - Select Query
SELECT * FROM mybb_threads WHERE tid='2560'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.116396903992

#18 - Select Query
SELECT * FROM mybb_threads WHERE tid='10499'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0430500507355

#19 - Select Query
SELECT * FROM mybb_threads WHERE tid='3844'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.100298166275

#20 - Select Query
SELECT * FROM mybb_threads WHERE tid='9352'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.151273965836

#21 - Select Query
SELECT * FROM mybb_threads WHERE tid='10482'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0789151191711

#22 - Select Query
SELECT * FROM mybb_threads WHERE tid='10490'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0597970485687

#23 - Select Query
SELECT * FROM mybb_threads WHERE tid='10299'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0896179676056

#24 - Select Query
SELECT * FROM mybb_threads WHERE tid='6477'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.158895969391

#25 - Select Query
SELECT * FROM mybb_threads WHERE tid='3519'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.062698841095

#26 - Select Query
SELECT * FROM mybb_threads WHERE tid='10293'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0732500553131

#27 - Select Query
SELECT * FROM mybb_threads WHERE tid='3327'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.114499807358

#28 - Select Query
SELECT * FROM mybb_threads WHERE tid='10495'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.139017105103

#29 - Select Query
SELECT * FROM mybb_threads WHERE tid='2500'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0883851051331

#30 - Select Query
SELECT * FROM mybb_threads WHERE tid='10475'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.104166984558

#31 - Select Query
SELECT * FROM mybb_threads WHERE tid='5518'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.113281965256

#32 - Select Query
SELECT * FROM mybb_threads WHERE tid='9499'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.019926071167

#33 - Select Query
SELECT * FROM mybb_threads WHERE tid='10382'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0392100811005

#34 - Select Query
SELECT * FROM mybb_threads WHERE tid='3580'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.016224861145

#35 - Select Query
SELECT * FROM mybb_threads WHERE tid='10069'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0136339664459

#36 - Select Query
SELECT * FROM mybb_threads WHERE tid='9061'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.115615129471

#37 - Select Query
SELECT * FROM mybb_threads WHERE tid='7822'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.115176916122

#38 - Select Query
SELECT * FROM mybb_threads WHERE tid='3173'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0203521251678

#39 - Select Query
SELECT * FROM mybb_threads WHERE tid='7242'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.00665998458862

#40 - Select Query
SELECT * FROM mybb_threads WHERE tid='8585'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.159169912338

#41 - Select Query
SELECT * FROM mybb_threads WHERE tid='7973'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0259809494019

#42 - Select Query
SELECT * FROM mybb_threads WHERE tid='8367'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0387768745422

#43 - Select Query
SELECT * FROM mybb_threads WHERE tid='8579'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0397810935974

#44 - Select Query
SELECT * FROM mybb_threads WHERE tid='10500'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0318839550018

#45 - Select Query
SELECT * FROM mybb_threads WHERE tid='9144'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0331959724426

#46 - Select Query
SELECT * FROM mybb_threads WHERE tid='9320'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0992379188538

#47 - Select Query
SELECT * FROM mybb_threads WHERE tid='10479'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.101550102234

#48 - Select Query
SELECT * FROM mybb_threads WHERE tid='9937'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0252778530121

#49 - Select Query
SELECT * FROM mybb_threads WHERE tid='10384'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0283319950104

#50 - Select Query
SELECT * FROM mybb_threads WHERE tid='5708'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.000332117080688

#51 - Select Query
SELECT * FROM mybb_threads WHERE tid='10350'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0555491447449

#52 - Select Query
SELECT * FROM mybb_threads WHERE tid='2491'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.031406879425

#53 - Select Query
SELECT * FROM mybb_threads WHERE tid='10410'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0819048881531

#54 - Select Query
SELECT * FROM mybb_threads WHERE tid='7967'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0429780483246

#55 - Select Query
SELECT * FROM mybb_threads WHERE tid='10338'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0930099487305

#56 - Select Query
SELECT * FROM mybb_threads WHERE tid='10477'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0910260677338

#57 - Select Query
SELECT * FROM mybb_threads WHERE tid='8885'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0305180549622

#58 - Select Query
SELECT * FROM mybb_threads WHERE tid='8978'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0152089595795

#59 - Select Query
SELECT * FROM mybb_threads WHERE tid='1416'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0458631515503

#60 - Select Query
SELECT * FROM mybb_threads WHERE tid='10063'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0383489131927

#61 - Select Query
SELECT * FROM mybb_threads WHERE tid='7945'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.100821971893

#62 - Select Query
SELECT * FROM mybb_threads WHERE tid='9010'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0414080619812

#63 - Select Query
SELECT * FROM mybb_threads WHERE tid='10494'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0334680080414

#64 - Select Query
SELECT * FROM mybb_threads WHERE tid='10435'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0922729969025

#65 - Select Query
SELECT * FROM mybb_threads WHERE tid='3385'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.050243139267

#66 - Select Query
SELECT * FROM mybb_threads WHERE tid='10439'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0443949699402

#67 - Select Query
SELECT * FROM mybb_threads WHERE tid='2213'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0228490829468

#68 - Select Query
SELECT * FROM mybb_threads WHERE tid='2731'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0210139751434

#69 - Select Query
SELECT * FROM mybb_threads WHERE tid='10441'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0977470874786

#70 - Select Query
SELECT * FROM mybb_threads WHERE tid='6422'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0402610301971

#71 - Select Query
SELECT * FROM mybb_threads WHERE tid='2194'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0268549919128

#72 - Select Query
SELECT * FROM mybb_threads WHERE tid='10443'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0878469944

#73 - Select Query
SELECT * FROM mybb_threads WHERE tid='727'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0495948791504

#74 - Select Query
SELECT * FROM mybb_threads WHERE tid='6482'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0637137889862

#75 - Select Query
SELECT * FROM mybb_threads WHERE tid='9982'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0302250385284

#76 - Select Query
SELECT * FROM mybb_threads WHERE tid='10447'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0386390686035

#77 - Select Query
SELECT * FROM mybb_threads WHERE tid='8200'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.046952009201

#78 - Select Query
SELECT * FROM mybb_threads WHERE tid='10452'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.088045835495

#79 - Select Query
SELECT * FROM mybb_threads WHERE tid='10292'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0458071231842

#80 - Select Query
SELECT * FROM mybb_threads WHERE tid='7974'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0948700904846

#81 - Select Query
SELECT * FROM mybb_threads WHERE tid='10457'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0856008529663

#82 - Select Query
SELECT * FROM mybb_threads WHERE tid='4421'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0470430850983

#83 - Select Query
SELECT * FROM mybb_threads WHERE tid='10483'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0712292194366

#84 - Select Query
SELECT * FROM mybb_threads WHERE tid='10459'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0498809814453

#85 - Select Query
SELECT * FROM mybb_threads WHERE tid='10330'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0714471340179

#86 - Select Query
SELECT * FROM mybb_threads WHERE tid='1834'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.033075094223

#87 - Select Query
SELECT * FROM mybb_threads WHERE tid='9753'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0318629741669

#88 - Select Query
SELECT * FROM mybb_threads WHERE tid='10394'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0353519916534

#89 - Select Query
SELECT * FROM mybb_threads WHERE tid='9358'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0396349430084

#90 - Select Query
SELECT * FROM mybb_threads WHERE tid='249'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.042366027832

#91 - Select Query
SELECT * FROM mybb_threads WHERE tid='1757'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0267851352692

#92 - Select Query
SELECT * FROM mybb_threads WHERE tid='2693'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0376250743866

#93 - Select Query
SELECT * FROM mybb_threads WHERE tid='2370'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0751140117645

#94 - Select Query
SELECT * FROM mybb_threads WHERE tid='8269'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0730540752411

#95 - Select Query
SELECT * FROM mybb_threads WHERE tid='7678'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.229682922363

#96 - Select Query
SELECT * FROM mybb_threads WHERE tid='8829'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0587010383606

#97 - Select Query
SELECT * FROM mybb_threads WHERE tid='978'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.126290082932

#98 - Select Query
SELECT * FROM mybb_threads WHERE tid='242'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0283360481262

#99 - Select Query
SELECT * FROM mybb_threads WHERE tid='8154'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0397760868073

#100 - Select Query
SELECT * FROM mybb_threads WHERE tid='4098'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0481219291687

#101 - Select Query
SELECT * FROM mybb_threads WHERE tid='8882'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0332400798798

#102 - Select Query
SELECT * FROM mybb_threads WHERE tid='1701'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.000182867050171

#103 - Select Query
SELECT * FROM mybb_threads WHERE tid='470'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0257928371429

#104 - Select Query
SELECT * FROM mybb_threads WHERE tid='4373'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0415000915527

#105 - Select Query
SELECT * FROM mybb_threads WHERE tid='10269'
table	type	possible_keys	key	key_len	ref	rows	Extra
mybb_threads	const	PRIMARY	PRIMARY	4	const	1	
Query Time: 0.0291020870209

Template Statistics

Templates Used (Loaded for this Page) - 43 Total
global_boardclosed_warning, global_pm_alert, index, header_welcomeblock_member, header_welcomeblock_member_moderator, header_welcomeblock_member_admin, redirect, gobutton, forumbit_depth2_forum, forumbit_depth3, forumbit_depth3_statusicon, forumbit_subforums, footer, headerinclude, nav_sep, nav_sep_active, header_welcomeblock_guest, header, forumbit_depth1_cat, global_unreadreports, global_pending_joinrequests, index_loginform, index_whosonline, index_stats, index_birthdays_birthday, forumbit_moderators, index_birthdays, index_logoutlink, error_nopermission, error_nopermission_loggedin, error, index_whosonline_memberbit, forumbit_depth2_cat, nav, nav_bit, nav_bit_active, error_inline, global_bannedwarning, htmldoctype, footer_languageselect, index_boardstats, forumbit_depth2_forum_lastpost, forumbit_depth1_forum_lastpost
Link to your board? It's something to do with a plugin that's querying for lots of threads individually.
Pages: 1 2