Headless submit functionality

Execute generic submit command wthin a tool session without UI.

Launch Tool

You must login before you can run this tool.

Version 1.15 - published on 22 Jun 2020

This tool is closed source.

View All Supporting Documents

Category

Tools

Published on

Abstract

The headlesssubmit tool is be used to run cluster jobs without the standard HUB UI.

Cite this work

Researchers should cite this work as follows:

  • Steven Clark (2020), "Headless submit functionality," https://datacenterhub.org/resources/headlesssubmit.

    BibTex | EndNote

Debug Console

Close30 MBRequestSessionTimelineDatabase100Events52
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( NO_PROXY => .s2.internal, https_proxy => http://10.8.63.5:3128, http_proxy => http:/... Array(
NO_PROXY => .s2.internal,
https_proxy => http://10.8.63.5:3128,
http_proxy => http://10.8.63.5:3128,
LD_LIBRARY_PATH => /usr/local/lib:/usr/lib64/:/opt/rh/rh-python36/root/usr/lib64/:/opt/remi/php56/root/usr/lib64,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /resources/headlesssubmit,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/resources/headlesssubmit,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => datacenterhub.org,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /resources/headlesssubmit,
SCRIPT_URI => https://datacenterhub.org/resources/headlesssubmit,
HTTPS => on,
SSL_TLS_SNI => datacenterhub.org,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_ACCEPT_ENCODING => br,gzip,
HTTP_HOST => datacenterhub.org,
HTTP_CONNECTION => Keep-Alive,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache,
SERVER_NAME => datacenterhub.org,
SERVER_ADDR => 10.111.11.100,
SERVER_PORT => 443,
REMOTE_ADDR => 3.228.220.31,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 35472,
REDIRECT_URL => /resources/headlesssubmit,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /resources/headlesssubmit,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1597317477.6144,
REQUEST_TIME => 1597317477,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 27ec572f63fc720a43a19aabb06608da
tracker.ssid 27ec572f63fc720a43a19aabb06608da
tracker.rsid 27ec572f63fc720a43a19aabb06608da
  • site 0.050 seconds (+0.050); 12.25 MB (+12.250) - afterInitialise
  • site 0.074 seconds (+0.024); 14.00 MB (+1.750) - afterRoute
  • site 0.350 seconds (+0.276); 28.75 MB (+14.750) - afterDispatch
  • site 0.360 seconds (+0.011); 29.00 MB (+0.250) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.362 seconds (+0.002); 29.00 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.363 seconds (+0.000); 29.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.401 seconds (+0.038); 29.25 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.418 seconds (+0.018); 29.75 MB (+0.500) - onAfterRender
  • site 0.428 seconds (+0.010); 29.75 MB (0.000) - sessionStore
30 MB

100 Queries Logged: 0.10216426849365 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '3ca2878be84dd64c6ad39a4a0586502b'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '3ca2878be84dd64c6ad39a4a0586502b'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '27ec572f63fc720a43a19aabb06608da'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '27ec572f63fc720a43a19aabb06608da'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('27ec572f63fc720a43a19aabb06608da','0','1597317477','3.228.220.31')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. 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'
  9. SELECT *
      FROM `jos_viewlevels`
  10. 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` ASC
  11. 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` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  13. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  14. 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` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      ORDER BY `home` DESC
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tools'
  17. SELECT *
      FROM `jos_resources`
      WHERE `jos_resources`.`alias` = 'headlesssubmit'
  18. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '7'
  19. SHOW FULL COLUMNS
      FROM `jos_tool_version`
  20. SHOW FULL COLUMNS
      FROM `jos_tool_authors`
  21. SELECT v.*, d.local_revision, d.doi_label, d.rid, d.alias, d.versionid, d.doi, d.doi_shoulder
      FROM `jos_tool_version` as v
      LEFT JOIN `jos_doi_mapping` as d
      ON d.alias = v.toolname
      AND d.local_revision=v.revision
      WHERE v.toolname = 'headlesssubmit'
      ORDER BY v.state DESC, v.revision DESC
  22. SELECT r.id
      FROM `jos_tool` as t
      LEFT JOIN `jos_resources` as r
      ON r.alias = t.toolname
      WHERE t.id='8' ;
  23. SELECT authorid as uidNumber, ordering
      FROM `jos_author_assoc`
      WHERE subid= '14737'
      AND subtable='resources'
      ORDER BY ordering
  24. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='34'
      ORDER BY a.ordering
  25. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='33'
      ORDER BY a.ordering
  26. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='32'
      ORDER BY a.ordering
  27. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='31'
      ORDER BY a.ordering
  28. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='25'
      ORDER BY a.ordering
  29. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='17'
      ORDER BY a.ordering
  30. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='16'
      ORDER BY a.ordering
  31. SELECT jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags.id = jos_tags_object.tagid
      WHERE `jos_tags_object`.`label` != 'badge'
      AND `jos_tags_object`.`tbl` = 'resources'
      AND `jos_tags_object`.`objectid` = '14737'
      AND `jos_tags`.`admin` = '0'
  32. SELECT *
      FROM `jos_screenshots`
      WHERE `jos_screenshots`.`resourceid` = '14737'
      AND `jos_screenshots`.`versionid` = '34'
      ORDER BY `ordering` ASC
  33. SELECT n.id, t.name AS name, n.name AS xname, NULL AS xorg, n.givenName, n.givenName AS firstname, n.middleName, n.middleName AS middlename, n.surname, n.surname AS lastname, t.organization, t.*, a.role
      FROM `jos_tool_authors` AS t
      LEFT JOIN `jos_users` AS n
      ON n.id=t.uid JOIN `jos_tool_version` AS v
      ON v.id=t.version_id
      LEFT JOIN `jos_author_assoc` AS a
      ON a.authorid=t.uid
      AND a.subtable='resources'
      AND a.subid='14737'
      WHERE t.toolname='headlesssubmit'
      AND v.state<>3
      AND t.revision='20'
      ORDER BY t.ordering
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  35. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14737'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  36. SELECT *
      FROM `jos_resource_ratings`
      WHERE `jos_resource_ratings`.`resource_id` = '14737'
      AND `jos_resource_ratings`.`state` IN ('1','3')
      ORDER BY `created` DESC
  37. SHOW TABLES
  38. SELECT *
      FROM `jos_resource_stats_tools`
      WHERE `jos_resource_stats_tools`.`resid` = '14737'
      AND `jos_resource_stats_tools`.`period` = '14'
      AND `jos_resource_stats_tools`.`datetime` LIKE '%2020-08-%%'
  39. SELECT *
      FROM `jos_resource_stats_clusters`
      WHERE `jos_resource_stats_clusters`.`resid` = '14737'
  40. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  41. SELECT *
      FROM `jos_citations`
      INNER JOIN jos_citations_assoc
      ON jos_citations_assoc.cid = jos_citations.id
      WHERE `jos_citations`.`published` = '1'
      AND `jos_citations_assoc`.`tbl` = 'resource'
      AND `jos_citations_assoc`.`oid` = '14737'
      ORDER BY `jos_citations`.`affiliated` ASC,`jos_citations`.`year` DESC
  42. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  43. 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 ('toolheadlesssubmit')
      AND `jos_answers_questions`.`state` < '2'
  44. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  45. SELECT *
      FROM `jos_wishlist`
      WHERE `jos_wishlist`.`referenceid` = '14737'
      AND `jos_wishlist`.`category` = 'resource'
  46. SELECT *
      FROM `jos_xgroups`
      WHERE gidNumber = '14737';
  47. SHOW FULL COLUMNS
      FROM `jos_publications`
  48. SELECT V.*, C.id as id, C.category, C.master_type, C.project_id, C.access as master_access, C.master_doi, C.checked_out, C.checked_out_time, C.rating as master_rating, C.ranking as master_ranking, C.times_rated as master_times_rated, C.alias, V.id as version_id, C.group_owner, t.name AS cat_name, t.alias as cat_alias, t.url_alias as cat_url, MT.alias as base, MT.curatorgroup, PP.alias as project_alias, PP.title as project_title, PP.state as project_status, PP.provisioned as project_provisioned, PP.private as project_private, PP.owned_by_group as project_group ,(SELECT vv.version_label
      FROM jos_publication_versions as vv
      WHERE vv.publication_id=C.id
      AND (vv.state = 3 OR vv.state = 5)
      LIMIT 1) AS dev_version_label ,(SELECT vv.state
      FROM jos_publication_versions as vv
      WHERE vv.publication_id=C.id
      AND vv.main=1
      ORDER BY vv.created DESC
      LIMIT 1) AS default_version_status ,(SELECT COUNT(*)
      FROM jos_publication_versions
      WHERE publication_id=C.id
      AND state!=3 ) AS versions
      FROM jos_publication_versions as V, jos_projects AS PP, jos_publication_master_types AS MT, jos_publications AS C JOIN jos_publication_categories AS t
      ON C.category=t.id
      WHERE V.publication_id=C.id
      AND MT.id=C.master_type
      AND PP.id=C.project_id
      AND V.main=1
      AND C.id='14737'
      LIMIT 1
  49. SELECT *
      FROM `jos_resources`
      WHERE `jos_resources`.`id` = '14737'
  50. SELECT v.*, d.local_revision, d.doi_label, d.rid, d.alias, d.versionid, d.doi, d.doi_shoulder
      FROM `jos_tool_version` as v
      LEFT JOIN `jos_doi_mapping` as d
      ON d.alias = v.toolname
      AND d.local_revision=v.revision
      WHERE v.toolname = 'headlesssubmit'
      ORDER BY v.state DESC, v.revision DESC
  51. SELECT r.id
      FROM `jos_tool` as t
      LEFT JOIN `jos_resources` as r
      ON r.alias = t.toolname
      WHERE t.id='8' ;
  52. SELECT authorid as uidNumber, ordering
      FROM `jos_author_assoc`
      WHERE subid= '14737'
      AND subtable='resources'
      ORDER BY ordering
  53. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='34'
      ORDER BY a.ordering
  54. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='33'
      ORDER BY a.ordering
  55. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='32'
      ORDER BY a.ordering
  56. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='31'
      ORDER BY a.ordering
  57. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='25'
      ORDER BY a.ordering
  58. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='17'
      ORDER BY a.ordering
  59. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='16'
      ORDER BY a.ordering
  60. SELECT n.id, t.name AS name, n.name AS xname, NULL AS xorg, n.givenName, n.givenName AS firstname, n.middleName, n.middleName AS middlename, n.surname, n.surname AS lastname, t.organization, t.*, a.role
      FROM `jos_tool_authors` AS t
      LEFT JOIN `jos_users` AS n
      ON n.id=t.uid JOIN `jos_tool_version` AS v
      ON v.id=t.version_id
      LEFT JOIN `jos_author_assoc` AS a
      ON a.authorid=t.uid
      AND a.subtable='resources'
      AND a.subid='14737'
      WHERE t.toolname='headlesssubmit'
      AND v.state<>3
      AND t.revision='20'
      ORDER BY t.ordering
  61. SELECT g.cn
      FROM `jos_tool_groups` AS g
      INNER JOIN `jos_xgroups` AS xg
      ON g.cn=xg.cn
      INNER JOIN `jos_tool` AS t
      ON g.toolid=t.id
      INNER JOIN `jos_resources` as r
      ON r.alias = t.toolname
      WHERE r.id = '14737'
      AND g.role=1
  62. SELECT *
      FROM `jos_wishlist_ownergroups`
      WHERE `jos_wishlist_ownergroups`.`wishlist` = '256'
  63. SELECT *
      FROM `jos_xgroups`
      WHERE cn = 'app-headlesssubmit';
  64. (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
      where gidNumber='1495') UNION (select uidNumber, 'applicants' AS role
      from jos_xgroups_applicants
      where gidNumber='1495') UNION (select uidNumber, 'members' AS role
      from jos_xgroups_members
      where gidNumber='1495') UNION (select uidNumber, 'managers' AS role
      from jos_xgroups_managers
      where gidNumber='1495')
  65. SELECT *
      FROM `jos_wishlist_owners`
      WHERE `jos_wishlist_owners`.`wishlist` = '256'
      AND `jos_wishlist_owners`.`type` != '2'
  66. SELECT COUNT(jos_wishlist_item.id) AS count
      FROM `jos_wishlist_item`
      WHERE `jos_wishlist_item`.`wishlist` = '256'
      AND `jos_wishlist_item`.`status` != '2'
      AND `jos_wishlist_item`.`private` = '0'
  67. SELECT n.id, t.name AS name, n.name AS xname, NULL AS xorg, n.givenName, n.givenName AS firstname, n.middleName, n.middleName AS middlename, n.surname, n.surname AS lastname, t.organization, t.*, a.role
      FROM `jos_tool_authors` AS t
      LEFT JOIN `jos_users` AS n
      ON n.id=t.uid JOIN `jos_tool_version` AS v
      ON v.id=t.version_id
      LEFT JOIN `jos_author_assoc` AS a
      ON a.authorid=t.uid
      AND a.subtable='resources'
      AND a.subid='14737'
      WHERE t.toolname='headlesssubmit'
      AND v.state<>3
      AND t.revision='20'
      ORDER BY t.ordering
  68. SELECT n.id, t.name AS name, n.name AS xname, NULL AS xorg, n.givenName, n.givenName AS firstname, n.middleName, n.middleName AS middlename, n.surname, n.surname AS lastname, t.organization, t.*, a.role
      FROM `jos_tool_authors` AS t
      LEFT JOIN `jos_users` AS n
      ON n.id=t.uid JOIN `jos_tool_version` AS v
      ON v.id=t.version_id
      LEFT JOIN `jos_author_assoc` AS a
      ON a.authorid=t.uid
      AND a.subtable='resources'
      AND a.subid='14737'
      WHERE t.toolname='headlesssubmit'
      AND v.state<>3
      AND t.revision='20'
      ORDER BY t.ordering
  69. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1015'
  70. SHOW FULL COLUMNS
      FROM `jos_resource_assoc`
  71. SELECT jos_resources.*,parent_id,jos_resource_assoc.ordering AS associative_ordering,jos_resource_assoc.grouping AS associative_grouping
      FROM `jos_resources`
      INNER JOIN jos_resource_assoc
      ON jos_resources.id = child_id
      WHERE `jos_resource_assoc`.`parent_id` = '14737'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`standalone` = '0'
      ORDER BY `ordering` ASC
  72. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  73. SELECT 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_tools.14737'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  74. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  75. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  76. SHOW TABLES
  77. SELECT *
      FROM jos_tool_version
      WHERE instance='headlesssubmit_r20';
  78. SELECT alias
      FROM jos_tool_version_alias AS aux
      WHERE aux.tool_version_id='34'
      ORDER BY alias ASC;
  79. SELECT middleware
      FROM jos_tool_version_middleware AS aux
      WHERE aux.tool_version_id='34'
      ORDER BY middleware ASC;
  80. SELECT hostreq
      FROM jos_tool_version_hostreq AS aux
      WHERE aux.tool_version_id='34'
      ORDER BY hostreq ASC;
  81. SELECT uid
      FROM jos_tool_authors
      WHERE version_id='34'
      ORDER BY ordering ASC;
  82. SELECT cn
      FROM jos_tool_groups
      WHERE role='0'
      AND toolid='8'
      ORDER BY cn ASC;
  83. SELECT cn
      FROM jos_tool_groups
      WHERE (role='1' OR role='2')
      AND toolid='8'
      ORDER BY cn ASC;
  84. SELECT id,toolname,title,registered,registered_by,state_changed,ticketid,published,state,priority
      FROM jos_tool
      WHERE id='8';
  85. SELECT instance
      FROM jos_tool_version AS aux
      WHERE aux.toolid='8'
      ORDER BY version ASC;
  86. SELECT tv.toolname, tg.cn
      FROM `jos_tool_groups` AS tg, `jos_tool_version` AS tv
      WHERE tg.toolid = tv.toolid
      AND tg.toolid='8'
      AND role=0
      AND tv.instance='headlesssubmit_r20'
      AND tv.toolaccess='@
      GROUP'
  87. 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 m.gidNumber=g.gidNumber
      AND m.uidNumber=0
      ORDER BY description, cn
  88. SELECT k.*
      FROM ((SELECT DISTINCT w.id, w.title, w.pagename AS alias, v.pagetext AS introtext, NULL AS type, NULL AS published, NULL AS publish_up, w.scope, w.rating, w.times_rated, w.ranking, 'Topic' AS section
      FROM `jos_wiki_pages` AS w
      INNER JOIN `jos_wiki_versions` AS v
      ON w.version_id=v.id
      INNER JOIN `jos_wiki_links` AS wl
      ON wl.page_id=w.id
      WHERE v.approved=1
      AND wl.scope='resource'
      AND wl.scope_id='14737'
      AND w.access!=1
      GROUP BY w.id, v.pagetext
      ORDER BY ranking DESC, title
      LIMIT 10) UNION (SELECT DISTINCT r.id, r.title, r.alias, r.introtext, r.type, r.published, r.publish_up, NULL AS scope, r.rating, r.times_rated, r.ranking, rt.type AS section
      FROM `jos_resource_types` AS rt, `jos_resources` AS r JOIN `jos_resource_assoc` AS a
      ON r.id=a.parent_id
      LEFT JOIN `jos_resource_types` AS t
      ON r.logical_type=t.id
      WHERE r.published=1
      AND a.child_id='14737'
      AND r.type=rt.id
      AND r.type!=8
      AND r.access=0
      ORDER BY r.ranking
      LIMIT 10)) AS k
      ORDER BY ranking DESC
      LIMIT 10
  89. SELECT *
      FROM `jos_resource_sponsors`
      WHERE `jos_resource_sponsors`.`state` = '1'
  90. 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` = 'resources'
      AND `jos_tags_object`.`objectid` = '14737'
      GROUP BY jos_tags_object.label,jos_tags.id
  91. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '7'
  92. 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` <= '2020-08-13 11:17:57' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-08-13 11:17:57' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '88' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  93. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  94. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  95. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  96. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  97. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  98. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  99. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  100. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1597317477;s:18:\"session.timer.last\";i:1597317477;s:17:\"session.timer.now\";i:1597317477;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\":1:{s:9:\"Resources\";O:8:\"stdClass\":2:{s:6:\"Models\";O:8:\"stdClass\":3:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}s:10:\"Screenshot\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}s:7:\"Reviews\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Review\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:4:\"desc\";}}}}}}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:\"27ec572f63fc720a43a19aabb06608da\";s:12:\"tracker.ssid\";s:32:\"27ec572f63fc720a43a19aabb06608da\";s:12:\"tracker.rsid\";s:32:\"27ec572f63fc720a43a19aabb06608da\";}',`time` = '1597317478',`ip` = '3.228.220.31'
      WHERE `session_id` = '27ec572f63fc720a43a19aabb06608da'

58 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 16 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 14 × SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
  3. 4 × SELECT n.id, t.name AS name, n.name AS xname, NULL AS xorg, n.givenName, n.givenName AS firstname, n.middleName, n.middleName AS middlename, n.surname, n.surname AS lastname, t.organization, t.*, a.role
      FROM `jos_tool_authors` AS t
      LEFT JOIN `jos_users` AS n
      ON n.id=t.uid JOIN `jos_tool_version` AS v
      ON v.id=t.version_id
      LEFT JOIN `jos_author_assoc` AS a
      ON a.authorid=t.uid
      AND a.subtable='resources'
      AND a.subid='14737'
  4. 3 × SELECT *
      FROM `jos_resource_types`
  5. 2 × SELECT r.id
      FROM `jos_tool` as t
      LEFT JOIN `jos_resources` as r
      ON r.alias = t.toolname
  6. 2 × SELECT authorid as uidNumber, ordering
      FROM `jos_author_assoc`
  7. 2 × SELECT data
      FROM `jos_session`
  8. 2 × SELECT cn
      FROM jos_tool_groups
  9. 2 × SELECT *
      FROM `jos_assets`
  10. 2 × SELECT v.*, d.local_revision, d.doi_label, d.rid, d.alias, d.versionid, d.doi, d.doi_shoulder
      FROM `jos_tool_version` as v
      LEFT JOIN `jos_doi_mapping` as d
      ON d.alias = v.toolname
      AND d.local_revision=v.revision
  11. 2 × SELECT *
      FROM `jos_xgroups`
  12. 2 × SELECT *
      FROM `jos_resources`
  13. 1 × SELECT alias
      FROM jos_tool_version_alias AS aux
  14. 1 × SELECT middleware
      FROM jos_tool_version_middleware AS aux
  15. 1 × SELECT hostreq
      FROM jos_tool_version_hostreq AS aux
  16. 1 × SELECT *
      FROM jos_tool_version
  17. 1 × SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  18. 1 × SELECT a.rules
      FROM `jos_assets` AS `a`
  19. 1 × SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
  20. 1 × SELECT uid
      FROM jos_tool_authors
  21. 1 × SELECT session_id
      FROM `jos_session`
  22. 1 × SELECT *
      FROM `jos_resource_sponsors`
  23. 1 × SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
  24. 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_id
  25. 1 × SELECT k.*
      FROM ((SELECT DISTINCT w.id, w.title, w.pagename AS alias, v.pagetext AS introtext, NULL AS type, NULL AS published, NULL AS publish_up, w.scope, w.rating, w.times_rated, w.ranking, 'Topic' AS section
      FROM `jos_wiki_pages` AS w
      INNER JOIN `jos_wiki_versions` AS v
      ON w.version_id=v.id
      INNER JOIN `jos_wiki_links` AS wl
      ON wl.page_id=w.id
  26. 1 × 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
  27. 1 × SELECT id,toolname,title,registered,registered_by,state_changed,ticketid,published,state,priority
      FROM jos_tool
  28. 1 × SELECT instance
      FROM jos_tool_version AS aux
  29. 1 × SELECT tv.toolname, tg.cn
      FROM `jos_tool_groups` AS tg, `jos_tool_version` AS tv
  30. 1 × SELECT jos_resources.*,parent_id,jos_resource_assoc.ordering AS associative_ordering,jos_resource_assoc.grouping AS associative_grouping
      FROM `jos_resources`
      INNER JOIN jos_resource_assoc
      ON jos_resources.id = child_id
  31. 1 × SELECT COUNT(jos_wishlist_item.id) AS count
      FROM `jos_wishlist_item`
  32. 1 × SELECT *
      FROM `jos_author_assoc`
  33. 1 × SELECT *
      FROM `jos_resource_ratings`
  34. 1 × SELECT *
      FROM `jos_resource_stats_tools`
  35. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  36. 1 × SELECT *
      FROM `jos_screenshots`
  37. 1 × 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
  38. 1 × 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
  39. 1 × SELECT jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags.id = jos_tags_object.tagid
  40. 1 × SELECT *
      FROM `jos_resource_stats_clusters`
  41. 1 × SELECT *
      FROM `jos_citations`
      INNER JOIN jos_citations_assoc
      ON jos_citations_assoc.cid = jos_citations.id
  42. 1 × SELECT g.cn
      FROM `jos_tool_groups` AS g
      INNER JOIN `jos_xgroups` AS xg
      ON g.cn=xg.cn
      INNER JOIN `jos_tool` AS t
      ON g.toolid=t.id
      INNER JOIN `jos_resources` as r
      ON r.alias = t.toolname
  43. 1 × SELECT *
      FROM `jos_wishlist_ownergroups`
  44. 1 × SELECT *
      FROM `jos_wishlist_owners`
  45. 1 × SELECT V.*, C.id as id, C.category, C.master_type, C.project_id, C.access as master_access, C.master_doi, C.checked_out, C.checked_out_time, C.rating as master_rating, C.ranking as master_ranking, C.times_rated as master_times_rated, C.alias, V.id as version_id, C.group_owner, t.name AS cat_name, t.alias as cat_alias, t.url_alias as cat_url, MT.alias as base, MT.curatorgroup, PP.alias as project_alias, PP.title as project_title, PP.state as project_status, PP.provisioned as project_provisioned, PP.private as project_private, PP.owned_by_group as project_group ,(SELECT vv.version_label
      FROM jos_publication_versions as vv
  46. 1 × SELECT *
      FROM `jos_viewlevels
  47. 1 × 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
  48. 1 × SELECT *
      FROM `jos_wishlist`
  49. 1 × SELECT *
      FROM `jos_users`
OTHER Tables:
  1. 2 × SHOW TABLE
  2. 1 × (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
  3. 1 × SHOW FULL COLUMNS
      FROM `jos_resource_assoc
  4. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1597317477;s:18:\"session.timer.last\";i:1597317477;s:17:\"session.timer.now\";i:1597317477;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\":1:{s:9:\"Resources\";O:8:\"stdClass\":2:{s:6:\"Models\";O:8:\"stdClass\":3:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}s:10:\"Screenshot\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}s:6:\"Author\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:8:\"ordering\";s:8:\"orderdir\";s:3:\"asc\";}}s:7:\"Reviews\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Review\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:4:\"desc\";}}}}}}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:\"27ec572f63fc720a43a19aabb06608da\";s:12:\"tracker.ssid\";s:32:\"27ec572f63fc720a43a19aabb06608da\";s:12:\"tracker.rsid\";s:32:\"27ec572f63fc720a43a19aabb06608da\";}',`time` = '1597317478',`ip` = '3.228.220.31'
  5. 1 × SHOW FULL COLUMNS
      FROM `jos_publications
  6. 1 × DELETE
      FROM `jos_session`
  7. 1 × SHOW FULL COLUMNS
      FROM `jos_tool_version
  8. 1 × SHOW FULL COLUMNS
      FROM `jos_tool_authors
  9. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('27ec572f63fc720a43a19aabb06608da','0','1597317477','3.228.220.31'
  • 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 plgSystemPassword::onAfterRoute /core/plugins/system/password/password.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
  • onResourcesAreas Method plgResourcesAbout::onResourcesAreas /core/plugins/resources/about/about.php:32
  • onResourcesAreas Method plgResourcesReviews::onResourcesAreas /core/plugins/resources/reviews/reviews.php:43
  • onResourcesAreas Method plgResourcesUsage::onResourcesAreas /core/plugins/resources/usage/usage.php:29
  • onResourcesAreas Method plgResourcesVersions::onResourcesAreas /core/plugins/resources/versions/versions.php:29
  • onResourcesAreas Method plgResourcesShare::onResourcesAreas /core/plugins/resources/share/share.php:29
  • onResourcesAreas Method plgResourcesCitations::onResourcesAreas /core/plugins/resources/citations/citations.php:29
  • onResourcesAreas Method plgResourcesQuestions::onResourcesAreas /core/plugins/resources/questions/questions.php:29
  • onResourcesAreas Method plgResourcesSupportingDocs::onResourcesAreas /core/plugins/resources/supportingdocs/supportingdocs.php:30
  • onResourcesAreas Method plgResourcesWishlist::onResourcesAreas /core/plugins/resources/wishlist/wishlist.php:29
  • onResourcesAreas Method plgResourcesFindThisText::onResourcesAreas /core/plugins/resources/findthistext/findthistext.php:29
  • onResourcesAreas Method plgResourcesWindowstools::onResourcesAreas /core/plugins/resources/windowstools/windowstools.php:214
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:35
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:25
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:35
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:25
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:41
  • onResources Method plgResourcesAbout::onResources /core/plugins/resources/about/about.php:54
  • onResources Method plgResourcesReviews::onResources /core/plugins/resources/reviews/reviews.php:91
  • onResources Method plgResourcesUsage::onResources /core/plugins/resources/usage/usage.php:51
  • onResources Method plgResourcesVersions::onResources /core/plugins/resources/versions/versions.php:50
  • onResources Method plgResourcesShare::onResources /core/plugins/resources/share/share.php:50
  • onResources Method plgResourcesCitations::onResources /core/plugins/resources/citations/citations.php:51
  • onResources Method plgResourcesQuestions::onResources /core/plugins/resources/questions/questions.php:60
  • onResources Method plgResourcesSupportingDocs::onResources /core/plugins/resources/supportingdocs/supportingdocs.php:52
  • onResources Method plgResourcesWishlist::onResources /core/plugins/resources/wishlist/wishlist.php:50
  • onResources Method plgResourcesFindThisText::onResources /core/plugins/resources/findthistext/findthistext.php:51
  • onResources Method plgResourcesWindowstools::onResources /core/plugins/resources/windowstools/windowstools.php:235
  • onResources Method plgResourcesGooglescholar::onResources /core/plugins/resources/googlescholar/googlescholar.php:25
  • onResources Method plgResourcesOpengraph::onResources /core/plugins/resources/opengraph/opengraph.php:25
  • onResources Method plgResourcesDublincore::onResources /core/plugins/resources/dublincore/dublincore.php:25
  • onResources Method plgResourcesCoins::onResources /core/plugins/resources/coins/coins.php:25
  • onResourcesSub Method plgResourcesGroups::onResourcesSub /core/plugins/resources/groups/groups.php:45
  • onResourcesSub Method plgResourcesRelated::onResourcesSub /core/plugins/resources/related/related.php:45
  • onResourcesSub Method plgResourcesSponsors::onResourcesSub /core/plugins/resources/sponsors/sponsors.php:45
  • onResourcesSub Method plgResourcesWatch::onResourcesSub /core/plugins/resources/watch/watch.php:46
  • onResourcesSub Method plgResourcesCollections::onResourcesSub /core/plugins/resources/collections/collections.php:31
  • 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