SQL Report

Page generated in 0.0345 seconds with 21 queries + 4 queries returning data from cache

Time spent on mysqli queries: 0.00623s | Time spent on PHP: 0.0283s

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.00538s | After: 0.00566s | Elapsed: 0.00028s

Query #2
SELECT u., s. FROM nouncb1_sessions s, nouncb1_users u WHERE s.session_id = 'fe7615c1d4681afc09821029412ef530' 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.01237s | After: 0.01280s | Elapsed: 0.00043s

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.01374s | After: 0.01408s | Elapsed: 0.00034s

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.01444s | After: 0.01459s | Elapsed [cache]: 0.00015s | Elapsed [db]: 0.00028s

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

Affected rows: 0 | Before: 0.01489s | After: 0.01538s | Elapsed: 0.00049s

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, 1701416147, 1701416147, 1701416147, 'CCBot/2.0 (https://commoncrawl.org/faq/)', '', '44.212.94.18', 0, 0, 1, 'ucp.php?explain=1&mode=register', 0, '3b5dc5201b9a79b95f4ba2f7121445eb')

Query #6

Before: 0.01553s | After: 0.01609s | Elapsed: 0.00056s

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

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

Before: 0.01655s | After: 0.01779s | Elapsed: 0.00124s

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

Before: 0.02160s | After: 0.02170s | Elapsed [cache]: 0.00010s | Elapsed [db]: 0.00019s

Query #9
SELECT lang_id FROM nouncb1_lang

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

Before: 0.02342s | After: 0.02359s | Elapsed: 0.00017s

Query #10
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.02405s | After: 0.02421s | Elapsed: 0.00016s

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

Before: 0.02454s | After: 0.02467s | Elapsed [cache]: 0.00013s | Elapsed [db]: 0.00017s

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

Before: 0.02825s | After: 0.02836s | Elapsed [cache]: 0.00011s | Elapsed [db]: 0.00022s

Query #13
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.02863s | After: 0.02878s | Elapsed: 0.00015s

Query #14
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 > 1701416147) 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_footer_navbar', 'after_header_navbar', 'below_footer', 'below_header', 'pop_up', 'slide_up') ORDER BY (RAND() * a.ad_priority) DESC ) z ORDER BY z.location_id

Query #14

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.02942s | After: 0.03023s | Elapsed: 0.00080s

Query #15
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.03086s | After: 0.03103s | Elapsed: 0.00018s

Query #16
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.03125s | After: 0.03144s | Elapsed: 0.00020s

Query #17
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.03165s | After: 0.03179s | Elapsed: 0.00014s

Query #18
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.03198s | After: 0.03211s | Elapsed: 0.00013s

Query #19
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.03230s | After: 0.03243s | Elapsed: 0.00013s

Query #20
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.03261s | After: 0.03273s | Elapsed: 0.00013s

Query #21
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.03291s | After: 0.03309s | Elapsed: 0.00018s

Query #22
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.03328s | After: 0.03340s | Elapsed: 0.00013s

Query #23
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.03357s | After: 0.03370s | Elapsed: 0.00013s

Query #24
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.03387s | After: 0.03400s | Elapsed: 0.00013s

Query #25
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.03417s | After: 0.03431s | Elapsed: 0.00014s