Atsegin dut
| 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
phpFox Developers Debug
Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula
Total Time:
0.6436019
PHP General Time:
0.5012772
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.1423247
SQL Queries:
77
SQL Memory Usage:
1.41 Mb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
28.67 Mb
Total Memory Usage (Including Debug):
28.85 Mb
Memory Limit:
512 Mb (1024M)
Load Balancing Enabled:
No
Requests From:
192.168.100.222
Server Time Stamp:
April 8, 2026, 8:26 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.0001812
| 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 */
FROM phpfox_plugin AS p
JOIN phpfox_product AS product
ON(p.product_id = product.product_id AND product.is_active = 1)
JOIN phpfox_plugin_hook AS ph
ON(ph.call_name = p.call_name AND ph.is_active = 1)
JOIN phpfox_module AS m
ON(m.module_id = p.module_id AND m.is_active = 1)
WHERE p.is_active = 1
ORDER BY p.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | p | ALL | is_active | MISSING KEY | 5 | Using where; Using filesort | ||
| 1 | SIMPLE | ph | ref | call_name | call_name | 258 | sqlgipsol.p.call_name,const | 1 | Using where; Using index |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.p.module_id,const | 8 | Using index |
0.0008008
| Memory Before: 2.42 Mb
| Memory After: 2.43 Mb
| Memory Used: 1.35 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('5d190b47691329b47562fd318d0e35b6', '0d574f7196f9f96e319d05681455513d', '0', '1775636797', '/pages/70/fevent/when_this-month/show_15/sort_most-viewed', '0', '0', '0', '216.73.216.132', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.')
0.0052488
| Memory Before: 2.52 Mb
| Memory After: 2.55 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 */
FROM phpfox_user_group_setting AS user_group_setting
JOIN phpfox_module AS m
ON(m.module_id = user_group_setting.module_id)
LEFT JOIN phpfox_user_setting AS user_setting
ON(user_setting.user_group_id = '3' AND user_setting.setting_id = user_group_setting.setting_id)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | user_group_setting | ALL | module_id | MISSING KEY | 472 | Using where | ||
| 1 | SIMPLE | user_setting | ref | user_group_id | user_group_id | 4 | const,sqlgipsol.user_group_setting.setting_id | 1 | |
| 1 | SIMPLE | m | ref | module_id,module_is_active | module_id | 77 | sqlgipsol.user_group_setting.module_id | 8 | Using index |
0.0002120
| Memory Before: 4.01 Mb
| Memory After: 4.01 Mb
| Memory Used: 5.08 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 */
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ref | is_default | is_default | 1 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | sqlgipsol.s.theme_id | 1 |
0.0000911
| Memory Before: 4.01 Mb
| Memory After: 4.01 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 */
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_style | const | style_id_2,style_id | style_id_2 | 2 | const | 1 |
0.0003629
| Memory Before: 4.62 Mb
| Memory After: 4.63 Mb
| Memory Used: 6.16 kb
| Rows: 1
| Slave: No
SELECT *
FROM phpfox_language
WHERE language_id = 'eu'
/* OO Query */
FROM phpfox_language
WHERE language_id = 'eu'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_language | const | PRIMARY | PRIMARY | 14 | const | 1 |
0.0989392
| Memory Before: 4.63 Mb
| Memory After: 5.17 Mb
| Memory Used: 559.18 kb
| Rows: 15859
| 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 */
FROM phpfox_language_phrase AS p
LEFT JOIN phpfox_module AS m
ON(p.module_id = m.module_id AND m.is_active = 1)
JOIN phpfox_product AS product
ON(p.product_id = product.product_id AND product.is_active = 1)
WHERE p.language_id = 'eu'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | p | ALL | language_id,setting_list | MISSING KEY | 43059 | Using where | ||
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.p.module_id,const | 8 | Using where; Using index |
0.0047338
| Memory Before: 9.01 Mb
| Memory After: 9.37 Mb
| Memory Used: 366.92 kb
| Rows: 11627
| 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 */
FROM phpfox_language_phrase AS p
LEFT JOIN phpfox_module AS m
ON(p.module_id = m.module_id AND m.is_active = 1)
JOIN phpfox_product AS product
ON(p.product_id = product.product_id AND product.is_active = 1)
WHERE p.language_id = 'en'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | p | ALL | language_id,setting_list | MISSING KEY | 43059 | Using where | ||
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.p.product_id,const | 3 | Using index |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.p.module_id,const | 8 | Using where; Using index |
0.0005670
| Memory Before: 21.52 Mb
| Memory After: 21.52 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 */
FROM phpfox_language_rule
WHERE language_id = 'eu'
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0002909
| Memory Before: 4.49 Mb
| Memory After: 4.51 Mb
| Memory Used: 17.52 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 */
FROM phpfox_block AS b
LEFT JOIN phpfox_block_source AS bs
ON(bs.block_id = b.block_id)
JOIN phpfox_module AS m
ON(b.module_id = m.module_id AND m.is_active = 1)
JOIN phpfox_product AS p
ON(b.product_id = p.product_id AND p.is_active = 1)
WHERE b.is_active = 1
ORDER BY b.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | index | is_active,module_id,module_is_active | module_is_active | 78 | 85 | Using where; Using index; Using temporary; Using filesort | |
| 1 | SIMPLE | b | ref|filter | is_active,product_id,module_id | module_id|is_active | 77|1 | sqlgipsol.m.module_id | 9 (63%) | Using where; Using rowid filter |
| 1 | SIMPLE | bs | ref | block_id | block_id | 4 | sqlgipsol.b.block_id | 5 | |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.b.product_id,const | 3 | Using index |
0.0005660
| Memory Before: 5.59 Mb
| Memory After: 5.6 Mb
| Memory Used: 4.18 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_pages_design_order
WHERE page_id = 70
ORDER BY ordering ASC
/* OO Query */
FROM phpfox_pages_design_order
WHERE page_id = 70
ORDER BY ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0018229
| Memory Before: 5.85 Mb
| Memory After: 5.87 Mb
| Memory Used: 15.7 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 = 70
/* OO Query */
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 = 70
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pg | system | PRIMARY,category_id | MISSING KEY | Const row not found | |||
| 1 | SIMPLE | pc | system | page_id | MISSING KEY | Const row not found | |||
| 1 | SIMPLE | p | const | PRIMARY,page_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | f | const | user_check,user_id,top_friend,friend_user_id | user_check | 8 | const,const | Unique row not found | |
| 1 | SIMPLE | pt | const | page_id | page_id | 4 | const | 1 | |
| 1 | SIMPLE | u2 | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | u | ref | page_id | page_id | 4 | const | 1 | |
| 1 | SIMPLE | pu | ref | page_id | page_id | 4 | const | 1 | |
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | type_id_3|item_id | 81|4 | const,const | 1 (1%) | Using where; Using rowid filter |
| 1 | SIMPLE | ts | eq_ref | style_id_2,style_id | style_id_2 | 2 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | sqlgipsol.ts.theme_id | 1 | Using where |
0.0005181
| Memory Before: 5.95 Mb
| Memory After: 5.95 Mb
| Memory Used: 4.02 kb
| Rows: 13
| Slave: Yes
SELECT *
FROM phpfox_pages_perm
WHERE page_id = 70
/* OO Query */
FROM phpfox_pages_perm
WHERE page_id = 70
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_pages_perm | ref | page_id | page_id | 4 | const | 13 |
0.0003791
| Memory Before: 5.96 Mb
| Memory After: 5.96 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 = 70
/* OO Query */
FROM phpfox_pages_widget AS pw
JOIN phpfox_pages_widget_text AS pwt
ON(pwt.widget_id = pw.widget_id)
WHERE pw.page_id = 70
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0002110
| Memory Before: 6.8 Mb
| Memory After: 6.8 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 */
FROM phpfox_fevent_cron AS s
WHERE 1=1 AND `type_cron` = 'for_repeat'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ALL | MISSING KEY | 103467 | Using where |
0.0001001
| Memory Before: 6.8 Mb
| Memory After: 6.8 Mb
| Memory Used: 3.13 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 */
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 */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | l | ref | type_id,type_id_2,type_id_3,item_id | type_id_3 | 81 | const,const | 1 | Using index condition |
| 1 | SIMPLE | p | eq_ref | PRIMARY,view_id_2,view_id,page_id | PRIMARY | 4 | sqlgipsol.l.item_id | 1 | Using where |
0.0001090
| Memory Before: 6.8 Mb
| Memory After: 6.8 Mb
| Memory Used: 3.4 kb
| Rows: 0
| Slave: Yes
SELECT category_id,name
FROM phpfox_event_category
WHERE name_url = 'fevent'
/* OO Query */
FROM phpfox_event_category
WHERE name_url = 'fevent'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_event_category | ALL | MISSING KEY | 8 | Using where |
0.0036411
| Memory Before: 7.51 Mb
| Memory After: 7.52 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 */
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 */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0009449
| Memory Before: 8.68 Mb
| Memory After: 8.69 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 = 70 AND ( m.start_time >= 1774994400 AND m.start_time <= 1777586399 ) AND ( m.start_time >= 1774994400 AND m.start_time <= 1777586399 )
LIMIT 1
/* OO Query */
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 = 70 AND ( m.start_time >= 1774994400 AND m.start_time <= 1777586399 ) AND ( m.start_time >= 1774994400 AND m.start_time <= 1777586399 )
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | range | PRIMARY,module_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | view_id | 10 | 1 | Using index condition; Using where | |
| 1 | SIMPLE | ft | ref | event_id | event_id | 4 | sqlgipsol.m.event_id | 1 | Using index |
0.0106790
| Memory Before: 8.64 Mb
| Memory After: 8.65 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>1775606400))) or ( v.isrepeat = -1 AND v.end_time >= '1775606400' ) )
ORDER BY v.start_time ASC
/* OO Query */
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>1775606400))) or ( v.isrepeat = -1 AND v.end_time >= '1775606400' ) )
ORDER BY v.start_time ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | v | ALL | user_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | MISSING KEY | 9007 | Using where; Using filesort | ||
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.v.user_id | 1 |
0.0001869
| Memory Before: 8.92 Mb
| Memory After: 8.93 Mb
| Memory Used: 3.71 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 */
FROM phpfox_rss AS r
JOIN phpfox_module AS m
ON(m.module_id = r.module_id AND m.is_active = 1)
JOIN phpfox_product AS p
ON(p.product_id = r.product_id AND p.is_active = 1)
WHERE r.is_active = 1 AND r.is_site_wide = 1
ORDER BY r.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | r | ALL | is_active | MISSING KEY | 8 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.r.product_id,const | 3 | Using index |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.r.module_id,const | 8 | Using index |
0.0002019
| Memory Before: 9.05 Mb
| Memory After: 9.06 Mb
| Memory Used: 6.16 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | index_merge | product_id,m_connection,parent_id | m_connection,parent_id | 79,3 | 4 | Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort | |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0001049
| Memory Before: 9.08 Mb
| Memory After: 9.09 Mb
| Memory Used: 6.16 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | index_merge | product_id,m_connection,parent_id | m_connection,parent_id | 79,3 | 4 | Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort | |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0001009
| Memory Before: 9.11 Mb
| Memory After: 9.12 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | 211 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0002692
| Memory Before: 9.25 Mb
| Memory After: 9.26 Mb
| Memory Used: 10.24 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0001922
| Memory Before: 9.25 Mb
| Memory After: 9.26 Mb
| Memory Used: 10.27 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0001719
| Memory Before: 9.14 Mb
| Memory After: 9.14 Mb
| Memory Used: 5.14 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main_right' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 2 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000801
| Memory Before: 9.13 Mb
| Memory After: 9.13 Mb
| Memory Used: 5.14 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'main_right' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 2 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000982
| Memory Before: 9.13 Mb
| Memory After: 9.14 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | 211 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000880
| Memory Before: 9.26 Mb
| Memory After: 9.27 Mb
| Memory Used: 10.3 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0000701
| Memory Before: 9.26 Mb
| Memory After: 9.27 Mb
| Memory Used: 10.27 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0000811
| Memory Before: 9.16 Mb
| Memory After: 9.17 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'explore' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000691
| Memory Before: 9.13 Mb
| Memory After: 9.14 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'explore' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000920
| Memory Before: 9.13 Mb
| Memory After: 9.14 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | 211 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000851
| Memory Before: 9.26 Mb
| Memory After: 9.27 Mb
| Memory Used: 10.3 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0000710
| Memory Before: 9.26 Mb
| Memory After: 9.27 Mb
| Memory Used: 10.24 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0005431
| Memory Before: 9.17 Mb
| Memory After: 9.18 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 = 'fevent.index' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
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 */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0003719
| Memory Before: 9.14 Mb
| Memory After: 9.15 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 */
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 */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | product_id,m_connection,parent_id | m_connection | 79 | const,const | 1 | Using index condition; Using where; Using temporary; Using filesort |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000961
| Memory Before: 9.15 Mb
| Memory After: 9.16 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | 211 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000870
| Memory Before: 9.27 Mb
| Memory After: 9.28 Mb
| Memory Used: 10.24 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0000699
| Memory Before: 9.28 Mb
| Memory After: 9.29 Mb
| Memory Used: 10.25 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0000820
| Memory Before: 9.18 Mb
| Memory After: 9.19 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'footer' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | index_merge | product_id,m_connection,parent_id | m_connection,parent_id | 79,3 | 1 | Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort | |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000720
| Memory Before: 9.17 Mb
| Memory After: 9.17 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id = 0 AND m.m_connection = 'footer' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | index_merge | product_id,m_connection,parent_id | m_connection,parent_id | 79,3 | 1 | Using intersect(m_connection,parent_id); Using where; Using temporary; Using filesort | |
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000918
| Memory Before: 9.18 Mb
| Memory After: 9.19 Mb
| Memory Used: 9.79 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 */
FROM phpfox_menu AS m
JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)
WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | 211 | Using where; Using filesort | ||
| 1 | SIMPLE | p | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.m.product_id,const | 3 | Using index |
| 1 | SIMPLE | mo | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.m.module_id,const | 8 | Using index |
0.0000939
| Memory Before: 9.3 Mb
| Memory After: 9.31 Mb
| Memory Used: 10.24 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.user_id = 0 AND user_group_id IN (1, 4)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0000701
| Memory Before: 9.31 Mb
| Memory After: 9.32 Mb
| Memory Used: 10.24 kb
| Rows: 0
| Slave: No
SELECT u.*
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
FROM phpfox_user AS u
WHERE u.gender IN (3, 4) AND u.user_id = 0 AND NOT user_group_id IN (1, 4)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0001700
| Memory Before: 10.04 Mb
| Memory After: 10.05 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'template.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002210
| Memory Before: 10.91 Mb
| Memory After: 10.92 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 = 'core' AND name = 'template-body.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002298
| Memory Before: 11 Mb
| Memory After: 11 Mb
| Memory Used: 3.18 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'cabecera.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002089
| Memory Before: 11.15 Mb
| Memory After: 11.15 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001199
| Memory Before: 11.17 Mb
| Memory After: 11.17 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002649
| Memory Before: 22.34 Mb
| Memory After: 22.34 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002069
| Memory Before: 22.35 Mb
| Memory After: 22.35 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002060
| Memory Before: 22.37 Mb
| Memory After: 22.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-menusub.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-menusub.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002439
| Memory Before: 27.53 Mb
| Memory After: 27.53 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 = 'pages' AND name = 'photo.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'pages' AND name = 'photo.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001550
| Memory Before: 27.55 Mb
| Memory After: 27.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 = 'layout' AND name = 'block.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0001218
| Memory Before: 27.56 Mb
| Memory After: 27.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 = 'pages' AND name = 'like.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'pages' AND name = 'like.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001092
| Memory Before: 27.57 Mb
| Memory After: 27.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 = 'block' AND module_id = 'pages' AND name = 'like.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'pages' AND name = 'like.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0012760
| Memory Before: 27.84 Mb
| Memory After: 27.85 Mb
| Memory Used: 9.27 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "pages|like"
/* OO Query */
FROM phpfox_ad
WHERE location = "pages|like"
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_ad | ALL | MISSING KEY | 12 | Using where |
0.0002320
| 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 = 'block' AND module_id = 'pages' AND name = 'menu.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'pages' AND name = 'menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002232
| Memory Before: 27.79 Mb
| Memory After: 27.79 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 = 'share' AND name = 'link.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'share' AND name = 'link.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002968
| Memory Before: 28.12 Mb
| Memory After: 28.14 Mb
| Memory Used: 23.33 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 */
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 */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | cf | ALL | MISSING KEY | 83 | Using where; Using filesort | |||
| 1 | SIMPLE | cg | eq_ref | PRIMARY | PRIMARY | 2 | sqlgipsol.cf.group_id | 1 | |
| 1 | SIMPLE | cmv | ref | field_id | field_id | 2 | sqlgipsol.cf.field_id | 11 | |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.cf.module_id,const | 8 | Using index |
0.0002429
| Memory Before: 28.42 Mb
| Memory After: 28.42 Mb
| Memory Used: 5.95 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 */
FROM phpfox_custom_option
WHERE field_id IN(93,22,9,79,80,81,48,33,38,51,53,54,55,58,59,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77)
ORDER BY option_id ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_custom_option | ALL | field_id | MISSING KEY | 83 | Using where; Using filesort |
0.0001211
| Memory Before: 28.28 Mb
| Memory After: 28.29 Mb
| Memory Used: 3.16 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/header.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001690
| Memory Before: 28.46 Mb
| Memory After: 28.46 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'pages' AND name = 'joinpage.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001631
| Memory Before: 28.33 Mb
| Memory After: 28.33 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 = 'search.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002201
| Memory Before: 28.35 Mb
| Memory After: 28.35 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-contentclass.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002038
| Memory Before: 28.35 Mb
| Memory After: 28.35 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002310
| Memory Before: 28.36 Mb
| Memory After: 28.36 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'controller' AND module_id = 'fevent' AND name = 'index.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001409
| Memory Before: 28.47 Mb
| Memory After: 28.47 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'block.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0000942
| Memory Before: 28.48 Mb
| Memory After: 28.48 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'fevent' AND name = 'search.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0001030
| Memory Before: 28.49 Mb
| Memory After: 28.49 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'fevent' AND name = 'search.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0011399
| Memory Before: 28.99 Mb
| Memory After: 29.02 Mb
| Memory Used: 34.78 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 */
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 */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0003810
| Memory Before: 28.99 Mb
| Memory After: 29 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 */
FROM phpfox_country_child
WHERE country_iso = ''
ORDER BY ordering ASC, name ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0001340
| Memory Before: 28.99 Mb
| Memory After: 28.99 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'country-child.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0005801
| Memory Before: 28.99 Mb
| Memory After: 29 Mb
| Memory Used: 9.27 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "fevent|search"
/* OO Query */
FROM phpfox_ad
WHERE location = "fevent|search"
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_ad | ALL | MISSING KEY | 12 | Using where |
0.0001760
| Memory Before: 28.58 Mb
| Memory After: 28.59 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 */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
Array
(
[session] => 5d190b47691329b47562fd318d0e35b6
[redirect] => /pages/70/fevent/when_this-month/show_15/sort_most-viewed
[socialintegration_pageId] => 70
)
Array ( )
