phpFox Developers Debug Toggle JavaScript Console
Version:
4.7.8
Product Code Name:
Neutron

Total Time:
0.0746841
PHP General Time:
0.0617732
GZIP:
enabled

Driver Version:
MySQL 5.7.27-log
SQL Time:
0.0129109
SQL Queries:
22
SQL Memory Usage:
348.37 Kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Database Connection:
0.0004432201385498

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

Load Balancing Enabled:
No
Requests From:
207.246.85.29


Server Time Stamp:
November 20, 2019, 11:22 pm
PHP Version:
7.3.9
PHP Sapi:
fpm-fcgi
PHP safe_mode:
false
PHP open_basedir:
false
Operating System:
Linux

Cache:
file
SQL Queries
0.0004408 | Memory Before: 4.31 Mb | Memory After: 4.34 Mb | Memory Used: 25.52 Kb | Rows: 34 | Slave: Yes
SELECT *
FROM phpfox_apps
WHERE is_active=1
0.0029352 | Memory Before: 7.28 Mb | Memory After: 7.28 Mb | Memory Used: 696 b | Rows: - | Slave: No
DELETE FROM phpfox_log_session WHERE id_hash = 'c56fb43d525078d2aaf85f739d93f298'
0.0013320 | Memory Before: 7.29 Mb | Memory After: 7.29 Mb | Memory Used: 696 b | 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 ('499e963668b6719f988d8c9dba862300', 'c56fb43d525078d2aaf85f739d93f298', '0', '1574292165', '', '0', '0', '0', '34.204.203.142', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0003941 | Memory Before: 7.32 Mb | Memory After: 7.34 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT sp.*
FROM phpfox_subscribe_purchase AS sp
     JOIN phpfox_user_field AS uf
ON(uf.subscribe_id=sp.purchase_id)

WHERE sp.user_id=0
0.0004439 | Memory Before: 7.64 Mb | Memory After: 7.66 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_video
WHERE user_id = 0 AND module_id NOT IN ("user")
LIMIT 1
0.0020440 | Memory Before: 7.65 Mb | Memory After: 7.66 Mb | Memory Used: 16.97 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_video_category
WHERE category_id = 3
0.0001910 | Memory Before: 7.65 Mb | Memory After: 7.67 Mb | Memory Used: 16.97 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_video_category
WHERE category_id = 3
0.0001040 | Memory Before: 7.65 Mb | Memory After: 7.67 Mb | Memory Used: 16.97 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_video_category
WHERE category_id = 3
0.0000899 | Memory Before: 7.65 Mb | Memory After: 7.67 Mb | Memory Used: 16.97 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_video_category
WHERE category_id IN(3)
0.0001581 | Memory Before: 7.63 Mb | Memory After: 7.65 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: No
SELECT vc.category_id
FROM phpfox_video_category AS vc
WHERE vc.parent_id = 3
0.0024431 | Memory Before: 7.72 Mb | Memory After: 7.74 Mb | Memory Used: 17.13 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, u.birthday, u.country_iso, video.*
FROM (
( SELECT vc.category_id, vc.name, video.*
FROM phpfox_video AS video
     LEFT JOIN phpfox_video_category_data AS vcd
ON(vcd.video_id = video.video_id)
     LEFT JOIN phpfox_video_category AS vc
ON(vc.category_id = vcd.category_id AND vc.is_active = 1)

WHERE video.in_process = 0 AND video.view_id = 0 AND video.item_id = 0 AND video.privacy IN(0) AND vcd.category_id IN (3)
GROUP BY video.video_id
ORDER BY video.time_stamp DESC
LIMIT 12

)) AS video
     JOIN phpfox_user AS u
ON(u.user_id = video.user_id)

ORDER BY video.time_stamp DESC
LIMIT 12
0.0007889 | Memory Before: 7.73 Mb | Memory After: 7.74 Mb | Memory Used: 16.93 Kb | Rows: 1 | Slave: No
SELECT count(*) as total_rows FROM (
( SELECT vc.category_id, vc.name, video.*
FROM phpfox_video AS video
     LEFT JOIN phpfox_video_category_data AS vcd
ON(vcd.video_id = video.video_id)
     LEFT JOIN phpfox_video_category AS vc
ON(vc.category_id = vcd.category_id AND vc.is_active = 1)

WHERE video.in_process = 0 AND video.view_id = 0 AND video.item_id = 0 AND video.privacy IN(0) AND vcd.category_id IN (3)
GROUP BY video.video_id
ORDER BY video.time_stamp DESC
LIMIT 12

)) AS video
     JOIN phpfox_user AS u
ON(u.user_id = video.user_id)
0.0001640 | Memory Before: 7.73 Mb | Memory After: 7.75 Mb | Memory Used: 16.97 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_video_category
WHERE category_id = 3
0.0001121 | Memory Before: 7.73 Mb | Memory After: 7.75 Mb | Memory Used: 16.97 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_video_category
WHERE category_id IN(3)
0.0002999 | Memory Before: 8.22 Mb | Memory After: 8.23 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: No
SELECT vc.category_id
FROM phpfox_video_category AS vc
WHERE vc.parent_id = 1
0.0001879 | Memory Before: 8.22 Mb | Memory After: 8.23 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(Distinct vcd.video_id)
FROM phpfox_video_category_data AS vcd
WHERE vcd.category_id = 1
LIMIT 1
0.0001309 | Memory Before: 8.22 Mb | Memory After: 8.23 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: No
SELECT vc.category_id
FROM phpfox_video_category AS vc
WHERE vc.parent_id = 2
0.0001631 | Memory Before: 8.22 Mb | Memory After: 8.24 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(Distinct vcd.video_id)
FROM phpfox_video_category_data AS vcd
WHERE vcd.category_id = 2
LIMIT 1
0.0001600 | Memory Before: 8.22 Mb | Memory After: 8.24 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: No
SELECT vc.category_id
FROM phpfox_video_category AS vc
WHERE vc.parent_id = 3
0.0001199 | Memory Before: 8.22 Mb | Memory After: 8.24 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(Distinct vcd.video_id)
FROM phpfox_video_category_data AS vcd
WHERE vcd.category_id = 3
LIMIT 1
0.0001080 | Memory Before: 8.22 Mb | Memory After: 8.24 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: No
SELECT vc.category_id
FROM phpfox_video_category AS vc
WHERE vc.parent_id = 4
0.0001001 | Memory Before: 8.22 Mb | Memory After: 8.24 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(Distinct vcd.video_id)
FROM phpfox_video_category_data AS vcd
WHERE vcd.category_id = 4
LIMIT 1
Array
(
    [session] => 499e963668b6719f988d8c9dba862300
    [redirect] => 
)