Version:
2.0.4
Product Code Name:
Arctic
Total Time:
0.7584078
PHP General Time:
0.6755237
GZIP:
enabled
Driver Version:
MySQL 5.0.22
SQL Time:
0.0828841
SQL Queries:
13
SQL Memory Usage:
6.02 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
5.72 Mb
Total Memory Usage (Including Debug):
5.86 Mb
Memory Limit:
32 Mb (64M)
Load Balancing Enabled:
No
Requests From:
79.99.42.26
Server Time Stamp:
February 23, 2012, 6:16 am
PHP Version:
5.1.6
PHP Sapi:
apache2handler
PHP safe_mode:
false
PHP open_basedir:
true
Operating System:
Linux
0.0004611
| 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 = '378ef59ecebb3f9eb99fa0c3dd8729ae' 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.0004330
| Memory Before: 1.6 Mb
| Memory After: 1.6 Mb
| Memory Used: 808 b
| Rows: -
| Slave: No
UPDATE phpfox_log_session
SET last_activity = '1329977804', user_id = '0', location = '/user/browse/gender_2/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '38.107.179.219', user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
WHERE session_hash = '378ef59ecebb3f9eb99fa0c3dd8729ae'
| 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.0003328
| Memory Before: 1.75 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.0003061
| 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.0002649
| 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.0002720
| 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.0004399
| 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.0615630
| Memory Before: 3.26 Mb
| Memory After: 3.26 Mb
| Memory Used: 240 b
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_user
AS u
JOIN phpfox_user_field
AS ufield
ON(ufield.user_id = u.user_id)
WHERE u.gender = '2'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | ufield | index | user_id | user_id | 4 | | 5373 | Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | phpfoxdev.ufield.user_id | 1 | Using where |
0.0172961
| Memory Before: 3.29 Mb
| Memory After: 3.29 Mb
| Memory Used: 336 b
| Rows: 21
| Slave: Yes
SELECT uf.user_id as is_featured, uf.ordering as featured_order, u.status_id as unverified, u.*, ufield.*
FROM phpfox_user
AS u
LEFT JOIN phpfox_user_featured
AS uf
ON(uf.user_id = u.user_id)
JOIN phpfox_user_field
AS ufield
ON(ufield.user_id = u.user_id)
WHERE u.gender = '2'
ORDER BY u.full_name ASC
LIMIT 21
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | uf | system | PRIMARY | MISSING KEY | | | | const row not found |
| 1 | SIMPLE | u | ALL | PRIMARY | MISSING KEY | | | 5373 | Using where; Using filesort |
| 1 | SIMPLE | ufield | eq_ref | user_id | user_id | 4 | phpfoxdev.u.user_id | 1 | |
0.0006349
| Memory Before: 3.75 Mb
| Memory After: 3.75 Mb
| Memory Used: 728 b
| Rows: 3
| Slave: Yes
SELECT cron.*
FROM phpfox_cron
AS cron
JOIN phpfox_product
AS product
ON(product.product_id = cron.product_id AND product.is_active = 1)
JOIN phpfox_module
AS m
ON(m.module_id = cron.module_id AND m.is_active = 1)
WHERE cron.is_active = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | cron | ref | is_active | is_active | 1 | const | 2 | |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 78 | phpfoxdev.cron.product_id,const | 2 | Using index |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 228 | phpfoxdev.cron.module_id,const | 5 | Using index |
0.0003071
| Memory Before: 3.75 Mb
| Memory After: 3.76 Mb
| Memory Used: 280 b
| Rows: -
| Slave: No
DELETE FROM phpfox_log_session
WHERE last_activity < '1329967004'
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_log_session | range | specific_forum,general_forum,last_activity | specific_forum | 4 | | 1 | Using where |
0.0003071
| Memory Before: 3.75 Mb
| Memory After: 3.75 Mb
| Memory Used: 592 b
| Rows: -
| Slave: No
UPDATE phpfox_cron
SET next_run = '1329977864', last_run = '1329977804'
WHERE cron_id = 1
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_cron | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0002661
| Memory Before: 3.75 Mb
| Memory After: 3.76 Mb
| Memory Used: 240 b
| Rows: -
| Slave: No
INSERT INTO phpfox_cron_log (cron_id, time_stamp) VALUES ('1', '1329977804')
Array
(
[session] => 378ef59ecebb3f9eb99fa0c3dd8729ae
[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] => /user/browse/gender_2/
)
Array
(
[phpfox1visit] => 1329976487
)
View Profile
Send Message
Add to Friends
