• Discoverability Visible
  • Join Policy Restricted
  • Created 07 Jul 2017

About the Group

Public Description

Motivation

Bridges across the U.S. continue to deteriorate at an alarming rate and the American Society of Civil Engineers estimate a cost of over $76 billion to improve the country’s functionally obsolete or structurally deficient bridges. This indicates a significant demand for innovative bridge health monitoring solutions that can strategically guide management, maintenance and replacement programs without risking public safety. Unfortunately, the need to improve how our bridges are managed and repaired or replaced faces similar issues and demands as the rest of the U.S. transportation network: continuously shrinking resources and governing bodies who do not have the necessary insights from bridge health data to find a workable solution.

Call to Action

To discuss how to address critical problems related to bridge health, researchers, practitioners, and individuals representing public and private sectors (transportation infrastructure and built environment owners, operators, designers and maintainers) convened with Big Data technology and analytics experts at the inaugural BRIDGE-ing Big Data Workshop hosted by the University of Nebraska in October 2015. During this workshop, it became clear that Big Data technology could assist with providing a timely solution. It also was apparent that past efforts focusing on utilizing bridge health monitoring and big data techniques as part of the management and maintenance/replacement processes are fragmented, and resulting datasets are not deemed trustworthy and are under-utilized.

Vision and Goals

Through our efforts we will:

  1. Catalog datasets including sources, copyrights, license, collection procedures, and expected access controls from private sector, academia, and government agencies
  2. Obtain commitments from stakeholders and host collaboration workshops with small working groups to discuss, import/export, and share bridge structural health monitoring data
  3. Solicit proposals from businesses/researchers to develop innovative applications that integrate disparate and voluminous data sources.

It is anticipated that this project’s findings will benefit the Midwest Big Data Hub transportation spoke and potentially inform similar activities for highways, buildings, power distribution networks and other civil infrastructure entities. Findings from this project will be promoted to national and international technical organizations, to directly impact workforce development, education and research programs. Combined, this project will make a direct impact on our country’s ability to efficiently maintain the health and safety of its bridges.

For more information:

https://bridgingbigdata.github.io


Debug Console

Close37 MBRequestSessionTimelineDatabase66Events49
$_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 => /groups/bridgingbigdata,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/groups/bridgingbigdata,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /groups/bridgingbigdata,
SCRIPT_URI => https://datacenterhub.org/groups/bridgingbigdata,
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:07:12 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 => 46625,
REDIRECT_URL => /groups/bridgingbigdata,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /groups/bridgingbigdata,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1590782465.8391,
REQUEST_TIME => 1590782465,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 885fa99b5f6795f03bcbbf9f48f28edc
tracker.ssid 885fa99b5f6795f03bcbbf9f48f28edc
tracker.rsid 885fa99b5f6795f03bcbbf9f48f28edc
  • site 0.046 seconds (+0.046); 12.25 MB (+12.250) - afterInitialise
  • site 0.066 seconds (+0.020); 13.50 MB (+1.250) - afterRoute
  • site 0.383 seconds (+0.317); 36.50 MB (+23.000) - afterDispatch
  • site 0.390 seconds (+0.007); 37.00 MB (+0.500) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.392 seconds (+0.002); 37.00 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.392 seconds (+0.000); 37.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.407 seconds (+0.015); 37.25 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.411 seconds (+0.004); 37.25 MB (0.000) - onAfterRender
  • site 0.414 seconds (+0.003); 37.25 MB (0.000) - sessionStore
37 MB

66 Queries Logged: 0.042764186859131 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '85b3b32ef764ff9992eec6da12ccaba6'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '85b3b32ef764ff9992eec6da12ccaba6'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '885fa99b5f6795f03bcbbf9f48f28edc'
  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` = '885fa99b5f6795f03bcbbf9f48f28edc'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('885fa99b5f6795f03bcbbf9f48f28edc','0','1590782465','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 extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  13. 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
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  15. DELETE
      FROM `jos_xgroups_pages_checkout`
      WHERE `userid`='0'
  16. SELECT *
      FROM `jos_xgroups`
      WHERE cn = 'bridgingbigdata';
  17. (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
      where gidNumber='1479') UNION (select uidNumber, 'applicants' AS role
      from jos_xgroups_applicants
      where gidNumber='1479') UNION (select uidNumber, 'members' AS role
      from jos_xgroups_members
      where gidNumber='1479') UNION (select uidNumber, 'managers' AS role
      from jos_xgroups_managers
      where gidNumber='1479')
  18. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  19. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  20. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages`
  21. SELECT *
      FROM jos_xgroups_pages
      WHERE gidNumber='1479'
      AND state IN (0,1)
      ORDER BY lft ASC
  22. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_versions`
  23. SELECT *
      FROM jos_xgroups_pages_versions
      WHERE pageid='239'
      ORDER BY version DESC
  24. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_hits`
  25. INSERT INTO `jos_xgroups_pages_hits` (`gidNumber`,`pageid`,`userid`,`date`,`ip`)
      VALUES ('1479','239','0','2020-05-29 20:01:06','10.111.11.10')
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  27. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  28. SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_categories`
  29. SELECT *
      FROM `jos_xgroups_description_fields`
      ORDER BY `ordering` ASC
  30. SELECT *
      FROM `jos_xgroups_description_answers`
      WHERE `jos_xgroups_description_answers`.`group_id` = '1479'
      AND `jos_xgroups_description_answers`.`field_id` IN ('116','117')
      ORDER BY `ordering` ASC
  31. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  32. SHOW FULL COLUMNS
      FROM `jos_collections`
  33. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      LEFT JOIN `jos_xgroups` AS g
      ON g.gidNumber=b.object_id
      AND b.object_type='
      group'
      WHERE b.state='1'
      AND b.access='0'
      AND b.object_id='1479'
      AND b.object_type='
      group'
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  35. SELECT COUNT(jos_wiki_pages.id) AS count
      FROM `jos_wiki_pages`
      WHERE `jos_wiki_pages`.`scope` = '
      group'
      AND `jos_wiki_pages`.`scope_id` = '1479'
      AND `jos_wiki_pages`.`state` = '1'
  36. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  37. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      WHERE `jos_resources`.`published` IN ('1')
      AND `jos_resources`.`group_owner` = 'bridgingbigdata'
      AND `jos_resources`.`access` IN ('0','1','2','3','4')
      AND (`jos_resources`.`publish_up` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_up` <= '2020-05-29 20:01:06' )
      AND (`jos_resources`.`publish_down` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_down` >= '2020-05-29 20:01:06' )
  38. SELECT jos_resources.*
      FROM `jos_resources`
      WHERE `jos_resources`.`published` IN ('1')
      AND `jos_resources`.`group_owner` = 'bridgingbigdata'
      AND `jos_resources`.`access` IN ('0','1','2','3','4')
      AND (`jos_resources`.`publish_up` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_up` IS NULL OR `jos_resources`.`publish_up` <= '2020-05-29 20:01:06' )
      AND (`jos_resources`.`publish_down` = '0000-00-00 00:00:00' OR `jos_resources`.`publish_down` IS NULL OR `jos_resources`.`publish_down` >= '2020-05-29 20:01:06' )
      GROUP BY jos_resources.id
      ORDER BY `rating` ASC
      LIMIT 15
  39. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  40. SELECT COUNT(jos_forum_posts.id) AS count
      FROM `jos_forum_posts`
      WHERE `jos_forum_posts`.`scope` = '
      group'
      AND `jos_forum_posts`.`scope_id` = '1479'
      AND `jos_forum_posts`.`state` = '1'
      AND `jos_forum_posts`.`parent` = '0'
  41. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  42. SELECT COUNT(jos_blog_entries.id) AS count
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = '
      group'
      AND `jos_blog_entries`.`scope_id` = '1479'
      AND `jos_blog_entries`.`state` IN ('1')
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` IS NULL OR `jos_blog_entries`.`publish_up` <= '2020-05-29 20:01:06' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2020-05-29 20:01:06' )
  43. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  44. SELECT *
      FROM `jos_wishlist`
      WHERE `jos_wishlist`.`referenceid` = '1479'
      AND `jos_wishlist`.`category` = '
      group'
  45. SELECT *
      FROM `jos_wishlist_ownergroups`
      WHERE `jos_wishlist_ownergroups`.`wishlist` = '250'
  46. SELECT *
      FROM `jos_wishlist_owners`
      WHERE `jos_wishlist_owners`.`wishlist` = '250'
      AND `jos_wishlist_owners`.`type` != '2'
  47. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  48. 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` = 'manage'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  49. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  50. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  51. SELECT COUNT(jos_wishlist_item.id) AS count
      FROM `jos_wishlist_item`
      WHERE `jos_wishlist_item`.`wishlist` = '250'
      AND `jos_wishlist_item`.`status` != '2'
      AND `jos_wishlist_item`.`private` = '0'
  52. SHOW FULL COLUMNS
      FROM `jos_projects`
  53. SELECT DISTINCT p.id
      FROM jos_project_owners as po, jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.created_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
      WHERE p.id=po.projectid
      AND p.state NOT IN (2, 3)
      AND po.status=1
      AND po.groupid=1479
  54. SELECT *
      FROM `jos_xgroups_memberoption`
      WHERE `jos_xgroups_memberoption`.`gidNumber` = '1479'
      AND `jos_xgroups_memberoption`.`userid` = '0'
      AND `jos_xgroups_memberoption`.`optionname` = 'receive-forum-email'
  55. SELECT COUNT(jos_announcements.id) AS count
      FROM `jos_announcements`
      WHERE `jos_announcements`.`scope` = '
      group'
      AND `jos_announcements`.`scope_id` = '1479'
      AND `jos_announcements`.`state` = '1'
      AND (`jos_announcements`.`publish_up` IS NULL OR `jos_announcements`.`publish_up` <= '2020-05-29 20:01:06' )
      AND (`jos_announcements`.`publish_down` IS NULL OR `jos_announcements`.`publish_down` >= '2020-05-29 20:01:06' )
  56. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = '
      group'
      AND `jos_activity_recipients`.`scope_id` = '1479'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  57. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  58. SELECT *
      FROM jos_xgroups_pages
      WHERE gidNumber='1479'
      AND state IN (1)
      ORDER BY lft ASC
  59. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'groups'
      AND `jos_tags_object`.`objectid` = '1479'
      GROUP BY jos_tags_object.label,jos_tags.id
  60. 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 20:01:06' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-05-29 20:01:06' )
      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
  61. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  62. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  63. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  64. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  65. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  66. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590782465;s:18:\"session.timer.last\";i:1590782465;s:17:\"session.timer.now\";i:1590782465;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":2:{s:6:\"Groups\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:3:\"Orm\";O:8:\"stdClass\":2:{s:5:\"Field\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Answer\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}}}}}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:\"885fa99b5f6795f03bcbbf9f48f28edc\";s:12:\"tracker.ssid\";s:32:\"885fa99b5f6795f03bcbbf9f48f28edc\";s:12:\"tracker.rsid\";s:32:\"885fa99b5f6795f03bcbbf9f48f28edc\";}',`time` = '1590782466',`ip` = '10.111.11.10'
      WHERE `session_id` = '885fa99b5f6795f03bcbbf9f48f28edc'

45 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 19 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 2 × SELECT *
      FROM `jos_assets`
  3. 2 × SELECT data
      FROM `jos_session`
  4. 2 × SELECT *
      FROM jos_xgroups_pages
  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 a.rules
      FROM `jos_assets` AS `a`
  7. 1 × SELECT *
      FROM `jos_wishlist`
  8. 1 × SELECT COUNT(jos_blog_entries.id) AS count
      FROM `jos_blog_entries`
  9. 1 × SELECT *
      FROM `jos_wishlist_ownergroups`
  10. 1 × SELECT *
      FROM `jos_wishlist_owners`
  11. 1 × SELECT COUNT(jos_wishlist_item.id) AS count
      FROM `jos_wishlist_item`
  12. 1 × SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
  13. 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
  14. 1 × SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
  15. 1 × SELECT COUNT(jos_announcements.id) AS count
      FROM `jos_announcements`
  16. 1 × SELECT DISTINCT p.id
      FROM jos_project_owners as po, jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.created_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
  17. 1 × SELECT *
      FROM `jos_xgroups_memberoption`
  18. 1 × SELECT COUNT(jos_forum_posts.id) AS count
      FROM `jos_forum_posts`
  19. 1 × SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
  20. 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
  21. 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
  22. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  23. 1 × SELECT *
      FROM `jos_viewlevels
  24. 1 × SELECT session_id
      FROM `jos_session`
  25. 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
  26. 1 × SELECT *
      FROM `jos_xgroups`
  27. 1 × SELECT *
      FROM jos_xgroups_pages_versions
  28. 1 × SELECT COUNT(jos_wiki_pages.id) AS count
      FROM `jos_wiki_pages`
  29. 1 × SELECT *
      FROM `jos_resource_types`
  30. 1 × SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      LEFT JOIN `jos_xgroups` AS g
      ON g.gidNumber=b.object_id
      AND b.object_type='
      group'
  31. 1 × SELECT *
      FROM `jos_xgroups_description_answers`
  32. 1 × SELECT *
      FROM `jos_xgroups_description_fields`
  33. 1 × SELECT jos_resources.*
      FROM `jos_resources`
OTHER Tables:
  1. 1 × SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_categories
  2. 1 × INSERT INTO `jos_xgroups_pages_hits` (`gidNumber`,`pageid`,`userid`,`date`,`ip`)
      VALUES ('1479','239','0','2020-05-29 20:01:06','10.111.11.10'
  3. 1 × SHOW FULL COLUMNS
      FROM `jos_collections
  4. 1 × SHOW FULL COLUMNS
      FROM `jos_projects
  5. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590782465;s:18:\"session.timer.last\";i:1590782465;s:17:\"session.timer.now\";i:1590782465;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":2:{s:6:\"Groups\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:3:\"Orm\";O:8:\"stdClass\":2:{s:5:\"Field\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Answer\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}}}}}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:\"885fa99b5f6795f03bcbbf9f48f28edc\";s:12:\"tracker.ssid\";s:32:\"885fa99b5f6795f03bcbbf9f48f28edc\";s:12:\"tracker.rsid\";s:32:\"885fa99b5f6795f03bcbbf9f48f28edc\";}',`time` = '1590782466',`ip` = '10.111.11.10'
  6. 1 × SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_hits
  7. 1 × SHOW FULL COLUMNS
      FROM `jos_xgroups_pages_versions
  8. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('885fa99b5f6795f03bcbbf9f48f28edc','0','1590782465','10.111.11.10'
  9. 1 × DELETE
      FROM `jos_xgroups_pages_checkout`
  10. 1 × (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
  11. 1 × SHOW FULL COLUMNS
      FROM `jos_xgroups_pages
  12. 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
  • onGroupAreas Method plgGroupsCollections::onGroupAreas /core/plugins/groups/collections/collections.php:127
  • onGroupAreas Method plgGroupsMembers::onGroupAreas /core/plugins/groups/members/members.php:59
  • onGroupAreas Method plgGroupsWiki::onGroupAreas /core/plugins/groups/wiki/wiki.php:55
  • onGroupAreas Method plgGroupsMessages::onGroupAreas /core/plugins/groups/messages/messages.php:55
  • onGroupAreas Method plgGroupsResources::onGroupAreas /core/plugins/groups/resources/resources.php:78
  • onGroupAreas Method plgGroupsForum::onGroupAreas /core/plugins/groups/forum/forum.php:61
  • onGroupAreas Method plgGroupsBlog::onGroupAreas /core/plugins/groups/blog/blog.php:55
  • onGroupAreas Method plgGroupsWishlist::onGroupAreas /core/plugins/groups/wishlist/wishlist.php:55
  • onGroupAreas Method plgGroupsProjects::onGroupAreas /core/plugins/groups/projects/projects.php:68
  • onGroupAreas Method plgGroupsMemberOptions::onGroupAreas /core/plugins/groups/memberoptions/memberoptions.php:28
  • onGroupAreas Method plgGroupsAnnouncements::onGroupAreas /core/plugins/groups/announcements/announcements.php:55
  • onGroupAreas Method plgGroupsFiles::onGroupAreas /core/plugins/groups/files/files.php:55
  • onGroupAreas Method plgGroupsActivity::onGroupAreas /core/plugins/groups/activity/activity.php:28
  • onContentSave Method plgSystemContent::onContentSave /core/plugins/system/content/content.php:23
  • 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 plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:41
  • onGroup Method plgGroupsCollections::onGroup /core/plugins/groups/collections/collections.php:152
  • onGroup Method plgGroupsMembers::onGroup /core/plugins/groups/members/members.php:84
  • onGroup Method plgGroupsWiki::onGroup /core/plugins/groups/wiki/wiki.php:80
  • onGroup Method plgGroupsMessages::onGroup /core/plugins/groups/messages/messages.php:80
  • onGroup Method plgGroupsResources::onGroup /core/plugins/groups/resources/resources.php:103
  • onGroup Method plgGroupsForum::onGroup /core/plugins/groups/forum/forum.php:86
  • onGroup Method plgGroupsBlog::onGroup /core/plugins/groups/blog/blog.php:80
  • onGroup Method plgGroupsWishlist::onGroup /core/plugins/groups/wishlist/wishlist.php:81
  • onGroup Method plgGroupsProjects::onGroup /core/plugins/groups/projects/projects.php:93
  • onGroup Method plgGroupsMemberOptions::onGroup /core/plugins/groups/memberoptions/memberoptions.php:54
  • onGroup Method plgGroupsAnnouncements::onGroup /core/plugins/groups/announcements/announcements.php:131
  • onGroup Method plgGroupsFiles::onGroup /core/plugins/groups/files/files.php:80
  • onGroup Method plgGroupsActivity::onGroup /core/plugins/groups/activity/activity.php:53
  • onBeforeGroup Method plgGroupsAnnouncements::onBeforeGroup /core/plugins/groups/announcements/announcements.php:74
  • 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