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

Time before:  0.124626874924
Time after:   0.258491039276
Elapsed time: 0.133864164352
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_users  range  PRIMARY  PRIMARY  3    4810  1  Using where; Using index  

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

Time before:  0.259547948837
Time after:   0.259853839874
Elapsed time: 0.000305891036987
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_forums  ALL          15  1    

Query:	SELECT user_id, username
	FROM phpbb_users
	WHERE user_id <> -1
	ORDER BY user_id DESC
	LIMIT 1

Time before:  0.260416984558
Time after:   0.260756969452
Elapsed time: 0.000339984893799
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_users  range  PRIMARY  PRIMARY  3    4810  1  Using where  

Query:	SELECT user_regdate
	FROM phpbb_users
	WHERE user_id = 11999
	LIMIT 1

Time before:  0.384871959686
Time after:   0.385902881622
Elapsed time: 0.00103092193604
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_users  const  PRIMARY  PRIMARY  3  const  1  1    

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

Time before:  0.387469053268
Time after:   0.3889939785
Elapsed time: 0.00152492523193
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_config  range  PRIMARY  PRIMARY  255    2  2  Using where  

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

Time before:  0.457437992096
Time after:   0.505197048187
Elapsed time: 0.0477590560913
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_topics  range  topic_status  topic_status  1    1821  10  Using where; Using filesort  

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

Time before:  0.520503044128
Time after:   0.537910938263
Elapsed time: 0.0174078941345
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_topics  range  topic_status  topic_status  1    1821  10  Using where; Using filesort  

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

Time before:  0.547653913498
Time after:   0.711037874222
Elapsed time: 0.163383960724
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_users  range  PRIMARY  PRIMARY  3    4615  1  Using where  

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

Time before:  0.712240934372
Time after:   0.845831871033
Elapsed time: 0.133590936661
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_users  range  PRIMARY  PRIMARY  3    4615  10  Using where; Using filesort  

Query:	SELECT * FROM phpbb_stats_smilies_info

Time before:  0.857311964035
Time after:   0.857578992844
Elapsed time: 0.000267028808594
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_stats_smilies_info  system          1  1    

Query:	SELECT * FROM phpbb_stats_smilies_index

Time before:  0.858368873596
Time after:   0.858653068542
Elapsed time: 0.000284194946289
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_stats_smilies_index  ALL          22  22    

Query:	SELECT max(post_id) as total FROM phpbb_posts

Time before:  0.859387874603
Time after:   0.859740972519
Elapsed time: 0.000353097915649
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE                1  Select tables optimized away  

Query:	SELECT COUNT(post_id) as total FROM phpbb_posts

Time before:  0.860492944717
Time after:   0.870888948441
Elapsed time: 0.0103960037231
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts  index    forum_id  2    20726  1  Using index  

Query:	SELECT smile_url FROM phpbb_smilies GROUP BY smile_url

Time before:  0.871794939041
Time after:   0.871957063675
Elapsed time: 0.000162124633789
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  22  Using temporary; Using filesort  

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

Time before:  0.872720003128
Time after:   0.872839927673
Elapsed time: 0.000119924545288
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:arrow:%' AND post_id > 21025

Time before:  0.873296976089
Time after:   0.873775005341
Elapsed time: 0.000478029251099
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.874637842178
Time after:   0.874767065048
Elapsed time: 0.000129222869873
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  3  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:D%' AND post_id > 21025

Time before:  0.87517285347
Time after:   0.875587940216
Elapsed time: 0.000415086746216
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:-D%' AND post_id > 21025

Time before:  0.876334905624
Time after:   0.87674498558
Elapsed time: 0.000410079956055
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:grin:%' AND post_id > 21025

Time before:  0.877435922623
Time after:   0.877851963043
Elapsed time: 0.000416040420532
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.878392934799
Time after:   0.878519058228
Elapsed time: 0.000126123428345
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  3  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:?%' AND post_id > 21025

Time before:  0.878972053528
Time after:   0.879401922226
Elapsed time: 0.00042986869812
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:-?%' AND post_id > 21025

Time before:  0.879821062088
Time after:   0.880244016647
Elapsed time: 0.000422954559326
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:???:%' AND post_id > 21025

Time before:  0.880796909332
Time after:   0.881212949753
Elapsed time: 0.000416040420532
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.88165307045
Time after:   0.881773948669
Elapsed time: 0.000120878219604
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  3  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%8)%' AND post_id > 21025

Time before:  0.882195949554
Time after:   0.882617950439
Elapsed time: 0.00042200088501
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.883152008057
Time after:   0.883550882339
Elapsed time: 0.000398874282837
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:cool:%' AND post_id > 21025

Time before:  0.884002923965
Time after:   0.884394884109
Elapsed time: 0.000391960144043
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.884914875031
Time after:   0.885031938553
Elapsed time: 0.000117063522339
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:cry:%' AND post_id > 21025

Time before:  0.885422945023
Time after:   0.885869979858
Elapsed time: 0.000447034835815
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.886327981949
Time after:   0.886445999146
Elapsed time: 0.000118017196655
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:shock:%' AND post_id > 21025

Time before:  0.886823892593
Time after:   0.887228965759
Elapsed time: 0.000405073165894
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.88814997673
Time after:   0.888279914856
Elapsed time: 0.00012993812561
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:evil:%' AND post_id > 21025

Time before:  0.888689994812
Time after:   0.889117956161
Elapsed time: 0.000427961349487
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.889693021774
Time after:   0.889811992645
Elapsed time: 0.000118970870972
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:!:%' AND post_id > 21025

Time before:  0.89023399353
Time after:   0.890653848648
Elapsed time: 0.000419855117798
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.891103982925
Time after:   0.891221046448
Elapsed time: 0.000117063522339
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:idea:%' AND post_id > 21025

Time before:  0.891675949097
Time after:   0.892098903656
Elapsed time: 0.000422954559326
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.892541885376
Time after:   0.892658948898
Elapsed time: 0.000117063522339
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:lol:%' AND post_id > 21025

Time before:  0.893038988113
Time after:   0.893453836441
Elapsed time: 0.000414848327637
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.893913984299
Time after:   0.894039869308
Elapsed time: 0.000125885009766
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  3  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:x%' AND post_id > 21025

Time before:  0.894445896149
Time after:   0.894862890244
Elapsed time: 0.000416994094849
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:-x%' AND post_id > 21025

Time before:  0.895357847214
Time after:   0.89577794075
Elapsed time: 0.000420093536377
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:mad:%' AND post_id > 21025

Time before:  0.896167993546
Time after:   0.896568059921
Elapsed time: 0.000400066375732
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.897042036057
Time after:   0.897157907486
Elapsed time: 0.000115871429443
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:mrgreen:%' AND post_id > 21025

Time before:  0.897541999817
Time after:   0.897946834564
Elapsed time: 0.000404834747314
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.898400068283
Time after:   0.898519992828
Elapsed time: 0.000119924545288
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  3  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:|%' AND post_id > 21025

Time before:  0.898922920227
Time after:   0.899327993393
Elapsed time: 0.000405073165894
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:-|%' AND post_id > 21025

Time before:  0.899864912033
Time after:   0.900285005569
Elapsed time: 0.000420093536377
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:neutral:%' AND post_id > 21025

Time before:  0.900913953781
Time after:   0.90131688118
Elapsed time: 0.000402927398682
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.90175485611
Time after:   0.901872873306
Elapsed time: 0.000118017196655
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:?:%' AND post_id > 21025

Time before:  0.902267932892
Time after:   0.902673006058
Elapsed time: 0.000405073165894
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.903126955032
Time after:   0.903257846832
Elapsed time: 0.000130891799927
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  3  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:P%' AND post_id > 21025

Time before:  0.903746843338
Time after:   0.904193878174
Elapsed time: 0.000447034835815
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:-P%' AND post_id > 21025

Time before:  0.904630899429
Time after:   0.905024051666
Elapsed time: 0.000393152236938
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:razz:%' AND post_id > 21025

Time before:  0.905407905579
Time after:   0.905803918839
Elapsed time: 0.000396013259888
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.906250953674
Time after:   0.906368970871
Elapsed time: 0.000118017196655
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:oops:%' AND post_id > 21025

Time before:  0.906754970551
Time after:   0.90716791153
Elapsed time: 0.000412940979004
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.90940284729
Time after:   0.909566879272
Elapsed time: 0.000164031982422
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:roll:%' AND post_id > 21025

Time before:  0.91005897522
Time after:   0.910531044006
Elapsed time: 0.000472068786621
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  1  Using where  

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

Time before:  0.910977840424
Time after:   0.911113977432
Elapsed time: 0.000136137008667
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  3  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:(%' AND post_id > 21025

Time before:  0.911524057388
Time after:   0.9119348526
Elapsed time: 0.000410795211792
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:-(%' AND post_id > 21025

Time before:  0.912353038788
Time after:   0.912744998932
Elapsed time: 0.000391960144043
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:sad:%' AND post_id > 21025

Time before:  0.913692951202
Time after:   0.914160013199
Elapsed time: 0.00046706199646
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.914626836777
Time after:   0.914747953415
Elapsed time: 0.000121116638184
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  3  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:)%' AND post_id > 21025

Time before:  0.915133953094
Time after:   0.915546894073
Elapsed time: 0.000412940979004
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:-)%' AND post_id > 21025

Time before:  0.915940999985
Time after:   0.9163210392
Elapsed time: 0.000380039215088
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:smile:%' AND post_id > 21025

Time before:  0.916697025299
Time after:   0.917083978653
Elapsed time: 0.000386953353882
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.917641878128
Time after:   0.917773962021
Elapsed time: 0.000132083892822
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  3  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:o%' AND post_id > 21025

Time before:  0.918171882629
Time after:   0.918603897095
Elapsed time: 0.000432014465332
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:-o%' AND post_id > 21025

Time before:  0.91902589798
Time after:   0.919416904449
Elapsed time: 0.000391006469727
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:eek:%' AND post_id > 21025

Time before:  0.919800043106
Time after:   0.920341968536
Elapsed time: 0.000541925430298
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.920780897141
Time after:   0.920897960663
Elapsed time: 0.000117063522339
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:twisted:%' AND post_id > 21025

Time before:  0.921288967133
Time after:   0.921689033508
Elapsed time: 0.000400066375732
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.922356843948
Time after:   0.922479867935
Elapsed time: 0.000123023986816
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          42  3  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:wink:%' AND post_id > 21025

Time before:  0.922865867615
Time after:   0.923301935196
Elapsed time: 0.000436067581177
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%;)%' AND post_id > 21025

Time before:  0.923706054688
Time after:   0.924088001251
Elapsed time: 0.000381946563721
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

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

Time before:  0.924506902695
Time after:   0.924885988235
Elapsed time: 0.000379085540771
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    39  0  Using where  

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 27 WHERE smile_url = 'icon_arrow.gif'

Time before:  0.925314903259
Time after:   0.925554037094
Elapsed time: 0.000239133834839

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 728 WHERE smile_url = 'icon_biggrin.gif'

Time before:  0.925678014755
Time after:   0.925885915756
Elapsed time: 0.000207901000977

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 150 WHERE smile_url = 'icon_confused.gif'

Time before:  0.926110982895
Time after:   0.926327943802
Elapsed time: 0.000216960906982

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 149 WHERE smile_url = 'icon_cool.gif'

Time before:  0.926447868347
Time after:   0.92666387558
Elapsed time: 0.000216007232666

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 274 WHERE smile_url = 'icon_cry.gif'

Time before:  0.926779985428
Time after:   0.92698597908
Elapsed time: 0.000205993652344

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 141 WHERE smile_url = 'icon_eek.gif'

Time before:  0.92710185051
Time after:   0.927305936813
Elapsed time: 0.000204086303711

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 86 WHERE smile_url = 'icon_evil.gif'

Time before:  0.927422046661
Time after:   0.927624940872
Elapsed time: 0.000202894210815

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 48 WHERE smile_url = 'icon_exclaim.gif'

Time before:  0.927738904953
Time after:   0.92794084549
Elapsed time: 0.000201940536499

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 21 WHERE smile_url = 'icon_idea.gif'

Time before:  0.928053855896
Time after:   0.928253889084
Elapsed time: 0.000200033187866

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 249 WHERE smile_url = 'icon_lol.gif'

Time before:  0.928365945816
Time after:   0.929784059525
Elapsed time: 0.0014181137085

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 55 WHERE smile_url = 'icon_mad.gif'

Time before:  0.92994093895
Time after:   0.930254936218
Elapsed time: 0.000313997268677

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 15 WHERE smile_url = 'icon_mrgreen.gif'

Time before:  0.930373907089
Time after:   0.930582046509
Elapsed time: 0.000208139419556

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 7 WHERE smile_url = 'icon_neutral.gif'

Time before:  0.930696964264
Time after:   0.9308989048
Elapsed time: 0.000201940536499

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 81 WHERE smile_url = 'icon_question.gif'

Time before:  0.931014060974
Time after:   0.931215047836
Elapsed time: 0.000200986862183

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 166 WHERE smile_url = 'icon_razz.gif'

Time before:  0.931329965591
Time after:   0.931583881378
Elapsed time: 0.000253915786743

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 144 WHERE smile_url = 'icon_redface.gif'

Time before:  0.931702852249
Time after:   0.931907892227
Elapsed time: 0.000205039978027

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 193 WHERE smile_url = 'icon_rolleyes.gif'

Time before:  0.932026863098
Time after:   0.932242870331
Elapsed time: 0.000216007232666

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 707 WHERE smile_url = 'icon_sad.gif'

Time before:  0.932363033295
Time after:   0.93256187439
Elapsed time: 0.000198841094971

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 1138 WHERE smile_url = 'icon_smile.gif'

Time before:  0.93373298645
Time after:   0.934036016464
Elapsed time: 0.000303030014038

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 170 WHERE smile_url = 'icon_surprised.gif'

Time before:  0.934166908264
Time after:   0.934370040894
Elapsed time: 0.000203132629395

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 40 WHERE smile_url = 'icon_twisted.gif'

Time before:  0.934500932693
Time after:   0.934700012207
Elapsed time: 0.00019907951355

Query:	UPDATE phpbb_stats_smilies_index SET smile_count = 362 WHERE smile_url = 'icon_wink.gif'

Time before:  0.934897899628
Time after:   0.935109853745
Elapsed time: 0.000211954116821

Query:	UPDATE phpbb_stats_smilies_info SET last_post_id = 21055

Time before:  0.935222864151
Time after:   0.935574054718
Elapsed time: 0.000351190567017

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

Time before:  0.947233915329
Time after:   0.95029091835
Elapsed time: 0.00305700302124
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_topics  range  topic_status  topic_status  1    1821  1  Using where; Using index  

Query:	SELECT u.user_id, u.username, COUNT(t.topic_poster) num_topics
	FROM phpbb_users u, phpbb_topics 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.950913906097
Time after:   1.10282588005
Elapsed time: 0.151911973953
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  t  ALL          3641  10  Using where; Using temporary; Using filesort 
1  SIMPLE  u  eq_ref  PRIMARY  PRIMARY  3  intramod.t.topic_poster  1    Using where  

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

Time before:  1.11265301704
Time after:   1.16492486
Elapsed time: 0.0522718429565
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts  index    post_time  4    20726  13  Using index; Using temporary; Using filesort  

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

Time before:  1.17145705223
Time after:   1.18296694756
Elapsed time: 0.0115098953247
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_topics  ALL          3641  13  Using temporary; Using filesort  

Query:	SELECT a.post_id, p.forum_id as post_forum_id, t.topic_title, d.*
	FROM phpbb_attachments a, phpbb_attachments_desc d, phpbb_posts p, phpbb_topics 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:  1.19098305702
Time after:   1.19296193123
Elapsed time: 0.00197887420654
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  d  ALL  PRIMARY        62  10  Using filesort 
1  SIMPLE  a  ref  attach_id_post_id,attach_id_privmsgs_id,post_id  attach_id_post_id  3  intramod.d.attach_id  1    Using index 
1  SIMPLE  p  eq_ref  PRIMARY,topic_id  PRIMARY  3  intramod.a.post_id  1     
1  SIMPLE  t  eq_ref  PRIMARY  PRIMARY  3  intramod.p.topic_id  1      

Query:	SELECT u.user_id, u.username, count(u.user_id) as user_posts
	FROM phpbb_users u, phpbb_posts p
	WHERE (u.user_id = p.poster_id) AND (p.post_time > '1167627600') AND (u.user_id <> -1)
	GROUP BY user_id, username
	ORDER BY user_posts DESC
	LIMIT 10

Time before:  1.20771789551
Time after:   1.61312699318
Elapsed time: 0.405409097672
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  u  range  PRIMARY  PRIMARY  3    4615  10  Using where; Using temporary; Using filesort 
1  SIMPLE  p  ref  poster_id,post_time  poster_id  3  intramod.u.user_id  3    Using where  

Query:	SELECT u.user_id, u.username, count(u.user_id) as user_posts
	FROM phpbb_users u, phpbb_posts p
	WHERE (u.user_id = p.poster_id) AND (p.post_time > '1170046800') AND (u.user_id <> -1)
	GROUP BY user_id, username
	ORDER BY user_posts DESC
	LIMIT 10

Time before:  1.77530002594
Time after:   1.78095293045
Elapsed time: 0.0056529045105
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  p  range  poster_id,post_time  post_time  4    328  10  Using where; Using temporary; Using filesort 
1  SIMPLE  u  eq_ref  PRIMARY  PRIMARY  3  intramod.p.poster_id  1    Using where  

Query:	SELECT YEAR(FROM_UNIXTIME(user_regdate)) as year_regdate, MONTH(FROM_UNIXTIME(user_regdate)) as month_regdate, COUNT(*) AS num_user
	FROM phpbb_users
	WHERE (user_id <> -1 )
	GROUP BY YEAR(FROM_UNIXTIME(user_regdate)), MONTH(FROM_UNIXTIME(user_regdate))
	ORDER BY user_regdate

Time before:  1.79088997841
Time after:   1.94203495979
Elapsed time: 0.151144981384
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_users  range  PRIMARY  PRIMARY  3    4615  13  Using where; Using temporary; Using filesort  

The Statistics Mod generated 109 queries,
spending 1.32027029991 doing MySQL queries and 0.627715587616 doing PHP things.