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

Total Time:
0.0852211
PHP General Time:
0.0702336
GZIP:
enabled

Driver Version:
MySQL 5.7.27-log
SQL Time:
0.0149875
SQL Queries:
25
SQL Memory Usage:
398.86 Kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Database Connection:
0.00053691864013672

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

Load Balancing Enabled:
No
Requests From:
207.246.85.29


Server Time Stamp:
November 11, 2019, 11:24 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.0004900 | Memory Before: 4.28 Mb | Memory After: 4.31 Mb | Memory Used: 25.52 Kb | Rows: 34 | Slave: Yes
SELECT *
FROM phpfox_apps
WHERE is_active=1
0.0034299 | Memory Before: 7.25 Mb | Memory After: 7.25 Mb | Memory Used: 696 b | Rows: - | Slave: No
DELETE FROM phpfox_log_session WHERE id_hash = 'c56fb43d525078d2aaf85f739d93f298'
0.0014541 | Memory Before: 7.26 Mb | Memory After: 7.26 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 ('e5b76321d80b91a339a1fbd6e92fec2a', 'c56fb43d525078d2aaf85f739d93f298', '0', '1573514644', '', '0', '0', '0', '3.227.208.153', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0005698 | Memory Before: 7.36 Mb | Memory After: 7.37 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.0005400 | Memory Before: 7.59 Mb | Memory After: 7.6 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_music_song
WHERE user_id = 0 AND (module_id NOT IN ("user") OR module_id is NULL) AND (view_id != 2)
LIMIT 1
0.0003002 | Memory Before: 7.59 Mb | Memory After: 7.61 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_music_album
WHERE user_id = 0 AND (module_id NOT IN ("user") OR module_id is NULL)
LIMIT 1
0.0001760 | Memory Before: 7.59 Mb | Memory After: 7.61 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_music_playlist
WHERE user_id = 0
LIMIT 1
0.0002792 | Memory Before: 7.62 Mb | Memory After: 7.63 Mb | Memory Used: 16.98 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_music_genre
WHERE genre_id = 20
0.0019889 | Memory Before: 7.71 Mb | Memory After: 7.73 Mb | Memory Used: 17.05 Kb | Rows: 0 | Slave: Yes
SELECT lik.like_id AS is_liked, ma.name AS album_name, mp.play_id AS is_on_profile, 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, m.*
FROM (
( SELECT m.*
FROM phpfox_music_song AS m
INNER      JOIN phpfox_music_genre_data AS mgd
ON(mgd.song_id = m.song_id)

WHERE m.view_id = 0 AND m.privacy IN(0) AND mgd.genre_id = 20 AND m.item_id = 0
GROUP BY m.song_id
ORDER BY m.time_stamp DESC
LIMIT 10

)) AS m
     LEFT JOIN phpfox_like AS lik
ON(lik.type_id = 'music_song' AND lik.item_id = m.song_id AND lik.user_id = 0)
     LEFT JOIN phpfox_music_album AS ma
ON(ma.album_id = m.album_id)
     LEFT JOIN phpfox_music_profile AS mp
ON(mp.song_id = m.song_id AND mp.user_id = 0)
     LEFT JOIN phpfox_music_genre_data AS mmgd
ON(mmgd.song_id = m.song_id)
     LEFT JOIN phpfox_music_genre AS mg
ON(mg.genre_id = mmgd.genre_id)
     JOIN phpfox_user AS u
ON(u.user_id = m.user_id)

GROUP BY m.song_id
ORDER BY m.time_stamp DESC
LIMIT 10
0.0009229 | Memory Before: 7.69 Mb | Memory After: 7.71 Mb | Memory Used: 16.93 Kb | Rows: 1 | Slave: No
SELECT count(DISTINCT m.song_id) as total_rows FROM (
( SELECT m.*
FROM phpfox_music_song AS m
INNER      JOIN phpfox_music_genre_data AS mgd
ON(mgd.song_id = m.song_id)

WHERE m.view_id = 0 AND m.privacy IN(0) AND mgd.genre_id = 20 AND m.item_id = 0
GROUP BY m.song_id
ORDER BY m.time_stamp DESC
LIMIT 10

)) AS m
     LEFT JOIN phpfox_like AS lik
ON(lik.type_id = 'music_song' AND lik.item_id = m.song_id AND lik.user_id = 0)
     LEFT JOIN phpfox_music_album AS ma
ON(ma.album_id = m.album_id)
     LEFT JOIN phpfox_music_profile AS mp
ON(mp.song_id = m.song_id AND mp.user_id = 0)
     LEFT JOIN phpfox_music_genre_data AS mmgd
ON(mmgd.song_id = m.song_id)
     LEFT JOIN phpfox_music_genre AS mg
ON(mg.genre_id = mmgd.genre_id)
     JOIN phpfox_user AS u
ON(u.user_id = m.user_id)
0.0006292 | Memory Before: 8.18 Mb | Memory After: 8.19 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '1' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
0.0003941 | Memory Before: 8.22 Mb | Memory After: 8.24 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '3' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
0.0004730 | Memory Before: 8.22 Mb | Memory After: 8.24 Mb | Memory Used: 16.98 Kb | Rows: 0 | Slave: Yes
SELECT ma.*, 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
FROM phpfox_music_album AS ma
     JOIN phpfox_user AS u
ON(u.user_id = ma.user_id)

WHERE ma.view_id = 0 AND ma.privacy = 0 AND ma.total_track > 0 AND (ma.module_id is NULL)
ORDER BY ma.time_stamp DESC
LIMIT 4
0.0004220 | Memory Before: 8.23 Mb | Memory After: 8.24 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT ms.song_id
FROM phpfox_music_song AS ms
     JOIN phpfox_user AS u
ON(u.user_id = ms.user_id)
     JOIN phpfox_better_ads_sponsor AS s
ON(s.item_id = ms.song_id AND s.is_custom = 3)

WHERE ms.view_id = 0 AND ms.is_sponsor = 1 AND s.module_id = "music_song" AND s.is_active = 1 AND (ms.module_id is NULL)
ORDER BY rand()
LIMIT 100
0.0003140 | Memory Before: 8.23 Mb | Memory After: 8.25 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT ms.song_id
FROM phpfox_music_song AS ms
     JOIN phpfox_user AS u
ON(u.user_id = ms.user_id)
     LEFT JOIN phpfox_music_album AS ma
ON(ma.album_id = ms.album_id)

WHERE ms.view_id = 0 AND ms.is_featured = 1 AND (ms.module_id is NULL)
ORDER BY rand()
LIMIT 100
0.0002680 | Memory Before: 8.24 Mb | Memory After: 8.26 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '10' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
0.0002918 | Memory Before: 8.43 Mb | Memory After: 8.45 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '6' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
0.0002580 | Memory Before: 8.47 Mb | Memory After: 8.48 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '11' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
0.0002570 | Memory Before: 8.47 Mb | Memory After: 8.49 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '9' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
0.0002360 | Memory Before: 8.48 Mb | Memory After: 8.5 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '7' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
0.0002670 | Memory Before: 8.49 Mb | Memory After: 8.5 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '2' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
0.0002701 | Memory Before: 8.49 Mb | Memory After: 8.51 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '4' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
0.0002742 | Memory Before: 8.5 Mb | Memory After: 8.51 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '8' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
0.0002420 | Memory Before: 8.5 Mb | Memory After: 8.52 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '12' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
0.0002401 | Memory Before: 8.52 Mb | Memory After: 8.54 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT a.*, ap.block_id, ap.disallow_controller, ac.child_id, ac.country_id
FROM phpfox_better_ads AS a
     JOIN phpfox_better_ads_plan AS ap
ON(ap.plan_id=a.location)
     LEFT JOIN phpfox_better_ads_country AS ac
ON(ac.ads_id = a.ads_id)

WHERE a.is_custom = '3' AND a.is_active = '1' AND ap.block_id = '5' AND ap.is_active = '1' AND a.start_date <= 1573514644 AND (a.end_date = 0 OR a.end_date >= 1573514644)
Array
(
    [session] => e5b76321d80b91a339a1fbd6e92fec2a
    [redirect] => 
)