GLORIA

The GLORIA model (Global Resource Input-Output Assessment) is a multi-regional input-output database that was built by the University of Sydney using the IELab infrastructure for the UN International Resource Panel (UN IRP) in the context of the update of the material footprint accounts forming part of the UN IRP Material Flows Database. To use synergies between different UNEP initiatives it was decided to use GLORIA also as underlying MRIO model for the Sustainable Consumption and Production Hotspots Analysis Tool (SCP-HAT). The technical documentation outlines the construction approach for the MRIO table, lists the source data sets that were used, the quality checks that were performed, and holds additional, method- and data-specific information about the construction process.

The GLORIA MRIO database now includes not only the material footprint, but a wide range of other environmental, economic and social indicators. All data are available for download here.

Debug Console

Close16 MBRequestSessionTimelineDatabase35Events25
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( USER => apache, HOME => /usr/share/httpd, FCGI_ROLE => RESPONDER, REDIRECT_HTTP_AU... Array(
USER => apache,
HOME => /usr/share/httpd,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_UNIQUE_ID => ZRisYhandF82oxeeL-Z38QAAAAw,
REDIRECT_SCRIPT_URL => /analyse/GLORIA,
REDIRECT_SCRIPT_URI => https://ielab.info/analyse/GLORIA,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
UNIQUE_ID => ZRisYhandF82oxeeL-Z38QAAAAw,
SCRIPT_URL => /analyse/GLORIA,
SCRIPT_URI => https://ielab.info/analyse/GLORIA,
HTTPS => on,
HTTP_X_FORWARDED_FOR => 34.239.148.127,
HTTP_X_FORWARDED_PROTO => https,
HTTP_X_FORWARDED_PORT => 443,
HTTP_HOST => ielab.info,
HTTP_X_AMZN_TRACE_ID => Root=1-6518ac62-74734ef64ed89e6748d7bd46,
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 => Wed, 22 Mar 2023 03:28:51 GMT,
HTTP_ACCEPT_ENCODING => br,gzip,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_python/3.5.0- Python/2.7.5,
SERVER_NAME => ielab.info,
SERVER_ADDR => 10.84.154.253,
SERVER_PORT => 443,
REMOTE_ADDR => 10.84.154.140,
DOCUMENT_ROOT => /var/www/ielab,
REQUEST_SCHEME => https,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/ielab,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/ielab/index.php,
REMOTE_PORT => 56796,
REDIRECT_URL => /analyse/GLORIA,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /analyse/GLORIA,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1696115810.6168,
REQUEST_TIME => 1696115810
)
session.client.forwarded 34.239.148.127
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 8d20817c58ecfa40ea689ef02339987a
tracker.ssid 8d20817c58ecfa40ea689ef02339987a
tracker.rsid 8d20817c58ecfa40ea689ef02339987a
  • site 0.068 seconds (+0.068); 9.50 MB (+9.500) - afterInitialise
  • site 0.097 seconds (+0.030); 11.50 MB (+2.000) - afterRoute
  • site 0.137 seconds (+0.039); 14.75 MB (+3.250) - afterDispatch
  • site 0.146 seconds (+0.010); 15.00 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.148 seconds (+0.001); 15.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.148 seconds (+0.000); 15.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.149 seconds (+0.001); 15.25 MB (+0.250) - afterRenderModule mod_collect (Collect)
  • site 0.149 seconds (+0.000); 15.25 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.151 seconds (+0.002); 15.25 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.151 seconds (+0.000); 15.25 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.174 seconds (+0.022); 15.75 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.174 seconds (+0.000); 15.75 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.175 seconds (+0.001); 15.75 MB (0.000) - afterRenderModule mod_search (Search)
  • site 0.175 seconds (+0.000); 15.75 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.177 seconds (+0.002); 15.75 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.179 seconds (+0.002); 15.75 MB (0.000) - onAfterRender
  • site 0.180 seconds (+0.001); 15.75 MB (0.000) - sessionStore
16 MB

35 Queries Logged: 0.014937400817871 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '37e9d90f0f2941018ecc69b068138cc9'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '37e9d90f0f2941018ecc69b068138cc9'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '8d20817c58ecfa40ea689ef02339987a'
  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` = '8d20817c58ecfa40ea689ef02339987a'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('8d20817c58ecfa40ea689ef02339987a','0','1696115810','10.84.154.140')
  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` = '42'
      AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= '2023-09-30 23:16:50' )
      AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= '2023-09-30 23:16:50' )
      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` = '28'
      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_search'
  20. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  21. 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` <= '2023-09-30 23:16:50' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2023-09-30 23:16:50' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '165' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  22. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  23. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  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_answers'
  27. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  28. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  29. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  30. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  31. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  32. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  33. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  35. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1696115810;s:18:\"session.timer.last\";i:1696115810;s:17:\"session.timer.now\";i:1696115810;s:24:\"session.client.forwarded\";s:14:\"34.239.148.127\";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:\"8d20817c58ecfa40ea689ef02339987a\";s:12:\"tracker.ssid\";s:32:\"8d20817c58ecfa40ea689ef02339987a\";s:12:\"tracker.rsid\";s:32:\"8d20817c58ecfa40ea689ef02339987a\";}',`time` = '1696115810',`ip` = '10.84.154.140'
      WHERE `session_id` = '8d20817c58ecfa40ea689ef02339987a'
  • 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