Luca MacGregor

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

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/)')

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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