For developers

This page will contain resources for developers of simulation tools to be hosted on iADD.

Debug Console

Close14 MBRequestSessionTimelineDatabase21Events25
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_UNIQUE_ID => Zz7fQTubihdJWkfxaUbsiwAAAAM, REDIRECT_SCRIPT_URL => /for-develop... Array(
REDIRECT_UNIQUE_ID => Zz7fQTubihdJWkfxaUbsiwAAAAM,
REDIRECT_SCRIPT_URL => /for-developers,
REDIRECT_SCRIPT_URI => https://iadd.astro.illinois.edu/for-developers,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => iadd.astro.illinois.edu,
REDIRECT_STATUS => 200,
UNIQUE_ID => Zz7fQTubihdJWkfxaUbsiwAAAAM,
SCRIPT_URL => /for-developers,
SCRIPT_URI => https://iadd.astro.illinois.edu/for-developers,
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_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 => 3.138.118.194,
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 => 12190,
REDIRECT_URL => /for-developers,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /for-developers,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1732173633.052,
REQUEST_TIME => 1732173633
)
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ 91bc8e533eaa779a509479da03fd0450
tracker.ssid ⇒ 91bc8e533eaa779a509479da03fd0450
tracker.rsid ⇒ 91bc8e533eaa779a509479da03fd0450
  • site 0.051 seconds (+0.051); 9.50 MB (+9.500) - afterInitialise
  • site 0.068 seconds (+0.017); 10.75 MB (+1.250) - afterRoute
  • site 0.106 seconds (+0.038); 13.75 MB (+3.000) - afterDispatch
  • site 0.114 seconds (+0.008); 14.00 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.115 seconds (+0.001); 14.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.116 seconds (+0.000); 14.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.117 seconds (+0.001); 14.00 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.117 seconds (+0.000); 14.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.121 seconds (+0.003); 14.25 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.122 seconds (+0.001); 14.25 MB (0.000) - onAfterRender
  • site 0.124 seconds (+0.002); 14.25 MB (0.000) - sessionStore
14 MB

21 Queries Logged: 0.012279987335205 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '339f347cd5b737cfcead1f9175e02ade'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '339f347cd5b737cfcead1f9175e02ade'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '91bc8e533eaa779a509479da03fd0450'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '91bc8e533eaa779a509479da03fd0450'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('91bc8e533eaa779a509479da03fd0450','0','1732173633','3.138.118.194')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. 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'
  9. SELECT *
      FROM `jos_viewlevels`
  10. 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
  11. 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
  12. 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
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  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_content'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  17. SELECT a.*,a.id,a.asset_id,a.title,a.alias,a.title_alias,a.introtext,a.fulltext,
      CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END AS state,a.mask,a.catid,a.created,a.created_by,a.created_by_alias,
      CASE WHEN a.modified IS NULL THEN a.created ELSE a.modified END AS modified,a.modified_by,a.checked_out,a.checked_out_time,a.publish_up,a.publish_down,a.images,a.urls,a.attribs,a.version,a.parentid,a.ordering,a.metakey,a.metadesc,a.access,a.hits,a.metadata,a.featured,a.language,a.xreference,c.title AS category_title,c.alias AS category_alias,c.access AS category_access,u.name AS author,parent.title AS parent_title,parent.id AS parent_id,parent.path AS parent_route,parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating,v.rating_count AS rating_count
      FROM `jos_content` AS `a`
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE `a`.`id` = '59'
      AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= '2024-11-21 07:20:33' )
      AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= '2024-11-21 07:20:33' )
      AND `a`.`state` IN ('1','2')
  18. SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jos_categories` AS `c`
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (`c`.`extension` = 'com_content' OR `c`.`extension` = 'system' )
      AND `c`.`access` IN ('1','1','4')
      AND `c`.`published` = '1'
      AND `s`.`id` = '2'
      AND badcats.id is null
      GROUP BY c.id,c.asset_id,c.access,c.alias,c.checked_out,c.checked_out_time,c.created_time,c.created_user_id,c.description,c.extension,c.hits,c.language,c.level,c.lft,c.metadata,c.metadesc,c.metakey,c.modified_time,c.note,c.params,c.parent_id,c.path,c.published,c.rgt,c.title,c.modified_user_id
      ORDER BY `c`.`lft` ASC
  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` <= '2024-11-21 07:20:33' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2024-11-21 07:20:33' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '156' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  21. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732173633;s:18:\"session.timer.last\";i:1732173633;s:17:\"session.timer.now\";i:1732173633;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:\"91bc8e533eaa779a509479da03fd0450\";s:12:\"tracker.ssid\";s:32:\"91bc8e533eaa779a509479da03fd0450\";s:12:\"tracker.rsid\";s:32:\"91bc8e533eaa779a509479da03fd0450\";}',`time` = '1732173633',`ip` = '3.138.118.194'
      WHERE `session_id` = '91bc8e533eaa779a509479da03fd0450'

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 5 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 2 × SELECT data
      FROM `jos_session`
  3. 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
  4. 1 × SELECT a.*,a.id,a.asset_id,a.title,a.alias,a.title_alias,a.introtext,a.fulltext,
      CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END AS state,a.mask,a.catid,a.created,a.created_by,a.created_by_alias,
      CASE WHEN a.modified IS NULL THEN a.created ELSE a.modified END AS modified,a.modified_by,a.checked_out,a.checked_out_time,a.publish_up,a.publish_down,a.images,a.urls,a.attribs,a.version,a.parentid,a.ordering,a.metakey,a.metadesc,a.access,a.hits,a.metadata,a.featured,a.language,a.xreference,c.title AS category_title,c.alias AS category_alias,c.access AS category_access,u.name AS author,parent.title AS parent_title,parent.id AS parent_id,parent.path AS parent_route,parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating,v.rating_count AS rating_count
      FROM `jos_content` AS `a`
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
  5. 1 × SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jos_categories` AS `c`
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.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 a.rules
      FROM `jos_assets` AS `a`
  8. 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
  9. 1 × SELECT session_id
      FROM `jos_session`
  10. 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
  11. 1 × SELECT *
      FROM `jos_viewlevels
  12. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  13. 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
OTHER Tables:
  1. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1732173633;s:18:\"session.timer.last\";i:1732173633;s:17:\"session.timer.now\";i:1732173633;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:\"91bc8e533eaa779a509479da03fd0450\";s:12:\"tracker.ssid\";s:32:\"91bc8e533eaa779a509479da03fd0450\";s:12:\"tracker.rsid\";s:32:\"91bc8e533eaa779a509479da03fd0450\";}',`time` = '1732173633',`ip` = '3.138.118.194'
  2. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('91bc8e533eaa779a509479da03fd0450','0','1732173633','3.138.118.194'
  3. 1 × DELETE
      FROM `jos_session`
  • 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
  • onContentPrepare — Method — plgContentLoadmodule::onContentPrepare → /core/plugins/content/loadmodule/loadmodule.php:35
  • onContentPrepare — Method — plgContentEmailcloak::onContentPrepare → /core/plugins/content/emailcloak/emailcloak.php:25
  • onContentPrepare — Method — plgContentPagebreak::onContentPrepare → /core/plugins/content/pagebreak/pagebreak.php:35
  • onContentPrepare — Method — plgContentXhubtags::onContentPrepare → /core/plugins/content/xhubtags/xhubtags.php:25
  • onContentPrepare — Method — plgContentFormatwiki::onContentPrepare → /core/plugins/content/formatwiki/formatwiki.php:63
  • onContentPrepare — Method — plgContentFormathtml::onContentPrepare → /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare — Method — plgContentExternalhref::onContentPrepare → /core/plugins/content/externalhref/externalhref.php:41
  • onContentBeforeDisplay — Method — plgContentPagenavigation::onContentBeforeDisplay → /core/plugins/content/pagenavigation/pagenavigation.php:25
  • onContentBeforeDisplay — Method — plgContentVote::onContentBeforeDisplay → /core/plugins/content/vote/vote.php:32
  • 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