Publications: All

Search

No results found

Debug Console

Close16 MBRequestSessionTimelineDatabase40Events18
$_GET
Array( tag => testing,policyanalysis,bookch ) Array(
tag => testing,policyanalysis,bookch
)
$_POST
Array( ) Array(

)
$_COOKIE
Array( 8512ae7d57b1396273f76fe6ed341a23 => en-GB, 81f30cf708470b974874c8a96a6bcdb2 => 0f01b1e... Array(
8512ae7d57b1396273f76fe6ed341a23 => en-GB,
81f30cf708470b974874c8a96a6bcdb2 => 0f01b1eb9e5f15347e1447fbdd685451,
d482552ea4a74f85af0bb3d73890dabc => 5 E 45E43105E E 2444543 7406F5D 11B 37E B4A 3 05F41134B514059 4 951135F765817 3 B5C1243 B5612 F16 3 B 2 A1B 95E5552 4 95150 E 05152 051 B57535C 952 4 7 450545053 1 D 4 5 81B 3165952 2164044 C 016 A17 25056 31A5656 05350 151 7 05D 556 8 C B5154 3 9 0 6 0 3 6505552 05650 C 944 B4358 6 A16164A515412 24A 256515C1A 454 754 6 554 6 1 6515F 953 3 45557 1 051 E5E52545D F 0505753 916 94A,
cookie => 43a25f71035b89b5
)
$_SERVER
Array( REDIRECT_HTTPS => on, REDIRECT_SCRIPT_URL => /en/publications/browse, REDIRECT_SCRIP... Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /en/publications/browse,
REDIRECT_SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/publications/browse,
REDIRECT_STATUS => 200,
HTTPS => on,
SCRIPT_URL => /en/publications/browse,
SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/publications/browse,
HTTP_HOST => hsscommons.rs-dev.uvic.ca,
HTTP_USER_AGENT => Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com),
HTTP_ACCEPT => */*,
HTTP_ACCEPT_ENCODING => gzip, br, zstd, deflate,
HTTP_COOKIE => 8512ae7d57b1396273f76fe6ed341a23=en-GB; 81f30cf708470b974874c8a96a6bcdb2=0f01b1eb9e5f15347e1447fbdd685451; d482552ea4a74f85af0bb3d73890dabc=%205%20E%2045E43105E%20E%202444543%207406F5D%2011B%2037E%20B4A%203%2005F41134B514059%204%20951135F765817%203%20B5C1243%20B5612%20F16%203%20B%202%20A1B%2095E5552%204%2095150%20E%2005152%20051%20B57535C%20952%204%207%20450545053%201%20D%204%205%2081B%203165952%202164044%20C%20016%20A17%2025056%2031A5656%2005350%20151%207%2005D%20556%208%20C%20B5154%203%209%200%206%200%203%206505552%2005650%20C%20944%20B4358%206%20A16164A515412%2024A%20256515C1A%20454%20754%206%20554%206%201%206515F%20953%203%2045557%201%20051%20E5E52545D%20F%200505753%20916%2094A; cookie=43a25f71035b89b5,
HTTP_X_FORWARDED_FOR => 3.139.83.202,
HTTP_X_FORWARDED_HOST => hsscommons.rs-dev.uvic.ca,
HTTP_X_FORWARDED_PORT => 443,
HTTP_X_FORWARDED_PROTO => https,
HTTP_X_FORWARDED_SERVER => traefik-b8d8564f8-2whv9,
HTTP_X_REAL_IP => 3.139.83.202,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.4.62 (Debian),
SERVER_NAME => hsscommons.rs-dev.uvic.ca,
SERVER_ADDR => 10.233.98.122,
SERVER_PORT => 80,
REMOTE_ADDR => 10.233.94.22,
DOCUMENT_ROOT => /var/www/html,
REQUEST_SCHEME => http,
CONTEXT_PREFIX => ,
CONTEXT_DOCUMENT_ROOT => /var/www/html,
SERVER_ADMIN => webmaster@localhost,
SCRIPT_FILENAME => /var/www/html/index.php,
REMOTE_PORT => 58596,
REDIRECT_URL => /en/publications/browse,
REDIRECT_QUERY_STRING => tag=testing%2Cpolicyanalysis%2Cbookch,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => tag=testing%2Cpolicyanalysis%2Cbookch,
REQUEST_URI => /en/publications/browse?tag=testing%2Cpolicyanalysis%2Cbookch,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1745152136.6514,
REQUEST_TIME => 1745152136
)
session.client.forwarded 3.139.83.202
separator .
orderBy id
orderDir asc
always
0 registerDate
1 registerIP
2 access
renew
tracker.sid 0f01b1eb9e5f15347e1447fbdd685451
tracker.ssid 0f01b1eb9e5f15347e1447fbdd685451
tracker.rsid 0f01b1eb9e5f15347e1447fbdd685451
session.token 341f261c9624f25b838bfab2d9c43ad8
  • site 0.077 seconds (+0.077); 16.00 MB (+16.000) - afterInitialise
  • site 0.113 seconds (+0.036); 16.00 MB (0.000) - afterRoute
  • site 0.871 seconds (+0.759); 16.00 MB (0.000) - afterDispatch
  • site 0.914 seconds (+0.042); 16.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.939 seconds (+0.026); 16.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.941 seconds (+0.002); 16.00 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics)
  • site 0.941 seconds (+0.000); 16.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics)
  • site 0.941 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.941 seconds (+0.000); 16.00 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.942 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_wrapper (Wrapper)
  • site 0.942 seconds (+0.000); 16.00 MB (0.000) - afterRenderModule mod_wrapper (Wrapper)
  • site 0.942 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.942 seconds (+0.001); 16.00 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.942 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.943 seconds (+0.000); 16.00 MB (0.000) - afterRenderModule mod_collect (Collect)
  • site 0.943 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.992 seconds (+0.049); 16.00 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.992 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_languages (Language Switcher)
  • site 0.993 seconds (+0.001); 16.00 MB (0.000) - afterRenderModule mod_languages (Language Switcher)
  • site 0.994 seconds (+0.001); 16.00 MB (0.000) - onAfterRender
  • site 1.014 seconds (+0.021); 16.00 MB (0.000) - sessionStore
16 MB

40 Queries Logged: 0.87343192100525 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '0f01b1eb9e5f15347e1447fbdd685451'
  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, b.title
      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` >= ''
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  7. SELECT *
      FROM `jos_languages`
      WHERE `published` = '1'
      ORDER BY `ordering` ASC
  8. SELECT language,id
      FROM `jos_menu`
      WHERE `home` = '1'
      AND `published` = '1'
      AND `client_id` = ''
  9. 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` > ''
      AND `m`.`client_id` = ''
      ORDER BY `m`.`lft` ASC
  10. SELECT con.`id`
      FROM `jos_content` AS con
      LEFT JOIN `jos_categories` AS cat
      ON con.catid = cat.id
      WHERE con.state=1
      AND con.`alias` = 'browse'
      AND cat.`path` = 'publications'
  11. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  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` = ''
      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 extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  15. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  16. SELECT *
      FROM jos_publication_categories as C
      WHERE C.state=1
      ORDER BY C.name ASC
  17. SHOW FULL COLUMNS
      FROM `jos_publication_versions`
  18. SHOW FULL COLUMNS
      FROM `jos_publications`
  19. SHOW FULL COLUMNS
      FROM `jos_publication_master_types`
  20. SHOW FULL COLUMNS
      FROM `jos_publication_categories`
  21. SHOW FULL COLUMNS
      FROM `jos_publications`
  22. SELECT C.id , TA.tag, COUNT(DISTINCT TA.tag) AS uniques
      FROM jos_publication_versions V
      LEFT JOIN jos_publications C
      ON V.publication_id = C.id
      LEFT JOIN jos_projects PP
      ON PP.id = C.project_id
      LEFT JOIN jos_publication_master_types MT
      ON MT.id = C.master_type
      LEFT JOIN jos_publication_categories AS t
      ON t.id = C.category
      LEFT JOIN jos_tags_object RTA
      ON RTA.objectid = V.id
      LEFT JOIN jos_tags TA
      ON RTA.tagid = TA.id
      WHERE 1
      AND V.version_number = (SELECT MAX(version_number)
      FROM jos_publication_versions
      WHERE publication_id=C.id
      AND state=1 )
      AND (V.state=1)
      AND (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2025-04-20 12:28:56')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-20 12:28:56')
      AND V.state != 2
      AND (V.access != 2)
      AND RTA.tbl='publications'
      AND TA.tag IN ('testing','policyanalysis','bookch')
      GROUP BY C.id
      HAVING uniques=3
  23. SELECT V.*, C.id as id, C.category, C.project_id, C.access as master_access, C.checked_out, C.checked_out_time, C.rating as master_rating, C.group_owner, C.master_type, C.master_doi, C.ranking as master_ranking, C.times_rated as master_times_rated, C.alias, V.id as version_id, t.name AS cat_name, t.alias as cat_alias, t.url_alias as cat_url, PP.alias as project_alias, PP.title as project_title, PP.state as project_status, PP.private as project_private, PP.provisioned as project_provisioned, MT.alias as base, MT.params as type_params, (SELECT vv.version_label
      FROM `jos_publication_versions` as vv
      WHERE vv.publication_id=C.id
      AND vv.state=3
      ORDER BY ID DESC
      LIMIT 1) AS dev_version_label , (SELECT COUNT(*)
      FROM `jos_publication_versions`
      WHERE publication_id=C.id
      AND state!=3) AS versions , TA.tag, COUNT(DISTINCT TA.tag) AS uniques
      FROM jos_publication_versions V
      LEFT JOIN jos_publications C
      ON V.publication_id = C.id
      LEFT JOIN jos_projects PP
      ON PP.id = C.project_id
      LEFT JOIN jos_publication_master_types MT
      ON MT.id = C.master_type
      LEFT JOIN jos_publication_categories AS t
      ON t.id = C.category
      LEFT JOIN jos_tags_object RTA
      ON RTA.objectid = V.id
      LEFT JOIN jos_tags TA
      ON RTA.tagid = TA.id
      WHERE 1
      AND V.version_number = (SELECT MAX(version_number)
      FROM jos_publication_versions
      WHERE publication_id=C.id
      AND state=1 )
      AND (V.state=1)
      AND (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2025-04-20 12:28:56')
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2025-04-20 12:28:56')
      AND V.state != 2
      AND (V.access != 2)
      AND RTA.tbl='publications'
      AND TA.tag IN ('testing','policyanalysis','bookch')
      GROUP BY C.id
      HAVING uniques=3
      ORDER BY V.published_up DESC
      LIMIT 0, 20
  24. SELECT t.tag, t.raw_tag, t.admin, tj.tagid, tj.objectid, COUNT(tj.tagid) AS tcount
      FROM jos_tags AS t JOIN jos_tags_object AS tj
      ON t.id=tj.tagid
      LEFT JOIN jos_publication_versions AS V
      ON V.id=tj.objectid
      AND tj.tbl='publications'
      WHERE t.id=tj.tagid
      AND t.admin=0
      AND tj.tbl='publications'
      AND V.state=1
      AND V.main=1
      AND V.access!=4
      AND V.published_up < '2025-04-20 12:28:57'
      AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down > '2025-04-20 12:28:57')
      GROUP BY tj.tagid
      ORDER BY tcount DESC
      LIMIT 20
  25. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  27. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_register'
  28. 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-04-20 12:28:57' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2025-04-20 12:28:57' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = ''
      AND (`mm`.`menuid` = '' OR `mm`.`menuid` <= '' )
      AND `m`.`language` IN ('en-GB','*')
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  29. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_menus'
  30. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  31. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  32. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  33. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_events'
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  35. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  36. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  37. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  38. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  39. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  40. UPDATE `jos_session`
      SET `data` = '__default|a:11:{s:15:\"session.counter\";i:62;s:19:\"session.timer.start\";i:1745152090;s:18:\"session.timer.last\";i:1745152135;s:17:\"session.timer.now\";i:1745152136;s:24:\"session.client.forwarded\";s:12:\"3.139.83.202\";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\":2:{s:5:\"Field\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Option\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}}}s:4:\"Post\";O:8:\"stdClass\":2:{s:5:\"start\";d:0;s:5:\"
      limit\";i:20;}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:17:\"Hubzero\\User\\User\":1:{s:5:\"guest\";b:1;}s:11:\"tracker.sid\";s:32:\"0f01b1eb9e5f15347e1447fbdd685451\";s:12:\"tracker.ssid\";s:32:\"0f01b1eb9e5f15347e1447fbdd685451\";s:12:\"tracker.rsid\";s:32:\"0f01b1eb9e5f15347e1447fbdd685451\";s:13:\"session.token\";s:32:\"341f261c9624f25b838bfab2d9c43ad8\";}',`time` = '1745152137',`ip` = '10.233.94.22'
      WHERE `session_id` = '0f01b1eb9e5f15347e1447fbdd685451'
  • onAfterInitialise Method plgSystemLanguageFilter::onAfterInitialise /app/plugins/system/languagefilter/languagefilter.php:186
  • 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 /app/plugins/system/password/password.php:21
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:22
  • onAfterDispatch Method plgSystemLanguageFilter::onAfterDispatch /app/plugins/system/languagefilter/languagefilter.php:554
  • 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