SQL Report

Page generated in 0.0837 seconds with 19 queries + 5 queries returning data from cache

Time spent on mysqli queries: 0.02037s | Time spent on PHP: 0.06331s

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.00445s | After: 0.00453s | Elapsed: 0.00008s

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.00993s | After: 0.01020s | Elapsed: 0.00027s

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.01051s | After: 0.01088s | Elapsed [cache]: 0.00037s | Elapsed [db]: 0.00015s

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, 1752826317, 1752826317, 1752826317, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '216.73.216.169', 0, 0, 1, 'viewforum.php/teams-and-associations-f8-1575.html?explain=1&f=8&start=1575', 8, '3c2b8ad5358a51ed9b6c9f13726b27ae')

Query #4

Before: 0.01141s | After: 0.01739s | Elapsed: 0.00598s

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

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_sessions	range	session_time,session_user_id	session_time	4		1502	Using index condition; Using where

Before: 0.01780s | After: 0.02288s | Elapsed: 0.00507s

Query #6
UPDATE bb_users SET user_last_active = 1752826317 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.02316s | After: 0.02365s | Elapsed: 0.00049s

Query #7
SELECT f.* FROM (bb_forums f) WHERE f.forum_id = 8

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	f	const	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	const	1

Before: 0.02451s | After: 0.02459s | Elapsed: 0.00009s

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

Before: 0.02623s | After: 0.02650s | Elapsed [cache]: 0.00027s | Elapsed [db]: 0.00009s

Query #9
SELECT f.*, fa.user_id FROM (bb_forums f) LEFT JOIN bb_forums_access fa ON (fa.forum_id = f.forum_id AND fa.session_id = '3c2b8ad5358a51ed9b6c9f13726b27ae') WHERE left_id > 22 AND left_id < 45 ORDER BY f.left_id

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	f	ALL	left_right_id				41	Using where; 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.05068s | After: 0.05188s | Elapsed: 0.00119s

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

Before: 0.05270s | After: 0.05295s | Elapsed [cache]: 0.00024s | Elapsed [db]: 0.00033s

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: 0.05773s | After: 0.05795s | Elapsed [cache]: 0.00021s | Elapsed [db]: 0.00011s

Query #12
SELECT COUNT(DISTINCT s.session_ip) as num_guests FROM bb_sessions s WHERE s.session_user_id = 1 AND s.session_time >= 1752825960 AND s.session_forum_id = 8

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	946 (0%)	Using where; Using rowid filter

Before: 0.05890s | After: 0.05970s | Elapsed: 0.00080s

Query #13
SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM bb_sessions s WHERE s.session_time >= 1752825990 AND s.session_forum_id = 8 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_fid	session_user_id	4		5	Using index condition; Using where

Before: 0.05992s | After: 0.06010s | Elapsed: 0.00018s

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

Before: 0.06036s | After: 0.06061s | Elapsed [cache]: 0.00025s | Elapsed [db]: 0.00007s

Query #15
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: 0.06212s | After: 0.06220s | Elapsed: 0.00008s

Query #16
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: 0.06239s | After: 0.06246s | Elapsed: 0.00007s

Query #17
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: 0.06261s | After: 0.06266s | Elapsed: 0.00005s

Query #18
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: 0.06281s | After: 0.06287s | Elapsed: 0.00006s

Query #19
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: 0.06307s | After: 0.06314s | Elapsed: 0.00006s

Query #20
SELECT forum_id, forum_name, parent_id, forum_type, left_id, right_id FROM bb_forums ORDER BY left_id ASC

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_forums	ALL					41	Using filesort

Before: 0.06345s | After: 0.06400s | Elapsed: 0.00055s

Query #21
SELECT * FROM bb_config_text WHERE config_name = 'reparser_resume'

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

Before: 0.06702s | After: 0.06708s | Elapsed: 0.00006s

Query #22
SELECT t.*, f.forum_name FROM (bb_topics t) LEFT JOIN bb_forums f ON (f.forum_id = t.forum_id) WHERE (t.forum_id = 8 AND t.topic_type = 2) OR (t.forum_id IN (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) AND t.topic_type = 3) ORDER BY t.topic_time DESC

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	range	forum_id,forum_id_type,fid_time_moved,forum_vis_last,latest_topics,idx_bb_topics_forum_id_last_post_time_id,idx_bb_topics_forum_id,idx_topics_forum_id,idx_topics_forum_lastpost,idx_topics_moved_time,idx_topics_type_time,bb_topics_forum_id_topic_id	idx_topics_type_time	1		2	Using index condition; Using where; Using filesort
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.t.forum_id	1

Before: 0.07060s | After: 0.07286s | Elapsed: 0.00226s

Query #23
SELECT t.topic_id FROM (bb_topics t) WHERE t.forum_id = 8 AND t.topic_type IN (0, 1) AND ((t.topic_visibility = 1)) ORDER BY t.topic_type ASC, t.topic_last_post_time ASC, t.topic_last_post_id ASC LIMIT 386, 25

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ref	forum_id,forum_id_type,fid_time_moved,topic_visibility,forum_vis_last,latest_topics,idx_bb_topics_forum_id_last_post_time_id,idx_bb_topics_forum_id,idx_topics_forum_id,idx_topics_forum_lastpost,idx_topics_moved_time,idx_topics_type_time,bb_topics_forum_id_topic_id	forum_id_type	3	const	1988	Using index condition; Using where; Using filesort

Before: 0.07322s | After: 0.07577s | Elapsed: 0.00255s

Query #24
SELECT t.* FROM (bb_topics t) WHERE t.topic_id IN (1224, 1225, 1226, 1227, 1228, 1229, 1230, 1231, 1232, 1233, 1234, 1235, 1236, 1237, 1238, 1239, 1240, 1241, 1242, 1243, 1244, 1245, 1246, 1247, 1248)

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	range	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	idx_bb_topics_topic_id	4		25	Using index condition

Before: 0.07630s | After: 0.07677s | Elapsed: 0.00047s