Hirritarron harrera sarea nº 5

SELECT p.call_name, p.php_code
FROM phpfox_plugin AS p
     JOIN phpfox_product AS product
            ON(p.product_id = product.product_id AND product.is_active = 1)
     JOIN phpfox_plugin_hook AS ph
            ON(ph.call_name = p.call_name AND ph.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = p.module_id AND m.is_active = 1)

WHERE p.is_active = 1
ORDER BY p.ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	ALL	is_active	MISSING KEY			5	Using where; Using filesort
1	SIMPLE	ph	ref	call_name	call_name	258	sqlgipsol.p.call_name,const	1	Using where; Using index
1	SIMPLE	product	ref	is_active,product_active,product_id	product_active	28	sqlgipsol.p.product_id,const	3	Using index
1	SIMPLE	m	ref	is_active,module_id,module_is_active	module_is_active	78	sqlgipsol.p.module_id,const	8	Using index

SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session AS s
WHERE s.session_hash = '6905d05c3eec849c90c75728cd01cb27' 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 = '1769445533', user_id = '0', location = '/mobile/document/category/29/hirritarron-harrera-sarea-nº-5', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.178', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = '6905d05c3eec849c90c75728cd01cb27'

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 i.*, io.phrase_var as option_phrase_var
FROM phpfox_input_field AS i
     LEFT JOIN phpfox_input_option AS io
            ON(io.field_id = i.field_id)

WHERE module_id = "document"
/* 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_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 = 29
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	2
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 = 29
GROUP BY m.document_id
ORDER BY m.time_stamp DESC
LIMIT 9
/* 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	2	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.mcd.document_id	1	Using where
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.m.user_id	1
1	SIMPLE	dt	ALL		MISSING KEY			729	Using where; Using join buffer (flat, BNL join)

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 = 869
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 category_id
FROM phpfox_document_category
WHERE category_id = '29'
LIMIT 1
/* OO Query */

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

SELECT pc.category_id, pc.parent_id
FROM phpfox_document_category AS pc
WHERE pc.category_id = 29
/* OO Query */

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

SELECT pc.category_id, pc.parent_id
FROM phpfox_document_category AS pc
WHERE pc.category_id = 9
/* OO Query */

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

SELECT pc.category_id, pc.parent_id
FROM phpfox_document_category AS pc
WHERE pc.category_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 *
FROM phpfox_document_category
WHERE category_id IN(29,9)
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_document_category	range	PRIMARY	PRIMARY	3		2	Using index condition

SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'document.index' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ref	product_id,m_connection,parent_id	m_connection	79	const,const	1	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	p	ref	is_active,product_active,product_id	product_active	28	sqlgipsol.m.product_id,const	3	Using index
1	SIMPLE	mo	ref	is_active,module_id,module_is_active	module_is_active	78	sqlgipsol.m.module_id,const	8	Using index

SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'document' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ref	product_id,m_connection,parent_id	m_connection	79	const,const	1	Using index condition; Using where; Using temporary; Using filesort
1	SIMPLE	p	ref	is_active,product_active,product_id	product_active	28	sqlgipsol.m.product_id,const	3	Using index
1	SIMPLE	mo	ref	is_active,module_id,module_is_active	module_is_active	78	sqlgipsol.m.module_id,const	8	Using index

SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
            ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
            ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ALL	product_id,parent_id	MISSING KEY			210	Using where; Using filesort
1	SIMPLE	p	ref	is_active,product_active,product_id	product_active	28	sqlgipsol.m.product_id,const	3	Using index
1	SIMPLE	mo	ref	is_active,module_id,module_is_active	module_is_active	78	sqlgipsol.m.module_id,const	8	Using index

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 mc.category_id, mc.name, mc.name_url
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 29 AND mc.is_active = 1
ORDER BY mc.ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	mc	ref	parent_id,is_active	parent_id	4	const,const	1	Using where; Using filesort

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 = '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	681	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 *
FROM phpfox_ad
WHERE location = "document|featured"
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	ALL		MISSING KEY			12	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 = 29
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	dcd	ref	category_id,document_id	category_id	4	const	2
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 = 'block' AND module_id = 'document' AND name = '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 = 'block' AND module_id = 'document' AND name = '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_ad
WHERE location = "document|statistic"
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	ALL		MISSING KEY			12	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 = 29
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	ref	category_id,document_id	category_id	4	const	2	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 *
FROM phpfox_ad
WHERE location = "document|topview"
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	ALL		MISSING KEY			12	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		681	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 *
FROM phpfox_ad
WHERE location = "document|mostdiscussed"
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_ad	ALL		MISSING KEY			12	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