SQL Report

Page generated in 1.118 seconds with 12 queries + 5 queries returning data from cache

Time spent on mysqli queries: 0.91551s | Time spent on PHP: 0.20248s

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.04242s | After: 0.04323s | Elapsed: 0.00081s

Query #2
SELECT u.*, s.* FROM bb_sessions s, bb_users u WHERE s.session_id = 'd8d1874bf80cf5431237ea1b8647f391' 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.07395s | After: 0.07643s | Elapsed: 0.00248s

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.08122s | After: 0.08138s | Elapsed [cache]: 0.00016s | Elapsed [db]: 0.00046s

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

Before: 0.09609s | After: 0.09614s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00257s

Query #5
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	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	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	100.00	Using where; Using index

Before: 0.10740s | After: 0.10789s | Elapsed: 0.00049s

Query #6
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 = 'd8d1874bf80cf5431237ea1b8647f391') ORDER BY f.left_id

Id	Select Type	Table	Partitions	Type	Possible Keys	Key	Key Len	Ref	Rows	Filtered	Extra
1	SIMPLE	f		ALL					41	100.00	Using filesort
1	SIMPLE	fa		ref	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	99	const,xuya89hi_phpbb_minorhockeytalks.f.forum_id	1	100.00	Using index

Before: 0.10817s | After: 0.10839s | Elapsed: 0.00021s

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

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

Before: 0.11752s | After: 0.11848s | Elapsed: 0.00096s

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

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

Before: 0.12322s | After: 1.01416s | Elapsed: 0.89094s

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: 1.05131s | After: 1.05137s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00871s

Query #10
UPDATE bb_sessions SET session_time = 1749988236, session_page = 'search.php?author_id=475&explain=1&sr=posts', session_forum_id = 0 WHERE session_id = 'd8d1874bf80cf5431237ea1b8647f391'

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: 1.06247s | After: 1.07583s | Elapsed: 0.01336s

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

Before: 1.08665s | After: 1.08671s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00675s

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: 1.11034s | After: 1.11322s | Elapsed: 0.00288s

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: 1.11344s | After: 1.11656s | Elapsed: 0.00311s

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: 1.11681s | After: 1.11690s | Elapsed: 0.00010s

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: 1.11702s | After: 1.11711s | Elapsed: 0.00009s

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: 1.11723s | After: 1.11731s | Elapsed: 0.00008s

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: 1.11754s | After: 1.11761s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00668s