Invitaciones a Eventos

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 ('cb2f51dd4ea8ac447cdb5375b3fed8a8', '0d574f7196f9f96e319d05681455513d', '0', '1765165280', '/fevent/view_invites/show_50', '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 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			98539	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 COUNT(m.event_id)
FROM phpfox_fevent AS m
INNER      JOIN phpfox_fevent_text AS ft
            ON(ft.event_id = m.event_id)
INNER      JOIN phpfox_fevent_invite AS ei
            ON(ei.event_id = m.event_id AND ei.rsvp_id = 0 AND ei.invited_user_id = 0)

WHERE m.view_id = 0 AND m.privacy IN(0) AND ( ( m.item_id = 0 ) )
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	ei	ref	event_id,event_id_2,invited_user_id,event_id_3,rsvp_id	invited_user_id	4	const	1	Using where
1	SIMPLE	m	eq_ref	PRIMARY,view_id,view_id_2,view_id_3,view_id_4,view_id_5	PRIMARY	4	sqlgipsol.ei.event_id	1	Using where
1	SIMPLE	ft	ref	event_id	event_id	4	sqlgipsol.ei.event_id	1	Using index

SELECT v.*, 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 v
     JOIN phpfox_user AS u
            ON(u.user_id = v.user_id)

WHERE v.view_id = 0 AND v.is_featured = 1 AND ((v.isrepeat>-1 and (v.timerepeat=0 or ( v.isrepeat>-1 and v.timerepeat>1765152000))) or ( v.isrepeat = -1 AND v.end_time >= '1765152000' ) )
ORDER BY v.start_time ASC
/* OO Query */

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

SELECT rsvp_id
FROM phpfox_fevent_invite
WHERE event_id = 10326 AND invited_user_id = 0
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent_invite	ref|filter	event_id,event_id_2,invited_user_id,event_id_3	invited_user_id|event_id	4|4	const	1 (0%)	Using where; Using rowid filter

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 COUNT(*)
FROM phpfox_fevent AS m
WHERE m.is_featured = 1 and m.view_id = 0 AND ( ( m.item_id = 0 ))
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ALL	view_id,view_id_2,view_id_3,view_id_4,view_id_5	MISSING KEY			8218	Using where

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 html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'calendario.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 = 'index.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 = '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 = '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; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'fevent' 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; Using where

SELECT 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
     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_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 html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'country-child.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