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