Version:
2.1.0
Product Code Name:
Arctic
Total Time:
0.2236769
PHP General Time:
0.1284969
GZIP:
enabled
Driver Version:
MySQL 5.1.68-cll
SQL Time:
0.0951800
SQL Queries:
9
SQL Memory Usage:
13.91 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
10.03 Mb
Total Memory Usage (Including Debug):
10.27 Mb
Memory Limit:
32 Mb (64M)
Load Balancing Enabled:
No
Requests From:
174.127.109.132
Server Time Stamp:
May 22, 2013, 7:34 pm
PHP Version:
5.3.23
PHP Sapi:
cgi-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux
Cache:
file
0.0005839
| Memory Before: 3.41 Mb
| Memory After: 3.42 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 ('8dffb6dffb730b86a6e2614694682a69', 'e2d155e2b9e93d282810a2a5a95c41b3', '0', '1369251257', '/stretch/blog/been-a-really-long-time-2/comment_19328/page_1/comment_0/', '0', '0', '0', '50.19.155.235', 'CCBot/2.0')
0.0001659
| 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.0007050
| Memory Before: 5.46 Mb
| Memory After: 5.46 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT u.*
FROM phpfox2_user
AS u
WHERE u.user_name = 'stretch'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | u | ref | user_name | user_name | 103 | const | 1 | Using where |
0.0001070
| Memory Before: 5.67 Mb
| Memory After: 5.67 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox2_user_blocked
WHERE user_id = 935 AND block_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 |
0.0012078
| Memory Before: 6.2 Mb
| Memory After: 6.2 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT blog_track.item_id
AS is_viewed, p.item_id
AS privacy_pass, f.friend_id
AS is_friend, blog.*, blog_text.text_parsed
AS text, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox2_blog
AS blog
LEFT JOIN phpfox2_blog_track
AS blog_track
ON(blog_track.item_id = blog.blog_id AND blog_track.user_id = 0)
LEFT JOIN phpfox2_privacy
AS p
ON(p.item_id = blog.blog_id AND p.category_id = 'blog' AND p.user_id = 0)
LEFT JOIN phpfox2_friend
AS f
ON(f.user_id = blog.user_id AND f.friend_user_id = 0)
JOIN phpfox2_blog_text
AS blog_text
ON(blog_text.blog_id = blog.blog_id)
JOIN phpfox2_user
AS u
ON(u.user_id = blog.user_id)
WHERE blog.user_id = 935 AND blog.title_url = 'been-a-really-long-time-2'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | p | system | item_id | MISSING KEY | | | | const row not found |
| 1 | SIMPLE | u | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | blog | ref | PRIMARY,title_url,user_id,my_blogs,profile_user,profile_guest,user_id_2 | user_id | 261 | const,const | 1 | Using where |
| 1 | SIMPLE | f | ref | user_id,user_check,top_friend,friend_user_id | user_check | 8 | const,const | 1 | |
| 1 | SIMPLE | blog_text | ref | blog_id | blog_id | 4 | truckel0_phpfox.blog.blog_id | 12 | |
| 1 | SIMPLE | blog_track | ref | item_id | item_id | 8 | truckel0_phpfox.blog.blog_id,const | 2 | Using index |
0.0002902
| Memory Before: 6.34 Mb
| Memory After: 6.34 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT d.blog_id, d.category_id, c.name
AS category_name, c.name_url, c.user_id
FROM phpfox2_blog_category_data
AS d
JOIN phpfox2_blog_category
AS c
ON(d.category_id = c.category_id)
WHERE d.blog_id IN(4403)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | d | ref | blog_id,category_id | blog_id | 4 | const | 1 | |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category_id | PRIMARY | 4 | truckel0_phpfox.d.category_id | 1 | |
0.0029490
| Memory Before: 6.44 Mb
| Memory After: 6.44 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT tag_id, item_id, tag_text, tag_url
FROM phpfox2_tag
WHERE item_id = 4403 AND category_id = 'blog'
ORDER BY tag_id ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox2_tag | ref | item_id,category_id,user_search,user_search_general,item_id_2,item_id_3 | item_id | 81 | const,const | 1 | Using where; Using filesort |
0.0005510
| Memory Before: 8.96 Mb
| Memory After: 8.96 Mb
| Memory Used: 1.55 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 phpfox2_blog_track
AS track
JOIN phpfox2_user
AS u
ON(u.user_id = track.user_id)
WHERE track.item_id = 4403 AND track.user_id != 935
ORDER BY track.time_stamp
DESC
LIMIT 6
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | track | range | item_id | item_id | 8 | | 4 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | truckel0_phpfox.track.user_id | 1 | |
0.0886202
| Memory Before: 10.24 Mb
| Memory After: 10.24 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT cmt.*, comment_text.text_parsed
AS text, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox2_comment
AS cmt
LEFT JOIN phpfox2_comment_text
AS comment_text
ON(comment_text.comment_id = cmt.comment_id)
LEFT JOIN phpfox2_user
AS u
ON(u.user_id = cmt.user_id)
WHERE cmt.type_id = 'blog' AND cmt.item_id = 4403 AND cmt.view_id = 0
ORDER BY cmt.time_stamp
DESC
LIMIT 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | cmt | ref | type_id,view_id | type_id | 82 | const,const,const | 3 | Using where; Using filesort |
| 1 | SIMPLE | comment_text | ref | comment_id | comment_id | 4 | truckel0_phpfox.cmt.comment_id | 12 | |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | truckel0_phpfox.cmt.user_id | 1 | |
Array
(
[session] => 8dffb6dffb730b86a6e2614694682a69
[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] => /stretch/blog/been-a-really-long-time-2/comment_19328/page_1/comment_0/
)
