Sign up for your FREE Carnival Board account to get access to thousands of topics, private forums." Once you sign up you will get IMMEDIATE access to the board. Also, please be sure to check out our other pages listed in the MENU!
SELECT * FROM wowbb_user_groups WHERE user_group_id=1
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
wowbb_user_groups
const
PRIMARY
PRIMARY
2
const
1
NULL
0.0001 seconds
SELECT * FROM wowbb_calendar LEFT JOIN wowbb_users USING (user_id) WHERE event_recurrence = 0 AND event_start < '2010-04-02 23:59' ORDER BY event_start, event_id
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
wowbb_calendar
ref
event_recurrence
event_recurrence
1
const
27
Using where; Using filesort
1
SIMPLE
wowbb_users
eq_ref
PRIMARY
PRIMARY
4
carnytow_wowbb.wowbb_calendar.user_id
1
NULL
0.0019 seconds
SELECT user_id, user_name, user_birthday FROM wowbb_users WHERE SUBSTRING(user_birthday, 6, 5) >= '02-28' AND SUBSTRING(user_birthday, 6, 5) < '04-02' ORDER BY user_birthday, user_name
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
wowbb_users
ALL
NULL
NULL
NULL
NULL
972
Using where; Using filesort
0.0028 seconds
SELECT * FROM wowbb_calendar LEFT JOIN wowbb_users USING (user_id) WHERE event_recurrence=1 ORDER BY event_start, event_id
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
wowbb_calendar
ref
event_recurrence
event_recurrence
1
const
1
Using where; Using filesort
1
SIMPLE
wowbb_users
eq_ref
PRIMARY
PRIMARY
4
carnytow_wowbb.wowbb_calendar.user_id
1
NULL
0.0005 seconds
SELECT * FROM wowbb_emoticons ORDER BY emoticon_id
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
wowbb_emoticons
ALL
NULL
NULL
NULL
NULL
10
Using filesort
0.0001 seconds
SELECT session_id FROM wowbb_sessions WHERE last_visit >= '2010-03-10 19:11:44' AND ip='38.107.191.96'
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
wowbb_sessions
range
last_visit
last_visit
8
NULL
1
Using where
0.0007 seconds
SELECT COUNT(*) AS users_online FROM wowbb_sessions WHERE last_visit >= '2010-03-10 19:11:44'
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
wowbb_sessions
range
last_visit
last_visit
8
NULL
2
Using where; Using index
0.0001 seconds
SELECT log_id, max_online FROM wowbb_visitor_log WHERE log_date='2010-03-10'
