|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 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_visitor_log WHERE log_date < '2010-09-06' ORDER BY log_date | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_visitor_log | ALL | log_date | NULL | NULL | NULL | 510 | Using where; Using filesort |
| 0.0220 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2006-12-01' and '2006-12-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0009 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2006-12-01' and '2006-12-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0006 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2007-01-01' and '2007-01-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2007-01-01' and '2007-01-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-04-01' and '2009-04-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-04-01' and '2009-04-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-05-01' and '2009-05-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-05-01' and '2009-05-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-06-01' and '2009-06-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-06-01' and '2009-06-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-07-01' and '2009-07-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-07-01' and '2009-07-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-08-01' and '2009-08-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-08-01' and '2009-08-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-09-01' and '2009-09-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-09-01' and '2009-09-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-10-01' and '2009-10-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-10-01' and '2009-10-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-11-01' and '2009-11-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-01' and '2009-11-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-12-01' and '2009-12-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-12-01' and '2009-12-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2010-01-01' and '2010-01-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2010-01-01' and '2010-01-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2010-02-01' and '2010-02-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2010-02-01' and '2010-02-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2010-03-01' and '2010-03-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2010-03-01' and '2010-03-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2010-04-01' and '2010-04-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2010-04-01' and '2010-04-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0004 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2010-05-01' and '2010-05-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2010-05-01' and '2010-05-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2010-06-01' and '2010-06-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2010-06-01' and '2010-06-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2010-07-01' and '2010-07-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2010-07-01' and '2010-07-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2010-08-01' and '2010-08-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0011 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2010-08-01' and '2010-08-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2010-09-01' and '2010-09-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 0.0001 seconds | |||||||||
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2010-09-01' and '2010-09-31' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_pm | ALL | NULL | NULL | NULL | NULL | 245 | Using where |
| 0.0003 seconds | |||||||||
| SELECT session_id FROM wowbb_sessions WHERE last_visit >= '2010-09-06 21:53:27' AND ip='38.107.191.82' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_sessions | range | last_visit | last_visit | 8 | NULL | 4 | Using where |
| 0.0002 seconds | |||||||||
| SELECT COUNT(*) AS users_online FROM wowbb_sessions WHERE last_visit >= '2010-09-06 21:53:27' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_sessions | range | last_visit | last_visit | 8 | NULL | 5 | Using where; Using index |
| 0.0001 seconds | |||||||||
| SELECT log_id, max_online FROM wowbb_visitor_log WHERE log_date='2010-09-06' | |||||||||
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | wowbb_visitor_log | ref | log_date | log_date | 3 | const | 1 | NULL |
| 0.0001 seconds | |||||||||