0.0003459
| 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 ('b103d3c2332c3561f20c6a7cf033a15d', '0677c402907773a4f0e89030b656d936', '0', '1369081346', '/Heatherleigh/blog/', '0', '0', '0', '184.72.184.104', 'CCBot/2.0')
0.0001380
| 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.0010250
| Memory Before: 5.46 Mb
| Memory After: 5.46 Mb
| Memory Used: 1.55 kb
| Rows: 1
| 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_name = 'Heatherleigh'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | ur | system | item_id,item_id_2 | MISSING KEY | | | | const row not found |
| 1 | SIMPLE | u | ref | PRIMARY,user_name,user_group_id | user_name | 103 | const | 1 | Using where |
| 1 | SIMPLE | user_space | eq_ref | user_id | user_id | 4 | truckel0_phpfox.u.user_id | 1 | |
| 1 | SIMPLE | user_field | eq_ref | user_id | user_id | 4 | truckel0_phpfox.u.user_id | 1 | |
| 1 | SIMPLE | ts | ref | style_id | style_id | 2 | truckel0_phpfox.user_field.designer_style_id | 1 | |
| 1 | SIMPLE | ug | ref | user_group_id | user_group_id | 1 | truckel0_phpfox.u.user_group_id | 2 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | truckel0_phpfox.ts.theme_id | 1 | |
| 1 | SIMPLE | ls | ref | user_id,user_id_2 | user_id | 5 | truckel0_phpfox.user_space.user_id,const | 19 | Using index |
| 1 | SIMPLE | user_activity | eq_ref | user_id | user_id | 4 | truckel0_phpfox.user_space.user_id | 1 | Using where |
0.0000901
| Memory Before: 5.71 Mb
| Memory After: 5.71 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox2_user_blocked
WHERE user_id = 1216 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.0001910
| Memory Before: 5.77 Mb
| Memory After: 5.78 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT birthday
FROM phpfox2_user
WHERE user_id = 1216
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox2_user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
0.0000560
| Memory Before: 5.78 Mb
| Memory After: 5.78 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox2_user_privacy
WHERE user_id = 1216
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox2_user_privacy | ref | user_id,user_id_2 | user_id | 4 | const | 1 | |
0.0005341
| Memory Before: 6.92 Mb
| Memory After: 6.92 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox2_blog
AS blog
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 = 1216 AND blog.is_approved = 1 AND blog.post_status = 1
/* 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 | blog | ref | PRIMARY,public_view,user_id,my_blogs,profile_user,profile_guest,user_id_2 | user_id | 4 | const | 8 | Using where |
| 1 | SIMPLE | blog_text | ref | blog_id | blog_id | 4 | truckel0_phpfox.blog.blog_id | 12 | Using index |
0.0006471
| Memory Before: 6.98 Mb
| Memory After: 6.98 Mb
| Memory Used: 1.55 kb
| Rows: 5
| Slave: Yes
SELECT 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
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 = 1216 AND blog.is_approved = 1 AND blog.post_status = 1
ORDER BY time_stamp
DESC
LIMIT 5
/* 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 | blog | ref | PRIMARY,public_view,user_id,my_blogs,profile_user,profile_guest,user_id_2 | user_id | 4 | const | 8 | Using where |
| 1 | SIMPLE | blog_text | ref | blog_id | blog_id | 4 | truckel0_phpfox.blog.blog_id | 12 | |
0.0301309
| Memory Before: 7.14 Mb
| Memory After: 7.14 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(1549, 1548, 1547, 1546, 1545)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | d | ALL | blog_id,category_id | MISSING KEY | | | 3 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category_id | PRIMARY | 4 | truckel0_phpfox.d.category_id | 1 | |
0.0014861
| Memory Before: 7.24 Mb
| Memory After: 7.25 Mb
| Memory Used: 1.55 kb
| Rows: 3
| Slave: Yes
SELECT tag_id, item_id, tag_text, tag_url
FROM phpfox2_tag
WHERE item_id IN(1549, 1548, 1547, 1546, 1545) 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 | range | item_id,category_id,user_search,user_search_general,item_id_2,item_id_3 | item_id | 81 | | 6 | Using where; Using filesort |
0.0007961
| Memory Before: 9.84 Mb
| Memory After: 9.84 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT c.category_id, c.name, c.name_url, c.user_id, COUNT(DISTINCT b.blog_id)
AS used
FROM phpfox2_blog_category
AS c
LEFT JOIN phpfox2_blog_category_data
AS bcd
ON(bcd.category_id = c.category_id)
LEFT JOIN phpfox2_blog
AS b
ON(b.blog_id = bcd.blog_id AND b.is_approved = 1 AND b.privacy = 1 AND b.post_status = 1)
WHERE c.user_id = 1216
GROUP BY c.category_id
ORDER BY c.name ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | c | ref | user_id | user_id | 4 | const | 1 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | bcd | ref | category_id | category_id | 4 | truckel0_phpfox.c.category_id | 2 | |
| 1 | SIMPLE | b | eq_ref | PRIMARY,public_view | PRIMARY | 4 | truckel0_phpfox.bcd.blog_id | 1 | |
0.0005791
| Memory Before: 10.15 Mb
| Memory After: 10.15 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_user_track
AS track
JOIN phpfox2_user
AS u
ON(u.user_id = track.user_id)
WHERE track.item_id = 1216 AND track.user_id != 1216
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 | |
Array
(
[session] => b103d3c2332c3561f20c6a7cf033a15d
[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] => /Heatherleigh/blog/
)