IMG-20190325-WA0009

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 ('80ea6a62ff8f267331e17fac4b0df670', '0d574f7196f9f96e319d05681455513d', '0', '1765172498', '/photo/3653/img-20190325-wa0009', '0', '0', '0', '216.73.216.221', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.')

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	sqlgipsol.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 lik.like_id AS is_liked, f.friend_id AS is_friend, 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, u.last_activity, p.*, pi.*, pa.name AS album_url, pa.name AS album_title, pa.profile_id AS album_profile_id, pt.item_id AS is_viewed
FROM phpfox_photo AS p
     LEFT JOIN phpfox_like AS lik
            ON(lik.type_id = 'photo' AND lik.item_id = p.photo_id AND lik.user_id = 0)
     LEFT JOIN phpfox_friend AS f
            ON(f.user_id = p.user_id AND f.friend_user_id = 0)
     JOIN phpfox_user AS u
            ON(u.user_id = p.user_id)
     LEFT JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = p.photo_id)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = p.album_id)
     LEFT JOIN phpfox_photo_track AS pt
            ON(pt.item_id = p.photo_id AND pt.user_id = 0)

WHERE p.photo_id = 3653
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	const	PRIMARY,photo_id,photo_id_2	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY,user_id	PRIMARY	4	const	1
1	SIMPLE	pi	const	photo_id	photo_id	4	const	1
1	SIMPLE	pa	const	PRIMARY,album_id	PRIMARY	4	const		Unique row not found
1	SIMPLE	lik	ref|filter	type_id,type_id_2,type_id_3,item_id	type_id_3|item_id	81|4	const,const	1 (1%)	Using where; Using rowid filter
1	SIMPLE	f	ref|filter	user_check,user_id,top_friend,friend_user_id	user_id|friend_user_id	4|4	const	1 (0%)	Using where; Using rowid filter
1	SIMPLE	pt	ref	item_id	item_id	8	const,const	1	Using index

SELECT tag_id, item_id, tag_text, tag_url
FROM phpfox_tag
WHERE item_id = 3653 AND category_id = 'photo'
ORDER BY tag_id ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_tag	ref	item_id,category_id,user_search,user_search_general,item_id_2,item_id_3,category_id_2	item_id	81	const,const	1	Using index condition; Using where; Using filesort

SELECT pc.parent_id, pc.category_id, pc.name
FROM phpfox_photo_category_data AS pcd
     JOIN phpfox_photo_category AS pc
            ON(pc.category_id = pcd.category_id)

WHERE pcd.photo_id = 3653
ORDER BY pc.parent_id ASC, pc.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 COUNT(*)
FROM phpfox_photo AS photo
     JOIN phpfox_user AS u
            ON(u.user_id = photo.user_id)

WHERE photo.photo_id > 3653 AND photo.group_id = 0 AND photo.type_id = 0 AND ((photo.privacy = 0) AND photo.privacy = 0 AND photo.view_id = 0)
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	index	PRIMARY,user_id	user_status	1		347	Using index
1	SIMPLE	photo	ref|filter	PRIMARY,photo_id,view_id_2,photo_id_2,view_id,privacy,view_id_3,view_id_4,view_id_5	view_id_3|PRIMARY	10|4	const,const,const,sqlgipsol.u.user_id	4 (38%)	Using where; Using rowid filter

SELECT photo.*
FROM phpfox_photo AS photo
     JOIN phpfox_user AS u
            ON(u.user_id = photo.user_id)

WHERE photo.photo_id > 3653 AND photo.group_id = 0 AND photo.type_id = 0 AND ((photo.privacy = 0) AND photo.privacy = 0 AND photo.view_id = 0)
ORDER BY photo.photo_id ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	photo	ALL	PRIMARY,photo_id,view_id_2,photo_id_2,view_id,privacy,view_id_3,view_id_4,view_id_5	MISSING KEY			2715	Using where; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.photo.user_id	1	Using index

SELECT COUNT(*)
FROM phpfox_photo AS photo
     JOIN phpfox_user AS u
            ON(u.user_id = photo.user_id)

WHERE photo.photo_id < 3653 AND photo.group_id = 0 AND photo.type_id = 0 AND ((photo.privacy = 0) AND photo.privacy = 0 AND photo.view_id = 0)
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	index	PRIMARY,user_id	user_status	1		347	Using index
1	SIMPLE	photo	ref	PRIMARY,photo_id,view_id_2,photo_id_2,view_id,privacy,view_id_3,view_id_4,view_id_5	view_id_3	10	const,const,const,sqlgipsol.u.user_id	4	Using where

SELECT photo.*
FROM phpfox_photo AS photo
     JOIN phpfox_user AS u
            ON(u.user_id = photo.user_id)

WHERE photo.photo_id < 3653 AND photo.group_id = 0 AND photo.type_id = 0 AND ((photo.privacy = 0) AND photo.privacy = 0 AND photo.view_id = 0)
ORDER BY photo.photo_id DESC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	photo	ALL	PRIMARY,photo_id,view_id_2,photo_id_2,view_id,privacy,view_id_3,view_id_4,view_id_5	MISSING KEY			2715	Using where; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.photo.user_id	1	Using index

SELECT p.user_id AS photo_owner_id, pt.tag_id, pt.user_id AS post_user_id, pt.content, pt.position_x, pt.position_y, pt.width, pt.height, 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, u.last_activity
FROM phpfox_photo_tag AS pt
     LEFT JOIN phpfox_user AS u
            ON(u.user_id = pt.tag_user_id)
     JOIN phpfox_photo AS p
            ON(p.photo_id = pt.photo_id)

WHERE pt.photo_id = 3653
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	const	PRIMARY,photo_id,photo_id_2	PRIMARY	4	const	1
1	SIMPLE	pt	ref	photo_id,photo_id_2,photo_id_3,photo_id_4	photo_id	4	const	1
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.pt.tag_user_id	1

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'template.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'cabecera.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'breadcrumb.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-breadcrumblist.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-breadcrumbmenu.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-contentclass.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'controller' AND module_id = 'photo' AND name = 'view.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'photo' AND name = 'detail.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT action_id
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "photo" AND item_id = 3653 AND user_id = 0
LIMIT 1
/* 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 l.like_id AS is_liked, c.*, ct.text_parsed AS text, 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, u.last_activity
FROM phpfox_comment AS c
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'feed_mini' AND l.item_id = c.comment_id AND l.user_id = 0)
     JOIN phpfox_comment_text AS ct
            ON(ct.comment_id = c.comment_id)
     JOIN phpfox_user AS u
            ON(u.user_id = c.user_id)

WHERE c.parent_id = 0 AND c.type_id = 'photo' AND c.item_id = 3653 AND c.view_id = 0
ORDER BY c.time_stamp DESC
LIMIT 10
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	c	ref	PRIMARY,user_id,type_id,parent_id,parent_id_2,view_id	type_id	82	const,const,const	1	Using index condition; Using where; Using filesort
1	SIMPLE	l	ref	type_id,type_id_2,type_id_3,item_id	type_id_3	81	const,const	1	Using where
1	SIMPLE	ct	ref	comment_id	comment_id	4	sqlgipsol.c.comment_id	1
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.c.user_id	1

SELECT l.*, 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, u.last_activity, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)
     LEFT JOIN phpfox_action AS a
            ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "photo")

WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 3653
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	system	type_id,type_id_2,type_id_3,item_id	MISSING KEY				Const row not found; Using temporary; Using filesort
1	SIMPLE	l	ref|filter	type_id,type_id_2,type_id_3,item_id	item_id|type_id_3	4|77	const	1 (3%)	Using where; Using rowid filter
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.l.user_id	1

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, u.last_activity
FROM phpfox_like AS l
     JOIN phpfox_user AS u
            ON(u.user_id = l.user_id)

WHERE l.type_id = 'photo' AND l.item_id = 3653
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* 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_2	81	const,const	1	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.l.user_id	1

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, u.last_activity
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo" AND a.item_id = 3653
GROUP BY u.user_id
/* 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 html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'comment.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'share' AND name = 'link.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'comment' AND name = 'mini.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'link.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'captcha' AND name = 'form.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where