Version:
2.0.4
Product Code Name:
Arctic
Total Time:
0.7310522
PHP General Time:
0.663299
GZIP:
enabled
Driver Version:
MySQL 5.0.22
SQL Time:
0.0677532
SQL Queries:
12
SQL Memory Usage:
6.48 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
5.63 Mb
Total Memory Usage (Including Debug):
5.77 Mb
Memory Limit:
32 Mb (64M)
Load Balancing Enabled:
No
Requests From:
79.99.42.26
Server Time Stamp:
May 22, 2012, 4:34 pm
PHP Version:
5.1.6
PHP Sapi:
apache2handler
PHP safe_mode:
false
PHP open_basedir:
true
Operating System:
Linux
0.0004849
| Memory Before: 1.59 Mb
| Memory After: 1.59 Mb
| Memory Used: 368 b
| Rows: 1
| Slave: No
SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session
AS s
WHERE s.session_hash = 'f3d5a875be8fdbc3758a1d3b831bc010' AND s.id_hash = 'af7937af3e4465b9039e98887dc0bc04'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | s | ref | session_hash,log_session | session_hash | 96 | const | 1 | Using where |
0.0004830
| Memory Before: 1.6 Mb
| Memory After: 1.6 Mb
| Memory Used: 808 b
| Rows: -
| Slave: No
UPDATE phpfox_log_session
SET last_activity = '1337704440', user_id = '0', location = '/marketplace/view/discount-uggs/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '38.107.179.218', user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
WHERE session_hash = 'f3d5a875be8fdbc3758a1d3b831bc010'
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_log_session | ref | session_hash,log_session | session_hash | 96 | const | 1 | Using where |
0.0003231
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 264 b
| Rows: 3
| Slave: No
SELECT loc_id,loc_name,isbanned
FROM sc_locswitch
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | sc_locswitch | ALL | | MISSING KEY | | | 3 | |
0.0003049
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 728 b
| Rows: 1
| Slave: No
SELECT count(*)
FROM phpfox_country
WHERE isbanned =1 and country_iso = ''
/* 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.0002620
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 328 b
| Rows: 1
| Slave: No
SELECT count(*)
FROM sc_city_ban
WHERE isbanned =1 and city = 'Unknown'
/* 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.0002670
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 344 b
| Rows: 1
| Slave: No
SELECT count(*)
FROM sc_zip_ban
WHERE isbanned =1 and zip = 'Unknown'
/* 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.0004301
| Memory Before: 2.18 Mb
| Memory After: 2.18 Mb
| Memory Used: 912 b
| 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 | ref | is_default | is_default | 1 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | phpfoxdev.s.theme_id | 1 | |
0.0206580
| Memory Before: 2.53 Mb
| Memory After: 2.53 Mb
| Memory Used: 416 b
| Rows: 1
| Slave: Yes
SELECT l.*, ml.invite_id, ml.visited_id, uf.total_score, uf.total_rating, ua.activity_points, mt.description_parsed
AS description, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_marketplace
AS l
JOIN phpfox_marketplace_text
AS mt
ON(mt.listing_id = l.listing_id)
JOIN phpfox_user
AS u
ON(u.user_id = l.user_id)
JOIN phpfox_user_field
AS uf
ON(uf.user_id = l.user_id)
JOIN phpfox_user_activity
AS ua
ON(ua.user_id = l.user_id)
LEFT JOIN phpfox_marketplace_invite
AS ml
ON(ml.listing_id = l.listing_id AND ml.invited_user_id = 0)
WHERE l.group_id = 0 AND l.title_url = 'discount-uggs'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | ml | system | listing_id,listing_id_2,invited_user_id,listing_id_3,listing_id_4 | MISSING KEY | | | | const row not found |
| 1 | SIMPLE | l | ref | PRIMARY,listing_id,view_id | view_id | 771 | const,const | 1 | Using where |
| 1 | SIMPLE | mt | ref | listing_id | listing_id | 4 | phpfoxdev.l.listing_id | 2 | |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | phpfoxdev.l.user_id | 2 | |
| 1 | SIMPLE | uf | eq_ref | user_id | user_id | 4 | phpfoxdev.u.user_id | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | user_id | user_id | 4 | phpfoxdev.u.user_id | 1 | Using where |
0.0261681
| Memory Before: 2.63 Mb
| Memory After: 2.63 Mb
| Memory Used: 552 b
| Rows: 2
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_marketplace_category_data
AS pcd
JOIN phpfox_marketplace_category
AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.listing_id = 2
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | pcd | ref | category_id,listing_id | listing_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | phpfoxdev.pcd.category_id | 1 | Using where |
0.0004780
| Memory Before: 5.08 Mb
| Memory After: 5.08 Mb
| Memory Used: 744 b
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_marketplace
AS v
JOIN phpfox_user
AS u
ON(u.user_id = v.user_id)
WHERE v.listing_id != 2 AND v.view_id = 0 AND v.user_id = 4778
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
| 1 | SIMPLE | v | ref | PRIMARY,view_id_2,listing_id,view_id_3 | view_id_2 | 1 | const | 1 | Using where |
0.0005651
| Memory Before: 5.08 Mb
| Memory After: 5.08 Mb
| Memory Used: 240 b
| Rows: 0
| Slave: Yes
SELECT v.*, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_marketplace
AS v
JOIN phpfox_user
AS u
ON(u.user_id = v.user_id)
WHERE v.listing_id != 2 AND v.view_id = 0 AND v.user_id = 4778
ORDER BY v.time_stamp
DESC
LIMIT 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
| 1 | SIMPLE | v | ref | PRIMARY,view_id_2,listing_id,view_id_3 | view_id_2 | 1 | const | 1 | Using where |
0.0173290
| Memory Before: 5.1 Mb
| Memory After: 5.1 Mb
| Memory Used: 928 b
| Rows: 1
| Slave: Yes
SELECT image_id, image_path, server_id
FROM phpfox_marketplace_image
WHERE listing_id = 2
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_marketplace_image | system | listing_id | MISSING KEY | | | 1 | |
Array
(
[session] => f3d5a875be8fdbc3758a1d3b831bc010
[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/discount-uggs/
)
Array
(
[phpfox1visit] => 1337696753
)