Groups: Browse

Search for Groups
iADD Developers
iadd-developers iADD Developers
Closed Join Policy

Debug Console

Close16 MBRequestSessionTimelineDatabase23Events16
$_GET
Array( sortby => alias ) Array(
sortby => alias
)
$_POST
Array( ) Array(

)
$_COOKIE
Array( d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41... Array(
d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B5B5A 65050 1 1 553515D 754 2 F 7 2585B 55551545652 4 6 D5B 153 11B 3165952 2164044 C 016 A17 25056 31A 4525351 4 9 1525D C 9 35C5F F 1 5 75B57575653 056 1 7 C 0555A 044 B4358 6 A16164A515412 24A 256515C1A5650545652 D 4535C575D A5D 0 754 4535357 058 E5452 95A C 652 5 016 94A,
81f30cf708470b974874c8a96a6bcdb2 => bbc36957d493ef7dfaccea6db0c4c1c8
)
$_SERVER
Array( REDIRECT_UNIQUE_ID => aOoVxzUFHsS6oC@aFcwMbgAAAAI, REDIRECT_SCRIPT_URL => /groups/brow... Array(
REDIRECT_UNIQUE_ID => aOoVxzUFHsS6oC@aFcwMbgAAAAI,
REDIRECT_SCRIPT_URL => /groups/browse,
REDIRECT_SCRIPT_URI => https://iadd.astro.illinois.edu/groups/browse,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => iadd.astro.illinois.edu,
REDIRECT_STATUS => 200,
UNIQUE_ID => aOoVxzUFHsS6oC@aFcwMbgAAAAI,
SCRIPT_URL => /groups/browse,
SCRIPT_URI => https://iadd.astro.illinois.edu/groups/browse,
HTTPS => on,
SSL_TLS_SNI => iadd.astro.illinois.edu,
HTTP_ACCEPT => */*,
HTTP_USER_AGENT => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com),
HTTP_COOKIE => d482552ea4a74f85af0bb3d73890dabc=+5+E+45E43105E+E+2444543+7406F5D+11B+37E+B4A+3+05F41134B514059+4+951135F765817+3+B5C1243+B5612+F16+3+B+2+A1B5B5A+65050+1+1+553515D+754+2+F+7+2585B+55551545652+4+6+D5B+153+11B+3165952+2164044+C+016+A17+25056+31A+4525351+4+9+1525D+C+9+35C5F+F+1+5+75B57575653+056+1+7+C+0555A+044+B4358+6+A16164A515412+24A+256515C1A5650545652+D+4535C575D+A5D+0+754+4535357+058+E5452+95A+C+652+5+016+94A; 81f30cf708470b974874c8a96a6bcdb2=bbc36957d493ef7dfaccea6db0c4c1c8,
HTTP_ACCEPT_ENCODING => gzip, br, zstd, deflate,
HTTP_HOST => iadd.astro.illinois.edu,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.37 (AlmaLinux) OpenSSL/1.1.1k PHP/5.6.40 mod_python/3.5.0 Python/2.7.18 SVN/1.10.2,
SERVER_NAME => iadd.astro.illinois.edu,
SERVER_ADDR => 128.174.51.20,
SERVER_PORT => 443,
REMOTE_ADDR => 216.73.216.30,
DOCUMENT_ROOT => /var/www/iadd,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/iadd,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/iadd/index.php,
REMOTE_PORT => 64942,
REDIRECT_URL => /groups/browse,
REDIRECT_QUERY_STRING => sortby=alias,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => sortby=alias,
REQUEST_URI => /groups/browse?sortby=alias,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1760171463.772,
REQUEST_TIME => 1760171463
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid bbc36957d493ef7dfaccea6db0c4c1c8
tracker.ssid bbc36957d493ef7dfaccea6db0c4c1c8
tracker.rsid bbc36957d493ef7dfaccea6db0c4c1c8
  • site 0.037 seconds (+0.037); 8.75 MB (+8.750) - afterInitialise
  • site 0.053 seconds (+0.016); 10.25 MB (+1.500) - afterRoute
  • site 0.089 seconds (+0.036); 14.75 MB (+4.500) - afterDispatch
  • site 0.097 seconds (+0.008); 14.75 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.099 seconds (+0.001); 15.00 MB (+0.250) - afterRenderModule mod_custom (Hub Footer)
  • site 0.101 seconds (+0.002); 15.25 MB (+0.250) - beforeRenderModule mod_collect (Collect)
  • site 0.102 seconds (+0.001); 15.50 MB (+0.250) - afterRenderModule mod_collect (Collect)
  • site 0.102 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.109 seconds (+0.007); 15.75 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.110 seconds (+0.002); 15.75 MB (0.000) - onAfterRender
  • site 0.112 seconds (+0.002); 15.75 MB (0.000) - sessionStore
16 MB

23 Queries Logged: 0.0087802410125732 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'bbc36957d493ef7dfaccea6db0c4c1c8'
  2. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  3. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  4. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  5. SELECT *
      FROM `jos_viewlevels`
  6. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  7. SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  8. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  9. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  10. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  11. DELETE
      FROM `jos_xgroups_pages_checkout`
      WHERE `userid`='0'
  12. SELECT COUNT(*)
      FROM `jos_xgroups`
      WHERE type IN (1,3)
      AND discoverability=0
      AND published='1'
      ORDER BY cn ASC;
  13. SELECT cn,description,published,gidNumber,type,public_desc,join_policy
      FROM `jos_xgroups`
      WHERE type IN (1,3)
      AND discoverability=0
      AND published='1'
      ORDER BY cn ASC
      LIMIT 0,20;
  14. SELECT *
      FROM `jos_xgroups`
      WHERE cn = '';
  15. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  16. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'com_groups'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  17. SELECT *
      FROM `jos_xgroups`
      WHERE gidNumber = '1000';
  18. (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
      where gidNumber='1000') UNION (select uidNumber, 'applicants' AS role
      from jos_xgroups_applicants
      where gidNumber='1000') UNION (select uidNumber, 'members' AS role
      from jos_xgroups_members
      where gidNumber='1000') UNION (select uidNumber, 'managers' AS role
      from jos_xgroups_managers
      where gidNumber='1000')
  19. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  20. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE `m`.`published` = '1'
      AND `e`.`enabled` = '1'
      AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= '2025-10-11 08:31:03' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2025-10-11 08:31:03' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '81' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  21. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  22. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  23. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1760171462;s:18:\"session.timer.last\";i:1760171463;s:17:\"session.timer.now\";i:1760171463;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:1:\"0\";s:7:\"session\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"bbc36957d493ef7dfaccea6db0c4c1c8\";s:12:\"tracker.ssid\";s:32:\"bbc36957d493ef7dfaccea6db0c4c1c8\";s:12:\"tracker.rsid\";s:32:\"bbc36957d493ef7dfaccea6db0c4c1c8\";}',`time` = '1760171463',`ip` = '216.73.216.30'
      WHERE `session_id` = 'bbc36957d493ef7dfaccea6db0c4c1c8'

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 7 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 2 × SELECT *
      FROM `jos_xgroups`
  3. 1 × SELECT cn,description,published,gidNumber,type,public_desc,join_policy
      FROM `jos_xgroups`
  4. 1 × SELECT a.rules
      FROM `jos_assets` AS `a`
  5. 1 × SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  6. 1 × SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
  7. 1 × SELECT COUNT(*)
      FROM `jos_xgroups`
  8. 1 × SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
  9. 1 × SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  10. 1 × SELECT *
      FROM `jos_viewlevels
  11. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  12. 1 × SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
  13. 1 × SELECT data
      FROM `jos_session`
OTHER Tables:
  1. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1760171462;s:18:\"session.timer.last\";i:1760171463;s:17:\"session.timer.now\";i:1760171463;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:1:\"0\";s:7:\"session\";}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"bbc36957d493ef7dfaccea6db0c4c1c8\";s:12:\"tracker.ssid\";s:32:\"bbc36957d493ef7dfaccea6db0c4c1c8\";s:12:\"tracker.rsid\";s:32:\"bbc36957d493ef7dfaccea6db0c4c1c8\";}',`time` = '1760171463',`ip` = '216.73.216.30'
  2. 1 × (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
  3. 1 × DELETE
      FROM `jos_xgroups_pages_checkout`
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:21
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:20
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:21
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:21
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:113
  • onAfterInitialise Method plgSystemReferrerpolicy::onAfterInitialise /core/plugins/system/referrerpolicy/referrerpolicy.php:21
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:21
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:21
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:21
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:21
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:21
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:21
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:22
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:60
  • onAfterDispatch Method PlgSystemHighlight::onAfterDispatch /core/plugins/system/highlight/highlight.php:25
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:21