Debug Console

$_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 => /community/resources/whatsnew,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/community/resources/whatsnew,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /community/resources/whatsnew,
SCRIPT_URI => https://datacenterhub.org/community/resources/whatsnew,
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_IF_MODIFIED_SINCE => Sun, 05 Apr 2020 09:12:56 PDT,
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 => 17800,
REDIRECT_URL => /community/resources/whatsnew,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /community/resources/whatsnew,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1590474695.6549,
REQUEST_TIME => 1590474695,
argv => Array(

)
,
argc => 0
)

• site 0.045 seconds (+0.045); 12.25 MB (+12.250) - afterInitialise
• site 0.063 seconds (+0.018); 13.50 MB (+1.250) - afterRoute
• site 0.340 seconds (+0.277); 20.00 MB (+6.500) - afterDispatch
• site 0.349 seconds (+0.009); 20.25 MB (+0.250) - beforeRenderModule mod_custom (Footer: info and navigation)
• site 0.351 seconds (+0.002); 20.50 MB (+0.250) - afterRenderModule mod_custom (Footer: info and navigation)
• site 0.351 seconds (+0.000); 20.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
• site 0.365 seconds (+0.015); 20.75 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
• site 0.370 seconds (+0.004); 21.00 MB (+0.250) - onAfterRender
• site 0.372 seconds (+0.003); 21.00 MB (0.000) - sessionStore

1. SELECT data
  FROM `jos_session`
  WHERE `session_id` = '81f7714061c71548cd39f6029bb77024'
2. DELETE
  FROM `jos_session`
  WHERE `session_id` = '81f7714061c71548cd39f6029bb77024'
3. SELECT data
  FROM `jos_session`
  WHERE `session_id` = 'd106e884008fb99475cfc24300b4166b'
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` = 'd106e884008fb99475cfc24300b4166b'
  LIMIT 1
6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
  VALUES ('d106e884008fb99475cfc24300b4166b','0','1590474695','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 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
13. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_whatsnew'
14. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_resources'
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_publications'
17. SELECT *
  FROM `jos_resource_types`
  WHERE `jos_resource_types`.`category` = '27'
  ORDER BY `type` ASC
18. SELECT count(DISTINCT c.id)
  FROM jos_content AS c
  INNER JOIN jos_categories AS b
  ON b.id=c.catid
  WHERE c.publish_up > '2020-04-26 06:31:35'
  AND c.publish_up < '2020-05-26 06:31:35'
  AND c.state='1'
19. SELECT count(DISTINCT e.id)
  FROM jos_events AS e
  WHERE e.created > '2020-04-26 06:31:35'
  AND e.created < '2020-05-26 06:31:35'
  AND scope='events'
20. SELECT COUNT(*)
  FROM `jos_kb_articles` AS f
  LEFT JOIN `jos_categories` AS c
  ON c.id = f.category
  WHERE f.state=1
  AND c.published = 1
  AND f.created > ''
  AND f.created < '2020-05-26 06:31:35'
  AND f.access IN (1,1,4)
21. ( 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 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 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 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 m.gidNumber=g.gidNumber
  AND m.uidNumber=0 )
22. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '68'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
23. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '76'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
24. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '73'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
25. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '6'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
26. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '72'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
27. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '9'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
28. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '69'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
29. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '66'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
30. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '67'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
31. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '10'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
32. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '3'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
33. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '1'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
34. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '31'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
35. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '39'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
36. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '7'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
37. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '77'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
38. SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
  WHERE `jos_resources`.`standalone` = '1'
  AND `jos_resources`.`published` = '1'
  AND `jos_resources`.`type` = '2'
  AND `jos_resources`.`access` IN ('0','3')
  AND `jos_resources`.`publish_up` > '2020-04-26 06:31:35'
  AND `jos_resources`.`publish_up` < '2020-05-26 06:31:35'
39. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_wiki'
40. SELECT *
  FROM `jos_wiki_pages`
  WHERE `jos_wiki_pages`.`state` = '1'
  AND `jos_wiki_pages`.`created` >= '2020-04-26 06:31:35'
  AND `jos_wiki_pages`.`created` < '2020-05-26 06:31:35'
  ORDER BY `created` DESC
41. SHOW FULL COLUMNS
  FROM `jos_publications`
42. SELECT C.id
  FROM jos_publication_versions V
  LEFT JOIN jos_publications C
  ON V.publication_id = C.id
  LEFT JOIN jos_projects PP
  ON PP.id = C.project_id
  LEFT JOIN jos_publication_master_types MT
  ON MT.id = C.master_type
  LEFT JOIN jos_publication_categories AS t
  ON t.id = C.category
  WHERE 1
  AND V.version_number = (SELECT MAX(version_number)
  FROM jos_publication_versions
  WHERE publication_id=C.id
  AND state=1 )
  AND (V.state=1)
  AND (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2020-05-26 06:31:35')
  AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2020-05-26 06:31:35')
  AND V.published_up > '2020-04-26 06:31:35'
  AND V.published_up < '2020-05-26 06:31:35'
  AND V.state != 2
  AND (V.access != 2)
  GROUP BY C.id
43. SELECT c.id, c.title, c.alias, c.created, b.path, CONCAT(c.introtext, c.fulltext) AS text, CONCAT('index.php?option=com_content&task=view&id=', c.id) AS href, NULL AS fsection, b.alias AS category, 'content' AS section, NULL AS subsection
  FROM jos_content AS c
  INNER JOIN jos_categories AS b
  ON b.id=c.catid
  WHERE c.publish_up > '2020-04-26 06:31:35'
  AND c.publish_up < '2020-05-26 06:31:35'
  AND c.state='1'
  ORDER BY publish_up DESC, title
  LIMIT 0,5
44. SELECT e.id, e.title, NULL AS alias, e.content AS itext, NULL AS ftext, e.state, e.created, e.modified, e.publish_up, NULL AS params, CONCAT('index.php?option=com_events&task=details&id=', e.id) AS href, 'events' AS section, NULL AS area, NULL AS category, NULL AS rating, NULL AS times_rated, NULL AS ranking
  FROM jos_events AS e
  WHERE e.created > '2020-04-26 06:31:35'
  AND e.created < '2020-05-26 06:31:35'
  AND scope='events'
  ORDER BY publish_up DESC, title
  LIMIT 0,5
45. SELECT f.id, f.title, f.fulltxt AS `text`, concat('index.php?option=com_kb&section=', coalesce(concat(c.path, '/'), ''), f.alias) AS href, 'kb' AS section, c.alias AS subsection
  FROM `jos_kb_articles` AS f
  LEFT JOIN `jos_categories` AS c
  ON c.id = f.category
  WHERE f.state=1
  AND c.published = 1
  AND f.created > ''
  AND f.created < '2020-05-26 06:31:35'
  AND f.access IN (1,1,4)
  ORDER BY f.created DESC, f.title
  LIMIT 0,5
46. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_kb'
47. ( 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 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 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 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 m.gidNumber=g.gidNumber
  AND m.uidNumber=0 )
48. SELECT *
  FROM `jos_wiki_pages`
  WHERE `jos_wiki_pages`.`state` = '1'
  AND `jos_wiki_pages`.`created` >= '2020-04-26 06:31:35'
  AND `jos_wiki_pages`.`created` < '2020-05-26 06:31:35'
  ORDER BY `created` DESC
  LIMIT 5
49. SELECT *
  FROM `jos_xgroups`
  WHERE gidNumber = '1539';
50. (select uidNumber, 'invitees' AS role
  from jos_xgroups_invitees
  where gidNumber='1539') UNION (select uidNumber, 'applicants' AS role
  from jos_xgroups_applicants
  where gidNumber='1539') UNION (select uidNumber, 'members' AS role
  from jos_xgroups_members
  where gidNumber='1539') UNION (select uidNumber, 'managers' AS role
  from jos_xgroups_managers
  where gidNumber='1539')
51. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_groups'
52. SELECT *
  FROM `jos_wiki_versions`
  WHERE `jos_wiki_versions`.`id` = '385'
53. SELECT *
  FROM `jos_xgroups`
  WHERE gidNumber = '1538';
54. (select uidNumber, 'invitees' AS role
  from jos_xgroups_invitees
  where gidNumber='1538') UNION (select uidNumber, 'applicants' AS role
  from jos_xgroups_applicants
  where gidNumber='1538') UNION (select uidNumber, 'members' AS role
  from jos_xgroups_members
  where gidNumber='1538') UNION (select uidNumber, 'managers' AS role
  from jos_xgroups_managers
  where gidNumber='1538')
55. SELECT *
  FROM `jos_wiki_versions`
  WHERE `jos_wiki_versions`.`id` = '384'
56. SELECT *
  FROM `jos_xgroups`
  WHERE gidNumber = '1537';
57. (select uidNumber, 'invitees' AS role
  from jos_xgroups_invitees
  where gidNumber='1537') UNION (select uidNumber, 'applicants' AS role
  from jos_xgroups_applicants
  where gidNumber='1537') UNION (select uidNumber, 'members' AS role
  from jos_xgroups_members
  where gidNumber='1537') UNION (select uidNumber, 'managers' AS role
  from jos_xgroups_managers
  where gidNumber='1537')
58. SELECT *
  FROM `jos_wiki_versions`
  WHERE `jos_wiki_versions`.`id` = '383'
59. SELECT *
  FROM `jos_xgroups`
  WHERE gidNumber = '1536';
60. (select uidNumber, 'invitees' AS role
  from jos_xgroups_invitees
  where gidNumber='1536') UNION (select uidNumber, 'applicants' AS role
  from jos_xgroups_applicants
  where gidNumber='1536') UNION (select uidNumber, 'members' AS role
  from jos_xgroups_members
  where gidNumber='1536') UNION (select uidNumber, 'managers' AS role
  from jos_xgroups_managers
  where gidNumber='1536')
61. SELECT *
  FROM `jos_wiki_versions`
  WHERE `jos_wiki_versions`.`id` = '382'
62. SELECT *
  FROM `jos_xgroups`
  WHERE gidNumber = '1535';
63. (select uidNumber, 'invitees' AS role
  from jos_xgroups_invitees
  where gidNumber='1535') UNION (select uidNumber, 'applicants' AS role
  from jos_xgroups_applicants
  where gidNumber='1535') UNION (select uidNumber, 'members' AS role
  from jos_xgroups_members
  where gidNumber='1535') UNION (select uidNumber, 'managers' AS role
  from jos_xgroups_managers
  where gidNumber='1535')
64. SELECT *
  FROM `jos_wiki_versions`
  WHERE `jos_wiki_versions`.`id` = '381'
65. SELECT V.*, C.id as id, C.category, C.project_id, C.access as master_access, C.checked_out, C.checked_out_time, C.rating as master_rating, C.group_owner, C.master_type, C.master_doi, C.ranking as master_ranking, C.times_rated as master_times_rated, C.alias, V.id as version_id, t.name AS cat_name, t.alias as cat_alias, t.url_alias as cat_url, PP.alias as project_alias, PP.title as project_title, PP.state as project_status, PP.private as project_private, PP.provisioned as project_provisioned, MT.alias as base, MT.params as type_params, (SELECT vv.version_label
  FROM `jos_publication_versions` as vv
  WHERE vv.publication_id=C.id
  AND vv.state=3
  ORDER BY ID DESC
  LIMIT 1) AS dev_version_label , (SELECT COUNT(*)
  FROM `jos_publication_versions`
  WHERE publication_id=C.id
  AND state!=3) AS versions
  FROM jos_publication_versions V
  LEFT JOIN jos_publications C
  ON V.publication_id = C.id
  LEFT JOIN jos_projects PP
  ON PP.id = C.project_id
  LEFT JOIN jos_publication_master_types MT
  ON MT.id = C.master_type
  LEFT JOIN jos_publication_categories AS t
  ON t.id = C.category
  WHERE 1
  AND V.version_number = (SELECT MAX(version_number)
  FROM jos_publication_versions
  WHERE publication_id=C.id
  AND state=1 )
  AND (V.state=1)
  AND (V.published_up IS NULL OR V.published_up = '0000-00-00 00:00:00' OR V.published_up <= '2020-05-26 06:31:36')
  AND (V.published_down IS NULL OR V.published_down = '0000-00-00 00:00:00' OR V.published_down >= '2020-05-26 06:31:36')
  AND V.published_up > '2020-04-26 06:31:35'
  AND V.published_up < '2020-05-26 06:31:35'
  AND V.state != 2
  AND (V.access != 2)
  GROUP BY C.id
  ORDER BY V.published_up DESC
  LIMIT 0, 5
66. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_users'
67. 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:31:36' )
  AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-05-26 06:31:36' )
  AND `m`.`access` IN ('1','1','4')
  AND `m`.`client_id` = '0'
  AND (`mm`.`menuid` = '20' OR `mm`.`menuid` <= '0' )
  ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
68. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_content'
69. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_categories'
70. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_usage'
71. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_feedback'
72. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_support'
73. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_wishlist'
74. UPDATE `jos_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590474695;s:18:\"session.timer.last\";i:1590474695;s:17:\"session.timer.now\";i:1590474695;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\":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:\"d106e884008fb99475cfc24300b4166b\";s:12:\"tracker.ssid\";s:32:\"d106e884008fb99475cfc24300b4166b\";s:12:\"tracker.rsid\";s:32:\"d106e884008fb99475cfc24300b4166b\";}',`time` = '1590474696',`ip` = '10.111.11.10'
  WHERE `session_id` = 'd106e884008fb99475cfc24300b4166b'

28 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 17 × SELECT COUNT(jos_resources.id) AS count
  FROM `jos_resources`
2. 16 × SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
3. 5 × SELECT *
  FROM `jos_wiki_versions`
4. 5 × SELECT *
  FROM `jos_xgroups`
5. 2 × SELECT data
  FROM `jos_session`
6. 2 × SELECT *
  FROM `jos_wiki_pages`
7. 1 × SELECT C.id
  FROM jos_publication_versions V
  LEFT JOIN jos_publications C
  ON V.publication_id = C.id
  LEFT JOIN jos_projects PP
  ON PP.id = C.project_id
  LEFT JOIN jos_publication_master_types MT
  ON MT.id = C.master_type
  LEFT JOIN jos_publication_categories AS t
  ON t.id = C.category
8. 1 × SELECT e.id, e.title, NULL AS alias, e.content AS itext, NULL AS ftext, e.state, e.created, e.modified, e.publish_up, NULL AS params, CONCAT('index.php?option=com_events&task=details&id=', e.id) AS href, 'events' AS section, NULL AS area, NULL AS category, NULL AS rating, NULL AS times_rated, NULL AS ranking
  FROM jos_events AS e
9. 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
10. 1 × SELECT f.id, f.title, f.fulltxt AS `text`, concat('index.php?option=com_kb&section=', coalesce(concat(c.path, '/'), ''), f.alias) AS href, 'kb' AS section, c.alias AS subsection
  FROM `jos_kb_articles` AS f
  LEFT JOIN `jos_categories` AS c
  ON c.id = f.category
11. 1 × SELECT V.*, C.id as id, C.category, C.project_id, C.access as master_access, C.checked_out, C.checked_out_time, C.rating as master_rating, C.group_owner, C.master_type, C.master_doi, C.ranking as master_ranking, C.times_rated as master_times_rated, C.alias, V.id as version_id, t.name AS cat_name, t.alias as cat_alias, t.url_alias as cat_url, PP.alias as project_alias, PP.title as project_title, PP.state as project_status, PP.private as project_private, PP.provisioned as project_provisioned, MT.alias as base, MT.params as type_params, (SELECT vv.version_label
  FROM `jos_publication_versions` as vv
12. 1 × SELECT count(DISTINCT e.id)
  FROM jos_events AS e
13. 1 × SELECT *
  FROM `jos_viewlevels
14. 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
15. 1 × SELECT session_id
  FROM `jos_session`
16. 1 × SELECT folder AS type,element AS name,protected,params
  FROM `jos_extensions`
17. 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
18. 1 × SELECT *
  FROM `jos_resource_types`
19. 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
20. 1 × SELECT COUNT(*)
  FROM `jos_kb_articles` AS f
  LEFT JOIN `jos_categories` AS c
  ON c.id = f.category

OTHER Tables:

1. 5 × (select uidNumber, 'invitees' AS role
  from jos_xgroups_invitees
2. 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 m
3. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
  VALUES ('d106e884008fb99475cfc24300b4166b','0','1590474695','10.111.11.10'
4. 1 × UPDATE `jos_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590474695;s:18:\"session.timer.last\";i:1590474695;s:17:\"session.timer.now\";i:1590474695;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\":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:\"d106e884008fb99475cfc24300b4166b\";s:12:\"tracker.ssid\";s:32:\"d106e884008fb99475cfc24300b4166b\";s:12:\"tracker.rsid\";s:32:\"d106e884008fb99475cfc24300b4166b\";}',`time` = '1590474696',`ip` = '10.111.11.10'
5. 1 × SELECT c.id, c.title, c.alias, c.created, b.path, CONCAT(c.introtext, c.fulltext) AS text, CONCAT('index.php?option=com_content&task=view&id=', c.id) AS href, NULL AS fsection, b.alias AS category, 'content' AS section, NULL AS subsection
  FROM jos_content AS c
  INNER JOIN jos_categories AS b
  ON b.id=c.catid
6. 1 × SHOW FULL COLUMNS
  FROM `jos_publications
7. 1 × DELETE
  FROM `jos_session`
8. 1 × SELECT count(DISTINCT c.id)
  FROM jos_content AS c
  INNER JOIN jos_categories AS b
  ON b.id=c.catid

• 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
• onWhatsnewAreas — Method — plgWhatsnewContent::onWhatsnewAreas → /core/plugins/whatsnew/content/content.php:28
• onWhatsnewAreas — Method — plgWhatsnewEvents::onWhatsnewAreas → /core/plugins/whatsnew/events/events.php:28
• onWhatsnewAreas — Method — plgWhatsnewKb::onWhatsnewAreas → /core/plugins/whatsnew/kb/kb.php:28
• onWhatsnewAreas — Method — plgWhatsnewResources::onWhatsnewAreas → /core/plugins/whatsnew/resources/resources.php:63
• onWhatsnewAreas — Method — plgWhatsnewWiki::onWhatsnewAreas → /core/plugins/whatsnew/wiki/wiki.php:28
• onWhatsnewAreas — Method — plgWhatsnewPublications::onWhatsnewAreas → /core/plugins/whatsnew/publications/publications.php:65
• onWhatsnew — Method — plgWhatsnewContent::onWhatsnew → /core/plugins/whatsnew/content/content.php:45
• onWhatsnew — Method — plgWhatsnewEvents::onWhatsnew → /core/plugins/whatsnew/events/events.php:45
• onWhatsnew — Method — plgWhatsnewKb::onWhatsnew → /core/plugins/whatsnew/kb/kb.php:45
• onWhatsnew — Method — plgWhatsnewResources::onWhatsnew → /core/plugins/whatsnew/resources/resources.php:102
• onWhatsnew — Method — plgWhatsnewWiki::onWhatsnew → /core/plugins/whatsnew/wiki/wiki.php:45
• onWhatsnew — Method — plgWhatsnewPublications::onWhatsnew → /core/plugins/whatsnew/publications/publications.php:82
• 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