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

Total Time:
0.0710821
PHP General Time:
0.0556889
GZIP:
enabled

Driver Version:
MySQL 5.7.27-log
SQL Time:
0.0153932
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.00043988227844238

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:20 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.0004330 | 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.0076001 | 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.0016630 | 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 ('5d25780a297025db9cc1f4b0eef63201', 'c56fb43d525078d2aaf85f739d93f298', '0', '1574292011', '', '0', '0', '0', '34.204.203.142', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0003829 | 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.0003669 | 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.0011630 | 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 = 4
0.0001311 | 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 = 4
0.0000889 | 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 = 4
0.0000849 | 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(4)
0.0001321 | 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 = 4
0.0012710 | 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 (4)
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.0005920 | Memory Before: 7.72 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 (4)
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.0001318 | 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 = 4
0.0000861 | 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(4)
0.0002871 | 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.0002110 | 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.0001140 | 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.0001202 | 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.0001121 | 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.0001829 | 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.0001092 | 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.0001299 | 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] => 5d25780a297025db9cc1f4b0eef63201
    [redirect] => 
)