Wish List - datacenterhub

Search for Wishes
  1. filter x
Granted tagged with "filter" (0 - 0 of 0)

There are currently no wishes on this list based on your search selection.

Debug Console

Close18 MBRequestSessionTimelineDatabase30Events15
$_GET
Array( filterby => granted, sortby => submitter, tags => filter ) Array(
filterby => granted,
sortby => submitter,
tags => filter
)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( NO_PROXY => .s2.internal, https_proxy => http://10.8.63.5:3128, http_proxy => http:/... Array(
NO_PROXY => .s2.internal,
https_proxy => http://10.8.63.5:3128,
http_proxy => http://10.8.63.5:3128,
LD_LIBRARY_PATH => /usr/local/lib:/usr/lib64/:/opt/rh/rh-python36/root/usr/lib64/:/opt/remi/php56/root/usr/lib64,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
REDIRECT_HTTP_AUTHORIZATION => ,
REDIRECT_SCRIPT_URL => /wishlist/general/1,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/wishlist/general/1,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => datacenterhub.org,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /wishlist/general/1,
SCRIPT_URI => https://datacenterhub.org/wishlist/general/1,
HTTPS => on,
SSL_TLS_SNI => datacenterhub.org,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_IF_MODIFIED_SINCE => Sat, 18 Jan 2020 06:03:04 GMT,
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 => 75.101.173.236,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 48934,
REDIRECT_QUERY_STRING => filterby=granted&sortby=submitter&tags=filter,
REDIRECT_URL => /wishlist/general/1,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => filterby=granted&sortby=submitter&tags=filter,
REQUEST_URI => /wishlist/general/1?filterby=granted&sortby=submitter&tags=filter,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1597014742.4181,
REQUEST_TIME => 1597014742,
argv => Array(
0 => filterby=granted&sortby=submitter&tags=filter
)
,
argc => 1
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 341d5d0c138f599f7eae75ac5c52096d
tracker.ssid 341d5d0c138f599f7eae75ac5c52096d
tracker.rsid 341d5d0c138f599f7eae75ac5c52096d
  • site 0.045 seconds (+0.045); 12.25 MB (+12.250) - afterInitialise
  • site 0.065 seconds (+0.020); 13.50 MB (+1.250) - afterRoute
  • site 0.105 seconds (+0.039); 17.25 MB (+3.750) - afterDispatch
  • site 0.114 seconds (+0.010); 17.75 MB (+0.500) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.116 seconds (+0.002); 17.75 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.116 seconds (+0.000); 17.75 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.132 seconds (+0.016); 18.25 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.136 seconds (+0.004); 18.50 MB (+0.250) - onAfterRender
  • site 0.139 seconds (+0.002); 18.50 MB (0.000) - sessionStore
18 MB

30 Queries Logged: 0.0088083744049072 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'ec4164e7e3e8f4f12a28d88334973ecd'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = 'ec4164e7e3e8f4f12a28d88334973ecd'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '341d5d0c138f599f7eae75ac5c52096d'
  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` = '341d5d0c138f599f7eae75ac5c52096d'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('341d5d0c138f599f7eae75ac5c52096d','0','1597014742','75.101.173.236')
  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`
      LEFT JOIN jos_tags_object
      ON jos_tags_object.objectid = jos_wishlist_item.id
      LEFT JOIN jos_tags
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_wishlist_item`.`wishlist` = '1'
      AND `jos_wishlist_item`.`status` = '1'
      AND `jos_wishlist_item`.`private` = '0'
      AND `jos_tags_object`.`tbl` = 'wishlist'
      AND (`jos_tags`.`tag` IN ('filter') )
      GROUP BY jos_wishlist_item.id
  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_tags_object
      ON jos_tags_object.objectid = jos_wishlist_item.id
      LEFT JOIN jos_tags
      ON jos_tags_object.tagid = jos_tags.id
      LEFT JOIN jos_users
      ON jos_users.id = jos_wishlist_item.proposed_by
      WHERE `jos_wishlist_item`.`wishlist` = '1'
      AND `jos_wishlist_item`.`status` = '1'
      AND `jos_wishlist_item`.`private` = '0'
      AND `jos_tags_object`.`tbl` = 'wishlist'
      AND (`jos_tags`.`tag` IN ('filter') )
      GROUP BY jos_wishlist_item.id
      ORDER BY `jos_users`.`name` ASC
      LIMIT 20
  20. 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
  21. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  22. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE `m`.`published` = '1'
      AND `e`.`enabled` = '1'
      AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= '2020-08-09 23:12:22' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-08-09 23:12:22' )
      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
  23. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  25. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  26. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  27. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  28. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  29. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  30. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1597014742;s:18:\"session.timer.last\";i:1597014742;s:17:\"session.timer.now\";i:1597014742;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:\"341d5d0c138f599f7eae75ac5c52096d\";s:12:\"tracker.ssid\";s:32:\"341d5d0c138f599f7eae75ac5c52096d\";s:12:\"tracker.rsid\";s:32:\"341d5d0c138f599f7eae75ac5c52096d\";}',`time` = '1597014742',`ip` = '75.101.173.236'
      WHERE `session_id` = '341d5d0c138f599f7eae75ac5c52096d'

18 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 12 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 2 × SELECT data
      FROM `jos_session`
  3. 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
  4. 1 × SELECT COUNT(jos_wishlist_item.id) AS count
      FROM `jos_wishlist_item`
      LEFT JOIN jos_tags_object
      ON jos_tags_object.objectid = jos_wishlist_item.id
      LEFT JOIN jos_tags
      ON jos_tags_object.tagid = jos_tags.id
  5. 1 × SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
  6. 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
  7. 1 × SELECT a.rules
      FROM `jos_assets` AS `a`
  8. 1 × SELECT jos_wishlist_item.*,(SELECT COUNT(*)
      FROM `jos_vote_log` AS v
  9. 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
  10. 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
  11. 1 × SELECT session_id
      FROM `jos_session`
  12. 1 × SELECT *
      FROM `jos_viewlevels
  13. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  14. 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
  15. 1 × SELECT *
      FROM `jos_wishlist`
OTHER Tables:
  1. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1597014742;s:18:\"session.timer.last\";i:1597014742;s:17:\"session.timer.now\";i:1597014742;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:\"341d5d0c138f599f7eae75ac5c52096d\";s:12:\"tracker.ssid\";s:32:\"341d5d0c138f599f7eae75ac5c52096d\";s:12:\"tracker.rsid\";s:32:\"341d5d0c138f599f7eae75ac5c52096d\";}',`time` = '1597014742',`ip` = '75.101.173.236'
  2. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('341d5d0c138f599f7eae75ac5c52096d','0','1597014742','75.101.173.236'
  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