phpFox Developers Debug Toggle JavaScript Console
Version:
3.8.0
Product Code Name:
Nebula

Total Time:
0.0623851
PHP General Time:
0.053693
GZIP:
enabled

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

Total Memory Usage:
2.52 Mb
Total Memory Usage (Including Debug):
2.58 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
198.13.61.26


Server Time Stamp:
July 3, 2020, 10:58 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.0000761 | Memory Before: 442.77 kb | Memory After: 444.28 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.0012560 | Memory Before: 738.49 kb | Memory After: 739.84 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 ('6fc21f0ff38b32e098a4b0103ac255ac', 'c56fb43d525078d2aaf85f739d93f298', '0', '1593817139', '/mobile/pages/', '0', '0', '0', '3.233.229.90', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0000679 | Memory Before: 873.1 kb | Memory After: 874.61 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.0000470 | Memory Before: 876.44 kb | Memory After: 877.95 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.0019119 | Memory Before: 1.46 Mb | Memory After: 1.46 Mb | Memory Used: 1.51 kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_pages AS pages
WHERE pages.app_id = 0 AND pages.view_id = 0 AND pages.privacy IN(0)
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpagesrefview_id_2,app_id,app_id_2,app_id_3,app_id_4,view_idapp_id_26const,const,const5Using index
0.0021181 | Memory Before: 1.48 Mb | Memory After: 1.48 Mb | Memory Used: 1.51 kb | Rows: 4 | Slave: Yes
SELECT pu.vanity_url, pc.page_type, pc.name AS category_name, u2.server_id AS profile_server_id, u2.user_image AS profile_user_image, pages.*, 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_pages AS pages
     LEFT JOIN phpfox_pages_url AS pu
            ON(pu.page_id = pages.page_id)
     LEFT JOIN phpfox_pages_category AS pc
            ON(pc.category_id = pages.category_id)
     LEFT JOIN phpfox_user AS u2
            ON(u2.profile_page_id = pages.page_id)
     JOIN phpfox_user AS u
            ON(u.user_id = pages.user_id)

WHERE pages.app_id = 0 AND pages.view_id = 0 AND pages.privacy IN(0)
ORDER BY pages.time_stamp DESC
LIMIT 10
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEpagesALLview_id_2,app_id,app_id_2,app_id_3,app_id_4,view_idMISSING KEY   6Using where; Using filesort
1SIMPLEpurefpage_idpage_id4phpfoxfb.pages.page_id1 
1SIMPLEpceq_refPRIMARY,category_idPRIMARY3phpfoxfb.pages.category_id1 
1SIMPLEu2refpage_idpage_id4phpfoxfb.pages.page_id19378 
1SIMPLEueq_refPRIMARY,user_idPRIMARY4phpfoxfb.pages.user_id1 
0.0014529 | Memory Before: 2.17 Mb | Memory After: 2.17 Mb | Memory Used: 1.51 kb | Rows: 6 | Slave: Yes
SELECT pt.*
FROM phpfox_pages_type AS pt
WHERE pt.is_active = 1
ORDER BY pt.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEptALLis_activeMISSING KEY   6Using where; Using filesort
0.0002761 | Memory Before: 2.29 Mb | Memory After: 2.29 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "macore|pagescategory"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   1Using where
0.0006368 | Memory Before: 2.32 Mb | Memory After: 2.32 Mb | Memory Used: 1.51 kb | Rows: 2 | 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 = "pages")

WHERE (l.type_id = 'pages' OR l.type_id = 'pages') AND l.item_id = 1 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_idtype_id81const,const2Using 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.0002840 | Memory Before: 2.33 Mb | Memory After: 2.33 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 = "pages" AND item_id = 1 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.0002761 | Memory Before: 2.36 Mb | Memory After: 2.36 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 = "pages" AND a.item_id = 1
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.0000660 | Memory Before: 2.42 Mb | Memory After: 2.42 Mb | Memory Used: 1.51 kb | Rows: 6 | Slave: Yes
SELECT pt.*
FROM phpfox_pages_type AS pt
WHERE pt.is_active = 1
ORDER BY pt.ordering ASC
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEptALLis_activeMISSING KEY   6Using where; Using filesort
0.0002232 | Memory Before: 2.49 Mb | Memory After: 2.49 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "pages|category"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   1Using where
Array
(
    [session] => 6fc21f0ff38b32e098a4b0103ac255ac
    [redirect] => /mobile/pages/
)