- $_GET
-
Array(
)
Array(
)
- $_POST
-
Array(
)
Array(
)
- $_COOKIE
-
Array(
)
Array(
)
- $_SERVER
-
Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /en/publications/2414/usage/1,
REDIRECT...
Array(
REDIRECT_HTTPS => on,
REDIRECT_SCRIPT_URL => /en/publications/2414/usage/1,
REDIRECT_SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/publications/2414/usage/1,
REDIRECT_STATUS => 200,
HTTPS => on,
SCRIPT_URL => /en/publications/2414/usage/1,
SCRIPT_URI => http://hsscommons.rs-dev.uvic.ca/en/publications/2414/usage/1,
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_X_FORWARDED_FOR => 18.116.52.101,
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 => 18.116.52.101,
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 => 41300,
REDIRECT_URL => /en/publications/2414/usage/1,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING =>
REQUEST_URI => /en/publications/2414/usage/1,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1745208251.8122,
REQUEST_TIME => 1745208251
)
session.client.forwarded ⇒ 18.116.52.101
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
always ⇒
0 ⇒ registerDate
1 ⇒ registerIP
2 ⇒ access
renew ⇒
tracker.sid ⇒ d8123c2d135632d038fabe08b525a896
tracker.ssid ⇒ d8123c2d135632d038fabe08b525a896
tracker.rsid ⇒ d8123c2d135632d038fabe08b525a896
20 MB
79 Queries Logged: 1.0934855937958 seconds
SELECT data
FROM `jos_session`
WHERE `session_id` = 'e9a02b58f3368dce65ed73c79b689652'DELETE
FROM `jos_session`
WHERE `session_id` = 'e9a02b58f3368dce65ed73c79b689652'SELECT data
FROM `jos_session`
WHERE `session_id` = 'd8123c2d135632d038fabe08b525a896'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_languages'SELECT session_id
FROM `jos_session`
WHERE `session_id` = 'd8123c2d135632d038fabe08b525a896'
LIMIT 1INSERT INTO `jos_session`
(`session_id`,`client_id`,`time`,`ip`)
VALUES ('d8123c2d135632d038fabe08b525a896','','1745208251','10.233.94.22')SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_members'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'SELECT *
FROM `jos_viewlevels`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` ASCSELECT *
FROM `jos_languages`
WHERE `published` = '1'
ORDER BY `ordering` ASCSELECT language,id
FROM `jos_menu`
WHERE `home` = '1'
AND `published` = '1'
AND `client_id` = ''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` ASCSELECT 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` = '1'
AND cat.`path` = 'publications/2414/usage'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_publications'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` DESCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_tags'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_projects'SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SELECT *
FROM jos_publications
WHERE id='2414'SELECT *
FROM jos_publication_versions
WHERE publication_id='2414'
AND version_number='1'
LIMIT 1SHOW FULL COLUMNS
FROM `jos_publication_master_types`SELECT *
FROM `jos_publication_master_types`
WHERE `id` = '1'SHOW FULL COLUMNS
FROM `jos_publication_categories`SELECT *
FROM `jos_publication_categories`
WHERE `id` = '14'SELECT *
FROM jos_publication_versions
WHERE publication_id='2414'
AND state = 1
ORDER BY version_number DESC
LIMIT 1 SHOW FULL COLUMNS
FROM `jos_projects`SELECT *
FROM jos_projects
WHERE id='129'
LIMIT 1SHOW FULL COLUMNS
FROM `jos_publication_attachments`SELECT a.*
FROM jos_publication_attachments AS a
WHERE a.publication_version_id='2441'
ORDER BY a.ordering ASCSHOW FULL COLUMNS
FROM `jos_publication_blocks`SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_citations'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_resources'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_answers'SELECT jos_answers_questions.*
FROM `jos_answers_questions`
INNER JOIN jos_tags_object
ON jos_tags_object.objectid = jos_answers_questions.id
INNER JOIN jos_tags
ON jos_tags.id = jos_tags_object.tagid
WHERE `jos_tags_object`.`tbl` = 'answers'
AND `jos_tags`.`tag` IN ('publication2414')
AND `jos_answers_questions`.`state` < '2'SHOW FULL COLUMNS
FROM `jos_publication_ratings`SELECT COUNT(rr.id)
FROM `jos_publication_ratings` AS rr
WHERE rr.state IN (1, 3)
AND rr.publication_id='2414'
ORDER BY rr.created DESCSHOW TABLESSHOW FULL COLUMNS
FROM `jos_publication_stats`SELECT *
FROM jos_publication_stats
WHERE period ='14'
AND publication_id ='2414'
AND datetime='2025-04-00 00:00:00'
ORDER BY datetime DESC
LIMIT 1SELECT *
FROM `jos_publication_logs`
WHERE `publication_id`='2414'
AND `publication_version_id`='2441'
ORDER BY `year` ASC, `month` ASCSELECT SUM(page_views)
FROM `jos_publication_logs`
WHERE `publication_id`='2414'
AND `publication_version_id`='2441'
ORDER BY `year` ASC, `month` ASCSELECT SUM(primary_accesses)
FROM `jos_publication_logs`
WHERE `publication_id`='2414'
AND `publication_version_id`='2441'
ORDER BY `year` ASC, `month` ASCSHOW FULL COLUMNS
FROM `jos_publication_authors`SELECT A.*, PO.invited_name, PO.invited_email
FROM jos_publication_authors as A JOIN jos_project_owners as PO
ON PO.id=A.project_owner_id
WHERE A.publication_version_id='2441'
AND A.status=1
AND (A.role != 'submitter' || A.role IS NULL)
ORDER BY A.ordering ASC SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = ''SELECT *
FROM `jos_user_profiles`
WHERE `jos_user_profiles`.`user_id` = NULLSELECT *
FROM jos_publication_authors
WHERE role='submitter'
AND publication_version_id='2441'
LIMIT 1SELECT A.id as owner_id, x.uidNumber as user_id, COALESCE(A.name , x.name) as name, x.username, x.orcid, COALESCE(A.organization , x.organization) as organization
FROM jos_xprofiles as x
LEFT JOIN jos_publication_authors as A
ON x.uidNumber=A.user_id
AND A.publication_version_id='2441'
AND A.status=1
AND A.role = 'submitter'
WHERE (x.uidNumber='1030')
LIMIT 1 SHOW FULL COLUMNS
FROM `jos_publication_licenses`SELECT *
FROM jos_publication_licenses
WHERE id='5'
LIMIT 1SELECT *
FROM `jos_publication_attachments`
WHERE `publication_id` = '2414'
AND `role` = '1'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` = 'publications'
AND `jos_tags_object`.`objectid` = '2441'
GROUP BY jos_tags_object.label,jos_tags.idSELECT COUNT(*)
FROM jos_publication_attachments AS a
where a.publication_version_id = '2441'SHOW FULL COLUMNS
FROM `jos_publication_blocks`SELECT COUNT(*)
FROM jos_tags_object AS ta, jos_tags AS t
WHERE ta.tagid=t.id
AND t.tag=''
AND ta.tbl='publications'
AND ta.objectid=2414SELECT jos_publications.*,(10*titleScore + 5*contentScore+2*tagScore)/(10+5+2) AS rec_score
FROM `jos_recommendation`
INNER JOIN jos_publications
ON jos_publications.id = jos_recommendation.fromID
WHERE `jos_recommendation`.`fromID` = '2414'
HAVING rec_score > '0.21'
ORDER BY `rec_score` DESC
LIMIT 10SHOW FULL COLUMNS
FROM `jos_publication_versions`SHOW FULL COLUMNS
FROM `jos_publications`SELECT k.*
FROM ((SELECT v.id, v.page_id AS pageid, MAX(v.version) AS version, w.title, w.pagename AS alias, v.pagetext AS abstract,
NULL AS category, NULL AS published, NULL AS publish_up, w.scope, w.rating, w.times_rated, w.ranking, 'wiki' AS class, 'Topic' AS section
FROM `jos_wiki_pages` AS w
INNER JOIN `jos_wiki_versions` AS v
ON w.id=v.page_id
INNER JOIN `jos_wiki_links` AS wl
ON wl.page_id=w.id
WHERE v.approved=1
AND wl.scope='publication'
AND wl.scope_id='2414'
AND w.access!=1
GROUP BY pageid, v.id
ORDER BY ranking DESC, title
LIMIT 10) UNION (SELECT DISTINCT r.publication_id as id, NULL AS pageid, r.id AS version,
r.title, C.alias, r.abstract, C.category, r.state as published,
r.published_up, NULL AS scope, C.rating, C.times_rated, C.ranking,
rt.alias AS class, rt.name AS section
FROM `jos_publications` as C, `jos_publication_categories` AS rt, `jos_publication_versions` AS r
INNER JOIN `jos_tags_object` AS a
ON r.publication_id=a.objectid
AND a.tbl='publications'
INNER JOIN `jos_publication_authors` AS PA
ON PA.publication_version_id=r.id
WHERE C.id=r.publication_id
AND (a.tagid IN (0,'367','389','390') OR PA.user_id IN (''))
AND r.publication_id !=2414
AND C.category = rt.id
AND C.category!=8
AND r.access=0
AND r.state=1
GROUP BY r.publication_id, r.id
ORDER BY r.ranking
LIMIT 10) UNION (SELECT DISTINCT r.publication_id as id, NULL AS pageid, r.id AS version,
r.title, C.alias, r.abstract, C.category, r.state as published,
r.published_up, NULL AS scope, C.rating, C.times_rated, C.ranking,
rt.alias AS class, rt.name AS section
FROM `jos_publications` AS C
INNER JOIN `jos_publication_categories` AS rt
ON rt.id = C.category
INNER JOIN `jos_publication_versions` AS r
ON r.publication_id = C.id
INNER JOIN `jos_publication_attachments` AS a
ON a.publication_id = C.id
WHERE r.publication_id !=2414
AND C.category!=8
AND r.access=0
AND r.state=1
AND a.object_name='publication'
AND a.object_id=2414
GROUP BY r.publication_id, r.id
ORDER BY r.ranking
LIMIT 10)) AS k
ORDER BY ranking DESC
LIMIT 10SELECT COUNT(jos_item_watch.id) AS count
FROM `jos_item_watch`
WHERE `jos_item_watch`.`item_id` = '2414'
AND `jos_item_watch`.`item_type` = 'publication'SHOW FULL COLUMNS
FROM `jos_publication_versions`SELECT *
FROM jos_publication_versions
WHERE publication_id='2414'
AND state = 1
ORDER BY version_number DESC
LIMIT 1 SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_search'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_users'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_register'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-21 04:04:13'
)
AND (`m`.`publish_down` IS NULL
OR `m`.`publish_down` >= '2025-04-21 04:04:13'
)
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` ASCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_menus'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_content'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_categories'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_collections'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_events'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_blog'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_groups'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_forum'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_support'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_kb'UPDATE `jos_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1745208251;s:18:\"session.timer.last\";i:1745208251;s:17:\"session.timer.now\";i:1745208251;s:24:\"session.client.forwarded\";s:13:\"18.116.52.101\";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\";O:17:\"Hubzero\\User\\User\":1:{s:5:\"guest\";b:1;}s:11:\"tracker.sid\";s:32:\"d8123c2d135632d038fabe08b525a896\";s:12:\"tracker.ssid\";s:32:\"d8123c2d135632d038fabe08b525a896\";s:12:\"tracker.rsid\";s:32:\"d8123c2d135632d038fabe08b525a896\";}',`time` = '1745208253',`ip` = '10.233.94.22'
WHERE `session_id` = 'd8123c2d135632d038fabe08b525a896'
onAfterInitialise — Method — plgSystemLanguageFilter::onAfterInitialise → /app/plugins/system/languagefilter/languagefilter.php:186onAfterInitialise — Method — plgSystemP3p::onAfterInitialise → /core/plugins/system/p3p/p3p.php:21onAfterInitialise — Method — plgSystemRemember::onAfterInitialise → /core/plugins/system/remember/remember.php:20onAfterInitialise — Method — plgSystemHubzero::onAfterInitialise → /core/plugins/system/hubzero/hubzero.php:21onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:21onAfterInitialise — Method — plgSystemSupergroup::onAfterInitialise → /core/plugins/system/supergroup/supergroup.php:113onAfterInitialise — Method — plgSystemReferrerpolicy::onAfterInitialise → /core/plugins/system/referrerpolicy/referrerpolicy.php:21onAfterRoute — Method — plgSystemJquery::onAfterRoute → /core/plugins/system/jquery/jquery.php:21onAfterRoute — Method — plgSystemSpamjail::onAfterRoute → /core/plugins/system/spamjail/spamjail.php:21onAfterRoute — Method — plgSystemIncomplete::onAfterRoute → /core/plugins/system/incomplete/incomplete.php:21onAfterRoute — Method — plgSystemUnconfirmed::onAfterRoute → /core/plugins/system/unconfirmed/unconfirmed.php:21onAfterRoute — Method — plgSystemUnapproved::onAfterRoute → /core/plugins/system/unapproved/unapproved.php:21onAfterRoute — Method — plgSystemPassword::onAfterRoute → /app/plugins/system/password/password.php:21onPublicationAreas — Method — plgPublicationsQuestions::onPublicationAreas → /app/plugins/publications/questions/questions.php:31onPublicationAreas — Method — plgPublicationsReviews::onPublicationAreas → /app/plugins/publications/reviews/reviews.php:33onPublicationAreas — Method — plgPublicationsShare::onPublicationAreas → /app/plugins/publications/share/share.php:31onPublicationAreas — Method — plgPublicationsSupportingDocs::onPublicationAreas → /app/plugins/publications/supportingdocs/supportingdocs.php:31onPublicationAreas — Method — plgPublicationsUsage::onPublicationAreas → /app/plugins/publications/usage/usage.php:56onPublicationAreas — Method — plgPublicationsVersions::onPublicationAreas → /app/plugins/publications/versions/versions.php:31onPublicationAreas — Method — plgPublicationsForks::onPublicationAreas → /core/plugins/publications/forks/forks.php:31onPublication — Method — plgPublicationsQuestions::onPublication → /app/plugins/publications/questions/questions.php:54onPublication — Method — plgPublicationsReviews::onPublication → /app/plugins/publications/reviews/reviews.php:77onPublication — Method — plgPublicationsShare::onPublication → /app/plugins/publications/share/share.php:48onPublication — Method — plgPublicationsSupportingDocs::onPublication → /app/plugins/publications/supportingdocs/supportingdocs.php:55onPublication — Method — plgPublicationsUsage::onPublication → /app/plugins/publications/usage/usage.php:79onPublication — Method — plgPublicationsVersions::onPublication → /app/plugins/publications/versions/versions.php:55onPublication — Method — plgPublicationsGooglescholar::onPublication → /app/plugins/publications/googlescholar/googlescholar.php:27onPublication — Method — plgPublicationsOpengraph::onPublication → /app/plugins/publications/opengraph/opengraph.php:27onPublication — Method — plgPublicationsDublincore::onPublication → /app/plugins/publications/dublincore/dublincore.php:27onPublication — Method — plgPublicationsForks::onPublication → /core/plugins/publications/forks/forks.php:54onPublication — Method — plgPublicationsJsonld::onPublication → /core/plugins/publications/jsonld/jsonld.php:27onPublicationSub — Method — plgPublicationsRecommendations::onPublicationSub → /app/plugins/publications/recommendations/recommendations.php:56onPublicationSub — Method — plgPublicationsRelated::onPublicationSub → /app/plugins/publications/related/related.php:49onPublicationSub — Method — plgPublicationsGroups::onPublicationSub → /core/plugins/publications/groups/groups.php:49onPublicationSub — Method — plgPublicationsWatch::onPublicationSub → /core/plugins/publications/watch/watch.php:49onPublicationSub — Method — plgPublicationsForks::onPublicationSub → /core/plugins/publications/forks/forks.php:111onAfterDispatch — Method — plgSystemMobile::onAfterDispatch → /core/plugins/system/mobile/mobile.php:22onAfterDispatch — Method — plgSystemLanguageFilter::onAfterDispatch → /app/plugins/system/languagefilter/languagefilter.php:554onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:60onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:25onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:21
