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

Total Time:
0.0695710
PHP General Time:
0.0575681
GZIP:
enabled

Driver Version:
MySQL 5.7.27-log
SQL Time:
0.0120029
SQL Queries:
39
SQL Memory Usage:
636.2 Kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Database Connection:
0.00042319297790527

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

Load Balancing Enabled:
No
Requests From:
207.246.85.29


Server Time Stamp:
November 20, 2019, 11:19 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.0004659 | 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.0032759 | 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.0015230 | 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 ('8ae593692d16ac89537c9a9c385cb549', 'c56fb43d525078d2aaf85f739d93f298', '0', '1574291954', '', '0', '0', '0', '34.204.203.142', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0004220 | 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.0002761 | Memory Before: 7.64 Mb | Memory After: 7.66 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 15
ORDER BY mc.ordering ASC
0.0002470 | Memory Before: 7.63 Mb | Memory After: 7.64 Mb | Memory Used: 17.07 Kb | Rows: 1 | Slave: Yes
SELECT pc.*, pc2.name AS parent_name
FROM phpfox_photo_category AS pc
     LEFT JOIN phpfox_photo_category AS pc2
ON(pc2.category_id = pc.parent_id)

WHERE pc.category_id = 15
0.0002561 | Memory Before: 7.63 Mb | Memory After: 7.65 Mb | Memory Used: 17.16 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_language
ORDER BY is_default DESC
0.0008380 | Memory Before: 7.72 Mb | Memory After: 7.74 Mb | Memory Used: 17.2 Kb | Rows: 0 | Slave: Yes
SELECT pa.name AS album_name, pa.profile_id AS album_profile_id, pa.cover_id AS album_cover_id, pa.timeline_id AS album_timeline_id, 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, photo.*
FROM (
( SELECT photo.*
FROM phpfox_photo AS photo
INNER      JOIN phpfox_photo_category_data AS pcd
ON(pcd.photo_id = photo.photo_id)

WHERE photo.view_id = 0 AND photo.module_id is NULL AND photo.privacy IN(0) AND pcd.category_id = 15 AND photo.is_profile_photo IN (0) AND photo.is_cover_photo IN (0) AND (photo.type_id = 0 OR (photo.type_id = 1 AND photo.group_id != 0))
GROUP BY photo.photo_id
ORDER BY photo.photo_id DESC
LIMIT 20

)) AS photo
     LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = photo.album_id)
     JOIN phpfox_user AS u
ON(u.user_id = photo.user_id)

ORDER BY photo.photo_id DESC
LIMIT 20
0.0004590 | 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 photo.*
FROM phpfox_photo AS photo
INNER      JOIN phpfox_photo_category_data AS pcd
ON(pcd.photo_id = photo.photo_id)

WHERE photo.view_id = 0 AND photo.module_id is NULL AND photo.privacy IN(0) AND pcd.category_id = 15 AND photo.is_profile_photo IN (0) AND photo.is_cover_photo IN (0) AND (photo.type_id = 0 OR (photo.type_id = 1 AND photo.group_id != 0))
GROUP BY photo.photo_id
ORDER BY photo.photo_id DESC
LIMIT 20

)) AS photo
     LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = photo.album_id)
     JOIN phpfox_user AS u
ON(u.user_id = photo.user_id)
0.0002139 | Memory Before: 7.73 Mb | Memory After: 7.75 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo
WHERE (type_id = 0 OR (type_id = 1 AND (parent_user_id = 0 OR group_id))) AND user_id = 0 AND is_profile_photo IN (0) AND is_cover_photo IN (0) AND (type_id = 0 OR (type_id = 1 AND group_id != 0))
LIMIT 1
0.0002298 | Memory Before: 7.74 Mb | Memory After: 7.75 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_photo_album
WHERE user_id = 0 AND (((profile_id > 0 OR cover_id > 0 OR timeline_id > 0) AND total_photo > 0) OR (profile_id = 0 AND cover_id = 0 AND timeline_id = 0))
LIMIT 1
0.0001330 | Memory Before: 7.74 Mb | Memory After: 7.76 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT category_id
FROM phpfox_photo_category
WHERE category_id = '15'
LIMIT 1
0.0001199 | Memory Before: 7.74 Mb | Memory After: 7.76 Mb | Memory Used: 16.91 Kb | Rows: 1 | Slave: Yes
SELECT pc.category_id, pc.parent_id
FROM phpfox_photo_category AS pc
WHERE pc.category_id = 15
0.0001090 | Memory Before: 7.74 Mb | Memory After: 7.76 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT pc.category_id, pc.parent_id
FROM phpfox_photo_category AS pc
WHERE pc.category_id = 0
0.0001450 | Memory Before: 7.74 Mb | Memory After: 7.76 Mb | Memory Used: 17 Kb | Rows: 1 | Slave: No
SELECT *
FROM phpfox_photo_category
WHERE category_id =15
0.0001249 | Memory Before: 7.75 Mb | Memory After: 7.76 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT pc.*, pc2.name AS parent_name
FROM phpfox_photo_category AS pc
     LEFT JOIN phpfox_photo_category AS pc2
ON(pc2.category_id = pc.parent_id)

WHERE pc.category_id = 0
0.0003810 | Memory Before: 8.23 Mb | Memory After: 8.24 Mb | Memory Used: 17.98 Kb | Rows: 21 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 0
ORDER BY mc.ordering ASC
0.0001481 | Memory Before: 8.24 Mb | Memory After: 8.25 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 1
ORDER BY mc.ordering ASC
0.0001061 | Memory Before: 8.24 Mb | Memory After: 8.26 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 2
ORDER BY mc.ordering ASC
0.0000980 | Memory Before: 8.24 Mb | Memory After: 8.26 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 3
ORDER BY mc.ordering ASC
0.0000949 | Memory Before: 8.24 Mb | Memory After: 8.26 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 4
ORDER BY mc.ordering ASC
0.0000930 | Memory Before: 8.24 Mb | Memory After: 8.26 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 5
ORDER BY mc.ordering ASC
0.0001171 | Memory Before: 8.24 Mb | Memory After: 8.26 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 6
ORDER BY mc.ordering ASC
0.0001130 | Memory Before: 8.25 Mb | Memory After: 8.26 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 7
ORDER BY mc.ordering ASC
0.0001090 | Memory Before: 8.25 Mb | Memory After: 8.26 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 8
ORDER BY mc.ordering ASC
0.0000980 | Memory Before: 8.25 Mb | Memory After: 8.26 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 9
ORDER BY mc.ordering ASC
0.0000930 | Memory Before: 8.25 Mb | Memory After: 8.27 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 10
ORDER BY mc.ordering ASC
0.0000920 | Memory Before: 8.25 Mb | Memory After: 8.27 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 11
ORDER BY mc.ordering ASC
0.0000980 | Memory Before: 8.25 Mb | Memory After: 8.27 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 12
ORDER BY mc.ordering ASC
0.0000951 | Memory Before: 8.25 Mb | Memory After: 8.27 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 13
ORDER BY mc.ordering ASC
0.0001450 | Memory Before: 8.25 Mb | Memory After: 8.27 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 14
ORDER BY mc.ordering ASC
0.0001490 | Memory Before: 8.25 Mb | Memory After: 8.27 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 15
ORDER BY mc.ordering ASC
0.0001221 | Memory Before: 8.26 Mb | Memory After: 8.27 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 16
ORDER BY mc.ordering ASC
0.0001020 | Memory Before: 8.26 Mb | Memory After: 8.27 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 17
ORDER BY mc.ordering ASC
0.0000970 | Memory Before: 8.26 Mb | Memory After: 8.28 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 18
ORDER BY mc.ordering ASC
0.0000951 | Memory Before: 8.26 Mb | Memory After: 8.28 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 19
ORDER BY mc.ordering ASC
0.0000939 | Memory Before: 8.26 Mb | Memory After: 8.28 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 20
ORDER BY mc.ordering ASC
0.0000930 | Memory Before: 8.26 Mb | Memory After: 8.28 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT mc.category_id, mc.name
FROM phpfox_photo_category AS mc
WHERE mc.is_active = 1 AND mc.parent_id = 21
ORDER BY mc.ordering ASC
0.0005310 | Memory Before: 8.29 Mb | Memory After: 8.31 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT p.photo_id
FROM phpfox_photo AS p
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)
     JOIN phpfox_photo_info AS pi
ON(pi.photo_id = p.photo_id)
     JOIN phpfox_better_ads_sponsor AS s
ON(s.item_id = p.photo_id)
     LEFT JOIN phpfox_photo_album AS pa
ON(pa.album_id = p.album_id)

WHERE p.view_id = 0 AND p.is_sponsor = 1 AND s.module_id = 'photo' AND s.is_active = 1 AND s.is_custom = 3 AND p.module_id is NULL
ORDER BY rand()
LIMIT 100
Array
(
    [session] => 8ae593692d16ac89537c9a9c385cb549
    [redirect] => 
)