Powered by
WowBB 1.7 - Copyright © 2003-2006 Aycan Gulez
Page processed in 0.3154 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-11-01' AND '2009-11-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-11-01 00:00:00' and '2009-11-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-11-01 00:00:00' and '2009-11-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-11-02 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-02 00:00:00' and '2009-11-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-11-03 00:00:00' and '2009-11-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-11-03 00:00:00' and '2009-11-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.0004 seconds |
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-11-04 00:00:00' and '2009-11-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-11-04 00:00:00' and '2009-11-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-11-05 00:00:00' and '2009-11-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-11-05 00:00:00' and '2009-11-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-11-06 00:00:00' and '2009-11-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-11-06 00:00:00' and '2009-11-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-11-07 00:00:00' and '2009-11-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-11-07 00:00:00' and '2009-11-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-11-08 00:00:00' and '2009-11-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-11-08 00:00:00' and '2009-11-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.0005 seconds |
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-11-09 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-09 00:00:00' and '2009-11-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-11-10 00:00:00' and '2009-11-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-11-10 00:00:00' and '2009-11-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-11-11 00:00:00' and '2009-11-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-11-11 00:00:00' and '2009-11-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-11-12 00:00:00' and '2009-11-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-11-12 00:00:00' and '2009-11-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-11-13 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-13 00:00:00' and '2009-11-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.0004 seconds |
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-11-14 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-14 00:00:00' and '2009-11-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-11-15 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-15 00:00:00' and '2009-11-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.0004 seconds |
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-11-16 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-16 00:00:00' and '2009-11-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-11-17 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-17 00:00:00' and '2009-11-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.0005 seconds |
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-11-18 00:00:00' and '2009-11-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-11-18 00:00:00' and '2009-11-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-11-19 00:00:00' and '2009-11-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-11-19 00:00:00' and '2009-11-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-11-20 00:00:00' and '2009-11-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.0003 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-20 00:00:00' and '2009-11-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-11-21 00:00:00' and '2009-11-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-11-21 00:00:00' and '2009-11-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-11-22 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-22 00:00:00' and '2009-11-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-11-23 00:00:00' and '2009-11-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-11-23 00:00:00' and '2009-11-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-11-24 00:00:00' and '2009-11-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-11-24 00:00:00' and '2009-11-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-11-25 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-25 00:00:00' and '2009-11-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-11-26 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-26 00:00:00' and '2009-11-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.0005 seconds |
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-11-27 00:00:00' and '2009-11-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-11-27 00:00:00' and '2009-11-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-11-28 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-28 00:00:00' and '2009-11-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-11-29 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-29 00:00:00' and '2009-11-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.0005 seconds |
| SELECT COUNT(*) AS post_count FROM wowbb_posts WHERE post_date_time BETWEEN '2009-11-30 00:00:00' and '2009-11-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.0002 seconds |
| SELECT COUNT(*) AS pm_count FROM wowbb_pm WHERE pm_date_time BETWEEN '2009-11-30 00:00:00' and '2009-11-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:09:02' AND ip='38.107.191.83' |
| 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.0004 seconds |
| SELECT COUNT(*) AS users_online FROM wowbb_sessions WHERE last_visit >= '2010-09-06 22:09:02' |
| 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; Using index |
| 0.0002 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.0002 seconds |