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