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.070876121520996
Time after:   0.094170093536377
Elapsed time: 0.023293972015381

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		2841	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.11529207229614
Time after:   0.14015197753906
Elapsed time: 0.02485990524292

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		2841	10	Using where; Using filesort

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

Time before:  0.16235899925232
Time after:   0.17170310020447
Elapsed time: 0.0093441009521484

id	select_type	table	type	possible_keys	key	key_len	ref	rows	affected_rows	Extra
1	SIMPLE	phpbb_users	ALL	PRIMARY				2092	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.17234706878662
Time after:   0.1821870803833
Elapsed time: 0.0098400115966797

id	select_type	table	type	possible_keys	key	key_len	ref	rows	affected_rows	Extra
1	SIMPLE	phpbb_users	ALL	PRIMARY				2092	10	Using where; Using filesort

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

Time before:  0.20406007766724
Time after:   0.20623707771301
Elapsed time: 0.0021770000457764

id	select_type	table	type	possible_keys	key	key_len	ref	rows	affected_rows	Extra
1	SIMPLE	phpbb_topics	ALL	topic_status				2853	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.20699501037598
Time after:   0.27520513534546
Elapsed time: 0.068210124969482

id	select_type	table	type	possible_keys	key	key_len	ref	rows	affected_rows	Extra
1	SIMPLE	t	ALL					2853	10	Using where; Using temporary; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	3	capmacphpbb.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.29684996604919
Time after:   0.29794406890869
Elapsed time: 0.0010941028594971

id	select_type	table	type	possible_keys	key	key_len	ref	rows	affected_rows	Extra
1	SIMPLE	phpbb_posts	index		post_time	4		6632	95	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.32578802108765
Time after:   0.34049105644226
Elapsed time: 0.014703035354614

id	select_type	table	type	possible_keys	key	key_len	ref	rows	affected_rows	Extra
1	SIMPLE	phpbb_topics	ALL					2853	95	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 > '1277964000') AND (u.user_id <> -1)
	GROUP BY user_id, username
	ORDER BY user_posts DESC
	LIMIT 10

Time before:  0.37091112136841
Time after:   0.37237000465393
Elapsed time: 0.0014588832855225

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		11	7	Using where; Using temporary; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	3	capmacphpbb.p.poster_id	1		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 > '1280120400') AND (u.user_id <> -1)
	GROUP BY user_id, username
	ORDER BY user_posts DESC
	LIMIT 10

Time before:  0.39314794540405
Time after:   0.39378309249878
Elapsed time: 0.00063514709472656

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		1	0	Using where; Using temporary; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	3	capmacphpbb.p.poster_id	1		Using where

The Statistics Mod generated 10 queries,
spending 0.15561628341675 doing MySQL queries and 0.24909472465515 doing PHP things.