SQL Report

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

Time spent on mysqli queries: 0.01174s | Time spent on PHP: 0.06151s

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.00506s | After: 0.00516s | Elapsed: 0.00010s

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.01073s | After: 0.01104s | Elapsed: 0.00031s

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.01137s | After: 0.01179s | Elapsed [cache]: 0.00042s | Elapsed [db]: 0.00020s

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, 1755052016, 1755052016, 1755052016, 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '216.73.216.0', 0, 0, 1, 'index.php?explain=1', 0, 'f1c8d4aa17fe75dafb753fb47bc25fae')

Before: 0.01246s | After: 0.01316s | Elapsed: 0.00070s

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

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

Before: 0.01344s | After: 0.01481s | Elapsed: 0.00137s

Query #6
UPDATE bb_users SET user_last_active = 1755052016 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.01503s | After: 0.01557s | Elapsed: 0.00054s

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

Before: 0.01778s | After: 0.01804s | Elapsed [cache]: 0.00026s | Elapsed [db]: 0.00008s

Query #8
SELECT f.* FROM (bb_forums f) ORDER BY f.left_id

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

Before: 0.04113s | After: 0.04128s | Elapsed: 0.00014s

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.04239s | After: 0.04265s | Elapsed [cache]: 0.00026s | Elapsed [db]: 0.00028s

Query #10
SELECT g.group_id, g.group_name, g.group_colour, g.group_type, g.group_legend FROM bb_groups g LEFT JOIN bb_user_group ug ON ( g.group_id = ug.group_id AND ug.user_id = 1 AND ug.user_pending = 0 ) WHERE g.group_legend > 0 AND (g.group_type <> 2 OR ug.user_id = 1) ORDER BY g.group_legend ASC

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	g	range	group_legend_name,idx_groups_legend_type	idx_groups_legend_type	3		1	Using index condition
1	SIMPLE	ug	ref	group_id,user_id,idx_usergroup_user_pending	idx_usergroup_user_pending	8	const,orthohin_minorhockeytalks.g.group_id,const	1	Using where; Using index

Before: 0.04803s | After: 0.04811s | Elapsed: 0.00008s

Query #11
SELECT forum_id FROM bb_forums WHERE 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 forum_recent_topics = 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	bb_forums	ALL	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				41	Using where

Before: 0.04939s | After: 0.04947s | Elapsed: 0.00007s

Query #12

SELECT COUNT(t.topic_id) as topic_count FROM (bb_topics t) LEFT JOIN bb_topics_track tt ON (tt.topic_id = t.topic_id AND tt.user_id = 1) LEFT JOIN bb_forums_track ft ON (ft.forum_id = t.forum_id AND ft.user_id = 1) LEFT JOIN bb_topics_posted tp ON (tp.topic_id = t.topic_id AND tp.user_id = 1) WHERE t.topic_id <> '0' AND t.topic_status <> 2 AND ((1=0 OR (t.topic_visibility = 1 AND 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'))))

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	ALL	PRIMARY,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_topic_id,idx_bb_topics_forum_id,idx_topics_forum_id,idx_topics_topic_id,idx_topics_forum_lastpost,idx_topics_forum,idx_topics_moved_time,idx_topics_topic_id_topic_attachment,idx_bb_topics_topic_id_last_post_time_moved_id_forum_id,bb_topics_forum_id_topic_id				5558	Using where

Before: 0.05135s | After: 0.05517s | Elapsed: 0.00382s

Query #13

SELECT t.forum_id, t.topic_id, t.topic_type, t.icon_id, tp.topic_posted, tt.mark_time, ft.mark_time as f_mark_time, t.topic_last_post_time as sortcr FROM (bb_topics t) LEFT JOIN bb_topics_track tt ON (tt.topic_id = t.topic_id AND tt.user_id = 1) LEFT JOIN bb_forums_track ft ON (ft.forum_id = t.forum_id AND ft.user_id = 1) LEFT JOIN bb_topics_posted tp ON (tp.topic_id = t.topic_id AND tp.user_id = 1) WHERE t.topic_id <> '0' AND t.topic_status <> 2 AND ((1=0 OR (t.topic_visibility = 1 AND 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')))) ORDER BY t.topic_last_post_time DESC LIMIT 100

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	index	PRIMARY,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_topic_id,idx_bb_topics_forum_id,idx_topics_forum_id,idx_topics_topic_id,idx_topics_forum_lastpost,idx_topics_forum,idx_topics_moved_time,idx_topics_topic_id_topic_attachment,idx_bb_topics_topic_id_last_post_time_moved_id_forum_id,bb_topics_forum_id_topic_id	last_post_time	4		100	Using where
1	SIMPLE	tt	eq_ref	PRIMARY,topic_id,idx_topics_track,bb_topics_track_user_id_topic_id	PRIMARY	8	const,orthohin_minorhockeytalks.t.topic_id	1
1	SIMPLE	ft	eq_ref	PRIMARY,idx_forums_track,bb_forums_track_user_id_forum_id	PRIMARY	7	const,orthohin_minorhockeytalks.t.forum_id	1
1	SIMPLE	tp	eq_ref	PRIMARY,bb_topics_posted_user_id_topic_id	PRIMARY	8	const,orthohin_minorhockeytalks.t.topic_id	1

Before: 0.05759s | After: 0.06026s | Elapsed: 0.00268s

Query #14
SELECT t.*, f.forum_name, tp.topic_posted, f.parent_id, f.forum_parents, f.left_id, f.right_id FROM (bb_topics t) LEFT JOIN bb_forums f ON (f.forum_id = t.forum_id) LEFT JOIN bb_topics_posted tp ON (tp.topic_id = t.topic_id AND tp.user_id = 1) WHERE t.topic_id IN ('5227', '5771', '5208', '1130', '5276', '159', '8938', '154', '38', '5731') ORDER BY t.topic_last_post_time DESC LIMIT 10

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		10	Using index condition; 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
1	SIMPLE	tp	eq_ref	PRIMARY,bb_topics_posted_user_id_topic_id	PRIMARY	8	const,orthohin_minorhockeytalks.t.topic_id	1

Before: 0.06140s | After: 0.06191s | Elapsed: 0.00051s

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.06577s | After: 0.06603s | Elapsed [cache]: 0.00026s | Elapsed [db]: 0.00009s

Query #16
SELECT COUNT(DISTINCT s.session_ip) as num_guests FROM bb_sessions s WHERE s.session_user_id = 1 AND s.session_time >= 1755051660

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

Before: 0.06700s | After: 0.06756s | Elapsed: 0.00056s

Query #17
SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM bb_sessions s WHERE s.session_time >= 1755051690 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_user_id	4		4	Using index condition; Using where

Before: 0.06783s | After: 0.06806s | Elapsed: 0.00023s

Query #18
SELECT u.username, u.username_clean, u.user_id, u.user_type, u.user_allow_viewonline, u.user_colour FROM (bb_users u) WHERE u.user_id IN (4, 20) ORDER BY u.username_clean ASC

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	range	PRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_id	idx_bb_users_user_id	4		2	Using index condition; Using filesort

Before: 0.06837s | After: 0.06859s | Elapsed: 0.00023s

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

Before: 0.06894s | After: 0.06929s | Elapsed [cache]: 0.00034s | Elapsed [db]: 0.00017s

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: 0.07196s | After: 0.07204s | Elapsed: 0.00008s

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: 0.07222s | After: 0.07229s | Elapsed: 0.00007s

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: 0.07244s | After: 0.07251s | Elapsed: 0.00007s

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: 0.07270s | After: 0.07280s | Elapsed: 0.00010s

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: 0.07302s | After: 0.07310s | Elapsed: 0.00008s