WOMANHOOD + FGM

Notice: Undefined index: value - module/profile/include/component/block/header.class.php (134)
0 module/profile/include/component/block/header.class.php : 134   Phpfox_Error::errorHandler(8, "Undefined index: value", "module/profile/include/component/block/header.class.php", 134, Array(7))
1 module/profile/include/component/block/header.class.php : 112   Profile_Component_Block_Header->processCustomFields()
2 include/library/phpfox/module/module.class.php : 835   Profile_Component_Block_Header->process()
3 include/library/phpfox/phpfox/phpfox.class.php : 354   Phpfox_Module->getComponent("profile.header", Array(0), "block", FALSE)
4 file/cache/template/frontend_tm_base5_template_template.html.php.php : 142   Phpfox::getBlock("profile.header", Array(0))
5 include/library/phpfox/template/template.class.php : 3437   require("file/cache/template/frontend_tm_base5_template_template.html.php.php")
6 include/library/phpfox/template/template.class.php : 3423   Phpfox_Template->_requireFile("theme/frontend/tm_base5/template/template.html.php")
7 include/library/phpfox/template/template.class.php : 2473   Phpfox_Template->_getFromCache("theme/frontend/tm_base5/template/template.html.php")
8 include/library/phpfox/phpfox/phpfox.class.php : 1462   Phpfox_Template->getLayout("template")
9 index.php : 42   Phpfox::run()

Notice: Undefined index: value - module/profile/include/component/block/header.class.php (140)
0 module/profile/include/component/block/header.class.php : 140   Phpfox_Error::errorHandler(8, "Undefined index: value", "module/profile/include/component/block/header.class.php", 140, Array(9))
1 module/profile/include/component/block/header.class.php : 112   Profile_Component_Block_Header->processCustomFields()
2 include/library/phpfox/module/module.class.php : 835   Profile_Component_Block_Header->process()
3 include/library/phpfox/phpfox/phpfox.class.php : 354   Phpfox_Module->getComponent(""profile.header"", "Array(0)", ""block"", "FALSE")
4 file/cache/template/frontend_tm_base5_template_template.html.php.php : 142   Phpfox::getBlock(""profile.header"", "Array(0)")
5 include/library/phpfox/template/template.class.php : 3437   require("file/cache/template/frontend_tm_base5_template_template.html.php.php")
6 include/library/phpfox/template/template.class.php : 3423   Phpfox_Template->_requireFile(""theme/frontend/tm_base5/template/template.html.php"")
7 include/library/phpfox/template/template.class.php : 2473   Phpfox_Template->_getFromCache(""theme/frontend/tm_base5/template/template.html.php"")
8 include/library/phpfox/phpfox/phpfox.class.php : 1462   Phpfox_Template->getLayout(""template"")
9 index.php : 42   Phpfox::run()

Aztarna Solidarioa

Gertaerak bilatu
Ez da gertaerarik topatu.
phpFox Developers Debug Toggle JavaScript Console
Debug Details
Version:
3.8.0
Product Code Name:
Nebula

Total Time:
0.8412099
PHP General Time:
0.4947021
GZIP:
disabled

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

Total Memory Usage:
28.27 Mb
Total Memory Usage (Including Debug):
28.52 Mb
Memory Limit:
512 Mb (1024M)

Load Balancing Enabled:
No
Requests From:
192.168.100.222


Server Time Stamp:
April 13, 2026, 8:11 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.0001290 | Memory Before: 1.41 Mb | Memory After: 1.41 Mb | Memory Used: 4.78 kb | Rows: 5 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpALLis_activeMISSING KEY   5Using where; Using filesort
1SIMPLEphrefcall_namecall_name258sqlgipsol.p.call_name,const1Using where; Using index
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.p.module_id,const8Using index
0.0005641 | Memory Before: 2.42 Mb | Memory After: 2.43 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 = 'cc4fb7f122b81d9e4f80dec72e85289e' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefsession_hash,log_sessionsession_hash32const1Using index condition; Using where
0.0004330 | Memory Before: 2.43 Mb | Memory After: 2.43 Mb | Memory Used: 1.41 kb | Rows: - | Slave: No
UPDATE phpfox_log_session SET last_activity = '1776067910', user_id = '0', location = '/mobile/pages/153/fevent/when_this-week/show_100/sort_most-liked', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.171', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = 'cc4fb7f122b81d9e4f80dec72e85289e'
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_log_sessionrefsession_hash,log_sessionsession_hash32const1Using index condition
0.0001721 | Memory Before: 3.75 Mb | Memory After: 3.76 Mb | Memory Used: 4.97 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.0001221 | Memory Before: 3.75 Mb | Memory After: 3.76 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.0002151 | Memory Before: 4.37 Mb | Memory After: 4.37 Mb | Memory Used: 6.14 kb | Rows: 1 | Slave: No
SELECT *
FROM phpfox_language
WHERE language_id = 'eu'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_languageconstPRIMARYPRIMARY14const1 
0.1031508 | Memory Before: 4.37 Mb | Memory After: 4.92 Mb | Memory Used: 559.3 kb | Rows: 15863 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpALLlanguage_id,setting_listMISSING KEY   43072Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.p.module_id,const8Using where; Using index
0.0510910 | Memory Before: 8.96 Mb | Memory After: 9.32 Mb | Memory Used: 367.1 kb | Rows: 11632 | Slave: No
SELECT p.var_name, p.text, m.module_id
FROM phpfox_language_phrase AS p
     LEFT JOIN phpfox_module AS m
            ON(p.module_id = m.module_id AND m.is_active = 1)
     JOIN phpfox_product AS product
            ON(p.product_id = product.product_id AND product.is_active = 1)

WHERE p.language_id = 'en'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpALLlanguage_id,setting_listMISSING KEY   43072Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.p.module_id,const8Using where; Using index
0.0002921 | Memory Before: 21.49 Mb | Memory After: 21.5 Mb | Memory Used: 3.89 kb | Rows: 0 | Slave: No
SELECT var_name, rule, rule_value, ordering
FROM phpfox_language_rule
WHERE language_id = 'eu'
ORDER BY ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0003231 | Memory Before: 4.58 Mb | Memory After: 4.59 Mb | Memory Used: 17.59 kb | Rows: 144 | Slave: No
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmindexis_active,module_id,module_is_activemodule_is_active78 85Using where; Using index; Using temporary; Using filesort
1SIMPLEbref|filteris_active,product_id,module_idmodule_id|is_active77|1sqlgipsol.m.module_id9 (63%)Using where; Using rowid filter
1SIMPLEbsrefblock_idblock_id4sqlgipsol.b.block_id5 
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.b.product_id,const3Using index
0.0002420 | Memory Before: 4.88 Mb | Memory After: 4.88 Mb | Memory Used: 3.13 kb | Rows: 0 | Slave: No
SELECT find_value
FROM phpfox_ban
WHERE type_id = 'ip'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0005569 | Memory Before: 4.87 Mb | Memory After: 4.9 Mb | Memory Used: 26.56 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.0002160 | Memory Before: 5.28 Mb | Memory After: 5.29 Mb | Memory Used: 4.23 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.0130770 | Memory Before: 5.25 Mb | Memory After: 5.26 Mb | Memory Used: 9.59 kb | Rows: 266 | 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 = 'friend' 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_id78const704Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0001621 | Memory Before: 5.5 Mb | Memory After: 5.5 Mb | Memory Used: 4.19 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_pages_design_order
WHERE page_id = 153
ORDER BY ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0009179 | Memory Before: 5.79 Mb | Memory After: 5.81 Mb | Memory Used: 15.71 kb | Rows: 1 | Slave: Yes
SELECT f.friend_id AS is_friend, p.*, u.user_image as image_path, p.image_path as pages_image_path, u.user_id as page_user_id, p.use_timeline, pc.claim_id, pu.vanity_url, pg.name AS category_name, pg.page_type, pt.text_parsed AS text, l.like_id AS is_liked, u.full_name, 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, u2.user_id AS owner_user_id, u2.profile_page_id AS owner_profile_page_id, u2.server_id AS owner_server_id, u2.user_name AS owner_user_name, u2.full_name AS owner_full_name, u2.gender AS owner_gender, u2.user_image AS owner_user_image, u2.is_invisible AS owner_is_invisible, u2.user_group_id AS owner_user_group_id, u2.language_id AS owner_language_id, u2.last_activity AS owner_last_activity
FROM phpfox_pages AS p
     LEFT JOIN phpfox_friend AS f
            ON(f.user_id = p.user_id AND f.friend_user_id = 0)
     JOIN phpfox_pages_text AS pt
            ON(pt.page_id = p.page_id)
     JOIN phpfox_user AS u
            ON(u.profile_page_id = p.page_id)
     JOIN phpfox_user AS u2
            ON(u2.user_id = p.user_id)
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = p.page_id)
     LEFT JOIN phpfox_pages_category AS pg
            ON(pg.category_id = p.category_id)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'pages' AND l.item_id = p.page_id AND l.user_id = 0)
     LEFT JOIN phpfox_theme_style AS ts
            ON(ts.style_id = p.designer_style_id)
     LEFT JOIN phpfox_theme AS t
            ON(t.theme_id = ts.theme_id)
     LEFT JOIN phpfox_pages_claim AS pc
            ON(pc.page_id = p.page_id AND pc.user_id = 0)

WHERE p.page_id = 153
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpgsystemPRIMARY,category_idMISSING KEY    Const row not found
1SIMPLEpcsystempage_idMISSING KEY    Const row not found
1SIMPLEpconstPRIMARY,page_idPRIMARY4const1 
1SIMPLEfconstuser_check,user_id,top_friend,friend_user_iduser_check8const,const Unique row not found
1SIMPLEptconstpage_idpage_id4const1 
1SIMPLEu2constPRIMARY,user_idPRIMARY4const1 
1SIMPLEurefpage_idpage_id4const1 
1SIMPLEpurefpage_idpage_id4const1 
1SIMPLElref|filtertype_id,type_id_2,type_id_3,item_idtype_id_3|item_id81|4const,const1 (1%)Using where; Using rowid filter
1SIMPLEtseq_refstyle_id_2,style_idstyle_id_22const1 
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2sqlgipsol.ts.theme_id1Using where
0.0001009 | Memory Before: 5.89 Mb | Memory After: 5.89 Mb | Memory Used: 4.02 kb | Rows: 13 | Slave: Yes
SELECT *
FROM phpfox_pages_perm
WHERE page_id = 153
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_pages_permrefpage_idpage_id4const17 
0.0000770 | Memory Before: 5.9 Mb | Memory After: 5.9 Mb | Memory Used: 5.45 kb | Rows: 0 | Slave: Yes
SELECT pw.*, pwt.text_parsed AS text
FROM phpfox_pages_widget AS pw
     JOIN phpfox_pages_widget_text AS pwt
            ON(pwt.widget_id = pw.widget_id)

WHERE pw.page_id = 153
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0001619 | Memory Before: 6.55 Mb | Memory After: 6.55 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT MAX(`time_stamp`)
FROM phpfox_fevent_cron AS s
WHERE 1=1 AND `type_cron` = 'for_repeat'
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsALL MISSING KEY   103586Using where
0.0000799 | Memory Before: 6.55 Mb | Memory After: 6.56 Mb | Memory Used: 3.12 kb | Rows: 0 | Slave: Yes
SELECT p.page_id
FROM phpfox_pages AS p
     JOIN phpfox_like AS l
            ON(l.user_id = 0 AND l.`type_id` = 'pages' AND l.`item_id` = p.page_id)

WHERE p.view_id = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id_381const,const1Using index condition
1SIMPLEpeq_refPRIMARY,view_id_2,view_id,page_idPRIMARY4sqlgipsol.l.item_id1Using where
0.0000820 | Memory Before: 6.55 Mb | Memory After: 6.56 Mb | Memory Used: 3.39 kb | Rows: 0 | Slave: Yes
SELECT category_id,name
FROM phpfox_event_category
WHERE name_url = 'fevent'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_event_categoryALL MISSING KEY   8Using where
0.0143311 | Memory Before: 6.87 Mb | Memory After: 6.89 Mb | Memory Used: 17.33 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|14const2192 (30%)Using index condition; Using where; Using rowid filter
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0001619 | Memory Before: 7.27 Mb | Memory After: 7.27 Mb | Memory Used: 4.73 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 = "fevent"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0104179 | Memory Before: 7.44 Mb | Memory After: 7.46 Mb | Memory Used: 19.73 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|14const2539 (30%)Using index condition; Using where; Using rowid filter
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0004499 | Memory Before: 8.37 Mb | Memory After: 8.38 Mb | Memory Used: 3.13 kb | Rows: 1 | Slave: Yes
SELECT COUNT(m.event_id)
FROM phpfox_fevent AS m
INNER      JOIN phpfox_fevent_text AS ft
            ON(ft.event_id = m.event_id)

WHERE m.view_id = 0 AND m.privacy IN(0) AND m.module_id = 'pages' AND m.item_id = 153 AND ( m.start_time >= 1776031200 AND m.start_time <= 1776635999 ) AND ( m.start_time >= 1776031200 AND m.start_time <= 1776635999 )
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefPRIMARY,module_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5view_id_26const,const,const1Using index condition; Using where
1SIMPLEftrefevent_idevent_id4sqlgipsol.m.event_id1Using index
0.0054600 | Memory Before: 8.33 Mb | Memory After: 8.34 Mb | Memory Used: 15.12 kb | Rows: 0 | Slave: Yes
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_fevent AS v
     JOIN phpfox_user AS u
            ON(u.user_id = v.user_id)

WHERE v.view_id = 0 AND v.is_featured = 1 AND ((v.isrepeat>-1 and (v.timerepeat=0 or ( v.isrepeat>-1 and v.timerepeat>1776038400))) or ( v.isrepeat = -1 AND v.end_time >= '1776038400' ) )
ORDER BY v.start_time ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEvALLuser_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5MISSING KEY   9007Using where; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4sqlgipsol.v.user_id1 
0.0001709 | Memory Before: 8.5 Mb | Memory After: 8.5 Mb | Memory Used: 3.7 kb | Rows: 4 | Slave: No
SELECT r.feed_id, r.title_var, r.php_group_code
FROM phpfox_rss AS r
     JOIN phpfox_module AS m
            ON(m.module_id = r.module_id AND m.is_active = 1)
     JOIN phpfox_product AS p
            ON(p.product_id = r.product_id AND p.is_active = 1)

WHERE r.is_active = 1 AND r.is_site_wide = 1
ORDER BY r.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLErALLis_activeMISSING KEY   8Using where; Using filesort
1SIMPLEprefis_active,product_active,product_idproduct_active28sqlgipsol.r.product_id,const3Using index
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.r.module_id,const8Using index
0.0001581 | Memory Before: 8.62 Mb | Memory After: 8.63 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.0000741 | Memory Before: 8.65 Mb | Memory After: 8.66 Mb | Memory Used: 6.18 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.0000880 | Memory Before: 8.68 Mb | Memory After: 8.69 Mb | Memory Used: 9.76 kb | Rows: 72 | 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   211Using 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.0001550 | Memory Before: 8.7 Mb | Memory After: 8.7 Mb | Memory Used: 5.15 kb | Rows: 3 | 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,const2Using 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.0000720 | Memory Before: 8.69 Mb | Memory After: 8.69 Mb | Memory Used: 5.18 kb | Rows: 3 | 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,const2Using 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.0000880 | Memory Before: 8.7 Mb | Memory After: 8.7 Mb | Memory Used: 9.77 kb | Rows: 72 | 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   211Using 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.0000720 | Memory Before: 8.72 Mb | Memory After: 8.72 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.0000629 | Memory Before: 8.69 Mb | Memory After: 8.69 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.0001030 | Memory Before: 8.69 Mb | Memory After: 8.7 Mb | Memory Used: 9.75 kb | Rows: 72 | 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   211Using 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.0000739 | Memory Before: 8.72 Mb | Memory After: 8.73 Mb | Memory Used: 5.03 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 = 'fevent.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.0000639 | Memory Before: 8.7 Mb | Memory After: 8.7 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 = 'fevent' 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.0000749 | Memory Before: 8.7 Mb | Memory After: 8.71 Mb | Memory Used: 9.77 kb | Rows: 72 | 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   211Using 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.0000701 | Memory Before: 8.73 Mb | Memory After: 8.74 Mb | Memory Used: 5.39 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.0000730 | Memory Before: 8.71 Mb | Memory After: 8.72 Mb | Memory Used: 5.4 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.0000761 | Memory Before: 8.73 Mb | Memory After: 8.74 Mb | Memory Used: 9.81 kb | Rows: 72 | 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   211Using 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.0001669 | Memory Before: 8.98 Mb | Memory After: 9.02 Mb | Memory Used: 38.09 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.0001600 | Memory Before: 9.24 Mb | Memory After: 9.25 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 = '1'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEarefis_activeis_active53const,const1Using index condition
1SIMPLEacALLad_idMISSING KEY   1Using where; Using join buffer (flat, BNL join)
0.0001061 | Memory Before: 9.04 Mb | Memory After: 9.05 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 = '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.0000761 | Memory Before: 9.04 Mb | Memory After: 9.05 Mb | Memory Used: 3.66 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.0001490 | Memory Before: 9.56 Mb | Memory After: 9.57 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 = 'template.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001490 | Memory Before: 9.92 Mb | Memory After: 9.92 Mb | Memory Used: 3.35 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.0023921 | Memory Before: 10.1 Mb | Memory After: 10.11 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_id78const171Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0027671 | Memory Before: 10.12 Mb | Memory After: 10.12 Mb | Memory Used: 5.21 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.0038989 | Memory Before: 10.14 Mb | Memory After: 10.15 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_id78const259Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0001569 | Memory Before: 10.27 Mb | Memory After: 10.27 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.0001640 | Memory Before: 10.34 Mb | Memory After: 10.34 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.0000839 | Memory Before: 10.35 Mb | Memory After: 10.36 Mb | Memory Used: 3.17 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.0001562 | Memory Before: 10.57 Mb | Memory After: 10.57 Mb | Memory Used: 6.04 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.0000820 | Memory Before: 10.57 Mb | Memory After: 10.58 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.0000789 | Memory Before: 10.6 Mb | Memory After: 10.6 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.0072138 | Memory Before: 10.65 Mb | Memory After: 10.79 Mb | Memory Used: 136.82 kb | Rows: 237 | 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_id78const1221Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0613329 | Memory Before: 10.95 Mb | Memory After: 11.16 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|14const2879 (30%)Using index condition; Using where; Using rowid filter
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0107801 | Memory Before: 12.26 Mb | Memory After: 12.39 Mb | Memory Used: 136.2 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_id78const492Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0002501 | Memory Before: 21.83 Mb | Memory After: 21.84 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 = '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.0002470 | Memory Before: 21.83 Mb | Memory After: 21.84 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 = '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.0001440 | Memory Before: 21.83 Mb | Memory After: 21.84 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 = '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.0001209 | Memory Before: 21.84 Mb | Memory After: 21.85 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.0002351 | Memory Before: 21.84 Mb | Memory After: 21.85 Mb | Memory Used: 9.61 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.0001180 | Memory Before: 21.86 Mb | Memory After: 21.86 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.0001180 | Memory Before: 21.86 Mb | Memory After: 21.87 Mb | Memory Used: 9.58 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.0001121 | Memory Before: 21.86 Mb | Memory After: 21.87 Mb | Memory Used: 9.67 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.0001161 | Memory Before: 21.88 Mb | Memory After: 21.88 Mb | Memory Used: 3.2 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-menusub.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0104399 | Memory Before: 21.89 Mb | Memory After: 21.9 Mb | Memory Used: 9.14 kb | Rows: 247 | 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 = 'pages' 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_id78const668Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0126810 | Memory Before: 26.9 Mb | Memory After: 26.91 Mb | Memory Used: 10.5 kb | Rows: 304 | 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 = 'document' 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_id78const1150Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0001612 | Memory Before: 26.95 Mb | Memory After: 26.95 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'pages' AND name = 'photo.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001531 | Memory Before: 27.14 Mb | Memory After: 27.14 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 = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0001550 | Memory Before: 27.15 Mb | Memory After: 27.15 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'pages' AND name = 'like.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0000942 | Memory Before: 27.15 Mb | Memory After: 27.15 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'pages' AND name = 'like.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001628 | Memory Before: 27.42 Mb | Memory After: 27.43 Mb | Memory Used: 9.32 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "pages|like"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   12Using where
0.0000901 | Memory Before: 27.37 Mb | Memory After: 27.37 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'pages' AND name = '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.0001540 | Memory Before: 27.4 Mb | Memory After: 27.41 Mb | Memory Used: 3.16 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'share' AND name = 'link.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0028870 | Memory Before: 27.42 Mb | Memory After: 27.43 Mb | Memory Used: 5.13 kb | Rows: 75 | 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 = 'share' 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_id78const195Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0002241 | Memory Before: 27.73 Mb | Memory After: 27.75 Mb | Memory Used: 23.32 kb | Rows: 117 | 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_custom_option AS cmv
            ON(cmv.field_id = cf.field_id)
     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   83Using where; Using filesort
1SIMPLEcgeq_refPRIMARYPRIMARY2sqlgipsol.cf.group_id1 
1SIMPLEcmvreffield_idfield_id2sqlgipsol.cf.field_id11 
1SIMPLEmrefis_active,module_id,module_is_activemodule_is_active78sqlgipsol.cf.module_id,const8Using index
0.0001221 | Memory Before: 28.03 Mb | Memory After: 28.04 Mb | Memory Used: 5.93 kb | Rows: 72 | Slave: Yes
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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_custom_optionALLfield_idMISSING KEY   83Using where; Using filesort
0.0102870 | Memory Before: 28.08 Mb | Memory After: 28.09 Mb | Memory Used: 12.42 kb | Rows: 387 | 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_id78const1666Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0001469 | Memory Before: 27.89 Mb | Memory After: 27.9 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.0001631 | Memory Before: 28.07 Mb | Memory After: 28.07 Mb | Memory Used: 3.17 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'pages' AND name = 'joinpage.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001600 | Memory Before: 28.2 Mb | Memory After: 28.21 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 = '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.0000758 | Memory Before: 27.94 Mb | Memory After: 27.94 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.0001428 | Memory Before: 27.96 Mb | Memory After: 27.96 Mb | Memory Used: 3.2 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.0001459 | Memory Before: 27.96 Mb | Memory After: 27.96 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.0001471 | Memory Before: 27.96 Mb | Memory After: 27.97 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 = '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.0000770 | Memory Before: 27.97 Mb | Memory After: 27.97 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 = 'fevent' 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.0001400 | Memory Before: 28.08 Mb | Memory After: 28.08 Mb | Memory Used: 3.27 kb | Rows: 0 | Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition
0.0000780 | Memory Before: 28.09 Mb | Memory After: 28.09 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 = 'fevent' AND name = 'search.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0000670 | Memory Before: 28.1 Mb | Memory After: 28.1 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 = 'fevent' AND name = 'search.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001669 | Memory Before: 28.47 Mb | Memory After: 28.47 Mb | Memory Used: 5.44 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.0008659 | Memory Before: 28.6 Mb | Memory After: 28.63 Mb | Memory Used: 34.63 kb | Rows: 0 | 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_id = 0
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0000911 | Memory Before: 28.6 Mb | Memory After: 28.6 Mb | Memory Used: 3.38 kb | Rows: 0 | Slave: No
SELECT child_id, name
FROM phpfox_country_child
WHERE country_iso = ''
ORDER BY ordering ASC, name ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    Impossible WHERE noticed after reading const tables
0.0000851 | Memory Before: 28.6 Mb | Memory After: 28.6 Mb | Memory Used: 3.16 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 = 'country-child.html.php'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_templatereftheme_id,theme_id_2,foldertheme_id176const,const,const1Using index condition; Using where
0.0001130 | Memory Before: 28.6 Mb | Memory After: 28.61 Mb | Memory Used: 9.27 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "fevent|search"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   12Using where
0.0000920 | Memory Before: 28.16 Mb | Memory After: 28.17 Mb | Memory Used: 9.54 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.0000870 | Memory Before: 28.16 Mb | Memory After: 28.17 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.0000820 | Memory Before: 28.18 Mb | Memory After: 28.19 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-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.0017419 | Memory Before: 28.2 Mb | Memory After: 28.2 Mb | Memory Used: 4.41 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_id78const195Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
0.0083899 | Memory Before: 28.21 Mb | Memory After: 28.22 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_id78const481Using index condition; Using where
1SIMPLEproductrefis_active,product_active,product_idproduct_active28sqlgipsol.p.product_id,const3Using index
Session
Array
(
    [session] => cc4fb7f122b81d9e4f80dec72e85289e
    [redirect] => /mobile/pages/153/fevent/when_this-week/show_100/sort_most-liked
    [socialintegration_pageId] => 153
)
Cookie
TOP