Version:
2.0.5
Product Code Name:
Arctic
Total Time:
0.1510851
PHP General Time:
0.1471229
GZIP:
enabled
Driver Version:
MySQL 5.0.91-community
SQL Time:
0.0039622
SQL Queries:
18
SQL Memory Usage:
19.9 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
5.42 Mb
Total Memory Usage (Including Debug):
5.59 Mb
Memory Limit:
32 Mb (64M)
Load Balancing Enabled:
No
Requests From:
67.228.136.224
Server Time Stamp:
September 6, 2010, 4:29 pm
PHP Version:
5.2.12
PHP Sapi:
cgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux
Cache:
file
0.0002840
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 1.12 kb
| 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 = 'ece03a6fd1e2522387cbd228d3bbd6ad' AND s.id_hash = 'd0b63444099757fedc3d79aa837e804c'
/* 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 | 32 | const | 1 | Using where |
0.0001450
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_log_view (user_id, ip_address, protocal, cache_data, time_stamp) VALUES ('0', '38.107.191.82', 'GET', 'a:4:{s:8:\"location\";s:23:\"/video/category/tattoo/\";s:8:\"referrer\";N;s:10:\"user_agent\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:7:\"request\";s:46:\"a:1:{s:2:\"do\";s:23:\"/video/category/tattoo/\";}\";}', '1283790572')
0.0001638
| Memory Before: 1.76 Mb
| Memory After: 1.76 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session
SET last_activity = '1283790572', user_id = '0', location = '/video/category/tattoo/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '38.107.191.82', user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
WHERE session_hash = 'ece03a6fd1e2522387cbd228d3bbd6ad'
| 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 | 32 | const | 1 | Using where |
0.0002630
| Memory Before: 2.33 Mb
| Memory After: 2.33 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 | ref | is_default | is_default | 1 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | deathdlr_fox.s.theme_id | 1 | |
0.0000970
| Memory Before: 2.34 Mb
| Memory After: 2.34 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: No
SELECT folder
AS parent_style_folder
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_style | ref | style_id | style_id | 2 | const | 1 | |
0.0000801
| Memory Before: 2.34 Mb
| Memory After: 2.34 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: No
SELECT folder
AS parent_theme_folder
FROM phpfox_theme
WHERE theme_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme | const | PRIMARY,theme_id | PRIMARY | 2 | const | 1 | |
0.0003791
| Memory Before: 3.19 Mb
| Memory After: 3.19 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(DISTINCT m.video_id)
FROM phpfox_video
AS m
INNER JOIN phpfox_video_category_data
AS mcd
ON(mcd.video_id = m.video_id)
WHERE m.in_process = 0 AND m.view_id = 0 AND m.module_id = 'video' AND m.item_id = 0 AND mcd.category_id IN(7)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | mcd | ref | category_id,video_id | category_id | 4 | const | 7 | |
| 1 | SIMPLE | m | eq_ref | PRIMARY,in_process,video_id_2,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,video_id,video_id_3,view_id,view_id_3,view_id_4 | PRIMARY | 4 | deathdlr_fox.mcd.video_id | 1 | Using where |
0.0005860
| Memory Before: 3.34 Mb
| Memory After: 3.34 Mb
| Memory Used: 1.12 kb
| Rows: 8
| Slave: Yes
SELECT m.*, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_video
AS m
INNER JOIN phpfox_video_category_data
AS mcd
ON(mcd.video_id = m.video_id)
JOIN phpfox_user
AS u
ON(u.user_id = m.user_id)
WHERE m.in_process = 0 AND m.view_id = 0 AND m.module_id = 'video' AND m.item_id = 0 AND mcd.category_id IN(7)
GROUP BY m.video_id
ORDER BY m.is_featured
DESC , m.time_stamp
DESC
LIMIT 12
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | mcd | ref | category_id,video_id | category_id | 4 | const | 7 | Using temporary; Using filesort |
| 1 | SIMPLE | m | eq_ref | PRIMARY,in_process,video_id_2,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,video_id,video_id_3,view_id,view_id_3,user_id,view_id_4 | PRIMARY | 4 | deathdlr_fox.mcd.video_id | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | deathdlr_fox.m.user_id | 1 | |
0.0003660
| Memory Before: 3.5 Mb
| Memory After: 3.5 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: No
SELECT v.*, ve.embed_code, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_video
AS v
JOIN phpfox_user
AS u
ON(u.user_id = v.user_id)
LEFT JOIN phpfox_video_embed
AS ve
ON(ve.video_id = v.video_id)
WHERE v.in_process = 0 AND v.view_id = 0 AND v.is_spotlight = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | v | ref | in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,view_id_3,user_id,view_id_4 | in_process | 1 | const | 7 | Using where |
| 1 | SIMPLE | ve | eq_ref | video_id | video_id | 4 | deathdlr_fox.v.video_id | 1 | |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | deathdlr_fox.v.user_id | 1 | |
0.0000999
| Memory Before: 3.91 Mb
| Memory After: 3.91 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT count_view
FROM phpfox_ad
WHERE ad_id = 9
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0001092
| Memory Before: 3.91 Mb
| Memory After: 3.91 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_ad
SET count_view = '71717'
WHERE ad_id = 9
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0000851
| Memory Before: 3.92 Mb
| Memory After: 3.92 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT count_view
FROM phpfox_ad
WHERE ad_id = 12
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0000830
| Memory Before: 3.92 Mb
| Memory After: 3.92 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_ad
SET count_view = '32651'
WHERE ad_id = 12
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0000961
| Memory Before: 4.26 Mb
| Memory After: 4.26 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT count_view
FROM phpfox_ad
WHERE ad_id = 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0000842
| Memory Before: 4.26 Mb
| Memory After: 4.26 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_ad
SET count_view = '113203'
WHERE ad_id = 10
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0008588
| Memory Before: 5.27 Mb
| Memory After: 5.27 Mb
| Memory Used: 1.12 kb
| Rows: 0
| Slave: Yes
SELECT category_id, tag_text
AS tag, tag_url, COUNT(item_id)
AS total
FROM phpfox_tag
WHERE category_id = 'video'
GROUP BY tag_text, tag_url
ORDER BY total
DESC , tag_text ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_tag | ref | category_id,user_search,user_search_general | category_id | 77 | const | 1 | Using where; Using temporary; Using filesort |
0.0000961
| Memory Before: 5.41 Mb
| Memory After: 5.42 Mb
| Memory Used: 1.12 kb
| Rows: 1
| Slave: Yes
SELECT count_view
FROM phpfox_ad
WHERE ad_id = 11
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0000858
| Memory Before: 5.42 Mb
| Memory After: 5.42 Mb
| Memory Used: 1.07 kb
| Rows: -
| Slave: No
UPDATE phpfox_ad
SET count_view = '112963'
WHERE ad_id = 11
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_ad | const | PRIMARY | PRIMARY | 4 | const | 1 | |
Array
(
[session] => ece03a6fd1e2522387cbd228d3bbd6ad
[theme] => a:7:{s:8:"style_id";s:1:"3";s:15:"style_parent_id";s:1:"1";s:17:"style_folder_name";s:7:"default";s:17:"theme_folder_name";s:6:"sinner";s:15:"theme_parent_id";s:1:"1";s:19:"parent_style_folder";s:7:"default";s:19:"parent_theme_folder";s:7:"default";}
[redirect] => /video/category/tattoo/
)
Array
(
[phpfox1visit] => 1283789999
)
