Route: forum.forum ID: #forum_forum CSS: theme_material _is_guest_user material_html
phpFox Developers Debug Toggle JavaScript Console
Version:
4.7.8
Product Code Name:
Neutron

Total Time:
0.0617180
PHP General Time:
0.0530169
GZIP:
enabled

Driver Version:
MySQL 5.7.27-log
SQL Time:
0.0087011
SQL Queries:
21
SQL Memory Usage:
334.39 Kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Database Connection:
0.00041317939758301

Total Memory Usage:
8.56 Mb
Total Memory Usage (Including Debug):
8.56 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.0004089 | 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.0029938 | 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.0010982 | 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 ('94ea81809eae197c1a215304ba04b3ff', 'c56fb43d525078d2aaf85f739d93f298', '0', '1574292215', '', '0', '0', '0', '34.204.203.142', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0003331 | 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.0004609 | Memory Before: 7.65 Mb | Memory After: 7.67 Mb | Memory Used: 20.02 Kb | Rows: 9 | Slave: Yes
SELECT f.forum_id, f.thread_id, f.total_thread, f.total_post, f.post_id, ft.title AS thread_title, ft.title_url AS thread_title_url, ft.time_update AS thread_time_stamp, 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_forum AS f
     LEFT JOIN phpfox_forum_thread AS ft
ON(ft.thread_id = f.thread_id)
     LEFT JOIN phpfox_user AS u
ON(u.user_id = f.last_user_id)

WHERE f.view_id = 0
0.0002708 | Memory Before: 7.74 Mb | Memory After: 7.75 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT forum_id
FROM phpfox_forum_access
WHERE var_value = 0 AND var_name = 'can_view_forum' AND user_group_id = 3
0.0006239 | Memory Before: 7.74 Mb | Memory After: 7.76 Mb | Memory Used: 17.33 Kb | Rows: 0 | Slave: Yes
SELECT ft.*, fs.subscribe_id AS is_subscribed, f.name AS forum_name, f.name_url AS forum_url, f.is_closed AS forum_is_closed, 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, u2.user_id AS last_user_id, u2.profile_page_id AS last_profile_page_id, u2.server_id AS last_server_id, u2.user_name AS last_user_name, u2.full_name AS last_full_name, u2.gender AS last_gender, u2.user_image AS last_user_image, u2.is_invisible AS last_is_invisible, u2.user_group_id AS last_user_group_id, u2.language_id AS last_language_id, u2.birthday AS last_birthday, u2.country_iso AS last_country_iso
FROM (
( SELECT ft.*
FROM phpfox_forum_thread AS ft
WHERE ft.forum_id = 1 AND ft.group_id = 0 AND ft.view_id = 0 AND ft.is_announcement = 0
ORDER BY ft.order_id DESC , ft.time_stamp DESC
LIMIT 5

)) AS ft
     JOIN phpfox_user AS u
ON(u.user_id = ft.user_id)
     LEFT JOIN phpfox_forum_subscribe AS fs
ON(fs.thread_id = ft.thread_id AND fs.user_id = 0)
     LEFT JOIN phpfox_user AS u2
ON(u2.user_id = ft.last_user_id)
     LEFT JOIN phpfox_forum AS f
ON(f.forum_id = ft.forum_id)

ORDER BY ft.order_id DESC , ft.time_stamp DESC
0.0001841 | Memory Before: 7.74 Mb | Memory After: 7.76 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: No
SELECT COUNT(*)
FROM phpfox_forum_thread AS ft
WHERE ft.forum_id = 1 AND ft.group_id = 0 AND ft.view_id = 0 AND ft.is_announcement = 0
LIMIT 1
0.0001400 | Memory Before: 7.76 Mb | Memory After: 7.77 Mb | Memory Used: 17.17 Kb | Rows: 9 | Slave: Yes
SELECT forum_id
FROM phpfox_forum
0.0001960 | Memory Before: 7.76 Mb | Memory After: 7.78 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT moderator_id, user_id
FROM phpfox_forum_moderator
WHERE forum_id = 1
0.0001011 | Memory Before: 7.76 Mb | Memory After: 7.78 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT moderator_id, user_id
FROM phpfox_forum_moderator
WHERE forum_id = 2
0.0000942 | Memory Before: 7.76 Mb | Memory After: 7.78 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT moderator_id, user_id
FROM phpfox_forum_moderator
WHERE forum_id = 3
0.0000801 | Memory Before: 7.76 Mb | Memory After: 7.78 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT moderator_id, user_id
FROM phpfox_forum_moderator
WHERE forum_id = 4
0.0000739 | Memory Before: 7.76 Mb | Memory After: 7.78 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT moderator_id, user_id
FROM phpfox_forum_moderator
WHERE forum_id = 5
0.0000720 | Memory Before: 7.76 Mb | Memory After: 7.78 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT moderator_id, user_id
FROM phpfox_forum_moderator
WHERE forum_id = 6
0.0000720 | Memory Before: 7.77 Mb | Memory After: 7.78 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT moderator_id, user_id
FROM phpfox_forum_moderator
WHERE forum_id = 7
0.0000720 | Memory Before: 7.77 Mb | Memory After: 7.78 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT moderator_id, user_id
FROM phpfox_forum_moderator
WHERE forum_id = 8
0.0000849 | Memory Before: 7.77 Mb | Memory After: 7.78 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT moderator_id, user_id
FROM phpfox_forum_moderator
WHERE forum_id = 9
0.0003591 | Memory Before: 7.77 Mb | Memory After: 7.78 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT ft.*, fs.subscribe_id AS is_subscribed, fa.announcement_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
FROM phpfox_forum_announcement AS fa
     JOIN phpfox_forum_thread AS ft
ON(ft.thread_id = fa.thread_id)
     LEFT JOIN phpfox_forum_subscribe AS fs
ON(fs.thread_id = ft.thread_id AND fs.user_id = 0)
     JOIN phpfox_user AS u
ON(u.user_id = ft.user_id)

WHERE fa.forum_id = 1
ORDER BY ft.time_update DESC
LIMIT 10
0.0001619 | Memory Before: 7.77 Mb | Memory After: 7.78 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_forum_thread
WHERE user_id =0 AND group_id = 0 AND view_id >= 0 and is_announcement = 0
LIMIT 1
0.0008202 | Memory Before: 8.3 Mb | Memory After: 8.31 Mb | Memory Used: 16.9 Kb | Rows: 0 | Slave: Yes
SELECT fp.*, fpt.text_parsed, ft.title as thread_title, 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 (
( SELECT fp.*
FROM phpfox_forum_post AS fp
     JOIN phpfox_forum_thread AS ft
ON(ft.thread_id = fp.thread_id)

WHERE ft.group_id = '0' AND ft.view_id = '0' AND ft.forum_id = '1'
ORDER BY fp.time_stamp DESC , ft.time_update DESC
LIMIT 4

)) AS fp
     JOIN phpfox_forum_thread AS ft
ON(ft.thread_id = fp.thread_id)
     JOIN phpfox_forum_post_text AS fpt
ON(fpt.post_id = fp.post_id)
     JOIN phpfox_user AS u
ON(u.user_id = fp.user_id)

ORDER BY fp.time_stamp DESC , ft.time_update DESC
Array
(
    [session] => 94ea81809eae197c1a215304ba04b3ff
    [redirect] => 
)