Últimos eventos
- Finalizado
Comenzó: septiembre 23, 2021 17:00
Finalizó: septiembre 23, 2021 18:00
- Finalizado
Comenzó: septiembre 20, 2021 17:30
Finalizó: septiembre 20, 2021 18:30
Últimas fotos
Igualdad
Antiracismo (Hernani)
phpFox Developers Debug
Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula
Total Time:
6.7755129
PHP General Time:
6.7258047
GZIP:
disabled
Driver Version:
MySQL 5.5.5-10.5.29-MariaDB-0+deb11u1
SQL Time:
0.0497082
SQL Queries:
65
SQL Memory Usage:
530.64 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Total Memory Usage:
14.58 Mb
Total Memory Usage (Including Debug):
14.85 Mb
Memory Limit:
512 Mb (1024M)
Load Balancing Enabled:
No
Requests From:
192.168.100.222
Server Time Stamp:
December 9, 2025, 6:31 pm
PHP Version:
5.6.40
PHP Sapi:
fpm-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux
Cache:
file
SQL Queries
0.0005379
| Memory Before: 2.29 Mb
| Memory After: 2.29 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 = '1d3afa7912f9c05923ae6b450cc9bb08' AND s.id_hash = '0d574f7196f9f96e319d05681455513d'
/* OO Query */
FROM phpfox_log_session AS s
WHERE s.session_hash = '1d3afa7912f9c05923ae6b450cc9bb08' 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.0004251
| Memory Before: 2.29 Mb
| Memory After: 2.3 Mb
| Memory Used: 1.41 kb
| Rows: -
| Slave: No
UPDATE phpfox_log_session SET last_activity = '1765305112', user_id = '0', location = '/mobile/profile-2474', is_forum = '0', forum_id = '0', im_hide = '0', ip_address = '216.73.216.221', user_agent = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.' WHERE session_hash = '1d3afa7912f9c05923ae6b450cc9bb08'
| 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.0002341
| Memory Before: 3.62 Mb
| Memory After: 3.62 Mb
| Memory Used: 4.97 kb
| Rows: 1
| Slave: No
SELECT s.style_id, s.parent_id AS style_parent_id, s.folder AS style_folder_name, t.folder AS theme_folder_name, t.parent_id AS theme_parent_id, t.total_column, s.l_width, s.c_width, s.r_width
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
FROM phpfox_theme_style AS s
JOIN phpfox_theme AS t
ON(t.theme_id = s.theme_id)
WHERE s.is_default = 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | s | ref | is_default | is_default | 1 | const | 1 | |
| 1 | SIMPLE | t | eq_ref | PRIMARY,theme_id | PRIMARY | 2 | sqlgipsol.s.theme_id | 1 |
0.0001051
| 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 */
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.0021479
| Memory Before: 4.99 Mb
| Memory After: 5.03 Mb
| Memory Used: 36.19 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-2474'
/* OO Query */
FROM phpfox_user AS u
JOIN phpfox_user_group AS ug
ON(ug.user_group_id = u.user_group_id)
JOIN phpfox_user_space AS user_space
ON(user_space.user_id = u.user_id)
JOIN phpfox_user_field AS user_field
ON(user_field.user_id = u.user_id)
JOIN phpfox_user_activity AS user_activity
ON(user_activity.user_id = u.user_id)
LEFT JOIN phpfox_theme_style AS ts
ON(ts.style_id = user_field.designer_style_id AND ts.is_active = 1)
LEFT JOIN phpfox_theme AS t
ON(t.theme_id = ts.theme_id)
LEFT JOIN phpfox_user_featured AS uf
ON(uf.user_id = u.user_id)
LEFT JOIN phpfox_log_session AS ls
ON(ls.user_id = u.user_id AND ls.im_hide = 0)
LEFT JOIN phpfox_photo AS p
ON(p.photo_id = user_field.cover_photo)
WHERE u.user_name = 'profile-2474'
/* 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.0013161
| Memory Before: 6.49 Mb
| Memory After: 6.5 Mb
| Memory Used: 3.18 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_fevent
WHERE view_id = 0 AND item_id = 0 AND user_id = 2474
LIMIT 1
/* OO Query */
FROM phpfox_fevent
WHERE view_id = 0 AND item_id = 0 AND user_id = 2474
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 | 90 | Using where |
0.0006199
| Memory Before: 8.43 Mb
| Memory After: 8.44 Mb
| Memory Used: 3.73 kb
| Rows: 3
| Slave: Yes
SELECT user_id, user_privacy, user_value
FROM phpfox_user_privacy
WHERE user_id = 2474
/* OO Query */
FROM phpfox_user_privacy
WHERE user_id = 2474
/* 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.0015709
| Memory Before: 10.03 Mb
| Memory After: 10.03 Mb
| Memory Used: 3.13 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(m.event_id)
FROM phpfox_fevent AS m
INNER JOIN phpfox_fevent_text AS ft
ON(ft.event_id = m.event_id)
WHERE m.view_id = 0 AND m.privacy IN(0) AND m.user_id = 2474
LIMIT 1
/* OO Query */
FROM phpfox_fevent AS m
INNER JOIN phpfox_fevent_text AS ft
ON(ft.event_id = m.event_id)
WHERE m.view_id = 0 AND m.privacy IN(0) AND m.user_id = 2474
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | PRIMARY,user_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | view_id_3 | 6 | const,const,const | 47 | |
| 1 | SIMPLE | ft | ref | event_id | event_id | 4 | sqlgipsol.m.event_id | 1 | Using index |
0.0019832
| Memory Before: 10.21 Mb
| Memory After: 10.23 Mb
| Memory Used: 23.27 kb
| Rows: 5
| Slave: Yes
SELECT m.server_id as event_server_id, m.*, u.*
FROM phpfox_fevent AS m
INNER JOIN phpfox_fevent_text AS ft
ON(ft.event_id = m.event_id)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.view_id = 0 AND m.privacy IN(0) AND m.user_id = 2474
ORDER BY m.time_stamp DESC
LIMIT 5
/* OO Query */
FROM phpfox_fevent AS m
INNER JOIN phpfox_fevent_text AS ft
ON(ft.event_id = m.event_id)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.view_id = 0 AND m.privacy IN(0) AND m.user_id = 2474
ORDER BY m.time_stamp DESC
LIMIT 5
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | u | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | m | ref | PRIMARY,user_id,view_id,view_id_2,view_id_3,view_id_4,view_id_5 | view_id_3 | 6 | const,const,const | 47 | Using where; Using filesort |
| 1 | SIMPLE | ft | ref | event_id | event_id | 4 | sqlgipsol.m.event_id | 1 | Using index |
0.0003841
| Memory Before: 10.3 Mb
| Memory After: 10.3 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 9033 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 9033 AND user_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0003951
| Memory Before: 10.3 Mb
| Memory After: 10.31 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 7984 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 7984 AND user_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0003769
| Memory Before: 10.31 Mb
| Memory After: 10.31 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 7028 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 7028 AND user_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0003970
| Memory Before: 10.31 Mb
| Memory After: 10.32 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 6993 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 6993 AND user_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0003810
| Memory Before: 10.32 Mb
| Memory After: 10.32 Mb
| Memory Used: 3.38 kb
| Rows: 0
| Slave: Yes
SELECT *
FROM phpfox_fevent_admin
WHERE event_id = 6961 AND user_id = 0
/* OO Query */
FROM phpfox_fevent_admin
WHERE event_id = 6961 AND user_id = 0
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | MISSING KEY | Impossible WHERE noticed after reading const tables |
0.0007501
| Memory Before: 10.62 Mb
| Memory After: 10.63 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_document AS m
WHERE m.is_approved = 1 AND m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND m.user_id = 2474
LIMIT 1
/* OO Query */
FROM phpfox_document AS m
WHERE m.is_approved = 1 AND m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND m.user_id = 2474
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | m | ref | user_id,in_process,in_process_2,in_process_3,in_process_4,in_process_5,view_id_4 | in_process_3 | 5 | const,const | 2 | Using where |
0.0058649
| Memory Before: 10.62 Mb
| Memory After: 10.67 Mb
| Memory Used: 47.14 kb
| Rows: 2
| Slave: Yes
SELECT dt.*, m.*, 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_document AS m
JOIN phpfox_document_text AS dt
ON(dt.document_id = m.document_id)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.is_approved = 1 AND m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND m.user_id = 2474
ORDER BY m.time_stamp DESC
LIMIT 4
/* OO Query */
FROM phpfox_document AS m
JOIN phpfox_document_text AS dt
ON(dt.document_id = m.document_id)
JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
WHERE m.is_approved = 1 AND m.in_process = 0 AND m.view_id = 0 AND m.item_id = 0 AND m.privacy IN(0) AND m.user_id = 2474
ORDER BY m.time_stamp DESC
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | u | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | m | ref | PRIMARY,user_id,in_process,document_id_2,in_process_2,in_process_3,in_process_4,in_process_5,document_id,document_id_3,view_id_4 | in_process_3 | 5 | const,const | 2 | Using where |
| 1 | SIMPLE | dt | ALL | MISSING KEY | 714 | Using where; Using join buffer (flat, BNL join) |
0.0007639
| Memory Before: 11.05 Mb
| Memory After: 11.05 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 765
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 765
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 2 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0006778
| Memory Before: 11.11 Mb
| Memory After: 11.11 Mb
| Memory Used: 3.88 kb
| Rows: 1
| Slave: Yes
SELECT pc.parent_id, pc.category_id, pc.name, pc.name_url
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 579
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
FROM phpfox_document_category_data AS pcd
JOIN phpfox_document_category AS pc
ON(pc.category_id = pcd.category_id)
WHERE pcd.document_id = 579
ORDER BY pc.parent_id ASC, pc.ordering ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | pcd | ref | category_id,document_id | document_id | 4 | const | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | pc | eq_ref | PRIMARY | PRIMARY | 3 | sqlgipsol.pcd.category_id | 1 | Using index condition |
0.0007830
| Memory Before: 11.13 Mb
| Memory After: 11.14 Mb
| Memory Used: 3.12 kb
| Rows: 1
| Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS photo
WHERE photo.view_id = 0 AND photo.group_id = 0 AND photo.type_id = 0 AND photo.privacy IN(0) AND photo.user_id = 2474
LIMIT 1
/* OO Query */
FROM phpfox_photo AS photo
WHERE photo.view_id = 0 AND photo.group_id = 0 AND photo.type_id = 0 AND photo.privacy IN(0) AND photo.user_id = 2474
LIMIT 1
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | photo | ref | view_id_2,view_id,privacy,view_id_3,view_id_4,view_id_5 | view_id_3 | 10 | const,const,const,const | 2 | Using where |
0.0014830
| Memory Before: 11.14 Mb
| Memory After: 11.15 Mb
| Memory Used: 14.63 kb
| Rows: 2
| Slave: Yes
SELECT pa.name AS album_name, pa.profile_id AS album_profile_id, ppc.name as category_name, ppc.category_id, l.like_id as is_liked, adisliked.action_id as is_disliked, photo.*, 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_photo AS photo
LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = photo.album_id)
LEFT JOIN phpfox_photo_category_data AS ppcd
ON(ppcd.photo_id = photo.photo_id)
LEFT JOIN phpfox_photo_category AS ppc
ON(ppc.category_id = ppcd.category_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_action AS adisliked
ON(adisliked.action_type_id = 2 AND adisliked.item_id = photo.photo_id AND adisliked.user_id = 0)
JOIN phpfox_user AS u
ON(u.user_id = photo.user_id)
WHERE photo.view_id = 0 AND photo.group_id = 0 AND photo.type_id = 0 AND photo.privacy IN(0) AND photo.user_id = 2474
GROUP BY photo.photo_id
ORDER BY photo.photo_id DESC
LIMIT 4
/* OO Query */
FROM phpfox_photo AS photo
LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = photo.album_id)
LEFT JOIN phpfox_photo_category_data AS ppcd
ON(ppcd.photo_id = photo.photo_id)
LEFT JOIN phpfox_photo_category AS ppc
ON(ppc.category_id = ppcd.category_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_action AS adisliked
ON(adisliked.action_type_id = 2 AND adisliked.item_id = photo.photo_id AND adisliked.user_id = 0)
JOIN phpfox_user AS u
ON(u.user_id = photo.user_id)
WHERE photo.view_id = 0 AND photo.group_id = 0 AND photo.type_id = 0 AND photo.privacy IN(0) AND photo.user_id = 2474
GROUP BY photo.photo_id
ORDER BY photo.photo_id DESC
LIMIT 4
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ppcd | system | photo_id | MISSING KEY | Const row not found; Using temporary; Using filesort | |||
| 1 | SIMPLE | ppc | system | PRIMARY | MISSING KEY | Const row not found | |||
| 1 | SIMPLE | adisliked | system | item_id | MISSING KEY | Const row not found | |||
| 1 | SIMPLE | u | const | PRIMARY,user_id | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | photo | ref | view_id_2,view_id,privacy,view_id_3,view_id_4,view_id_5 | view_id_3 | 10 | const,const,const,const | 2 | Using where |
| 1 | SIMPLE | l | ref|filter | type_id,type_id_2,type_id_3,item_id | item_id|type_id_3 | 4|81 | sqlgipsol.photo.photo_id | 1 (1%) | Using where; Using rowid filter |
| 1 | SIMPLE | pa | ref | PRIMARY,album_id | album_id | 4 | sqlgipsol.photo.album_id | 1 |
0.0007169
| Memory Before: 11.46 Mb
| Memory After: 11.46 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 = 2474
LIMIT 1
/* OO Query */
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 = 2474
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.0002289
| Memory Before: 12.45 Mb
| Memory After: 12.45 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'template.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'template.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002232
| Memory Before: 13.12 Mb
| Memory After: 13.12 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-body.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0019691
| Memory Before: 13.46 Mb
| Memory After: 13.48 Mb
| Memory Used: 17.98 kb
| Rows: 79
| 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 = 2474)
JOIN phpfox_module AS m
ON(m.module_id = cf.module_id AND m.is_active = 1)
LEFT JOIN phpfox_custom_group AS cg
ON(cg.group_id = cf.group_id)
WHERE cf.type_id IN ('user_main','user_panel','profile_panel') AND cf.is_active = 1 AND cf.user_group_id = 0
ORDER BY cf.ordering ASC
/* OO Query */
FROM phpfox_custom_field AS cf
LEFT JOIN phpfox_user_custom_multiple_value AS cmv
ON(cmv.field_id = cf.field_id AND cmv.user_id = 2474)
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.0008509
| Memory Before: 13.72 Mb
| Memory After: 13.74 Mb
| Memory Used: 26.91 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 2474
/* OO Query */
FROM phpfox_user_custom
WHERE user_id = 2474
/* 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.0007770
| Memory Before: 13.74 Mb
| Memory After: 13.74 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 */
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.0002410
| Memory Before: 13.84 Mb
| Memory After: 13.84 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 */
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.0002241
| Memory Before: 14.01 Mb
| Memory After: 14.01 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'hispalanguage' AND name = 'select.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002718
| Memory Before: 14.03 Mb
| Memory After: 14.03 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002811
| Memory Before: 14.03 Mb
| Memory After: 14.03 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-menu.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menu.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002291
| Memory Before: 14.05 Mb
| Memory After: 14.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 = 'core' AND name = 'template-holdername.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-holdername.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0003409
| Memory Before: 14.11 Mb
| Memory After: 14.13 Mb
| Memory Used: 18.04 kb
| Rows: 79
| 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 = 2474)
JOIN phpfox_module AS m
ON(m.module_id = cf.module_id AND m.is_active = 1)
LEFT JOIN phpfox_custom_group AS cg
ON(cg.group_id = cf.group_id)
WHERE cf.type_id IN ('user_main','user_panel','profile_panel') AND cf.is_active = 1 AND cf.user_group_id = 0
ORDER BY cf.ordering ASC
/* OO Query */
FROM phpfox_custom_field AS cf
LEFT JOIN phpfox_user_custom_multiple_value AS cmv
ON(cmv.field_id = cf.field_id AND cmv.user_id = 2474)
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.0002820
| Memory Before: 14.37 Mb
| Memory After: 14.4 Mb
| Memory Used: 26.93 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 2474
/* OO Query */
FROM phpfox_user_custom
WHERE user_id = 2474
/* 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.0002561
| Memory Before: 14.39 Mb
| Memory After: 14.39 Mb
| Memory Used: 5.67 kb
| Rows: 64
| Slave: Yes
SELECT *
FROM phpfox_custom_option
WHERE field_id IN(22,9,79,80,81,48,33,38,51,53,54,55,58,59,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77)
ORDER BY option_id ASC
/* OO Query */
FROM phpfox_custom_option
WHERE field_id IN(22,9,79,80,81,48,33,38,51,53,54,55,58,59,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77)
ORDER BY option_id ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_custom_option | ALL | field_id | MISSING KEY | 75 | Using where; Using filesort |
0.0005660
| Memory Before: 14.13 Mb
| Memory After: 14.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/header.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/header.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0004890
| Memory Before: 14.28 Mb
| Memory After: 14.29 Mb
| Memory Used: 10.52 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_photo
WHERE photo_id = 3887
/* OO Query */
FROM phpfox_photo
WHERE photo_id = 3887
/* 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.0004191
| Memory Before: 14.42 Mb
| Memory After: 14.42 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/logo.html.php'
/* OO Query */
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.0006070
| Memory Before: 14.61 Mb
| Memory After: 14.61 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/pic.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'block/pic.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002282
| Memory Before: 14.34 Mb
| Memory After: 14.35 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'search.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0002241
| Memory Before: 14.36 Mb
| Memory After: 14.36 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-contentclass.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'core' AND name = 'template-contentclass.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002241
| Memory Before: 14.36 Mb
| Memory After: 14.36 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'layout' AND name = 'error.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition |
0.0005810
| Memory Before: 14.37 Mb
| Memory After: 14.37 Mb
| Memory Used: 3.16 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'controller/info.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'profile' AND name = 'controller/info.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.0002601
| Memory Before: 14.43 Mb
| Memory After: 14.45 Mb
| Memory Used: 18.01 kb
| Rows: 79
| 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 = 2474)
JOIN phpfox_module AS m
ON(m.module_id = cf.module_id AND m.is_active = 1)
LEFT JOIN phpfox_custom_group AS cg
ON(cg.group_id = cf.group_id)
WHERE cf.type_id IN ('user_main','user_panel','profile_panel') AND cf.is_active = 1 AND cf.user_group_id = 0
ORDER BY cf.ordering ASC
/* OO Query */
FROM phpfox_custom_field AS cf
LEFT JOIN phpfox_user_custom_multiple_value AS cmv
ON(cmv.field_id = cf.field_id AND cmv.user_id = 2474)
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.0001550
| Memory Before: 14.69 Mb
| Memory After: 14.72 Mb
| Memory Used: 26.94 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 2474
/* OO Query */
FROM phpfox_user_custom
WHERE user_id = 2474
/* 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.0001349
| Memory Before: 14.71 Mb
| Memory After: 14.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 */
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.0006330
| Memory Before: 14.42 Mb
| Memory After: 14.43 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'profileinfodescrip.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'profileinfodescrip.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.0002642
| Memory Before: 14.44 Mb
| Memory After: 14.46 Mb
| Memory Used: 18.04 kb
| Rows: 79
| 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 = 2474)
JOIN phpfox_module AS m
ON(m.module_id = cf.module_id AND m.is_active = 1)
LEFT JOIN phpfox_custom_group AS cg
ON(cg.group_id = cf.group_id)
WHERE cf.type_id IN ('user_main','user_panel','profile_panel') AND cf.is_active = 1 AND cf.user_group_id = 0
ORDER BY cf.ordering ASC
/* OO Query */
FROM phpfox_custom_field AS cf
LEFT JOIN phpfox_user_custom_multiple_value AS cmv
ON(cmv.field_id = cf.field_id AND cmv.user_id = 2474)
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.0001750
| Memory Before: 14.71 Mb
| Memory After: 14.74 Mb
| Memory Used: 26.96 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 2474
/* OO Query */
FROM phpfox_user_custom
WHERE user_id = 2474
/* 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.0002410
| Memory Before: 14.73 Mb
| Memory After: 14.73 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 */
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.0005300
| Memory Before: 14.45 Mb
| Memory After: 14.45 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'profileinfomap.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'profileinfomap.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.0002861
| Memory Before: 14.48 Mb
| Memory After: 14.5 Mb
| Memory Used: 18.05 kb
| Rows: 79
| 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 = 2474)
JOIN phpfox_module AS m
ON(m.module_id = cf.module_id AND m.is_active = 1)
LEFT JOIN phpfox_custom_group AS cg
ON(cg.group_id = cf.group_id)
WHERE cf.type_id IN ('user_main','user_panel','profile_panel') AND cf.is_active = 1 AND cf.user_group_id = 0
ORDER BY cf.ordering ASC
/* OO Query */
FROM phpfox_custom_field AS cf
LEFT JOIN phpfox_user_custom_multiple_value AS cmv
ON(cmv.field_id = cf.field_id AND cmv.user_id = 2474)
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.0001590
| Memory Before: 14.75 Mb
| Memory After: 14.78 Mb
| Memory Used: 26.97 kb
| Rows: 1
| Slave: Yes
SELECT *
FROM phpfox_user_custom
WHERE user_id = 2474
/* OO Query */
FROM phpfox_user_custom
WHERE user_id = 2474
/* 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.0001349
| Memory Before: 14.77 Mb
| Memory After: 14.77 Mb
| Memory Used: 5.67 kb
| Rows: 64
| Slave: Yes
SELECT *
FROM phpfox_custom_option
WHERE field_id IN(22,9,79,80,81,48,33,38,51,53,54,55,58,59,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77)
ORDER BY option_id ASC
/* OO Query */
FROM phpfox_custom_option
WHERE field_id IN(22,9,79,80,81,48,33,38,51,53,54,55,58,59,61,62,63,64,66,68,69,70,71,72,73,74,75,76,77)
ORDER BY option_id ASC
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_custom_option | ALL | field_id | MISSING KEY | 75 | Using where; Using filesort |
0.0005910
| Memory Before: 14.5 Mb
| Memory After: 14.5 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 = 'profileinfo.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'higipsol' AND name = 'profileinfo.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.0112429
| Memory Before: 14.56 Mb
| Memory After: 14.56 Mb
| Memory Used: 3.13 kb
| Rows: 1
| Slave: No
SELECT COUNT(access_id) as count
FROM phpfox_zozketa_access AS a
WHERE a.user_id = 2474
/* OO Query */
FROM phpfox_zozketa_access AS a
WHERE a.user_id = 2474
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | a | ALL | MISSING KEY | 26895 | Using where |
0.0005870
| Memory Before: 14.56 Mb
| Memory After: 14.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 = 'profile' AND name = 'event_entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'event_entry.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.0002229
| Memory Before: 14.56 Mb
| Memory After: 14.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 = 'profile' AND name = 'event_entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'event_entry.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
0.0002649
| Memory Before: 14.56 Mb
| Memory After: 14.57 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'event_entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'event_entry.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.0002320
| Memory Before: 14.56 Mb
| Memory After: 14.57 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'event_entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'event_entry.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: 14.57 Mb
| Memory After: 14.57 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'event_entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'event_entry.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.0007119
| Memory Before: 14.57 Mb
| Memory After: 14.57 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'photo_entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'photo_entry.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.0001600
| Memory Before: 14.57 Mb
| Memory After: 14.57 Mb
| Memory Used: 3.15 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'photo_entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'photo_entry.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.0006108
| Memory Before: 14.57 Mb
| Memory After: 14.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 = 'profile' AND name = 'document_entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'document_entry.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.0002229
| Memory Before: 14.58 Mb
| Memory After: 14.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 = 'profile' AND name = 'document_entry.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'block' AND module_id = 'profile' AND name = 'document_entry.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.0002310
| Memory Before: 14.56 Mb
| Memory After: 14.56 Mb
| Memory Used: 3.25 kb
| Rows: 0
| Slave: Yes
SELECT html_data
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */
FROM phpfox_theme_template
WHERE folder = 'tm_base5' AND type_id = 'base5' AND module_id = 'core' AND name = 'block/template-menufooter.html.php'
/* OO Query */
| Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | phpfox_theme_template | ref | theme_id,theme_id_2,folder | theme_id | 176 | const,const,const | 1 | Using index condition; Using where |
Array
(
[session] => 1d3afa7912f9c05923ae6b450cc9bb08
[redirect] => /mobile/profile-2474
)
Array
(
[coreb6aavisit] => 1765305108
)
