| 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 : 3428 | require("file/cache/template/frontend_tm_base5_template_template.html.php.php") | |||||||
| 6 | include/library/phpfox/template/template.class.php : 3414 | 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 : 3428 | require("file/cache/template/frontend_tm_base5_template_template.html.php.php") | |||||||
| 6 | include/library/phpfox/template/template.class.php : 3414 | 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.3952851
PHP General Time:
0.277917
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.1173681
SQL Queries:
105
SQL Memory Usage:
452.73 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
24.7 Mb
Total Memory Usage (Including Debug):
24.89 Mb
Memory Limit:
512 Mb (1024M)
Load Balancing Enabled:
No
Requests From:
192.168.100.222
Server Time Stamp:
January 25, 2026, 4:08 pm
PHP Version:
5.6.40
PHP Sapi:
fpm-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux
Cache:
file
SQL Queries
0.0001431
| 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.0006239
| Memory Before: 2.42 Mb
| Memory After: 2.42 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 = '252eb3e7e83754d28065118574d095db' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
FROM phpfox_log_session AS s
WHERE s.session_hash = '252eb3e7e83754d28065118574d095db' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ref | session_hash,log_session | session_hash | 32 | const | 1 | Using index condition; Using where |
0.0005441
| Memory Before: 2.42 Mb
| Memory After: 2.43 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session SET last_activity = '1769357339', user_id = '0', location = '/fevent-7207-i-jornadas-de-divulgaci-243n-y-sensibilizaci-243n-en-alimentaci-243n-consciente/wall', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.178', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = '252eb3e7e83754d28065118574d095db'
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_log_session | ref | session_hash,log_session | session_hash | 32 | const | 1 | Using index condition |
0.0002289
| Memory Before: 3.75 Mb
| Memory After: 3.75 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 */
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.0001070
| Memory Before: 3.75 Mb
| Memory After: 3.75 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.0017200
| Memory Before: 5.22 Mb
| Memory After: 5.25 Mb
| Memory Used: 35.59 kb
| Rows: 1
| Slave: Yes
SELECT p.photo_id as cover_photo_exists, u.*, user_space.*, user_field.*, user_activity.*, ls.user_id AS is_online, ts.style_id AS designer_style_id, ts.folder AS designer_style_folder, t.folder AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id AS theme_parent_id, ug.prefix, ug.suffix, ug.icon_ext, ug.title, uf.user_id as is_featured
FROM phpfox_user AS u
JOIN phpfox_user_group AS ug
ON(ug.user_group_id = u.user_group_id)
JOIN phpfox_user_space AS user_space
ON(user_space.user_id = u.user_id)
JOIN phpfox_user_field AS user_field
ON(user_field.user_id = u.user_id)
JOIN phpfox_user_activity AS user_activity
ON(user_activity.user_id = u.user_id)
LEFT JOIN phpfox_theme_style AS ts
ON(ts.style_id = user_field.designer_style_id AND ts.is_active = 1)
LEFT JOIN phpfox_theme AS t
ON(t.theme_id = ts.theme_id)
LEFT JOIN phpfox_user_featured AS uf
ON(uf.user_id = u.user_id)
LEFT JOIN phpfox_log_session AS ls
ON(ls.user_id = u.user_id AND ls.im_hide = 0)
LEFT JOIN phpfox_photo AS p
ON(p.photo_id = user_field.cover_photo)
WHERE u.user_name = 'fevent-7207-i-jornadas-de-divulgaci-243n-y-sensibilizaci-243n-en-alimentaci-243n-consciente'
/* 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_name = 'fevent-7207-i-jornadas-de-divulgaci-243n-y-sensibilizaci-243n-en-alimentaci-243n-consciente'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | u | ref | PRIMARY,user_group_id,user_id,user_name | user_name | 103 | const | 1 | Using index condition |
| 1 | SIMPLE | user_field | eq_ref | user_id | user_id | 4 | sqlgipsol.u.user_id | 1 | |
| 1 | SIMPLE | ts | eq_ref | style_id_2,style_id,is_active | style_id_2 | 2 | sqlgipsol.user_field.designer_style_id | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | sqlgipsol.ts.theme_id | 1 | Using where |
| 1 | SIMPLE | ug | eq_ref | PRIMARY,user_group_id | PRIMARY | 1 | sqlgipsol.u.user_group_id | 1 | Using index condition |
| 1 | SIMPLE | uf | eq_ref | PRIMARY | PRIMARY | 4 | sqlgipsol.u.user_id | 1 | Using index |
| 1 | SIMPLE | user_space | eq_ref | user_id | user_id | 4 | sqlgipsol.u.user_id | 1 | |
| 1 | SIMPLE | user_activity | eq_ref | user_id | user_id | 4 | sqlgipsol.u.user_id | 1 | |
| 1 | SIMPLE | ls | ref | user_id,user_id_2,user_id_3 | user_id | 5 | sqlgipsol.u.user_id,const | 723 | Using index |
| 1 | SIMPLE | p | eq_ref | PRIMARY,photo_id,photo_id_2 | PRIMARY | 4 | sqlgipsol.user_field.cover_photo | 1 | Using index |
0.0001390
| Memory Before: 5.51 Mb
| Memory After: 5.52 Mb
| Memory Used: 3.41 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_pages_url
WHERE vanity_url = 'fevent-7207-i-jornadas-de-divulgaci-243n-y-sensibilizaci-243n-en-alimentaci-243n-consciente'
/* OO Query */
FROM phpfox_pages_url
WHERE vanity_url = 'fevent-7207-i-jornadas-de-divulgaci-243n-y-sensibilizaci-243n-en-alimentaci-243n-consciente'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_pages_url | ref | vanity_url | vanity_url | 257 | const | 1 | Using index condition |
0.0002811
| Memory Before: 5.6 Mb
| Memory After: 5.64 Mb
| Memory Used: 40.14 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 = 152
/* 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 = 152
/* 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.0001221
| Memory Before: 5.74 Mb
| Memory After: 5.75 Mb
| Memory Used: 4.02 kb
| Rows: 13
| Slave: Yes
SELECT *
FROM phpfox_pages_perm
WHERE page_id = 152
/* OO Query */
FROM phpfox_pages_perm
WHERE page_id = 152
/* 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 | 18 |
0.0001009
| Memory Before: 5.75 Mb
| Memory After: 5.75 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 = 152
/* 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 = 152
/* 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.0002179
| Memory Before: 9.34 Mb
| Memory After: 9.35 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 = '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.0002160
| Memory Before: 10.9 Mb
| Memory After: 10.91 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 */
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.0001180
| Memory Before: 11.1 Mb
| Memory After: 11.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 = '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.0001061
| Memory Before: 11.24 Mb
| Memory After: 11.25 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 = '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.0001988
| Memory Before: 11.27 Mb
| Memory After: 11.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 = '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.0002992
| Memory Before: 22.43 Mb
| Memory After: 22.43 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.0002151
| Memory Before: 22.44 Mb
| Memory After: 22.45 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.0002909
| Memory Before: 22.79 Mb
| Memory After: 22.81 Mb
| Memory Used: 22.18 kb
| Rows: 109
| 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 | 82 | 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 | 10 | |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.cf.module_id,const | 8 | Using index |
0.0001450
| Memory Before: 23.09 Mb
| Memory After: 23.09 Mb
| Memory Used: 5.68 kb
| Rows: 64
| Slave: Yes
SELECT *
FROM phpfox_custom_option
WHERE field_id IN(22,9,79,80,81,48,33,38,51,53,54,55,58,59,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77)
ORDER BY option_id ASC
/* OO Query */
FROM phpfox_custom_option
WHERE field_id IN(22,9,79,80,81,48,33,38,51,53,54,55,58,59,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77)
ORDER BY option_id ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_custom_option | ALL | field_id | MISSING KEY | 75 | Using where; Using filesort |
0.0002129
| Memory Before: 22.95 Mb
| Memory After: 22.96 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.0002091
| Memory Before: 23.24 Mb
| Memory After: 23.24 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/pic.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/pic.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002091
| Memory Before: 23.16 Mb
| Memory After: 23.16 Mb
| Memory Used: 3.74 kb
| Rows: 3
| Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 2617
/* OO Query */
FROM phpfox_user_privacy
WHERE user_id = 2617
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_user_privacy | ref | user_id,user_id_2 | user_id | 4 | const | 9 |
0.0002079
| Memory Before: 23.05 Mb
| Memory After: 23.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 = '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.0002060
| Memory Before: 23.06 Mb
| Memory After: 23.07 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.0002110
| Memory Before: 23.06 Mb
| Memory After: 23.07 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.0006962
| Memory Before: 23.07 Mb
| Memory After: 23.08 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 = 'pages' AND name = 'view.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'controller' AND module_id = 'pages' AND name = 'view.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.0004740
| Memory Before: 23.66 Mb
| Memory After: 23.66 Mb
| Memory Used: 3.41 kb
| Rows: 0
| Slave: Yes
SELECT var_name, user_value
FROM phpfox_component_setting
WHERE user_id = 2618
/* OO Query */
FROM phpfox_component_setting
WHERE user_id = 2618
/* 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.0008190
| Memory Before: 23.66 Mb
| Memory After: 23.67 Mb
| Memory Used: 8.34 kb
| Rows: 1
| Slave: Yes
SELECT feed.*, 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, u.view_id
FROM phpfox_pages_feed AS feed
JOIN phpfox_user AS u
ON(u.user_id = feed.user_id)
WHERE feed.parent_user_id = 152
ORDER BY feed.time_update DESC
LIMIT 4
/* OO Query */
FROM phpfox_pages_feed AS feed
JOIN phpfox_user AS u
ON(u.user_id = feed.user_id)
WHERE feed.parent_user_id = 152
ORDER BY feed.time_update DESC
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | feed | ref | parent_user_id | parent_user_id | 4 | const | 1 | Using where; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.feed.user_id | 1 |
0.0011189
| Memory Before: 23.79 Mb
| Memory After: 23.81 Mb
| Memory Used: 11.46 kb
| Rows: 1
| Slave: Yes
SELECT photo.*, l.like_id AS is_liked, pi.description, pfeed.photo_id AS extra_photo_id, pa.album_id, pa.name
FROM phpfox_photo AS photo
JOIN phpfox_photo_info AS pi
ON(pi.photo_id = photo.photo_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
LEFT JOIN phpfox_photo_feed AS pfeed
ON(pfeed.feed_id = 25)
LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = photo.album_id)
WHERE photo.photo_id = 4482
/* OO Query */
FROM phpfox_photo AS photo
JOIN phpfox_photo_info AS pi
ON(pi.photo_id = photo.photo_id)
LEFT JOIN phpfox_like AS l
ON(l.type_id = 'photo' AND l.item_id = photo.photo_id AND l.user_id = 0)
LEFT JOIN phpfox_photo_feed AS pfeed
ON(pfeed.feed_id = 25)
LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = photo.album_id)
WHERE photo.photo_id = 4482
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | photo | const | PRIMARY,photo_id,photo_id_2 | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | pi | const | photo_id | photo_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 | pfeed | ref | feed_id | feed_id | 4 | const | 1 | |
| 1 | SIMPLE | pa | eq_ref | PRIMARY,album_id | PRIMARY | 4 | const | 1 |
0.0011110
| Memory Before: 24.07 Mb
| Memory After: 24.07 Mb
| Memory Used: 6.7 kb
| Rows: 0
| Slave: Yes
SELECT l.*, 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, a.time_stamp as action_time_stamp
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
LEFT JOIN phpfox_action AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "photo")
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 4482
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
LEFT JOIN phpfox_action AS a
ON(a.item_id = l.item_id AND a.user_id = l.user_id AND a.item_type_id = "photo")
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 4482
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | system | type_id,type_id_2,type_id_3,item_id | MISSING KEY | Const row not found; Using temporary; Using filesort | |||
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | item_id|type_id_3 | 4|77 | const | 1 (3%) | Using where; Using rowid filter |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0005550
| Memory Before: 24.07 Mb
| Memory After: 24.07 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 4482
LIMIT 1
/* OO Query */
FROM phpfox_like AS l
WHERE (l.type_id = 'photo' OR l.type_id = 'photo') AND l.item_id = 4482
LIMIT 1
/* 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 | 81 | const,const | 1 | Using where; Using index |
0.0003591
| Memory Before: 24.07 Mb
| Memory After: 24.08 Mb
| Memory Used: 5.36 kb
| Rows: 0
| Slave: Yes
SELECT 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_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "photo" AND a.item_id = 4482
GROUP BY u.user_id
/* OO Query */
FROM phpfox_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "photo" AND a.item_id = 4482
GROUP BY u.user_id
/* 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.0006700
| Memory Before: 24.07 Mb
| Memory After: 24.08 Mb
| Memory Used: 5.36 kb
| Rows: 0
| Slave: No
SELECT 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_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
WHERE l.type_id = 'photo' AND l.item_id = 4482
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* OO Query */
FROM phpfox_like AS l
JOIN phpfox_user AS u
ON(u.user_id = l.user_id)
WHERE l.type_id = 'photo' AND l.item_id = 4482
GROUP BY u.user_id
ORDER BY u.full_name ASC
/* 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_2 | 81 | const,const | 1 | Using where; Using index; Using temporary; Using filesort |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 |
0.0001249
| Memory Before: 24.09 Mb
| Memory After: 24.09 Mb
| Memory Used: 5.38 kb
| Rows: 0
| Slave: Yes
SELECT 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_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "photo" AND a.item_id = 4482
GROUP BY u.user_id
/* OO Query */
FROM phpfox_action AS a
JOIN phpfox_user AS u
ON(u.user_id = a.user_id)
WHERE a.item_type_id = "photo" AND a.item_id = 4482
GROUP BY u.user_id
/* 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.0003340
| Memory Before: 24.09 Mb
| Memory After: 24.09 Mb
| Memory Used: 5.46 kb
| Rows: 1
| Slave: Yes
SELECT 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_user AS u
WHERE user_id IN (2618)
/* OO Query */
FROM phpfox_user AS u
WHERE user_id IN (2618)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | u | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 |
0.0001252
| Memory Before: 23.99 Mb
| Memory After: 24 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT count(*)
FROM phpfox_feed
LIMIT 1
/* OO Query */
FROM phpfox_feed
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Select tables optimized away |
0.0009820
| Memory Before: 24.28 Mb
| Memory After: 24.28 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1767225600' AND time_stamp <= '1798675200'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1767225600' AND time_stamp <= '1798675200'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0131240
| Memory Before: 24.28 Mb
| Memory After: 24.28 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1735689600' AND time_stamp <= '1767139200'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1735689600' AND time_stamp <= '1767139200'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1270 | Using index condition; Using where |
0.0082290
| Memory Before: 24.28 Mb
| Memory After: 24.29 Mb
| Memory Used: 3.13 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1704067200' AND time_stamp <= '1735603200'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1704067200' AND time_stamp <= '1735603200'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1138 | Using index condition; Using where |
0.0074081
| Memory Before: 24.28 Mb
| Memory After: 24.29 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1672531200' AND time_stamp <= '1703980800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1672531200' AND time_stamp <= '1703980800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1327 | Using index condition; Using where |
0.0078931
| Memory Before: 24.29 Mb
| Memory After: 24.29 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1640995200' AND time_stamp <= '1672444800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1640995200' AND time_stamp <= '1672444800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1519 | Using index condition; Using where |
0.0085750
| Memory Before: 24.29 Mb
| Memory After: 24.29 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1609459200' AND time_stamp <= '1640908800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1609459200' AND time_stamp <= '1640908800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1310 | Using index condition; Using where |
0.0077059
| Memory Before: 24.29 Mb
| Memory After: 24.29 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1577836800' AND time_stamp <= '1609372800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1577836800' AND time_stamp <= '1609372800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 763 | Using index condition; Using where |
0.0060401
| Memory Before: 24.29 Mb
| Memory After: 24.29 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1546300800' AND time_stamp <= '1577750400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1546300800' AND time_stamp <= '1577750400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 691 | Using index condition; Using where |
0.0116391
| Memory Before: 24.29 Mb
| Memory After: 24.29 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1514764800' AND time_stamp <= '1546214400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1514764800' AND time_stamp <= '1546214400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1148 | Using index condition; Using where |
0.0094030
| Memory Before: 24.29 Mb
| Memory After: 24.3 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1483228800' AND time_stamp <= '1514678400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1483228800' AND time_stamp <= '1514678400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1223 | Using index condition; Using where |
0.0070169
| Memory Before: 24.29 Mb
| Memory After: 24.3 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1451606400' AND time_stamp <= '1483142400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1451606400' AND time_stamp <= '1483142400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 891 | Using index condition; Using where |
0.0021541
| Memory Before: 24.3 Mb
| Memory After: 24.3 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1420070400' AND time_stamp <= '1451520000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1420070400' AND time_stamp <= '1451520000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 249 | Using index condition; Using where |
0.0023692
| Memory Before: 24.3 Mb
| Memory After: 24.3 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1388534400' AND time_stamp <= '1419984000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1388534400' AND time_stamp <= '1419984000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 285 | Using index condition; Using where |
0.0006540
| Memory Before: 24.3 Mb
| Memory After: 24.3 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1356998400' AND time_stamp <= '1388448000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1356998400' AND time_stamp <= '1388448000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 62 | Using index condition; Using where |
0.0002131
| Memory Before: 24.3 Mb
| Memory After: 24.3 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1325376000' AND time_stamp <= '1356912000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1325376000' AND time_stamp <= '1356912000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0002372
| Memory Before: 24.3 Mb
| Memory After: 24.3 Mb
| Memory Used: 3.13 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1293840000' AND time_stamp <= '1325289600'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1293840000' AND time_stamp <= '1325289600'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001941
| Memory Before: 24.3 Mb
| Memory After: 24.31 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1262304000' AND time_stamp <= '1293753600'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1262304000' AND time_stamp <= '1293753600'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0002191
| Memory Before: 24.3 Mb
| Memory After: 24.31 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1230768000' AND time_stamp <= '1262217600'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1230768000' AND time_stamp <= '1262217600'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0002089
| Memory Before: 24.31 Mb
| Memory After: 24.31 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1199145600' AND time_stamp <= '1230681600'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1199145600' AND time_stamp <= '1230681600'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0002060
| Memory Before: 24.31 Mb
| Memory After: 24.31 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1167609600' AND time_stamp <= '1199059200'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1167609600' AND time_stamp <= '1199059200'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001900
| Memory Before: 24.31 Mb
| Memory After: 24.31 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1136073600' AND time_stamp <= '1167523200'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1136073600' AND time_stamp <= '1167523200'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0002100
| Memory Before: 24.31 Mb
| Memory After: 24.31 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1104537600' AND time_stamp <= '1135987200'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1104537600' AND time_stamp <= '1135987200'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0002000
| Memory Before: 24.31 Mb
| Memory After: 24.32 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1072915200' AND time_stamp <= '1104451200'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1072915200' AND time_stamp <= '1104451200'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001931
| Memory Before: 24.31 Mb
| Memory After: 24.32 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1041379200' AND time_stamp <= '1072828800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1041379200' AND time_stamp <= '1072828800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001910
| Memory Before: 24.32 Mb
| Memory After: 24.32 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1009843200' AND time_stamp <= '1041292800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '1009843200' AND time_stamp <= '1041292800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001941
| Memory Before: 24.32 Mb
| Memory After: 24.32 Mb
| Memory Used: 3.15 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '978307200' AND time_stamp <= '1009756800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '978307200' AND time_stamp <= '1009756800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001860
| Memory Before: 24.32 Mb
| Memory After: 24.32 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '946684800' AND time_stamp <= '978220800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '946684800' AND time_stamp <= '978220800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001810
| Memory Before: 24.32 Mb
| Memory After: 24.32 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '915148800' AND time_stamp <= '946598400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '915148800' AND time_stamp <= '946598400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001841
| Memory Before: 24.32 Mb
| Memory After: 24.32 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '883612800' AND time_stamp <= '915062400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '883612800' AND time_stamp <= '915062400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0002069
| Memory Before: 24.32 Mb
| Memory After: 24.33 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '852076800' AND time_stamp <= '883526400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '852076800' AND time_stamp <= '883526400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001860
| Memory Before: 24.32 Mb
| Memory After: 24.33 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '820454400' AND time_stamp <= '851990400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '820454400' AND time_stamp <= '851990400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001810
| Memory Before: 24.33 Mb
| Memory After: 24.33 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '788918400' AND time_stamp <= '820368000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '788918400' AND time_stamp <= '820368000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001800
| Memory Before: 24.33 Mb
| Memory After: 24.33 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '757382400' AND time_stamp <= '788832000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '757382400' AND time_stamp <= '788832000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001800
| Memory Before: 24.33 Mb
| Memory After: 24.33 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '725846400' AND time_stamp <= '757296000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '725846400' AND time_stamp <= '757296000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001721
| Memory Before: 24.33 Mb
| Memory After: 24.33 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '694224000' AND time_stamp <= '725760000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '694224000' AND time_stamp <= '725760000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001788
| Memory Before: 24.33 Mb
| Memory After: 24.34 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '662688000' AND time_stamp <= '694137600'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '662688000' AND time_stamp <= '694137600'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001750
| Memory Before: 24.33 Mb
| Memory After: 24.34 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '631152000' AND time_stamp <= '662601600'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '631152000' AND time_stamp <= '662601600'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001771
| Memory Before: 24.34 Mb
| Memory After: 24.34 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '599616000' AND time_stamp <= '631065600'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '599616000' AND time_stamp <= '631065600'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001721
| Memory Before: 24.34 Mb
| Memory After: 24.34 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '567993600' AND time_stamp <= '599529600'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '567993600' AND time_stamp <= '599529600'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001979
| Memory Before: 24.34 Mb
| Memory After: 24.34 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '536457600' AND time_stamp <= '567907200'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '536457600' AND time_stamp <= '567907200'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001841
| Memory Before: 24.34 Mb
| Memory After: 24.34 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '504921600' AND time_stamp <= '536371200'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '504921600' AND time_stamp <= '536371200'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001850
| Memory Before: 24.34 Mb
| Memory After: 24.34 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '473385600' AND time_stamp <= '504835200'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '473385600' AND time_stamp <= '504835200'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001900
| Memory Before: 24.34 Mb
| Memory After: 24.35 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '441763200' AND time_stamp <= '473299200'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '441763200' AND time_stamp <= '473299200'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001929
| Memory Before: 24.34 Mb
| Memory After: 24.35 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '410227200' AND time_stamp <= '441676800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '410227200' AND time_stamp <= '441676800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0002010
| Memory Before: 24.35 Mb
| Memory After: 24.35 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '378691200' AND time_stamp <= '410140800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '378691200' AND time_stamp <= '410140800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001860
| Memory Before: 24.35 Mb
| Memory After: 24.35 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '347155200' AND time_stamp <= '378604800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '347155200' AND time_stamp <= '378604800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001750
| Memory Before: 24.35 Mb
| Memory After: 24.35 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '315532800' AND time_stamp <= '347068800'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '315532800' AND time_stamp <= '347068800'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001781
| Memory Before: 24.35 Mb
| Memory After: 24.35 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '283996800' AND time_stamp <= '315446400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '283996800' AND time_stamp <= '315446400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001800
| Memory Before: 24.35 Mb
| Memory After: 24.35 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '252460800' AND time_stamp <= '283910400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '252460800' AND time_stamp <= '283910400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001740
| Memory Before: 24.35 Mb
| Memory After: 24.36 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '220924800' AND time_stamp <= '252374400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '220924800' AND time_stamp <= '252374400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001738
| Memory Before: 24.35 Mb
| Memory After: 24.36 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '189302400' AND time_stamp <= '220838400'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '189302400' AND time_stamp <= '220838400'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001760
| Memory Before: 24.36 Mb
| Memory After: 24.36 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '157766400' AND time_stamp <= '189216000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '157766400' AND time_stamp <= '189216000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0002079
| Memory Before: 24.36 Mb
| Memory After: 24.36 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '126230400' AND time_stamp <= '157680000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '126230400' AND time_stamp <= '157680000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001931
| Memory Before: 24.36 Mb
| Memory After: 24.36 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '94694400' AND time_stamp <= '126144000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '94694400' AND time_stamp <= '126144000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001800
| Memory Before: 24.36 Mb
| Memory After: 24.36 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '63072000' AND time_stamp <= '94608000'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '63072000' AND time_stamp <= '94608000'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001881
| Memory Before: 24.36 Mb
| Memory After: 24.37 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '31536000' AND time_stamp <= '62985600'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '31536000' AND time_stamp <= '62985600'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001829
| Memory Before: 24.36 Mb
| Memory After: 24.37 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '0' AND time_stamp <= '31449600'
LIMIT 1
/* OO Query */
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 0 AND feed_reference = 0 AND time_stamp > '0' AND time_stamp <= '31449600'
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_feed | range | time_stamp | time_stamp | 8 | 1 | Using index condition; Using where |
0.0001879
| Memory Before: 24.37 Mb
| Memory After: 24.37 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT dob_setting
FROM phpfox_user_field
WHERE user_id = 0
LIMIT 1
/* OO Query */
FROM phpfox_user_field
WHERE user_id = 0
LIMIT 1
/* 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.0001321
| Memory Before: 24.36 Mb
| Memory After: 24.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 = '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.0003619
| Memory Before: 24.36 Mb
| Memory After: 24.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 = 'feed' AND name = 'display.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'display.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.0001230
| Memory Before: 24.37 Mb
| Memory After: 24.38 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 = 'feed' AND name = 'display.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'display.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.0001619
| Memory Before: 24.65 Mb
| Memory After: 24.66 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 = 'captcha' AND name = 'form.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'captcha' AND name = 'form.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.0003181
| Memory Before: 24.63 Mb
| Memory After: 24.63 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 = 'feed' AND name = 'timeline.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'timeline.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.0003278
| Memory Before: 24.8 Mb
| Memory After: 24.81 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 = 'feed' AND name = 'content.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'content.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.0001771
| Memory Before: 24.89 Mb
| Memory After: 24.89 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 = 'feed' AND name = 'comment.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'comment.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.0001709
| Memory Before: 24.98 Mb
| Memory After: 24.99 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' AND name = 'link.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'feed' 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.0001819
| Memory Before: 25.07 Mb
| Memory After: 25.07 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 */
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.0002012
| Memory Before: 25.03 Mb
| Memory After: 25.03 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 = 'like' AND name = 'display.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'like' AND name = 'display.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.0002079
| Memory Before: 24.61 Mb
| Memory After: 24.61 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] => 252eb3e7e83754d28065118574d095db
[redirect] => /fevent-7207-i-jornadas-de-divulgaci-243n-y-sensibilizaci-243n-en-alimentaci-243n-consciente/wall
)
Array
(
[coreb6aavisit] => 1769357336
)