0.0001521
| Memory Before: 442.43 kb
| Memory After: 443.94 kb
| Memory Used: 1.51 kb
| Rows: 1
| Slave: No
SELECT value_actual
FROM phpfox_setting
WHERE var_name = 'phpfox_version'
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | phpfox_setting | ref | var_name | var_name | 102 | const | 1 | Using where |
0.0022900
| Memory Before: 738.34 kb
| Memory After: 739.69 kb
| Memory Used: 1.35 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('afecde98bb9b262ae24f3c78816e0944', 'c56fb43d525078d2aaf85f739d93f298', '0', '1550614045', '/profile-11443/info/', '0', '0', '0', '3.82.52.91', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0001500
| Memory Before: 872.88 kb
| Memory After: 874.39 kb
| Memory Used: 1.51 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, t.total_column, s.l_width, s.c_width, s.r_width
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 | phpfoxfb.s.theme_id | 1 | |
0.0001149
| Memory Before: 876.22 kb
| Memory After: 877.73 kb
| Memory Used: 1.51 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 | const | style_id_2,style_id | style_id_2 | 2 | const | 1 | |
0.0026152
| Memory Before: 1.13 Mb
| Memory After: 1.13 Mb
| Memory Used: 1.51 kb
| Rows: 1
| Slave: Yes
SELECT ur.rate_id
AS has_rated, p.photo_id as cover_photo_exists, 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.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id
AS theme_parent_id, ug.prefix, ug.suffix, ug.icon_ext, ug.title, uf.user_id as is_featured
FROM phpfox_user
AS u
LEFT JOIN phpfox_user_rating
AS ur
ON(ur.item_id = u.user_id AND ur.user_id = 0)
JOIN phpfox_user_group
AS ug
ON(ug.user_group_id = u.user_group_id)
JOIN phpfox_user_space
AS user_space
ON(user_space.user_id = u.user_id)
JOIN phpfox_user_field
AS user_field
ON(user_field.user_id = u.user_id)
JOIN phpfox_user_activity
AS user_activity
ON(user_activity.user_id = u.user_id)
LEFT JOIN phpfox_theme_style
AS ts
ON(ts.style_id = user_field.designer_style_id AND ts.is_active = 1)
LEFT JOIN phpfox_theme
AS t
ON(t.theme_id = ts.theme_id)
LEFT JOIN phpfox_user_featured
AS uf
ON(uf.user_id = u.user_id)
LEFT JOIN phpfox_log_session
AS ls
ON(ls.user_id = u.user_id AND ls.im_hide = 0)
LEFT JOIN phpfox_photo
AS p
ON(p.photo_id = user_field.cover_photo)
WHERE u.user_name = 'profile-11443'
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | u | ref | PRIMARY,user_name,user_group_id,user_id | user_name | 103 | const | 1 | Using where |
1 | SIMPLE | ur | ref | item_id,item_id_2 | item_id | 8 | phpfoxfb.u.user_id,const | 1 | Using index |
1 | SIMPLE | ug | eq_ref | PRIMARY,user_group_id | PRIMARY | 1 | phpfoxfb.u.user_group_id | 1 | Using where |
1 | SIMPLE | user_field | eq_ref | user_id | user_id | 4 | phpfoxfb.u.user_id | 1 | |
1 | SIMPLE | ts | eq_ref | style_id_2,style_id,is_active | style_id_2 | 2 | phpfoxfb.user_field.designer_style_id | 1 | |
1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | phpfoxfb.ts.theme_id | 1 | |
1 | SIMPLE | uf | eq_ref | PRIMARY | PRIMARY | 4 | phpfoxfb.user_field.user_id | 1 | Using index |
1 | SIMPLE | ls | ref | user_id,user_id_2,user_id_3 | user_id | 5 | phpfoxfb.user_field.user_id,const | 401 | Using index |
1 | SIMPLE | p | eq_ref | PRIMARY,photo_id,photo_id_2 | PRIMARY | 4 | phpfoxfb.user_field.cover_photo | 1 | Using index |
1 | SIMPLE | user_space | eq_ref | user_id | user_id | 4 | phpfoxfb.u.user_id | 1 | |
1 | SIMPLE | user_activity | eq_ref | user_id | user_id | 4 | phpfoxfb.user_field.user_id | 1 | Using where |
0.0001669
| Memory Before: 1.53 Mb
| Memory After: 1.53 Mb
| Memory Used: 1.51 kb
| Rows: 13
| Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 11443
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | phpfox_user_privacy | ref | user_id,user_id_2 | user_id | 4 | const | 13 | |
0.0001349
| Memory Before: 1.56 Mb
| Memory After: 1.56 Mb
| Memory Used: 1.51 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_user_blocked
WHERE user_id = 11443 AND block_user_id = 0
LIMIT 1
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | phpfox_user_blocked | ref | user_id,user_id_2 | user_id | 8 | const,const | 1 | Using index |
0.0001619
| Memory Before: 1.88 Mb
| Memory After: 1.88 Mb
| Memory Used: 1.51 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_user_design_order
WHERE user_id = 11443
ORDER BY ordering ASC
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | phpfox_user_design_order | ref | user_id | user_id | 4 | const | 1 | Using where; Using filesort |
0.0001431
| Memory Before: 2.12 Mb
| Memory After: 2.12 Mb
| Memory Used: 1.51 kb
| Rows: 1
| Slave: No
SELECT groupid
FROM phpfox_user
WHERE user_name like 'profile-11443'
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | phpfox_user | range | user_name | user_name | 103 | | 1 | Using where |
0.0001478
| Memory Before: 2.48 Mb
| Memory After: 2.48 Mb
| Memory Used: 1.51 kb
| Rows: 1
| Slave: No
SELECT groupid
FROM phpfox_user
WHERE user_name like 'profile-11443'
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | phpfox_user | range | user_name | user_name | 103 | | 1 | Using where |
0.0002298
| Memory Before: 2.63 Mb
| Memory After: 2.63 Mb
| Memory Used: 1.51 kb
| Rows: 0
| Slave: Yes
SELECT cf.*, cmv.option_id as customValue, co.phrase_var_name as phrase_chosen
FROM phpfox_custom_field
AS cf
JOIN phpfox_module
AS m
ON(m.module_id = cf.module_id AND m.is_active = 1)
JOIN phpfox_user_custom_multiple_value
AS cmv
ON(cmv.field_id = cf.field_id)
JOIN phpfox_custom_option
AS co
ON(co.option_id = cmv.option_id)
WHERE cf.type_id = "user_panel" AND cmv.user_id = 11443 AND cf.type_id = "user_main"
ORDER BY cf.ordering ASC
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | | | | MISSING KEY | | | | Impossible WHERE |
0.0001280
| Memory Before: 2.66 Mb
| Memory After: 2.66 Mb
| Memory Used: 1.51 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 11443
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | phpfox_user_custom | const | user_id | user_id | 4 | const | 1 | |
0.0001192
| Memory Before: 2.67 Mb
| Memory After: 2.67 Mb
| Memory Used: 1.51 kb
| Rows: 0
| Slave: Yes
SELECT co.phrase_var_name
FROM phpfox_custom_option
AS co
JOIN phpfox_user_custom_multiple_value
AS cmv
ON(cmv.option_id = co.option_id)
WHERE cmv.field_id = 6 AND cmv.user_id = 11443
LIMIT 1
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | cmv | ref | user_id | user_id | 6 | const,const | 1 | |
1 | SIMPLE | co | eq_ref | PRIMARY | PRIMARY | 2 | phpfoxfb.cmv.option_id | 1 | |
0.0000782
| Memory Before: 2.67 Mb
| Memory After: 2.68 Mb
| Memory Used: 1.51 kb
| Rows: 0
| Slave: Yes
SELECT co.phrase_var_name
FROM phpfox_custom_option
AS co
JOIN phpfox_user_custom_multiple_value
AS cmv
ON(cmv.option_id = co.option_id)
WHERE cmv.field_id = 7 AND cmv.user_id = 11443
LIMIT 1
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | cmv | ref | user_id | user_id | 6 | const,const | 1 | |
1 | SIMPLE | co | eq_ref | PRIMARY | PRIMARY | 2 | phpfoxfb.cmv.option_id | 1 | |
0.0000999
| Memory Before: 2.68 Mb
| Memory After: 2.69 Mb
| Memory Used: 1.51 kb
| Rows: 0
| Slave: Yes
SELECT mg.genre_id, mg.name, mg.name_url, mgu.order_id
FROM phpfox_music_genre_user
AS mgu
JOIN phpfox_music_genre
AS mg
ON(mg.genre_id = mgu.genre_id)
WHERE mgu.user_id = 11443
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | mgu | ref | user_id | user_id | 4 | const | 1 | |
1 | SIMPLE | mg | eq_ref | PRIMARY | PRIMARY | 2 | phpfoxfb.mgu.genre_id | 1 | |
0.0002589
| Memory Before: 3.59 Mb
| Memory After: 3.59 Mb
| Memory Used: 1.57 kb
| Rows: 0
| Slave: Yes
SELECT p.*, pu.vanity_url, u.user_id, u.profile_page_id, u.server_id
AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id
FROM phpfox_like
AS l
JOIN phpfox_pages
AS p
ON(p.page_id = l.item_id AND p.view_id = 0)
JOIN phpfox_user
AS u
ON(u.profile_page_id = p.page_id)
LEFT JOIN phpfox_pages_url
AS pu
ON(pu.page_id = p.page_id)
WHERE l.type_id = 'pages' AND l.user_id = 11443
GROUP BY p.page_id
ORDER BY l.time_stamp
DESC
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | l | ref | type_id,type_id_2,type_id_3,item_id | type_id_3 | 81 | const,const | 1 | Using where; Using temporary; Using filesort |
1 | SIMPLE | p | eq_ref | PRIMARY,view_id_2,view_id,page_id | PRIMARY | 4 | phpfoxfb.l.item_id | 1 | Using where |
1 | SIMPLE | pu | ref | page_id | page_id | 4 | phpfoxfb.p.page_id | 1 | |
1 | SIMPLE | u | ref | page_id | page_id | 4 | phpfoxfb.p.page_id | 19271 | Using where |
0.0001900
| Memory Before: 3.65 Mb
| Memory After: 3.65 Mb
| Memory Used: 1.51 kb
| Rows: 0
| Slave: Yes
SELECT count(f.user_id)
FROM phpfox_friend
AS f
JOIN phpfox_friend
AS sf
ON(sf.friend_user_id = f.friend_user_id AND sf.user_id = 11443)
JOIN phpfox_user
AS u
ON(u.user_id = f.friend_user_id)
WHERE f.is_page = 0 AND f.user_id = 0
GROUP BY f.friend_user_id
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | f | ref | user_check,user_id,top_friend,friend_user_id,is_page,is_page_2 | user_check | 4 | const | 1 | Using where |
1 | SIMPLE | sf | eq_ref | user_check,user_id,top_friend,friend_user_id | user_check | 8 | const,phpfoxfb.f.friend_user_id | 1 | Using index |
1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | phpfoxfb.f.friend_user_id | 1 | Using index |
0.0001149
| Memory Before: 3.65 Mb
| Memory After: 3.65 Mb
| Memory Used: 1.51 kb
| Rows: 0
| Slave: Yes
SELECT u.user_id, u.profile_page_id, u.server_id
AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id
FROM phpfox_friend
AS f
JOIN phpfox_friend
AS sf
ON(sf.friend_user_id = f.friend_user_id AND sf.user_id = 11443)
JOIN phpfox_user
AS u
ON(u.user_id = f.friend_user_id)
WHERE f.is_page = 0 AND f.user_id = 0
GROUP BY f.friend_user_id
ORDER BY f.time_stamp
DESC
LIMIT 7
/* OO Query */
Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | f | ref | user_check,user_id,top_friend,friend_user_id,is_page,is_page_2 | user_check | 4 | const | 1 | Using where; Using temporary; Using filesort |
1 | SIMPLE | sf | eq_ref | user_check,user_id,top_friend,friend_user_id | user_check | 8 | const,phpfoxfb.f.friend_user_id | 1 | Using index |
1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | phpfoxfb.f.friend_user_id | 1 | |