0.0003309
| 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 ('78dbc20fd76aca889d00e590b621a000', '1aaf2349a3ed40ef0f86f3e65294a991', '0', '1369295657', '/alexandcari/', '0', '0', '0', '107.22.156.205', 'CCBot/2.0')
0.0001771
| 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.0011070
| Memory Before: 5.07 Mb
| Memory After: 5.07 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 = 'alexandcari'
/* 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.0002279
| Memory Before: 5.32 Mb
| Memory After: 5.32 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox2_user_blocked
WHERE user_id = 470 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.0002382
| Memory Before: 5.38 Mb
| Memory After: 5.38 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT birthday
FROM phpfox2_user
WHERE user_id = 470
/* 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.0001721
| Memory Before: 5.38 Mb
| Memory After: 5.39 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox2_user_privacy
WHERE user_id = 470
/* 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.0002148
| Memory Before: 5.77 Mb
| Memory After: 5.77 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT cache_id, block_id, ordering, is_hidden
FROM phpfox2_user_design_order
WHERE user_id = 470
ORDER BY ordering ASC
/* 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.0458090
| Memory Before: 7.82 Mb
| Memory After: 7.82 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox2_user_custom
WHERE user_id = 470
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox2_user_custom | const | user_id | user_id | 4 | const | 1 | |
0.0002940
| Memory Before: 8.65 Mb
| Memory After: 8.66 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT var_name, user_value
FROM phpfox2_component_setting
WHERE user_id = 470
/* 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.0015550
| Memory Before: 8.85 Mb
| Memory After: 8.85 Mb
| Memory Used: 1.55 kb
| Rows: 6
| Slave: Yes
SELECT uf.dob_setting, friend.friend_id, friend.is_top_friend, friend.time_stamp, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox2_friend
AS friend
JOIN phpfox2_user
AS u
ON(u.user_id = friend.friend_user_id)
JOIN phpfox2_user_field
AS uf
ON(u.user_id = uf.user_id)
WHERE friend.user_id = 470
GROUP BY u.user_id
ORDER BY friend.is_top_friend
DESC , friend.ordering ASC, RAND()
LIMIT 6
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | friend | ref | user_id,user_check,top_friend,friend_user_id | user_check | 4 | const | 48 | Using temporary; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | truckel0_phpfox.friend.friend_user_id | 1 | |
| 1 | SIMPLE | uf | eq_ref | user_id | user_id | 4 | truckel0_phpfox.friend.friend_user_id | 1 | |
0.0016501
| Memory Before: 9.1 Mb
| Memory After: 9.1 Mb
| Memory Used: 1.55 kb
| Rows: 3
| 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 = 470 AND track.user_id != 470
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 | | 3 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | truckel0_phpfox.track.user_id | 1 | |
0.0011880
| Memory Before: 9.27 Mb
| Memory After: 9.27 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT m.title, m.title_url, m.short_description, m.currency_id, m.price, m.time_stamp, m.image_path, m.server_id
FROM phpfox2_marketplace
AS m
WHERE m.view_id = 0 AND m.group_id = 0 AND m.user_id = 470
ORDER BY m.time_stamp
DESC
LIMIT 5
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | view_id_2,view_id,view_id_3,user_id | view_id_2 | 9 | const,const,const | 1 | Using where; Using filesort |
0.0007851
| Memory Before: 9.47 Mb
| Memory After: 9.47 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT m.event_id, m.title, m.title_url, m.tag_line, m.image_path, m.server_id, m.start_time, m.location, m.country_iso, m.city, m.module_id, m.item_id
FROM phpfox2_event
AS m
JOIN phpfox2_event_invite
AS ei
ON(ei.event_id = m.event_id AND ei.rsvp_id = 1 AND ei.invited_user_id = 470)
WHERE m.view_id = 0 AND m.start_time >= '1369267200'
ORDER BY m.start_time ASC
LIMIT 5
/* 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.0005810
| Memory Before: 9.67 Mb
| Memory After: 9.67 Mb
| Memory Used: 1.55 kb
| Rows: 4
| Slave: Yes
SELECT m.title, m.title_url, m.short_description, m.time_stamp, m.image_path, m.server_id, m.total_member
FROM phpfox2_group
AS m
JOIN phpfox2_group_invite
AS ei
ON(ei.group_id = m.group_id AND ei.member_id = 1 AND ei.invited_user_id = 470)
WHERE m.view_id IN(0,1)
ORDER BY m.time_stamp
DESC
LIMIT 5
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | ei | ref | group_id,invited_user_id,group_id_2,group_id_3,group_id_4,group_id_5 | invited_user_id | 4 | const | 3 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | m | eq_ref | PRIMARY,view_id,view_id_3,group_id | PRIMARY | 4 | truckel0_phpfox.ei.group_id | 1 | Using where |
0.0006599
| Memory Before: 9.72 Mb
| Memory After: 9.72 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT SQL_CALC_FOUND_ROWS u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox2_friend
AS f
INNER JOIN (
SELECT friend_user_id
FROM phpfox2_friend
WHERE user_id = 470)
AS sf
ON(sf.friend_user_id = f.friend_user_id)
JOIN phpfox2_user
AS u
ON(u.user_id = f.friend_user_id)
WHERE f.user_id = 0
GROUP BY f.friend_user_id
ORDER BY f.time_stamp
DESC
LIMIT 3
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | PRIMARY | f | ref | user_id,user_check,top_friend,friend_user_id | user_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | PRIMARY | | ALL | | MISSING KEY | | | 52 | Using where; Using join buffer |
| 1 | PRIMARY | u | eq_ref | PRIMARY | PRIMARY | 4 | sf.friend_user_id | 1 | Using where |
| 2 | DERIVED | phpfox2_friend | ref | user_id,user_check,top_friend | user_check | 4 | | 48 | Using index |
0.0001030
| Memory Before: 9.72 Mb
| Memory After: 9.72 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: No
SELECT FOUND_ROWS()
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | MISSING KEY | | | | No tables used |
0.0004382
| Memory Before: 9.96 Mb
| Memory After: 9.96 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox2_feed
AS feed
WHERE feed.view_id = 0 AND feed.user_id = 470
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | feed | ref | user_id,view_id,view_id_2 | user_id | 4 | const | 1 | Using where |
0.0006669
| Memory Before: 9.96 Mb
| Memory After: 9.96 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT feed.*, fl.feed_id
AS is_liked, u1.user_id
AS owner_user_id, u1.server_id
AS owner_server_id, u1.user_name
AS owner_user_name, u1.full_name
AS owner_full_name, u1.gender
AS owner_gender, u1.user_image
AS owner_user_image, u1.is_invisible
AS owner_is_invisible, u2.user_id
AS viewer_user_id, u2.server_id
AS viewer_server_id, u2.user_name
AS viewer_user_name, u2.full_name
AS viewer_full_name, u2.gender
AS viewer_gender, u2.user_image
AS viewer_user_image, u2.is_invisible
AS viewer_is_invisible
FROM phpfox2_feed
AS feed
JOIN phpfox2_user
AS u1
ON(u1.user_id = feed.user_id)
LEFT JOIN phpfox2_user
AS u2
ON(u2.user_id = feed.item_user_id)
LEFT JOIN phpfox2_feed_like
AS fl
ON(fl.feed_id = feed.feed_id AND fl.user_id = 0)
WHERE feed.view_id = 0 AND feed.user_id = 470
ORDER BY feed.time_stamp
DESC
LIMIT 10
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | fl | system | feed_id,feed_id_2 | MISSING KEY | | | | const row not found |
| 1 | SIMPLE | u1 | const | PRIMARY | PRIMARY | 4 | const | 1 | Using filesort |
| 1 | SIMPLE | feed | ref | user_id,view_id,view_id_2 | user_id | 4 | const | 1 | Using where |
| 1 | SIMPLE | u2 | eq_ref | PRIMARY | PRIMARY | 4 | truckel0_phpfox.feed.item_user_id | 1 | |
0.0004239
| Memory Before: 10.3 Mb
| Memory After: 10.3 Mb
| Memory Used: 1.55 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox2_video
AS m
WHERE m.in_process = 0 AND m.view_id = 0 AND m.user_id = 470
/* 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.0002310
| Memory Before: 10.39 Mb
| Memory After: 10.39 Mb
| Memory Used: 1.55 kb
| Rows: 0
| Slave: Yes
SELECT ma.name, ma.name_url, ma.year, ma.image_path, ma.server_id, ma.total_track, ma.total_play, ma.time_stamp
FROM phpfox2_music_album
AS ma
WHERE ma.view_id = 0 AND ma.user_id = 470
ORDER BY ma.time_stamp
DESC
LIMIT 4
/* 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.0008290
| Memory Before: 10.63 Mb
| Memory After: 10.63 Mb
| Memory Used: 1.55 kb
| Rows: 3
| Slave: Yes
SELECT u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, p.destination, p.server_id, p.title_url, p.title, p.mature, p.album_id, pa.name
AS album_name, pa.name_url
AS album_url
FROM phpfox2_photo
AS p
JOIN phpfox2_user
AS u
ON(u.user_id = p.user_id)
LEFT JOIN phpfox2_photo_album
AS pa
ON(pa.album_id = p.album_id)
WHERE p.view_id = 0 AND p.group_id = 0 AND p.privacy = 0 AND p.user_id = 470
ORDER BY p.time_stamp
DESC
LIMIT 3
/* 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 | p | ref | view_id,view_id_2,view_id_3,view_id_4,view_id_5,user_id | user_id | 4 | const | 12 | Using where |
| 1 | SIMPLE | pa | eq_ref | PRIMARY,album_id | PRIMARY | 4 | truckel0_phpfox.p.album_id | 1 | |
0.3319249
| Memory Before: 11.22 Mb
| Memory After: 11.22 Mb
| Memory Used: 1.55 kb
| Rows: 10
| 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 = 'profile' AND cmt.item_id = 470 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 | 48 | 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 | |
!!! So now I am medical leave while my "new" primary physican orders a ton of tests to form a medical background from which to begin working!!
Luckily, I have both short/long term disability benefits and cast-iron medical so we will see the system up close and personal....and I will blog my experiences as they develope so drop a line once a while since I suddenly have all this time on my hands
Send a Message
Add to Friends
Add to Favorites
Invite to a Group
