Debug Console

Close32 MBRequestSessionTimelineDatabase75Events53
$_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 => /members/1016/collections,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/members/1016/collections,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /members/1016/collections,
SCRIPT_URI => https://datacenterhub.org/members/1016/collections,
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 => 46797,
REDIRECT_URL => /members/1016/collections,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /members/1016/collections,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1590471580.1025,
REQUEST_TIME => 1590471580,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid c6e19760315f38a30aa4a47f9a9691c9
tracker.ssid c6e19760315f38a30aa4a47f9a9691c9
tracker.rsid c6e19760315f38a30aa4a47f9a9691c9
  • site 0.046 seconds (+0.046); 12.25 MB (+12.250) - afterInitialise
  • site 0.065 seconds (+0.019); 13.50 MB (+1.250) - afterRoute
  • site 0.407 seconds (+0.342); 30.50 MB (+17.000) - afterDispatch
  • site 0.415 seconds (+0.008); 30.75 MB (+0.250) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.417 seconds (+0.002); 31.00 MB (+0.250) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.417 seconds (+0.000); 31.00 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.434 seconds (+0.017); 31.50 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.438 seconds (+0.004); 31.75 MB (+0.250) - onAfterRender
  • site 0.441 seconds (+0.003); 31.75 MB (0.000) - sessionStore
32 MB

75 Queries Logged: 0.087884664535522 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '63dc38dbddcc1448ddb2116dcb337a85'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '63dc38dbddcc1448ddb2116dcb337a85'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'c6e19760315f38a30aa4a47f9a9691c9'
  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` = 'c6e19760315f38a30aa4a47f9a9691c9'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('c6e19760315f38a30aa4a47f9a9691c9','0','1590471580','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_tags'
  14. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1016'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_jobs'
  17. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  18. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  19. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_publications'
  20. SHOW FULL COLUMNS
      FROM `jos_jobs_employers`
  21. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  22. 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_members.component'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  23. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  24. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  25. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2020-05-26 05:39:40'
  26. SELECT *
      FROM `jos_xgroups_inviteemails`
      WHERE `jos_xgroups_inviteemails`.`email` = 'csim@unl.edu'
  27. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_applicants` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1016 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_members` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1016 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_managers` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1016 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_invitees` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1016 )
  28. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  29. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      LEFT JOIN jos_author_assoc
      ON jos_author_assoc.subid = jos_resources.id
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` IN ('1')
      AND `jos_author_assoc`.`subtable` = 'resources'
      AND `jos_author_assoc`.`authorid` = '1016'
      AND `jos_author_assoc`.`role` != 'submitter'
      AND `jos_resources`.`access` IN ('0','3')
  30. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  31. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`created_by` = '1016'
      AND `jos_wiki_versions`.`approved` = '1'
      GROUP BY page_id,id
  32. SELECT COUNT(jos_wiki_pages.id) AS count
      FROM `jos_wiki_pages`
      WHERE `jos_wiki_pages`.`state` = '1'
      AND `jos_wiki_pages`.`scope` = 'site'
      AND `jos_wiki_pages`.`id` IN ('30','31','31','31','31','268','276')
  33. SHOW FULL COLUMNS
      FROM `jos_publications`
  34. SELECT *
      FROM `jos_publication_categories`
      WHERE `jos_publication_categories`.`state` = '1'
      ORDER BY `name` ASC
  35. SELECT COUNT(jos_publication_versions.id) AS count
      FROM `jos_publication_versions`
      INNER JOIN jos_publications
      ON jos_publications.id = jos_publication_versions.publication_id
      LEFT JOIN jos_publication_authors
      ON jos_publication_authors.publication_version_id = jos_publication_versions.id
      WHERE `jos_publication_versions`.`state` IN ('1')
      AND `jos_publication_authors`.`user_id` = '1016'
      AND (`jos_publication_authors`.`role` IS NULL OR `jos_publication_authors`.`role` != 'submitter' )
      AND `jos_publication_versions`.`access` IN ('0','3')
  36. SHOW TABLES
  37. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  38. SHOW FULL COLUMNS
      FROM `jos_collections`
  39. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.access='0'
      AND b.object_id='1016'
      AND b.object_type='member'
  40. SELECT DISTINCT b.*, im.id AS item_id, im.positive AS likes, f.following_id AS following, (SELECT COUNT(*)
      FROM `jos_collections_items` AS i
      INNER JOIN `jos_collections_posts` AS s
      ON s.item_id=i.id
      WHERE s.collection_id=b.id
      AND i.state=1
      AND i.access='0') AS posts
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.access='0'
      AND b.object_id='1016'
      AND b.object_type='member'
      ORDER BY created DESC
      LIMIT 0,20
  41. SHOW FULL COLUMNS
      FROM `jos_collections_posts`
  42. SELECT COUNT(*)
      FROM jos_collections_posts AS p
      INNER JOIN jos_collections AS c
      ON c.id=p.collection_id
      INNER JOIN jos_collections_items AS i
      ON p.item_id=i.id
      LEFT JOIN jos_users AS u
      ON p.created_by=u.id
      WHERE c.object_id='1016'
      AND c.object_type='member'
      AND i.state='1'
      AND c.state='1'
      AND i.access='0'
      AND c.access='0'
  43. SHOW FULL COLUMNS
      FROM `jos_collections_following`
  44. SELECT COUNT(*)
      FROM jos_collections_following AS f
      WHERE f.following_id='1016'
      AND f.following_type='member'
  45. SELECT COUNT(*)
      FROM jos_collections_following AS f
      WHERE f.follower_id='1016'
      AND f.follower_type='member'
  46. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_help'
  47. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.object_id='1016'
      AND b.object_type='member'
  48. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.access='0'
      AND b.object_id='1016'
      AND b.object_type='member'
  49. SELECT COUNT(jos_xmessage_recipient.id) AS count
      FROM `jos_xmessage_recipient`
      INNER JOIN jos_xmessage
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      LEFT JOIN jos_xmessage_seen
      ON jos_xmessage_seen.mid=jos_xmessage.id
      AND jos_xmessage_seen.uid=1016
      WHERE `jos_xmessage_recipient`.`uid` = '1016'
      AND `jos_xmessage_recipient`.`state` = '0'
  50. SELECT COUNT(jos_xmessage.id) AS count
      FROM `jos_xmessage`
      INNER JOIN jos_xmessage_recipient
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      WHERE `jos_xmessage_recipient`.`uid` = '1016'
      AND `jos_xmessage_recipient`.`state` != '2'
      AND jos_xmessage.id NOT IN (SELECT s.mid
      FROM `jos_xmessage_seen` AS s
      WHERE s.uid=1016)
  51. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2020-05-26 05:39:40'
  52. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2020-05-26 05:39:40'
  53. SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2020-05-26 05:39:40'
  54. SHOW TABLES
  55. SELECT *
      FROM `jos_users_points`
      WHERE `jos_users_points`.`uid` = '1016'
  56. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  57. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '1016'
      AND `jos_blog_entries`.`state` IN ('1')
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` IS NULL OR `jos_blog_entries`.`publish_up` <= '2020-05-26 05:39:40' )
      AND (`jos_blog_entries`.`publish_down` IS NULL OR `jos_blog_entries`.`publish_down` >= '2020-05-26 05:39:40' )
  58. SHOW FULL COLUMNS
      FROM `jos_projects`
  59. SELECT count(DISTINCT p.id)
      FROM jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid='1016'
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.owned_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
      WHERE (o.userid='1016'
      AND o.status!=2
      AND p.state NOT IN (2, 3)
      AND ((p.setup_stage >= '2') OR (o.role = 1
      AND p.owned_by_user='1016')))
      AND p.provisioned = 0
  60. SHOW FULL COLUMNS
      FROM `jos_project_owners`
  61. SELECT p.alias, p.title, o.*
      FROM jos_project_owners AS o
      INNER JOIN `jos_projects` AS p
      ON p.id=o.projectid
      WHERE o.userid=0
      AND o.status=0
      AND o.invited_email='csim@unl.edu'
  62. SELECT jos_citations.*,u.username,F.format AS template,CS.sec_cits_cnt AS sec_cnt
      FROM `jos_citations`
      LEFT JOIN jos_users AS u
      ON jos_citations.uid = u.id
      LEFT JOIN jos_citations_secondary AS CS
      ON jos_citations.id = CS.cid
      LEFT JOIN jos_citations_format AS F
      ON jos_citations.format = F.style
      WHERE `jos_citations`.`scope` = 'member'
      AND `jos_citations`.`scope_id` = '1016'
      AND `jos_citations`.`published` IN ('1')
  63. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = 'user'
      AND `jos_activity_recipients`.`scope_id` = '1016'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` IS NULL
  64. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM jos_xgroups AS g, jos_xgroups_managers AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_invitees AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 )
  65. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1016 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1016 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM jos_xgroups AS g, jos_xgroups_managers AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1016 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_invitees AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1016 )
  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 05:39:40' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-05-26 05:39:40' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '83' 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_groups'
  72. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  73. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  74. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  75. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590471580;s:18:\"session.timer.last\";i:1590471580;s:17:\"session.timer.now\";i:1590471580;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:\"c6e19760315f38a30aa4a47f9a9691c9\";s:12:\"tracker.ssid\";s:32:\"c6e19760315f38a30aa4a47f9a9691c9\";s:12:\"tracker.rsid\";s:32:\"c6e19760315f38a30aa4a47f9a9691c9\";}',`time` = '1590471580',`ip` = '10.111.11.10'
      WHERE `session_id` = 'c6e19760315f38a30aa4a47f9a9691c9'

46 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 20 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 4 × SELECT e.id
      FROM `jos_jobs_employers` AS e JOIN `jos_users_points_subscriptions` AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
  3. 3 × SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
  4. 2 × SELECT COUNT(*)
      FROM jos_collections_following AS f
  5. 2 × SELECT *
      FROM `jos_assets`
  6. 2 × SELECT data
      FROM `jos_session`
  7. 1 × SELECT DISTINCT b.*, im.id AS item_id, im.positive AS likes, f.following_id AS following, (SELECT COUNT(*)
      FROM `jos_collections_items` AS i
      INNER JOIN `jos_collections_posts` AS s
      ON s.item_id=i.id
  8. 1 × SELECT COUNT(jos_xmessage_recipient.id) AS count
      FROM `jos_xmessage_recipient`
      INNER JOIN jos_xmessage
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      LEFT JOIN jos_xmessage_seen
      ON jos_xmessage_seen.mid=jos_xmessage.id
      AND jos_xmessage_seen.uid=1016
  9. 1 × SELECT COUNT(*)
      FROM jos_collections_posts AS p
      INNER JOIN jos_collections AS c
      ON c.id=p.collection_id
      INNER JOIN jos_collections_items AS i
      ON p.item_id=i.id
      LEFT JOIN jos_users AS u
      ON p.created_by=u.id
  10. 1 × SELECT *
      FROM `jos_users_points`
  11. 1 × SELECT jos_citations.*,u.username,F.format AS template,CS.sec_cits_cnt AS sec_cnt
      FROM `jos_citations`
      LEFT JOIN jos_users AS u
      ON jos_citations.uid = u.id
      LEFT JOIN jos_citations_secondary AS CS
      ON jos_citations.id = CS.cid
      LEFT JOIN jos_citations_format AS F
      ON jos_citations.format = F.style
  12. 1 × SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
  13. 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
  14. 1 × SELECT p.alias, p.title, o.*
      FROM jos_project_owners AS o
      INNER JOIN `jos_projects` AS p
      ON p.id=o.projectid
  15. 1 × SELECT count(DISTINCT p.id)
      FROM jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid='1016'
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.owned_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
  16. 1 × SELECT COUNT(jos_publication_versions.id) AS count
      FROM `jos_publication_versions`
      INNER JOIN jos_publications
      ON jos_publications.id = jos_publication_versions.publication_id
      LEFT JOIN jos_publication_authors
      ON jos_publication_authors.publication_version_id = jos_publication_versions.id
  17. 1 × SELECT *
      FROM `jos_blog_entries`
  18. 1 × SELECT COUNT(jos_xmessage.id) AS count
      FROM `jos_xmessage`
      INNER JOIN jos_xmessage_recipient
      ON jos_xmessage.id = jos_xmessage_recipient.mid
  19. 1 × SELECT *
      FROM `jos_wiki_versions`
  20. 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
  21. 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
  22. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  23. 1 × SELECT *
      FROM `jos_viewlevels
  24. 1 × SELECT session_id
      FROM `jos_session`
  25. 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
  26. 1 × SELECT *
      FROM `jos_users`
  27. 1 × SELECT a.rules
      FROM `jos_assets` AS `a`
  28. 1 × SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      LEFT JOIN jos_author_assoc
      ON jos_author_assoc.subid = jos_resources.id
  29. 1 × SELECT COUNT(jos_wiki_pages.id) AS count
      FROM `jos_wiki_pages`
  30. 1 × SELECT *
      FROM `jos_resource_types`
  31. 1 × SELECT *
      FROM `jos_xgroups_inviteemails`
  32. 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
  33. 1 × SELECT *
      FROM `jos_publication_categories`
OTHER Tables:
  1. 2 × SHOW TABLE
  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 × SHOW FULL COLUMNS
      FROM `jos_collections_following
  4. 1 × SHOW FULL COLUMNS
      FROM `jos_projects
  5. 1 × SHOW FULL COLUMNS
      FROM `jos_project_owners
  6. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1590471580;s:18:\"session.timer.last\";i:1590471580;s:17:\"session.timer.now\";i:1590471580;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:\"c6e19760315f38a30aa4a47f9a9691c9\";s:12:\"tracker.ssid\";s:32:\"c6e19760315f38a30aa4a47f9a9691c9\";s:12:\"tracker.rsid\";s:32:\"c6e19760315f38a30aa4a47f9a9691c9\";}',`time` = '1590471580',`ip` = '10.111.11.10'
  7. 1 × SHOW FULL COLUMNS
      FROM `jos_collections_posts
  8. 1 × SHOW FULL COLUMNS
      FROM `jos_collections
  9. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('c6e19760315f38a30aa4a47f9a9691c9','0','1590471580','10.111.11.10'
  10. 1 × SHOW FULL COLUMNS
      FROM `jos_jobs_employers
  11. 1 × ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_applicants` AS m
  12. 1 × SHOW FULL COLUMNS
      FROM `jos_publications
  13. 1 × DELETE
      FROM `jos_session`
  • 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
  • onMembersAreas Method plgMembersDashboard::onMembersAreas /core/plugins/members/dashboard/dashboard.php:62
  • onMembersAreas Method plgMembersProfile::onMembersAreas /core/plugins/members/profile/profile.php:30
  • onMembersAreas Method plgMembersGroups::onMembersAreas /core/plugins/members/groups/groups.php:30
  • onMembersAreas Method plgMembersAccount::onMembersAreas /core/plugins/members/account/account.php:34
  • onMembersAreas Method plgMembersContributions::onMembersAreas /core/plugins/members/contributions/contributions.php:30
  • onMembersAreas Method plgMembersUsage::onMembersAreas /core/plugins/members/usage/usage.php:30
  • onMembersAreas Method plgMembersCollections::onMembersAreas /core/plugins/members/collections/collections.php:30
  • onMembersAreas Method plgMembersMessages::onMembersAreas /core/plugins/members/messages/messages.php:30
  • onMembersAreas Method plgMembersResume::onMembersAreas /core/plugins/members/resume/resume.php:60
  • onMembersAreas Method plgMembersPoints::onMembersAreas /core/plugins/members/points/points.php:30
  • onMembersAreas Method plgMembersBlog::onMembersAreas /core/plugins/members/blog/blog.php:30
  • onMembersAreas Method plgMembersProjects::onMembersAreas /core/plugins/members/projects/projects.php:46
  • onMembersAreas Method plgMembersCitations::onMembersAreas /core/plugins/members/citations/citations.php:47
  • onMembersAreas Method plgMembersActivity::onMembersAreas /core/plugins/members/activity/activity.php:30
  • onMembersAreas Method plgMembersImpact::onMembersAreas /core/plugins/members/impact/impact.php:80
  • onMembersContributionsAreas Method plgMembersResources::onMembersContributionsAreas /core/plugins/members/resources/resources.php:63
  • onMembersContributionsAreas Method plgMembersWiki::onMembersContributionsAreas /core/plugins/members/wiki/wiki.php:28
  • onMembersContributionsAreas Method plgMembersImpact::onMembersContributionsAreas /core/plugins/members/impact/impact.php:196
  • onMembersContributionsAreas Method plgMembersPublications::onMembersContributionsAreas /core/plugins/members/publications/publications.php:65
  • onMembersContributions Method plgMembersResources::onMembersContributions /core/plugins/members/resources/resources.php:117
  • onMembersContributions Method plgMembersWiki::onMembersContributions /core/plugins/members/wiki/wiki.php:65
  • onMembersContributions Method plgMembersImpact::onMembersContributions /core/plugins/members/impact/impact.php:241
  • onMembersContributions Method plgMembersPublications::onMembersContributions /core/plugins/members/publications/publications.php:102
  • onMembers Method plgMembersDashboard::onMembers /core/plugins/members/dashboard/dashboard.php:88
  • onMembers Method plgMembersProfile::onMembers /core/plugins/members/profile/profile.php:50
  • onMembers Method plgMembersGroups::onMembers /core/plugins/members/groups/groups.php:56
  • onMembers Method plgMembersAccount::onMembers /core/plugins/members/account/account.php:60
  • onMembers Method plgMembersContributions::onMembers /core/plugins/members/contributions/contributions.php:50
  • onMembers Method plgMembersUsage::onMembers /core/plugins/members/usage/usage.php:50
  • onMembers Method plgMembersCollections::onMembers /core/plugins/members/collections/collections.php:50
  • onMembers Method plgMembersMessages::onMembers /core/plugins/members/messages/messages.php:56
  • onMembers Method plgMembersResume::onMembers /core/plugins/members/resume/resume.php:160
  • onMembers Method plgMembersPoints::onMembers /core/plugins/members/points/points.php:56
  • onMembers Method plgMembersBlog::onMembers /core/plugins/members/blog/blog.php:50
  • onMembers Method plgMembersProjects::onMembers /core/plugins/members/projects/projects.php:71
  • onMembers Method plgMembersCitations::onMembers /core/plugins/members/citations/citations.php:67
  • onMembers Method plgMembersActivity::onMembers /core/plugins/members/activity/activity.php:54
  • onMembers Method plgMembersImpact::onMembers /core/plugins/members/impact/impact.php:113
  • 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