Version:
2.0.0rc3
Product Code Name:
Arctic
Total Time:
0.5141289
PHP General Time:
0.2181248
GZIP:
enabled
Driver Version:
MySQL 5.0.81-community
SQL Time:
0.2960041
SQL Queries:
9
SQL Memory Usage:
9.95 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
3.94 Mb
Total Memory Usage (Including Debug):
4.08 Mb
Memory Limit:
16 Mb (32M)
Load Balancing Enabled:
No
Requests From:
208.167.227.150
Server Time Stamp:
November 7, 2009, 9:39 am
PHP Version:
5.2.11
PHP Sapi:
cgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux
0.0005519
| Memory Before: 1.6 Mb
| Memory After: 1.6 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('1b5b2b941b83d47dd927a4238b1f166f', 'd0b63444099757fedc3d79aa837e804c', '0', '1257586799', '', '0', '0', '0', '38.107.191.117', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)')
0.0006280
| Memory Before: 2.12 Mb
| Memory After: 2.12 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: No
SELECT s.style_id, s.parent_id
AS style_parent_id, s.folder
AS style_folder_name, t.folder
AS theme_folder_name, t.parent_id
AS theme_parent_id
FROM phpfox_theme_style
AS s
JOIN phpfox_theme
AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | s | system | | MISSING KEY | | | 1 | |
| 1 | SIMPLE | t | system | PRIMARY,theme_id | MISSING KEY | | | 1 | |
0.0007470
| Memory Before: 2.42 Mb
| Memory After: 2.42 Mb
| Memory Used: 1.12 kb
| Rows: 0
| Slave: Yes
SELECT cf.*
FROM phpfox_custom_field
AS cf
WHERE cf.type_id IN('user_main','user_panel','profile_panel') AND cf.user_group_id = 0 AND cf.on_signup = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | cf | ALL | | MISSING KEY | | | 16 | Using where |
0.0003650
| Memory Before: 3.03 Mb
| Memory After: 3.03 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_ad
SET count_view = count_view + '1'
WHERE ad_id = 1
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.2897091
| Memory Before: 3.41 Mb
| Memory After: 3.41 Mb
| Memory Used: 1.12 kb
| Rows: 4
| Slave: Yes
SELECT u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_user
AS u
WHERE u.user_image IS NOT NULL
ORDER BY RAND()
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | u | range | user_image | user_image | 53 | | 21188 | Using where; Using temporary; Using filesort |
0.0003572
| Memory Before: 3.55 Mb
| Memory After: 3.55 Mb
| Memory Used: 1.08 kb
| Rows: -
| Slave: No
UPDATE phpfox_ad
SET count_view = count_view + '1'
WHERE ad_id = 3
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0003169
| Memory Before: 3.68 Mb
| Memory After: 3.68 Mb
| Memory Used: 1.12 kb
| Rows: 0
| Slave: No
SELECT sp.*
FROM phpfox_subscribe_package
AS sp
WHERE sp.is_active = 1 AND sp.is_registration = 1
ORDER BY sp.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE noticed after reading const tables |
0.0002651
| Memory Before: 3.71 Mb
| Memory After: 3.71 Mb
| Memory Used: 1.12 kb
| Rows: 0
| Slave: Yes
SELECT var_name, user_value
FROM phpfox_component_setting
WHERE user_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_component_setting | ref | user_id,user_id_2 | user_id | 4 | const | 1 | |
0.0030639
| Memory Before: 3.85 Mb
| Memory After: 3.85 Mb
| Memory Used: 1.12 kb
| Rows: 3
| Slave: Yes
SELECT b.blog_id, b.time_stamp, b.title, b.title_url, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_blog
AS b
JOIN phpfox_user
AS u
ON(u.user_id = b.user_id)
WHERE b.is_approved = 1 AND b.privacy = 1 AND b.post_status = 1
ORDER BY b.time_stamp
DESC
LIMIT 3
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | b | range | public_view,user_id,my_blogs,profile_user,profile_guest | public_view | 3 | | 282 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | f0xysp4c3db.b.user_id | 1 | |
Array
(
[session] => 1b5b2b941b83d47dd927a4238b1f166f
[486256453theme] => a:5:{s:8:"style_id";s:1:"1";s:15:"style_parent_id";s:1:"0";s:17:"style_folder_name";s:7:"default";s:17:"theme_folder_name";s:7:"default";s:15:"theme_parent_id";s:1:"0";}
[redirect] =>
)