Array
(
)

Array
(
    [66] => Array
        (
            [menu_id] => 66
            [parent_id] => 0
            [m_connection] => photo.index
            [var_name] => menu_photo_upload_a_new_image_714586c73197300f65ba08f7dee8cb4a
            [disallow_access] => 
            [module] => photo
            [url] => photo.add
            [module_is_active] => 1
            [mobile_icon] => 
        )

)

ASOCIACIÓN ALDATZEN BOLONDRES ELKARTEA A FAVOR DE UNA SOCIEDAD JUSTA Y SOSTENIBLE(r)en argazkiak » Gipuzkoa Kutxa Solidarioa » Ikusienak

Gipuzkoa Kutxa Solidarioa

ALDATZEN ELKARTEA

Lankidetza eta Garapena

Irabazi-asmorik gabeko elkartea izanik, gure helburua gizartea mundu bidezkoago eta iraunkorrago baterantz eraldatzearen alde lan egitea da, hezkuntzaren eta konpromiso sozialaren bidez, aldi berean, elkarteko boluntarioen inplikazio pertsonala bultzatuz

Argazkia igo

Ordenatu:
Ikusienak

Erakutsi:
40 orrialdeko

Noiz:
Hilabete honetan

0Argazkiak_

1Bilduma

Ez da argazkirik topatu.

phpFox Developers Debug Toggle JavaScript Console

Debug Details

Version:

3.8.0

Product Code Name:

Nebula

Total Time:

0.3104591

PHP General Time:

0.2964555

GZIP:

disabled

Driver Version:

MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1

SQL Time:

0.0140036

SQL Queries:

SQL Memory Usage:

332.71 kb

SQL Slave Enabled:

SQL Total Slaves:

N/A

SQL Slave Server:

N/A

Total Memory Usage:

27.89 Mb

Total Memory Usage (Including Debug):

28.02 Mb

Memory Limit:

512 Mb (1024M)

Load Balancing Enabled:

Requests From:

192.168.100.222

Server Time Stamp:

January 26, 2026, 5:27 pm

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

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 ('ef7a7cebc30c3e8051fc5abf06a4f6af', '0d574f7196f9f96e319d05681455513d', '0', '1769448440', '/mobile/profile-2628/photo/photos/when_this-month/show_40/sort_most-viewed', '0', '0', '0', '216.73.216.178', '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 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 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-2628'
/* 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 COUNT(*)
FROM phpfox_fevent
WHERE view_id = 0 AND item_id = 0 AND user_id = 2628
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 COUNT(*)
FROM phpfox_photo_album
WHERE view_id = 0 AND group_id = 0 AND user_id = 2628
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_photo_album	ref	user_id,view_id,view_id_2,view_id_3,view_id_4	view_id	9	const,const,const	1	Using index

SELECT COUNT(*)
FROM phpfox_photo_album
WHERE view_id = 0 AND group_id = 0 AND user_id = 2628
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_photo_album	ref	user_id,view_id,view_id_2,view_id_3,view_id_4	view_id	9	const,const,const	1	Using index

SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 2628
/* 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	8

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 = "photo"
/* 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_photo AS photo
WHERE photo.view_id = 0 AND photo.group_id = 0 AND photo.type_id = 0 AND photo.privacy IN(0) AND photo.user_id = 2628 AND photo.time_stamp >= '1767218500' AND photo.time_stamp <= '1769814000'
LIMIT 1
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	photo	ref	view_id_2,view_id,privacy,view_id_3,view_id_4,view_id_5	view_id_3	10	const,const,const,const	1	Using where

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			210	Using where; Using filesort
1	SIMPLE	p	ref	is_active,product_active,product_id	product_active	28	sqlgipsol.m.product_id,const	3	Using index
1	SIMPLE	mo	ref	is_active,module_id,module_is_active	module_is_active	78	sqlgipsol.m.module_id,const	8	Using index

SELECT 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			210	Using where; Using filesort
1	SIMPLE	p	ref	is_active,product_active,product_id	product_active	28	sqlgipsol.m.product_id,const	3	Using index
1	SIMPLE	mo	ref	is_active,module_id,module_is_active	module_is_active	78	sqlgipsol.m.module_id,const	8	Using index

SELECT 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			210	Using where; Using filesort
1	SIMPLE	p	ref	is_active,product_active,product_id	product_active	28	sqlgipsol.m.product_id,const	3	Using index
1	SIMPLE	mo	ref	is_active,module_id,module_is_active	module_is_active	78	sqlgipsol.m.module_id,const	8	Using index

SELECT 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 = 'photo.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 = 'photo' 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			210	Using where; Using filesort
1	SIMPLE	p	ref	is_active,product_active,product_id	product_active	28	sqlgipsol.m.product_id,const	3	Using index
1	SIMPLE	mo	ref	is_active,module_id,module_is_active	module_is_active	78	sqlgipsol.m.module_id,const	8	Using index

SELECT 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			210	Using where; Using filesort
1	SIMPLE	p	ref	is_active,product_active,product_id	product_active	28	sqlgipsol.m.product_id,const	3	Using index
1	SIMPLE	mo	ref	is_active,module_id,module_is_active	module_is_active	78	sqlgipsol.m.module_id,const	8	Using index

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'template.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'cabecera.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT 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 = 2628)
     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			82	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 = 2628
/* 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(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			75	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 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 html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-contentclass.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'controller' AND module_id = 'photo' 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 = 'photo' AND name = 'specialmenu.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	phpfox_theme_template	ref	theme_id,theme_id_2,folder	theme_id	176	const,const,const	1	Using index condition; Using where

Session

Array
(
    [session] => ef7a7cebc30c3e8051fc5abf06a4f6af
    [redirect] => /mobile/profile-2628/photo/photos/when_this-month/show_40/sort_most-viewed
)

Array
(
)

TOP