0.0006571
| Memory Before: 2.29 Mb
| Memory After: 2.3 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 = 'e537aa7d65ffd57b1679dc4ed1fdd55e' 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.0004411
| Memory Before: 2.3 Mb
| Memory After: 2.3 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session
SET last_activity = '1786978785', user_id = '0', location = '/mobile/profile-2655/@GipuzkoaFeministaElkarte', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.145', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.'
WHERE session_hash = 'e537aa7d65ffd57b1679dc4ed1fdd55e'
| 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.0002239
| Memory Before: 3.62 Mb
| Memory After: 3.63 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 */
| 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.0001290
| Memory Before: 3.63 Mb
| Memory After: 3.63 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 */
| 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.0027061
| Memory Before: 5.13 Mb
| Memory After: 5.17 Mb
| Memory Used: 36.22 kb
| Rows: 1
| Slave: Yes
SELECT p.photo_id as cover_photo_exists, u.*, user_space.*, user_field.*, user_activity.*, ls.user_id
AS is_online, ts.style_id
AS designer_style_id, ts.folder
AS designer_style_folder, t.folder
AS designer_theme_folder, t.total_column, ts.l_width, ts.c_width, ts.r_width, t.parent_id
AS theme_parent_id, ug.prefix, ug.suffix, ug.icon_ext, ug.title, uf.user_id as is_featured
FROM phpfox_user
AS u
JOIN phpfox_user_group
AS ug
ON(ug.user_group_id = u.user_group_id)
JOIN phpfox_user_space
AS user_space
ON(user_space.user_id = u.user_id)
JOIN phpfox_user_field
AS user_field
ON(user_field.user_id = u.user_id)
JOIN phpfox_user_activity
AS user_activity
ON(user_activity.user_id = u.user_id)
LEFT JOIN phpfox_theme_style
AS ts
ON(ts.style_id = user_field.designer_style_id AND ts.is_active = 1)
LEFT JOIN phpfox_theme
AS t
ON(t.theme_id = ts.theme_id)
LEFT JOIN phpfox_user_featured
AS uf
ON(uf.user_id = u.user_id)
LEFT JOIN phpfox_log_session
AS ls
ON(ls.user_id = u.user_id AND ls.im_hide = 0)
LEFT JOIN phpfox_photo
AS p
ON(p.photo_id = user_field.cover_photo)
WHERE u.user_name = 'profile-2655'
/* 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 | index | user_id,user_id_2,user_id_3 | user_id | 5 | | 71 | Using where; Using index; Using join buffer (flat, BNL join) |
| 1 | SIMPLE | p | eq_ref | PRIMARY,photo_id,photo_id_2 | PRIMARY | 4 | sqlgipsol.user_field.cover_photo | 1 | Using index |
0.0007560
| Memory Before: 7.18 Mb
| Memory After: 7.19 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_fevent
WHERE view_id = 0 AND item_id = 0 AND user_id = 2655
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_fevent | ref | user_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | user_id | 4 | const | 2 | Using where |
0.0005670
| Memory Before: 9.13 Mb
| Memory After: 9.13 Mb
| Memory Used: 3.91 kb
| Rows: 8
| Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 2655
/* 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 | 7 | |
0.0009849
| Memory Before: 10.03 Mb
| Memory After: 10.04 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 = 'profile.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.0021830
| Memory Before: 10.03 Mb
| Memory After: 10.04 Mb
| Memory Used: 5.32 kb
| Rows: 5
| 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 = 'profile' 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 | | 2 | 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.0022399
| Memory Before: 10.05 Mb
| Memory After: 10.06 Mb
| Memory Used: 10.31 kb
| Rows: 80
| 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 */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ALL | product_id,parent_id | MISSING KEY | | | 222 | 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.0004070
| Memory Before: 10.19 Mb
| Memory After: 10.2 Mb
| Memory Used: 10.27 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 */
| 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.0003860
| Memory Before: 10.2 Mb
| Memory After: 10.21 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 */
| 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.0001180
| Memory Before: 10.2 Mb
| Memory After: 10.21 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 */
| 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.0000989
| Memory Before: 10.2 Mb
| Memory After: 10.21 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 */
| 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.0004349
| Memory Before: 10.45 Mb
| Memory After: 10.45 Mb
| Memory Used: 5.16 kb
| Rows: 3
| Slave: Yes
SELECT cron.*
FROM phpfox_cron
AS cron
JOIN phpfox_product
AS product
ON(product.product_id = cron.product_id AND product.is_active = 1)
JOIN phpfox_module
AS m
ON(m.module_id = cron.module_id AND m.is_active = 1)
WHERE cron.is_active = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | cron | ALL | is_active | MISSING KEY | | | 4 | Using where |
| 1 | SIMPLE | product | ref | is_active,product_active,product_id | product_active | 28 | sqlgipsol.cron.product_id,const | 3 | Using index |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.cron.module_id,const | 8 | Using index |
0.0001001
| Memory Before: 10.46 Mb
| Memory After: 10.46 Mb
| Memory Used: 3.36 kb
| Rows: 0
| Slave: No
SELECT event_id, image_path
FROM phpfox_fevent
WHERE end_time < 1735689600 AND image_path != "" AND image_path != "af9e5ac6fdf7acdeabaaebb4e50a5d84%s.jpg"
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_fevent | ALL | | MISSING KEY | | | 9465 | Using where |
0.0002630
| Memory Before: 10.46 Mb
| Memory After: 10.46 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_cron
SET next_run = '1786978785', last_run = '1786978785'
WHERE cron_id = 5
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_cron | const | PRIMARY | PRIMARY | 3 | const | 1 | |
0.0001838
| Memory Before: 10.46 Mb
| Memory After: 10.46 Mb
| Memory Used: 1.29 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_cron_log (cron_id, time_stamp) VALUES ('5', '1786978785')
0.0000930
| Memory Before: 10.93 Mb
| Memory After: 10.93 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 */
| 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: 12.46 Mb
| Memory After: 12.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 = '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.0001199
| Memory Before: 12.55 Mb
| Memory After: 12.55 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 = '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.0001321
| Memory Before: 12.68 Mb
| Memory After: 12.68 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
| 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: 12.7 Mb
| Memory After: 12.71 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| 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: 23.25 Mb
| Memory After: 23.25 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 */
| 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.0001168
| Memory Before: 23.26 Mb
| Memory After: 23.26 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 */
| 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.0023720
| Memory Before: 23.6 Mb
| Memory After: 23.61 Mb
| Memory Used: 17.84 kb
| Rows: 78
| Slave: Yes
SELECT cf.*, cmv.option_id as customValue, cg.user_group_id as cg_user_group_id
FROM phpfox_custom_field
AS cf
LEFT JOIN phpfox_user_custom_multiple_value
AS cmv
ON(cmv.field_id = cf.field_id AND cmv.user_id = 2655)
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 | cmv | ref | user_id | user_id | 6 | const,sqlgipsol.cf.field_id | 1 | |
| 1 | SIMPLE | cg | eq_ref | PRIMARY | PRIMARY | 2 | sqlgipsol.cf.group_id | 1 | |
| 1 | SIMPLE | m | ref | is_active,module_id,module_is_active | module_is_active | 78 | sqlgipsol.cf.module_id,const | 8 | Using index |
0.0010440
| Memory Before: 23.86 Mb
| Memory After: 23.89 Mb
| Memory Used: 31.67 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 2655
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_user_custom | const | user_id | user_id | 4 | const | 1 | |
0.0008049
| Memory Before: 23.89 Mb
| Memory After: 23.9 Mb
| Memory Used: 5.93 kb
| Rows: 72
| Slave: Yes
SELECT *
FROM phpfox_custom_option
WHERE field_id IN(93,22,9,79,80,81,48,33,38,51,53,54,55,58,59,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77)
ORDER BY option_id ASC
/* OO Query */
| 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.0008070
| Memory Before: 23.76 Mb
| Memory After: 23.76 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/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.0004029
| Memory Before: 24.14 Mb
| Memory After: 24.15 Mb
| Memory Used: 10.55 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_photo
WHERE photo_id = 4708
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_photo | const | PRIMARY,photo_id,photo_id_2 | PRIMARY | 4 | const | 1 | |
0.0003440
| Memory Before: 24.27 Mb
| Memory After: 24.28 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/logo.html.php'
/* OO Query */
| 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.0003371
| Memory Before: 24.46 Mb
| Memory After: 24.46 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/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.0001371
| Memory Before: 24.2 Mb
| Memory After: 24.2 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 */
| 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.0001349
| Memory Before: 24.21 Mb
| Memory After: 24.22 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 */
| 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.0001049
| Memory Before: 24.22 Mb
| Memory After: 24.22 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 */
| 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.0020640
| Memory Before: 24.81 Mb
| Memory After: 24.82 Mb
| Memory Used: 9.1 kb
| Rows: 4
| Slave: Yes
SELECT feed.*, apps.app_title, 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 (
(
SELECT feed.*
FROM phpfox_feed
AS feed
WHERE feed.privacy IN(0) AND type_id = 'feed_comment' AND feed.user_id = 2655
/* OO Query */) UNI
ON (
SELECT feed.*
FROM phpfox_feed
AS feed
WHERE feed.privacy IN(0) AND feed.user_id = 2655 AND feed.feed_reference = 0 AND feed.parent_user_id = 0
/* OO Query */) UNI
ON (
SELECT feed.*
FROM phpfox_feed
AS feed
WHERE feed.privacy IN(0) AND feed.parent_user_id = 2655
/* OO Query */))
AS feed
JOIN phpfox_user
AS u
ON(u.user_id = feed.user_id)
LEFT JOIN phpfox_app
AS apps
ON(apps.app_id = feed.app_id)
GROUP BY feed.feed_id
ORDER BY feed.time_stamp
DESC
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | PRIMARY | apps | system | PRIMARY,app_id | MISSING KEY | | | | Const row not found; Using temporary; Using filesort |
| 1 | PRIMARY | <derived2> | ALL | | MISSING KEY | | | 6 | |
| 1 | PRIMARY | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | feed.user_id | 1 | |
| 2 | DERIVED | feed | ref | privacy_2,privacy_3,privacy_4,type_id,privacy,privacy_5,user_id | type_id | 77 | const | 1 | Using index condition; Using where |
| 3 | UNION | feed | ref | privacy_2,privacy_3,privacy_4,privacy,privacy_5,user_id | privacy | 5 | const,const | 4 | Using index condition; Using where |
| 4 | UNION | feed | ref | privacy_2,privacy_3,privacy_4,privacy,privacy_5 | privacy_5 | 5 | const,const | 1 | |
| | UNION RESULT | <union2,3,4> | ALL | | MISSING KEY | | | | |
0.0013840
| Memory Before: 24.94 Mb
| Memory After: 24.95 Mb
| Memory Used: 13.22 kb
| Rows: 1
| Slave: Yes
SELECT e.event_id, e.module_id, e.item_id, e.title, e.time_stamp, e.image_path, e.server_id, e.total_like, e.total_comment, et.description_parsed, l.like_id
AS is_liked
FROM phpfox_fevent
AS e
LEFT JOIN phpfox_like
AS l
ON(l.type_id = 'fevent' AND l.item_id = e.event_id AND l.user_id = 0)
LEFT JOIN phpfox_fevent_text
AS et
ON(et.event_id = e.event_id)
WHERE e.event_id = 11559
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | e | const | PRIMARY | PRIMARY | 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 | et | ref | event_id | event_id | 4 | const | 1 | |
0.0011320
| Memory Before: 25 Mb
| Memory After: 25.01 Mb
| Memory Used: 6.71 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 = "fevent")
WHERE (l.type_id = 'fevent' OR l.type_id = 'fevent') AND l.item_id = 11559
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 | l | ref|filter | type_id,type_id_2,type_id_3,item_id | item_id|type_id_3 | 4|77 | const | 1 (8%) | Using where; Using temporary; Using filesort; Using rowid filter |
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | item_id | 4 | const | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 | |
0.0005522
| Memory Before: 25 Mb
| Memory After: 25.01 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_like
AS l
WHERE (l.type_id = 'fevent' OR l.type_id = 'fevent') AND l.item_id = 11559
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.0004611
| Memory Before: 25.01 Mb
| Memory After: 25.01 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 = "fevent" AND a.item_id = 11559
GROUP BY u.user_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.a.user_id | 1 | |
0.0001390
| Memory Before: 25.02 Mb
| Memory After: 25.03 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 = "fevent" AND a.item_id = 11559
GROUP BY u.user_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.a.user_id | 1 | |
0.0003910
| Memory Before: 25.28 Mb
| Memory After: 25.29 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 = "custom" AND a.item_id = 2655
GROUP BY u.user_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.a.user_id | 1 | |
0.0006490
| Memory Before: 25.28 Mb
| Memory After: 25.29 Mb
| Memory Used: 6.71 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 = "custom")
WHERE (l.type_id = 'custom' OR l.type_id = 'custom') AND l.item_id = 2655
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 | 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 temporary; Using filesort; Using rowid filter |
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | item_id | 4 | const | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 | |
0.0005078
| Memory Before: 25.29 Mb
| Memory After: 25.29 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 = 'custom' AND l.item_id = 2655
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.0000880
| Memory Before: 25.29 Mb
| Memory After: 25.29 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 = "custom" AND a.item_id = 2655
GROUP BY u.user_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.a.user_id | 1 | |
0.0009582
| Memory Before: 25.3 Mb
| Memory After: 25.32 Mb
| Memory Used: 14.08 kb
| Rows: 1
| Slave: Yes
SELECT u.user_id
AS parent_user_id, u.profile_page_id
AS parent_profile_page_id, u.server_id
AS user_parent_server_id, u.user_name
AS parent_user_name, u.full_name
AS parent_full_name, u.gender
AS parent_gender, u.user_image
AS parent_user_image, u.is_invisible
AS parent_is_invisible, u.user_group_id
AS parent_user_group_id, u.language_id
AS parent_language_id, u.last_activity
AS parent_last_activity, 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
LEFT JOIN phpfox_user
AS u
ON(u.user_id = photo.parent_user_id)
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 = 19303)
LEFT JOIN phpfox_photo_album
AS pa
ON(pa.album_id = photo.album_id)
WHERE photo.photo_id = 4707
/* 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 | u | const | PRIMARY,user_id | PRIMARY | 4 | const | | Unique row not found |
| 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.0007980
| Memory Before: 25.31 Mb
| Memory After: 25.32 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 = 4707
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 | 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 temporary; Using filesort; Using rowid filter |
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | item_id | 4 | const | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 | |
0.0003798
| Memory Before: 25.31 Mb
| Memory After: 25.32 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 = 4707
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.0003779
| Memory Before: 25.32 Mb
| Memory After: 25.32 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 = 4707
GROUP BY u.user_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.a.user_id | 1 | |
0.0004671
| Memory Before: 25.32 Mb
| Memory After: 25.32 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 = 4707
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.0000920
| Memory Before: 25.32 Mb
| Memory After: 25.33 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 = 4707
GROUP BY u.user_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.a.user_id | 1 | |
0.0008421
| Memory Before: 25.33 Mb
| Memory After: 25.35 Mb
| Memory Used: 14.09 kb
| Rows: 1
| Slave: Yes
SELECT u.user_id
AS parent_user_id, u.profile_page_id
AS parent_profile_page_id, u.server_id
AS user_parent_server_id, u.user_name
AS parent_user_name, u.full_name
AS parent_full_name, u.gender
AS parent_gender, u.user_image
AS parent_user_image, u.is_invisible
AS parent_is_invisible, u.user_group_id
AS parent_user_group_id, u.language_id
AS parent_language_id, u.last_activity
AS parent_last_activity, 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
LEFT JOIN phpfox_user
AS u
ON(u.user_id = photo.parent_user_id)
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 = 19302)
LEFT JOIN phpfox_photo_album
AS pa
ON(pa.album_id = photo.album_id)
WHERE photo.photo_id = 4706
/* 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 | u | const | PRIMARY,user_id | PRIMARY | 4 | const | | Unique row not found |
| 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.0007479
| Memory Before: 25.34 Mb
| Memory After: 25.35 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 = 4706
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 | 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 temporary; Using filesort; Using rowid filter |
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | item_id | 4 | const | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.l.user_id | 1 | |
0.0002940
| Memory Before: 25.34 Mb
| Memory After: 25.35 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 = 4706
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.0002811
| Memory Before: 25.35 Mb
| Memory After: 25.35 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 = 4706
GROUP BY u.user_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.a.user_id | 1 | |
0.0003519
| Memory Before: 25.35 Mb
| Memory After: 25.35 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 = 4706
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.0000730
| Memory Before: 25.35 Mb
| Memory After: 25.35 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 = 4706
GROUP BY u.user_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | a | ref | type_id,type_id_2,type_id_3,item_id | type_id_2 | 81 | const,const | 1 | Using where; Using index |
| 1 | SIMPLE | u | eq_ref | PRIMARY,user_id | PRIMARY | 4 | sqlgipsol.a.user_id | 1 | |
0.0002229
| Memory Before: 25.35 Mb
| Memory After: 25.36 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_user
AS u
WHERE user_id IN (0,0,0,0)
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | u | range | PRIMARY,user_id | user_id | 4 | | 1 | Using index condition |
0.0000811
| Memory Before: 25.25 Mb
| Memory After: 25.25 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT count(*)
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.0066321
| Memory Before: 25.53 Mb
| Memory After: 25.53 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 1012 | Using index condition; Using where |
0.0080459
| Memory Before: 25.53 Mb
| Memory After: 25.54 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 1906 | Using index condition; Using where |
0.0060539
| Memory Before: 25.53 Mb
| Memory After: 25.54 Mb
| Memory Used: 3.13 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 835 | Using index condition; Using where |
0.0092220
| Memory Before: 25.54 Mb
| Memory After: 25.54 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 898 | Using index condition; Using where |
0.0093529
| Memory Before: 25.54 Mb
| Memory After: 25.54 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 1042 | Using index condition; Using where |
0.0079300
| Memory Before: 25.54 Mb
| Memory After: 25.54 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 1123 | Using index condition; Using where |
0.0051661
| Memory Before: 25.54 Mb
| Memory After: 25.54 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 793 | Using index condition; Using where |
0.0049031
| Memory Before: 25.54 Mb
| Memory After: 25.55 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 718 | Using index condition; Using where |
0.0078821
| Memory Before: 25.54 Mb
| Memory After: 25.55 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 1192 | Using index condition; Using where |
0.0088000
| Memory Before: 25.54 Mb
| Memory After: 25.55 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 1271 | Using index condition; Using where |
0.0068150
| Memory Before: 25.55 Mb
| Memory After: 25.55 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 926 | Using index condition; Using where |
0.0021310
| Memory Before: 25.55 Mb
| Memory After: 25.55 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 258 | Using index condition; Using where |
0.0021651
| Memory Before: 25.55 Mb
| Memory After: 25.55 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 295 | Using index condition; Using where |
0.0005760
| Memory Before: 25.55 Mb
| Memory After: 25.55 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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 | | 65 | Using index condition; Using where |
0.0002010
| Memory Before: 25.55 Mb
| Memory After: 25.56 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001850
| Memory Before: 25.55 Mb
| Memory After: 25.56 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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: 25.56 Mb
| Memory After: 25.56 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0002091
| Memory Before: 25.56 Mb
| Memory After: 25.56 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001800
| Memory Before: 25.56 Mb
| Memory After: 25.56 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001869
| Memory Before: 25.56 Mb
| Memory After: 25.56 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001919
| Memory Before: 25.56 Mb
| Memory After: 25.56 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001881
| Memory Before: 25.56 Mb
| Memory After: 25.57 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0002110
| Memory Before: 25.56 Mb
| Memory After: 25.57 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001819
| Memory Before: 25.57 Mb
| Memory After: 25.57 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001771
| Memory Before: 25.57 Mb
| Memory After: 25.57 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001771
| Memory Before: 25.57 Mb
| Memory After: 25.57 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001800
| Memory Before: 25.57 Mb
| Memory After: 25.57 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001791
| Memory Before: 25.57 Mb
| Memory After: 25.58 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001690
| Memory Before: 25.57 Mb
| Memory After: 25.58 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0002091
| Memory Before: 25.58 Mb
| Memory After: 25.58 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001969
| Memory Before: 25.58 Mb
| Memory After: 25.58 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001910
| Memory Before: 25.58 Mb
| Memory After: 25.58 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001950
| Memory Before: 25.58 Mb
| Memory After: 25.58 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0002158
| Memory Before: 25.58 Mb
| Memory After: 25.58 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001850
| Memory Before: 25.58 Mb
| Memory After: 25.59 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001972
| Memory Before: 25.58 Mb
| Memory After: 25.59 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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: 25.59 Mb
| Memory After: 25.59 Mb
| Memory Used: 3.13 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001731
| Memory Before: 25.59 Mb
| Memory After: 25.59 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001681
| Memory Before: 25.59 Mb
| Memory After: 25.59 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001619
| Memory Before: 25.59 Mb
| Memory After: 25.59 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001681
| Memory Before: 25.59 Mb
| Memory After: 25.59 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001628
| Memory Before: 25.59 Mb
| Memory After: 25.6 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001700
| Memory Before: 25.59 Mb
| Memory After: 25.6 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001640
| Memory Before: 25.6 Mb
| Memory After: 25.6 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001681
| Memory Before: 25.6 Mb
| Memory After: 25.6 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001700
| Memory Before: 25.6 Mb
| Memory After: 25.6 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001631
| Memory Before: 25.6 Mb
| Memory After: 25.6 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001671
| Memory Before: 25.6 Mb
| Memory After: 25.61 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001760
| Memory Before: 25.6 Mb
| Memory After: 25.61 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001640
| Memory Before: 25.61 Mb
| Memory After: 25.61 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001612
| Memory Before: 25.61 Mb
| Memory After: 25.61 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0002069
| Memory Before: 25.61 Mb
| Memory After: 25.61 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001678
| Memory Before: 25.61 Mb
| Memory After: 25.61 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001640
| Memory Before: 25.61 Mb
| Memory After: 25.61 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001650
| Memory Before: 25.61 Mb
| Memory After: 25.62 Mb
| Memory Used: 3.15 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001650
| Memory Before: 25.61 Mb
| Memory After: 25.62 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001750
| Memory Before: 25.62 Mb
| Memory After: 25.62 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_feed
FORCE INDEX (time_stamp)
WHERE user_id = 2655 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.0001931
| Memory Before: 25.62 Mb
| Memory After: 25.62 Mb
| Memory Used: 3.18 kb
| Rows: 1
| Slave: Yes
SELECT dob_setting
FROM phpfox_user_field
WHERE user_id = 2655
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_user_field | const | user_id | user_id | 4 | const | 1 | |
0.0001199
| Memory Before: 25.61 Mb
| Memory After: 25.62 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 */
| 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.0002229
| Memory Before: 25.62 Mb
| Memory After: 25.63 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 */
| 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.0001559
| Memory Before: 25.63 Mb
| Memory After: 25.64 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 */
| 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.0002301
| Memory Before: 25.91 Mb
| Memory After: 25.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 = '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.0002232
| Memory Before: 25.79 Mb
| Memory After: 25.8 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 */
| 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.0002131
| Memory Before: 25.97 Mb
| Memory After: 25.97 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0001009
| Memory Before: 26.3 Mb
| Memory After: 26.3 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 */
| 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.0000968
| Memory Before: 26.39 Mb
| Memory After: 26.4 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 */
| 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.0001080
| Memory Before: 26.48 Mb
| Memory After: 26.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 = '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.0001221
| Memory Before: 26.44 Mb
| Memory After: 26.44 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 */
| 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.0001040
| Memory Before: 26.1 Mb
| Memory After: 26.11 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 */
| 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.0001159
| Memory Before: 26.29 Mb
| Memory After: 26.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 = '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.0001161
| Memory Before: 26.37 Mb
| Memory After: 26.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 = '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.0001171
| Memory Before: 26.47 Mb
| Memory After: 26.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 = '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.0001290
| Memory Before: 26.53 Mb
| Memory After: 26.54 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 */
| 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: 26.47 Mb
| Memory After: 26.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 = '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.0062990
| Memory Before: 26.5 Mb
| Memory After: 26.51 Mb
| Memory Used: 6.67 kb
| Rows: 1
| Slave: Yes
SELECT uf.dob_setting, friend.friend_id, friend.friend_user_id, friend.is_top_friend, friend.time_stamp, 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_friend
AS friend
INNER JOIN (
SELECT friend_user_id
FROM phpfox_friend
WHERE is_page = 0 AND user_id = 2655)
AS sf
ON(sf.friend_user_id = friend.friend_user_id)
JOIN phpfox_user
AS u
ON(u.user_id = friend.friend_user_id AND u.status_id = 0)
JOIN phpfox_user_field
AS uf
ON(u.user_id = uf.user_id)
WHERE friend.is_page = 0 AND friend.user_id = 2655
GROUP BY u.user_id
ORDER BY friend.is_top_friend
DESC , friend.ordering ASC, RAND()
LIMIT 6
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_friend | ref | user_check,user_id,top_friend,friend_user_id,is_page,is_page_2 | is_page_2 | 5 | const,const | 1 | Using where; Using index; Using temporary; Using filesort |
| 1 | SIMPLE | friend | eq_ref | user_check,user_id,top_friend,friend_user_id,is_page,is_page_2 | user_check | 8 | const,sqlgipsol.phpfox_friend.friend_user_id | 1 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY,public_feed,status_id,status_id_2,user_id,user_status | PRIMARY | 4 | sqlgipsol.phpfox_friend.friend_user_id | 1 | Using where |
| 1 | SIMPLE | uf | eq_ref | user_id | user_id | 4 | sqlgipsol.phpfox_friend.friend_user_id | 1 | |
0.0004630
| Memory Before: 26.51 Mb
| Memory After: 26.51 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 = 'friend' 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.0002220
| Memory Before: 26.39 Mb
| Memory After: 26.39 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 */
| 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.0002189
| Memory Before: 26.56 Mb
| Memory After: 26.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 = '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.0001280
| Memory Before: 26.64 Mb
| Memory After: 26.65 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 = '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.0001190
| Memory Before: 26.74 Mb
| Memory After: 26.74 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 = '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.0001309
| Memory Before: 26.8 Mb
| Memory After: 26.8 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 */
| 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.0001121
| Memory Before: 26.74 Mb
| Memory After: 26.75 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 = '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.0002031
| Memory Before: 26.41 Mb
| Memory After: 26.41 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 = '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.0002170
| Memory Before: 26.58 Mb
| Memory After: 26.58 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0001760
| Memory Before: 26.66 Mb
| Memory After: 26.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 = '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.0001321
| Memory Before: 26.76 Mb
| Memory After: 26.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 = '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.0001171
| Memory Before: 26.82 Mb
| Memory After: 26.82 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 */
| 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.0001040
| Memory Before: 26.76 Mb
| Memory After: 26.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 = '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.0005629
| Memory Before: 26.44 Mb
| Memory After: 26.45 Mb
| Memory Used: 9.27 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "feed|display"
/* 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.0004730
| Memory Before: 26.31 Mb
| Memory After: 26.31 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 = 'controller/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.0001111
| Memory Before: 26.33 Mb
| Memory After: 26.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 = '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 |