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

Time before:  0.057687997818
Time after:   0.0583791732788
Elapsed time: 0.000691175460815
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_users  index  PRIMARY  PRIMARY  3    904  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.0605890750885
Time after:   0.0613451004028
Elapsed time: 0.000756025314331
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_forums  ALL          21  1    

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

Time before:  0.0627222061157
Time after:   0.0630021095276
Elapsed time: 0.000279903411865
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_users  index  PRIMARY  PRIMARY  3    1  1  Using where  

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

Time before:  0.076642036438
Time after:   0.0769731998444
Elapsed time: 0.000331163406372
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.0772461891174
Time after:   0.0776212215424
Elapsed time: 0.000375032424927
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_config  range  PRIMARY  PRIMARY  767    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.0845201015472
Time after:   0.095762014389
Elapsed time: 0.0112419128418
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    6550  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.109027147293
Time after:   0.119577169418
Elapsed time: 0.0105500221252
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    6550  10  Using where; Using filesort  

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

Time before:  0.132652044296
Time after:   0.135974168777
Elapsed time: 0.0033221244812
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_users  ALL  PRIMARY        904  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.140071153641
Time after:   0.142520189285
Elapsed time: 0.00244903564453
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_users  ALL  PRIMARY        904  10  Using where; Using filesort  

Query:	SELECT * FROM stats_smilies_info

Time before:  0.149487018585
Time after:   0.152187108994
Elapsed time: 0.00270009040833
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  stats_smilies_info  system          1  1    

Query:	SELECT * FROM stats_smilies_index

Time before:  0.152523994446
Time after:   0.155628204346
Elapsed time: 0.0031042098999
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  stats_smilies_index  ALL          28  28    

Query:	SELECT max(post_id) as total FROM phpbb_posts

Time before:  0.156521081924
Time after:   0.156690120697
Elapsed time: 0.000169038772583
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.156893014908
Time after:   0.156982183456
Elapsed time: 8.9168548584E-5
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE                1  Select tables optimized away  

Query:	SELECT smile_url FROM phpbb_smilies GROUP BY smile_url

Time before:  0.157159090042
Time after:   0.160179138184
Elapsed time: 0.00302004814148
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  30  Using temporary; Using filesort  

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

Time before:  0.161466121674
Time after:   0.162321090698
Elapsed time: 0.000854969024658
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:baba:%' AND post_id > 87260

Time before:  0.162599086761
Time after:   0.163106203079
Elapsed time: 0.000507116317749
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.163417100906
Time after:   0.163623094559
Elapsed time: 0.000205993652344
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:bah:%' AND post_id > 87260

Time before:  0.163883209229
Time after:   0.164187192917
Elapsed time: 0.000303983688354
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.164446115494
Time after:   0.165424108505
Elapsed time: 0.000977993011475
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:banana:%' AND post_id > 87260

Time before:  0.165688991547
Time after:   0.166016101837
Elapsed time: 0.000327110290527
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.166263103485
Time after:   0.166433095932
Elapsed time: 0.000169992446899
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:buf:%' AND post_id > 87260

Time before:  0.166629076004
Time after:   0.167697191238
Elapsed time: 0.00106811523438
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.168092012405
Time after:   0.169810056686
Elapsed time: 0.00171804428101
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:cabreado:%' AND post_id > 87260

Time before:  0.170065164566
Time after:   0.170687198639
Elapsed time: 0.000622034072876
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.171113014221
Time after:   0.171516180038
Elapsed time: 0.000403165817261
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:confused:%' AND post_id > 87260

Time before:  0.171783208847
Time after:   0.172157049179
Elapsed time: 0.000373840332031
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.172422170639
Time after:   0.173195123672
Elapsed time: 0.000772953033447
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

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

Time before:  0.17353105545
Time after:   0.173890113831
Elapsed time: 0.000359058380127
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.174262046814
Time after:   0.17446398735
Elapsed time: 0.000201940536499
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:cunao:%' AND post_id > 87260

Time before:  0.175320148468
Time after:   0.175721168518
Elapsed time: 0.000401020050049
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.176000118256
Time after:   0.17688703537
Elapsed time: 0.000886917114258
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:dios:%' AND post_id > 87260

Time before:  0.177173137665
Time after:   0.177825212479
Elapsed time: 0.000652074813843
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.178153991699
Time after:   0.178436040878
Elapsed time: 0.000282049179077
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:dream:%' AND post_id > 87260

Time before:  0.178714036942
Time after:   0.179045200348
Elapsed time: 0.000331163406372
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.179286003113
Time after:   0.179524183273
Elapsed time: 0.000238180160522
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:drink:%' AND post_id > 87260

Time before:  0.179719209671
Time after:   0.180072069168
Elapsed time: 0.00035285949707
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.1803150177
Time after:   0.180449008942
Elapsed time: 0.000133991241455
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

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

Time before:  0.180946111679
Time after:   0.181284189224
Elapsed time: 0.000338077545166
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.18151307106
Time after:   0.181649208069
Elapsed time: 0.000136137008667
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

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

Time before:  0.181837081909
Time after:   0.182133197784
Elapsed time: 0.000296115875244
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.182379007339
Time after:   0.182653188705
Elapsed time: 0.000274181365967
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:hola:%' AND post_id > 87260

Time before:  0.18300318718
Time after:   0.184408187866
Elapsed time: 0.00140500068665
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.184736013412
Time after:   0.185609102249
Elapsed time: 0.00087308883667
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:ill:%' AND post_id > 87260

Time before:  0.185854196548
Time after:   0.186897039413
Elapsed time: 0.00104284286499
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.187219142914
Time after:   0.187522172928
Elapsed time: 0.000303030014038
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:malo:%' AND post_id > 87260

Time before:  0.187736034393
Time after:   0.189222097397
Elapsed time: 0.00148606300354
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.189587116241
Time after:   0.189733028412
Elapsed time: 0.00014591217041
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:muro:%' AND post_id > 87260

Time before:  0.189952135086
Time after:   0.190385103226
Elapsed time: 0.000432968139648
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.190709114075
Time after:   0.190891027451
Elapsed time: 0.000181913375854
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:nono:%' AND post_id > 87260

Time before:  0.191168069839
Time after:   0.191620111465
Elapsed time: 0.000452041625977
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.19192814827
Time after:   0.19207906723
Elapsed time: 0.000150918960571
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:ok:%' AND post_id > 87260

Time before:  0.192388057709
Time after:   0.192809104919
Elapsed time: 0.000421047210693
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.193072080612
Time after:   0.19407916069
Elapsed time: 0.00100708007812
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:plas:%' AND post_id > 87260

Time before:  0.194380998611
Time after:   0.195652008057
Elapsed time: 0.00127100944519
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.195960998535
Time after:   0.196290016174
Elapsed time: 0.00032901763916
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:please:%' AND post_id > 87260

Time before:  0.196576118469
Time after:   0.197016000748
Elapsed time: 0.000439882278442
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.197277069092
Time after:   0.197423219681
Elapsed time: 0.000146150588989
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:risitas:%' AND post_id > 87260

Time before:  0.197627067566
Time after:   0.19796705246
Elapsed time: 0.000339984893799
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.198194026947
Time after:   0.198360204697
Elapsed time: 0.000166177749634
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:rolleyes:%' AND post_id > 87260

Time before:  0.199166059494
Time after:   0.199909210205
Elapsed time: 0.00074315071106
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.200182199478
Time after:   0.200633049011
Elapsed time: 0.000450849533081
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:sorry:%' AND post_id > 87260

Time before:  0.200875997543
Time after:   0.20118021965
Elapsed time: 0.000304222106934
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.201414108276
Time after:   0.201539993286
Elapsed time: 0.000125885009766
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:stop:%' AND post_id > 87260

Time before:  0.201813220978
Time after:   0.202157020569
Elapsed time: 0.000343799591064
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.202432155609
Time after:   0.202571153641
Elapsed time: 0.000138998031616
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:timido:%' AND post_id > 87260

Time before:  0.202761173248
Time after:   0.203063011169
Elapsed time: 0.000301837921143
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.203307151794
Time after:   0.203485012054
Elapsed time: 0.00017786026001
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%:tongue:%' AND post_id > 87260

Time before:  0.203679084778
Time after:   0.203973054886
Elapsed time: 0.000293970108032
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.20419716835
Time after:   0.204344034195
Elapsed time: 0.000146865844727
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  1  Using where  

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

Time before:  0.204540014267
Time after:   0.204830169678
Elapsed time: 0.000290155410767
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.205047130585
Time after:   0.205862998962
Elapsed time: 0.000815868377686
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  2  Using where  

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

Time before:  0.206135988235
Time after:   0.207826137543
Elapsed time: 0.00169014930725
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.208281040192
Time after:   0.209111213684
Elapsed time: 0.000830173492432
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.209411144257
Time after:   0.209843158722
Elapsed time: 0.000432014465332
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_smilies  ALL          32  2  Using where  

Query:	SELECT post_id, post_text
	FROM phpbb_posts_text
	WHERE post_text LIKE '%xD%' AND post_id > 87260

Time before:  0.210146188736
Time after:   0.210650205612
Elapsed time: 0.000504016876221
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  0  Using where  

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

Time before:  0.211762189865
Time after:   0.213591098785
Elapsed time: 0.00182890892029
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts_text  range  PRIMARY  PRIMARY  3    10  1  Using where  

Query:	UPDATE stats_smilies_index SET smile_count = 2772 WHERE smile_url = 'baba.gif'

Time before:  0.213896989822
Time after:   0.214034080505
Elapsed time: 0.000137090682983

Query:	UPDATE stats_smilies_index SET smile_count = 350 WHERE smile_url = 'bah.gif'

Time before:  0.21408700943
Time after:   0.214196205139
Elapsed time: 0.000109195709229

Query:	UPDATE stats_smilies_index SET smile_count = 512 WHERE smile_url = 'banana.gif'

Time before:  0.214246034622
Time after:   0.214351177216
Elapsed time: 0.000105142593384

Query:	UPDATE stats_smilies_index SET smile_count = 780 WHERE smile_url = 'buff.gif'

Time before:  0.214397192001
Time after:   0.214501142502
Elapsed time: 0.000103950500488

Query:	UPDATE stats_smilies_index SET smile_count = 1735 WHERE smile_url = 'cabreado.gif'

Time before:  0.214548110962
Time after:   0.214648008347
Elapsed time: 9.98973846436E-5

Query:	UPDATE stats_smilies_index SET smile_count = 2747 WHERE smile_url = 'confused.gif'

Time before:  0.2146961689
Time after:   0.21479511261
Elapsed time: 9.89437103271E-5

Query:	UPDATE stats_smilies_index SET smile_count = 2331 WHERE smile_url = 'cry.gif'

Time before:  0.21484208107
Time after:   0.214947223663
Elapsed time: 0.000105142593384

Query:	UPDATE stats_smilies_index SET smile_count = 13588 WHERE smile_url = 'cunao.gif'

Time before:  0.214993000031
Time after:   0.215093135834
Elapsed time: 0.000100135803223

Query:	UPDATE stats_smilies_index SET smile_count = 4195 WHERE smile_url = 'dios.gif'

Time before:  0.215140104294
Time after:   0.215254068375
Elapsed time: 0.000113964080811

Query:	UPDATE stats_smilies_index SET smile_count = 236 WHERE smile_url = 'dream.gif'

Time before:  0.21530008316
Time after:   0.215406179428
Elapsed time: 0.0001060962677

Query:	UPDATE stats_smilies_index SET smile_count = 1017 WHERE smile_url = 'drink.gif'

Time before:  0.215452194214
Time after:   0.215561151505
Elapsed time: 0.000108957290649

Query:	UPDATE stats_smilies_index SET smile_count = 3280 WHERE smile_url = 'eek.gif'

Time before:  0.21560716629
Time after:   0.215705156326
Elapsed time: 9.79900360107E-5

Query:	UPDATE stats_smilies_index SET smile_count = 3717 WHERE smile_url = 'feliz.gif'

Time before:  0.215756177902
Time after:   0.215854167938
Elapsed time: 9.79900360107E-5

Query:	UPDATE stats_smilies_index SET smile_count = 7510 WHERE smile_url = 'hola.gif'

Time before:  0.215901136398
Time after:   0.216000080109
Elapsed time: 9.89437103271E-5

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'illness.gif'

Time before:  0.216047048569
Time after:   0.216152191162
Elapsed time: 0.000105142593384

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'malo.gif'

Time before:  0.216204166412
Time after:   0.216304063797
Elapsed time: 9.98973846436E-5

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'muro.gif'

Time before:  0.216350078583
Time after:   0.216452121735
Elapsed time: 0.000102043151855

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'nono.gif'

Time before:  0.21649813652
Time after:   0.216603040695
Elapsed time: 0.000104904174805

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'ok.gif'

Time before:  0.216649055481
Time after:   0.216746091843
Elapsed time: 9.70363616943E-5

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'plas.gif'

Time before:  0.216792106628
Time after:   0.21688914299
Elapsed time: 9.70363616943E-5

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'please.gif'

Time before:  0.216935157776
Time after:   0.217034101486
Elapsed time: 9.89437103271E-5

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'risitas.gif'

Time before:  0.217080116272
Time after:   0.217180013657
Elapsed time: 9.98973846436E-5

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'rolleyes.gif'

Time before:  0.217231035233
Time after:   0.217335224152
Elapsed time: 0.000104188919067

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'sorry.gif'

Time before:  0.217382192612
Time after:   0.217495203018
Elapsed time: 0.000113010406494

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'stop.gif'

Time before:  0.217612028122
Time after:   0.217730045319
Elapsed time: 0.000118017196655

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'timido.gif'

Time before:  0.21785902977
Time after:   0.217961072922
Elapsed time: 0.000102043151855

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'tongue.gif'

Time before:  0.218008041382
Time after:   0.218106031418
Elapsed time: 9.79900360107E-5

Query:	UPDATE stats_smilies_index SET smile_count = 0 WHERE smile_url = 'triste.gif'

Time before:  0.218152046204
Time after:   0.218261003494
Elapsed time: 0.000108957290649

Query:	INSERT INTO stats_smilies_index (code, smile_url, smile_count) VALUES (':wink:', 'wink.gif', 0)

Time before:  0.218314170837
Time after:   0.219506025314
Elapsed time: 0.00119185447693

Query:	INSERT INTO stats_smilies_index (code, smile_url, smile_count) VALUES ('xD', 'xd.gif', 1)

Time before:  0.219592094421
Time after:   0.219705104828
Elapsed time: 0.000113010406494

Query:	UPDATE stats_smilies_info SET last_post_id = 87268

Time before:  0.219754219055
Time after:   0.219863176346
Elapsed time: 0.000108957290649

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

Time before:  0.227789163589
Time after:   0.230054140091
Elapsed time: 0.00226497650146
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_topics  ALL  topic_status        6601  1  Using where  

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.230445146561
Time after:   0.279149055481
Elapsed time: 0.0487039089203
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  t  ALL          6601  10  Using where; Using temporary; Using filesort 
1  SIMPLE  u  eq_ref  PRIMARY  PRIMARY  3  marinosc_swssphpbb.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:  0.28631401062
Time after:   0.422440052032
Elapsed time: 0.136126041412
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_posts  index    post_time  4    85313  88  Using index; Using temporary; Using filesort  

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 > '1328079600') AND (u.user_id <> -1)
	GROUP BY user_id, username
	ORDER BY user_posts DESC
	LIMIT 10

Time before:  0.43218421936
Time after:   0.443855047226
Elapsed time: 0.0116708278656
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    779  10  Using where; Using temporary; Using filesort 
1  SIMPLE  u  eq_ref  PRIMARY  PRIMARY  3  marinosc_swssphpbb.p.poster_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 > '1328511600') AND (u.user_id <> -1)
	GROUP BY user_id, username
	ORDER BY user_posts DESC
	LIMIT 10

Time before:  0.460691213608
Time after:   0.464843988419
Elapsed time: 0.00415277481079
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    366  10  Using where; Using temporary; Using filesort 
1  SIMPLE  u  eq_ref  PRIMARY  PRIMARY  3  marinosc_swssphpbb.p.poster_id  1      

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:  0.47775220871
Time after:   0.487972021103
Elapsed time: 0.0102198123932
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_topics  ALL          6601  88  Using temporary; Using filesort  

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:  0.497533082962
Time after:   0.500694036484
Elapsed time: 0.00316095352173
id select_type table type possible_keys key key_len ref rows affected_rows Extra
1  SIMPLE  phpbb_users  ALL  PRIMARY        904  88  Using where; Using temporary; Using filesort  

The Statistics Mod generated 114 queries,
spending 0.292926549911 doing MySQL queries and 0.215940475464 doing PHP things.