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

Time before:  0.140963077545
Time after:   0.157332897186
Elapsed time: 0.0163698196411
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_users  index  PRIMARY  PRIMARY    33968  Using where; Using index 


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

Time before:  0.160041093826
Time after:   0.160259962082
Elapsed time: 0.000218868255615
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_forums  ALL          13   


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

Time before:  0.162781000137
Time after:   0.163260936737
Elapsed time: 0.000479936599731
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_users  index  PRIMARY  PRIMARY    33968  Using where 


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

Time before:  0.183835983276
Time after:   0.184120893478
Elapsed time: 0.000284910202026
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_users  const  PRIMARY  PRIMARY  const   


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

Time before:  0.185002088547
Time after:   0.185497999191
Elapsed time: 0.000495910644531
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_config  range  PRIMARY  PRIMARY  257    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.270137071609
Time after:   0.323642015457
Elapsed time: 0.0535049438477
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_topics  range  topic_status  topic_status    10504  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.346633911133
Time after:   0.400756120682
Elapsed time: 0.054122209549
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_topics  range  topic_status  topic_status    10504  10  Using where; Using filesort 


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

Time before:  0.410141944885
Time after:   0.561589002609
Elapsed time: 0.151447057724
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_users  ALL  PRIMARY        33968  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.56281709671
Time after:   0.563545942307
Elapsed time: 0.000728845596313
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_users  range  PRIMARY,user_posts  user_posts    11026  10  Using where 


Query:	SELECT * FROM phpbb_stats_smilies_info

Time before:  0.57421207428
Time after:   0.574424028397
Elapsed time: 0.000211954116821
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_stats_smilies_info  system           


Query:	SELECT * FROM phpbb_stats_smilies_index

Time before:  0.574907064438
Time after:   0.575169086456
Elapsed time: 0.000262022018433
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_stats_smilies_index  ALL          22  22   


Query:	SELECT max(post_id) as total FROM phpbb_posts

Time before:  0.575896024704
Time after:   0.576155900955
Elapsed time: 0.000259876251221
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE                Select tables optimized away 


Query:	SELECT COUNT(post_id) as total FROM phpbb_posts

Time before:  0.576637029648
Time after:   0.576905012131
Elapsed time: 0.00026798248291
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE                Select tables optimized away 


Query:	SELECT smile_url FROM phpbb_smilies GROUP BY smile_url

Time before:  0.577382087708
Time after:   0.577661991119
Elapsed time: 0.000279903411865
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_smilies  ALL          42  22  Using temporary; Using filesort 


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

Time before:  0.58917593956
Time after:   0.600399017334
Elapsed time: 0.011223077774
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_topics  ALL  topic_status        10525  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.601141929626
Time after:   0.808542013168
Elapsed time: 0.207400083542
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  ALL          10525  10  Using where; Using temporary; Using filesort 
SIMPLE  eq_ref  PRIMARY,user_posts  PRIMARY  intramod.t.topic_poster    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.818455934525
Time after:   0.818798065186
Elapsed time: 0.000342130661011
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_posts  index    post_time    54731  38  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:  0.827052116394
Time after:   0.85840010643
Elapsed time: 0.031347990036
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_topics  ALL          10525  38  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:  0.869355916977
Time after:   0.870790958405
Elapsed time: 0.00143504142761
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  ALL  PRIMARY,attach_id        197  10  Using filesort 
SIMPLE  ref  attach_id_post_id  attach_id_post_id  intramod.d.attach_id    Using index 
SIMPLE  eq_ref  PRIMARY,topic_n_id,topic_id  PRIMARY  intramod.a.post_id     
SIMPLE  eq_ref  PRIMARY,topic_id,topic_id_2  PRIMARY  intramod.p.topic_id     


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

Time before:  0.885634899139
Time after:   0.918777942657
Elapsed time: 0.0331430435181
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  range  poster_id,post_time,poster_id_2  post_time    1196  10  Using where; Using temporary; Using filesort 
SIMPLE  eq_ref  PRIMARY  PRIMARY  intramod.p.poster_id     


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

Time before:  0.929430007935
Time after:   0.944463968277
Elapsed time: 0.0150339603424
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  range  poster_id,post_time,poster_id_2  post_time    477  10  Using where; Using temporary; Using filesort 
SIMPLE  eq_ref  PRIMARY  PRIMARY  intramod.p.poster_id     


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.954128980637
Time after:   1.1826980114
Elapsed time: 0.228569030762
id select_type table type possible_keys key key_len ref rows affected_rows Extra
SIMPLE  phpbb_users  ALL  PRIMARY        33968  38  Using where; Using temporary; Using filesort 


The Statistics Mod generated 22 queries,
spending 0.807428598404 doing MySQL queries and 0.390666484833 doing PHP things.