Route: groups.index ID: #groups_index CSS: theme_material _is_guest_user material_html
No Groups found.
phpFox Developers Debug Toggle JavaScript Console
Version:
4.7.8
Product Code Name:
Neutron

Total Time:
0.0734241
PHP General Time:
0.0601554
GZIP:
enabled

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

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

Load Balancing Enabled:
No
Requests From:
207.246.85.29


Server Time Stamp:
November 18, 2019, 10:33 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.0009291 | 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.0037000 | 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.0017340 | Memory Before: 7.25 Mb | Memory After: 7.25 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 ('02cad631134afe9cb1b65a3a71025346', 'c56fb43d525078d2aaf85f739d93f298', '0', '1574116413', '', '0', '0', '0', '3.93.74.227', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0004220 | Memory Before: 7.29 Mb | Memory After: 7.31 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.0003250 | Memory Before: 7.67 Mb | Memory After: 7.69 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT count(*)
FROM phpfox_pages
WHERE user_id = '0' AND item_type = '1'
LIMIT 1
0.0002890 | Memory Before: 7.68 Mb | Memory After: 7.7 Mb | Memory Used: 17.42 Kb | Rows: 4 | Slave: Yes
SELECT pt.*
FROM phpfox_pages_type AS pt
WHERE pt.item_type = 1 AND pt.is_active = 1
ORDER BY pt.ordering ASC
0.0012751 | Memory Before: 7.87 Mb | Memory After: 7.89 Mb | Memory Used: 17.45 Kb | Rows: 0 | Slave: Yes
SELECT pages.*, pt.text, pt.text_parsed, pu.vanity_url, u2.user_id AS profile_user_id, u2.profile_page_id AS profile_profile_page_id, u2.server_id AS profile_server_id, u2.user_name AS profile_user_name, u2.full_name AS profile_full_name, u2.gender AS profile_gender, u2.user_image AS profile_user_image, u2.is_invisible AS profile_is_invisible, u2.user_group_id AS profile_user_group_id, u2.language_id AS profile_language_id, u2.birthday AS profile_birthday, u2.country_iso AS profile_country_iso
FROM (
( SELECT pages.*
FROM phpfox_pages AS pages
WHERE pages.type_id = 6 AND pages.app_id = 0 AND pages.view_id = 0 AND (pages.user_id = 0 OR pages.reg_method <> 2)
ORDER BY pages.time_stamp DESC
LIMIT 6

)) AS pages
     JOIN phpfox_user AS u2
ON(u2.profile_page_id = pages.page_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = pages.page_id)
     LEFT JOIN phpfox_pages_text AS pt
ON(pt.page_id = pages.page_id)

ORDER BY pages.time_stamp DESC
LIMIT 6
0.0001981 | Memory Before: 7.87 Mb | Memory After: 7.89 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_pages AS pages
WHERE pages.item_type = 1 AND pages.type_id = 6 AND pages.view_id = 0 AND (pages.user_id = 0 OR pages.reg_method <> 2)
LIMIT 1
0.0006020 | Memory Before: 7.87 Mb | Memory After: 7.89 Mb | Memory Used: 17.45 Kb | Rows: 0 | Slave: Yes
SELECT pages.*, pt.text, pt.text_parsed, pu.vanity_url, u2.user_id AS profile_user_id, u2.profile_page_id AS profile_profile_page_id, u2.server_id AS profile_server_id, u2.user_name AS profile_user_name, u2.full_name AS profile_full_name, u2.gender AS profile_gender, u2.user_image AS profile_user_image, u2.is_invisible AS profile_is_invisible, u2.user_group_id AS profile_user_group_id, u2.language_id AS profile_language_id, u2.birthday AS profile_birthday, u2.country_iso AS profile_country_iso
FROM (
( SELECT pages.*
FROM phpfox_pages AS pages
WHERE pages.type_id = 7 AND pages.app_id = 0 AND pages.view_id = 0 AND (pages.user_id = 0 OR pages.reg_method <> 2)
ORDER BY pages.time_stamp DESC
LIMIT 6

)) AS pages
     JOIN phpfox_user AS u2
ON(u2.profile_page_id = pages.page_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = pages.page_id)
     LEFT JOIN phpfox_pages_text AS pt
ON(pt.page_id = pages.page_id)

ORDER BY pages.time_stamp DESC
LIMIT 6
0.0001531 | Memory Before: 7.87 Mb | Memory After: 7.89 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_pages AS pages
WHERE pages.item_type = 1 AND pages.type_id = 7 AND pages.view_id = 0 AND (pages.user_id = 0 OR pages.reg_method <> 2)
LIMIT 1
0.0005810 | Memory Before: 7.88 Mb | Memory After: 7.89 Mb | Memory Used: 17.45 Kb | Rows: 0 | Slave: Yes
SELECT pages.*, pt.text, pt.text_parsed, pu.vanity_url, u2.user_id AS profile_user_id, u2.profile_page_id AS profile_profile_page_id, u2.server_id AS profile_server_id, u2.user_name AS profile_user_name, u2.full_name AS profile_full_name, u2.gender AS profile_gender, u2.user_image AS profile_user_image, u2.is_invisible AS profile_is_invisible, u2.user_group_id AS profile_user_group_id, u2.language_id AS profile_language_id, u2.birthday AS profile_birthday, u2.country_iso AS profile_country_iso
FROM (
( SELECT pages.*
FROM phpfox_pages AS pages
WHERE pages.type_id = 8 AND pages.app_id = 0 AND pages.view_id = 0 AND (pages.user_id = 0 OR pages.reg_method <> 2)
ORDER BY pages.time_stamp DESC
LIMIT 6

)) AS pages
     JOIN phpfox_user AS u2
ON(u2.profile_page_id = pages.page_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = pages.page_id)
     LEFT JOIN phpfox_pages_text AS pt
ON(pt.page_id = pages.page_id)

ORDER BY pages.time_stamp DESC
LIMIT 6
0.0001471 | Memory Before: 7.88 Mb | Memory After: 7.89 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_pages AS pages
WHERE pages.item_type = 1 AND pages.type_id = 8 AND pages.view_id = 0 AND (pages.user_id = 0 OR pages.reg_method <> 2)
LIMIT 1
0.0005591 | Memory Before: 7.88 Mb | Memory After: 7.9 Mb | Memory Used: 17.45 Kb | Rows: 0 | Slave: Yes
SELECT pages.*, pt.text, pt.text_parsed, pu.vanity_url, u2.user_id AS profile_user_id, u2.profile_page_id AS profile_profile_page_id, u2.server_id AS profile_server_id, u2.user_name AS profile_user_name, u2.full_name AS profile_full_name, u2.gender AS profile_gender, u2.user_image AS profile_user_image, u2.is_invisible AS profile_is_invisible, u2.user_group_id AS profile_user_group_id, u2.language_id AS profile_language_id, u2.birthday AS profile_birthday, u2.country_iso AS profile_country_iso
FROM (
( SELECT pages.*
FROM phpfox_pages AS pages
WHERE pages.type_id = 9 AND pages.app_id = 0 AND pages.view_id = 0 AND (pages.user_id = 0 OR pages.reg_method <> 2)
ORDER BY pages.time_stamp DESC
LIMIT 6

)) AS pages
     JOIN phpfox_user AS u2
ON(u2.profile_page_id = pages.page_id)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = pages.page_id)
     LEFT JOIN phpfox_pages_text AS pt
ON(pt.page_id = pages.page_id)

ORDER BY pages.time_stamp DESC
LIMIT 6
0.0001469 | Memory Before: 7.88 Mb | Memory After: 7.9 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT COUNT(*)
FROM phpfox_pages AS pages
WHERE pages.item_type = 1 AND pages.type_id = 9 AND pages.view_id = 0 AND (pages.user_id = 0 OR pages.reg_method <> 2)
LIMIT 1
0.0004351 | Memory Before: 8.36 Mb | Memory After: 8.38 Mb | Memory Used: 17.42 Kb | Rows: 4 | Slave: Yes
SELECT *
FROM phpfox_pages_type
WHERE is_active = 1 AND item_type = 1
ORDER BY ordering ASC
0.0001581 | Memory Before: 8.37 Mb | Memory After: 8.38 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT count(*)
FROM phpfox_pages
WHERE type_id = '6' AND view_id = '0'
LIMIT 1
0.0001931 | Memory Before: 8.37 Mb | Memory After: 8.39 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_pages_category
WHERE type_id = 6 AND is_active = 1
ORDER BY ordering ASC
0.0001209 | Memory Before: 8.37 Mb | Memory After: 8.39 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT count(*)
FROM phpfox_pages
WHERE type_id = '7' AND view_id = '0'
LIMIT 1
0.0001531 | Memory Before: 8.37 Mb | Memory After: 8.39 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_pages_category
WHERE type_id = 7 AND is_active = 1
ORDER BY ordering ASC
0.0001640 | Memory Before: 8.37 Mb | Memory After: 8.39 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT count(*)
FROM phpfox_pages
WHERE type_id = '8' AND view_id = '0'
LIMIT 1
0.0001440 | Memory Before: 8.37 Mb | Memory After: 8.39 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_pages_category
WHERE type_id = 8 AND is_active = 1
ORDER BY ordering ASC
0.0001070 | Memory Before: 8.38 Mb | Memory After: 8.39 Mb | Memory Used: 16.89 Kb | Rows: 1 | Slave: Yes
SELECT count(*)
FROM phpfox_pages
WHERE type_id = '9' AND view_id = '0'
LIMIT 1
0.0001168 | Memory Before: 8.38 Mb | Memory After: 8.39 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT *
FROM phpfox_pages_category
WHERE type_id = 9 AND is_active = 1
ORDER BY ordering ASC
0.0003161 | Memory Before: 8.38 Mb | Memory After: 8.4 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT p.page_id
FROM phpfox_pages AS p
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)

WHERE p.view_id = 0 AND p.is_featured = 1 AND p.item_type = 1
ORDER BY rand()
LIMIT 100
0.0002990 | Memory Before: 8.39 Mb | Memory After: 8.41 Mb | Memory Used: 16.86 Kb | Rows: 0 | Slave: Yes
SELECT p.page_id
FROM phpfox_pages AS p
     JOIN phpfox_user AS u
ON(u.user_id = p.user_id)
     JOIN phpfox_better_ads_sponsor AS s
ON(s.item_id = p.page_id)

WHERE p.view_id = 0 AND p.is_sponsor = 1 AND s.module_id = 'groups' AND s.is_active = 1 AND s.is_custom = 3
ORDER BY rand()
LIMIT 100
Array
(
    [session] => 02cad631134afe9cb1b65a3a71025346
    [redirect] => 
)