SQL Report

Page generated in 0.0764 seconds with 38 queries + 4 queries returning data from cache

Time spent on mysqli queries: 0.01398s | Time spent on PHP: 0.0624s

Query #1
SELECT config_name, config_value FROM nouncb1_config WHERE is_dynamic = 1

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

Before: 0.00910s | After: 0.00949s | Elapsed: 0.00038s

Query #2
SELECT u.*, s.* FROM nouncb1_sessions s, nouncb1_users u WHERE s.session_id = '702171b334c203b75c5f5e6db3e1be2c' AND u.user_id = s.session_user_id

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

Before: 0.01921s | After: 0.01963s | Elapsed: 0.00042s

Query #3
SELECT * FROM nouncb1_users WHERE user_id = 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_users	const	PRIMARY	PRIMARY	4	const	1

Before: 0.02130s | After: 0.02171s | Elapsed: 0.00041s

Query results obtained from the cache
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end FROM nouncb1_banlist WHERE ban_email = '' AND (ban_userid = 1 OR ban_ip <> '')

Before: 0.02220s | After: 0.02256s | Elapsed [cache]: 0.00036s | Elapsed [db]: 0.00037s

Query #5
DELETE FROM nouncb1_sessions WHERE session_id = '702171b334c203b75c5f5e6db3e1be2c' AND session_user_id = 1

Affected rows: 0 | Before: 0.02313s | After: 0.02340s | Elapsed: 0.00027s

Query #6

INSERT INTO nouncb1_sessions (session_user_id, session_start, session_last_visit, session_time, session_browser, session_forwarded_for, session_ip, session_autologin, session_admin, session_viewonline, session_page, session_forum_id, session_id) VALUES (1, 1695819352, 1695819352, 1695819352, 'CCBot/2.0 (https://commoncrawl.org/faq/)', '', '3.235.188.113', 0, 0, 1, 'viewtopic.php?explain=1&f=14&p=7299', 14, '543a0a0e58700f8bc0fb0b76131c49a2')

Before: 0.02370s | After: 0.02429s | Elapsed: 0.00059s

Query #7
SELECT COUNT(session_id) AS sessions FROM nouncb1_sessions WHERE session_user_id = 1 AND session_time >= 1695812152

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_sessions	ALL	session_time,session_user_id				1994	Using where

Before: 0.02488s | After: 0.02584s | Elapsed: 0.00096s

Query #8
SELECT t.*, f.*, p.post_visibility, p.post_time, p.post_id FROM (nouncb1_forums f CROSS JOIN nouncb1_posts p CROSS JOIN nouncb1_topics t) WHERE p.post_id = 7299 AND t.topic_id = p.topic_id AND f.forum_id = t.forum_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	const	PRIMARY,topic_id,tid_post_time	PRIMARY	4	const	1
1	SIMPLE	t	const	PRIMARY,forum_id,forum_id_type,fid_time_moved,forum_vis_last,latest_topics	PRIMARY	4	const	1
1	SIMPLE	f	const	PRIMARY	PRIMARY	3	const	1

Before: 0.02781s | After: 0.02825s | Elapsed: 0.00044s

Query results obtained from the cache
SELECT * FROM nouncb1_styles s WHERE s.style_id = 3

Before: 0.03273s | After: 0.03300s | Elapsed [cache]: 0.00027s | Elapsed [db]: 0.00026s

Query #10
SELECT * FROM nouncb1_config_text WHERE config_name = 'internal_link_domains'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.03782s | After: 0.03817s | Elapsed: 0.00035s

Query #11
SELECT * FROM nouncb1_config_text WHERE config_name = 'forbidden_domains'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.03924s | After: 0.03944s | Elapsed: 0.00020s

Query #12
SELECT p.post_id FROM nouncb1_posts p WHERE p.topic_id = 5236 AND p.post_visibility = 1 ORDER BY p.post_time ASC, p.post_id ASC LIMIT 10

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	ref	topic_id,tid_post_time,post_visibility	tid_post_time	4	const	1	Using where

Before: 0.04189s | After: 0.04222s | Elapsed: 0.00033s

Query #13
SELECT u.*, z.friend, z.foe, p.* FROM (nouncb1_users u CROSS JOIN nouncb1_posts p) LEFT JOIN nouncb1_zebra z ON (z.user_id = 1 AND z.zebra_id = p.poster_id) WHERE p.post_id = 7299 AND u.user_id = p.poster_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	const	PRIMARY,poster_id	PRIMARY	4	const	1
1	SIMPLE	z	const	PRIMARY	PRIMARY	8	const,const		Unique row not found
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1

Before: 0.04295s | After: 0.04347s | Elapsed: 0.00052s

Query #14
SELECT lang_id FROM nouncb1_lang WHERE lang_iso = 'en'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_lang	ref	lang_iso	lang_iso	92	const	1	Using where; Using index

Before: 0.04712s | After: 0.04737s | Elapsed: 0.00025s

Query #15
SELECT l.*, f.* FROM nouncb1_profile_lang l, nouncb1_profile_fields f WHERE l.lang_id = 1 AND f.field_active = 1 AND f.field_no_view = 0 AND l.field_id = f.field_id ORDER BY f.field_order

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	l	ALL	PRIMARY				10	Using where; Using temporary; Using filesort
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	3	nounites_nouncb1.l.field_id	1	Using where

Before: 0.04797s | After: 0.04882s | Elapsed: 0.00085s

Query #16
SELECT * FROM nouncb1_profile_fields_data WHERE user_id = 2

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

Before: 0.04925s | After: 0.04944s | Elapsed: 0.00019s

Query #17
SELECT session_user_id, MAX(session_time) as online_time, MIN(session_viewonline) AS viewonline FROM nouncb1_sessions WHERE session_user_id = 2 GROUP BY session_user_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_sessions	ref	session_user_id	session_user_id	4	const	1

Before: 0.04992s | After: 0.05015s | Elapsed: 0.00023s

Query #18
SELECT a.user_id, a.forum_id, a.auth_setting, a.auth_option_id, ao.auth_option FROM nouncb1_acl_users a, nouncb1_acl_options ao WHERE a.auth_role_id = 0 AND a.auth_option_id = ao.auth_option_id AND a.user_id = 2 AND ao.auth_option = 'u_readpm'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	ao	const	PRIMARY,auth_option	auth_option	152	const	1	Using index
1	SIMPLE	a	ref	user_id,auth_option_id,auth_role_id	auth_option_id	3	const	1	Using where

Before: 0.05067s | After: 0.05096s | Elapsed: 0.00029s

Query #19
SELECT a.user_id, a.forum_id, r.auth_option_id, r.auth_setting, r.auth_option_id, ao.auth_option FROM nouncb1_acl_users a, nouncb1_acl_roles_data r, nouncb1_acl_options ao WHERE a.auth_role_id = r.role_id AND r.auth_option_id = ao.auth_option_id AND a.user_id = 2 AND ao.auth_option = 'u_readpm'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	ao	const	PRIMARY,auth_option	auth_option	152	const	1	Using index
1	SIMPLE	r	ref	PRIMARY,ath_op_id	ath_op_id	3	const	5
1	SIMPLE	a	ref	user_id,auth_role_id	auth_role_id	3	nounites_nouncb1.r.role_id	29	Using where

Before: 0.05134s | After: 0.05164s | Elapsed: 0.00029s

Query #20

SELECT ug.user_id, a.forum_id, a.auth_setting, a.auth_option_id, ao.auth_option FROM nouncb1_acl_groups a, nouncb1_user_group ug, nouncb1_groups g, nouncb1_acl_options ao WHERE a.auth_role_id = 0 AND a.auth_option_id = ao.auth_option_id AND a.group_id = ug.group_id AND g.group_id = ug.group_id AND ug.user_pending = 0 AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1) AND ug.user_id = 2 AND ao.auth_option = 'u_readpm'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	ao	const	PRIMARY,auth_option	auth_option	152	const	1	Using index
1	SIMPLE	a	ref	group_id,auth_opt_id,auth_role_id	auth_opt_id	3	const	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	3	nounites_nouncb1.a.group_id	1
1	SIMPLE	ug	ref	group_id,user_id,group_leader	user_id	4	const	3	Using where

Before: 0.05217s | After: 0.05250s | Elapsed: 0.00033s

Query #21

SELECT ug.user_id, a.forum_id, r.auth_setting, r.auth_option_id, ao.auth_option FROM nouncb1_acl_groups a, nouncb1_user_group ug, nouncb1_groups g, nouncb1_acl_roles_data r, nouncb1_acl_options ao WHERE a.auth_role_id = r.role_id AND r.auth_option_id = ao.auth_option_id AND a.group_id = ug.group_id AND g.group_id = ug.group_id AND ug.user_pending = 0 AND NOT (ug.group_leader = 1 AND g.group_skip_auth = 1) AND ug.user_id = 2 AND ao.auth_option = 'u_readpm'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	ao	const	PRIMARY,auth_option	auth_option	152	const	1	Using index
1	SIMPLE	ug	ref	group_id,user_id,group_leader	user_id	4	const	3	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	3	nounites_nouncb1.ug.group_id	1	Using where
1	SIMPLE	a	ref	group_id,auth_role_id	group_id	3	nounites_nouncb1.ug.group_id	14
1	SIMPLE	r	eq_ref	PRIMARY,ath_op_id	PRIMARY	6	nounites_nouncb1.a.auth_role_id,const	1

Before: 0.05321s | After: 0.05391s | Elapsed: 0.00070s

Query #22
SELECT ban_userid FROM nouncb1_banlist WHERE ban_userid = 2 AND ban_exclude <> 1 AND ban_end = 0

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_banlist	range	ban_end,ban_user	ban_user	5		2	Using index condition; Using where

Before: 0.05440s | After: 0.05462s | Elapsed: 0.00022s

Query #23
UPDATE nouncb1_topics SET topic_views = topic_views + 1, topic_last_view_time = 1695819352 WHERE topic_id = 5236

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_topics	const	PRIMARY	PRIMARY	4	const	1

Affected rows: 1 | Before: 0.05830s | After: 0.05897s | Elapsed: 0.00067s

Query #24
SELECT * FROM nouncb1_config_text WHERE config_name = 'google_adsense_html'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.05998s | After: 0.06027s | Elapsed: 0.00028s

Query #25
SELECT COUNT(DISTINCT s.session_ip) as num_guests FROM nouncb1_sessions s WHERE s.session_user_id = 1 AND s.session_time >= 1695819000 AND s.session_forum_id = 14

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ref|filter	session_time,session_user_id,session_fid	session_fid|session_time	3|4	const	83 (10%)	Using where; Using rowid filter

Before: 0.06097s | After: 0.06153s | Elapsed: 0.00056s

Query #26
SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM nouncb1_sessions s WHERE s.session_time >= 1695819030 AND s.session_forum_id = 14 AND s.session_user_id <> 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ref|filter	session_time,session_user_id,session_fid	session_fid|session_user_id	3|4	const	83 (0%)	Using where; Using rowid filter

Before: 0.06190s | After: 0.06218s | Elapsed: 0.00028s

Query #27
SELECT u.username, u.username_clean, u.user_id, u.user_type, u.user_allow_viewonline, u.user_colour FROM (nouncb1_users u) WHERE u.user_id = 14 ORDER BY u.username_clean ASC

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1

Before: 0.06262s | After: 0.06283s | Elapsed: 0.00021s

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

Before: 0.06347s | After: 0.06368s | Elapsed [cache]: 0.00021s | Elapsed [db]: 0.00022s

Query results obtained from the cache
SELECT group_id FROM nouncb1_user_group WHERE user_id = 1 AND user_pending = 0

Before: 0.06638s | After: 0.06658s | Elapsed [cache]: 0.00020s | Elapsed [db]: 0.00025s

Query #30
SELECT * FROM nouncb1_config_text WHERE config_name = 'phpbb_ads_hide_groups'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.06692s | After: 0.06710s | Elapsed: 0.00019s

Query #31

SELECT location_id, ad_id, ad_code FROM ( SELECT al.location_id, a.ad_id, a.ad_code FROM nouncb1_ad_locations al LEFT JOIN nouncb1_ads a ON (al.ad_id = a.ad_id) WHERE a.ad_enabled = 1 AND (a.ad_end_date = 0 OR a.ad_end_date > 1695819352) AND (a.ad_views_limit = 0 OR a.ad_views_limit > a.ad_views) AND (a.ad_clicks_limit = 0 OR a.ad_clicks_limit > a.ad_clicks) AND al.location_id IN ('above_footer', 'above_header', 'after_first_post', 'after_footer_navbar', 'after_header_navbar', 'after_not_first_post', 'after_posts', 'before_posts', 'below_footer', 'below_header', 'pop_up', 'slide_up') ORDER BY (RAND() * a.ad_priority) DESC ) z ORDER BY z.location_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY		ALL					2	Using filesort
2	DERIVED	a	ref	PRIMARY,ad_enabled	ad_enabled	1	const	1	Using where; Using temporary; Using filesort
2	DERIVED	al	ref	PRIMARY,location_id	PRIMARY	3	nounites_nouncb1.a.ad_id	1	Using where; Using index

Before: 0.06783s | After: 0.06872s | Elapsed: 0.00089s

Query #32
SELECT * FROM nouncb1_config_text WHERE config_name = 'adblock_warn_text'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.06977s | After: 0.07006s | Elapsed: 0.00029s

Query #33
SELECT * FROM nouncb1_config_text WHERE config_name = 'adblock_ad_text'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.07036s | After: 0.07054s | Elapsed: 0.00018s

Query #34
SELECT * FROM nouncb1_config_text WHERE config_name = 'noscript_warn_text'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.07104s | After: 0.07132s | Elapsed: 0.00029s

Query #35
SELECT * FROM nouncb1_config_text WHERE config_name = 'header_ad_text'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.07169s | After: 0.07202s | Elapsed: 0.00033s

Query #36
SELECT * FROM nouncb1_config_text WHERE config_name = 'footer_ad_text'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.07236s | After: 0.07260s | Elapsed: 0.00024s

Query #37
SELECT * FROM nouncb1_config_text WHERE config_name = 'topicfirst_ad_text'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.07299s | After: 0.07319s | Elapsed: 0.00020s

Query #38
SELECT * FROM nouncb1_config_text WHERE config_name = 'topicmid_ad_text'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.07353s | After: 0.07384s | Elapsed: 0.00031s

Query #39
SELECT * FROM nouncb1_config_text WHERE config_name = 'topiclast_ad_text'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.07419s | After: 0.07439s | Elapsed: 0.00020s

Query #40
SELECT * FROM nouncb1_config_text WHERE config_name = 'search_ad_text'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.07467s | After: 0.07490s | Elapsed: 0.00024s

Query #41
SELECT * FROM nouncb1_config_text WHERE config_name = 'total_topic_block_text'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.07524s | After: 0.07541s | Elapsed: 0.00017s

Query #42
SELECT * FROM nouncb1_config_text WHERE config_name = 'adsense_page_level_text'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	nouncb1_config_text	const	PRIMARY	PRIMARY	767	const	1

Before: 0.07570s | After: 0.07591s | Elapsed: 0.00022s