Query:	SELECT COUNT(user_id) AS total
	FROM nuke_users
	WHERE user_id <> 1

Time before:  0.0238149166107
Time after:   0.0239968299866
Elapsed time: 0.000181913375854

Query:	SELECT SUM(forum_topics) AS topic_total, SUM(forum_posts) AS post_total
	FROM nuke_bbforums

Time before:  0.0240888595581
Time after:   0.0242819786072
Elapsed time: 0.000193119049072

Query:	SELECT user_id, user_color_gc, username
	FROM nuke_users
	WHERE user_id <> 1
	ORDER BY user_id DESC
	LIMIT 1

Time before:  0.0243599414825
Time after:   0.0245499610901
Elapsed time: 0.000190019607544

Query:	SELECT user_regdate
	FROM nuke_users
	WHERE user_id = 14
	LIMIT 1

Time before:  0.025004863739
Time after:   0.0251648426056
Elapsed time: 0.000159978866577

Query:	SELECT *
	FROM nuke_bbconfig
	WHERE config_name = 'record_online_users' OR config_name = 'record_online_date'

Time before:  0.025239944458
Time after:   0.0255398750305
Elapsed time: 0.00029993057251

Query:	SELECT SUM(user_posts) as total_posts FROM nuke_users WHERE user_id <> 1

Time before:  0.0294749736786
Time after:   0.0297060012817
Elapsed time: 0.000231027603149

Query:	SELECT user_id, user_color_gc, username, user_posts
	FROM nuke_users
	WHERE (user_id <> 1 ) AND (user_posts > 0)
	ORDER BY user_posts DESC
	LIMIT 10

Time before:  0.0297868251801
Time after:   0.0300669670105
Elapsed time: 0.000280141830444

Query:	SELECT COUNT(topic_id) as total_topics FROM nuke_bbtopics WHERE topic_status <> 2

Time before:  0.0358638763428
Time after:   0.0361349582672
Elapsed time: 0.000271081924438

Query:	SELECT u.user_id, u.user_color_gc, u.username, COUNT(t.topic_poster) num_topics
	FROM nuke_users u, nuke_bbtopics t
	WHERE (t.topic_poster <> 1) AND (u.user_posts > 0) AND (u.user_id = t.topic_poster)
	GROUP BY t.topic_poster ORDER BY num_topics DESC
	LIMIT 10

Time before:  0.0362188816071
Time after:   0.0366320610046
Elapsed time: 0.000413179397583

Query:	SELECT u.user_id, u.user_color_gc, u.username, count(u.user_id) as user_posts
	FROM nuke_users u, nuke_bbposts p
	WHERE (u.user_id = p.poster_id) AND (p.post_time > '1243227600') AND (u.user_id <> 1)
	GROUP BY user_id, username
	ORDER BY user_posts DESC
	LIMIT 10

Time before:  0.0413348674774
Time after:   0.0425069332123
Elapsed time: 0.00117206573486

Query:	SELECT u.user_id, u.user_color_gc, u.username, count(u.user_id) as user_posts
	FROM nuke_users u, nuke_bbposts p
	WHERE (u.user_id = p.poster_id) AND (p.post_time > '1241157600') AND (u.user_id <> 1)
	GROUP BY user_id, username
	ORDER BY user_posts DESC
	LIMIT 10

Time before:  0.0479209423065
Time after:   0.0493500232697
Elapsed time: 0.00142908096313

Query:	SELECT topic_id, forum_id, topic_title, topic_replies
	FROM nuke_bbtopics
	WHERE (topic_status <> 2) AND (topic_replies > 0)
	ORDER BY topic_replies DESC
	LIMIT 10

Time before:  0.055104970932
Time after:   0.055340051651
Elapsed time: 0.000235080718994

Query:	SELECT forum_id, topic_id, topic_title, topic_views
	FROM nuke_bbtopics
	WHERE (topic_status <> 2) AND (topic_views > 0)
	ORDER BY topic_views DESC
	LIMIT 10

Time before:  0.0617928504944
Time after:   0.0620229244232
Elapsed time: 0.000230073928833

Query:	SELECT COUNT( word_id ) total_words FROM nuke_bbsearch_wordmatch

Time before:  0.0676770210266
Time after:   0.0704810619354
Elapsed time: 0.00280404090881

Query:	SELECT COUNT( swm.word_id ) word_count, swm.word_id word_id, swl.word_text word_text
	FROM nuke_bbsearch_wordmatch swm, nuke_bbsearch_wordlist swl
	WHERE swm.word_id = swl.word_id AND swl.word_text != 'nbsp'
	GROUP BY swm.word_id ORDER BY word_count DESC
	LIMIT 10

Time before:  0.0705809593201
Time after:   0.0740129947662
Elapsed time: 0.00343203544617

Query:	SELECT YEAR(FROM_UNIXTIME(topic_time)) as year_topic, MONTH(FROM_UNIXTIME(topic_time)) as month_topic, COUNT(*) AS num_topics
	FROM nuke_bbtopics
	GROUP BY YEAR(FROM_UNIXTIME(topic_time)), MONTH(FROM_UNIXTIME(topic_time))
	ORDER BY topic_time

Time before:  0.0797588825226
Time after:   0.0800378322601
Elapsed time: 0.000278949737549

Query:	SELECT * FROM nuke_bbstats_smilies_info

Time before:  0.0839478969574
Time after:   0.084324836731
Elapsed time: 0.00037693977356

Query:	SELECT * FROM nuke_bbstats_smilies_index

Time before:  0.0844049453735
Time after:   0.0847108364105
Elapsed time: 0.000305891036987

Query:	SELECT max(post_id) as total FROM nuke_bbposts

Time before:  0.0849618911743
Time after:   0.0851349830627
Elapsed time: 0.000173091888428

Query:	SELECT COUNT(post_id) as total FROM nuke_bbposts

Time before:  0.0852048397064
Time after:   0.0853378772736
Elapsed time: 0.000133037567139

Query:	SELECT smile_url FROM nuke_bbsmilies GROUP BY smile_url

Time before:  0.0854108333588
Time after:   0.0858099460602
Elapsed time: 0.000399112701416

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_arrow.gif'

Time before:  0.0860018730164
Time after:   0.0862138271332
Elapsed time: 0.000211954116821

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:arrow:%' AND post_id > 85

Time before:  0.0863070487976
Time after:   0.0866549015045
Elapsed time: 0.000347852706909

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_biggrin.gif'

Time before:  0.0867478847504
Time after:   0.0869488716125
Elapsed time: 0.000200986862183

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:D%' AND post_id > 85

Time before:  0.0870518684387
Time after:   0.088634967804
Elapsed time: 0.00158309936523

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:-D%' AND post_id > 85

Time before:  0.0887289047241
Time after:   0.0889139175415
Elapsed time: 0.000185012817383

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:grin:%' AND post_id > 85

Time before:  0.0889959335327
Time after:   0.0891709327698
Elapsed time: 0.000174999237061

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_confused.gif'

Time before:  0.0892679691315
Time after:   0.0894589424133
Elapsed time: 0.00019097328186

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:?%' AND post_id > 85

Time before:  0.0895888805389
Time after:   0.0897738933563
Elapsed time: 0.000185012817383

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:-?%' AND post_id > 85

Time before:  0.0898540019989
Time after:   0.0900299549103
Elapsed time: 0.000175952911377

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:???:%' AND post_id > 85

Time before:  0.0901119709015
Time after:   0.090283870697
Elapsed time: 0.000171899795532

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_cool.gif'

Time before:  0.0903768539429
Time after:   0.0905699729919
Elapsed time: 0.000193119049072

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%8)%' AND post_id > 85

Time before:  0.0906798839569
Time after:   0.0908648967743
Elapsed time: 0.000185012817383

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%8-)%' AND post_id > 85

Time before:  0.0909469127655
Time after:   0.0911169052124
Elapsed time: 0.000169992446899

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:cool:%' AND post_id > 85

Time before:  0.091197013855
Time after:   0.0913789272308
Elapsed time: 0.000181913375854

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_cry.gif'

Time before:  0.0914719104767
Time after:   0.0916650295258
Elapsed time: 0.000193119049072

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:cry:%' AND post_id > 85

Time before:  0.0917558670044
Time after:   0.0919418334961
Elapsed time: 0.000185966491699

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_eek.gif'

Time before:  0.0920360088348
Time after:   0.0922269821167
Elapsed time: 0.00019097328186

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%8O%' AND post_id > 85

Time before:  0.0923318862915
Time after:   0.0925040245056
Elapsed time: 0.000172138214111

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%8-O%' AND post_id > 85

Time before:  0.0925960540771
Time after:   0.0927729606628
Elapsed time: 0.000176906585693

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:shock:%' AND post_id > 85

Time before:  0.0928528308868
Time after:   0.0930259227753
Elapsed time: 0.000173091888428

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_evil.gif'

Time before:  0.0931220054626
Time after:   0.0933029651642
Elapsed time: 0.000180959701538

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:evil:%' AND post_id > 85

Time before:  0.0933940410614
Time after:   0.093582868576
Elapsed time: 0.000188827514648

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_exclaim.gif'

Time before:  0.0936808586121
Time after:   0.0938608646393
Elapsed time: 0.000180006027222

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:!:%' AND post_id > 85

Time before:  0.0939519405365
Time after:   0.094132900238
Elapsed time: 0.000180959701538

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_idea.gif'

Time before:  0.0942258834839
Time after:   0.0944118499756
Elapsed time: 0.000185966491699

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:idea:%' AND post_id > 85

Time before:  0.0945010185242
Time after:   0.0947108268738
Elapsed time: 0.000209808349609

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_lol.gif'

Time before:  0.094810962677
Time after:   0.0950000286102
Elapsed time: 0.000189065933228

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:lol:%' AND post_id > 85

Time before:  0.0950889587402
Time after:   0.0952789783478
Elapsed time: 0.000190019607544

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_mad.gif'

Time before:  0.0953719615936
Time after:   0.095566034317
Elapsed time: 0.000194072723389

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:x%' AND post_id > 85

Time before:  0.0956709384918
Time after:   0.0958650112152
Elapsed time: 0.000194072723389

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:-x%' AND post_id > 85

Time before:  0.0959458351135
Time after:   0.0961248874664
Elapsed time: 0.000179052352905

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:mad:%' AND post_id > 85

Time before:  0.096204996109
Time after:   0.0963890552521
Elapsed time: 0.000184059143066

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_mrgreen.gif'

Time before:  0.096480846405
Time after:   0.0966758728027
Elapsed time: 0.000195026397705

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:mrgreen:%' AND post_id > 85

Time before:  0.0967659950256
Time after:   0.0969638824463
Elapsed time: 0.000197887420654

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_neutral.gif'

Time before:  0.0970768928528
Time after:   0.097275018692
Elapsed time: 0.000198125839233

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:|%' AND post_id > 85

Time before:  0.0973789691925
Time after:   0.0975799560547
Elapsed time: 0.000200986862183

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:-|%' AND post_id > 85

Time before:  0.0976629257202
Time after:   0.0978519916534
Elapsed time: 0.000189065933228

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:neutral:%' AND post_id > 85

Time before:  0.0979318618774
Time after:   0.0981159210205
Elapsed time: 0.000184059143066

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_question.gif'

Time before:  0.098207950592
Time after:   0.0983989238739
Elapsed time: 0.00019097328186

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:?:%' AND post_id > 85

Time before:  0.0984890460968
Time after:   0.0986769199371
Elapsed time: 0.000187873840332

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_razz.gif'

Time before:  0.0987720489502
Time after:   0.098965883255
Elapsed time: 0.00019383430481

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:P%' AND post_id > 85

Time before:  0.0990698337555
Time after:   0.0992560386658
Elapsed time: 0.000186204910278

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:-P%' AND post_id > 85

Time before:  0.0993359088898
Time after:   0.0995109081268
Elapsed time: 0.000174999237061

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:razz:%' AND post_id > 85

Time before:  0.0995948314667
Time after:   0.0997738838196
Elapsed time: 0.000179052352905

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_redface.gif'

Time before:  0.0998659133911
Time after:   0.10006403923
Elapsed time: 0.000198125839233

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:oops:%' AND post_id > 85

Time before:  0.100155830383
Time after:   0.100338935852
Elapsed time: 0.00018310546875

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_rolleyes.gif'

Time before:  0.100432872772
Time after:   0.100621938705
Elapsed time: 0.000189065933228

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:roll:%' AND post_id > 85

Time before:  0.100712060928
Time after:   0.100891828537
Elapsed time: 0.000179767608643

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_sad.gif'

Time before:  0.100986003876
Time after:   0.101181983948
Elapsed time: 0.000195980072021

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:(%' AND post_id > 85

Time before:  0.101284980774
Time after:   0.101469039917
Elapsed time: 0.000184059143066

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:-(%' AND post_id > 85

Time before:  0.101552963257
Time after:   0.101731061935
Elapsed time: 0.000178098678589

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:sad:%' AND post_id > 85

Time before:  0.101819992065
Time after:   0.101996898651
Elapsed time: 0.000176906585693

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_smile.gif'

Time before:  0.102090835571
Time after:   0.102284908295
Elapsed time: 0.000194072723389

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:)%' AND post_id > 85

Time before:  0.102387905121
Time after:   0.10257601738
Elapsed time: 0.000188112258911

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:-)%' AND post_id > 85

Time before:  0.102656841278
Time after:   0.102830886841
Elapsed time: 0.000174045562744

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:smile:%' AND post_id > 85

Time before:  0.102917909622
Time after:   0.103096961975
Elapsed time: 0.000179052352905

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_surprised.gif'

Time before:  0.103190898895
Time after:   0.103382825851
Elapsed time: 0.000191926956177

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:o%' AND post_id > 85

Time before:  0.103486061096
Time after:   0.103667974472
Elapsed time: 0.000181913375854

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:-o%' AND post_id > 85

Time before:  0.103749036789
Time after:   0.10392999649
Elapsed time: 0.000180959701538

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:eek:%' AND post_id > 85

Time before:  0.104009866714
Time after:   0.104187011719
Elapsed time: 0.000177145004272

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_twisted.gif'

Time before:  0.104301929474
Time after:   0.104487895966
Elapsed time: 0.000185966491699

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:twisted:%' AND post_id > 85

Time before:  0.104581832886
Time after:   0.104765892029
Elapsed time: 0.000184059143066

Query:	SELECT *
	FROM nuke_bbsmilies
	WHERE smile_url = 'icon_wink.gif'

Time before:  0.104859828949
Time after:   0.105051994324
Elapsed time: 0.000192165374756

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%:wink:%' AND post_id > 85

Time before:  0.10515499115
Time after:   0.105340957642
Elapsed time: 0.000185966491699

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%;)%' AND post_id > 85

Time before:  0.105422019958
Time after:   0.105595827103
Elapsed time: 0.000173807144165

Query:	SELECT post_id, post_text
	FROM nuke_bbposts_text
	WHERE post_text LIKE '%;-)%' AND post_id > 85

Time before:  0.105675935745
Time after:   0.105865001678
Elapsed time: 0.000189065933228

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_arrow.gif'

Time before:  0.105957984924
Time after:   0.106209993362
Elapsed time: 0.00025200843811

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 8 WHERE smile_url = 'icon_biggrin.gif'

Time before:  0.106260061264
Time after:   0.106497049332
Elapsed time: 0.000236988067627

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 2 WHERE smile_url = 'icon_confused.gif'

Time before:  0.106549978256
Time after:   0.106782913208
Elapsed time: 0.000232934951782

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_cool.gif'

Time before:  0.10683298111
Time after:   0.107059001923
Elapsed time: 0.000226020812988

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_cry.gif'

Time before:  0.107107877731
Time after:   0.10734295845
Elapsed time: 0.000235080718994

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_eek.gif'

Time before:  0.107390880585
Time after:   0.107620954514
Elapsed time: 0.000230073928833

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_evil.gif'

Time before:  0.107668876648
Time after:   0.107903003693
Elapsed time: 0.000234127044678

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_exclaim.gif'

Time before:  0.107951879501
Time after:   0.10818696022
Elapsed time: 0.000235080718994

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_idea.gif'

Time before:  0.108235836029
Time after:   0.108468055725
Elapsed time: 0.000232219696045

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 5 WHERE smile_url = 'icon_lol.gif'

Time before:  0.108516931534
Time after:   0.108752965927
Elapsed time: 0.000236034393311

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_mad.gif'

Time before:  0.108800888062
Time after:   0.10903096199
Elapsed time: 0.000230073928833

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_mrgreen.gif'

Time before:  0.109081983566
Time after:   0.109313011169
Elapsed time: 0.000231027603149

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_neutral.gif'

Time before:  0.109366893768
Time after:   0.109603881836
Elapsed time: 0.000236988067627

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 2 WHERE smile_url = 'icon_question.gif'

Time before:  0.109652996063
Time after:   0.109885931015
Elapsed time: 0.000232934951782

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 1 WHERE smile_url = 'icon_razz.gif'

Time before:  0.109935045242
Time after:   0.11016702652
Elapsed time: 0.000231981277466

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_redface.gif'

Time before:  0.110214948654
Time after:   0.11044383049
Elapsed time: 0.000228881835938

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 1 WHERE smile_url = 'icon_rolleyes.gif'

Time before:  0.110496044159
Time after:   0.110730886459
Elapsed time: 0.000234842300415

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_sad.gif'

Time before:  0.110780000687
Time after:   0.11101102829
Elapsed time: 0.000231027603149

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 2 WHERE smile_url = 'icon_smile.gif'

Time before:  0.111058950424
Time after:   0.111289978027
Elapsed time: 0.000231027603149

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_surprised.gif'

Time before:  0.111338853836
Time after:   0.111572980881
Elapsed time: 0.000234127044678

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 0 WHERE smile_url = 'icon_twisted.gif'

Time before:  0.111620903015
Time after:   0.111853837967
Elapsed time: 0.000232934951782

Query:	UPDATE nuke_bbstats_smilies_index SET smile_count = 1 WHERE smile_url = 'icon_wink.gif'

Time before:  0.11190199852
Time after:   0.112133026123
Elapsed time: 0.000231027603149

Query:	UPDATE nuke_bbstats_smilies_info SET last_post_id = 87

Time before:  0.112180948257
Time after:   0.112370967865
Elapsed time: 0.000190019607544

Query:	SELECT topic_id, forum_id, topic_title, topic_replies, topic_views, topic_views/(topic_replies + 1) AS k
	FROM nuke_bbtopics
	WHERE (topic_status <> 2) AND (topic_replies > 0)
	ORDER BY k DESC
	LIMIT 10

Time before:  0.118929862976
Time after:   0.119251012802
Elapsed time: 0.00032114982605

Query:	SELECT topic_id, forum_id, topic_title, topic_replies, topic_views, topic_views/(topic_replies + 1) AS k
	FROM nuke_bbtopics
	WHERE (topic_status <> 2) AND (topic_replies > 0)
	ORDER BY k ASC
	LIMIT 10

Time before:  0.125128984451
Time after:   0.125412940979
Elapsed time: 0.00028395652771

Query:	SELECT SUBSTRING_INDEX(user_regdate,' ',-1) as year_regdate, SUBSTRING_INDEX(user_regdate,' ',1) as month_regdate, COUNT(*) AS num_user
	FROM nuke_users
	WHERE (user_id <> 1 )
	AND SUBSTRING_INDEX(user_regdate, ' ',1) <> 'Non'
	GROUP BY SUBSTRING_INDEX(user_regdate,' ',-1), SUBSTRING_INDEX(user_regdate,' ',1)

Time before:  0.131469011307
Time after:   0.131852865219
Elapsed time: 0.000383853912354

Query:	SELECT YEAR(FROM_UNIXTIME(post_time)) as year_post, MONTH(FROM_UNIXTIME(post_time)) as month_post, COUNT(*) AS num_posts
	FROM nuke_bbposts
	GROUP BY YEAR(FROM_UNIXTIME(post_time)), MONTH(FROM_UNIXTIME(post_time))
	ORDER BY post_time

Time before:  0.134826898575
Time after:   0.135195970535
Elapsed time: 0.000369071960449

Query:	SELECT a.post_id, p.forum_id as post_forum_id, t.topic_title, d.*
	FROM nuke_bbattachments a, nuke_bbattachments_desc d, nuke_bbposts p, nuke_bbtopics t
	WHERE (a.post_id = p.post_id) AND (p.topic_id = t.topic_id) AND (a.attach_id = d.attach_id) ORDER BY download_count DESC LIMIT 10

Time before:  0.140085935593
Time after:   0.140730857849
Elapsed time: 0.00064492225647

The Statistics Mod generated 115 queries,
spending 0.0343685150146 doing MySQL queries and 0.111766338348 doing PHP things.