personal-5226775_640 (2)

Inklusioa

Talde behartsuak integratzeko esku-hartze soziala

Argazkiak bilatu...
1Argazkiak_
1Bilduma
Ez da argazkirik topatu.
phpFox Developers Debug Toggle JavaScript Console
Debug Details
Version:
3.8.0
Product Code Name:
Nebula

Total Time:
4.7041049
PHP General Time:
4.4899571
GZIP:
disabled

Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.2141478
SQL Queries:
87
SQL Memory Usage:
1.28 Mb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
27.88 Mb
Total Memory Usage (Including Debug):
28.09 Mb
Memory Limit:
512 Mb (1024M)

Load Balancing Enabled:
No
Requests From:
192.168.100.222


Server Time Stamp:
December 16, 2025, 11:44 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
0.0006151 | Memory Before: 2.29 Mb | Memory After: 2.29 Mb | Memory Used: 3.86 kb | Rows: 1 | Slave: No
SELECT s.session_hash, s.id_hash, s.captcha_hash, s.user_id
FROM phpfox_log_session AS s
WHERE s.session_hash = '4bca113493fe3642106e44b1c0dc7092' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_hash,log_sessionsession_hash32const1Using index condition; Using where
0.0004342 | Memory Before: 2.3 Mb | Memory After: 2.3 Mb | Memory Used: 1.41 kb | Rows: - | Slave: No
UPDATE phpfox_log_session SET last_activity = '1765885455', user_id = '0', location = '/profile-2580/photo/photos/when_this-week/show_20/sort_latest', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.151', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = '4bca113493fe3642106e44b1c0dc7092'
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_log_sessionrefsession_hash,log_sessionsession_hash32const1Using index condition
0.0002561 | Memory Before: 3.58 Mb | Memory After: 3.58 Mb | Memory Used: 3.2 kb | Rows: 9 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtsALLis_activeMISSING KEY   9Using where
1SIMPLEteq_refPRIMARY,is_active,theme_idPRIMARY2sqlgipsol.ts.theme_id1Using where
0.0002031 | Memory Before: 3.76 Mb | Memory After: 3.77 Mb | Memory Used: 5.03 kb | Rows: 1 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefis_defaultis_default1const1 
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2sqlgipsol.s.theme_id1 
0.0001178 | Memory Before: 3.77 Mb | Memory After: 3.77 Mb | Memory Used: 3.18 kb | Rows: 1 | Slave: No
SELECT folder AS parent_style_folder
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_styleconststyle_id_2,style_idstyle_id_22const1 
0.0015979 | Memory Before: 4.63 Mb | Memory After: 4.65 Mb | Memory Used: 26.57 kb | Rows: 990 | Slave: No
SELECT page_id, title_url
FROM phpfox_page
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_pageALL MISSING KEY   990 
0.0001941 | Memory Before: 5.04 Mb | Memory After: 5.04 Mb | Memory Used: 4.37 kb | Rows: 3 | Slave: Yes
SELECT *
FROM phpfox_seo_meta
ORDER BY time_stamp
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_seo_metaALL MISSING KEY   3Using filesort
0.0014880 | Memory Before: 5.16 Mb | Memory After: 5.2 Mb | Memory Used: 36.08 kb | Rows: 1 | Slave: Yes
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-2580'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEurefPRIMARY,user_group_id,user_id,user_nameuser_name103const1Using index condition
1SIMPLEuser_fieldeq_refuser_iduser_id4sqlgipsol.u.user_id1 
1SIMPLEtseq_refstyle_id_2,style_id,is_activestyle_id_22sqlgipsol.user_field.designer_style_id1Using where
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2sqlgipsol.ts.theme_id1Using where
1SIMPLEugeq_refPRIMARY,user_group_idPRIMARY1sqlgipsol.u.user_group_id1Using index condition
1SIMPLEufeq_refPRIMARYPRIMARY4sqlgipsol.u.user_id1Using index
1SIMPLEuser_spaceeq_refuser_iduser_id4sqlgipsol.u.user_id1 
1SIMPLEuser_activityeq_refuser_iduser_id4sqlgipsol.u.user_id1 
1SIMPLElsrefuser_id,user_id_2,user_id_3user_id5sqlgipsol.u.user_id,const723Using index
1SIMPLEpeq_refPRIMARY,photo_id,photo_id_2PRIMARY4sqlgipsol.user_field.cover_photo1Using index
0.0002739 | Memory Before: 5.29 Mb | Memory After: 5.3 Mb | Memory Used: 5.42 kb | Rows: 89 | Slave: No
SELECT c.country_iso, c.name
FROM phpfox_country AS c
ORDER BY c.ordering ASC, c.name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcALL MISSING KEY   89Using filesort
0.0002289 | Memory Before: 11.1 Mb | Memory After: 11.1 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_fevent
WHERE view_id = 0 AND item_id = 0 AND user_id = 2580
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_feventrefuser_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5user_id4const1Using where
0.0001779 | Memory Before: 11.08 Mb | Memory After: 11.08 Mb | Memory Used: 4.13 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_user_blocked
WHERE block_user_id = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0001271 | Memory Before: 10.98 Mb | Memory After: 10.98 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: No
SELECT COUNT(*)
FROM phpfox_photo_album
WHERE view_id = 0 AND group_id = 0 AND user_id = 2580
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_albumrefuser_id,view_id,view_id_2,view_id_3,view_id_4view_id9const,const,const1Using index
0.0001209 | Memory Before: 11.14 Mb | Memory After: 11.15 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: No
SELECT COUNT(*)
FROM phpfox_photo_album
WHERE view_id = 0 AND group_id = 0 AND user_id = 2580
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photo_albumrefuser_id,view_id,view_id_2,view_id_3,view_id_4view_id9const,const,const1Using index
0.0002229 | Memory Before: 11.2 Mb | Memory After: 11.2 Mb | Memory Used: 3.76 kb | Rows: 3 | Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 2580
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_privacyrefuser_id,user_id_2user_id4const8 
0.0176790 | Memory Before: 11.2 Mb | Memory After: 11.22 Mb | Memory Used: 16.38 kb | Rows: 519 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'photo' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpreflanguage_id,module_id,setting_listmodule_id78const1575Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0001950 | Memory Before: 11.83 Mb | Memory After: 11.83 Mb | Memory Used: 4.76 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0110922 | Memory Before: 12 Mb | Memory After: 12.03 Mb | Memory Used: 27.38 kb | Rows: 698 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'core' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpref|filterlanguage_id,module_id,setting_listmodule_id|language_id78|14const2527 (30%)Using index condition; Using where; Using rowid filter
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0003970 | Memory Before: 12.36 Mb | Memory After: 12.37 Mb | Memory Used: 3.12 kb | Rows: 1 | Slave: Yes
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 = 2580 AND photo.time_stamp >= '1765926000' AND photo.time_stamp <= '1766313855'
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphotorefview_id_2,view_id,privacy,view_id_3,view_id_4,view_id_5view_id_310const,const,const,const1Using where
0.0001578 | Memory Before: 12.64 Mb | Memory After: 12.64 Mb | Memory Used: 3.64 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_seo_nofollow
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_seo_nofollowsystem MISSING KEY    Const row not found
0.0001061 | Memory Before: 12.69 Mb | Memory After: 12.69 Mb | Memory Used: 4.23 kb | Rows: 3 | Slave: Yes
SELECT *
FROM phpfox_seo_meta
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_seo_metaALL MISSING KEY   3 
0.0036471 | Memory Before: 12.83 Mb | Memory After: 12.84 Mb | Memory Used: 6.7 kb | Rows: 143 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'smartslider' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpreflanguage_id,module_id,setting_listmodule_id78const336Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0000949 | Memory Before: 12.88 Mb | Memory After: 12.89 Mb | Memory Used: 6.17 kb | Rows: 16 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmindex_mergeproduct_id,m_connection,parent_idm_connection,parent_id79,3 4Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000799 | Memory Before: 12.91 Mb | Memory After: 12.92 Mb | Memory Used: 6.19 kb | Rows: 16 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmindex_mergeproduct_id,m_connection,parent_idm_connection,parent_id79,3 4Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000911 | Memory Before: 12.94 Mb | Memory After: 12.95 Mb | Memory Used: 9.67 kb | Rows: 71 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmALLproduct_id,parent_idMISSING KEY   209Using where; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0001469 | Memory Before: 12.96 Mb | Memory After: 12.97 Mb | Memory Used: 5.07 kb | Rows: 2 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefproduct_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000741 | Memory Before: 12.95 Mb | Memory After: 12.96 Mb | Memory Used: 5.09 kb | Rows: 2 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefproduct_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0001070 | Memory Before: 12.96 Mb | Memory After: 12.97 Mb | Memory Used: 9.67 kb | Rows: 71 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmALLproduct_id,parent_idMISSING KEY   209Using where; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000839 | Memory Before: 12.98 Mb | Memory After: 12.99 Mb | Memory Used: 4.92 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefproduct_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000679 | Memory Before: 12.96 Mb | Memory After: 12.96 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefproduct_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000820 | Memory Before: 12.96 Mb | Memory After: 12.97 Mb | Memory Used: 9.67 kb | Rows: 71 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmALLproduct_id,parent_idMISSING KEY   209Using where; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000811 | Memory Before: 12.99 Mb | Memory After: 13 Mb | Memory Used: 4.99 kb | Rows: 1 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefproduct_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000691 | Memory Before: 12.97 Mb | Memory After: 12.97 Mb | Memory Used: 4.91 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefproduct_id,m_connection,parent_idm_connection79const,const1Using index condition; Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000820 | Memory Before: 12.97 Mb | Memory After: 12.98 Mb | Memory Used: 9.67 kb | Rows: 71 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmALLproduct_id,parent_idMISSING KEY   209Using where; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000801 | Memory Before: 13 Mb | Memory After: 13.01 Mb | Memory Used: 5.38 kb | Rows: 6 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmindex_mergeproduct_id,m_connection,parent_idm_connection,parent_id79,3 1Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000689 | Memory Before: 12.99 Mb | Memory After: 12.99 Mb | Memory Used: 5.38 kb | Rows: 6 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmindex_mergeproduct_id,m_connection,parent_idm_connection,parent_id79,3 1Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0000899 | Memory Before: 13 Mb | Memory After: 13.01 Mb | Memory Used: 9.67 kb | Rows: 71 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmALLproduct_id,parent_idMISSING KEY   209Using where; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.m.product_id,const3Using index
1SIMPLEmorefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.m.module_id,const8Using index
0.0001671 | Memory Before: 13.25 Mb | Memory After: 13.28 Mb | Memory Used: 38.11 kb | Rows: 472 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEuser_group_settingALLmodule_idMISSING KEY   472Using where
1SIMPLEuser_settingrefuser_group_iduser_group_id4const,sqlgipsol.user_group_setting.setting_id1 
1SIMPLEmrefmodule_id,module_is_activemodule_id77sqlgipsol.user_group_setting.module_id8Using index
0.0003719 | Memory Before: 13.54 Mb | Memory After: 13.55 Mb | Memory Used: 9.53 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001950 | Memory Before: 13.34 Mb | Memory After: 13.35 Mb | Memory Used: 3.63 kb | Rows: 0 | Slave: No
SELECT logo_id, logo, file_ext
FROM phpfox_theme_style_logo
WHERE style_id = 11
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0001731 | Memory Before: 13.4 Mb | Memory After: 13.4 Mb | Memory Used: 5.11 kb | Rows: 2 | Slave: Yes
SELECT cron.*
FROM phpfox_cron AS cron
     JOIN phpfox_product AS product
            ON(product.product_id = cron.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = cron.module_id AND m.is_active = 1)

WHERE cron.is_active = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcronrefis_activeis_active1const3Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.cron.product_id,const3Using index
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.cron.module_id,const8Using index
0.0002329 | Memory Before: 13.86 Mb | Memory After: 13.87 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'template.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0002611 | Memory Before: 14.21 Mb | Memory After: 14.21 Mb | Memory Used: 3.36 kb | Rows: 0 | Slave: No
SELECT find_value, replacement
FROM phpfox_ban
WHERE type_id = 'word'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0001111 | Memory Before: 14.22 Mb | Memory After: 14.22 Mb | Memory Used: 3.34 kb | Rows: 0 | Slave: No
SELECT tc.module_id, tc.file_name
FROM phpfox_theme_css AS tc
WHERE style_id = 11
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0221260 | Memory Before: 14.78 Mb | Memory After: 14.8 Mb | Memory Used: 17.28 kb | Rows: 594 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'fevent' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpref|filterlanguage_id,module_id,setting_listmodule_id|language_id78|14const2182 (30%)Using index condition; Using where; Using rowid filter
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0002050 | Memory Before: 14.97 Mb | Memory After: 14.98 Mb | Memory Used: 4.41 kb | Rows: 1 | Slave: No
SELECT *
FROM phpfox_currency
WHERE is_active = 1
ORDER BY ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_currencyrefis_activeis_active1const1Using where; Using filesort
0.0017841 | Memory Before: 14.98 Mb | Memory After: 14.99 Mb | Memory Used: 4.77 kb | Rows: 60 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'emoticon' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpreflanguage_id,module_id,setting_listmodule_id78const170Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0028951 | Memory Before: 15 Mb | Memory After: 15.01 Mb | Memory Used: 5.2 kb | Rows: 79 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'attachment' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpreflanguage_id,module_id,setting_listmodule_id78const174Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0040710 | Memory Before: 15.02 Mb | Memory After: 15.03 Mb | Memory Used: 6.56 kb | Rows: 137 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'language' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpreflanguage_id,module_id,setting_listmodule_id78const265Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0082998 | Memory Before: 15.06 Mb | Memory After: 15.07 Mb | Memory Used: 12.09 kb | Rows: 373 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'higipsol' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpreflanguage_id,module_id,setting_listmodule_id78const1177Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0003221 | Memory Before: 15.36 Mb | Memory After: 15.37 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002670 | Memory Before: 15.54 Mb | Memory After: 15.55 Mb | Memory Used: 9.51 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0002449 | Memory Before: 15.55 Mb | Memory After: 15.56 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002420 | Memory Before: 15.67 Mb | Memory After: 15.68 Mb | Memory Used: 6.03 kb | Rows: 2 | Slave: Yes
SELECT l.*
FROM phpfox_language AS l
WHERE l.user_select = 1
ORDER BY l.is_default DESC , l.title
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElrefuser_selectuser_select1const2Using where; Using filesort
0.0001340 | Memory Before: 15.68 Mb | Memory After: 15.68 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002220 | Memory Before: 15.7 Mb | Memory After: 15.71 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0136509 | Memory Before: 15.76 Mb | Memory After: 15.92 Mb | Memory Used: 168.8 kb | Rows: 236 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'profile' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpreflanguage_id,module_id,setting_listmodule_id78const1216Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0136011 | Memory Before: 15.85 Mb | Memory After: 16 Mb | Memory Used: 151.15 kb | Rows: 848 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'user' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpref|filterlanguage_id,module_id,setting_listmodule_id|language_id78|14const2758 (30%)Using index condition; Using where; Using rowid filter
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0634549 | Memory Before: 16.57 Mb | Memory After: 16.77 Mb | Memory Used: 213.6 kb | Rows: 3513 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'page' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpref|filterlanguage_id,module_id,setting_listmodule_id|language_id78|14const2866 (30%)Using index condition; Using where; Using rowid filter
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0077460 | Memory Before: 17.38 Mb | Memory After: 17.51 Mb | Memory Used: 136.21 kb | Rows: 210 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'theme' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpreflanguage_id,module_id,setting_listmodule_id78const490Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0003130 | Memory Before: 26.95 Mb | Memory After: 26.96 Mb | Memory Used: 9.6 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0002739 | Memory Before: 26.95 Mb | Memory After: 26.96 Mb | Memory Used: 9.98 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0002630 | Memory Before: 26.95 Mb | Memory After: 26.96 Mb | Memory Used: 9.64 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001371 | Memory Before: 26.98 Mb | Memory After: 26.98 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002630 | Memory Before: 26.97 Mb | Memory After: 26.98 Mb | Memory Used: 9.77 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0002370 | Memory Before: 26.99 Mb | Memory After: 26.99 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002379 | Memory Before: 26.99 Mb | Memory After: 27 Mb | Memory Used: 9.59 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001411 | Memory Before: 26.99 Mb | Memory After: 27 Mb | Memory Used: 9.88 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0019069 | Memory Before: 27.33 Mb | Memory After: 27.34 Mb | Memory Used: 17.32 kb | Rows: 74 | Slave: Yes
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 = 2580)
     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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEcfALL MISSING KEY   82Using where; Using filesort
1SIMPLEcgeq_refPRIMARYPRIMARY2sqlgipsol.cf.group_id1 
1SIMPLEcmvrefuser_iduser_id6const,sqlgipsol.cf.field_id1 
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.cf.module_id,const8Using index
0.0003781 | Memory Before: 27.57 Mb | Memory After: 27.6 Mb | Memory Used: 27.05 kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 2580
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_user_customconstuser_iduser_id4const1 
0.0001462 | Memory Before: 27.6 Mb | Memory After: 27.61 Mb | Memory Used: 5.69 kb | Rows: 64 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_custom_optionALLfield_idMISSING KEY   75Using where; Using filesort
0.0147059 | Memory Before: 27.68 Mb | Memory After: 27.69 Mb | Memory Used: 12.23 kb | Rows: 378 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'custom' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpreflanguage_id,module_id,setting_listmodule_id78const1658Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0002699 | Memory Before: 27.46 Mb | Memory After: 27.46 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001719 | Memory Before: 27.61 Mb | Memory After: 27.62 Mb | Memory Used: 10.5 kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_photo
WHERE photo_id = 4053
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_photoconstPRIMARY,photo_id,photo_id_2PRIMARY4const1 
0.0000961 | Memory Before: 27.75 Mb | Memory After: 27.76 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002079 | Memory Before: 27.94 Mb | Memory After: 27.94 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002031 | Memory Before: 27.94 Mb | Memory After: 27.95 Mb | Memory Used: 9.55 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001779 | Memory Before: 27.68 Mb | Memory After: 27.68 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0002809 | Memory Before: 27.7 Mb | Memory After: 27.7 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002220 | Memory Before: 27.7 Mb | Memory After: 27.7 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0002320 | Memory Before: 27.7 Mb | Memory After: 27.71 Mb | Memory Used: 9.57 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001259 | Memory Before: 27.71 Mb | Memory After: 27.71 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002260 | Memory Before: 27.73 Mb | Memory After: 27.73 Mb | Memory Used: 3.15 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0002489 | Memory Before: 27.71 Mb | Memory After: 27.72 Mb | Memory Used: 9.53 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0003021 | Memory Before: 27.78 Mb | Memory After: 27.79 Mb | Memory Used: 9.52 kb | Rows: 0 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0002201 | Memory Before: 27.8 Mb | Memory After: 27.8 Mb | Memory Used: 3.2 kb | Rows: 0 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0027180 | Memory Before: 27.81 Mb | Memory After: 27.82 Mb | Memory Used: 4.42 kb | Rows: 45 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'contact' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpreflanguage_id,module_id,setting_listmodule_id78const194Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0080330 | Memory Before: 27.82 Mb | Memory After: 27.83 Mb | Memory Used: 8.86 kb | Rows: 234 | Slave: No
SELECT p.var_name, p.text
FROM phpfox_language_phrase AS p
     JOIN phpfox_product AS product
            ON(product.product_id = p.product_id AND product.is_active = 1)
     JOIN phpfox_module AS m
            ON(m.module_id = 'mail' AND p.module_id = m.module_id AND m.is_active = 1)

WHERE p.language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78const,const1Using where; Using index
1SIMPLEpreflanguage_id,module_id,setting_listmodule_id78const492Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
Session
Array
(
    [session] => 4bca113493fe3642106e44b1c0dc7092
    [redirect] => /profile-2580/photo/photos/when_this-week/show_20/sort_latest
    [socialintegration_pageId] => 49
)
Cookie
TOP