- $_GET
-
Array(
)
Array(
)
- $_POST
-
Array(
)
Array(
)
- $_COOKIE
-
Array(
)
Array(
)
- $_SERVER
-
Array(
REDIRECT_UNIQUE_ID => Wyz5BYAuE9gADHBgpuAAAAAD,
REDIRECT_SCRIPT_URL => /members/6071, ...
Array(
REDIRECT_UNIQUE_ID => Wyz5BYAuE9gADHBgpuAAAAAD,
REDIRECT_SCRIPT_URL => /members/6071,
REDIRECT_SCRIPT_URI => https://vhub.org/members/6071,
REDIRECT_nokeepalive =>
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => vhub.org,
REDIRECT_STATUS => 200,
UNIQUE_ID => Wyz5BYAuE9gADHBgpuAAAAAD,
SCRIPT_URL => /members/6071,
SCRIPT_URI => https://vhub.org/members/6071,
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 => Wed, 21 Feb 2018 07:31:48 GMT,
HTTP_CONNECTION => close,
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.144.16.135,
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 => 60912,
REDIRECT_URL => /members/6071,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING =>
REQUEST_URI => /members/6071,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1529673989.33,
REQUEST_TIME => 1529673989,
argv => Array(
)
,
argc => 0
)
separator ⇒ .
orderBy ⇒ id
orderDir ⇒ asc
1 ⇒ registerIP
2 ⇒ access
always ⇒
renew ⇒
tracker.sid ⇒ a0ce13a97c3e755edaa06bc74089e214
tracker.ssid ⇒ a0ce13a97c3e755edaa06bc74089e214
tracker.rsid ⇒ a0ce13a97c3e755edaa06bc74089e214
securiy_code0 ⇒ fb81a
session.token ⇒ 0b693881e80224eaa1ac91830463fbe2
31 MB
53 Queries Logged: 0.0323092937469 seconds
SELECT data
FROM `jos_session`
WHERE `session_id` = '21ea3cdf3f97b886e99d48e50c711d32'DELETE
FROM`jos_session`
WHERE `session_id` = '21ea3cdf3f97b886e99d48e50c711d32'SELECT data
FROM `jos_session`
WHERE `session_id` = 'a0ce13a97c3e755edaa06bc74089e214'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` = 'a0ce13a97c3e755edaa06bc74089e214'
LIMIT 1INSERT INTO `jos_session`
(`session_id`,`client_id`,`time`,`ip`)
VALUES ('a0ce13a97c3e755edaa06bc74089e214','0','1529673989','54.144.16.135')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_tags'SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` = '6071'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_publications'SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_citations'SELECT *
FROM `jos_user_profile_fields`
WHERE `jos_user_profile_fields`.`action_edit` != '0'
ORDER BY `ordering` ASCSELECT *
FROM `jos_user_profile_options`
WHERE `jos_user_profile_options`.`field_id` IN ('1','2','3','5','6','7','11','12','13','15')
ORDER BY `ordering` ASCSELECT *
FROM `jos_user_profiles`
WHERE `jos_user_profiles`.`user_id` = '6071'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` = 'xprofiles'
AND `jos_tags_object`.`objectid` = '6071'
AND `jos_tags`.`admin` = '0'
GROUP BY jos_tags.idSELECT 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` = 'xprofiles'
AND `jos_tags_object`.`objectid` = '6071'
AND `jos_tags`.`admin` = '0'
GROUP BY jos_tags.idSELECT 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-06-22 13:26:29'
)
AND (`m`.`publish_down` = '0000-00-00 00:00:00'
OR `m`.`publish_down` >= '2018-06-22 13:26:29'
)
AND `m`.`access` IN ('1','1','4')
AND `m`.`client_id` = '0'
AND (`mm`.`menuid` = '43'
OR `mm`.`menuid` <= '0'
)
ORDER BY `m`.`position` ASC,`m`.`ordering` ASCSELECT jos_user_profiles.*,jos_user_profile_options.label
FROM `jos_user_profiles`
INNER JOIN jos_user_profile_fields
ON jos_user_profile_fields.name = jos_user_profiles.profile_key
LEFT JOIN jos_user_profile_options
ON jos_user_profile_options.field_id=jos_user_profile_fields.id
AND jos_user_profile_options.value=jos_user_profiles.profile_value
WHERE `jos_user_profiles`.`user_id` = '6071'
AND `jos_user_profiles`.`user_id` = '6071'
ORDER BY `ordering` ASCSELECT 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` = 'xprofiles'
AND `jos_tags_object`.`objectid` = '6071'
AND `jos_tags`.`admin` = '0'
GROUP BY jos_tags.idSELECT *
FROM `jos_xgroups_inviteemails`
WHERE `jos_xgroups_inviteemails`.`email` = 'fandimin@gmail.com'( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM `jos_xgroups` AS g, `jos_xgroups_applicants` AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=6071 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
FROM `jos_xgroups` AS g, `jos_xgroups_members` AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=6071 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
FROM `jos_xgroups` AS g, `jos_xgroups_managers` AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=6071 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
FROM `jos_xgroups` AS g, `jos_xgroups_invitees` AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=6071 )SELECT *
FROM `jos_resource_types`
WHERE `jos_resource_types`.`category` = '27'
ORDER BY `type` ASCSELECT COUNT(jos_resources.id) AS count
FROM `jos_resources`
LEFT JOIN jos_author_assoc
ON jos_author_assoc.subid = jos_resources.id
WHERE `jos_resources`.`standalone` = '1'
AND `jos_resources`.`published` IN ('1')
AND `jos_author_assoc`.`subtable` = 'resources'
AND `jos_author_assoc`.`authorid` = '6071'
AND `jos_author_assoc`.`role` != 'submitter'
AND `jos_resources`.`access` IN ('0','3')SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_wiki'SELECT *
FROM `jos_wiki_versions`
WHERE `jos_wiki_versions`.`created_by` = '6071'
AND `jos_wiki_versions`.`approved` = '1'
GROUP BY page_idSELECT COUNT(jos_wiki_pages.id) AS count
FROM `jos_wiki_pages`
WHERE `jos_wiki_pages`.`state` = '1'
AND `jos_wiki_pages`.`scope` = 'site'
AND `jos_wiki_pages`.`id` IN ('')SHOW FULL COLUMNS
FROM `jos_publications`SHOW TABLESSELECT COUNT(jos_xmessage_recipient.id) AS count
FROM `jos_xmessage_recipient`
INNER JOIN jos_xmessage
ON jos_xmessage.id = jos_xmessage_recipient.mid
LEFT JOIN jos_xmessage_seen
ON jos_xmessage_seen.mid=jos_xmessage.id
AND jos_xmessage_seen.uid=6071
WHERE `jos_xmessage_recipient`.`uid` = '6071'
AND `jos_xmessage_recipient`.`state` = '0'SELECT COUNT(jos_xmessage.id) AS count
FROM `jos_xmessage`
INNER JOIN jos_xmessage_recipient
ON jos_xmessage.id = jos_xmessage_recipient.mid
WHERE `jos_xmessage_recipient`.`uid` = '6071'
AND `jos_xmessage_recipient`.`state` != '2'
AND jos_xmessage.id NOT IN (SELECT s.mid
FROM `jos_xmessage_seen` AS s
WHERE s.uid=6071)SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`
WHERE `type` = 'component'
AND `element` = 'com_blog'SELECT *
FROM `jos_blog_entries`
WHERE `jos_blog_entries`.`scope` = 'member'
AND `jos_blog_entries`.`scope_id` = '6071'
AND `jos_blog_entries`.`state` = '1'
AND `jos_blog_entries`.`access` IN ('1','1','4')
AND (`jos_blog_entries`.`publish_up` = '0000-00-00 00:00:00'
OR `jos_blog_entries`.`publish_up` <= '2018-06-22 13:26:29'
)
AND (`jos_blog_entries`.`publish_down` = '0000-00-00 00:00:00'
OR `jos_blog_entries`.`publish_down` >= '2018-06-22 13:26:29'
)SELECT *
FROM `jos_users`
WHERE `jos_users`.`id` IN ('6071')SELECT id,entry_id
FROM `jos_blog_comments`
WHERE `jos_blog_comments`.`state` IN ('1','3')
AND `jos_blog_comments`.`entry_id` IN ('1145','1146','1147','1148','1484')SELECT jos_citations.*,u.username,F.format AS template,CS.sec_cits_cnt AS sec_cnt
FROM `jos_citations`
LEFT JOIN jos_users AS u
ON jos_citations.uid = u.id
LEFT JOIN jos_citations_secondary AS CS
ON jos_citations.id = CS.cid
LEFT JOIN jos_citations_format AS F
ON jos_citations.format = F.style
WHERE `jos_citations`.`scope` = 'member'
AND `jos_citations`.`scope_id` = '6071'
AND `jos_citations`.`published` IN ('1')SELECT COUNT(jos_activity_recipients.id) AS count
FROM `jos_activity_recipients`
WHERE `jos_activity_recipients`.`scope` = 'user'
AND `jos_activity_recipients`.`scope_id` = '6071'
AND `jos_activity_recipients`.`state` = '1'
AND `jos_activity_recipients`.`viewed` = '0000-00-00 00:00:00'( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_applicants AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_members AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
FROM jos_xgroups AS g, jos_xgroups_managers AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_invitees AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=0 )( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_applicants AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=6071 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_members AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=6071 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
FROM jos_xgroups AS g, jos_xgroups_managers AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=6071 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_invitees AS m
WHERE (g.type='1' OR g.type='3')
AND m.gidNumber=g.gidNumber
AND m.uidNumber=6071 )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_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_content'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:1529673989;s:18:\"session.timer.last\";i:1529673989;s:17:\"session.timer.now\";i:1529673989;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":2:{s:7:\"Members\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Profile\";O:8:\"stdClass\":4:{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:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}}}}}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:\"a0ce13a97c3e755edaa06bc74089e214\";s:12:\"tracker.ssid\";s:32:\"a0ce13a97c3e755edaa06bc74089e214\";s:12:\"tracker.rsid\";s:32:\"a0ce13a97c3e755edaa06bc74089e214\";s:13:\"securiy_code0\";s:5:\"fb81a\";s:13:\"session.token\";s:32:\"0b693881e80224eaa1ac91830463fbe2\";}',`time` = '1529673990',`ip` = '54.144.16.135'
WHERE `session_id` = 'a0ce13a97c3e755edaa06bc74089e214'
33 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
16 × SELECT extension_id AS id,element AS "option",params,enabled
FROM `jos_extensions`3 × SELECT jos_tags_object.label,jos_tags.*
FROM `jos_tags`
INNER JOIN jos_tags_object
ON jos_tags_object.tagid = jos_tags.id2 × SELECT data
FROM `jos_session`2 × SELECT *
FROM `jos_users`1 × SELECT *
FROM `jos_wiki_versions`1 × SELECT COUNT(jos_activity_recipients.id) AS count
FROM `jos_activity_recipients`1 × SELECT COUNT(jos_resources.id) AS count
FROM `jos_resources`
LEFT JOIN jos_author_assoc
ON jos_author_assoc.subid = jos_resources.id1 × SELECT *
FROM `jos_resource_types`1 × SELECT COUNT(jos_wiki_pages.id) AS count
FROM `jos_wiki_pages`1 × SELECT COUNT(jos_xmessage_recipient.id) AS count
FROM `jos_xmessage_recipient`
INNER JOIN jos_xmessage
ON jos_xmessage.id = jos_xmessage_recipient.mid
LEFT JOIN jos_xmessage_seen
ON jos_xmessage_seen.mid=jos_xmessage.id
AND jos_xmessage_seen.uid=60711 × SELECT id,entry_id
FROM `jos_blog_comments`1 × SELECT *
FROM `jos_blog_entries`1 × SELECT COUNT(jos_xmessage.id) AS count
FROM `jos_xmessage`
INNER JOIN jos_xmessage_recipient
ON jos_xmessage.id = jos_xmessage_recipient.mid1 × SELECT *
FROM `jos_xgroups_inviteemails`1 × SELECT jos_citations.*,u.username,F.format AS template,CS.sec_cits_cnt AS sec_cnt
FROM `jos_citations`
LEFT JOIN jos_users AS u
ON jos_citations.uid = u.id
LEFT JOIN jos_citations_secondary AS CS
ON jos_citations.id = CS.cid
LEFT JOIN jos_citations_format AS F
ON jos_citations.format = F.style1 × 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 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_id1 × SELECT folder AS type,element AS name,protected,params
FROM `jos_extensions`1 × SELECT *
FROM `jos_viewlevels1 × 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 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 *
FROM `jos_user_profile_fields`1 × SELECT session_id
FROM `jos_session`1 × SELECT *
FROM `jos_user_profiles`1 × SELECT *
FROM `jos_user_profile_options`1 × SELECT jos_user_profiles.*,jos_user_profile_options.label
FROM `jos_user_profiles`
INNER JOIN jos_user_profile_fields
ON jos_user_profile_fields.name = jos_user_profiles.profile_key
LEFT JOIN jos_user_profile_options
ON jos_user_profile_options.field_id=jos_user_profile_fields.id
AND jos_user_profile_options.value=jos_user_profiles.profile_value
OTHER Tables:
2 × ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM jos_xgroups AS g, jos_xgroups_applicants AS m1 × UPDATE `jos_session`
SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1529673989;s:18:\"session.timer.last\";i:1529673989;s:17:\"session.timer.now\";i:1529673989;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":2:{s:7:\"Members\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Profile\";O:8:\"stdClass\":4:{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:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}}s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}}}}}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:\"a0ce13a97c3e755edaa06bc74089e214\";s:12:\"tracker.ssid\";s:32:\"a0ce13a97c3e755edaa06bc74089e214\";s:12:\"tracker.rsid\";s:32:\"a0ce13a97c3e755edaa06bc74089e214\";s:13:\"securiy_code0\";s:5:\"fb81a\";s:13:\"session.token\";s:32:\"0b693881e80224eaa1ac91830463fbe2\";}',`time` = '1529673990',`ip` = '54.144.16.135'1 × SHOW TABLE1 × SHOW FULL COLUMNS
FROM `jos_publications1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
VALUES ('a0ce13a97c3e755edaa06bc74089e214','0','1529673989','54.144.16.135'1 × ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
FROM `jos_xgroups` AS g, `jos_xgroups_applicants` AS m1 × 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:46onMembersAreas — Method — plgMembersDashboard::onMembersAreas → /core/plugins/members/dashboard/dashboard.php:87onMembersAreas — Method — plgMembersProfile::onMembersAreas → /core/plugins/members/profile/profile.php:55onMembersAreas — Method — plgMembersAccount::onMembersAreas → /core/plugins/members/account/account.php:59onMembersAreas — Method — plgMembersGroups::onMembersAreas → /core/plugins/members/groups/groups.php:55onMembersAreas — Method — plgMembersContributions::onMembersAreas → /core/plugins/members/contributions/contributions.php:55onMembersAreas — Method — plgMembersUsage::onMembersAreas → /core/plugins/members/usage/usage.php:55onMembersAreas — Method — plgMembersMessages::onMembersAreas → /core/plugins/members/messages/messages.php:55onMembersAreas — Method — plgMembersBlog::onMembersAreas → /core/plugins/members/blog/blog.php:55onMembersAreas — Method — plgMembersImpact::onMembersAreas → /core/plugins/members/impact/impact.php:105onMembersAreas — Method — plgMembersCitations::onMembersAreas → /core/plugins/members/citations/citations.php:72onMembersAreas — Method — plgMembersActivity::onMembersAreas → /core/plugins/members/activity/activity.php:54onMembersContributionsAreas — Method — plgMembersResources::onMembersContributionsAreas → /core/plugins/members/resources/resources.php:88onMembersContributionsAreas — Method — plgMembersWiki::onMembersContributionsAreas → /core/plugins/members/wiki/wiki.php:53onMembersContributionsAreas — Method — plgMembersImpact::onMembersContributionsAreas → /core/plugins/members/impact/impact.php:221onMembersContributions — Method — plgMembersResources::onMembersContributions → /core/plugins/members/resources/resources.php:142onMembersContributions — Method — plgMembersWiki::onMembersContributions → /core/plugins/members/wiki/wiki.php:90onMembersContributions — Method — plgMembersImpact::onMembersContributions → /core/plugins/members/impact/impact.php:266onMembers — Method — plgMembersDashboard::onMembers → /core/plugins/members/dashboard/dashboard.php:113onMembers — Method — plgMembersProfile::onMembers → /core/plugins/members/profile/profile.php:75onMembers — Method — plgMembersAccount::onMembers → /core/plugins/members/account/account.php:85onMembers — Method — plgMembersGroups::onMembers → /core/plugins/members/groups/groups.php:81onMembers — Method — plgMembersContributions::onMembers → /core/plugins/members/contributions/contributions.php:75onMembers — Method — plgMembersUsage::onMembers → /core/plugins/members/usage/usage.php:75onMembers — Method — plgMembersMessages::onMembers → /core/plugins/members/messages/messages.php:81onMembers — Method — plgMembersBlog::onMembers → /core/plugins/members/blog/blog.php:75onMembers — Method — plgMembersImpact::onMembers → /core/plugins/members/impact/impact.php:138onMembers — Method — plgMembersCitations::onMembers → /core/plugins/members/citations/citations.php:92onMembers — Method — plgMembersActivity::onMembers → /core/plugins/members/activity/activity.php:78onAfterDispatch — 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