SQL Report

Page generated in 0.5304 seconds with 196 queries + 2 queries returning data from cache

Time spent on mysqli queries: 0.01525s | Time spent on PHP: 0.51513s

Query #1
SELECT * FROM phpbb_ext WHERE ext_active = 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_ext	ALL					18	Using where

Before: 0.02672s | After: 0.02680s | Elapsed: 0.00008s

Query #2
SELECT config_name, config_value FROM phpbb_config WHERE is_dynamic = 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_config	ref	is_dynamic	is_dynamic	1	const	25

Before: 0.26010s | After: 0.26020s | Elapsed: 0.00010s

Query #3
SELECT u.*, s.* FROM phpbb_sessions s, phpbb_users u WHERE s.session_id = '52f85577461e498073bc92ad61f261bd' AND u.user_id = s.session_user_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	system	PRIMARY,session_user_id				1
1	SIMPLE	u	const	PRIMARY	PRIMARY	3	const	1

Before: 0.31015s | After: 0.31050s | Elapsed: 0.00036s

Query #4
UPDATE phpbb_sessions SET session_time = 1412606052, session_page = 'index.php?explain=1', session_forum_id = 0 WHERE session_id = '52f85577461e498073bc92ad61f261bd'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_sessions	system	PRIMARY				1

Affected rows: 1 | Before: 0.31831s | After: 0.31875s | Elapsed: 0.00043s

Query results obtained from the cache
SELECT * FROM phpbb_styles s WHERE s.style_id = 1

Before: 0.35371s | After: 0.35389s | Elapsed [cache]: 0.00017s | Elapsed [db]: 0.00008s

Query #6
SELECT f.*, ft.mark_time FROM (phpbb_forums f) LEFT JOIN phpbb_forums_track ft ON (ft.user_id = 53 AND ft.forum_id = f.forum_id) ORDER BY f.left_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	f	ALL					99	Using filesort
1	SIMPLE	ft	eq_ref	PRIMARY	PRIMARY	6	const,motobra2_mb.f.forum_id	1

Before: 0.35646s | After: 0.35686s | Elapsed: 0.00039s

Query #7
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.35767s | After: 0.35774s | Elapsed: 0.00007s

Query #8
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id = '90' GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	ref	forum_id	forum_id	3	const	1	Using where; Using index; Using temporary; Using filesort

Before: 0.35841s | After: 0.35847s | Elapsed: 0.00007s

Query #9
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.35905s | After: 0.35912s | Elapsed: 0.00007s

Query #10
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.35967s | After: 0.35973s | Elapsed: 0.00006s

Query #11
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.36021s | After: 0.36028s | Elapsed: 0.00007s

Query #12
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.36081s | After: 0.36087s | Elapsed: 0.00006s

Query #13
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.36136s | After: 0.36142s | Elapsed: 0.00006s

Query #14
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.36195s | After: 0.36200s | Elapsed: 0.00005s

Query #15
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.36248s | After: 0.36254s | Elapsed: 0.00006s

Query #16
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.36308s | After: 0.36314s | Elapsed: 0.00006s

Query #17
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.36360s | After: 0.36366s | Elapsed: 0.00006s

Query #18
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.36418s | After: 0.36425s | Elapsed: 0.00007s

Query #19
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.36471s | After: 0.36478s | Elapsed: 0.00006s

Query #20
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		3	Using where; Using index

Before: 0.36532s | After: 0.36539s | Elapsed: 0.00006s

Query #21
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.36585s | After: 0.36591s | Elapsed: 0.00006s

Query #22
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		3	Using where; Using index

Before: 0.36647s | After: 0.36653s | Elapsed: 0.00006s

Query #23
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.36700s | After: 0.36706s | Elapsed: 0.00007s

Query #24
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		3	Using where; Using index

Before: 0.36761s | After: 0.36767s | Elapsed: 0.00006s

Query #25
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.36815s | After: 0.36821s | Elapsed: 0.00007s

Query #26
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		3	Using where; Using index

Before: 0.36875s | After: 0.36881s | Elapsed: 0.00006s

Query #27
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.36928s | After: 0.36935s | Elapsed: 0.00007s

Query #28
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		4	Using where; Using index

Before: 0.36985s | After: 0.36991s | Elapsed: 0.00006s

Query #29
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.37040s | After: 0.37046s | Elapsed: 0.00006s

Query #30
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		4	Using where; Using index

Before: 0.37098s | After: 0.37104s | Elapsed: 0.00006s

Query #31
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.37152s | After: 0.37159s | Elapsed: 0.00006s

Query #32
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		4	Using where; Using index

Before: 0.37210s | After: 0.37217s | Elapsed: 0.00007s

Query #33
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.37269s | After: 0.37275s | Elapsed: 0.00006s

Query #34
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		4	Using where; Using index

Before: 0.37329s | After: 0.37335s | Elapsed: 0.00006s

Query #35
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.37382s | After: 0.37388s | Elapsed: 0.00006s

Query #36
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		5	Using where; Using index

Before: 0.37441s | After: 0.37447s | Elapsed: 0.00006s

Query #37
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.37494s | After: 0.37501s | Elapsed: 0.00007s

Query #38
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		6	Using where; Using index

Before: 0.37555s | After: 0.37562s | Elapsed: 0.00006s

Query #39
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.37609s | After: 0.37616s | Elapsed: 0.00007s

Query #40
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		6	Using where; Using index

Before: 0.37670s | After: 0.37677s | Elapsed: 0.00006s

Query #41
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.37723s | After: 0.37730s | Elapsed: 0.00006s

Query #42
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		6	Using where; Using index

Before: 0.37782s | After: 0.37789s | Elapsed: 0.00006s

Query #43
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.37836s | After: 0.37842s | Elapsed: 0.00006s

Query #44
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		6	Using where; Using index

Before: 0.37894s | After: 0.37901s | Elapsed: 0.00007s

Query #45
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.37950s | After: 0.37956s | Elapsed: 0.00006s

Query #46
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		6	Using where; Using index

Before: 0.38008s | After: 0.38014s | Elapsed: 0.00007s

Query #47
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.38061s | After: 0.38067s | Elapsed: 0.00006s

Query #48
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		6	Using where; Using index

Before: 0.38120s | After: 0.38126s | Elapsed: 0.00006s

Query #49
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.38172s | After: 0.38179s | Elapsed: 0.00006s

Query #50
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		6	Using where; Using index

Before: 0.38232s | After: 0.38238s | Elapsed: 0.00006s

Query #51
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.38285s | After: 0.38294s | Elapsed: 0.00009s

Query #52
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		6	Using where; Using index

Before: 0.38348s | After: 0.38355s | Elapsed: 0.00006s

Query #53
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.38401s | After: 0.38408s | Elapsed: 0.00007s

Query #54
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		6	Using where; Using index

Before: 0.38462s | After: 0.38468s | Elapsed: 0.00006s

Query #55
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.38517s | After: 0.38524s | Elapsed: 0.00006s

Query #56
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		7	Using where; Using index

Before: 0.38577s | After: 0.38583s | Elapsed: 0.00006s

Query #57
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.38633s | After: 0.38639s | Elapsed: 0.00006s

Query #58
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		7	Using where; Using index

Before: 0.38692s | After: 0.38698s | Elapsed: 0.00006s

Query #59
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.38747s | After: 0.38754s | Elapsed: 0.00006s

Query #60
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		7	Using where; Using index

Before: 0.38806s | After: 0.38813s | Elapsed: 0.00007s

Query #61
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.38860s | After: 0.38866s | Elapsed: 0.00006s

Query #62
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		7	Using where; Using index

Before: 0.38920s | After: 0.38926s | Elapsed: 0.00007s

Query #63
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.38973s | After: 0.38979s | Elapsed: 0.00007s

Query #64
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		7	Using where; Using index

Before: 0.39033s | After: 0.39039s | Elapsed: 0.00006s

Query #65
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.39085s | After: 0.39091s | Elapsed: 0.00006s

Query #66
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		7	Using where; Using index

Before: 0.39147s | After: 0.39153s | Elapsed: 0.00006s

Query #67
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.39199s | After: 0.39206s | Elapsed: 0.00007s

Query #68
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.39261s | After: 0.39267s | Elapsed: 0.00006s

Query #69
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.39316s | After: 0.39323s | Elapsed: 0.00007s

Query #70
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.39376s | After: 0.39382s | Elapsed: 0.00006s

Query #71
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.39431s | After: 0.39437s | Elapsed: 0.00006s

Query #72
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.39490s | After: 0.39497s | Elapsed: 0.00007s

Query #73
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.39546s | After: 0.39552s | Elapsed: 0.00006s

Query #74
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.39606s | After: 0.39613s | Elapsed: 0.00007s

Query #75
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.39660s | After: 0.39666s | Elapsed: 0.00006s

Query #76
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.39720s | After: 0.39734s | Elapsed: 0.00014s

Query #77
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.39783s | After: 0.39790s | Elapsed: 0.00006s

Query #78
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.39845s | After: 0.39852s | Elapsed: 0.00007s

Query #79
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.39899s | After: 0.39916s | Elapsed: 0.00017s

Query #80
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.39971s | After: 0.39977s | Elapsed: 0.00007s

Query #81
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.40025s | After: 0.40032s | Elapsed: 0.00007s

Query #82
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.40085s | After: 0.40091s | Elapsed: 0.00007s

Query #83
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.40141s | After: 0.40148s | Elapsed: 0.00007s

Query #84
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.40200s | After: 0.40207s | Elapsed: 0.00007s

Query #85
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.40255s | After: 0.40261s | Elapsed: 0.00006s

Query #86
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.40316s | After: 0.40323s | Elapsed: 0.00007s

Query #87
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.40372s | After: 0.40378s | Elapsed: 0.00006s

Query #88
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.40433s | After: 0.40439s | Elapsed: 0.00006s

Query #89
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.40486s | After: 0.40492s | Elapsed: 0.00006s

Query #90
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.40547s | After: 0.40554s | Elapsed: 0.00007s

Query #91
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.40601s | After: 0.40608s | Elapsed: 0.00007s

Query #92
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.40662s | After: 0.40668s | Elapsed: 0.00006s

Query #93
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.40717s | After: 0.40724s | Elapsed: 0.00007s

Query #94
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.40777s | After: 0.40784s | Elapsed: 0.00006s

Query #95
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.40833s | After: 0.40840s | Elapsed: 0.00007s

Query #96
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.40894s | After: 0.40901s | Elapsed: 0.00007s

Query #97
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.40950s | After: 0.40956s | Elapsed: 0.00006s

Query #98
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.41010s | After: 0.41017s | Elapsed: 0.00007s

Query #99
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.41064s | After: 0.41070s | Elapsed: 0.00006s

Query #100
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.41123s | After: 0.41130s | Elapsed: 0.00007s

Query #101
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.41178s | After: 0.41185s | Elapsed: 0.00007s

Query #102
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.41240s | After: 0.41249s | Elapsed: 0.00009s

Query #103
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.41297s | After: 0.41303s | Elapsed: 0.00007s

Query #104
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.41359s | After: 0.41365s | Elapsed: 0.00006s

Query #105
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.41413s | After: 0.41420s | Elapsed: 0.00007s

Query #106
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.41473s | After: 0.41480s | Elapsed: 0.00007s

Query #107
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.41528s | After: 0.41541s | Elapsed: 0.00014s

Query #108
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.41594s | After: 0.41603s | Elapsed: 0.00008s

Query #109
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.41651s | After: 0.41659s | Elapsed: 0.00008s

Query #110
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.41714s | After: 0.41721s | Elapsed: 0.00007s

Query #111
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.41769s | After: 0.41776s | Elapsed: 0.00006s

Query #112
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.41830s | After: 0.41837s | Elapsed: 0.00007s

Query #113
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.41884s | After: 0.41891s | Elapsed: 0.00006s

Query #114
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.41946s | After: 0.41953s | Elapsed: 0.00007s

Query #115
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.42000s | After: 0.42010s | Elapsed: 0.00010s

Query #116
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.42065s | After: 0.42071s | Elapsed: 0.00007s

Query #117
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.42120s | After: 0.42127s | Elapsed: 0.00007s

Query #118
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	range	forum_id	forum_id	3		8	Using where; Using index

Before: 0.42181s | After: 0.42189s | Elapsed: 0.00008s

Query #119
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.42239s | After: 0.42245s | Elapsed: 0.00007s

Query #120
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.42302s | After: 0.42312s | Elapsed: 0.00010s

Query #121
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.42390s | After: 0.42399s | Elapsed: 0.00010s

Query #122
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.42471s | After: 0.42479s | Elapsed: 0.00008s

Query #123
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.42534s | After: 0.42541s | Elapsed: 0.00007s

Query #124
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.42600s | After: 0.42608s | Elapsed: 0.00008s

Query #125
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.42658s | After: 0.42664s | Elapsed: 0.00006s

Query #126
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.42730s | After: 0.42738s | Elapsed: 0.00008s

Query #127
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.42786s | After: 0.42792s | Elapsed: 0.00006s

Query #128
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.42853s | After: 0.42861s | Elapsed: 0.00008s

Query #129
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.42908s | After: 0.42915s | Elapsed: 0.00007s

Query #130
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.42973s | After: 0.42981s | Elapsed: 0.00008s

Query #131
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.43030s | After: 0.43036s | Elapsed: 0.00006s

Query #132
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.43097s | After: 0.43105s | Elapsed: 0.00008s

Query #133
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.43155s | After: 0.43161s | Elapsed: 0.00006s

Query #134
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.43222s | After: 0.43230s | Elapsed: 0.00008s

Query #135
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.43279s | After: 0.43285s | Elapsed: 0.00006s

Query #136
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.43344s | After: 0.43350s | Elapsed: 0.00006s

Query #137
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.43397s | After: 0.43403s | Elapsed: 0.00006s

Query #138
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.43464s | After: 0.43470s | Elapsed: 0.00006s

Query #139
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.43517s | After: 0.43525s | Elapsed: 0.00007s

Query #140
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.43584s | After: 0.43590s | Elapsed: 0.00006s

Query #141
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.43639s | After: 0.43645s | Elapsed: 0.00006s

Query #142
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.43703s | After: 0.43710s | Elapsed: 0.00006s

Query #143
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.43758s | After: 0.43764s | Elapsed: 0.00006s

Query #144
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.43828s | After: 0.43835s | Elapsed: 0.00007s

Query #145
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.43882s | After: 0.43888s | Elapsed: 0.00006s

Query #146
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.43952s | After: 0.43959s | Elapsed: 0.00006s

Query #147
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.44006s | After: 0.44012s | Elapsed: 0.00006s

Query #148
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.44075s | After: 0.44081s | Elapsed: 0.00006s

Query #149
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.44130s | After: 0.44136s | Elapsed: 0.00006s

Query #150
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.44196s | After: 0.44202s | Elapsed: 0.00006s

Query #151
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.44250s | After: 0.44256s | Elapsed: 0.00006s

Query #152
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.44319s | After: 0.44326s | Elapsed: 0.00006s

Query #153
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.44373s | After: 0.44380s | Elapsed: 0.00006s

Query #154
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.44439s | After: 0.44445s | Elapsed: 0.00006s

Query #155
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.44492s | After: 0.44505s | Elapsed: 0.00012s

Query #156
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.44577s | After: 0.44583s | Elapsed: 0.00007s

Query #157
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.44636s | After: 0.44642s | Elapsed: 0.00007s

Query #158
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.44706s | After: 0.44712s | Elapsed: 0.00007s

Query #159
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.44763s | After: 0.44769s | Elapsed: 0.00006s

Query #160
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.44831s | After: 0.44837s | Elapsed: 0.00006s

Query #161
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.44885s | After: 0.44891s | Elapsed: 0.00006s

Query #162
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.44955s | After: 0.44961s | Elapsed: 0.00006s

Query #163
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.45009s | After: 0.45015s | Elapsed: 0.00006s

Query #164
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.45080s | After: 0.45086s | Elapsed: 0.00006s

Query #165
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.45135s | After: 0.45141s | Elapsed: 0.00006s

Query #166
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.45204s | After: 0.45210s | Elapsed: 0.00006s

Query #167
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.45259s | After: 0.45266s | Elapsed: 0.00006s

Query #168
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.45328s | After: 0.45335s | Elapsed: 0.00006s

Query #169
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.45383s | After: 0.45389s | Elapsed: 0.00006s

Query #170
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.45452s | After: 0.45458s | Elapsed: 0.00006s

Query #171
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.45506s | After: 0.45512s | Elapsed: 0.00006s

Query #172
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.45575s | After: 0.45581s | Elapsed: 0.00006s

Query #173
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.45629s | After: 0.45636s | Elapsed: 0.00006s

Query #174
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.45696s | After: 0.45703s | Elapsed: 0.00007s

Query #175
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.45752s | After: 0.45758s | Elapsed: 0.00006s

Query #176
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87', '3') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.45825s | After: 0.45832s | Elapsed: 0.00007s

Query #177
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.45880s | After: 0.45887s | Elapsed: 0.00006s

Query #178
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87', '3') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.45951s | After: 0.45957s | Elapsed: 0.00006s

Query #179
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.46004s | After: 0.46011s | Elapsed: 0.00006s

Query #180
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87', '3') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.46079s | After: 0.46085s | Elapsed: 0.00006s

Query #181
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.46134s | After: 0.46140s | Elapsed: 0.00006s

Query #182
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87', '3') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.46203s | After: 0.46210s | Elapsed: 0.00006s

Query #183
SELECT MAX(tally) AS max_forum_thanks FROM (SELECT forum_id, COUNT(*) AS tally FROM phpbb_thanks GROUP BY forum_id) t WHERE forum_id <> 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using where
2	DERIVED	phpbb_thanks	index		forum_id	3		9	Using index

Before: 0.46260s | After: 0.46266s | Elapsed: 0.00006s

Query #184
SELECT forum_id, COUNT(*) AS forum_thanks FROM phpbb_thanks WHERE forum_id IN ('90', '98', '86', '4', '2', '55', '79', '25', '64', '84', '71', '13', '28', '87', '3') GROUP BY forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_thanks	index	forum_id	forum_id	3		9	Using where; Using index

Before: 0.46332s | After: 0.46338s | Elapsed: 0.00007s

Query results obtained from the cache
SELECT m.*, u.user_colour, g.group_colour, g.group_type FROM (phpbb_moderator_cache m) LEFT JOIN phpbb_users u ON (m.user_id = u.user_id) LEFT JOIN phpbb_groups g ON (m.group_id = g.group_id) WHERE m.display_on_index = 1

Before: 0.46481s | After: 0.46498s | Elapsed [cache]: 0.00018s | Elapsed [db]: 0.00008s

Query #186
SELECT group_id, group_name, group_colour, group_type, group_legend FROM phpbb_groups WHERE group_legend > 0 ORDER BY group_legend ASC

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_groups	range	group_legend_name	group_legend_name	3		3	Using where

Before: 0.48722s | After: 0.48728s | Elapsed: 0.00007s

Query #187
SELECT u.user_id, u.username, u.user_colour, u.user_birthday FROM phpbb_users u LEFT JOIN phpbb_banlist b ON (u.user_id = b.ban_userid) WHERE (b.ban_id IS NULL OR b.ban_exclude = 1) AND (u.user_birthday LIKE ' 6-10-%' ) AND u.user_type IN (0, 3)

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	range	user_birthday,user_type	user_birthday	32		1	Using where
1	SIMPLE	b	ref	ban_user	ban_user	3	motobra2_mb.u.user_id	17	Using where

Before: 0.48810s | After: 0.48818s | Elapsed: 0.00008s

Query #188

SELECT forum_id FROM phpbb_forums WHERE forum_id NOT IN (0, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 18, 20, 21, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 104, 105, 106)

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_forums	index	PRIMARY	PRIMARY	3		99	Using where; Using index

Before: 0.49182s | After: 0.49189s | Elapsed: 0.00007s

Query #189
SELECT t.poster_id, COUNT(t.user_id) AS tally, u.user_id, u.username, u.user_colour FROM phpbb_users u LEFT JOIN phpbb_thanks t ON (u.user_id = t.poster_id) WHERE t.forum_id <> 0 OR t.forum_id = 0 GROUP BY t.poster_id ORDER BY tally DESC LIMIT 20

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ALL	forum_id,poster_id				9	Using where; Using temporary; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	3	motobra2_mb.t.poster_id	1

Before: 0.49263s | After: 0.49270s | Elapsed: 0.00007s

Query #190

SELECT forum_id FROM phpbb_forums WHERE forum_id IN (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 18, 20, 21, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 104, 105, 106) AND forum_recent_topics = 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_forums	ALL	PRIMARY				99	Using where

Before: 0.49460s | After: 0.49467s | Elapsed: 0.00008s

Query #191

SELECT t.forum_id, t.topic_id, t.topic_type, t.icon_id, tt.mark_time, ft.mark_time as f_mark_time FROM (phpbb_topics t) LEFT JOIN phpbb_topics_track tt ON (tt.topic_id = t.topic_id AND tt.user_id = 53) LEFT JOIN phpbb_forums_track ft ON (ft.forum_id = t.forum_id AND ft.user_id = 53) WHERE t.topic_id <> '0' AND t.topic_status <> 2 AND t.forum_id IN ('2', '7', '3', '4', '5', '6', '99', '8', '16', '82', '101', '78', '9', '65', '15', '10', '34', '11', '63', '59', '33', '12', '14', '23', '13', '21', '18', '20', '26', '100', '24', '30', '25', '31', '29', '27', '28', '32', '35', '53', '37', '38', '39', '40', '41', '70', '42', '43', '44', '45', '46', '47', '61', '48', '49', '50', '51', '52', '55', '84', '54', '56', '81', '57', '58', '60', '77', '64', '62', '72', '73', '66', '96', '71', '68', '67', '69', '74', '75', '79', '80', '85', '83', '98', '87', '86', '88', '89', '90', '91', '92', '93', '94', '95', '97', '102', '104', '105', '106') ORDER BY t.topic_last_post_time DESC LIMIT 50

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	index	PRIMARY,forum_id,forum_id_type,fid_time_moved,forum_vis_last	last_post_time	4		50	Using where
1	SIMPLE	tt	eq_ref	PRIMARY,topic_id	PRIMARY	6	const,motobra2_mb.t.topic_id	1
1	SIMPLE	ft	eq_ref	PRIMARY	PRIMARY	6	const,motobra2_mb.t.forum_id	1

Before: 0.49901s | After: 0.49912s | Elapsed: 0.00011s

Query #192
SELECT t.*, tp.topic_posted, f.forum_name, f.parent_id, f.forum_parents, f.left_id, f.right_id FROM (phpbb_topics t) LEFT JOIN phpbb_topics_posted tp ON (t.topic_id = tp.topic_id AND tp.user_id = 53) LEFT JOIN phpbb_forums f ON (f.forum_id = t.forum_id) WHERE t.topic_id IN ('4778', '4815', '3862', '1760', '4789') ORDER BY t.topic_last_post_time DESC LIMIT 5

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	range	PRIMARY	PRIMARY	3		5	Using where; Using filesort
1	SIMPLE	tp	eq_ref	PRIMARY	PRIMARY	6	const,motobra2_mb.t.topic_id	1
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	3	motobra2_mb.t.forum_id	1

Before: 0.50021s | After: 0.50032s | Elapsed: 0.00011s

Query #193
SELECT COUNT(DISTINCT s.session_ip) as num_guests FROM phpbb_sessions s WHERE s.session_user_id = 1 AND s.session_time >= 1412605440

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Before: 0.51412s | After: 0.51425s | Elapsed: 0.00013s

Query #194
SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM phpbb_sessions s WHERE s.session_time >= 1412605440 AND s.session_user_id <> 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	system	session_time,session_user_id				1

Before: 0.51450s | After: 0.51463s | Elapsed: 0.00013s

Query #195
SELECT username, username_clean, user_id, user_type, user_allow_viewonline, user_colour FROM phpbb_users WHERE user_id = 53 ORDER BY username_clean ASC

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_users	const	PRIMARY	PRIMARY	3	const	1

Before: 0.51489s | After: 0.51497s | Elapsed: 0.00009s

Query #196
SELECT COUNT(n.notification_id) AS unread_count FROM phpbb_notifications n, phpbb_notification_types nt WHERE n.user_id = 53 AND n.notification_read = 0 AND nt.notification_type_id = n.notification_type_id AND nt.notification_type_enabled = 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	n	ref	item_ident,user	user	4	const,const	1
1	SIMPLE	nt	eq_ref	PRIMARY	PRIMARY	2	motobra2_mb.n.notification_type_id	1	Using where

Before: 0.51580s | After: 0.51648s | Elapsed: 0.00068s

Query #197
SELECT n.*, nt.notification_type_name FROM phpbb_notifications n, phpbb_notification_types nt WHERE n.user_id = 53 AND nt.notification_type_id = n.notification_type_id AND nt.notification_type_enabled = 1 ORDER BY n.notification_time DESC LIMIT 5

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	n	ref	item_ident,user	user	3	const	4	Using where; Using filesort
1	SIMPLE	nt	eq_ref	PRIMARY	PRIMARY	2	motobra2_mb.n.notification_type_id	1	Using where

Before: 0.51681s | After: 0.51689s | Elapsed: 0.00008s

Query #198
SELECT * FROM phpbb_users WHERE user_id IN (0, 61, 2540, 1)

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpbb_users	range	PRIMARY	PRIMARY	3		4	Using where

Before: 0.51967s | After: 0.51979s | Elapsed: 0.00011s