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.0788832
PHP General Time:
0.0648889
GZIP:
enabled

Driver Version:
MySQL 5.7.27-log
SQL Time:
0.0139943
SQL Queries:
22
SQL Memory Usage:
349.51 Kb
SQL Slave Enabled:
No
SQL Total Slaves:
N/A
SQL Slave Server:
N/A
Database Connection:
0.00058698654174805

Total Memory Usage:
8.78 Mb
Total Memory Usage (Including Debug):
8.79 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.0006230 | 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.0049570 | 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.0028679 | 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 ('c159676c40425f66b6e2f0c7d6584d32', 'c56fb43d525078d2aaf85f739d93f298', '0', '1574291969', '', '0', '0', '0', '34.204.203.142', 'CCBot/2.0 (https://commoncrawl.org/faq/)')
0.0004089 | 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.0003910 | Memory Before: 7.72 Mb | Memory After: 7.73 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.0002949 | Memory Before: 7.72 Mb | Memory After: 7.74 Mb | Memory Used: 17 Kb | Rows: 1 | Slave: Yes
SELECT *
FROM phpfox_pages_type
WHERE type_id = 9
0.0007901 | Memory Before: 7.95 Mb | Memory After: 7.96 Mb | Memory Used: 17.09 Kb | Rows: 0 | Slave: Yes
SELECT pu.vanity_url, pc.page_type, pc.name AS category_name, u2.server_id AS profile_server_id, u2.user_image AS profile_user_image, 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, pages_type.name as type_name, pages.*
FROM (
( SELECT pages.*
FROM phpfox_pages AS pages
WHERE pages.app_id = 0 AND pages.view_id = 0 AND pages.type_id = 9 AND (pages.user_id = 0 OR pages.reg_method <> 2)

)) AS pages
     JOIN phpfox_pages_type AS pages_type
ON(pages_type.type_id = pages.type_id AND pages_type.item_type = 1)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = pages.page_id)
     LEFT JOIN phpfox_pages_category AS pc
ON(pc.category_id = pages.category_id)
     LEFT JOIN phpfox_user AS u2
ON(u2.profile_page_id = pages.page_id)
     JOIN phpfox_user AS u
ON(u.user_id = pages.user_id)

ORDER BY pages.time_stamp DESC
LIMIT 10
0.0003359 | Memory Before: 7.92 Mb | Memory After: 7.94 Mb | Memory Used: 16.93 Kb | Rows: 1 | Slave: No
SELECT count(*) as total_rows FROM (
( SELECT pages.*
FROM phpfox_pages AS pages
WHERE pages.app_id = 0 AND pages.view_id = 0 AND pages.type_id = 9 AND (pages.user_id = 0 OR pages.reg_method <> 2)

)) AS pages
     JOIN phpfox_pages_type AS pages_type
ON(pages_type.type_id = pages.type_id AND pages_type.item_type = 1)
     LEFT JOIN phpfox_pages_url AS pu
ON(pu.page_id = pages.page_id)
     LEFT JOIN phpfox_pages_category AS pc
ON(pc.category_id = pages.category_id)
     LEFT JOIN phpfox_user AS u2
ON(u2.profile_page_id = pages.page_id)
     JOIN phpfox_user AS u
ON(u.user_id = pages.user_id)
0.0004170 | Memory Before: 8 Mb | Memory After: 8.02 Mb | Memory Used: 16.91 Kb | Rows: 0 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'groups.index' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
0.0002420 | Memory Before: 8.01 Mb | Memory After: 8.02 Mb | Memory Used: 16.91 Kb | Rows: 0 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active, m.mobile_icon
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id = 0 AND m.m_connection = 'groups' AND m.is_active = 1
GROUP BY m.menu_id
ORDER BY m.ordering ASC
0.0003090 | Memory Before: 8.01 Mb | Memory After: 8.02 Mb | Memory Used: 17.91 Kb | Rows: 7 | Slave: No
SELECT m.menu_id, m.parent_id, m.m_connection, m.var_name, m.disallow_access, mo.module_id AS module, m.url_value AS url, mo.is_active AS module_is_active
FROM phpfox_menu AS m
     JOIN phpfox_module AS mo
ON(mo.module_id = m.module_id AND mo.is_active = 1)
     JOIN phpfox_product AS p
ON(m.product_id = p.product_id AND p.is_active = 1)

WHERE m.parent_id > 0 AND m.is_active = 1
ORDER BY m.ordering ASC
0.0004849 | Memory Before: 8.43 Mb | Memory After: 8.45 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.0002081 | Memory Before: 8.43 Mb | Memory After: 8.45 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.0002329 | Memory Before: 8.44 Mb | Memory After: 8.45 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.0001428 | Memory Before: 8.44 Mb | Memory After: 8.46 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.0001292 | Memory Before: 8.44 Mb | Memory After: 8.46 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.0001059 | Memory Before: 8.44 Mb | Memory After: 8.46 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.0001168 | Memory Before: 8.44 Mb | Memory After: 8.46 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.0001371 | Memory Before: 8.44 Mb | Memory After: 8.46 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.0001249 | Memory Before: 8.45 Mb | Memory After: 8.46 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.0003240 | Memory Before: 8.46 Mb | Memory After: 8.48 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.0003510 | Memory Before: 8.46 Mb | Memory After: 8.48 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] => c159676c40425f66b6e2f0c7d6584d32
    [redirect] => 
)