Gipuzkoa Kutxa Solidarioa

BIKARTE

Haurrak eta Gazteak

Adingabeko Errusiar eta Bielorusiar haurren harrera elkartea

Bideoa igo edo gorde

Ordenatu:
Eztabaidatuenak

Erakutsi:
18 orrialdeko

Noiz:
Edonoiz

Los Niños de Bragin - Document...

1253 Bistaratzeak
Bikarte Ongintza Elk...-k partekatuta

Bideo Aipagarriak

Elige comercio justo

by GipuzkoaSolidarioa
2,304 Bistaratzeak

Pausoka elkartea: Therasuit

by Pausoka Elkartea
3,237 Bistaratzeak

Bidezko merkataritza aukeratu

by GipuzkoaSolidarioa
3,369 Bistaratzeak

phpFox Developers Debug Toggle JavaScript Console

Debug Details

Version:

3.8.0

Product Code Name:

Nebula

Total Time:

0.9020200

PHP General Time:

0.5503977

GZIP:

disabled

Driver Version:

MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1

SQL Time:

0.3516223

SQL Queries:

SQL Memory Usage:

1.6 Mb

SQL Slave Enabled:

SQL Total Slaves:

N/A

SQL Slave Server:

N/A

Total Memory Usage:

28.39 Mb

Total Memory Usage (Including Debug):

28.6 Mb

Memory Limit:

512 Mb (1024M)

Load Balancing Enabled:

Requests From:

192.168.100.222

Server Time Stamp:

April 8, 2026, 11:17 am

PHP Version:

5.6.40

PHP Sapi:

fpm-fcgi

PHP safe_mode:

false

PHP open_basedir:

false

Operating System:

Linux

Cache:

file

SQL Queries

SELECT s.type_id, s.var_name, s.value_actual, m.module_id AS module_name
FROM phpfox_setting AS s
JOIN phpfox_module AS m
ON(m.module_id = s.module_id AND m.is_active = 1)

/* 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
1	SIMPLE	s	ref	module_id	module_id	78	sqlgipsol.m.module_id	11

SELECT m.module_id
FROM phpfox_module AS m
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.is_active = 1
ORDER BY m.module_id
/* OO Query */

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

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 product.*
FROM phpfox_product AS product
ORDER BY product.is_core DESC , product.product_id ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	product	ALL		MISSING KEY			26	Using filesort

SELECT r.url, r.replacement
FROM phpfox_rewrite AS r
/* OO Query */

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

SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session AS s
WHERE s.session_hash = '61636807e3bee05e660349e024c044cd' 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 = '1775647063', user_id = '0', location = '/profile-2439/video/when_all-time/show_18/sort_most-talked', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.132', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = '61636807e3bee05e660349e024c044cd'

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 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 ts.style_id
FROM phpfox_theme_style AS ts
JOIN phpfox_theme AS t
ON(t.theme_id = ts.theme_id AND t.is_active = 1)

WHERE ts.is_active = 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	ts	ALL	is_active	MISSING KEY			9	Using where
1	SIMPLE	t	eq_ref	PRIMARY,is_active,theme_id	PRIMARY	2	sqlgipsol.ts.theme_id	1	Using where

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

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

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			43059	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

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	p	ALL	language_id,setting_list	MISSING KEY			43059	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 find_value
FROM phpfox_ban
WHERE type_id = 'ip'
/* 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 page_id, title_url
FROM phpfox_page
/* OO Query */

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

SELECT *
FROM phpfox_seo_meta
ORDER BY time_stamp
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_seo_meta	ALL		MISSING KEY			3	Using filesort

SELECT p.photo_id as cover_photo_exists, u.*, user_space.*, user_field.*, user_activity.*, ls.user_id AS is_online, ts.style_id AS designer_style_id, ts.folder AS designer_style_folder, t.folder AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id AS theme_parent_id, ug.prefix, ug.suffix, ug.icon_ext, ug.title, uf.user_id as is_featured
FROM phpfox_user AS u
     JOIN phpfox_user_group AS ug
            ON(ug.user_group_id = u.user_group_id)
     JOIN phpfox_user_space AS user_space
            ON(user_space.user_id = u.user_id)
     JOIN phpfox_user_field AS user_field
            ON(user_field.user_id = u.user_id)
     JOIN phpfox_user_activity AS user_activity
            ON(user_activity.user_id = u.user_id)
     LEFT JOIN phpfox_theme_style AS ts
            ON(ts.style_id = user_field.designer_style_id AND ts.is_active = 1)
     LEFT JOIN phpfox_theme AS t
            ON(t.theme_id = ts.theme_id)
     LEFT JOIN phpfox_user_featured AS uf
            ON(uf.user_id = u.user_id)
     LEFT JOIN phpfox_log_session AS ls
            ON(ls.user_id = u.user_id AND ls.im_hide = 0)
     LEFT JOIN phpfox_photo AS p
            ON(p.photo_id = user_field.cover_photo)

WHERE u.user_name = 'profile-2439'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	ref	PRIMARY,user_group_id,user_id,user_name	user_name	103	const	1	Using index condition
1	SIMPLE	user_field	eq_ref	user_id	user_id	4	sqlgipsol.u.user_id	1
1	SIMPLE	ts	eq_ref	style_id_2,style_id,is_active	style_id_2	2	sqlgipsol.user_field.designer_style_id	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,theme_id	PRIMARY	2	sqlgipsol.ts.theme_id	1	Using where
1	SIMPLE	ug	eq_ref	PRIMARY,user_group_id	PRIMARY	1	sqlgipsol.u.user_group_id	1	Using index condition
1	SIMPLE	uf	eq_ref	PRIMARY	PRIMARY	4	sqlgipsol.u.user_id	1	Using index
1	SIMPLE	user_space	eq_ref	user_id	user_id	4	sqlgipsol.u.user_id	1
1	SIMPLE	user_activity	eq_ref	user_id	user_id	4	sqlgipsol.u.user_id	1
1	SIMPLE	ls	ref	user_id,user_id_2,user_id_3	user_id	5	sqlgipsol.u.user_id,const	723	Using index
1	SIMPLE	p	eq_ref	PRIMARY,photo_id,photo_id_2	PRIMARY	4	sqlgipsol.user_field.cover_photo	1	Using index

SELECT c.country_iso, c.name
FROM phpfox_country AS c
ORDER BY c.ordering ASC, c.name ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	c	ALL		MISSING KEY			89	Using filesort

SELECT COUNT(*)
FROM phpfox_fevent
WHERE view_id = 0 AND item_id = 0 AND user_id = 2439
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_fevent	ref	user_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5	user_id	4	const	1	Using where

SELECT *
FROM phpfox_user_blocked
WHERE block_user_id = 0
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE				MISSING KEY				Impossible WHERE noticed after reading const tables

SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 2439
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_user_privacy	ref	user_id,user_id_2	user_id	4	const	3

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 = "video"
/* 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(item_id) AS total
FROM phpfox_tag
WHERE category_id = 'video' AND tag_url = ''
GROUP BY tag_id
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_tag	ref	category_id,tag_url,user_search,user_search_general,category_id_2	tag_url	257	const	1	Using index condition; Using where; Using temporary; Using filesort

SELECT COUNT(*)
FROM phpfox_video AS m
WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND m.user_id = 2439
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ref	in_process,user_id,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6	in_process_5	11	const,const,const,const,const	1	Using index

SELECT 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_video AS m
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)

WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND m.user_id = 2439
ORDER BY m.total_comment DESC
LIMIT 18
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	u	const	PRIMARY,user_id	PRIMARY	4	const	1
1	SIMPLE	m	ref	in_process,user_id,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6	user_id	4	const	1	Using where; Using filesort

SELECT *
FROM phpfox_seo_nofollow
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_seo_nofollow	system		MISSING KEY				Const row not found

SELECT *
FROM phpfox_seo_meta
/* OO Query */

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

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

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			211	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 u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* 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 u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* 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 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	2	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	2	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

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ALL	product_id,parent_id	MISSING KEY			211	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 u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* 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 u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* 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 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

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ALL	product_id,parent_id	MISSING KEY			211	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 u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* 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 u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* 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 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 = 'video.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	index_merge	product_id,m_connection,parent_id	parent_id,m_connection	3,79		9	Using intersect(parent_id,m_connection); 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 = 'video' 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

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ALL	product_id,parent_id	MISSING KEY			211	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 u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* 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 u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* 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 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

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	m	ALL	product_id,parent_id	MISSING KEY			211	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 u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* 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 u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* 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 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 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 = '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 cf.*, cmv.option_id as customValue, cg.user_group_id as cg_user_group_id
FROM phpfox_custom_field AS cf
     LEFT JOIN phpfox_user_custom_multiple_value AS cmv
            ON(cmv.field_id = cf.field_id AND cmv.user_id = 2439)
     JOIN phpfox_module AS m
            ON(m.module_id = cf.module_id AND m.is_active = 1)
     LEFT JOIN phpfox_custom_group AS cg
            ON(cg.group_id = cf.group_id)

WHERE cf.type_id IN ('user_main','user_panel','profile_panel') AND cf.is_active = 1 AND cf.user_group_id = 0
ORDER BY cf.ordering ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	cf	ALL		MISSING KEY			83	Using where; Using filesort
1	SIMPLE	cg	eq_ref	PRIMARY	PRIMARY	2	sqlgipsol.cf.group_id	1
1	SIMPLE	cmv	ref	user_id	user_id	6	const,sqlgipsol.cf.field_id	1
1	SIMPLE	m	ref	is_active,module_id,module_is_active	module_is_active	78	sqlgipsol.cf.module_id,const	8	Using index

SELECT *
FROM phpfox_user_custom
WHERE user_id = 2439
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_user_custom	const	user_id	user_id	4	const	1

SELECT *
FROM phpfox_custom_option
WHERE field_id IN(93,22,9,79,80,81,48,33,38,51,53,54,55,58,59,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77)
ORDER BY option_id ASC
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_custom_option	ALL	field_id	MISSING KEY			83	Using where; Using filesort

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/header.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_photo
WHERE photo_id = 4299
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_photo	const	PRIMARY,photo_id,photo_id_2	PRIMARY	4	const	1

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/logo.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 = 'profile' AND name = 'block/pic.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 = '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 = 'video' 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 = 'video' 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 s.*, v.*, ve.embed_code, 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_video AS v
     JOIN phpfox_user AS u
            ON(u.user_id = v.user_id)
     JOIN phpfox_ad_sponsor AS s
            ON(s.item_id = v.video_id)
     LEFT JOIN phpfox_video_embed AS ve
            ON(ve.video_id = v.video_id)

WHERE v.in_process = 0 AND v.view_id = 0 AND v.is_sponsor = 1 AND s.module_id = "video"
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	s	ALL		MISSING KEY			21	Using where
1	SIMPLE	v	eq_ref	PRIMARY,in_process,user_id,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6	PRIMARY	4	sqlgipsol.s.item_id	1	Using where
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.v.user_id	1
1	SIMPLE	ve	eq_ref	video_id	video_id	4	sqlgipsol.s.item_id	1

SELECT v.*, u.user_id, u.profile_page_id, u.server_id AS user_server_id, u.user_name, u.full_name, u.gender, u.user_image, u.is_invisible, u.user_group_id, u.language_id, u.last_activity
FROM phpfox_video AS v
JOIN phpfox_user AS u
ON(u.user_id = v.user_id)

WHERE v.is_featured = 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	v	ALL	user_id	MISSING KEY			1016	Using where
1	SIMPLE	u	eq_ref	PRIMARY,user_id	PRIMARY	4	sqlgipsol.v.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 = 'video' 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 = 'video' 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 = 'video' AND name = 'mini.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 = 'video' AND name = 'mini.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 = 'video' AND name = 'mini.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 = "video|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 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

Session

Array
(
    [session] => 61636807e3bee05e660349e024c044cd
    [redirect] => /profile-2439/video/when_all-time/show_18/sort_most-talked
    [socialintegration_pageId] => 11
)

Array
(
    [coreb6aavisit] => 1775647034
)

TOP