SQL Report

Page generated in 0.1029 seconds with 16 queries + 2 queries returning data from cache

Time spent on mysqli queries: 0.01404s | Time spent on PHP: 0.08884s

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.02700s | After: 0.02785s | Elapsed: 0.00086s

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.04471s | After: 0.04579s | Elapsed: 0.00108s

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.04659s | After: 0.04734s | Elapsed: 0.00075s

Query #4
UPDATE ewaa_users SET user_lastvisit = 1737752467, user_last_active = 1737752508 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.04811s | After: 0.04889s | Elapsed: 0.00078s

Query #5
SELECT f.* FROM (ewaa_forums f) WHERE f.forum_id = 46

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	f	const	PRIMARY	PRIMARY	3	const	1

Before: 0.05029s | After: 0.05115s | Elapsed: 0.00087s

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

Before: 0.05945s | After: 0.05951s | Elapsed [cache]: 0.00005s | Elapsed [db]: 0.00070s

Query #7
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.07245s | After: 0.07321s | Elapsed: 0.00076s

Query #8
UPDATE ewaa_sessions SET session_time = 1737752508, session_page = 'viewforum.php?explain=1&f=46', session_forum_id = 46 WHERE session_id = 'bd7181283dc238f68cb54a17fbd4dcd4'

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.07406s | After: 0.07484s | Elapsed: 0.00078s

Query #9
SELECT COUNT(DISTINCT s.session_ip) as num_guests FROM ewaa_sessions s WHERE s.session_user_id = 1 AND s.session_time >= 1737751860 AND s.session_forum_id = 46

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

Before: 0.07589s | After: 0.07664s | Elapsed: 0.00075s

Query #10
SELECT s.session_user_id, s.session_ip, s.session_viewonline FROM ewaa_sessions s WHERE s.session_time >= 1737751890 AND s.session_forum_id = 46 AND s.session_user_id <> 1

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

Before: 0.07740s | After: 0.07813s | Elapsed: 0.00073s

Query #11
SELECT u.username, u.username_clean, u.user_id, u.user_type, u.user_allow_viewonline, u.user_colour FROM (ewaa_users u) WHERE u.user_id = 784 ORDER BY u.username_clean ASC

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

Before: 0.07888s | After: 0.07959s | Elapsed: 0.00071s

Query #12
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 > 1737752508) 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.08413s | After: 0.08501s | Elapsed: 0.00088s

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.08597s | After: 0.08604s | Elapsed [cache]: 0.00007s | Elapsed [db]: 0.00095s

Query #14
SELECT * FROM ewaa_config_text WHERE config_name = 'reparser_resume'

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

Before: 0.08825s | After: 0.08896s | Elapsed: 0.00071s

Query #15

SELECT t.*, f.forum_name FROM (ewaa_topics t) LEFT JOIN ewaa_forums f ON (f.forum_id = t.forum_id) WHERE (t.forum_id = 46 AND t.topic_type = 2) OR (t.forum_id IN (3, 4, 5, 9, 10, 11, 12, 13, 14, 15, 21, 24, 25, 28, 30, 32, 33, 34, 35, 36, 38, 39, 40, 41, 42, 45, 46, 47, 48, 49, 51, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 72, 73, 78, 85, 86, 87, 89, 94, 95, 98, 102, 105) AND t.topic_type = 3) ORDER BY t.topic_type DESC, t.topic_last_post_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	forum_id_type	4		56	Using index condition; Using filesort
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	3	db0rm_caforum.t.forum_id	1

Before: 0.09328s | After: 0.09491s | Elapsed: 0.00163s

Query #16
SELECT t.topic_id FROM (ewaa_topics t) WHERE t.forum_id = 46 AND t.topic_type IN (0, 1) AND (1 = 1) ORDER BY t.topic_type DESC, t.topic_last_post_time DESC, t.topic_last_post_id DESC LIMIT 15

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,forum_vis_last,latest_topics	forum_id_type	3	const	150	Using index condition; Using where; Using filesort

Before: 0.09588s | After: 0.09688s | Elapsed: 0.00100s

Query #17
SELECT t.* FROM (ewaa_topics t) WHERE t.topic_id IN (1898, 1893, 1892, 1891, 1522, 329, 409, 1870, 1831, 1832, 406, 1413, 1834, 1890, 777)

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	range	PRIMARY	PRIMARY	4		15	Using where

Before: 0.09765s | After: 0.09864s | Elapsed: 0.00098s

Query #18
SELECT u.user_id, u.username, u.user_colour FROM ewaa_users u LEFT JOIN ewaa_topics t ON (u.user_id = t.topic_attr_user) WHERE t.topic_id IN (1898, 1893, 1892, 1891, 1522, 329, 409, 1870, 1831, 1832, 406, 1413, 1834, 1890, 777) AND t.topic_attr_user <> 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	t	range	PRIMARY	PRIMARY	4		15	Using where
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	db0rm_caforum.t.topic_attr_user	1	Using where

Before: 0.10035s | After: 0.10114s | Elapsed: 0.00079s