Powered by
WowBB 1.7 - Copyright © 2003-2006 Aycan Gulez
Page processed in 0.2676 seconds (7% database + 93% PHP). 67 queries executed.
| 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 BETWEEN '2009-09-01' AND '2009-09-31' ORDER BY log_date |
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | wowbb_visitor_log | range | log_date | log_date | 3 | NULL | 27 | Using where |
| 0.0007 seconds |
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-09-01 00:00:00' and '2009-09-01 23:59:59' |
| 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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-09-01 00:00:00' and '2009-09-01 23:59:59' |
| 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-02 00:00:00' and '2009-09-02 23:59:59' |
| 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-02 00:00:00' and '2009-09-02 23:59:59' |
| 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-03 00:00:00' and '2009-09-03 23:59:59' |
| 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-03 00:00:00' and '2009-09-03 23:59:59' |
| 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-04 00:00:00' and '2009-09-04 23:59:59' |
| 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-04 00:00:00' and '2009-09-04 23:59:59' |
| 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-05 00:00:00' and '2009-09-05 23:59:59' |
| 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-05 00:00:00' and '2009-09-05 23:59:59' |
| 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-06 00:00:00' and '2009-09-06 23:59:59' |
| 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-06 00:00:00' and '2009-09-06 23:59:59' |
| 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-07 00:00:00' and '2009-09-07 23:59:59' |
| 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-07 00:00:00' and '2009-09-07 23:59:59' |
| 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-08 00:00:00' and '2009-09-08 23:59:59' |
| 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-08 00:00:00' and '2009-09-08 23:59:59' |
| 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-09 00:00:00' and '2009-09-09 23:59:59' |
| 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-09 00:00:00' and '2009-09-09 23:59:59' |
| 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-10 00:00:00' and '2009-09-10 23:59:59' |
| 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-10 00:00:00' and '2009-09-10 23:59:59' |
| 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-11 00:00:00' and '2009-09-11 23:59:59' |
| 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-11 00:00:00' and '2009-09-11 23:59:59' |
| 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-12 00:00:00' and '2009-09-12 23:59:59' |
| 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-12 00:00:00' and '2009-09-12 23:59:59' |
| 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-13 00:00:00' and '2009-09-13 23:59:59' |
| 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-13 00:00:00' and '2009-09-13 23:59:59' |
| 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-14 00:00:00' and '2009-09-14 23:59:59' |
| 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-14 00:00:00' and '2009-09-14 23:59:59' |
| 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-15 00:00:00' and '2009-09-15 23:59:59' |
| 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-15 00:00:00' and '2009-09-15 23:59:59' |
| 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-16 00:00:00' and '2009-09-16 23:59:59' |
| 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-16 00:00:00' and '2009-09-16 23:59:59' |
| 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-17 00:00:00' and '2009-09-17 23:59:59' |
| 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-17 00:00:00' and '2009-09-17 23:59:59' |
| 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-18 00:00:00' and '2009-09-18 23:59:59' |
| 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-18 00:00:00' and '2009-09-18 23:59:59' |
| 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-19 00:00:00' and '2009-09-19 23:59:59' |
| 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-19 00:00:00' and '2009-09-19 23:59:59' |
| 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-20 00:00:00' and '2009-09-20 23:59:59' |
| 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-20 00:00:00' and '2009-09-20 23:59:59' |
| 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-21 00:00:00' and '2009-09-21 23:59:59' |
| 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-21 00:00:00' and '2009-09-21 23:59:59' |
| 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-22 00:00:00' and '2009-09-22 23:59:59' |
| 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-22 00:00:00' and '2009-09-22 23:59:59' |
| 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-23 00:00:00' and '2009-09-23 23:59:59' |
| 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-23 00:00:00' and '2009-09-23 23:59:59' |
| 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-24 00:00:00' and '2009-09-24 23:59:59' |
| 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-24 00:00:00' and '2009-09-24 23:59:59' |
| 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-25 00:00:00' and '2009-09-25 23:59:59' |
| 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-25 00:00:00' and '2009-09-25 23:59:59' |
| 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-26 00:00:00' and '2009-09-26 23:59:59' |
| 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-26 00:00:00' and '2009-09-26 23:59:59' |
| 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-27 00:00:00' and '2009-09-27 23:59:59' |
| 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-27 00:00:00' and '2009-09-27 23:59:59' |
| 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-28 00:00:00' and '2009-09-28 23:59:59' |
| 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-28 00:00:00' and '2009-09-28 23:59:59' |
| 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-29 00:00:00' and '2009-09-29 23:59:59' |
| 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-29 00:00:00' and '2009-09-29 23:59:59' |
| 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-30 00:00:00' and '2009-09-30 23:59:59' |
| 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-30 00:00:00' and '2009-09-30 23:59:59' |
| 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 22:00:42' AND ip='38.107.191.80' |
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | wowbb_sessions | range | last_visit | last_visit | 8 | NULL | 7 | Using where |
| 0.0002 seconds |
| SELECT COUNT(*) AS users_online FROM wowbb_sessions WHERE last_visit >= '2010-09-06 22:00:42' |
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | wowbb_sessions | range | last_visit | last_visit | 8 | NULL | 8 | 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 |