Vedere quale tabella del database rallenta il caricamento

[Barrnet]

Copia il testo e incollalo in un box code.

[artikkk]

Non me lo fa copiare tutto.. comunque..
questo è l'index

Codice: Seleziona tutto

Page generated in 0.9642 seconds with 41 queries + 6 queries returning data from cache

Time spent on mysql4 queries: 0.82396s | Time spent on PHP: 0.14022s


Query #1
SELECT config_name, config_value FROM avphpbb_config WHERE is_dynamic = 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_config	ref	is_dynamic	is_dynamic	1	const	97	 

Before: 0.00257s | After: 0.00284s | Elapsed: 0.00027s


Query #2
SELECT u.*, s.* FROM avphpbb_sessions s, avphpbb_users u WHERE s.session_id = '1a404a2c3810bde0802a1abf6b5fbc5a' AND u.user_id = s.session_user_id
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	const	PRIMARY,session_user_id	PRIMARY	96	const	1	 
1	SIMPLE	u	const	PRIMARY	PRIMARY	3	const	1	 

Before: 0.00443s | After: 0.00477s | Elapsed: 0.00034s


Query #3
UPDATE avphpbb_sessions SET session_time = 1331502994, session_page = 'index.php?&explain=1', session_forum_id = 0, session_album_id = 0 WHERE session_id = '1a404a2c3810bde0802a1abf6b5fbc5a'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_sessions	const	PRIMARY	PRIMARY	96	const	1	 

Affected rows: 1 | Before: 0.00523s | After: 0.00541s | Elapsed: 0.00018s


Query #4
SELECT group_schedule_days, group_schedule_start, group_schedule_end FROM avphpbb_user_group WHERE user_id = 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_user_group	ref	user_id	user_id	3	const	4	 

Before: 0.00739s | After: 0.00755s | Elapsed: 0.00016s


Query results obtained from the cache
SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, t.template_inherits_id, t.template_inherit_path, c.theme_path, c.theme_name, c.theme_storedb, c.theme_id, i.imageset_path, i.imageset_id, i.imageset_name FROM avphpbb_styles s, avphpbb_styles_template t, avphpbb_styles_theme c, avphpbb_styles_imageset i WHERE s.style_id = 31 AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imageset_id = s.imageset_id

Before: 0.01091s | After: 0.01113s | Elapsed [cache]: 0.00023s | Elapsed [db]: 0.00020s


Query results obtained from the cache
SELECT * FROM avphpbb_styles_imageset_data WHERE imageset_id = 28 AND image_filename <> '' AND image_lang IN ('it', '')

Before: 0.01218s | After: 0.01271s | Elapsed [cache]: 0.00053s | Elapsed [db]: 0.00056s


Query #7
SELECT config_value FROM avphpbb_sn_config WHERE config_name = 'sn_global_enable'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_sn_config	const	PRIMARY	PRIMARY	767	const	1	 

Before: 0.01380s | After: 0.01388s | Elapsed: 0.00008s


Query #8
SELECT * FROM avphpbb_sn_users WHERE user_id = '2'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_sn_users	const	PRIMARY	PRIMARY	3	const	1	 

Before: 0.01646s | After: 0.01657s | Elapsed: 0.00012s


Query #9
SELECT config_name, config_value FROM avphpbb_sn_config WHERE config_name <> 'sn_global_enable'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_sn_config	ALL	PRIMARY	 	 	 	54	Using where

Before: 0.01687s | After: 0.01700s | Elapsed: 0.00013s


Query #10
SELECT auth_option_id FROM avphpbb_acl_options WHERE auth_option = 'u_sn_im' AND is_global = 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 0.01735s | After: 0.01742s | Elapsed: 0.00007s


Query #11
SELECT auth_option_id FROM avphpbb_acl_options WHERE auth_option = 'u_sn_userstatus' AND is_global = 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_acl_options	const	auth_option	auth_option	152	const	1	 

Before: 0.01771s | After: 0.01779s | Elapsed: 0.00008s


Query #12
SELECT auth_option_id FROM avphpbb_acl_options WHERE auth_option = 'u_sn_approval' AND is_global = 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 0.01806s | After: 0.01814s | Elapsed: 0.00008s


Query #13
SELECT auth_option_id FROM avphpbb_acl_options WHERE auth_option = 'u_sn_mainpage' AND is_global = 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 0.01839s | After: 0.01846s | Elapsed: 0.00007s


Query #14
SELECT auth_option_id FROM avphpbb_acl_options WHERE auth_option = 'u_sn_notify' AND is_global = 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 0.01876s | After: 0.01883s | Elapsed: 0.00007s


Query #15
SELECT auth_option_id FROM avphpbb_acl_options WHERE auth_option = 'u_sn_profile' AND is_global = 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	 	 	 	 	 	 	 	Impossible WHERE noticed after reading const tables

Before: 0.01917s | After: 0.01924s | Elapsed: 0.00007s


Query #16
DELETE FROM avphpbb_sn_im_chatboxes WHERE uid_from = '2' AND starttime < '1331502277'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_sn_im_chatboxes	ref	a,b	a	3	const	1	Using where

Affected rows: 0 | Before: 0.02022s | After: 0.02030s | Elapsed: 0.00008s


Query #17
SELECT s.session_user_id, s.session_ip, s.session_viewonline, (s.session_time) AS s_time FROM avphpbb_sessions AS s LEFT OUTER JOIN avphpbb_users AS u ON s.session_user_id = u.user_id WHERE u.user_type <> 2 AND s.session_time >= 1331501190 AND s.session_user_id <> 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ALL	session_time,session_user_id	 	 	 	1409	Using where
1	SIMPLE	u	eq_ref	PRIMARY,user_type	PRIMARY	3	admin_pronosky.s.session_user_id	1	Using where

Before: 0.02057s | After: 0.02651s | Elapsed: 0.00594s


Query #18
SELECT sn_u.user_id, sn_u.user_im_online, u.username, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, u.user_colour FROM (avphpbb_sn_users sn_u CROSS JOIN avphpbb_users u) WHERE sn_u.user_id = u.user_id AND sn_u.user_id IN (11797, 53194, 49493, 8091, 47269, 53698, 47703, 25774, 9824, 7162, 3700, 52524, 17722, 20630, 42292, 33621, 37135, 33874, 15290, 41870, 33117, 39173, 23899, 53757, 49338, 3758, 53710, 29109, 45202, 51253, 25325, 53642, 50840, 46855, 36432, 51646, 48778, 52970, 51985, 14443, 53733, 53749, 52751, 53712, 35467, 52899, 20618, 53684, 22284, 20226, 49748, 43784, 52192, 53725, 45112, 41569, 49522, 16806, 47314, 23366, 50625, 53276, 9130, 46448, 20959, 53746, 52946, 46919, 44410, 19730, 53728, 7409, 51687, 53592, 36023, 48801, 5303, 37572, 53759, 53753, 37932, 25522, 53734, 45683, 48751, 39361, 3752, 15322, 27169, 53686, 46581, 43921, 21369, 10091, 38948, 34717, 53751, 42178, 37307, 53738, 53525, 33328, 40822, 53760, 47600, 36543, 53621, 32788, 45050, 46041, 53224, 21313, 51392, 52634, 97, 50793, 29189, 53653, 32465, 48755, 53715, 52472, 25655, 53758, 48349, 51094, 40555, 53506, 13255, 16488, 8629, 3458, 9578, 53739, 53563, 49530, 52363, 21293, 28550, 53623, 53612, 43528, 38042, 18536, 47930, 53748, 34674, 53750, 43276, 45142, 15791, 53737, 50506, 53704, 43814, 53742, 50553, 50844, 53754, 30694, 30115, 52620, 47536, 52391, 12443, 53741, 10088, 13425, 52725, 53747, 53447, 37579, 49258, 53471, 29554, 53724, 29739, 44606, 6020, 53292, 12895, 34368, 50423, 48314, 49714, 18354, 53573, 51256, 53752, 43905, 32961, 39298, 44674, 53123, 48926, 38293, 53670) ORDER BY u.username ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	sn_u	range	PRIMARY	PRIMARY	3	 	197	Using where; Using temporary; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	3	admin_pronosky.sn_u.user_id	1	 

Before: 0.02891s | After: 0.03344s | Elapsed: 0.00453s


Query #19
SELECT * FROM avphpbb_sn_im_chatboxes WHERE uid_from = '2' AND starttime = '1331502277' ORDER BY starttime DESC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_sn_im_chatboxes	ref	a,b	a	3	const	1	Using where; Using filesort

Before: 0.03696s | After: 0.03712s | Elapsed: 0.00016s


Query #20
SELECT s.session_user_id, s.session_ip, s.session_viewonline, (s.session_time) AS s_time FROM avphpbb_sessions AS s LEFT OUTER JOIN avphpbb_users AS u ON s.session_user_id = u.user_id WHERE u.user_type <> 2 AND s.session_time >= 1331501190 AND s.session_user_id <> 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ALL	session_time,session_user_id	 	 	 	1409	Using where
1	SIMPLE	u	eq_ref	PRIMARY,user_type	PRIMARY	3	admin_pronosky.s.session_user_id	1	Using where

Before: 0.03776s | After: 0.05323s | Elapsed: 0.01547s


Query #21
SELECT sn_u.user_id, sn_u.user_im_online, u.username, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, u.user_colour FROM (avphpbb_sn_users sn_u CROSS JOIN avphpbb_users u) WHERE sn_u.user_id = u.user_id AND sn_u.user_id IN (11797, 53194, 49493, 8091, 47269, 53698, 47703, 25774, 9824, 7162, 3700, 52524, 17722, 20630, 42292, 33621, 37135, 33874, 15290, 41870, 33117, 39173, 23899, 53757, 49338, 3758, 53710, 29109, 45202, 51253, 25325, 53642, 50840, 46855, 36432, 51646, 48778, 52970, 51985, 14443, 53733, 53749, 52751, 53712, 35467, 52899, 20618, 53684, 22284, 20226, 49748, 43784, 52192, 53725, 45112, 41569, 49522, 16806, 47314, 23366, 50625, 53276, 9130, 46448, 20959, 53746, 52946, 46919, 44410, 19730, 53728, 7409, 51687, 53592, 36023, 48801, 5303, 37572, 53759, 53753, 37932, 25522, 53734, 45683, 48751, 39361, 3752, 15322, 27169, 53686, 46581, 43921, 21369, 10091, 38948, 34717, 53751, 42178, 37307, 53738, 53525, 33328, 40822, 53760, 47600, 36543, 53621, 32788, 45050, 46041, 53224, 21313, 51392, 52634, 97, 50793, 29189, 53653, 32465, 48755, 53715, 52472, 25655, 53758, 48349, 51094, 40555, 53506, 13255, 16488, 8629, 3458, 9578, 53739, 53563, 49530, 52363, 21293, 28550, 53623, 53612, 43528, 38042, 18536, 47930, 53748, 34674, 53750, 43276, 45142, 15791, 53737, 50506, 53704, 43814, 53742, 50553, 50844, 53754, 30694, 30115, 52620, 47536, 52391, 12443, 53741, 10088, 13425, 52725, 53747, 53447, 37579, 49258, 53471, 29554, 53724, 29739, 44606, 6020, 53292, 12895, 34368, 50423, 48314, 49714, 18354, 53573, 51256, 53752, 43905, 32961, 39298, 44674, 53123, 48926, 38293, 53670) ORDER BY u.username ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	sn_u	range	PRIMARY	PRIMARY	3	 	197	Using where; Using temporary; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	3	admin_pronosky.sn_u.user_id	1	 

Before: 0.05774s | After: 0.06143s | Elapsed: 0.00369s


Query #22
DELETE FROM avphpbb_sn_notify WHERE ntf_read = 16 AND ntf_change < 1331416594
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_sn_notify	range	a,b,c	c	6	 	1	Using where

Affected rows: 0 | Before: 0.06690s | After: 0.06700s | Elapsed: 0.00010s


Query #23
UPDATE avphpbb_sn_notify SET ntf_read = 19, ntf_change = '1331502994' WHERE ntf_read >= 32 AND ntf_time > 1331503294
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_sn_notify	range	a,b,c	b	6	 	1	Using where

Affected rows: 0 | Before: 0.06721s | After: 0.06730s | Elapsed: 0.00009s


Query #24
SELECT count(*) AS computed FROM avphpbb_sn_notify WHERE ntf_user = 2 AND ntf_read >= 19
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_sn_notify	range	a,b,c	a	5	 	995	Using where; Using index

Before: 0.06752s | After: 0.06781s | Elapsed: 0.00029s


Query #25
SELECT COUNT(entry_id) as count FROM avphpbb_sn_entries WHERE entry_time > 1331494096 AND entry_type = 2 AND user_id IN ('57', '65', '72', '73', '75', '94', '97', '139', '156', '168', '177', '283', '338', '344', '353', '362', '2336', '3124', '3138', '3196', '3217', '3241', '3439', '3524', '3758', '4088', '4298', '4815', '4945', '4952', '5208', '7679', '9966', '10489', '12849', '14112', '14179', '15115', '15856', '17177', '18536', '20515', '20805', '21243', '21618', '24747', '29345', '29554', '33322', '33872', '36574', '39649', '40026', '41565', '46936', '47930', '48256', '49246', '50437', '50819')
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_sn_entries	ALL	a	 	 	 	3625	Using where

Before: 0.06858s | After: 0.06974s | Elapsed: 0.00116s


Query results obtained from the cache
SELECT s.style_id, t.template_storedb, t.template_path, t.template_id, t.bbcode_bitfield, t.template_inherits_id, t.template_inherit_path, c.theme_path, c.theme_name, c.theme_storedb, c.theme_id, i.imageset_path, i.imageset_id, i.imageset_name FROM avphpbb_styles s, avphpbb_styles_template t, avphpbb_styles_theme c, avphpbb_styles_imageset i WHERE s.style_id = 31 AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imageset_id = s.imageset_id

Before: 0.07415s | After: 0.07435s | Elapsed [cache]: 0.00020s | Elapsed [db]: 0.00017s


Query results obtained from the cache
SELECT * FROM avphpbb_styles_imageset_data WHERE imageset_id = 28 AND image_filename <> '' AND image_lang IN ('it', '')

Before: 0.07522s | After: 0.07557s | Elapsed [cache]: 0.00035s | Elapsed [db]: 0.00049s


Query #28
SELECT m.membership_no FROM (avphpbb_membership m) WHERE m.associate_id = 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ALL	 	 	 	 	6	Using where

Before: 0.07632s | After: 0.07643s | Elapsed: 0.00010s


Query #29
SELECT ug.user_id, ug.user_pending, m.membership_no, m.renewal_date, m.remindertype, m.subscriber_id, m.uncleared, m.datepaid, m.associate_id FROM avphpbb_user_group AS ug LEFT JOIN avphpbb_membership AS m USING (group_id, user_id) WHERE ug.group_id = 40 AND ug.user_id = 2 UNION SELECT ug.user_id, ug.user_pending, m.membership_no, m.renewal_date, m.remindertype, m.subscriber_id, m.uncleared, m.datepaid, m.associate_id FROM avphpbb_user_group AS ug RIGHT JOIN avphpbb_membership AS m USING (group_id, user_id) WHERE m.group_id = 40 AND m.user_id = 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY	ug	ref	group_id,user_id	group_id	3	const	1	Using where
1	PRIMARY	m	ALL	 	 	 	 	6	 
2	UNION	m	ALL	 	 	 	 	6	Using where
2	UNION	ug	ref	group_id,user_id	group_id	3	const	1	 
 	UNION RESULT		ALL	 	 	 	 	 	 

Before: 0.07729s | After: 0.07781s | Elapsed: 0.00052s


Query #30
SELECT f.*, ft.mark_time, t.topic_title, t.topic_id, t.topic_last_post_id FROM (avphpbb_forums f) LEFT JOIN avphpbb_forums_track ft ON (ft.user_id = 2 AND ft.forum_id = f.forum_id) LEFT JOIN avphpbb_topics t ON (f.forum_last_post_id = t.topic_last_post_id AND t.topic_moved_id = 0) ORDER BY f.left_id
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	f	ALL	 	 	 	 	137	Using filesort
1	SIMPLE	ft	eq_ref	PRIMARY	PRIMARY	6	const,admin_pronosky.f.forum_id	1	 
1	SIMPLE	t	ref	topic_lpid,altt	topic_lpid	3	admin_pronosky.f.forum_last_post_id	1	 

Before: 0.08084s | After: 0.08826s | Elapsed: 0.00742s


Query #31
SELECT t.topic_id, t.topic_last_post_time, tt.mark_time as topic_mark_time, ft.mark_time as forum_mark_time FROM (avphpbb_topics t) LEFT JOIN avphpbb_topics_track tt ON (tt.user_id = 2 AND t.topic_id = tt.topic_id) LEFT JOIN avphpbb_forums_track ft ON (ft.user_id = 2 AND t.forum_id = ft.forum_id) WHERE t.topic_last_post_time > 1255867555 AND ( (tt.mark_time IS NOT NULL AND t.topic_last_post_time > tt.mark_time) OR (tt.mark_time IS NULL AND ft.mark_time IS NOT NULL AND t.topic_last_post_time > ft.mark_time) OR (tt.mark_time IS NULL AND ft.mark_time IS NULL) ) AND t.forum_id = 0 ORDER BY t.topic_last_post_time DESC LIMIT 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ref	forum_id,forum_id_type,last_post_time,forum_appr_last,fid_time_moved	fid_time_moved	3	const	7	Using where
1	SIMPLE	tt	eq_ref	PRIMARY,topic_id	PRIMARY	6	const,admin_pronosky.t.topic_id	1	Using where
1	SIMPLE	ft	const	PRIMARY	PRIMARY	6	const,const	1	Using where

Before: 0.08928s | After: 0.09230s | Elapsed: 0.00303s


Query #32
SELECT group_id, group_name, group_colour, group_type FROM avphpbb_groups WHERE group_legend = 1 ORDER BY group_name ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_groups	ref	group_legend_name	group_legend_name	1	const	9	Using where

Before: 0.12579s | After: 0.12599s | Elapsed: 0.00020s


Query results obtained from the cache
SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id FROM avphpbb_forums ORDER BY left_id ASC

Before: 0.12867s | After: 0.12918s | Elapsed [cache]: 0.00051s | Elapsed [db]: 0.00062s


Query #34
SELECT COUNT(r.report_id) AS total FROM avphpbb_reports r, avphpbb_posts p WHERE r.post_id = p.post_id AND r.report_closed = 0 AND forum_id IN (271, 270, 72, 45, 59, 226, 202, 225, 74, 77, 75, 76, 153, 201, 154, 157, 277, 278, 158, 263, 142, 229, 276, 228, 56, 88, 203, 217, 152, 267, 253, 223, 234, 252, 272, 268, 273, 275, 213, 264, 227, 231, 245, 250, 236, 1, 81, 3, 4, 2, 173, 31, 224, 107, 230, 23, 156, 22, 254, 41, 269, 162, 163, 30, 180, 160, 179, 130, 106, 82, 42, 113, 114, 205, 47, 222, 135, 38, 79, 36, 122, 211, 133, 64, 65, 66, 67, 68, 71, 69, 70, 215, 216, 235, 176, 181, 182, 177, 178, 29, 164, 92, 174, 6, 119, 120, 121, 7, 9, 131, 132, 151, 175, 103, 10, 11, 12, 13, 104, 15, 16, 105, 20, 21, 98, 52, 161, 248, 210, 78, 33, 34, 35, 172, 266, 251, 134)
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	r	ALL	post_id	 	 	 	4618	Using where
1	SIMPLE	p	eq_ref	PRIMARY,forum_id	PRIMARY	3	admin_pronosky.r.post_id	1	Using where

Before: 0.13246s | After: 0.13424s | Elapsed: 0.00178s


Query #35
SELECT COUNT(post_id) AS total FROM avphpbb_posts WHERE forum_id IN (271, 270, 72, 45, 59, 226, 202, 225, 74, 77, 75, 76, 153, 201, 154, 157, 277, 278, 158, 263, 142, 229, 276, 228, 56, 88, 203, 217, 152, 267, 253, 223, 234, 252, 272, 268, 273, 275, 213, 264, 227, 231, 245, 250, 236, 1, 81, 3, 4, 2, 173, 31, 224, 107, 230, 23, 156, 22, 254, 41, 269, 162, 163, 30, 180, 160, 179, 130, 106, 82, 42, 113, 114, 205, 47, 222, 135, 38, 79, 36, 122, 211, 133, 64, 65, 66, 67, 68, 71, 69, 70, 215, 216, 235, 176, 181, 182, 177, 178, 29, 164, 92, 174, 6, 119, 120, 121, 7, 9, 131, 132, 151, 175, 103, 10, 11, 12, 13, 104, 15, 16, 105, 20, 21, 98, 52, 161, 248, 210, 78, 33, 34, 35, 172, 266, 251, 134) AND post_approved = 0
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_posts	ref	forum_id,post_approved	post_approved	1	const	1	Using where

Before: 0.13616s | After: 0.13678s | Elapsed: 0.00062s


Query #36
SELECT forum_id FROM avphpbb_forums WHERE forum_id NOT IN (0, 1, 2, 3, 4, 6, 7, 9, 10, 11, 12, 13, 15, 16, 20, 21, 22, 23, 29, 30, 31, 33, 34, 35, 36, 38, 41, 42, 45, 47, 52, 56, 59, 64, 65, 66, 67, 68, 69, 70, 71, 72, 74, 75, 76, 77, 78, 79, 81, 82, 88, 92, 98, 103, 104, 105, 106, 107, 113, 114, 119, 120, 121, 122, 130, 131, 132, 133, 134, 135, 142, 151, 152, 153, 154, 156, 157, 158, 160, 161, 162, 163, 164, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 182, 201, 202, 203, 205, 210, 211, 213, 215, 216, 217, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 234, 235, 236, 245, 248, 250, 251, 252, 253, 254, 263, 264, 266, 267, 268, 269, 270, 271, 272, 273, 275, 276, 277, 278)
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_forums	index	PRIMARY	PRIMARY	3	 	137	Using where; Using index

Before: 0.14261s | After: 0.14303s | Elapsed: 0.00041s


Query #37
SELECT forum_id FROM avphpbb_forums WHERE forum_type = 1 LIMIT 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_forums	ALL	 	 	 	 	137	Using where

Before: 0.14385s | After: 0.14395s | Elapsed: 0.00010s


Query #38
SELECT t.* , tp.topic_posted, tt.mark_time FROM avphpbb_topics t LEFT JOIN avphpbb_topics_posted tp ON (tp.topic_id = t.topic_id AND tp.user_id = 2) LEFT JOIN avphpbb_topics_track tt ON (tt.topic_id = t.topic_id AND tt.user_id = 2) WHERE t.forum_id = 0 AND t.topic_type = 3 ORDER BY t.topic_last_post_time DESC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ref	forum_id,forum_id_type,forum_appr_last,fid_time_moved	fid_time_moved	3	const	7	Using where
1	SIMPLE	tp	eq_ref	PRIMARY	PRIMARY	6	const,admin_pronosky.t.topic_id	1	 
1	SIMPLE	tt	eq_ref	PRIMARY,topic_id	PRIMARY	6	const,admin_pronosky.t.topic_id	1	 

Before: 0.14437s | After: 0.14471s | Elapsed: 0.00034s


Query #39
SELECT mark_time FROM avphpbb_forums_track WHERE user_id = 2 AND forum_id = 0
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_forums_track	const	PRIMARY	PRIMARY	6	const,const	1	 

Before: 0.14507s | After: 0.14514s | Elapsed: 0.00008s


Query #40
SELECT r.room_id, r.room_name, r.room_type, r.room_low, u.user_id, u.username, u.username_clean, u.user_colour, u.user_avatar, u.user_avatar_type FROM avphpbb_poker_room r, avphpbb_users u WHERE r.room_active = 1 AND u.user_type IN (0, 3) AND ((r.p1id = u.user_id AND r.p1tt > 1331502934) OR (r.p2id = u.user_id AND r.p2tt > 1331502934) OR (r.p3id = u.user_id AND r.p3tt > 1331502934) OR (r.p4id = u.user_id AND r.p4tt > 1331502934) OR (r.p5id = u.user_id AND r.p5tt > 1331502934) OR (r.p6id = u.user_id AND r.p6tt > 1331502934) OR (r.p7id = u.user_id AND r.p7tt > 1331502934) OR (r.p8id = u.user_id AND r.p8tt > 1331502934) OR (r.p9id = u.user_id AND r.p9tt > 1331502934) OR (r.p10id = u.user_id AND r.p10tt > 1331502934)) ORDER BY r.room_type, r.room_low, u.username_clean ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	r	ref	room_active	room_active	1	const	2	Using where; Using temporary; Using filesort
1	SIMPLE	u	ALL	PRIMARY	 	 	 	51637	Range checked for each record (index map: 0x1)

Before: 0.15001s | After: 0.15035s | Elapsed: 0.00034s


Query #41
SELECT COUNT(DISTINCT s.session_ip) as num_guests FROM avphpbb_sessions s WHERE s.session_user_id = 1 AND s.session_time >= 1331501160
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ref	session_time,session_user_id	session_user_id	3	const	1100	Using where

Before: 0.15300s | After: 0.15601s | Elapsed: 0.00302s


Query #42
SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM avphpbb_sessions s WHERE s.session_time >= 1331501190 AND s.session_user_id <> 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	range	session_time,session_user_id	session_user_id	3	 	310	Using where

Before: 0.15624s | After: 0.15710s | Elapsed: 0.00086s


Query #43
SELECT username, username_clean, user_id, user_type, user_allow_viewonline, user_colour FROM avphpbb_users WHERE user_id IN (0, 2, 14, 15, 16, 97, 2990, 3458, 3700, 3752, 3758, 5303, 6020, 7162, 7409, 8091, 8629, 9130, 9578, 9824, 10088, 10091, 11797, 12443, 12895, 13255, 13425, 14443, 15290, 15322, 15791, 16488, 16806, 17722, 18354, 18536, 19730, 20226, 20618, 20630, 20959, 21293, 21313, 21369, 22284, 23366, 23899, 25325, 25522, 25655, 25774, 27169, 28550, 29109, 29189, 29554, 29739, 30115, 30694, 32465, 32788, 32961, 33117, 33328, 33621, 33874, 34368, 34674, 34717, 35467, 36023, 36432, 36543, 37135, 37307, 37572, 37579, 37932, 38042, 38293, 38948, 39173, 39298, 39361, 40555, 40822, 41569, 41870, 42178, 42292, 43276, 43528, 43784, 43814, 43905, 43921, 44410, 44606, 44674, 45050, 45112, 45142, 45202, 45683, 46041, 46448, 46581, 46855, 46919, 47269, 47314, 47536, 47600, 47703, 47930, 48314, 48349, 48751, 48755, 48778, 48801, 48926, 49258, 49338, 49493, 49522, 49530, 49714, 49748, 50423, 50506, 50553, 50625, 50793, 50840, 50844, 51094, 51253, 51256, 51392, 51646, 51687, 51985, 52192, 52363, 52391, 52472, 52524, 52620, 52634, 52725, 52751, 52899, 52946, 52970, 53123, 53194, 53224, 53276, 53292, 53447, 53471, 53506, 53525, 53563, 53573, 53592, 53612, 53621, 53623, 53642, 53653, 53670, 53684, 53686, 53698, 53704, 53710, 53712, 53715, 53724, 53725, 53728, 53733, 53734, 53737, 53738, 53739, 53741, 53742, 53746, 53747, 53748, 53749, 53750, 53751, 53752, 53753, 53754, 53757, 53758, 53759, 53760) ORDER BY username_clean ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_users	range	PRIMARY	PRIMARY	3	 	203	Using where; Using filesort

Before: 0.15866s | After: 0.16221s | Elapsed: 0.00355s


Query results obtained from the cache
SELECT forum_id FROM avphpbb_forums WHERE forum_options & 2 <> 0 LIMIT 1

Before: 0.16614s | After: 0.16633s | Elapsed [cache]: 0.00019s | Elapsed [db]: 0.00010s


Query #45
SELECT group_id FROM avphpbb_user_group WHERE user_id = 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_user_group	ref	user_id	user_id	3	const	4	 

Before: 0.17062s | After: 0.17074s | Elapsed: 0.00012s


Query #46
SELECT id, sidebar_name, sidebar_group FROM avphpbb_sidebar WHERE active = 1 ORDER BY sidebar_order ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	avphpbb_sidebar	ALL	 	 	 	 	2	Using where; Using filesort

Before: 0.17095s | After: 0.17105s | Elapsed: 0.00010s


Query #47
SELECT u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, t.topic_id, t.forum_id, t.topic_title, t.topic_poster, t.topic_time, t.topic_first_poster_name, t.topic_first_poster_colour FROM (avphpbb_topics t) LEFT JOIN avphpbb_users u ON (t.topic_poster = u.user_id) WHERE t.topic_approved = 1 AND t.topic_status <> 2 ORDER BY t.topic_time DESC LIMIT 15
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	range	topic_approved	topic_approved	1	 	279942	Using where; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	3	admin_pronosky.t.topic_poster	1	 

Before: 0.18422s | After: 0.95236s | Elapsed: 0.76814s