SQL Report

Page generated in 20.4959 seconds with 20 queries + 5 queries returning data from cache

Time spent on mysqli queries: 20.44536s | Time spent on PHP: 0.0505s

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

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

Before: 0.00434s | After: 0.00439s | Elapsed: 0.00005s

Query #2
SELECT * FROM bb_users WHERE user_id = 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_users	const	PRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_id	PRIMARY	4	const	1

Before: 0.00805s | After: 0.00814s | Elapsed: 0.00009s

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

Before: 0.00836s | After: 0.00882s | Elapsed [cache]: 0.00045s | Elapsed [db]: 0.00014s

Query #4
INSERT INTO bb_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, 1753242545, 1753242545, 1753242545, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '216.73.216.174', 0, 0, 1, 'search.php?author_id=60&explain=1&sr=posts', 0, 'c3e40bdebe526d2eb15b42f5f5807c92')

Query #4

Before: 0.01103s | After: 0.01173s | Elapsed: 0.00071s

Query #5
SELECT COUNT(session_id) AS sessions FROM bb_sessions WHERE session_user_id = 1 AND session_time >= 1753235345

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

Before: 0.01197s | After: 0.01233s | Elapsed: 0.00036s

Query #6
UPDATE bb_users SET user_last_active = 1753242545 WHERE user_id = 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_users	const	PRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_id	PRIMARY	4	const	1

Affected rows: 1 | Before: 0.01253s | After: 0.01267s | Elapsed: 0.00014s

Query results obtained from the cache
SELECT * FROM bb_styles WHERE style_id = 1

Before: 0.01437s | After: 0.01456s | Elapsed [cache]: 0.00020s | Elapsed [db]: 0.00004s

Query #8
SELECT forum_id FROM bb_forums WHERE forum_id NOT IN (0, 3, 4, 5, 6, 8, 25, 26, 27, 28, 29, 44, 45, 46, 47, 53, 54, 55, 56, 58, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84)

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_forums	index	PRIMARY,idx_bb_forums_forum_id,idx_bb_forums_forum_id_password_flags_type,idx_bb_forums_forum_id_password,idx_bb_forums_forum_id_type,bb_forums_forum_id	idx_bb_forums_forum_id	3		41	Using where; Using index

Before: 0.03426s | After: 0.03430s | Elapsed: 0.00004s

Query #9
SELECT f.forum_id, f.forum_name, f.parent_id, f.forum_type, f.right_id, f.forum_password, f.forum_flags, fa.user_id FROM bb_forums f LEFT JOIN bb_forums_access fa ON (fa.forum_id = f.forum_id AND fa.session_id = 'c3e40bdebe526d2eb15b42f5f5807c92') ORDER BY f.left_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	f	ALL					41	Using temporary; Using filesort
1	SIMPLE	fa	range	PRIMARY,idx_bb_forums_access_forum_id_session_id,idx_bb_forums_access_session_id_forum_id	idx_bb_forums_access_session_id_forum_id	96		1	Using where; Using index; Using join buffer (flat, BNL join)

Before: 0.03467s | After: 0.03493s | Elapsed: 0.00026s

Query #10
SELECT p.post_id, p.post_time FROM bb_posts p WHERE p.poster_id = 60 AND ((1=1 AND p.post_visibility = 1)) ORDER BY p.post_time DESC LIMIT 250

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	ref	poster_id,post_visibility,idx_poster_id,bb_posts_poster_id	poster_id	4	const	3	Using where; Using filesort

Before: 0.03558s | After: 20.46278s | Elapsed: 20.42719s

Query #11
SELECT COUNT(*) as result_count FROM bb_posts p WHERE p.poster_id = 60 AND ((1=1 AND p.post_visibility = 1)) ORDER BY p.post_time DESC

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	ref	poster_id,post_visibility,idx_poster_id,bb_posts_poster_id	poster_id	4	const	3	Using where

Before: 20.46338s | After: 20.46377s | Elapsed: 0.00039s

Query #12
SELECT search_time FROM bb_search_results WHERE search_key = 'de49a1945dd0caf18b2f414eac6b09b2'

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

Before: 20.46418s | After: 20.46432s | Elapsed: 0.00014s

Query #13
INSERT INTO bb_search_results (search_key, search_time, search_keywords, search_authors) VALUES ('de49a1945dd0caf18b2f414eac6b09b2', 1753242566, '', ' 60 ')

Before: 20.46436s | After: 20.46493s | Elapsed: 0.00057s

Query #14
UPDATE bb_users SET user_last_search = 1753242566 WHERE user_id = 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_users	const	PRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_id	PRIMARY	4	const	1

Affected rows: 1 | Before: 20.46528s | After: 20.47939s | Elapsed: 0.01411s

Query #15
UPDATE bb_search_results SET search_time = 1753242566 WHERE search_key = 'de49a1945dd0caf18b2f414eac6b09b2'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_search_results	const	PRIMARY	PRIMARY	98	const	1

Affected rows: 1 | Before: 20.48169s | After: 20.48187s | Elapsed: 0.00018s

Query #16
SELECT zebra_id, friend, foe FROM bb_zebra WHERE user_id = 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_zebra	ref	PRIMARY,idx_user_id_zebra_id,bb_zebra_user_id	PRIMARY	4	const	1

Before: 20.48291s | After: 20.48299s | Elapsed: 0.00007s

Query #17
SELECT p., f.forum_id, f.forum_name, t., u.username, u.username_clean, u.user_sig, u.user_sig_bbcode_uid, u.user_colour FROM (bb_posts p) LEFT JOIN bb_topics t ON (p.topic_id = t.topic_id) LEFT JOIN bb_forums f ON (p.forum_id = f.forum_id) LEFT JOIN bb_users u ON (p.poster_id = u.user_id) WHERE p.post_id IN (6044, 6045, 586) AND ((1=1 AND p.post_visibility = 1)) ORDER BY p.post_time DESC

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	range\|filter	PRIMARY,post_visibility,idx_bb_posts_post_id_topic_id_time,idx_posts_post_id,idx_posts_id_topic,idx_posts_post_id_visibility_topic_id	post_visibility\|idx_posts_post_id	5\|4		3 (0%)	Using index condition; Using filesort; Using rowid filter
1	SIMPLE	t	eq_ref	PRIMARY,idx_bb_topics_topic_id,idx_topics_topic_id,idx_topics_forum,idx_topics_topic_id_topic_attachment,idx_bb_topics_topic_id_last_post_time_moved_id_forum_id	PRIMARY	4	orthohin_minorhockeytalks.p.topic_id	1
1	SIMPLE	f	eq_ref	PRIMARY,idx_bb_forums_forum_id,idx_bb_forums_forum_id_password_flags_type,idx_bb_forums_forum_id_password,idx_bb_forums_forum_id_type,bb_forums_forum_id	PRIMARY	3	orthohin_minorhockeytalks.p.forum_id	1
1	SIMPLE	u	eq_ref	PRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_id	PRIMARY	4	orthohin_minorhockeytalks.p.poster_id	1

Before: 20.48429s | After: 20.48498s | Elapsed: 0.00069s

Query results obtained from the cache
SELECT ppl.*, pl.page_link_location, pl.page_link_event_name, p.page_route, p.page_title, p.page_icon_font, p.page_display, p.page_display_to_guests, p.page_description, p.page_description_display FROM (bb_pages_pages_links ppl) LEFT JOIN bb_pages_links pl ON (pl.page_link_id = ppl.page_link_id) LEFT JOIN bb_pages p ON (p.page_id = ppl.page_id) ORDER BY p.page_order ASC, ppl.page_link_id ASC

Before: 20.49054s | After: 20.49082s | Elapsed [cache]: 0.00028s | Elapsed [db]: 0.00008s

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

Before: 20.49152s | After: 20.49174s | Elapsed [cache]: 0.00022s | Elapsed [db]: 0.00007s

Query #20
SELECT * FROM bb_menu_colors

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_menu_colors	ALL					5

Before: 20.49379s | After: 20.49390s | Elapsed: 0.00012s

Query #21
SELECT * FROM bb_menu_buttons 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	bb_menu_buttons	ALL					11	Using where; Using filesort

Before: 20.49412s | After: 20.49418s | Elapsed: 0.00006s

Query #22
SELECT * FROM bb_menu_buttons WHERE button_display = 1 AND parent_id = 21 ORDER BY left_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_menu_buttons	ALL					11	Using where; Using filesort

Before: 20.49438s | After: 20.49445s | Elapsed: 0.00006s

Query #23
SELECT * FROM bb_menu_buttons WHERE button_display = 1 AND parent_id = 7 ORDER BY left_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_menu_buttons	ALL					11	Using where; Using filesort

Before: 20.49460s | After: 20.49465s | Elapsed: 0.00005s

Query #24
SELECT * FROM bb_menu_buttons WHERE button_display = 1 AND parent_id = 13 ORDER BY left_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_menu_buttons	ALL					11	Using where; Using filesort

Before: 20.49481s | After: 20.49487s | Elapsed: 0.00006s

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

Before: 20.49513s | After: 20.49540s | Elapsed [cache]: 0.00028s | Elapsed [db]: 0.00010s