0.0006740
| Memory Before: 2.29 Mb
| Memory After: 2.29 Mb
| Memory Used: 1.35 kb
| Rows: -
| Slave: No
INSERT INTO phpfox_log_session (session_hash, id_hash, user_id, last_activity, location, is_forum, forum_id, im_hide, ip_address, user_agent) VALUES ('29639d071c7d0fd35fca81ed7d98ea1c', '0d574f7196f9f96e319d05681455513d', '0', '1765176537', '/profile-2516/video/sort_most-talked', '0', '0', '0', '216.73.216.221', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.')
0.0003030
| Memory Before: 3.61 Mb
| Memory After: 3.62 Mb
| Memory Used: 5.03 kb
| Rows: 1
| Slave: No
SELECT s.style_id, s.parent_id
AS style_parent_id, s.folder
AS style_folder_name, t.folder
AS theme_folder_name, t.parent_id
AS theme_parent_id, t.total_column, s.l_width, s.c_width, s.r_width
FROM phpfox_theme_style
AS s
JOIN phpfox_theme
AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
| 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.0001359
| Memory Before: 3.62 Mb
| Memory After: 3.62 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.0022171
| Memory Before: 4.99 Mb
| Memory After: 5.03 Mb
| Memory Used: 36.2 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-2516'
/* 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 | ug | eq_ref | PRIMARY,user_group_id | PRIMARY | 1 | sqlgipsol.u.user_group_id | 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 | 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 | 61 | Using index |
| 1 | SIMPLE | p | eq_ref | PRIMARY,photo_id,photo_id_2 | PRIMARY | 4 | sqlgipsol.user_field.cover_photo | 1 | Using index |
0.0002351
| Memory Before: 6.49 Mb
| Memory After: 6.49 Mb
| Memory Used: 3.14 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_fevent
WHERE view_id = 0 AND item_id = 0 AND user_id = 2516
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 | 4 | Using where |
0.0002601
| Memory Before: 8.47 Mb
| Memory After: 8.47 Mb
| Memory Used: 3.73 kb
| Rows: 3
| Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 2516
/* 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 | 2 | |
0.0002298
| Memory Before: 9.28 Mb
| Memory After: 9.28 Mb
| Memory Used: 4.69 kb
| Rows: 0
| Slave: Yes
SELECT *, COUNT(item_id)
AS total
FROM phpfox_tag
WHERE category_id = 'video' AND tag_url = ''
GROUP BY tag_id
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_tag | ref | category_id,tag_url,user_search,user_search_general,category_id_2 | tag_url | 257 | const | 1 | Using index condition; Using where; Using temporary; Using filesort |
0.0002320
| Memory Before: 9.5 Mb
| Memory After: 9.5 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_video
AS m
WHERE m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND m.user_id = 2516
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | m | ref | in_process,user_id,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6 | in_process_5 | 11 | const,const,const,const,const | 1 | Using index |
0.0002499
| Memory Before: 10.57 Mb
| Memory After: 10.58 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = '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.0002820
| Memory Before: 11.68 Mb
| Memory After: 11.69 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.0002279
| Memory Before: 11.88 Mb
| Memory After: 11.88 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 */
| 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.0002360
| Memory Before: 12.04 Mb
| Memory After: 12.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 = '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.0002420
| Memory Before: 12.07 Mb
| Memory After: 12.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 = '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.0002799
| Memory Before: 12.07 Mb
| Memory After: 12.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 = '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.0002401
| Memory Before: 12.08 Mb
| Memory After: 12.09 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = '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.0003171
| Memory Before: 12.42 Mb
| Memory After: 12.44 Mb
| Memory Used: 18.15 kb
| Rows: 80
| 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 = 2516)
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 | user_id | user_id | 6 | const,sqlgipsol.cf.field_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.0003159
| Memory Before: 12.69 Mb
| Memory After: 12.72 Mb
| Memory Used: 31.15 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 2516
/* 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.0003431
| Memory Before: 12.72 Mb
| Memory After: 12.72 Mb
| Memory Used: 5.66 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 */
| 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.0002739
| Memory Before: 12.48 Mb
| Memory After: 12.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 = '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.0002880
| Memory Before: 12.85 Mb
| Memory After: 12.86 Mb
| Memory Used: 10.52 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_photo
WHERE photo_id = 4169
/* 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.0002050
| Memory Before: 12.99 Mb
| Memory After: 13 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.0002732
| Memory Before: 13.18 Mb
| Memory After: 13.18 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.0002251
| Memory Before: 12.92 Mb
| Memory After: 12.92 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.0002232
| Memory Before: 12.95 Mb
| Memory After: 12.95 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.0002279
| Memory Before: 12.95 Mb
| Memory After: 12.96 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002210
| Memory Before: 12.96 Mb
| Memory After: 12.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 = 'controller' AND module_id = 'video' AND name = 'index.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002768
| Memory Before: 13.25 Mb
| Memory After: 13.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 = '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.0002220
| Memory Before: 13.25 Mb
| Memory After: 13.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 = 'video' AND name = 'featured.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.0001841
| Memory Before: 13.26 Mb
| Memory After: 13.26 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 = 'video' AND name = 'featured.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.0002251
| Memory Before: 13.31 Mb
| Memory After: 13.32 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 = 'video' AND name = 'mini.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: 13.32 Mb
| Memory After: 13.32 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 = 'video' AND name = 'mini.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.0002880
| Memory Before: 13.32 Mb
| Memory After: 13.32 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 = 'video' AND name = 'mini.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.0002391
| Memory Before: 13.32 Mb
| Memory After: 13.32 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 = '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 |