(2012-03-16, 05:34 PM)Projec13 Wrote: [ -> ]Why does noone ever post the URL of there website in question Its alot easier to help sometimes to be able to navigate to the website.
my site works fine but problem its something eat resources in cpanel.
This is forum index:
Generated in 0.6440659 seconds (43.42% PHP / 56.58% MySQL)
SQL Queries: 48 / Global Parsing Time: 0.3463180 / Memory Usage: 9 MB
PHP version: 5.2.17 / Server Load: 5.52 / GZip Compression: Enabled
This is when open thread:
Generated in 0.5482900 seconds (54.16% PHP / 45.84% MySQL)
SQL Queries: 49 / Global Parsing Time: 0.1450679 / Memory Usage: 9.75 MB
PHP version: 5.2.17 / Server Load: 4.71 / GZip Compression: Enabled
This is when go to showthread:
Generated in 0.4384930 seconds (49.80% PHP / 50.20% MySQL)
SQL Queries: 38 / Global Parsing Time: 0.2063951 / Memory Usage: 10.25 MB
PHP version: 5.2.17 / Server Load: 2.91 / GZip Compression: Enabled
And this is advanced details:
Database Queries (48 Total)
#1 - Write Query
SET NAMES 'utf8'
Query Time: 0.000172138214111
#2 - Select Query
SELECT title,cache FROM datacache
table type possible_keys key key_len ref rows Extra
datacache ALL 33
Query Time: 0.0108020305634
#3 - Select Query
SELECT * FROM sessions WHERE sid='5b33353bd2ee072328574f4e2d2cad31' AND ip='212.39.108.22' LIMIT 1
table type possible_keys key key_len ref rows Extra
sessions const PRIMARY,ip PRIMARY 98 const 1
Query Time: 0.0126202106476
#4 - Select Query
SELECT u.*, f.* FROM users u LEFT JOIN 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.000953912734985
#5 - Write Query
UPDATE sessions SET `uid`='1', `time`='1331920991', `location`='/index.php?debug=1', `useragent`='Mozilla/5.0 (Windows NT 6.1; rv:11.0) Gecko/20100101 Firefox/11.0', `location1`='0', `location2`='0', `nopermission`='0' WHERE sid='5b33353bd2ee072328574f4e2d2cad31' LIMIT 1
Query Time: 0.000869989395142
(Plugin Hook: global_start)
#6 - Select Query
SELECT template FROM templates WHERE title='my_ideas_link' AND sid IN ('-2','-1','') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.000200986862183
(Plugin Hook: global_start)
#7 - Select Query
SELECT template FROM templates WHERE title='your_side_bar' AND sid IN ('-2','-1','') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 9.98973846436E-5
#8 - Select Query
SELECT name, tid, properties, stylesheets FROM themes WHERE tid='23' LIMIT 1
table type possible_keys key key_len ref rows Extra
themes const PRIMARY PRIMARY 2 const 1
Query Time: 0.000261068344116
#9 - Select Query
SELECT title,template FROM templates WHERE title IN ('' ,'index' ,'index_whosonline' ,'index_welcomemembertext' ,'index_welcomeguest' ,'index_whosonline_memberbit' ,'forumbit_depth1_cat' ,'forumbit_depth1_forum' ,'forumbit_depth2_cat' ,'forumbit_depth2_forum' ,'forumbit_depth1_forum_lastpost' ,'forumbit_depth2_forum_lastpost' ,'index_modcolumn' ,'forumbit_moderators' ,'forumbit_subforums' ,'index_welcomeguesttext' ,'index_birthdays_birthday' ,'index_birthdays' ,'index_pms' ,'index_loginform' ,'index_logoutlink' ,'index_stats' ,'forumbit_depth3' ,'forumbit_depth3_statusicon' ,'index_boardstats' ,'css' ,'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') AND sid IN ('-2','-1','22') ORDER BY sid ASC
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.000273942947388
#10 - Select Query
SELECT fid, filter FROM banfilters WHERE type = '3'
table type possible_keys key key_len ref rows Extra
banfilters ALL 2 Using where
Query Time: 0.0147857666016
#11 - Write Query
REPLACE INTO datacache SET `title`='bannedemails',`cache`='a:0:{}'
Query Time: 0.000500917434692
(Plugin Hook: global_end)
#12 - Select Query
SELECT * FROM mypermissions_actions WHERE file='index.php'
table type possible_keys key key_len ref rows Extra
Impossible WHERE noticed after reading const tables
Query Time: 0.000163078308105
(Plugin Hook: index_start)
#13 - Select Query
SELECT u.avatar, u.username, u.uid FROM users u LEFT JOIN sessions s ON (s.uid=u.uid) WHERE s.time > '1331920091' AND u.usergroup IN (3,4,6,8) ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time,uid time 8 15 Using where; Using temporary; Using filesort
u eq_ref PRIMARY,usergroup PRIMARY 4 dugokona_mybb1.s.uid 1 Using where
Query Time: 0.0029890537262
(Plugin Hook: index_start)
#14 - Select Query
SELECT * FROM users WHERE uid='66'
table type possible_keys key key_len ref rows Extra
users const PRIMARY PRIMARY 4 const 1
Query Time: 0.000170946121216
(Plugin Hook: index_start)
#15 - Select Query
SELECT template FROM templates WHERE title='staff_online_bit' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.0145409107208
(Plugin Hook: index_start)
#16 - Select Query
SELECT template FROM templates WHERE title='staff_online' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.000118017196655
(Plugin Hook: index_start)
#17 - Select Query
SELECT template FROM templates WHERE title='iad' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.0105109214783
(Plugin Hook: index_start)
#18 - Select Query
SELECT COUNT(pid) AS newposts FROM posts WHERE visible=1 AND dateline>'1331919027'
table type possible_keys key key_len ref rows Extra
posts range visible,dateline dateline 8 2 Using where
Query Time: 0.00783586502075
(Plugin Hook: index_start)
#19 - Select Query
SELECT template FROM templates WHERE title='portal_welcome_membertext' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.0013370513916
(Plugin Hook: index_start)
#20 - Select Query
SELECT template FROM templates WHERE title='portal_welcome' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.000184059143066
(Plugin Hook: index_start)
#21 - Select Query
SELECT COUNT(*) AS pms_total, SUM(IF(status='0' AND folder='1','1','0')) AS pms_unread FROM privatemessages WHERE uid='1'
table type possible_keys key key_len ref rows Extra
privatemessages ref uid uid 4 const 1
Query Time: 0.00357294082642
(Plugin Hook: index_start)
#22 - Select Query
SELECT template FROM templates WHERE title='portal_pms' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 8.79764556885E-5
(Plugin Hook: index_start)
#23 - Select Query
SELECT template FROM templates WHERE title='portal_stats' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 7.79628753662E-5
(Plugin Hook: index_start)
#24 - Select Query
SELECT template FROM templates WHERE title='portal_search' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 9.51290130615E-5
(Plugin Hook: index_start)
#25 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, u.username, u.invisible, u.usergroup, u.displaygroup FROM sessions s LEFT JOIN users u ON (s.uid=u.uid) WHERE s.time>'1331920091' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 15 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 dugokona_mybb1.s.uid 1
Query Time: 0.000548124313354
(Plugin Hook: index_start)
#26 - Select Query
SELECT template FROM templates WHERE title='portal_whosonline_memberbit' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 9.70363616943E-5
(Plugin Hook: index_start)
#27 - Select Query
SELECT template FROM templates WHERE title='portal_whosonline' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.00724792480469
(Plugin Hook: index_start)
#28 - Select Query
SELECT t.*, u.username FROM threads t LEFT JOIN users u ON (u.uid=t.uid) WHERE 1=1 AND t.visible='1' AND t.closed NOT LIKE 'moved|%' ORDER BY t.lastpost DESC LIMIT 0, 10
table type possible_keys key key_len ref rows Extra
t index lastpost 10 10 Using where
u eq_ref PRIMARY PRIMARY 4 dugokona_mybb1.t.uid 1
Query Time: 0.000885009765625
(Plugin Hook: index_start)
#29 - Select Query
SELECT template FROM templates WHERE title='portal_latestthreads_thread' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 8.20159912109E-5
(Plugin Hook: index_start)
#30 - Select Query
SELECT template FROM templates WHERE title='portal_latestthreads' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.0161309242249
(Plugin Hook: index_start)
#31 - Select Query
SELECT u.* FROM users u LEFT JOIN usergroups g ON (g.gid=u.usergroup) WHERE u.lastactive > 1331834591 ORDER BY u.lastactive DESC
table type possible_keys key key_len ref rows Extra
u ALL 156 Using where; Using filesort
g eq_ref PRIMARY PRIMARY 2 dugokona_mybb1.u.usergroup 1 Using index
Query Time: 0.000963926315308
(Plugin Hook: index_start)
#32 - Select Query
SELECT COUNT(post.dateline) AS postcount, post.uid, user.uid, user.username, user.usergroup, user.displaygroup, user.avatar FROM posts AS post JOIN users AS user ON (post.uid=user.uid) WHERE dateline > 1331834591 GROUP BY post.uid ORDER BY postcount DESC LIMIT 5
table type possible_keys key key_len ref rows Extra
post range uid,dateline dateline 8 50 Using where; Using temporary; Using filesort
user eq_ref PRIMARY PRIMARY 4 dugokona_mybb1.post.uid 1
Query Time: 0.000861883163452
(Plugin Hook: index_start)
#33 - Select Query
SELECT template FROM templates WHERE title='ttp_bit' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.000106811523438
(Plugin Hook: index_start)
#34 - Select Query
SELECT template FROM templates WHERE title='ttp_index' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 9.51290130615E-5
(Plugin Hook: index_start)
#35 - Select Query
SELECT tid, subject, username FROM `threads` WHERE visible = '1' AND closed NOT LIKE 'moved|%' AND `replies` > 1 ORDER BY `lastpost` DESC LIMIT 25
table type possible_keys key key_len ref rows Extra
threads index lastpost 10 25 Using where
Query Time: 0.0120098590851
(Plugin Hook: index_start)
#36 - Select Query
SELECT template FROM templates WHERE title='tag_cloud_bit' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.000320911407471
(Plugin Hook: index_start)
#37 - Select Query
SELECT template FROM templates WHERE title='tag_cloud' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.0146150588989
(Plugin Hook: index_start)
#38 - Select Query
SELECT username,postnum,uid,usergroup,displaygroup FROM users ORDER BY uid DESC LIMIT 0,8
table type possible_keys key key_len ref rows Extra
users index PRIMARY 4 8
Query Time: 0.0181369781494
(Plugin Hook: index_start)
#39 - Select Query
SELECT template FROM templates WHERE title='newcomers' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 9.58442687988E-5
(Plugin Hook: index_start)
#40 - Select Query
SELECT username,postnum,uid,usergroup,displaygroup FROM users ORDER BY postnum DESC LIMIT 0,8
table type possible_keys key key_len ref rows Extra
users ALL 156 Using filesort
Query Time: 0.00767087936401
(Plugin Hook: index_start)
#41 - Select Query
SELECT template FROM templates WHERE title='topposters' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.000171899795532
(Plugin Hook: index_start)
#42 - Select Query
SELECT subject,username,uid,tid,replies FROM threads WHERE visible='1' AND closed NOT LIKE 'moved|%' ORDER BY dateline DESC LIMIT 0,8
table type possible_keys key key_len ref rows Extra
threads index dateline 8 8 Using where
Query Time: 0.000643014907837
(Plugin Hook: index_start)
#43 - Select Query
SELECT template FROM templates WHERE title='newthreads' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.000204801559448
(Plugin Hook: index_start)
#44 - Select Query
SELECT subject,username,uid,pid,tid FROM posts WHERE visible='1' ORDER BY dateline DESC LIMIT 0,8
table type possible_keys key key_len ref rows Extra
posts index visible dateline 8 8 Using where
Query Time: 0.000144004821777
(Plugin Hook: index_start)
#45 - Select Query
SELECT template FROM templates WHERE title='latestposts' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.000122785568237
(Plugin Hook: index_start)
#46 - Select Query
SELECT template FROM templates WHERE title='top5stats_index' AND sid IN ('-2','-1','22') ORDER BY sid DESC LIMIT 1
table type possible_keys key key_len ref rows Extra
templates ALL 722 Using where; Using filesort
Query Time: 0.00760889053345
#47 - Select Query
SELECT s.sid, s.ip, s.uid, s.time, s.location, s.location1, u.username, u.invisible, u.usergroup, u.displaygroup FROM sessions s LEFT JOIN users u ON (s.uid=u.uid) WHERE s.time>'1331920091' ORDER BY u.username ASC, s.time DESC
table type possible_keys key key_len ref rows Extra
s range time time 8 15 Using where; Using temporary; Using filesort
u eq_ref PRIMARY PRIMARY 4 dugokona_mybb1.s.uid 1
Query Time: 0.00117015838623
#48 - Select Query
SELECT f.*, fr.dateline AS lastread FROM forums f LEFT JOIN 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 37 Using where; Using filesort
fr eq_ref fid fid 8 dugokona_mybb1.f.fid,const 1
Query Time: 0.000237941741943
Template Statistics
Templates Used (Loaded for this Page) - 63 Total
my_ideas_link, your_side_bar, 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, index_whosonline_memberbit, forumbit_depth2_cat, nav, nav_bit, nav_bit_active, htmldoctype, footer_languageselect, index_boardstats, forumbit_depth2_forum_lastpost, forumbit_depth1_forum_lastpost, , staff_online_bit, staff_online, iad, portal, portal_welcome_membertext, portal_welcome, portal_pms, portal_stats, portal_search, portal_whosonline_memberbit, portal_whosonline, portal_latestthreads_thread, portal_latestthreads, ttp_bit, ttp_index, tag_cloud_bit, tag_cloud, newcomers, topposters, newthreads, latestposts, top5stats_index
Templates Requiring Additional Calls (Not Cached at Startup) - 23 Total
my_ideas_link, your_side_bar, staff_online_bit, staff_online, iad, portal_welcome_membertext, portal_welcome, portal_pms, portal_stats, portal_search, portal_whosonline_memberbit, portal_whosonline, portal_latestthreads_thread, portal_latestthreads, ttp_bit, ttp_index, tag_cloud_bit, tag_cloud, newcomers, topposters, newthreads, latestposts, top5stats_index