SQL Report

Page generated in 0.0608 seconds with 7 queries + 2 queries returning data from cache

Time spent on mysqli queries: 0.0059s | Time spent on PHP: 0.05488s

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

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

Before: 0.02134s | After: 0.02215s | Elapsed: 0.00082s

Query #2
SELECT u., s. FROM ewaa_users u LEFT JOIN ewaa_sessions s ON (s.session_user_id = u.user_id) WHERE u.user_id = 784

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	s	ref	session_user_id	session_user_id	4	const	1

Before: 0.03464s | After: 0.03576s | Elapsed: 0.00113s

Query #3
SELECT ban_ip, ban_userid, ban_email, ban_exclude, ban_give_reason, ban_end FROM ewaa_banlist WHERE ban_email = '' AND (ban_userid = 784 OR ban_ip <> '')

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	ewaa_banlist	index_merge	ban_user,ban_email,ban_ip	ban_user,ban_ip	4,122		3	Using sort_union(ban_user,ban_ip); Using where

Before: 0.03656s | After: 0.03731s | Elapsed: 0.00074s

Query #4
UPDATE ewaa_users SET user_lastvisit = 1745140974, user_last_active = 1745141010 WHERE user_id = 784

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	ewaa_users	const	PRIMARY	PRIMARY	4	const	1

Affected rows: 1 | Before: 0.03807s | After: 0.03887s | Elapsed: 0.00080s

Query results obtained from the cache
SELECT * FROM ewaa_styles WHERE style_id = 149

Before: 0.04642s | After: 0.04645s | Elapsed [cache]: 0.00003s | Elapsed [db]: 0.00071s

Query #6
SELECT ug.*, u.username, u.username_clean, u.user_email FROM ewaa_user_group ug, ewaa_users u WHERE ug.user_id = u.user_id AND ug.user_pending = 0 AND ug.user_id = 784

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ug	ref	user_id	user_id	4	const	1	Using where

Before: 0.05183s | After: 0.05257s | Elapsed: 0.00074s

Query #7
UPDATE ewaa_sessions SET session_time = 1745141010, session_page = 'install.php?explain=1', session_forum_id = 0 WHERE session_id = '3cca88172ee8f7b4c74bccc17cb85bcb'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	ewaa_sessions	const	PRIMARY	PRIMARY	96	const	1

Affected rows: 1 | Before: 0.05341s | After: 0.05418s | Elapsed: 0.00077s

Query #8
SELECT * FROM ewaa_board_announcements WHERE announcement_id NOT IN(SELECT announcement_id FROM ewaa_board_announcements_track WHERE user_id = 784) AND announcement_enabled = 1 AND (announcement_expiry = 0 OR announcement_expiry > 1745141010) ORDER BY announcement_left_id ASC

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	PRIMARY	ewaa_board_announcements	ALL					1	Using where; Using filesort
2	DEPENDENT SUBQUERY	ewaa_board_announcements_track	ref	announcement_id,user_id	user_id	3	const	1	Using where

Before: 0.05813s | After: 0.05903s | Elapsed: 0.00090s

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

Before: 0.06004s | After: 0.06010s | Elapsed [cache]: 0.00006s | Elapsed [db]: 0.00095s