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

Total Time:
0.0900669
PHP General Time:
0.0863998
GZIP:
enabled

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

Total Memory Usage:
2.26 Mb
Total Memory Usage (Including Debug):
2.3 Mb
Memory Limit:
0.5 b (-1)

Load Balancing Enabled:
No
Requests From:
198.13.61.26


Server Time Stamp:
October 21, 2019, 11:46 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.0001230 | Memory Before: 442.38 kb | Memory After: 443.88 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.0012531 | Memory Before: 737.96 kb | Memory After: 739.31 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 ('0a21eb6cc4b84458ca29b9c5d578a05f', 'c56fb43d525078d2aaf85f739d93f298', '0', '1571701616', '/mobile/video/', '0', '0', '0', '34.204.171.108', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0000699 | Memory Before: 872.54 kb | Memory After: 874.05 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: 875.88 kb | Memory After: 877.38 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.0008690 | Memory Before: 1.39 Mb | Memory After: 1.39 Mb | Memory Used: 1.51 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 */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_tagrefcategory_id,tag_url,user_search,user_search_general,category_id_2category_id77const1Using where
0.0002639 | Memory Before: 1.41 Mb | Memory After: 1.41 Mb | Memory Used: 1.51 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)
LIMIT 1
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEmrefin_process,view_id,in_process_2,in_process_3,in_process_4,in_process_5,in_process_6in_process1const1Using where
0.0003130 | Memory Before: 2.07 Mb | Memory After: 2.07 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "macore|videocategory"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   1Using where
0.0003672 | Memory Before: 2.11 Mb | Memory After: 2.11 Mb | Memory Used: 1.51 kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_ad
WHERE location = "video|category"
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_adALL MISSING KEY   1Using where
0.0003610 | Memory Before: 2.17 Mb | Memory After: 2.17 Mb | Memory Used: 1.54 kb | Rows: 0 | Slave: Yes
SELECT category_id, tag_text AS tag, tag_url, COUNT(item_id) AS total
FROM phpfox_tag
WHERE category_id = 'video' AND added > 1571096816
GROUP BY tag_text, tag_url
HAVING total > 1
ORDER BY total DESC
LIMIT 10
/* OO Query */
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpfox_tagrefcategory_id,user_search,user_search_general,category_id_2category_id77const1Using where; Using temporary; Using filesort
Array
(
    [session] => 0a21eb6cc4b84458ca29b9c5d578a05f
    [redirect] => /mobile/video/
)