Members: Browse

Debug Console

Close27 MBRequestSessionTimelineDatabase55Events15
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( NO_PROXY => .s2.internal, https_proxy => http://10.8.63.5:3128, http_proxy => http:/... Array(
NO_PROXY => .s2.internal,
https_proxy => http://10.8.63.5:3128,
http_proxy => http://10.8.63.5:3128,
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /members,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/members,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /members,
SCRIPT_URI => https://datacenterhub.org/members,
HTTPS => on,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_IF_MODIFIED_SINCE => Sat, 29 Feb 2020 13:54:34 GMT,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => datacenterhub.org,
HTTP_CONNECTION => Keep-Alive,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache,
SERVER_NAME => datacenterhub.org,
SERVER_ADDR => 10.111.11.100,
SERVER_PORT => 443,
REMOTE_ADDR => 10.111.11.10,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 22765,
REDIRECT_URL => /members,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /members,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1590780005.6671,
REQUEST_TIME => 1590780005,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 3a7cb1db21488abb610f959e58ad49b1
tracker.ssid 3a7cb1db21488abb610f959e58ad49b1
tracker.rsid 3a7cb1db21488abb610f959e58ad49b1
  • site 0.048 seconds (+0.048); 12.25 MB (+12.250) - afterInitialise
  • site 0.067 seconds (+0.019); 13.50 MB (+1.250) - afterRoute
  • site 0.317 seconds (+0.250); 26.00 MB (+12.500) - afterDispatch
  • site 0.326 seconds (+0.009); 26.00 MB (0.000) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.328 seconds (+0.002); 26.00 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.328 seconds (+0.000); 26.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.345 seconds (+0.017); 26.50 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.351 seconds (+0.006); 26.75 MB (+0.250) - onAfterRender
  • site 0.357 seconds (+0.005); 26.75 MB (0.000) - sessionStore
27 MB

55 Queries Logged: 0.022709846496582 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '959353f55fbd637db1d7e72c034adf99'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '959353f55fbd637db1d7e72c034adf99'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '3a7cb1db21488abb610f959e58ad49b1'
  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` = '3a7cb1db21488abb610f959e58ad49b1'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('3a7cb1db21488abb610f959e58ad49b1','0','1590780005','10.111.11.10')
  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_tags'
  14. SELECT *
      FROM `jos_user_profile_fields`
      WHERE `jos_user_profile_fields`.`action_browse` IN ('1','1','4')
      AND `jos_user_profile_fields`.`type` != 'tags'
      ORDER BY `ordering` ASC
  15. SELECT COUNT(jos_users.id) AS count
      FROM `jos_users`
      WHERE `jos_users`.`block` = '0'
      AND `jos_users`.`activation` > '0'
      AND `jos_users`.`approved` > '0'
      AND `jos_users`.`access` IN ('1','1','4','0')
  16. SELECT jos_users.*
      FROM `jos_users`
      WHERE `jos_users`.`block` = '0'
      AND `jos_users`.`activation` > '0'
      AND `jos_users`.`approved` > '0'
      AND `jos_users`.`access` IN ('1','1','4','0')
      ORDER BY `surname` ASC
      LIMIT 20
  17. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`access` IN ('1','1','4','0')
      AND `jos_user_profiles`.`user_id` IN ('1067','2297','2909','2765','1648','2429','2415','2608','2285','2519','1533','2857','1590','2485','2280','2341','2300','2547','2406','2784')
  18. SELECT COUNT(jos_users.id) AS count
      FROM `jos_users`
      WHERE `jos_users`.`block` = '0'
      AND `jos_users`.`activation` > '0'
      AND `jos_users`.`approved` > '0'
  19. SELECT COUNT(jos_users.id) AS count
      FROM `jos_users`
      WHERE `jos_users`.`block` = '0'
      AND `jos_users`.`activation` > '0'
      AND `jos_users`.`approved` > '0'
      AND `jos_users`.`access` = '1'
  20. SELECT COUNT(jos_users.id) AS count
      FROM `jos_users`
      WHERE `jos_users`.`registerDate` > '2020-05-28 19:20:05'
  21. SELECT COUNT(jos_users.id) AS count
      FROM `jos_users`
      WHERE `jos_users`.`registerDate` > '2020-04-29 19:20:05'
  22. SELECT *
      FROM `jos_user_profile_options`
      WHERE `jos_user_profile_options`.`field_id` = '1'
  23. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_jobs'
  25. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  27. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  28. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1067';
  29. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2909';
  30. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2765';
  31. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1648';
  32. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2429';
  33. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2415';
  34. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2608';
  35. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2285';
  36. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1533';
  37. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2857';
  38. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1590';
  39. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2485';
  40. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2280';
  41. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2341';
  42. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2300';
  43. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2547';
  44. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2406';
  45. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2784';
  46. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  47. 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` <= '2020-05-29 19:20:06' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-05-29 19:20:06' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '83' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  48. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  49. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  50. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  51. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  52. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  53. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  54. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  55. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590780005;s:18:\"session.timer.last\";i:1590780005;s:17:\"session.timer.now\";i:1590780005;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:7:\"Members\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Profile\";O:8:\"stdClass\":1:{s:5:\"Field\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}}s:6:\"Member\";O:8:\"stdClass\":2:{s:5:\"start\";d:0;s:5:\"
      limit\";i:20;}}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:\"3a7cb1db21488abb610f959e58ad49b1\";s:12:\"tracker.ssid\";s:32:\"3a7cb1db21488abb610f959e58ad49b1\";s:12:\"tracker.rsid\";s:32:\"3a7cb1db21488abb610f959e58ad49b1\";}',`time` = '1590780006',`ip` = '10.111.11.10'
      WHERE `session_id` = '3a7cb1db21488abb610f959e58ad49b1'

18 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 18 × SELECT *
      FROM `jos_xprofiles`
  2. 16 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  3. 5 × SELECT COUNT(jos_users.id) AS count
      FROM `jos_users`
  4. 2 × SELECT data
      FROM `jos_session`
  5. 1 × SELECT jos_users.*
      FROM `jos_users`
  6. 1 × SELECT *
      FROM `jos_user_profile_options`
  7. 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
  8. 1 × SELECT *
      FROM `jos_user_profiles`
  9. 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
  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 session_id
      FROM `jos_session`
  12. 1 × SELECT *
      FROM `jos_viewlevels
  13. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  14. 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
  15. 1 × SELECT *
      FROM `jos_user_profile_fields`
OTHER Tables:
  1. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590780005;s:18:\"session.timer.last\";i:1590780005;s:17:\"session.timer.now\";i:1590780005;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:7:\"Members\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Profile\";O:8:\"stdClass\":1:{s:5:\"Field\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}}s:6:\"Member\";O:8:\"stdClass\":2:{s:5:\"start\";d:0;s:5:\"
      limit\";i:20;}}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:\"3a7cb1db21488abb610f959e58ad49b1\";s:12:\"tracker.ssid\";s:32:\"3a7cb1db21488abb610f959e58ad49b1\";s:12:\"tracker.rsid\";s:32:\"3a7cb1db21488abb610f959e58ad49b1\";}',`time` = '1590780006',`ip` = '10.111.11.10'
  2. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('3a7cb1db21488abb610f959e58ad49b1','0','1590780005','10.111.11.10'
  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 plgSystemPassword::onAfterRoute /core/plugins/system/password/password.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
  • 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