Version:
2.1.0
Product Code Name:
Arctic
Total Time:
1.6707389
PHP General Time:
1.6682589
GZIP:
enabled
Driver Version:
MySQL 5.1.68-cll
SQL Time:
0.0024800
SQL Queries:
4
SQL Memory Usage:
6.13 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
8.73 Mb
Total Memory Usage (Including Debug):
8.96 Mb
Memory Limit:
32 Mb (64M)
Load Balancing Enabled:
No
Requests From:
174.127.109.132
Server Time Stamp:
May 24, 2013, 11:23 am
PHP Version:
5.3.23
PHP Sapi:
cgi-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux
Cache:
file
0.0003870
| Memory Before: 3.41 Mb
| Memory After: 3.41 Mb
| Memory Used: 1.47 kb
| Rows: -
| Slave: No
INSERT INTO phpfox2_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('bab4d8b30bf063cdee175e0efe817b74', '1aaf2349a3ed40ef0f86f3e65294a991', '0', '1369394630', '/marketplace/view_purchased/', '0', '0', '0', '107.22.156.205', 'CCBot/2.0')
0.0002160
| Memory Before: 4.35 Mb
| Memory After: 4.35 Mb
| Memory Used: 1.55 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 phpfox2_theme_style
AS s
JOIN phpfox2_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 | is_default | MISSING KEY | | | 1 | |
| 1 | SIMPLE | t | system | PRIMARY,theme_id | MISSING KEY | | | 1 | |
0.0006480
| Memory Before: 5.9 Mb
| Memory After: 5.9 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(DISTINCT m.listing_id)
FROM phpfox2_marketplace
AS m
JOIN phpfox2_marketplace_invoice
AS minvoice
ON(minvoice.listing_id = m.listing_id AND minvoice.user_id = 0 AND minvoice.status = 'completed')
WHERE m.view_id = 0
/* 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.0012290
| Memory Before: 8.57 Mb
| Memory After: 8.57 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT ur.rate_id
AS has_rated, u.*, user_space.*, user_field.*, user_activity.*, ls.user_id
AS is_online, ts.style_id
AS designer_style_id, ts.folder
AS designer_style_folder, t.folder
AS designer_theme_folder, t.parent_id
AS theme_parent_id, ug.prefix, ug.suffix, ug.icon_ext, ug.title
FROM phpfox2_user
AS u
LEFT JOIN phpfox2_user_rating
AS ur
ON(ur.item_id = u.user_id AND ur.user_id = 0)
JOIN phpfox2_user_group
AS ug
ON(ug.user_group_id = u.user_group_id)
JOIN phpfox2_user_space
AS user_space
ON(user_space.user_id = u.user_id)
JOIN phpfox2_user_field
AS user_field
ON(user_field.user_id = u.user_id)
JOIN phpfox2_user_activity
AS user_activity
ON(user_activity.user_id = u.user_id)
LEFT JOIN phpfox2_theme_style
AS ts
ON(ts.style_id = user_field.designer_style_id)
LEFT JOIN phpfox2_theme
AS t
ON(t.theme_id = ts.theme_id)
LEFT JOIN phpfox2_log_session
AS ls
ON(ls.user_id = u.user_id AND ls.im_hide = 0)
WHERE u.user_id = 0
/* 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 |
Array
(
[session] => bab4d8b30bf063cdee175e0efe817b74
[theme] => 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] => /marketplace/view_purchased/
)
