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

Total Time:
0.0774620
PHP General Time:
0.0635002
GZIP:
enabled

Driver Version:
MySQL 5.7.27-log
SQL Time:
0.0139618
SQL Queries:
29
SQL Memory Usage:
466.82 Kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Database Connection:
0.00091814994812012

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

Load Balancing Enabled:
No
Requests From:
207.246.85.29


Server Time Stamp:
November 20, 2019, 11:23 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.0005350 | 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.0030541 | 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.0015359 | 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 ('156c8b14819a02667027310c855ffa8c', 'c56fb43d525078d2aaf85f739d93f298', '0', '1574292234', '', '0', '0', '0', '34.204.203.142', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0003960 | 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.0004821 | 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.0006812 | 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 = 2
0.0001361 | 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 = 2
0.0001531 | 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 = 2
0.0000961 | 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(2)
0.0001540 | 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 = 2
0.0030959 | 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 (2)
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.0006878 | 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 (2)
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.0001409 | 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 = 2
0.0001040 | 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(2)
0.0004489 | Memory Before: 8.21 Mb | Memory After: 8.22 Mb | Memory Used: 17.3 Kb | Rows: 4 | Slave: Yes
SELECT *
FROM phpfox_video_category
WHERE parent_id = 0 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC
0.0002100 | Memory Before: 8.21 Mb | Memory After: 8.23 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_video_category
WHERE parent_id = 1 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC
0.0001650 | Memory Before: 8.21 Mb | Memory After: 8.23 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_video_category
WHERE parent_id = 2 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC
0.0001440 | Memory Before: 8.21 Mb | Memory After: 8.23 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_video_category
WHERE parent_id = 3 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC
0.0001400 | Memory Before: 8.22 Mb | Memory After: 8.23 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_video_category
WHERE parent_id = 4 AND is_active = 1 AND category_id <> 0
ORDER BY ordering ASC
0.0001609 | 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.0001941 | 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.0001199 | 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 = 2
0.0001030 | 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.0000930 | 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.0001049 | 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.0001230 | 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.0001080 | Memory Before: 8.23 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
0.0002580 | Memory Before: 8.24 Mb | Memory After: 8.25 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT v.video_id
FROM phpfox_video AS v
WHERE v.is_featured = 1 AND v.in_process = 0 AND v.view_id = 0 AND v.item_id = 0
0.0003369 | Memory Before: 8.24 Mb | Memory After: 8.26 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT v.video_id
FROM phpfox_video AS v
     JOIN phpfox_better_ads_sponsor AS s
ON(s.item_id = v.video_id AND s.is_custom = 3)

WHERE s.module_id= "v" AND s.is_active = 1 AND v.is_sponsor = 1 AND v.in_process = 0 AND v.view_id = 0 AND s.module_id = 'v' AND v.item_id = 0
Array
(
    [session] => 156c8b14819a02667027310c855ffa8c
    [redirect] => 
)