January 11, 2019 by
No photos have been added yet.
Captcha Challenge
Reload Image
phpFox Developers Debug Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula

Total Time:
0.0769510
PHP General Time:
0.0403128
GZIP:
enabled

Driver Version:
MySQL 5.5.62-0ubuntu0.14.04.1
SQL Time:
0.0366382
SQL Queries:
12
SQL Memory Usage:
17.94 kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A

Total Memory Usage:
2.47 Mb
Total Memory Usage (Including Debug):
2.53 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
198.13.61.26


Server Time Stamp:
March 29, 2020, 4:00 pm
PHP Version:
5.5.9-1ubuntu4.29
PHP Sapi:
apache2handler
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux

Cache:
file
SQL Queries
0.0000958 | Memory Before: 442.51 kb | Memory After: 444.02 kb | Memory Used: 1.51 kb | Rows: 1 | Slave: No
SELECT value_actual
FROM phpfox_setting
WHERE var_name = 'phpfox_version'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_settingrefvar_namevar_name102const1Using where
0.0016000 | Memory Before: 739.72 kb | Memory After: 741.07 kb | 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 ('2ccbf9601d053c76f8fc9f1db8bba8c6', 'c56fb43d525078d2aaf85f739d93f298', '0', '1585497651', '/photo/album/profile/471/profile-471/', '0', '0', '0', '35.175.121.230', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0001051 | Memory Before: 874.25 kb | Memory After: 875.76 kb | Memory Used: 1.51 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEsrefis_defaultis_default1const1 
1SIMPLEteq_refPRIMARY,theme_idPRIMARY2phpfoxfb.s.theme_id1 
0.0000579 | Memory Before: 877.59 kb | Memory After: 879.09 kb | Memory Used: 1.51 kb | Rows: 1 | Slave: No
SELECT folder AS parent_style_folder
FROM phpfox_theme_style
WHERE style_id = 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_theme_styleconststyle_id_2,style_idstyle_id_22const1 
0.0327289 | Memory Before: 1.14 Mb | Memory After: 1.14 Mb | Memory Used: 1.51 kb | Rows: 1 | Slave: Yes
SELECT f.friend_id AS is_friend, l.like_id AS is_liked, pa.*, pai.*, 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
FROM phpfox_photo_album AS pa
     LEFT JOIN phpfox_friend AS f
            ON(f.user_id = pa.user_id AND f.friend_user_id = 0)
     LEFT JOIN phpfox_like AS l
            ON(l.type_id = 'photo_album' AND l.item_id = pa.album_id AND l.user_id = 0)
     JOIN phpfox_photo_album_info AS pai
            ON(pai.album_id = pa.album_id)
     JOIN phpfox_user AS u
            ON(u.user_id = pa.user_id)

WHERE pa.profile_id = 471
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpaiALLalbum_idMISSING KEY   18226 
1SIMPLEpaeq_refPRIMARY,user_id,album_idPRIMARY4phpfoxfb.pai.album_id1Using where
1SIMPLEfeq_refuser_check,user_id,top_friend,friend_user_iduser_check8phpfoxfb.pa.user_id,const1Using index
1SIMPLElreftype_id,type_id_2,type_id_3,item_idtype_id81const,phpfoxfb.pai.album_id1 
1SIMPLEueq_refPRIMARY,user_idPRIMARY4phpfoxfb.pa.user_id1 
0.0003591 | Memory Before: 1.25 Mb | Memory After: 1.25 Mb | Memory Used: 1.51 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo AS p
WHERE p.album_id = 7009
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprefalbum_id,album_id_2album_id4const1Using index
0.0001042 | Memory Before: 1.53 Mb | Memory After: 1.53 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: No
SELECT groupid
FROM phpfox_user
WHERE user_name like 'photo'
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_userrangeuser_nameuser_name103 1Using where
0.0003650 | Memory Before: 2.22 Mb | Memory After: 2.22 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT action_id
FROM phpfox_action
WHERE action_type_id = 2 AND item_type_id = "photo-album" AND item_id = 7009 AND user_id = 0
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_actionreftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where
0.0005119 | Memory Before: 2.26 Mb | Memory After: 2.26 Mb | Memory Used: 1.51 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, 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-album")

WHERE (l.type_id = 'photo_album' OR l.type_id = 'photo-album') AND l.item_id = 7009 AND l.user_id != 0
GROUP BY u.user_id
ORDER BY l.time_stamp DESC
LIMIT 3
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLElreftype_id,type_id_2,type_id_3,item_iditem_id4const1Using where; Using temporary; Using filesort
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1 
1SIMPLEueq_refPRIMARY,user_idPRIMARY4phpfoxfb.l.user_id1 
0.0002530 | Memory Before: 2.27 Mb | Memory After: 2.27 Mb | Memory Used: 1.51 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
FROM phpfox_action AS a
     JOIN phpfox_user AS u
            ON(u.user_id = a.user_id)

WHERE a.item_type_id = "photo-album" AND a.item_id = 7009
GROUP BY u.user_id
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEareftype_id,type_id_2,type_id_3,item_idtype_id81const,const1Using where; Using temporary; Using filesort
1SIMPLEueq_refPRIMARY,user_idPRIMARY4phpfoxfb.a.user_id1 
0.0003412 | Memory Before: 2.37 Mb | Memory After: 2.37 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT SQL_CALC_FOUND_ROWS 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
FROM phpfox_photo_tag AS pt
INNER      JOIN phpfox_photo AS p
            ON(p.album_id = 7009)
     JOIN phpfox_user AS u
            ON(u.user_id = pt.tag_user_id)

WHERE pt.photo_id = p.photo_id
GROUP BY u.user_id
LIMIT 7
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEptindexphoto_id,photo_id_2,photo_id_3,photo_id_4photo_id_38 1Using index; Using temporary; Using filesort
1SIMPLEpeq_refPRIMARY,album_id,photo_id,photo_id_2,album_id_2PRIMARY4phpfoxfb.pt.photo_id1Using where
1SIMPLEueq_refPRIMARY,user_idPRIMARY4phpfoxfb.pt.tag_user_id1 
0.0001161 | Memory Before: 2.37 Mb | Memory After: 2.37 Mb | Memory Used: 1.51 kb | Rows: 1 | Slave: No
SELECT FOUND_ROWS()
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE   MISSING KEY    No tables used
Array
(
    [session] => 2ccbf9601d053c76f8fc9f1db8bba8c6
    [redirect] => /photo/album/profile/471/profile-471/
)
Go to top