SQL Report

Page generated in 0.0711 seconds with 15 queries + 6 queries returning data from cache

Time spent on mysqli queries: 0.00367s | Time spent on PHP: 0.06741s

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

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

Before: 0.02140s | After: 0.02160s | Elapsed: 0.00020s

Query #2
SELECT u.*, s.* FROM bb_sessions s, bb_users u WHERE s.session_id = '50c9d09e2b05b88d2459564fbd076a84' AND u.user_id = s.session_user_id

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	s		const	PRIMARY,session_user_id	PRIMARY	96	const	1	100.00
1	SIMPLE	u		const	PRIMARY,idx_bb_users_user_id,idx_users_user_id,idx_user_id,bb_users_user_id	PRIMARY	4	const	1	100.00

Before: 0.04002s | After: 0.04021s | Elapsed: 0.00019s

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.04117s | After: 0.04131s | Elapsed [cache]: 0.00014s | Elapsed [db]: 0.00042s

Query #4
SELECT f.* FROM (bb_forums f) WHERE f.forum_id = 82

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	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	100.00

Before: 0.04361s | After: 0.04376s | Elapsed: 0.00015s

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

Before: 0.04523s | After: 0.04529s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00017s

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.04910s | After: 0.04915s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00021s

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.05438s | After: 0.05444s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00019s

Query #8
UPDATE bb_sessions SET session_time = 1749987358, session_page = 'viewforum.php/forum82.html?explain=1&f=82', session_forum_id = 82 WHERE session_id = '50c9d09e2b05b88d2459564fbd076a84'

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	bb_sessions		const	PRIMARY	PRIMARY	96	const	1	100.00

Affected rows: 1 | Before: 0.05485s | After: 0.05516s | Elapsed: 0.00031s

Query #9
SELECT COUNT(DISTINCT s.session_ip) as num_guests FROM bb_sessions s WHERE s.session_user_id = 1 AND s.session_time >= 1749987000 AND s.session_forum_id = 82

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

Before: 0.05552s | After: 0.05571s | Elapsed: 0.00019s

Query #10
SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM bb_sessions s WHERE s.session_time >= 1749987030 AND s.session_forum_id = 82 AND s.session_user_id <> 1

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

Before: 0.05590s | After: 0.05603s | Elapsed: 0.00013s

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

Before: 0.05656s | After: 0.05661s | Elapsed [cache]: 0.00004s | Elapsed [db]: 0.00011s

Query #12
SELECT * FROM bb_menu_colors

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

Before: 0.05864s | After: 0.05873s | Elapsed: 0.00010s

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

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

Before: 0.05888s | After: 0.05898s | Elapsed: 0.00010s

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

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

Before: 0.05913s | After: 0.05922s | Elapsed: 0.00009s

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

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

Before: 0.05941s | After: 0.05952s | Elapsed: 0.00010s

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

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

Before: 0.05966s | After: 0.05976s | Elapsed: 0.00010s

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: 0.05999s | After: 0.06005s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00018s

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

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

Before: 0.06237s | After: 0.06245s | Elapsed: 0.00008s

Query #19
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 = 82 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	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	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	100.00	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	xuya89hi_phpbb_minorhockeytalks.t.forum_id	1	100.00

Before: 0.06521s | After: 0.06635s | Elapsed: 0.00114s

Query #20
SELECT t.topic_id FROM (bb_topics t) WHERE t.forum_id = 82 AND t.topic_type IN (0, 1) AND ((t.topic_visibility = 1)) ORDER BY t.topic_type DESC, t.topic_last_post_time DESC, t.topic_last_post_id DESC LIMIT 25

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	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	3	const	55	100.00	Using where; Using filesort

Before: 0.06665s | After: 0.06697s | Elapsed: 0.00032s

Query #21
SELECT t.* FROM (bb_topics t) WHERE t.topic_id IN (3255, 5888, 5887, 5886, 5885, 5884, 5883, 5882, 5881, 5880, 5879, 5878, 5877, 5876, 5875, 5874, 5873, 5872, 5871, 5870, 5869, 5868, 5867, 5866, 5865)

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	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	PRIMARY	4		25	100.00	Using where

Before: 0.06755s | After: 0.06801s | Elapsed: 0.00047s