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 ('1b5b2b941b83d47dd927a4238b1f166f', 'd0b63444099757fedc3d79aa837e804c', '0', '1257586799', '', '0', '0', '0', '38.107.191.117', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)')

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 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	system		MISSING KEY			1
1	SIMPLE	t	system	PRIMARY,theme_id	MISSING KEY			1

SELECT cf.*
FROM phpfox_custom_field AS cf
WHERE cf.type_id IN('user_main','user_panel','profile_panel') AND cf.user_group_id = 0 AND cf.on_signup = 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	cf	ALL		MISSING KEY			16	Using where

UPDATE phpfox_ad SET count_view = count_view + '1' WHERE ad_id = 1

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	const	PRIMARY	PRIMARY	3	const	1

SELECT u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_user AS u
WHERE u.user_image IS NOT NULL
ORDER BY RAND()
LIMIT 4
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	range	user_image	user_image	53		21188	Using where; Using temporary; Using filesort

UPDATE phpfox_ad SET count_view = count_view + '1' WHERE ad_id = 3

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	const	PRIMARY	PRIMARY	3	const	1

SELECT sp.*
FROM phpfox_subscribe_package AS sp
WHERE sp.is_active = 1 AND sp.is_registration = 1
ORDER BY sp.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

SELECT var_name, user_value
FROM phpfox_component_setting
WHERE user_id = 0
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_component_setting	ref	user_id,user_id_2	user_id	4	const	1

SELECT b.blog_id, b.time_stamp, b.title, b.title_url, u.user_id, u.server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible
FROM phpfox_blog AS b
     JOIN phpfox_user AS u
            ON(u.user_id = b.user_id)

WHERE b.is_approved = 1 AND b.privacy = 1 AND b.post_status = 1
ORDER BY b.time_stamp DESC
LIMIT 3
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	b	range	public_view,user_id,my_blogs,profile_user,profile_guest	public_view	3		282	Using where; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	f0xysp4c3db.b.user_id	1