OpenCPU

OpenCPU is a software system for embedded statistical computation and reproducible research.

Launch Tool

You must login before you can run this tool.

Version 1.0 - published on 24 Jan 2019

Open source: license | download

View All Supporting Documents

Debug Console

Close29 MBRequestSessionTimelineDatabase85Events46
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( MANPATH => /opt/remi/php56/root/usr/share/man:/opt/puppetlabs/puppet/share/man, HOSTNA... Array(
MANPATH => /opt/remi/php56/root/usr/share/man:/opt/puppetlabs/puppet/share/man,
HOSTNAME => hz01-p-web01.hz01.internal,
SHELL => /bin/bash,
TERM => xterm-256color,
HISTSIZE => 1000,
SSH_TTY => /dev/pts/0,
NO_PROXY => .s2.internal,
http_proxy => http://10.8.63.5:3128,
USER => apache,
LD_LIBRARY_PATH => /opt/remi/php56/root/usr/lib64,
LS_COLORS => rs=0:di=38;5;27:ln=38;5;51:mh=44;38;5;15:pi=40;38;5;11:so=38;5;13:do=38;5;5:bd=48;5;232;38;5;11:cd=48;5;232;38;5;3:or=48;5;232;38;5;9:mi=05;48;5;232;38;5;15:su=48;5;196;38;5;15:sg=48;5;11;38;5;16:ca=48;5;196;38;5;226:tw=48;5;10;38;5;16:ow=48;5;10;38;5;21:st=48;5;21;38;5;15:ex=38;5;34:*.tar=38;5;9:*.tgz=38;5;9:*.arj=38;5;9:*.taz=38;5;9:*.lzh=38;5;9:*.lzma=38;5;9:*.tlz=38;5;9:*.txz=38;5;9:*.zip=38;5;9:*.z=38;5;9:*.Z=38;5;9:*.dz=38;5;9:*.gz=38;5;9:*.lz=38;5;9:*.xz=38;5;9:*.bz2=38;5;9:*.tbz=38;5;9:*.tbz2=38;5;9:*.bz=38;5;9:*.tz=38;5;9:*.deb=38;5;9:*.rpm=38;5;9:*.jar=38;5;9:*.rar=38;5;9:*.ace=38;5;9:*.zoo=38;5;9:*.cpio=38;5;9:*.7z=38;5;9:*.rz=38;5;9:*.jpg=38;5;13:*.jpeg=38;5;13:*.gif=38;5;13:*.bmp=38;5;13:*.pbm=38;5;13:*.pgm=38;5;13:*.ppm=38;5;13:*.tga=38;5;13:*.xbm=38;5;13:*.xpm=38;5;13:*.tif=38;5;13:*.tiff=38;5;13:*.png=38;5;13:*.svg=38;5;13:*.svgz=38;5;13:*.mng=38;5;13:*.pcx=38;5;13:*.mov=38;5;13:*.mpg=38;5;13:*.mpeg=38;5;13:*.m2v=38;5;13:*.mkv=38;5;13:*.ogm=38;5;13:*.mp4=38;5;13:*.m4v=38;5;13:*.mp4v=38;5;13:*.vob=38;5;13:*.qt=38;5;13:*.nuv=38;5;13:*.wmv=38;5;13:*.asf=38;5;13:*.rm=38;5;13:*.rmvb=38;5;13:*.flc=38;5;13:*.avi=38;5;13:*.fli=38;5;13:*.flv=38;5;13:*.gl=38;5;13:*.dl=38;5;13:*.xcf=38;5;13:*.xwd=38;5;13:*.yuv=38;5;13:*.cgm=38;5;13:*.emf=38;5;13:*.axv=38;5;13:*.anx=38;5;13:*.ogv=38;5;13:*.ogx=38;5;13:*.aac=38;5;45:*.au=38;5;45:*.flac=38;5;45:*.mid=38;5;45:*.midi=38;5;45:*.mka=38;5;45:*.mp3=38;5;45:*.mpc=38;5;45:*.ogg=38;5;45:*.ra=38;5;45:*.wav=38;5;45:*.axa=38;5;45:*.oga=38;5;45:*.spx=38;5;45:*.xspf=38;5;45:,
SUDO_USER => su-ehuebner,
SUDO_UID => 602,
USERNAME => root,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
MAIL => /var/spool/mail/su-ehuebner,
PWD => /home/ehuebner,
LANG => en_US.UTF-8,
MODULEPATH => /usr/share/Modules/modulefiles:/etc/modulefiles,
LOADEDMODULES => ,
https_proxy => http://10.8.63.5:3128,
ENVIRON_CONFIG_DIRS => /etc/environ.d ,
SHLVL => 3,
SUDO_COMMAND => /bin/su,
HOME => /var/www,
LOGNAME => root,
CVS_RSH => ssh,
MODULESHOME => /usr/share/Modules,
LESSOPEN => ||/usr/bin/lesspipe.sh %s,
SUDO_GID => 800,
G_BROKEN_FILENAMES => 1,
BASH_FUNC_module() => () { eval `/usr/bin/modulecmd bash $*`
}
,
_ => /opt/remi/php56/root/usr/sbin/php-fpm,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /resources/opencpu/citations,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/resources/opencpu/citations,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /resources/opencpu/citations,
SCRIPT_URI => https://datacenterhub.org/resources/opencpu/citations,
HTTPS => on,
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 => 10.111.11.10,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 30362,
REDIRECT_URL => /resources/opencpu/citations,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /resources/opencpu/citations,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1590474740.1001,
REQUEST_TIME => 1590474740,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 81c0bf5a6e3d3e5eccbf7ab63a7ef83a
tracker.ssid 81c0bf5a6e3d3e5eccbf7ab63a7ef83a
tracker.rsid 81c0bf5a6e3d3e5eccbf7ab63a7ef83a
  • site 0.046 seconds (+0.046); 12.25 MB (+12.250) - afterInitialise
  • site 0.067 seconds (+0.022); 13.75 MB (+1.500) - afterRoute
  • site 0.309 seconds (+0.242); 27.75 MB (+14.000) - afterDispatch
  • site 0.316 seconds (+0.007); 28.00 MB (+0.250) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.318 seconds (+0.002); 28.25 MB (+0.250) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.319 seconds (+0.000); 28.25 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.334 seconds (+0.015); 28.50 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.340 seconds (+0.006); 28.75 MB (+0.250) - onAfterRender
  • site 0.342 seconds (+0.003); 28.75 MB (0.000) - sessionStore
29 MB

85 Queries Logged: 0.056622266769409 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '84b6113d55755cf1d334bab058cfb1b6'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '84b6113d55755cf1d334bab058cfb1b6'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '81c0bf5a6e3d3e5eccbf7ab63a7ef83a'
  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` = '81c0bf5a6e3d3e5eccbf7ab63a7ef83a'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('81c0bf5a6e3d3e5eccbf7ab63a7ef83a','0','1590474740','10.111.11.10')
  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` = 'opencpu'
  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 = 'opencpu'
      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='12' ;
  23. SELECT authorid as uidNumber, ordering
      FROM `jos_author_assoc`
      WHERE subid= '14795'
      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='24'
      ORDER BY a.ordering
  25. SELECT *
      FROM `jos_author_assoc`
      WHERE `jos_author_assoc`.`subid` = '14795'
      AND `jos_author_assoc`.`subtable` = 'resources'
      ORDER BY `ordering` ASC
  26. SELECT *
      FROM `jos_resource_ratings`
      WHERE `jos_resource_ratings`.`resource_id` = '14795'
      AND `jos_resource_ratings`.`state` IN ('1','3')
      ORDER BY `created` DESC
  27. SHOW TABLES
  28. SELECT *
      FROM `jos_resource_stats_tools`
      WHERE `jos_resource_stats_tools`.`resid` = '14795'
      AND `jos_resource_stats_tools`.`period` = '14'
      AND `jos_resource_stats_tools`.`datetime` LIKE '%2020-05-%%'
  29. SELECT *
      FROM `jos_resource_stats_clusters`
      WHERE `jos_resource_stats_clusters`.`resid` = '14795'
  30. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  31. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  32. 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` = '14795'
      ORDER BY `jos_citations`.`affiliated` ASC,`jos_citations`.`year` DESC
  33. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  34. 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 ('toolopencpu')
      AND `jos_answers_questions`.`state` < '2'
  35. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  36. SELECT *
      FROM `jos_wishlist`
      WHERE `jos_wishlist`.`referenceid` = '14795'
      AND `jos_wishlist`.`category` = 'resource'
  37. SELECT *
      FROM `jos_xgroups`
      WHERE gidNumber = '14795';
  38. SHOW FULL COLUMNS
      FROM `jos_publications`
  39. 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='14795'
      LIMIT 1
  40. SELECT *
      FROM `jos_resources`
      WHERE `jos_resources`.`id` = '14795'
  41. 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 = 'opencpu'
      ORDER BY v.state DESC, v.revision DESC
  42. SELECT r.id
      FROM `jos_tool` as t
      LEFT JOIN `jos_resources` as r
      ON r.alias = t.toolname
      WHERE t.id='12' ;
  43. SELECT authorid as uidNumber, ordering
      FROM `jos_author_assoc`
      WHERE subid= '14795'
      AND subtable='resources'
      ORDER BY ordering
  44. SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
      WHERE a.version_id='24'
      ORDER BY a.ordering
  45. 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='14795'
      WHERE t.toolname='opencpu'
      AND v.state<>3
      AND t.revision='3'
      ORDER BY t.ordering
  46. 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 = '14795'
      AND g.role=1
  47. SELECT *
      FROM `jos_wishlist_ownergroups`
      WHERE `jos_wishlist_ownergroups`.`wishlist` = '265'
  48. SELECT *
      FROM `jos_xgroups`
      WHERE cn = 'app-opencpu';
  49. (select uidNumber, 'invitees' AS role
      from jos_xgroups_invitees
      where gidNumber='1503') UNION (select uidNumber, 'applicants' AS role
      from jos_xgroups_applicants
      where gidNumber='1503') UNION (select uidNumber, 'members' AS role
      from jos_xgroups_members
      where gidNumber='1503') UNION (select uidNumber, 'managers' AS role
      from jos_xgroups_managers
      where gidNumber='1503')
  50. SELECT *
      FROM `jos_wishlist_owners`
      WHERE `jos_wishlist_owners`.`wishlist` = '265'
      AND `jos_wishlist_owners`.`type` != '2'
  51. SELECT COUNT(jos_wishlist_item.id) AS count
      FROM `jos_wishlist_item`
      WHERE `jos_wishlist_item`.`wishlist` = '265'
      AND `jos_wishlist_item`.`status` != '2'
      AND `jos_wishlist_item`.`private` = '0'
  52. 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='14795'
      WHERE t.toolname='opencpu'
      AND v.state<>3
      AND t.revision='3'
      ORDER BY t.ordering
  53. 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='14795'
      WHERE t.toolname='opencpu'
      AND v.state<>3
      AND t.revision='3'
      ORDER BY t.ordering
  54. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1047'
  55. SHOW FULL COLUMNS
      FROM `jos_resource_assoc`
  56. 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` = '14795'
      AND `jos_resources`.`published` = '1'
      AND `jos_resources`.`standalone` = '0'
      ORDER BY `ordering` ASC
  57. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  58. 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.14795'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  59. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  60. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  61. SHOW TABLES
  62. SELECT *
      FROM jos_tool_version
      WHERE instance='opencpu_r3';
  63. SELECT alias
      FROM jos_tool_version_alias AS aux
      WHERE aux.tool_version_id='24'
      ORDER BY alias ASC;
  64. SELECT middleware
      FROM jos_tool_version_middleware AS aux
      WHERE aux.tool_version_id='24'
      ORDER BY middleware ASC;
  65. SELECT hostreq
      FROM jos_tool_version_hostreq AS aux
      WHERE aux.tool_version_id='24'
      ORDER BY hostreq ASC;
  66. SELECT uid
      FROM jos_tool_authors
      WHERE version_id='24'
      ORDER BY ordering ASC;
  67. SELECT cn
      FROM jos_tool_groups
      WHERE role='0'
      AND toolid='12'
      ORDER BY cn ASC;
  68. SELECT cn
      FROM jos_tool_groups
      WHERE (role='1' OR role='2')
      AND toolid='12'
      ORDER BY cn ASC;
  69. SELECT id,toolname,title,registered,registered_by,state_changed,ticketid,published,state,priority
      FROM jos_tool
      WHERE id='12';
  70. SELECT instance
      FROM jos_tool_version AS aux
      WHERE aux.toolid='12'
      ORDER BY version ASC;
  71. SELECT tv.toolname, tg.cn
      FROM `jos_tool_groups` AS tg, `jos_tool_version` AS tv
      WHERE tg.toolid = tv.toolid
      AND tg.toolid='12'
      AND role=0
      AND tv.instance='opencpu_r3'
      AND tv.toolaccess='@
      GROUP'
  72. 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
  73. 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='14795'
      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='14795'
      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
  74. SELECT *
      FROM `jos_resource_sponsors`
      WHERE `jos_resource_sponsors`.`state` = '1'
  75. 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` = '14795'
      GROUP BY jos_tags_object.label,jos_tags.id
  76. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`id` = '7'
  77. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  78. 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-05-26 06:32:20' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-05-26 06:32:20' )
      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
  79. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  80. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  81. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  82. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  83. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  84. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  85. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590474740;s:18:\"session.timer.last\";i:1590474740;s:17:\"session.timer.now\";i:1590474740;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\":2:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";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:\"81c0bf5a6e3d3e5eccbf7ab63a7ef83a\";s:12:\"tracker.ssid\";s:32:\"81c0bf5a6e3d3e5eccbf7ab63a7ef83a\";s:12:\"tracker.rsid\";s:32:\"81c0bf5a6e3d3e5eccbf7ab63a7ef83a\";}',`time` = '1590474740',`ip` = '10.111.11.10'
      WHERE `session_id` = '81c0bf5a6e3d3e5eccbf7ab63a7ef83a'

56 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 16 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 3 × SELECT *
      FROM `jos_resource_types`
  3. 3 × 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='14795'
  4. 2 × SELECT authorid as uidNumber, ordering
      FROM `jos_author_assoc`
  5. 2 × SELECT r.id
      FROM `jos_tool` as t
      LEFT JOIN `jos_resources` as r
      ON r.alias = t.toolname
  6. 2 × SELECT DISTINCT a.uid as uidNumber, a.ordering
      FROM `jos_tool_authors` as a
  7. 2 × SELECT *
      FROM `jos_xgroups`
  8. 2 × SELECT cn
      FROM jos_tool_groups
  9. 2 × SELECT *
      FROM `jos_resources`
  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 data
      FROM `jos_session`
  12. 2 × SELECT *
      FROM `jos_assets`
  13. 1 × SELECT middleware
      FROM jos_tool_version_middleware AS aux
  14. 1 × SELECT a.rules
      FROM `jos_assets` AS `a`
  15. 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
  16. 1 × SELECT alias
      FROM jos_tool_version_alias AS aux
  17. 1 × SELECT hostreq
      FROM jos_tool_version_hostreq AS aux
  18. 1 × SELECT *
      FROM jos_tool_version
  19. 1 × SELECT instance
      FROM jos_tool_version AS aux
  20. 1 × SELECT *
      FROM `jos_resource_sponsors`
  21. 1 × SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
  22. 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
  23. 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
  24. 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
  25. 1 × SELECT id,toolname,title,registered,registered_by,state_changed,ticketid,published,state,priority
      FROM jos_tool
  26. 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
  27. 1 × SELECT tv.toolname, tg.cn
      FROM `jos_tool_groups` AS tg, `jos_tool_version` AS tv
  28. 1 × SELECT uid
      FROM jos_tool_authors
  29. 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
  30. 1 × SELECT *
      FROM `jos_author_assoc`
  31. 1 × SELECT *
      FROM `jos_resource_ratings`
  32. 1 × SELECT *
      FROM `jos_resource_stats_tools`
  33. 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
  34. 1 × SELECT session_id
      FROM `jos_session`
  35. 1 × SELECT *
      FROM `jos_viewlevels
  36. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  37. 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
  38. 1 × SELECT *
      FROM `jos_resource_stats_clusters`
  39. 1 × SELECT *
      FROM `jos_citations`
      INNER JOIN jos_citations_assoc
      ON jos_citations_assoc.cid = jos_citations.id
  40. 1 × SELECT *
      FROM `jos_wishlist_ownergroups`
  41. 1 × SELECT *
      FROM `jos_wishlist_owners`
  42. 1 × SELECT COUNT(jos_wishlist_item.id) AS count
      FROM `jos_wishlist_item`
  43. 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
  44. 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
  45. 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
  46. 1 × SELECT *
      FROM `jos_wishlist`
  47. 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:1590474740;s:18:\"session.timer.last\";i:1590474740;s:17:\"session.timer.now\";i:1590474740;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\":2:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";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:\"81c0bf5a6e3d3e5eccbf7ab63a7ef83a\";s:12:\"tracker.ssid\";s:32:\"81c0bf5a6e3d3e5eccbf7ab63a7ef83a\";s:12:\"tracker.rsid\";s:32:\"81c0bf5a6e3d3e5eccbf7ab63a7ef83a\";}',`time` = '1590474740',`ip` = '10.111.11.10'
  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 ('81c0bf5a6e3d3e5eccbf7ab63a7ef83a','0','1590474740','10.111.11.10'
  • 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
  • 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