Debug Console

$_GET

Array( filterby => all, sortby => submitter, tags => ) Array(
filterby => all,
sortby => submitter,
tags =>
)

$_POST

Array( ) Array(

)

$_COOKIE

Array( ) Array(

)

$_SERVER

Array( NO_PROXY => .s2.internal, https_proxy => http://10.8.63.5:3128, http_proxy => http:/... Array(
NO_PROXY => .s2.internal,
https_proxy => http://10.8.63.5:3128,
http_proxy => http://10.8.63.5:3128,
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /wishlist/general/1,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/wishlist/general/1,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /wishlist/general/1,
SCRIPT_URI => https://datacenterhub.org/wishlist/general/1,
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,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
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 => 57027,
REDIRECT_QUERY_STRING => filterby=all&sortby=submitter&tags=,
REDIRECT_URL => /wishlist/general/1,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => filterby=all&sortby=submitter&tags=,
REQUEST_URI => /wishlist/general/1?filterby=all&sortby=submitter&tags=,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1591083212.2662,
REQUEST_TIME => 1591083212,
argv => Array(
0 => filterby=all&sortby=submitter&tags=
)
,
argc => 1
)

• site 0.048 seconds (+0.048); 12.25 MB (+12.250) - afterInitialise
• site 0.068 seconds (+0.020); 13.50 MB (+1.250) - afterRoute
• site 0.247 seconds (+0.179); 18.25 MB (+4.750) - afterDispatch
• site 0.255 seconds (+0.008); 18.75 MB (+0.500) - beforeRenderModule mod_custom (Footer: info and navigation)
• site 0.257 seconds (+0.002); 18.75 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
• site 0.257 seconds (+0.000); 18.75 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
• site 0.273 seconds (+0.016); 19.00 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
• site 0.279 seconds (+0.007); 19.25 MB (+0.250) - onAfterRender
• site 0.287 seconds (+0.008); 19.25 MB (0.000) - sessionStore

1. SELECT data
  FROM `jos_session`
  WHERE `session_id` = '591094007615b5d4a687829d8b6e975f'
2. DELETE
  FROM `jos_session`
  WHERE `session_id` = '591094007615b5d4a687829d8b6e975f'
3. SELECT data
  FROM `jos_session`
  WHERE `session_id` = '474b4562643c039eb05e7d4b8aa6450d'
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` = '474b4562643c039eb05e7d4b8aa6450d'
  LIMIT 1
6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
  VALUES ('474b4562643c039eb05e7d4b8aa6450d','0','1591083212','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_wishlist'
13. 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
14. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_tags'
15. SELECT *
  FROM `jos_wishlist`
  WHERE `jos_wishlist`.`referenceid` = '1'
  AND `jos_wishlist`.`category` = 'general'
16. SELECT a.rules
  FROM `jos_assets` AS `a`
  WHERE `a`.`id` = '1'
  GROUP BY a.id, a.rules, a.lft
17. 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_wishlist'
  GROUP BY b.id, b.rules, b.lft
  ORDER BY `b`.`lft` ASC
18. SELECT COUNT(jos_wishlist_item.id) AS count
  FROM `jos_wishlist_item`
  WHERE `jos_wishlist_item`.`wishlist` = '1'
  AND `jos_wishlist_item`.`status` != '2'
  AND `jos_wishlist_item`.`private` = '0'
19. SELECT jos_wishlist_item.*,(SELECT COUNT(*)
  FROM `jos_vote_log` AS v
  WHERE v.helpful='yes'
  AND v.category='wish'
  AND v.referenceid=jos_wishlist_item.id) AS positive,(SELECT COUNT(*)
  FROM `jos_vote_log` AS v
  WHERE v.helpful='no'
  AND v.category='wish'
  AND v.referenceid=jos_wishlist_item.id) AS negative,jos_users.name AS authorname
  FROM `jos_wishlist_item`
  LEFT JOIN jos_users
  ON jos_users.id = jos_wishlist_item.proposed_by
  WHERE `jos_wishlist_item`.`wishlist` = '1'
  AND `jos_wishlist_item`.`status` != '2'
  AND `jos_wishlist_item`.`private` = '0'
  ORDER BY `jos_users`.`name` ASC
  LIMIT 20
20. SELECT *
  FROM `jos_users`
  WHERE `jos_users`.`id` = '1059'
21. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '3'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
22. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '4'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
23. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '6'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
24. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '7'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
25. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '16'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
26. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '18'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
27. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '20'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
28. SELECT *
  FROM `jos_users`
  WHERE `jos_users`.`id` = '1078'
29. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '24'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
30. SELECT *
  FROM `jos_users`
  WHERE `jos_users`.`id` = '2794'
31. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '41'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
32. SELECT *
  FROM `jos_users`
  WHERE `jos_users`.`id` = '2615'
33. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '39'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
34. SELECT *
  FROM `jos_users`
  WHERE `jos_users`.`id` = '1066'
35. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '25'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
36. SELECT *
  FROM `jos_users`
  WHERE `jos_users`.`id` = '1016'
37. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '1'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
38. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '2'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
39. SELECT *
  FROM `jos_users`
  WHERE `jos_users`.`id` = '1049'
40. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '23'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
41. SELECT *
  FROM `jos_users`
  WHERE `jos_users`.`id` = '1053'
42. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '13'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
43. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '19'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
44. SELECT *
  FROM `jos_users`
  WHERE `jos_users`.`id` = '1036'
45. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '26'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
46. SELECT *
  FROM `jos_users`
  WHERE `jos_users`.`id` = '1034'
47. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '27'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
48. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '28'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
49. SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
  WHERE `jos_item_comments`.`item_id` = '34'
  AND `jos_item_comments`.`item_type` = 'wish'
  AND `jos_item_comments`.`parent` = '0'
50. 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` = 'wishlist'
  GROUP BY jos_tags_object.label,jos_tags.id
  ORDER BY `objects` ASC
  LIMIT 10
51. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_users'
52. 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-06-02 07:33:32' )
  AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-06-02 07:33:32' )
  AND `m`.`access` IN ('1','1','4')
  AND `m`.`client_id` = '0'
  AND (`mm`.`menuid` = '92' OR `mm`.`menuid` <= '0' )
  ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
53. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_content'
54. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_categories'
55. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_resources'
56. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_usage'
57. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_groups'
58. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_feedback'
59. SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
  WHERE `type` = 'component'
  AND `element` = 'com_support'
60. UPDATE `jos_session`
  SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1591083212;s:18:\"session.timer.last\";i:1591083212;s:17:\"session.timer.now\";i:1591083212;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:1:\"0\";s:7:\"session\";}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:\"474b4562643c039eb05e7d4b8aa6450d\";s:12:\"tracker.ssid\";s:32:\"474b4562643c039eb05e7d4b8aa6450d\";s:12:\"tracker.rsid\";s:32:\"474b4562643c039eb05e7d4b8aa6450d\";s:13:\"session.token\";s:32:\"c9b4dc0cdf78db10c8bf15f9b286b4eb\";}',`time` = '1591083212',`ip` = '10.111.11.10'
  WHERE `session_id` = '474b4562643c039eb05e7d4b8aa6450d'

20 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 20 × SELECT COUNT(jos_item_comments.id) AS count
  FROM `jos_item_comments`
2. 12 × SELECT extension_id AS id,element AS "option",params,enabled
  FROM `jos_extensions`
3. 10 × SELECT *
  FROM `jos_users`
4. 2 × SELECT data
  FROM `jos_session`
5. 1 × SELECT COUNT(jos_wishlist_item.id) AS count
  FROM `jos_wishlist_item`
6. 1 × SELECT jos_wishlist_item.*,(SELECT COUNT(*)
  FROM `jos_vote_log` AS v
7. 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
8. 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
9. 1 × SELECT jos_tags_object.label,jos_tags.*
  FROM `jos_tags`
  INNER JOIN jos_tags_object
  ON jos_tags_object.tagid = jos_tags.id
10. 1 × SELECT *
  FROM `jos_wishlist`
11. 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
12. 1 × SELECT session_id
  FROM `jos_session`
13. 1 × SELECT *
  FROM `jos_viewlevels
14. 1 × SELECT folder AS type,element AS name,protected,params
  FROM `jos_extensions`
15. 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
16. 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
17. 1 × SELECT a.rules
  FROM `jos_assets` AS `a`

OTHER Tables:

1. 1 × UPDATE `jos_session`
  SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1591083212;s:18:\"session.timer.last\";i:1591083212;s:17:\"session.timer.now\";i:1591083212;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:1:\"0\";s:7:\"session\";}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:\"474b4562643c039eb05e7d4b8aa6450d\";s:12:\"tracker.ssid\";s:32:\"474b4562643c039eb05e7d4b8aa6450d\";s:12:\"tracker.rsid\";s:32:\"474b4562643c039eb05e7d4b8aa6450d\";s:13:\"session.token\";s:32:\"c9b4dc0cdf78db10c8bf15f9b286b4eb\";}',`time` = '1591083212',`ip` = '10.111.11.10'
2. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
  VALUES ('474b4562643c039eb05e7d4b8aa6450d','0','1591083212','10.111.11.10'
3. 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
• 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