8-Promover el crecimiento económico sostenido, inclusivo y sostenible, el empleo pleno y productivo y el trabajo decente para todas las personas

SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session AS s
WHERE s.session_hash = '99e307957f8bb67558588a4bfd5609b4' 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 = '1765274454', user_id = '0', location = '/document/category/8/8-promover-el-crecimiento-económico-sostenido-inclusivo-y-sostenible-el-emp/show_12', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.221', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = '99e307957f8bb67558588a4bfd5609b4'

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 COUNT(*)
FROM phpfox_document AS m
INNER      JOIN phpfox_document_category_data AS mcd
            ON(mcd.document_id = m.document_id)

WHERE m.is_approved = 1 AND m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND mcd.category_id = 8
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	mcd	ref	category_id,document_id	category_id	4	const	185
1	SIMPLE	m	eq_ref	PRIMARY,in_process,document_id_2,in_process_2,in_process_3,in_process_4,in_process_5,document_id,document_id_3	PRIMARY	4	sqlgipsol.mcd.document_id	1	Using where

SELECT dt.*, m.*, 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_document AS m
INNER      JOIN phpfox_document_category_data AS mcd
            ON(mcd.document_id = m.document_id)
     JOIN phpfox_document_text AS dt
            ON(dt.document_id = m.document_id)
     JOIN phpfox_user AS u
            ON(u.user_id = m.user_id)

WHERE m.is_approved = 1 AND m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND mcd.category_id = 8
GROUP BY m.document_id
ORDER BY m.time_stamp DESC
LIMIT 12
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	dt	ALL		MISSING KEY			714	Using temporary; Using filesort
1	SIMPLE	m	eq_ref	PRIMARY,user_id,in_process,document_id_2,in_process_2,in_process_3,in_process_4,in_process_5,document_id,document_id_3,view_id_4	PRIMARY	4	sqlgipsol.dt.document_id	1	Using where
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.m.user_id	1
1	SIMPLE	mcd	ref|filter	category_id,document_id	document_id|category_id	4|4	sqlgipsol.dt.document_id	1 (25%)	Using index condition; Using where; Using rowid filter

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
     JOIN phpfox_document_category AS pc
            ON(pc.category_id = pcd.category_id)

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

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 = '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 = '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 = 'document' 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 = 'block' AND module_id = 'document' 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 = 'document' 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 = 'document' 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 = 'document' 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 = 'document' 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 = 'document' 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 = 'document' 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 = 'document' 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 = 'document' 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 = 'document' 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 = 'document' 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 = 'document' 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 = 'layout' AND name = 'pager.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 d.*, 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_document AS d
     JOIN phpfox_user AS u
            ON(u.user_id = d.user_id)

WHERE d.is_approved = 1 AND d.view_id = 0 AND d.module_id = 'document' AND d.item_id = 0 AND d.privacy = 0 AND d.is_featured = 1
LIMIT 4
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	d	ref	view_id,user_id,in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,view_id_4	in_process	1	const	668	Using where
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.d.user_id	1

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 = 'document' AND name = 'featured.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 = 'document' AND name = 'featured.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 count(*) as total_documents, sum(m.total_view) as total_views, sum(m.total_like) as total_likes
FROM phpfox_document AS m
     JOIN phpfox_document_category_data AS dcd
            ON(m.document_id = dcd.document_id)

WHERE m.in_process = 0 AND m.view_id = 0 AND m.module_id = 'document' AND m.item_id = 0 AND m.privacy IN(0) AND dcd.category_id = 8
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	dcd	ALL	category_id,document_id	MISSING KEY			728	Using where
1	SIMPLE	m	eq_ref	PRIMARY,view_id,document_id_2,view_id_2,document_id,document_id_3	PRIMARY	4	sqlgipsol.dcd.document_id	1	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 = 'base5' AND module_id = 'document' AND name = 'block/statistic.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 = 'document' AND name = 'block/statistic.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_document AS m
     JOIN phpfox_user AS u
            ON(m.user_id = u.user_id)
     JOIN phpfox_document_category_data AS dcd
            ON(m.document_id = dcd.document_id)

WHERE m.in_process = 0 AND m.is_approved=1 AND m.view_id = 0 AND m.module_id = 'document' AND m.item_id = 0 AND m.privacy IN(0) AND dcd.category_id = 8
ORDER BY m.total_view DESC
LIMIT 4
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	dcd	range	category_id,document_id	category_id	4		185	Using index condition; Using temporary; Using filesort
1	SIMPLE	m	eq_ref	PRIMARY,view_id,user_id,in_process,document_id_2,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,document_id,document_id_3,view_id_4	PRIMARY	4	sqlgipsol.dcd.document_id	1	Using where
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.m.user_id	1

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 = 'document' AND name = 'topview.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 = 'document' AND name = 'topview.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 d.*, 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_document AS d
     JOIN phpfox_user AS u
            ON(u.user_id = d.user_id)

WHERE d.is_approved = 1 AND d.view_id = 0 AND d.module_id = 'document' AND d.item_id = 0 AND d.privacy = 0
ORDER BY d.total_comment DESC
LIMIT 4
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	d	range	view_id,user_id,in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_2,view_id_4	in_process	1		668	Using index condition; Using where; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.d.user_id	1

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 = 'document' AND name = 'mostdiscussed.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 = 'document' AND name = 'mostdiscussed.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