SQL Report

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

Time spent on mysqli queries: 0.01235s | Time spent on PHP: 0.03477s

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.00366s | After: 0.00402s | Elapsed: 0.00036s

Query #2
SELECT u.*, s.* FROM nouncb1_sessions s, nouncb1_users u WHERE s.session_id = '8557150278f4c305725e548747b85b02' 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.00811s | After: 0.00855s | Elapsed: 0.00045s

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.00932s | After: 0.00961s | Elapsed: 0.00030s

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.01003s | After: 0.01019s | Elapsed [cache]: 0.00016s | Elapsed [db]: 0.00036s

Query #5
DELETE FROM nouncb1_sessions WHERE session_id = '8557150278f4c305725e548747b85b02' AND session_user_id = 1

Affected rows: 0 | Before: 0.01045s | After: 0.01076s | Elapsed: 0.00030s

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, 1695816948, 1695816948, 1695816948, 'CCBot/2.0 (https://commoncrawl.org/faq/)', '', '3.235.188.113', 0, 0, 1, 'viewtopic.php?explain=1&f=14&p=7299', 14, 'bcba84afed05a85cdee3e16907ffe7fa')

Before: 0.01090s | After: 0.01149s | Elapsed: 0.00059s

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

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

Before: 0.01191s | After: 0.01319s | Elapsed: 0.00129s

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.01431s | After: 0.01494s | Elapsed: 0.00063s

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

Before: 0.01706s | After: 0.01719s | Elapsed [cache]: 0.00012s | Elapsed [db]: 0.00020s

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.01953s | After: 0.01970s | Elapsed: 0.00017s

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.02033s | After: 0.02050s | Elapsed: 0.00017s

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.02189s | After: 0.02215s | Elapsed: 0.00026s

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.02267s | After: 0.02308s | Elapsed: 0.00041s

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.02479s | After: 0.02500s | Elapsed: 0.00020s

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.02542s | After: 0.02624s | Elapsed: 0.00082s

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.02662s | After: 0.02678s | Elapsed: 0.00017s

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.02717s | After: 0.02738s | Elapsed: 0.00021s

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.02775s | After: 0.02803s | Elapsed: 0.00028s

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.02846s | After: 0.02872s | Elapsed: 0.00025s

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.02916s | After: 0.02947s | Elapsed: 0.00031s

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.02988s | After: 0.03035s | Elapsed: 0.00047s

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.03067s | After: 0.03086s | Elapsed: 0.00020s

Query #23
UPDATE nouncb1_topics SET topic_views = topic_views + 1, topic_last_view_time = 1695816948 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.03424s | After: 0.03481s | Elapsed: 0.00057s

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.03523s | After: 0.03542s | Elapsed: 0.00018s

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 >= 1695816600 AND s.session_forum_id = 14

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ref	session_time,session_user_id,session_fid	session_fid	3	const	111	Using where

Before: 0.03587s | After: 0.03649s | Elapsed: 0.00063s

Query #26
SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM nouncb1_sessions s WHERE s.session_time >= 1695816630 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	111 (0%)	Using where; Using rowid filter

Before: 0.03679s | After: 0.03706s | Elapsed: 0.00027s

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 = 17 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.03744s | After: 0.03762s | Elapsed: 0.00018s

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

Before: 0.03815s | After: 0.03832s | Elapsed [cache]: 0.00017s | Elapsed [db]: 0.00018s

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

Before: 0.04029s | After: 0.04043s | Elapsed [cache]: 0.00013s | Elapsed [db]: 0.00020s

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.04075s | After: 0.04096s | Elapsed: 0.00021s

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 > 1695816948) 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.04165s | After: 0.04250s | Elapsed: 0.00085s

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.04322s | After: 0.04339s | Elapsed: 0.00017s

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.04362s | After: 0.04376s | Elapsed: 0.00014s

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.04397s | After: 0.04411s | Elapsed: 0.00014s

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.04429s | After: 0.04443s | Elapsed: 0.00013s

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.04462s | After: 0.04475s | Elapsed: 0.00013s

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.04495s | After: 0.04512s | Elapsed: 0.00017s

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.04531s | After: 0.04546s | Elapsed: 0.00015s

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.04565s | After: 0.04579s | Elapsed: 0.00013s

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.04599s | After: 0.04613s | Elapsed: 0.00014s

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.04631s | After: 0.04650s | Elapsed: 0.00019s

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.04669s | After: 0.04683s | Elapsed: 0.00013s