Kontzertu Solidarioa: Nazioarteko Flysch Organo Zikloa

SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session AS s
WHERE s.session_hash = '98e644126fa6bdb978f1b576b9e01fd9' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ref	session_hash,log_session	session_hash	32	const	1	Using index condition; Using where

UPDATE phpfox_log_session SET last_activity = '1787217911', user_id = '0', location = '/fevent/6969/kontzertu-solidarioa-nazioarteko-flysch-organo-zikloa/', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.217.42', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = '98e644126fa6bdb978f1b576b9e01fd9'

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_log_session	ref	session_hash,log_session	session_hash	32	const	1	Using index condition

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 MAX(`time_stamp`)
FROM phpfox_fevent_cron AS s
WHERE 1=1 AND `type_cron` = 'for_repeat'
LIMIT 1
/* OO Query */

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

SELECT p.page_id
FROM phpfox_pages AS p
     JOIN phpfox_like AS l
            ON(l.user_id = 0 AND l.`type_id` = 'pages' AND l.`item_id` = p.page_id)

WHERE p.view_id = 0
/* 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 index condition
1	SIMPLE	p	eq_ref	PRIMARY,view_id_2,view_id,page_id	PRIMARY	4	sqlgipsol.l.item_id	1	Using where

SELECT MAX(`time_stamp`)
FROM phpfox_fevent_cron AS s
WHERE 1=1 AND `type_cron` = 'for_repeat'
LIMIT 1
/* OO Query */

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

SELECT l.like_id AS is_liked, f.friend_id AS is_friend, e.*, et.description_parsed AS description, 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_fevent AS e
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'fevent' AND l.item_id = e.event_id AND l.user_id = 0)
     LEFT JOIN phpfox_friend AS f
            ON(f.user_id = e.user_id AND f.friend_user_id = 0)
     JOIN phpfox_user AS u
            ON(u.user_id = e.user_id)
     JOIN phpfox_fevent_text AS et
            ON(et.event_id = e.event_id)

WHERE e.event_id = 6969
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	e	const	PRIMARY,user_id	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY,user_id	PRIMARY	4	const	1
1	SIMPLE	l	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	friend_user_id|user_id	4|4	const	1 (0%)	Using where; Using rowid filter
1	SIMPLE	et	ref	event_id	event_id	4	const	1

SELECT cv.value, cf.phrase_var_name
FROM phpfox_fevent_custom_value AS cv
INNER      JOIN phpfox_fevent_custom_field AS cf
            ON(cf.field_id = cv.field_id)

WHERE cv.event_id = 6969 AND cf.is_active = 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 pc.parent_id, pc.category_id, pc.name
FROM phpfox_fevent_category_data AS pcd
     JOIN phpfox_fevent_category AS pc
            ON(pc.category_id = pcd.category_id)

WHERE pcd.event_id = 6969
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	pcd	ref	category_id,event_id	event_id	4	const	1	Using temporary; Using filesort
1	SIMPLE	pc	eq_ref	PRIMARY	PRIMARY	3	sqlgipsol.pcd.category_id	1	Using index condition

UPDATE phpfox_fevent
SET total_view = total_view + 1
WHERE event_id = 6969

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent	const	PRIMARY	PRIMARY	4	const	1

SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 6969 AND 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

SELECT event_id, image_path
FROM phpfox_fevent
WHERE end_time < 1735689600 AND image_path != "" AND image_path != "af9e5ac6fdf7acdeabaaebb4e50a5d84%s.jpg"
/* OO Query */

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

UPDATE phpfox_cron SET next_run = '1787217911', last_run = '1787217911' WHERE cron_id = 5

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

INSERT INTO phpfox_cron_log (cron_id, time_stamp) VALUES ('5', '1787217911')

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 = 'block' AND module_id = 'core' AND name = 'template-menusub.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 image_id, image_path, server_id
FROM phpfox_fevent_image
WHERE event_id = 6969
ORDER BY ordering ASC

/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_image	ref	listing_id	listing_id	4	const	1	Using where; Using filesort

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'fevent' AND name = 'image.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 *
FROM phpfox_fevent_category
WHERE parent_id=0
ORDER BY ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_category	ALL	parent_id	MISSING KEY			9	Using where; Using filesort

SELECT *
FROM phpfox_fevent_category
WHERE parent_id=7
ORDER BY ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_category	ref	parent_id	parent_id	3	const	1	Using where; Using filesort

SELECT *
FROM phpfox_fevent_category
WHERE parent_id=10
ORDER BY ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_category	ref	parent_id	parent_id	3	const	1	Using where; Using filesort

SELECT *
FROM phpfox_fevent_category
WHERE parent_id=2
ORDER BY ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_category	ref	parent_id	parent_id	3	const	1	Using where; Using filesort

SELECT *
FROM phpfox_fevent_category
WHERE parent_id=1
ORDER BY ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_category	ref	parent_id	parent_id	3	const	1	Using where; Using filesort

SELECT *
FROM phpfox_fevent_category
WHERE parent_id=8
ORDER BY ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_category	ref	parent_id	parent_id	3	const	1	Using where; Using filesort

SELECT *
FROM phpfox_fevent_category
WHERE parent_id=21
ORDER BY ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_category	ref	parent_id	parent_id	3	const	1	Using where; Using filesort

SELECT *
FROM phpfox_fevent_category
WHERE parent_id=5
ORDER BY ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_category	ref	parent_id	parent_id	3	const	1	Using where; Using filesort

SELECT *
FROM phpfox_fevent_category
WHERE parent_id=4
ORDER BY ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_category	ref	parent_id	parent_id	3	const	1	Using where; Using filesort

SELECT *
FROM phpfox_fevent_category
WHERE parent_id=22
ORDER BY ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_category	ref	parent_id	parent_id	3	const	1	Using where; Using filesort

SELECT *
FROM phpfox_fevent_category
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_category	ALL		MISSING KEY			9

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.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 = 'fevent' AND name = 'category.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 = 'fevent' AND name = 'category.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 = 'fevent' 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 = 'fevent' AND name = 'info.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 = "fevent" AND item_id = 6969 AND user_id = 0
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_action	ref	type_id,type_id_2,type_id_3,item_id	item_id	4	const	1	Using where

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 = "fevent")

WHERE (l.type_id = 'fevent' OR l.type_id = 'fevent') AND l.item_id = 6969
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	l	ref|filter	type_id,type_id_2,type_id_3,item_id	item_id|type_id_3	4|77	const	1 (8%)	Using where; Using temporary; Using filesort; Using rowid filter
1	SIMPLE	a	ref	type_id,type_id_2,type_id_3,item_id	item_id	4	const	1	Using where
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 = "fevent" AND a.item_id = 6969
GROUP BY u.user_id
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	type_id,type_id_2,type_id_3,item_id	type_id_2	81	const,const	1	Using where; Using index
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.a.user_id	1

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 feed.*, 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, u.view_id
FROM phpfox_fevent_feed AS feed
     JOIN phpfox_user AS u
            ON(u.user_id = feed.user_id)

WHERE feed.parent_user_id = 6969
ORDER BY feed.time_update DESC
LIMIT 4
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	feed	ref	parent_user_id	parent_user_id	4	const	1	Using where; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.feed.user_id	1

SELECT photo.*, l.like_id AS is_liked, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name
FROM phpfox_photo AS photo
     JOIN phpfox_photo_info AS pi
            ON(pi.photo_id = photo.photo_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
     LEFT JOIN phpfox_photo_feed AS pfeed
            ON(pfeed.feed_id = 155)
     LEFT JOIN phpfox_photo_album AS pa
            ON(pa.album_id = photo.album_id)

WHERE photo.photo_id = 4461
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	photo	const	PRIMARY,photo_id,photo_id_2	PRIMARY	4	const	1
1	SIMPLE	pi	const	photo_id	photo_id	4	const	1
1	SIMPLE	l	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	pfeed	ref	feed_id	feed_id	4	const	1
1	SIMPLE	pa	eq_ref	PRIMARY,album_id	PRIMARY	4	const	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 = 4461
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	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 temporary; Using filesort; Using rowid filter
1	SIMPLE	a	ref	type_id,type_id_2,type_id_3,item_id	item_id	4	const	1	Using where
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.l.user_id	1

SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 4461
LIMIT 1
/* 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	81	const,const	1	Using where; 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, 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 = 4461
GROUP BY u.user_id
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	type_id,type_id_2,type_id_3,item_id	type_id_2	81	const,const	1	Using where; Using index
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.a.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 = 4461
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 = 4461
GROUP BY u.user_id
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	type_id,type_id_2,type_id_3,item_id	type_id_2	81	const,const	1	Using where; Using index
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.a.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_user AS u
WHERE user_id IN (6969)
/* 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_feed
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE				MISSING KEY				Select tables optimized away

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.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 = 'fevent' 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 = 'fevent' 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 = 'feed' AND name = 'entry.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 = 'content.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 = '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 = '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