- $_GET
-
Array(
)
Array(
)
- $_POST
-
Array(
)
Array(
)
- $_COOKIE
-
Array(
)
Array(
)
- $_SERVER
-
Array(
SCRIPT_URL => /,
SCRIPT_URI => https://plantingscience.org/,
nokeepalive => ,
HTTP...
Array(
SCRIPT_URL => /,
SCRIPT_URI => https://plantingscience.org/,
nokeepalive =>
HTTPS => on,
SSL_TLS_SNI => plantingscience.org,
HTTP_HOST => plantingscience.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,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
SERVER_SIGNATURE =>
SERVER_SOFTWARE => Apache/2.2.15 (CentOS),
SERVER_NAME => plantingscience.org,
SERVER_ADDR => 172.30.0.20,
SERVER_PORT => 443,
REMOTE_ADDR => 54.144.6.40,
DOCUMENT_ROOT => /var/www/hub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/hub/index.php,
REMOTE_PORT => 41572,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.0,
REQUEST_METHOD => GET,
QUERY_STRING =>
REQUEST_URI => /,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1498238542.111,
REQUEST_TIME => 1498238542
)
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ 3cad32104837b9091cc992af5bbb8d21
tracker.ssid ⇒ 3cad32104837b9091cc992af5bbb8d21
tracker.rsid ⇒ 3cad32104837b9091cc992af5bbb8d21
securiy_code0 ⇒ 01551
session.token ⇒ e31514f281d0f6e1bf05e75cbd50ee6a
16 MB
30 Queries Logged: 0.010838985443115 seconds
SELECT data
FROM `jos_session`
WHERE `session_id` = '050bc189acf16c933c462770539cd264'DELETE
FROM`jos_session`
WHERE `session_id` = '050bc189acf16c933c462770539cd264'SELECT data
FROM `jos_session`
WHERE `session_id` = '3cad32104837b9091cc992af5bbb8d21'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` = '3cad32104837b9091cc992af5bbb8d21'
LIMIT 1INSERT INTO `jos_session`
(`session_id`,`client_id`,`time`,`ip`)
VALUES ('3cad32104837b9091cc992af5bbb8d21','0','1498238542','54.144.6.40')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 = 1
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-23 17:22:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-23 17:22:22')
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=2
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` <= '2017-06-23 17:22:22'
)
AND (`m`.`publish_down` = '0000-00-00 00:00:00'
OR `m`.`publish_down` >= '2017-06-23 17:22:22'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = '0'
AND (`mm`.`menuid` = '100'
OR `mm`.`menuid` <= '0'
)
ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
SELECT a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,a.fulltext, a.id, a.title, a.alias, a.title_alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, a.language,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,(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,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM jos_content AS a
LEFT JOIN jos_content_frontpage AS fp
ON fp.content_id = a.id
LEFT JOIN jos_categories AS c
ON c.id = a.catid
LEFT JOIN jos_users AS ua
ON ua.id = a.created_by
LEFT JOIN jos_users AS uam
ON uam.id = a.modified_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 != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1,4)
AND c.access IN (1,1,4)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid IN (16)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2017-06-23 17:22:22')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2017-06-23 17:22:22')
ORDER BY a.publish_up DESC
LIMIT 0, 5
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=16
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 extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_tags'SELECT *
FROM `jos_tags`
WHERE `jos_tags`.`admin` = '0'
ORDER BY `objects` DESC
LIMIT 25SELECT 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_support'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'UPDATE `jos_session`
SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1498238542;s:18:\"session.timer.last\";i:1498238542;s:17:\"session.timer.now\";i:1498238542;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:\"3cad32104837b9091cc992af5bbb8d21\";s:12:\"tracker.ssid\";s:32:\"3cad32104837b9091cc992af5bbb8d21\";s:12:\"tracker.rsid\";s:32:\"3cad32104837b9091cc992af5bbb8d21\";s:13:\"securiy_code0\";s:5:\"01551\";s:13:\"session.token\";s:32:\"e31514f281d0f6e1bf05e75cbd50ee6a\";}',`time` = '1498238542',`ip` = '54.144.6.40'
WHERE `session_id` = '3cad32104837b9091cc992af5bbb8d21'
onAfterInitialise — 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 — plgSystemXFeed::onAfterInitialise → /core/plugins/system/xfeed/xfeed.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 — plgContentLoadmodule::onContentPrepare → /core/plugins/content/loadmodule/loadmodule.php:60onContentPrepare — Method — plgContentEmailcloak::onContentPrepare → /core/plugins/content/emailcloak/emailcloak.php:49onContentPrepare — Method — plgContentPagebreak::onContentPrepare → /core/plugins/content/pagebreak/pagebreak.php:57onContentPrepare — Method — plgContentXhubtags::onContentPrepare → /core/plugins/content/xhubtags/xhubtags.php:50onContentPrepare — Method — plgContentFormatwiki::onContentPrepare → /core/plugins/content/formatwiki/formatwiki.php:85onContentPrepare — 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 — plgSystemMobile::onAfterDispatch → /core/plugins/system/mobile/mobile.php:47onAfterDispatch — 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
