- $_GET
-
Array(
)
Array(
)
- $_POST
-
Array(
)
Array(
)
- $_COOKIE
-
Array(
)
Array(
)
- $_SERVER
-
Array(
REDIRECT_UNIQUE_ID => WuDFZoAuE9gABlwlQfYAAAAH,
REDIRECT_SCRIPT_URL => /explore/online...
Array(
REDIRECT_UNIQUE_ID => WuDFZoAuE9gABlwlQfYAAAAH,
REDIRECT_SCRIPT_URL => /explore/online-databases,
REDIRECT_SCRIPT_URI => https://vhub.org/explore/online-databases,
REDIRECT_nokeepalive =>
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => vhub.org,
REDIRECT_STATUS => 200,
UNIQUE_ID => WuDFZoAuE9gABlwlQfYAAAAH,
SCRIPT_URL => /explore/online-databases,
SCRIPT_URI => https://vhub.org/explore/online-databases,
nokeepalive =>
HTTPS => on,
SSL_TLS_SNI => vhub.org,
HTTP_HOST => vhub.org,
HTTP_ACCEPT_ENCODING => x-gzip, gzip, deflate,
HTTP_USER_AGENT => CCBot/2.0 (http://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_IF_MODIFIED_SINCE => Sat, 24 Feb 2018 04:10:12 GMT,
PATH => /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin,
SERVER_SIGNATURE =>
SERVER_SOFTWARE => Apache,
SERVER_NAME => vhub.org,
SERVER_ADDR => 128.46.19.216,
SERVER_PORT => 443,
REMOTE_ADDR => 54.81.117.119,
DOCUMENT_ROOT => /www/vhub,
REQUEST_SCHEME => https,
CONTEXT_PREFIX =>
CONTEXT_DOCUMENT_ROOT => /www/vhub,
SERVER_ADMIN => nkissebe@purdue.edu,
SCRIPT_FILENAME => /www/vhub/index.php,
REMOTE_PORT => 57674,
REDIRECT_URL => /explore/online-databases,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.0,
REQUEST_METHOD => GET,
QUERY_STRING =>
REQUEST_URI => /explore/online-databases,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1524680038.79,
REQUEST_TIME => 1524680038,
argv => Array(
)
,
argc => 0
)
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ 6fe3c6bd47995c767a60e2b14b55b93e
tracker.ssid ⇒ 6fe3c6bd47995c767a60e2b14b55b93e
tracker.rsid ⇒ 6fe3c6bd47995c767a60e2b14b55b93e
securiy_code0 ⇒ 2d50b
session.token ⇒ 28bb0b361efb02e222b5d271d13eb6dd
27 MB
28 Queries Logged: 0.0054783821106 seconds
SELECT data
FROM `jos_session`
WHERE `session_id` = 'eea0b26d9b41980f19cd7fe88110eeff'DELETE
FROM`jos_session`
WHERE `session_id` = 'eea0b26d9b41980f19cd7fe88110eeff'SELECT data
FROM `jos_session`
WHERE `session_id` = '6fe3c6bd47995c767a60e2b14b55b93e'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` = '6fe3c6bd47995c767a60e2b14b55b93e'
LIMIT 1INSERT INTO `jos_session`
(`session_id`,`client_id`,`time`,`ip`)
VALUES ('6fe3c6bd47995c767a60e2b14b55b93e','0','1524680038','54.81.117.119')SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_members'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'SELECT *
FROM `jos_viewlevels`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` ASCSELECT 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` ASCSELECT 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` DESCSELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT *
FROM jos_languages
WHERE published=1
ORDER BY ordering ASCSELECT a.rules
FROM `jos_assets` AS `a`
WHERE `a`.`id` = '1'
GROUP BY a.id, a.rules, a.lftSELECT 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
SELECT 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 = 0 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,(0) as contactid,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 = 33
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-25 18:13:58')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-25 18:13:58')
AND (a.state = 1 OR a.state =2)
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=17
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.lftSELECT 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` = '0000-00-00 00:00:00'
OR `m`.`publish_up` <= '2018-04-25 18:13:59'
)
AND (`m`.`publish_down` = '0000-00-00 00:00:00'
OR `m`.`publish_down` >= '2018-04-25 18:13:59'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = '0'
AND (`mm`.`menuid` = '68'
OR `mm`.`menuid` <= '0'
)
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_support'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_search'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_kb'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_answers'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_wishlist'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_usage'UPDATE `jos_session`
SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1524680038;s:18:\"session.timer.last\";i:1524680038;s:17:\"session.timer.now\";i:1524680038;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:\"6fe3c6bd47995c767a60e2b14b55b93e\";s:12:\"tracker.ssid\";s:32:\"6fe3c6bd47995c767a60e2b14b55b93e\";s:12:\"tracker.rsid\";s:32:\"6fe3c6bd47995c767a60e2b14b55b93e\";s:13:\"securiy_code0\";s:5:\"2d50b\";s:13:\"session.token\";s:32:\"28bb0b361efb02e222b5d271d13eb6dd\";}',`time` = '1524680039',`ip` = '54.81.117.119'
WHERE `session_id` = '6fe3c6bd47995c767a60e2b14b55b93e'
17 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
11 × SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`2 × SELECT data
FROM `jos_session`1 × SELECT a.rules
FROM `jos_assets` AS `a`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_id1 × 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.template1 × SELECT b.rules
FROM `jos_assets` AS `a`
LEFT JOIN jos_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT folder AS type,element AS name,protected,params
FROM `jos_extensions`1 × SELECT session_id
FROM `jos_session`1 × SELECT b.id
FROM `jos_usergroups` AS `a`
LEFT JOIN jos_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM `jos_viewlevels1 × 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
OTHER Tables:
1 × 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.rgt1 × UPDATE `jos_session`
SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1524680038;s:18:\"session.timer.last\";i:1524680038;s:17:\"session.timer.now\";i:1524680038;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:\"6fe3c6bd47995c767a60e2b14b55b93e\";s:12:\"tracker.ssid\";s:32:\"6fe3c6bd47995c767a60e2b14b55b93e\";s:12:\"tracker.rsid\";s:32:\"6fe3c6bd47995c767a60e2b14b55b93e\";s:13:\"securiy_code0\";s:5:\"2d50b\";s:13:\"session.token\";s:32:\"28bb0b361efb02e222b5d271d13eb6dd\";}',`time` = '1524680039',`ip` = '54.81.117.119'1 × SELECT 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 = 0 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,(0) as contactid,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.rgt1 × SELECT *
FROM jos_languages1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
VALUES ('6fe3c6bd47995c767a60e2b14b55b93e','0','1524680038','54.81.117.119'1 × DELETE
FROM`jos_session`
onAfterInitialise — Method — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.php:46onAfterInitialise — Method — plgSystemP3p::onAfterInitialise → /core/plugins/system/p3p/p3p.php:45onAfterInitialise — Method — plgSystemRemember::onAfterInitialise → /core/plugins/system/remember/remember.php:44onAfterInitialise — Method — plgSystemHubzero::onAfterInitialise → /core/plugins/system/hubzero/hubzero.php:46onAfterInitialise — Method — plgSystemSupergroup::onAfterInitialise → /core/plugins/system/supergroup/supergroup.php:138onAfterRoute — Method — plgSystemJquery::onAfterRoute → /core/plugins/system/jquery/jquery.php:46onAfterRoute — Method — plgSystemSpamjail::onAfterRoute → /core/plugins/system/spamjail/spamjail.php:46onAfterRoute — Method — plgSystemIncomplete::onAfterRoute → /core/plugins/system/incomplete/incomplete.php:46onAfterRoute — Method — plgSystemUnconfirmed::onAfterRoute → /core/plugins/system/unconfirmed/unconfirmed.php:46onAfterRoute — Method — plgSystemUnapproved::onAfterRoute → /core/plugins/system/unapproved/unapproved.php:46onAfterRoute — Method — plgSystemPassword::onAfterRoute → /core/plugins/system/password/password.php:46onContentPrepare — Method — plgContentEmailcloak::onContentPrepare → /core/plugins/content/emailcloak/emailcloak.php:49onContentPrepare — Method — plgContentLoadmodule::onContentPrepare → /core/plugins/content/loadmodule/loadmodule.php:60onContentPrepare — Method — plgContentXhubtags::onContentPrepare → /core/plugins/content/xhubtags/xhubtags.php:50onContentPrepare — Method — plgContentPagebreak::onContentPrepare → /core/plugins/content/pagebreak/pagebreak.php:59onContentPrepare — Method — plgContentFormatwiki::onContentPrepare → /core/plugins/content/formatwiki/formatwiki.php:88onContentPrepare — Method — plgContentFormathtml::onContentPrepare → /core/plugins/content/formathtml/formathtml.php:130onContentBeforeDisplay — Method — plgContentPagenavigation::onContentBeforeDisplay → /core/plugins/content/pagenavigation/pagenavigation.php:49onContentBeforeDisplay — Method — plgContentVote::onContentBeforeDisplay → /core/plugins/content/vote/vote.php:57onAfterDispatch — Method — plgSystemDebug::onAfterDispatch → /core/plugins/system/debug/debug.php:87onAfterDispatch — Method — PlgSystemHighlight::onAfterDispatch → /core/plugins/system/highlight/highlight.php:49onGetModuleCaptcha — Method — plgSupportCaptcha::onGetModuleCaptcha → /core/plugins/support/captcha/captcha.php:217onAfterRender — Method — plgSystemSef::onAfterRender → /core/plugins/system/sef/sef.php:45