Thread: 67 queries?!
View Single Post
  #34  
Old 11-15-2002, 05:51 PM
Bison's Avatar
Bison Bison is offline
 
Join Date: Jun 2002
Location: Virginia Beach, Virginia
Posts: 522
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
I hate to jump in but i'm having simular issues with my index page. this line appears several times which has jumped my queries on my index page to a shocking 90 queries!

Query: SELECT template FROM template WHERE title='options'
Time before: 0.028990030288696
Time after: 0.030089020729065

Query: SELECT sessionhash,userid,host,useragent,styleid FROM session WHERE lastactivity>1037380414 AND sessionhash='57565ca59c79463a10c80c458c712492' AND host='24.52.238.196' AND useragent='Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1;'
Time before: 0.036381006240845
Time after: 0.036906003952026

Query: SELECT user.*,userfield.* FROM user LEFT JOIN userfield ON userfield.userid=user.userid WHERE user.userid='1'
Time before: 0.037148952484131
Time after: 0.038058996200562

Query: UPDATE user SET timeonline=timeonline+214 WHERE userid='1'
Time before: 0.038669943809509
Time after: 0.038979053497314

Query: SELECT templatesetid,replacementsetid,userselect FROM style WHERE styleid='24'
Time before: 0.03931999206543
Time after: 0.039639949798584

Query: SELECT template,title
FROM template
WHERE (title IN ('forumhome_birthdaybit','error_nopermission','for umhome_pmloggedin','forumhome_ welcometext','forumhome_logoutcode','forumhome_new posts','forumhome_todayposts', 'forumhome_logincode','forumhome_todayloggedinuser ','forumhome_todayloggedinuser s','forumhome_loggedinuser','forumhome_loggedinuse rs','forumhome_lastpostby','fo rumhome_moderator','forumhome_forumbit_level1_nopo st','forumhome_forumbit_level1 _post','forumhome_forumbit_level2_nopost','forumho me_forumbit_level2_post','foru mhome','forumhome_unregmessage','gobutton','timezo ne','username_loggedout','user name_loggedin','phpinclude','headinclude','header' ,'footer','forumjumpbit','foru mjump','nav_linkoff','nav_linkon','navbar','nav_jo iner','pagenav','pagenav_curpa ge','pagenav_firstlink','pagenav_lastlink','pagena v_nextlink','pagenav_pagelink' ,'pagenav_prevlink','home_microstats')
AND (templatesetid=-1 OR templatesetid='19'))
OR (title = 'maxloggedin')
OR (title = 'birthdays')
ORDER BY templatesetid
Time before: 0.0398850440979
Time after: 0.053624987602234

Query: SELECT COUNT(*) AS count FROM session WHERE userid=0 AND lastactivity>1037380414
Time before: 0.056285977363586
Time after: 0.056926965713501

Query: SELECT COUNT(DISTINCT(userid)) AS count FROM session WHERE session.userid>0 AND session.lastactivity>1037380414
Time before: 0.05706000328064
Time after: 0.057842969894409

Query: SELECT * FROM usergroup WHERE usergroupid=6
Time before: 0.060628056526184
Time after: 0.061303973197937

Query: SELECT template
FROM template
WHERE title='memberoftheday'
AND templatesetid=-2
Time before: 0.064283013343811
Time after: 0.06466805934906

Query: SELECT user.avatarid,avatarpath,NOT ISNULL(avatardata) AS hascustom,customavatar.dateline
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid='1'
Time before: 0.064878940582275
Time after: 0.066051959991455

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1
Time before: 0.066372036933899
Time after: 0.066789031028748

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND dateline>1037344130 AND folderid=0
Time before: 0.066923022270203
Time after: 0.067540049552917

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND messageread=0 AND folderid=0
Time before: 0.067765951156616
Time after: 0.068228006362915

Query: SELECT COUNT(*) AS messages FROM privatemessage WHERE userid=1 AND folderid=0
Time before: 0.068578958511353
Time after: 0.069056034088135

Query: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user
Time before: 0.070255994796753
Time after: 0.070462942123413

Query: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE posts=0
Time before: 0.070605993270874
Time after: 0.072136998176575

Query: SELECT COUNT(*) AS users,MAX(userid) FROM user WHERE posts=1
Time before: 0.072307944297791
Time after: 0.073686003684998

Query: SELECT COUNT(*) AS users,MAX(userid) AS max FROM user WHERE joindate

Query: SELECT userid,username,posts FROM user ORDER BY posts DESC LIMIT 10
Time before: 0.075706005096436
Time after: 0.077715039253235

Query: SELECT DISTINCT(userid),COUNT(postid) AS posts FROM post WHERE userid > 0 AND post.dateline>=1037303014 GROUP BY userid ORDER BY posts DESC LIMIT 10
Time before: 0.078215003013611
Time after: 0.14599597454071

Query: SELECT username FROM user WHERE userid=142
Time before: 0.14624905586243
Time after: 0.1465630531311

Query: SELECT username FROM user WHERE userid=173
Time before: 0.14674603939056
Time after: 0.1471780538559

Query: SELECT username FROM user WHERE userid=164
Time before: 0.14748001098633
Time after: 0.14765405654907

Query: SELECT username FROM user WHERE userid=71
Time before: 0.1478099822998
Time after: 0.14804303646088

Query: SELECT username FROM user WHERE userid=132
Time before: 0.14824604988098
Time after: 0.14847004413605

Query: SELECT username FROM user WHERE userid=5
Time before: 0.14866399765015
Time after: 0.14887797832489

Query: SELECT username FROM user WHERE userid=16
Time before: 0.14907598495483
Time after: 0.14929699897766

Query: SELECT username FROM user WHERE userid=114
Time before: 0.14949202537537
Time after: 0.14970302581787

Query: SELECT username FROM user WHERE userid=40
Time before: 0.14989900588989
Time after: 0.15011298656464

Query: SELECT username FROM user WHERE userid=179
Time before: 0.15030801296234
Time after: 0.15053200721741

Query: SELECT template FROM template WHERE title='g_statistics' AND (templatesetid=-1 OR templatesetid='19') ORDER BY templatesetid DESC LIMIT 1
Time before: 0.15075099468231
Time after: 0.15162599086761

Query: SELECT username,userid,timeonline FROM user WHERE userid > 1 ORDER BY timeonline DESC LIMIT 1
Time before: 0.15185904502869
Time after: 0.15404903888702

Query: SELECT postid AS posts FROM post ORDER BY postid DESC LIMIT 1
Time before: 0.15432798862457
Time after: 0.15449500083923

Query: SELECT threadid AS threads FROM thread ORDER BY threadid DESC LIMIT 1
Time before: 0.15462899208069
Time after: 0.15504205226898

Query: SELECT userid,username FROM user WHERE userid=181
Time before: 0.15522801876068
Time after: 0.15545797348022

Query: SELECT COUNT(*) AS threads FROM thread WHERE lastpost > '1037344130'
Time before: 0.15562796592712
Time after: 0.15971195697784

Query: SELECT count(*) AS posts FROM post WHERE dateline > '1037344130'
Time before: 0.15988099575043
Time after: 0.19722998142242

Query: SELECT style.title, user.styleid, COUNT(*) AS count FROM user LEFT JOIN style USING (styleid) WHERE style.styleid IS NOT NULL AND style.userselect=1 GROUP BY user.styleid
Time before: 0.19739603996277
Time after: 0.20033705234528

Query: SELECT template FROM template WHERE title='forumhome_dropdownbit' AND (templatesetid=-1 OR templatesetid='19') ORDER BY templatesetid DESC LIMIT 1
Time before: 0.20062303543091
Time after: 0.20155501365662

Query: SELECT * FROM forum WHERE displayorder<>0 AND active=1 ORDER BY parentid,displayorder
Time before: 0.20349204540253
Time after: 0.20521998405457

Query: SELECT forumid,canview,canpostnew FROM forumpermission WHERE usergroupid='6'
Time before: 0.21054005622864
Time after: 0.21099603176117

Query: SELECT forumid,accessmask FROM access WHERE userid='1'
Time before: 0.21127700805664
Time after: 0.21157097816467

Query: SELECT user.userid,user.username,moderator.forumid
FROM moderator
LEFT JOIN user
ON (moderator.userid=user.userid)
ORDER BY user.username
Time before: 0.21170401573181
Time after: 0.21375501155853

Query: SELECT COUNT(*) AS sessions FROM session WHERE userid=0 AND lastactivity>1037380415
Time before: 0.21618103981018
Time after: 0.21690499782562

Query: SELECT COUNT(*) AS sessions FROM session WHERE userid>0 AND lastactivity>1037380415
Time before: 0.21703994274139
Time after: 0.2175829410553

Query: SELECT DISTINCT session.userid,username,invisible,usergroupid
FROM session
LEFT JOIN user ON (user.userid=session.userid)
WHERE session.userid>0 AND session.lastactivity>1037380415
ORDER BY invisible ASC, username ASC
Time before: 0.21829295158386
Time after: 0.21945405006409

Query: SELECT userid, username, usergroupid, lastactivity, invisible FROM user
WHERE lastactivity > 1037343600
ORDER BY username
Time before: 0.22246098518372
Time after: 0.22455894947052

Query:
SELECT COUNT(*) AS count, inforum
FROM user
WHERE lastactivity>1037380414
AND lastvisit<>lastactivity
GROUP BY inforum

Time before: 0.23457598686218
Time after: 0.236083984375

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=3
Time before: 0.23655498027802
Time after: 0.23730397224426

Query: SELECT template FROM template WHERE title='forumhome_newforumthreads' AND (templatesetid=-1 OR templatesetid='19') ORDER BY templatesetid DESC LIMIT 1
Time before: 0.23760294914246
Time after: 0.23877704143524

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=4
Time before: 0.24047100543976
Time after: 0.24087905883789

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=53
Time before: 0.24284100532532
Time after: 0.24322700500488

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=35
Time before: 0.24459004402161
Time after: 0.24491202831268

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=20
Time before: 0.24664103984833
Time after: 0.2471729516983

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=37
Time before: 0.24912095069885
Time after: 0.24941897392273

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=38
Time before: 0.2509800195694
Time after: 0.25136005878448

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=26
Time before: 0.25331604480743
Time after: 0.25352001190186

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=27
Time before: 0.25516498088837
Time after: 0.25558400154114

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=28
Time before: 0.25710201263428
Time after: 0.25764095783234

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=29
Time before: 0.25941598415375
Time after: 0.2599960565567

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=1
Time before: 0.26179897785187
Time after: 0.26199495792389

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=2
Time before: 0.26357901096344
Time after: 0.26453304290771

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=33
Time before: 0.26654398441315
Time after: 0.26704895496368

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=32
Time before: 0.26881396770477
Time after: 0.27069997787476

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=5
Time before: 0.27237796783447
Time after: 0.27317702770233

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=44
Time before: 0.27496600151062
Time after: 0.27517104148865

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=34
Time before: 0.27671599388123
Time after: 0.27701604366302

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=6
Time before: 0.27877295017242
Time after: 0.27897298336029

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=7
Time before: 0.28059005737305
Time after: 0.28095495700836

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=40
Time before: 0.28271305561066
Time after: 0.28316497802734

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=21
Time before: 0.28473496437073
Time after: 0.28509998321533

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=30
Time before: 0.28676199913025
Time after: 0.28702199459076

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=8
Time before: 0.28881895542145
Time after: 0.28944098949432

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=10
Time before: 0.29133296012878
Time after: 0.29168200492859

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=39
Time before: 0.29352200031281
Time after: 0.29386496543884

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=9
Time before: 0.29544997215271
Time after: 0.29576897621155

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=11
Time before: 0.29733800888062
Time after: 0.29765200614929

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=12
Time before: 0.29985797405243
Time after: 0.30007195472717

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=13
Time before: 0.30181300640106
Time after: 0.30256700515747

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=43
Time before: 0.30449604988098
Time after: 0.30477404594421

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=14
Time before: 0.3062299489975
Time after: 0.30673694610596

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=15
Time before: 0.308434009552
Time after: 0.30870294570923

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=17
Time before: 0.31029105186462
Time after: 0.31058895587921

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=16
Time before: 0.31226694583893
Time after: 0.31331396102905

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=18
Time before: 0.31527101993561
Time after: 0.31547796726227

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=19
Time before: 0.31704497337341
Time after: 0.32025003433228

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=36
Time before: 0.32246005535126
Time after: 0.32312798500061

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=23
Time before: 0.32481598854065
Time after: 0.32508099079132

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=25
Time before: 0.32689094543457
Time after: 0.32720601558685

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=24
Time before: 0.32884502410889
Time after: 0.32937395572662

Query: SELECT COUNT(threadid) AS total FROM thread WHERE dateline>1037344130 and forumid=22
Time before: 0.33109605312347
Time after: 0.33147799968719

Query: SELECT findword,replaceword FROM replacement WHERE replacementsetid IN(-1,'20') ORDER BY replacementsetid DESC,replacementid DESC
Time before: 0.34253704547882
Time after: 0.34418594837189
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01319 seconds
  • Memory Usage 1,841KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete