troppe query da 700 a 1000 in home

[sakkiotto]

e da un po di tempo (non ci avevo fatto caso) che mi sono aumentate le query nella home con aumento memoria del sistema di 20 mega.. (anche il viewtopic non scherza...)

facendo explain
Page generated in 0.7865 seconds with 738 queries + 4 queries returning data from cache

mi compaiono tante richieste alcune pure duplicate o triplicate tipo

Codice: Seleziona tutto

SELECT ban_userid FROM fmtk_banlist
WHERE ban_userid = 8572

potete aiutarmi a capire come risolvere?

[Barrnet]

Probabilmente hai qualche mod male installata o poco ottimizzata.
Potresti elencare le mod che comprendono modifiche che vengono visualizzate nelle pagine interessate?
Sarebbe utile anche vedere l'elenco delle query.

[sakkiotto]

Ciao Barrnet,
ne ho un casino di mod, facciamo prima se mi potresti dire che file guardare dove potrebbe caricare tutte quelle query

[Anto]

Ciao,
per favore inserisci link al tuo sito

[sakkiotto]

Ciao Anto,
i link sono messi se intendi i credits phpbbitalia (footer)
o intendi altri link ?

[Barrnet]

In linea di massima dovresti controllare ogni file che viene richiamato nelle pagine problematiche.
Riesci ad incollare la tabella del debug che riassume tutte le query attive?

[sakkiotto]

adesso ho drasticamente ridotto a 100 query (ho tolto le mod who whas where e activity stat)
però vedo sempre quelle query che ho scritto sopra:


Time : 0.375s | 116 Queries | GZIP : Off | Memory Usage: 18.87 MiB
provo ad incollare qui

Codice: Seleziona tutto

SQL Report

Page generated in 0.4064 seconds with 113 queries + 5 queries returning data from cache

Time spent on mysqli queries: 0.1569s | Time spent on PHP: 0.24948s


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

Before: 0.02437s | After: 0.02465s | Elapsed: 0.00028s


Query #2
SELECT config_name, config_value FROM fmtk_points_config
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_points_config	ALL	 	 	 	 	18	 

Before: 0.02590s | After: 0.02602s | Elapsed: 0.00012s


Query #3
SELECT * FROM (fmtk_points_values v)
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	v	ALL	 	 	 	 	1	 

Before: 0.02633s | After: 0.02649s | Elapsed: 0.00016s


Query #4
SELECT u.*, s.* FROM fmtk_sessions s, fmtk_users u WHERE s.session_id = 'e673d9e5f8919b7a952ef5a09609bdfa' 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.03710s | After: 0.03746s | Elapsed: 0.00036s


Query #5
UPDATE fmtk_sessions SET session_time = 1413476441, session_page = 'index.php?&explain=1', session_forum_id = 0 WHERE session_id = 'e673d9e5f8919b7a952ef5a09609bdfa'
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_sessions	const	PRIMARY	PRIMARY	96	const	1	 

Affected rows: 1 | Before: 0.03817s | After: 0.06579s | Elapsed: 0.02762s


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 fmtk_styles s, fmtk_styles_template t, fmtk_styles_theme c, fmtk_styles_imageset i WHERE s.style_id = 6 AND t.template_id = s.template_id AND c.theme_id = s.theme_id AND i.imageset_id = s.imageset_id

Before: 0.07372s | After: 0.07383s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00018s


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

Before: 0.07440s | After: 0.07468s | Elapsed [cache]: 0.00028s | Elapsed [db]: 0.00053s


Query #8
SELECT f.*, ft.mark_time, t.topic_id, t.topic_title, t.topic_replies, t.topic_replies_real, t.topic_status, t.topic_type, t.topic_moved_id , t.topic_attr_id, t.topic_attr_user, t.topic_attr_time, t.topic_moved_id, t.topic_last_post_id FROM (fmtk_forums f) LEFT JOIN fmtk_forums_track ft ON (ft.user_id = 2 AND ft.forum_id = f.forum_id) LEFT JOIN fmtk_topics t ON (f.forum_last_post_id = t.topic_last_post_id) ORDER BY f.left_id
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	f	ALL	 	 	 	 	64	Using filesort
1	SIMPLE	ft	eq_ref	PRIMARY	PRIMARY	6	const,czbbsonw_00.f.forum_id	1	 
1	SIMPLE	t	ref	topic_lpid,altt	topic_lpid	3	czbbsonw_00.f.forum_last_post_id	1	 

Before: 0.07996s | After: 0.08460s | Elapsed: 0.00464s


Query #9
SELECT t.topic_id, t.topic_last_post_time, tt.mark_time as topic_mark_time, ft.mark_time as forum_mark_time FROM (fmtk_topics t) LEFT JOIN fmtk_topics_track tt ON (tt.user_id = 2 AND t.topic_id = tt.topic_id) LEFT JOIN fmtk_forums_track ft ON (ft.user_id = 2 AND t.forum_id = ft.forum_id) WHERE t.topic_last_post_time > 1410842970 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	1	Using where
1	SIMPLE	tt	eq_ref	PRIMARY,topic_id	PRIMARY	6	const,czbbsonw_00.t.topic_id	1	Using where
1	SIMPLE	ft	const	PRIMARY	PRIMARY	6	const,const	1	Using where

Before: 0.08507s | After: 0.08531s | Elapsed: 0.00024s


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

Before: 0.09544s | After: 0.09585s | Elapsed [cache]: 0.00041s | Elapsed [db]: 0.00093s


Query #11
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 7109
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.09627s | After: 0.09638s | Elapsed: 0.00011s


Query #12
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 7109
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.09662s | After: 0.09673s | Elapsed: 0.00011s


Query #13
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 6519
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.09701s | After: 0.09712s | Elapsed: 0.00010s


Query #14
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 5592
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.09737s | After: 0.09748s | Elapsed: 0.00010s


Query #15
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 6572
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.09774s | After: 0.09785s | Elapsed: 0.00010s


Query #16
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 7361
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.09813s | After: 0.09823s | Elapsed: 0.00010s


Query #17
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 2430
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.10183s | After: 0.10196s | Elapsed: 0.00013s


Query #18
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11301
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.10275s | After: 0.10286s | Elapsed: 0.00011s


Query #19
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 1558
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.10497s | After: 0.10508s | Elapsed: 0.00010s


Query #20
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 4534
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.10599s | After: 0.10610s | Elapsed: 0.00011s


Query #21
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 2927
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.10876s | After: 0.10888s | Elapsed: 0.00012s


Query #22
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 2631
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.11120s | After: 0.11130s | Elapsed: 0.00011s


Query #23
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 10214
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.11338s | After: 0.11349s | Elapsed: 0.00011s


Query #24
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11173
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.11564s | After: 0.11575s | Elapsed: 0.00011s


Query #25
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 1521
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.11777s | After: 0.11790s | Elapsed: 0.00013s


Query #26
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 10759
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.12011s | After: 0.12021s | Elapsed: 0.00010s


Query #27
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 219
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.12238s | After: 0.12249s | Elapsed: 0.00011s


Query #28
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 10574
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.12451s | After: 0.12462s | Elapsed: 0.00011s


Query #29
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 10633
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.12675s | After: 0.12688s | Elapsed: 0.00012s


Query #30
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 4534
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.12884s | After: 0.12897s | Elapsed: 0.00012s


Query #31
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 10995
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.13096s | After: 0.13107s | Elapsed: 0.00010s


Query #32
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 9875
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.13350s | After: 0.13361s | Elapsed: 0.00011s


Query #33
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11128
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.13437s | After: 0.13448s | Elapsed: 0.00011s


Query #34
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 9412
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.13556s | After: 0.13567s | Elapsed: 0.00011s


Query #35
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 8572
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.13791s | After: 0.13802s | Elapsed: 0.00011s


Query #36
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11238
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.14014s | After: 0.14025s | Elapsed: 0.00011s


Query #37
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 5361
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.14234s | After: 0.14244s | Elapsed: 0.00011s


Query #38
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 7158
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.14452s | After: 0.14463s | Elapsed: 0.00010s


Query #39
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 4221
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.14536s | After: 0.14547s | Elapsed: 0.00011s


Query #40
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 1558
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.15203s | After: 0.15214s | Elapsed: 0.00011s


Query #41
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 10989
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.15439s | After: 0.15450s | Elapsed: 0.00011s


Query #42
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 6629
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.15650s | After: 0.15660s | Elapsed: 0.00011s


Query #43
SELECT group_id, group_name, group_colour, group_type, group_position, group_legend FROM fmtk_groups WHERE group_legend > 0 ORDER BY group_position ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_groups	ALL	group_legend_name	 	 	 	15	Using where; Using filesort

Before: 0.15772s | After: 0.15791s | Elapsed: 0.00019s


Query #44
SELECT forum_id FROM fmtk_forums WHERE forum_id NOT IN (0, 1, 3, 4, 5, 6, 7, 8, 9, 12, 16, 17, 18, 22, 23, 24, 25, 26, 27, 29, 30, 31, 32, 34, 35, 36, 38, 39, 41, 43, 44, 45, 46, 47, 48, 51, 54, 55, 58, 59, 60, 61, 62, 63, 65, 66, 69, 73, 74, 75, 76, 77, 78, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98)
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_forums	index	PRIMARY	forum_lastpost_id	3	 	64	Using where; Using index

Before: 0.16035s | After: 0.16074s | Elapsed: 0.00039s


Query #45
SELECT u.user_id, u.username, u.user_colour, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, t.topic_title, t.topic_attr_id, t.topic_attr_user, t.topic_attr_time, t.forum_id, t.topic_last_post_id, t.topic_last_post_time, t.topic_last_poster_name FROM (fmtk_topics t) LEFT JOIN fmtk_users u ON (t.topic_last_poster_id = u.user_id) WHERE t.topic_approved = 1 AND t.topic_status <> 2 AND t.forum_id <> '9' 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	index	forum_id,forum_id_type,topic_approved,forum_appr_last,fid_time_moved	last_post_time	4	 	5	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	3	czbbsonw_00.t.topic_last_poster_id	1	 

Before: 0.16143s | After: 0.16176s | Elapsed: 0.00034s


Query #46
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11173
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.16215s | After: 0.16225s | Elapsed: 0.00011s


Query #47
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 10759
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.16404s | After: 0.16414s | Elapsed: 0.00011s


Query #48
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 6519
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.16579s | After: 0.16592s | Elapsed: 0.00013s


Query #49
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 9566
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.16758s | After: 0.16769s | Elapsed: 0.00011s


Query #50
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 7946
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.16934s | After: 0.16944s | Elapsed: 0.00011s


Query #51
SELECT u.username, u.user_id, u.user_colour, COUNT(p.post_id) AS user_posts FROM fmtk_users u, fmtk_posts p WHERE u.user_type NOT IN (2, 1) AND u.user_id = p.poster_id AND p.post_time BETWEEN 1412121600 AND 1413476441 GROUP BY u.user_id ORDER BY user_posts DESC LIMIT 10
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	ALL	poster_id	 	 	 	22297	Using where; Using temporary; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY,user_type	PRIMARY	3	czbbsonw_00.p.poster_id	1	Using where

Before: 0.17114s | After: 0.20940s | Elapsed: 0.03826s


Query #52
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 7158
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.20992s | After: 0.21004s | Elapsed: 0.00012s


Query #53
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 1558
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21035s | After: 0.21046s | Elapsed: 0.00011s


Query #54
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 2430
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21075s | After: 0.21085s | Elapsed: 0.00010s


Query #55
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 2927
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21115s | After: 0.21125s | Elapsed: 0.00010s


Query #56
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 5592
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21153s | After: 0.21164s | Elapsed: 0.00011s


Query #57
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 219
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21194s | After: 0.21205s | Elapsed: 0.00010s


Query #58
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 4534
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21233s | After: 0.21244s | Elapsed: 0.00011s


Query #59
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 8871
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21275s | After: 0.21286s | Elapsed: 0.00010s


Query #60
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 10506
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21318s | After: 0.21328s | Elapsed: 0.00010s


Query #61
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 9848
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21358s | After: 0.21370s | Elapsed: 0.00011s


Query #62
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11301
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21413s | After: 0.21424s | Elapsed: 0.00010s


Query #63
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11300
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21456s | After: 0.21467s | Elapsed: 0.00011s


Query #64
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11299
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21498s | After: 0.21508s | Elapsed: 0.00010s


Query #65
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11298
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21536s | After: 0.21546s | Elapsed: 0.00010s


Query #66
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11297
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21574s | After: 0.21585s | Elapsed: 0.00010s


Query #67
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11296
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21615s | After: 0.21625s | Elapsed: 0.00010s


Query #68
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11295
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21653s | After: 0.21663s | Elapsed: 0.00011s


Query #69
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11294
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21693s | After: 0.21704s | Elapsed: 0.00010s


Query #70
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11293
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21731s | After: 0.21742s | Elapsed: 0.00010s


Query #71
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11292
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21770s | After: 0.21780s | Elapsed: 0.00010s


Query #72
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21820s | After: 0.21831s | Elapsed: 0.00010s


Query #73
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 3
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21857s | After: 0.21868s | Elapsed: 0.00011s


Query #74
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 4
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21896s | After: 0.21906s | Elapsed: 0.00010s


Query #75
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 5
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21932s | After: 0.21943s | Elapsed: 0.00011s


Query #76
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 6
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.21969s | After: 0.21979s | Elapsed: 0.00010s


Query #77
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 7
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.22007s | After: 0.22017s | Elapsed: 0.00010s


Query #78
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 8
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.22043s | After: 0.22054s | Elapsed: 0.00010s


Query #79
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 9
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.22080s | After: 0.22093s | Elapsed: 0.00013s


Query #80
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 10
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.22118s | After: 0.22129s | Elapsed: 0.00010s


Query #81
SELECT COUNT(l.post_id) AS count, l.post_id, p.post_subject, u.username FROM likes l, fmtk_posts p, fmtk_users u WHERE l.ld = 0 AND l.like_time > 1412871641 AND p.post_id = l.post_id AND u.user_id = p.poster_id GROUP BY l.post_id ORDER BY count DESC LIMIT 0,5
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	l	ALL	lpost	 	 	 	5713	Using where; Using temporary; Using filesort
1	SIMPLE	p	eq_ref	PRIMARY,poster_id	PRIMARY	3	czbbsonw_00.l.post_id	1	 
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	3	czbbsonw_00.p.poster_id	1	 

Before: 0.22176s | After: 0.22535s | Elapsed: 0.00359s


Query #82
SELECT SUM(holding) AS total_holding, count(user_id) AS total_users FROM (fmtk_points_bank b) WHERE id > 0
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	b	range	PRIMARY	PRIMARY	4	 	1	Using where

Before: 0.22750s | After: 0.22763s | Elapsed: 0.00013s


Query #83
SELECT u.user_id, u.username, u.user_colour, u.user_points, b.holding FROM (fmtk_users u) LEFT JOIN fmtk_points_bank b ON (u.user_id = b.user_id)
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	ALL	 	 	 	 	10825	 
1	SIMPLE	b	ALL	 	 	 	 	1	 

Before: 0.22791s | After: 0.25893s | Elapsed: 0.03103s


Query #84
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11301
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.31952s | After: 0.31965s | Elapsed: 0.00013s


Query #85
SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM fmtk_sessions s WHERE s.session_time >= 1413476130 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_time	4	 	38	Using where

Before: 0.32234s | After: 0.32260s | Elapsed: 0.00026s


Query #86
SELECT username, username_clean, user_id, user_type, user_allow_viewonline, user_colour FROM fmtk_users WHERE user_id IN (5661, 5946, 17, 3747, 11301, 1831, 5290, 5804, 2927, 4721, 9782, 11237, 7509, 6635, 3153, 5361, 8491, 8548, 4, 8, 2) ORDER BY username_clean ASC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_users	range	PRIMARY	PRIMARY	3	 	21	Using where; Using filesort

Before: 0.32305s | After: 0.32359s | Elapsed: 0.00054s


Query #87
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 1831
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32397s | After: 0.32407s | Elapsed: 0.00010s


Query #88
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 5661
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32441s | After: 0.32451s | Elapsed: 0.00010s


Query #89
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 7509
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32484s | After: 0.32496s | Elapsed: 0.00012s


Query #90
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 2927
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32519s | After: 0.32528s | Elapsed: 0.00010s


Query #91
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 5361
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32558s | After: 0.32569s | Elapsed: 0.00010s


Query #92
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11301
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32594s | After: 0.32605s | Elapsed: 0.00010s


Query #93
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32628s | After: 0.32637s | Elapsed: 0.00010s


Query #94
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 3747
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32662s | After: 0.32673s | Elapsed: 0.00010s


Query #95
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 5290
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32700s | After: 0.32710s | Elapsed: 0.00010s


Query #96
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 4721
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32735s | After: 0.32745s | Elapsed: 0.00010s


Query #97
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 3153
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32771s | After: 0.32780s | Elapsed: 0.00010s


Query #98
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 9782
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32810s | After: 0.32821s | Elapsed: 0.00010s


Query #99
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11237
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32853s | After: 0.32862s | Elapsed: 0.00010s


Query #100
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 8491
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32893s | After: 0.32903s | Elapsed: 0.00010s


Query #101
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 6635
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32928s | After: 0.32938s | Elapsed: 0.00010s


Query #102
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 8548
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.32963s | After: 0.32973s | Elapsed: 0.00010s


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

Before: 0.33116s | After: 0.33125s | Elapsed [cache]: 0.00010s | Elapsed [db]: 0.00011s


Query #104
SELECT count(id) as total FROM fmtk_downloads_cat WHERE bug_tracker = 1
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_downloads_cat	ALL	 	 	 	 	25	Using where

Before: 0.33147s | After: 0.33159s | Elapsed: 0.00012s


Query results obtained from the cache
SELECT a.ad_id FROM fmtk_ads_groups a, fmtk_user_group ug WHERE ug.user_pending = 0 AND ug.user_id = 2 AND a.group_id = ug.group_id

Before: 0.33352s | After: 0.33363s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00020s


Query #106
SELECT ad_id, position_id, ad_priority FROM fmtk_ads_in_positions WHERE ad_enabled = 1 AND all_forums = 1 AND ad_id NOT IN ('10', '10', '10') ORDER BY ad_priority DESC
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_ads_in_positions	ref	ad_position,ad_enabled,all_forums	ad_enabled	1	const	21	Using where; Using filesort

Before: 0.33394s | After: 0.33413s | Elapsed: 0.00018s


Query #107
SELECT COUNT(distinct t.topic_id) as total FROM fmtk_topics t WHERE t.topic_last_post_time > 1413468415 AND t.topic_moved_id = 0 AND t.forum_id <> 9
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	range	forum_id,forum_id_type,last_post_time,forum_appr_last,fid_time_moved	last_post_time	4	 	13	Using where

Before: 0.34231s | After: 0.34267s | Elapsed: 0.00036s


Query #108
SELECT user_posts FROM fmtk_users WHERE user_id = 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_users	const	PRIMARY	PRIMARY	3	const	1	 

Before: 0.34301s | After: 0.34311s | Elapsed: 0.00010s


Query #109
SELECT t.topic_id, t.topic_last_post_time, tt.mark_time as topic_mark_time, ft.mark_time as forum_mark_time FROM (fmtk_topics t) LEFT JOIN fmtk_topics_track tt ON (tt.user_id = 2 AND t.topic_id = tt.topic_id) LEFT JOIN fmtk_forums_track ft ON (ft.user_id = 2 AND t.forum_id = ft.forum_id) WHERE t.topic_last_post_time > 1410842970 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.topic_moved_id = 0 AND t.forum_id <> 9 ORDER BY t.topic_id DESC LIMIT 1001
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	range	forum_id,forum_id_type,last_post_time,forum_appr_last,fid_time_moved	last_post_time	4	 	1628	Using where; Using filesort
1	SIMPLE	tt	eq_ref	PRIMARY,topic_id	PRIMARY	6	const,czbbsonw_00.t.topic_id	1	Using where
1	SIMPLE	ft	eq_ref	PRIMARY	PRIMARY	6	const,czbbsonw_00.t.forum_id	1	Using where

Before: 0.34398s | After: 0.35281s | Elapsed: 0.00883s


Query #110
SELECT COUNT(distinct t.topic_id) as total FROM fmtk_topics t WHERE t.topic_id IN (10401, 10398, 10397, 10395, 10391, 10388, 10382, 10381, 10380, 10377, 10376, 10375, 10372, 10370, 10368, 10360, 10357, 10350, 10349, 10348, 10346, 10343, 10338, 10329, 10327, 10319, 10315, 10314, 10307, 10306, 10303, 10300, 10294, 10292, 10288, 10286, 10278, 10277, 10275, 10274, 10273, 10270, 10267, 10263, 10262, 10259, 10254, 10250, 10246, 10245, 10240, 10233, 10232, 10228, 10219, 10218, 10215, 10210, 10207, 10204, 10203, 10201, 10200, 10199, 10198, 10197, 10196, 10195, 10194, 10193, 10192, 10191, 10190, 10189, 10188, 10186, 10185, 10184, 10183, 10182, 10181, 10180, 10179, 10178, 10177, 10176, 10174, 10173, 10172, 10170, 10169, 10168, 10167, 10166, 10164, 10163, 10162, 10161, 10160, 10159, 10158, 10157, 10155, 10154, 10153, 10152, 10151, 10150, 10149, 10147, 10146, 10145, 10144, 10143, 10142, 10141, 10139, 10138, 10137, 10136, 10135, 10134, 10133, 10132, 10131, 10130, 10129, 10128, 10127, 10126, 10125, 10124, 10123, 10122, 10121, 10120, 10119, 10118, 10117, 10116, 10115, 10114, 10113, 10112, 10111, 10110, 10109, 10108, 10107, 10106, 10105, 10104, 10103, 10102, 10101, 10100, 10099, 10098, 10097, 10096, 10095, 10094, 10093, 10092, 10091, 10090, 10089, 10088, 10087, 10086, 10085, 10084, 10082, 10081, 10080, 10079, 10077, 10076, 10075, 10074, 10073, 10072, 10071, 10070, 10069, 10068, 10067, 10065, 10064, 10063, 10061, 10060, 10059, 10058, 10057, 10056, 10055, 10054, 10053, 10052, 10050, 10049, 10048, 10047, 10045, 10044, 10043, 10042, 10041, 10040, 10039, 10038, 10037, 10036, 10035, 10034, 10033, 10032, 10031, 10030, 10029, 10028, 10027, 10026, 10024, 10023, 10022, 10020, 10017, 10016, 10015, 10014, 10013, 10012, 10011, 10010, 10009, 10008, 10007, 10006, 10005, 10004, 10003, 10002, 10001, 10000, 9998, 9995, 9993, 9992, 9983, 9981, 9977, 9974, 9973, 9970, 9969, 9967, 9966, 9961, 9959, 9958, 9957, 9955, 9953, 9948, 9939, 9938, 9932, 9931, 9930, 9928, 9927, 9925, 9920, 9917, 9916, 9914, 9907, 9902, 9898, 9897, 9895, 9893, 9891, 9890, 9886, 9885, 9884, 9883, 9880, 9877, 9868, 9865, 9862, 9858, 9855, 9854, 9850, 9846, 9845, 9844, 9836, 9835, 9834, 9833, 9831, 9828, 9827, 9826, 9825, 9823, 9821, 9816, 9815, 9813, 9810, 9808, 9807, 9804, 9799, 9797, 9793, 9791, 9789, 9787, 9785, 9779, 9773, 9771, 9770, 9760, 9756, 9750, 9748, 9747, 9746, 9744, 9737, 9736, 9732, 9730, 9729, 9728, 9721, 9719, 9718, 9707, 9706, 9704, 9696, 9690, 9689, 9688, 9687, 9685, 9682, 9678, 9670, 9666, 9664, 9662, 9661, 9660, 9657, 9651, 9649, 9643, 9642, 9636, 9633, 9632, 9630, 9622, 9619, 9618, 9617, 9614, 9613, 9608, 9607, 9596, 9593, 9591, 9588, 9587, 9582, 9573, 9568, 9566, 9559, 9555, 9551, 9545, 9544, 9542, 9535, 9532, 9531, 9530, 9529, 9522, 9519, 9517, 9516, 9512, 9511, 9508, 9503, 9502, 9499, 9498, 9496, 9492, 9488, 9486, 9485, 9483, 9482, 9479, 9476, 9475, 9474, 9472, 9470, 9468, 9464, 9462, 9457, 9456, 9455, 9451, 9445, 9438, 9435, 9434, 9433, 9430, 9429, 9426, 9421, 9419, 9416, 9413, 9403, 9402, 9401, 9398, 9397, 9396, 9393, 9388, 9386, 9383, 9381, 9379, 9377, 9373, 9370, 9367, 9364, 9363, 9360, 9354, 9352, 9350, 9346, 9344, 9341, 9335, 9333, 9332, 9331, 9329, 9327, 9322, 9319, 9318, 9316, 9314, 9308, 9306, 9305, 9303, 9302, 9289, 9287, 9283, 9273, 9268, 9263, 9260, 9257, 9248, 9240, 9225, 9223, 9222, 9220, 9219, 9218, 9214, 9210, 9206, 9201, 9198, 9197, 9196, 9194, 9192, 9191, 9190, 9186, 9180, 9177, 9174, 9170, 9169, 9167, 9163, 9158, 9152, 9148, 9142, 9140, 9139, 9135, 9129, 9126, 9125, 9124, 9120, 9117, 9112, 9107, 9100, 9099, 9097, 9092, 9089, 9087, 9086, 9085, 9083, 9081, 9079, 9077, 9075, 9073, 9072, 9070, 9065, 9064, 9063, 9062, 9060, 9059, 9057, 9053, 9050, 9048, 9047, 9043, 9038, 9036, 9032, 9027, 9026, 9025, 9023, 9022, 9021, 9020, 9019, 9011, 9010, 9009, 9005, 8996, 8989, 8988, 8987, 8978, 8977, 8976, 8974, 8973, 8969, 8968, 8965, 8964, 8963, 8958, 8950, 8946, 8943, 8942, 8939, 8937, 8935, 8933, 8928, 8923, 8913, 8907, 8903, 8899, 8897, 8896, 8895, 8890, 8889, 8886, 8882, 8876, 8875, 8873, 8872, 8871, 8869, 8866, 8865, 8864, 8860, 8859, 8857, 8856, 8851, 8850, 8848, 8845, 8841, 8838, 8832, 8830, 8829, 8825, 8823, 8815, 8814, 8812, 8808, 8806, 8802, 8801, 8798, 8796, 8794, 8789, 8787, 8783, 8781, 8780, 8778, 8775, 8770, 8769, 8768, 8759, 8756, 8755, 8750, 8748, 8742, 8740, 8732, 8731, 8730, 8729, 8726, 8725, 8722, 8717, 8715, 8711, 8710, 8707, 8698, 8696, 8694, 8690, 8689, 8685, 8681, 8680, 8676, 8674, 8672, 8670, 8666, 8661, 8660, 8658, 8655, 8654, 8653, 8652, 8651, 8648, 8646, 8644, 8640, 8637, 8636, 8635, 8633, 8629, 8627, 8625, 8622, 8621, 8604, 8600, 8594, 8593, 8588, 8587, 8586, 8585, 8579, 8578, 8575, 8571, 8564, 8547, 8540, 8533, 8528, 8526, 8523, 8519, 8518, 8512, 8506, 8504, 8491, 8490, 8484, 8483, 8479, 8476, 8471, 8469, 8467, 8466, 8464, 8462, 8461, 8460, 8445, 8442, 8439, 8436, 8420, 8418, 8413, 8409, 8403, 8395, 8390, 8388, 8385, 8373, 8366, 8357, 8356, 8344, 8336, 8332, 8322, 8321, 8317, 8307, 8302, 8296, 8289, 8282, 8276, 8274, 8260, 8257, 8252, 8242, 8218, 8206, 8201, 8200, 8178, 8177, 8165, 8148, 8146, 8128, 8121, 8119, 8106, 8096, 8076, 8073, 8065, 8061, 8045, 8033, 8027, 8015, 7979, 7953, 7925, 7920, 7909, 7895, 7891, 7888, 7872, 7868, 7864, 7863, 7856, 7848, 7826, 7815, 7790, 7754, 7748, 7725, 7715, 7694, 7691, 7687, 7676, 7654, 7652, 7633, 7611, 7594, 7580, 7550, 7529, 7516, 7514, 7431, 7404, 7398, 7300, 7268, 7264, 7238, 7222, 7192, 7175, 7116, 7096, 7084, 7083, 7051, 7013, 6996, 6994, 6990, 6981, 6979, 6977, 6974, 6967, 6960, 6909, 6893, 6806, 6799, 6721, 6656, 6628, 6623, 6600, 6584, 6577, 6543, 6531, 6512, 6511, 6500, 6454, 6444, 6429, 6416, 6386, 6381, 6361, 6345, 6341, 6328, 6322, 6283, 6246, 6192, 6182, 6166, 6150, 6141, 6122, 6019, 6002, 5932, 5908, 5892, 5849, 5778, 5678, 5674, 5662, 5649, 5645, 5621, 5543, 5534, 5515, 5512, 5407, 5393, 5354, 5346, 5328, 5298, 5277, 5228, 5215, 5214, 5150, 5122, 5086, 5080, 5077, 5061, 5030, 5023, 5013, 5000, 4628, 4576, 4567, 4566, 4539, 4509, 4503, 4489, 4461, 4311, 4302, 4293, 4292, 4281, 4261, 4252, 4166, 4161, 4139, 4132, 4115, 4109, 4104, 3987, 3982, 3971, 3967, 3928, 3917, 3915, 3861, 3859, 3803, 3704, 3693, 3692, 3628, 3624, 3611, 3479, 3478, 3477, 3476, 3475, 3473, 3469, 3468, 3467, 3465, 3464, 3463, 3440, 3419, 3411, 3356, 3334, 3251, 3244, 3213, 3197, 3169, 3101, 2975, 2840)
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	range	PRIMARY	PRIMARY	3	 	1001	Using where; Using index

Before: 0.36033s | After: 0.36393s | Elapsed: 0.00361s


Query #111
SELECT COUNT(post_id) as count FROM fmtk_posts WHERE post_time > 1413468415 AND poster_id != 2
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_posts	ALL	poster_id	 	 	 	22297	Using where

Before: 0.36466s | After: 0.38971s | Elapsed: 0.02505s


Query #112
SELECT u.username, u.user_avatar, u.user_avatar_type, u.user_avatar_width, u.user_avatar_height, p.post_text, t.topic_id, t.forum_id, t.topic_title, t.topic_last_post_time, t.topic_replies_real, t.topic_first_poster_colour, t.topic_last_post_id, t.topic_last_poster_name, t.topic_last_poster_colour FROM fmtk_topics t, fmtk_posts p, fmtk_users u WHERE t.forum_id <> 9 AND p.topic_id = t.topic_id AND p.post_approved = 1 AND u.user_id = topic_last_poster_id AND p.post_id = t.topic_last_post_id ORDER BY t.topic_last_post_time DESC LIMIT 0,20
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	index	PRIMARY,forum_id,forum_id_type,forum_appr_last,fid_time_moved,topic_lpid,altt	last_post_time	4	 	20	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	3	czbbsonw_00.t.topic_last_poster_id	1	 
1	SIMPLE	p	eq_ref	PRIMARY,topic_id,post_approved,tid_post_time	PRIMARY	3	czbbsonw_00.t.topic_last_post_id	1	Using where

Before: 0.39113s | After: 0.39185s | Elapsed: 0.00072s


Query #113
SELECT ban_userid FROM fmtk_banlist WHERE ban_userid = 11301
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_banlist	ref	ban_user	ban_user	3	const	1	Using index

Before: 0.39852s | After: 0.39864s | Elapsed: 0.00012s


Query #114
SELECT * FROM fmtk_customize_style_menu WHERE button_display = 1 AND parent_id = 0 ORDER BY left_id
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_customize_style_menu	ALL	 	 	 	 	1	Using where; Using filesort

Before: 0.40154s | After: 0.40170s | Elapsed: 0.00015s


Query #115
SELECT * FROM fmtk_customize_style_config
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_customize_style_config	ALL	 	 	 	 	12	 

Before: 0.40187s | After: 0.40197s | Elapsed: 0.00010s


Query #116
SELECT * FROM fmtk_customize_style_links WHERE button_display = 1 ORDER BY left_id
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_customize_style_links	ALL	 	 	 	 	10	Using where; Using filesort

Before: 0.40225s | After: 0.40243s | Elapsed: 0.00017s


Query #117
SELECT * FROM fmtk_customize_style_social WHERE button_display = 1 ORDER BY left_id
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_customize_style_social	ALL	 	 	 	 	5	Using where; Using filesort

Before: 0.40280s | After: 0.40294s | Elapsed: 0.00014s


Query #118
SELECT style_id, style_name FROM fmtk_styles WHERE style_active = 1 ORDER BY style_name
Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	fmtk_styles	ALL	 	 	 	 	2	Using where; Using filesort

Before: 0.40361s | After: 0.40379s | Elapsed: 0.00018s


Powered by phpBB® Forum Software © phpBB Group 

[Anto]

Il link al tuo forum phpBB

[sakkiotto]

www.manutek.it/forum/

io lho inserito nel profilo (per voi staff)

[Anto]

Sei in manutenzione? La pagina del tuo forum resta in caricamento.