Dokumentuak

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 ('506229bad1ce6c52d491144c8a2c664e', '0d574f7196f9f96e319d05681455513d', '0', '1766578010', '/document/sort_latest/show_9/when_all-time/page_72', '0', '0', '0', '216.73.216.164', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.')

SELECT m.module_id, user_group_setting.name, user_group_setting.type_id, user_group_setting.default_admin, user_group_setting.default_user, user_group_setting.default_guest, user_group_setting.default_staff, user_setting.value_actual AS value_actual
FROM phpfox_user_group_setting AS user_group_setting
     JOIN phpfox_module AS m
            ON(m.module_id = user_group_setting.module_id)
     LEFT JOIN phpfox_user_setting AS user_setting
            ON(user_setting.user_group_id = '3' AND user_setting.setting_id = user_group_setting.setting_id)

/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	user_group_setting	ALL	module_id	MISSING KEY			472	Using where
1	SIMPLE	user_setting	ref	user_group_id	user_group_id	4	const,sqlgipsol.user_group_setting.setting_id	1
1	SIMPLE	m	ref	module_id,module_is_active	module_id	77	sqlgipsol.user_group_setting.module_id	8	Using index

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 *
FROM phpfox_language
WHERE language_id = 'eu'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_language	const	PRIMARY	PRIMARY	14	const	1

SELECT p.var_name, p.text, m.module_id
FROM phpfox_language_phrase AS p
     LEFT JOIN phpfox_module AS m
            ON(p.module_id = m.module_id AND m.is_active = 1)
     JOIN phpfox_product AS product
            ON(p.product_id = product.product_id AND product.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	ALL	language_id,setting_list	MISSING KEY			42877	Using where
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 where; Using index

SELECT p.var_name, p.text, m.module_id
FROM phpfox_language_phrase AS p
     LEFT JOIN phpfox_module AS m
            ON(p.module_id = m.module_id AND m.is_active = 1)
     JOIN phpfox_product AS product
            ON(p.product_id = product.product_id AND product.is_active = 1)

WHERE p.language_id = 'en'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	ALL	language_id,setting_list	MISSING KEY			42877	Using where
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 where; Using index

SELECT var_name, rule, rule_value, ordering
FROM phpfox_language_rule
WHERE language_id = 'eu'
ORDER BY 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 b.block_id, b.type_id, b.ordering, b.m_connection, b.component, b.location, b.disallow_access, b.can_move, m.module_id, bs.source_parsed
FROM phpfox_block AS b
     LEFT JOIN phpfox_block_source AS bs
            ON(bs.block_id = b.block_id)
     JOIN phpfox_module AS m
            ON(b.module_id = m.module_id AND m.is_active = 1)
     JOIN phpfox_product AS p
            ON(b.product_id = p.product_id AND p.is_active = 1)

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

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	index	is_active,module_id,module_is_active	module_is_active	78		85	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	b	ref|filter	is_active,product_id,module_id	module_id|is_active	77|1	sqlgipsol.m.module_id	9 (63%)	Using where; Using rowid filter
1	SIMPLE	bs	ref	block_id	block_id	4	sqlgipsol.b.block_id	5
1	SIMPLE	p	ref	is_active,product_active,product_id	product_active	28	sqlgipsol.b.product_id,const	3	Using index

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
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)
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ref	in_process,in_process_2,in_process_3,in_process_4,in_process_5	in_process	1	const	681	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
     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)
ORDER BY m.time_stamp DESC
LIMIT 9 OFF SET 639
/* OO Query */

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

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 = 51
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 = 50
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 = 49
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 = 48
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 = 47
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 = 46
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 = 45
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 = 43
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 = 44
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 r.feed_id, r.title_var, r.php_group_code
FROM phpfox_rss AS r
     JOIN phpfox_module AS m
            ON(m.module_id = r.module_id AND m.is_active = 1)
     JOIN phpfox_product AS p
            ON(p.product_id = r.product_id AND p.is_active = 1)

WHERE r.is_active = 1 AND r.is_site_wide = 1
ORDER BY r.ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	r	ALL	is_active	MISSING KEY			8	Using where; Using filesort
1	SIMPLE	p	ref	is_active,product_active,product_id	product_active	28	sqlgipsol.r.product_id,const	3	Using index
1	SIMPLE	m	ref	is_active,module_id,module_is_active	module_is_active	78	sqlgipsol.r.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 = 'main' 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	index_merge	product_id,m_connection,parent_id	m_connection,parent_id	79,3		4	Using intersect(m_connection,parent_id); 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 = 'main' 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	index_merge	product_id,m_connection,parent_id	m_connection,parent_id	79,3		4	Using intersect(m_connection,parent_id); 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			209	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 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 = 'main_right' 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 = 'main_right' 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			209	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 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 = 'explore' 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 = 'explore' 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			209	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 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			209	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 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 = 'footer' 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	index_merge	product_id,m_connection,parent_id	m_connection,parent_id	79,3		1	Using intersect(m_connection,parent_id); 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 = 'footer' 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	index_merge	product_id,m_connection,parent_id	m_connection,parent_id	79,3		1	Using intersect(m_connection,parent_id); 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			209	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 a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '1'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '3'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

SELECT logo_id, logo, file_ext
FROM phpfox_theme_style_logo
WHERE style_id = 11
/* 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 = '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 tc.module_id, tc.file_name
FROM phpfox_theme_css AS tc
WHERE style_id = 11
/* 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 = '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 a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '14'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

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 l.*
FROM phpfox_language AS l
WHERE l.user_select = 1
ORDER BY l.is_default DESC , l.title
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	l	ref	user_select	user_select	1	const	2	Using where; Using filesort

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 a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '9'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '10'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '6'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

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 a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '11'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

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 a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '13'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

SELECT a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '7'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

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 a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '12'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

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 = 0 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	ALL	parent_id,is_active	MISSING KEY			10	Using where; Using filesort

SELECT mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 9 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 mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 6 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 mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 3 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 mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 1 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 mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 5 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 mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 28 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 mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 7 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 mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 15 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 mc.category_id, mc.name
FROM phpfox_document_category AS mc
WHERE mc.parent_id = 8 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 = '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 = '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 = 'document' 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 = 'core' 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 *
FROM phpfox_ad
WHERE location = "document|category"
/* 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 = '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 a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '2'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

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 = '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 a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '4'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

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
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)
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ALL	view_id,view_id_2	MISSING KEY			709	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)

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)
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	m	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.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 a.*, ac.child_id, ac.country_id
FROM phpfox_ad AS a
     LEFT JOIN phpfox_ad_country AS ac
            ON(ac.ad_id = a.ad_id)

WHERE a.is_active = 1 AND a.location = '8'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	a	ref	is_active	is_active	53	const,const	1	Using index condition
1	SIMPLE	ac	ALL	ad_id	MISSING KEY			1	Using where; Using join buffer (flat, BNL join)

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