Wish List - Wish List: Wish #23

<Member picture

0 Like 0 Dislike

HyunGu Jeong

order of columns in datasets

 It would be more convenient to have the order in datasets as below 

  Title/ ID/ report/ data/pics or drawings and then keywords/sources/ compilers.

 This is because, I think, people are more willing to check the report or actual data (files) first . Once they found what they want to read or use then they would check sources later.

 Like this abundant big-data-hub in variety areas,  people get easily annoyed by scrolling to find what they want. (Also, here "datacenterhug.org" requires, we have to scroll from left to right!)

 I am  a 17" laptop (not small) user but I could not see whole columns at once. So I think, the order of columns in datasets needs to be re-ordered for user's convenience as I mentioned above.

( and I do not think column for keywords is really necessary-once you clicked the title, at the bottom of the webpage, you can see the tags "keywords"  or it could be relocated to the last column )

Comments (3)

  1. Jill Pope

    Awww all the pictures are really beautiful and I am happy to share it for exciting reviews on paperwritingpro com forums.Thank you for sharing such nice post.

    Reply Report abuse

    Please login to comment.

  2. Anna shetty Shetty

    I tried a lot in this area, but still haven't found what I want, thank you very much 

    Reply Report abuse

    Please login to comment.

  3. Nelson john Frank

    There is not much in this wishlist, I was expecting a long list actually. There were many reviews about it on https://newyorkessays.com/ and they were very interesting. I think I should also post a wishlist here.

    Reply Report abuse

    Please login to comment.

Debug Console

Close20 MBRequestSessionTimelineDatabase51Events21
$_GET
Array( sortby => date, filterby => all, limit => 20 ) Array(
sortby => date,
filterby => all,
limit => 20
)
$_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/wish/23,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/wishlist/general/1/wish/23,
REDIRECT_HTTPS => on,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /wishlist/general/1/wish/23,
SCRIPT_URI => https://datacenterhub.org/wishlist/general/1/wish/23,
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 => 47085,
REDIRECT_QUERY_STRING => sortby=date&filterby=all&limit=20,
REDIRECT_URL => /wishlist/general/1/wish/23,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => sortby=date&filterby=all&limit=20,
REQUEST_URI => /wishlist/general/1/wish/23?sortby=date&filterby=all&limit=20,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1591086515.4599,
REQUEST_TIME => 1591086515,
argv => Array(
0 => sortby=date&filterby=all&limit=20
)
,
argc => 1
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 190ec7cdde6c9217e2713732c7f63989
tracker.ssid 190ec7cdde6c9217e2713732c7f63989
tracker.rsid 190ec7cdde6c9217e2713732c7f63989
session.token 8ed095bf790850baa75ca2929e74dd2d
  • site 0.052 seconds (+0.052); 12.25 MB (+12.250) - afterInitialise
  • site 0.075 seconds (+0.023); 13.50 MB (+1.250) - afterRoute
  • site 0.153 seconds (+0.078); 19.50 MB (+6.000) - afterDispatch
  • site 0.160 seconds (+0.008); 19.50 MB (0.000) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.162 seconds (+0.002); 19.50 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.162 seconds (+0.000); 19.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.179 seconds (+0.016); 20.00 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.184 seconds (+0.005); 20.00 MB (0.000) - onAfterRender
  • site 0.186 seconds (+0.002); 20.00 MB (0.000) - sessionStore
20 MB

51 Queries Logged: 0.015989303588867 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '002fbcb8b72f62b0d19681392020fb66'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '002fbcb8b72f62b0d19681392020fb66'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '190ec7cdde6c9217e2713732c7f63989'
  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` = '190ec7cdde6c9217e2713732c7f63989'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('190ec7cdde6c9217e2713732c7f63989','0','1591086515','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_item`
      WHERE `jos_wishlist_item`.`id` = '23'
  16. SELECT *
      FROM `jos_wishlist`
      WHERE `jos_wishlist`.`id` = '1'
  17. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  18. 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
  19. SELECT *
      FROM `jos_xgroups`
      WHERE cn = 'hubdev';
  20. SELECT *
      FROM `jos_wishlist_ownergroups`
      WHERE `jos_wishlist_ownergroups`.`wishlist` = '1'
  21. SELECT *
      FROM `jos_wishlist_owners`
      WHERE `jos_wishlist_owners`.`wishlist` = '1'
      AND `jos_wishlist_owners`.`type` != '2'
  22. SELECT *
      FROM `jos_wishlist_vote`
      WHERE `jos_wishlist_vote`.`wishid` = '23'
  23. SELECT id AS value,name AS text
      FROM `jos_users`
      WHERE `block` = '0'
      AND `id` IN ('')
      ORDER BY `name` ASC
  24. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1049'
  25. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1049';
  26. SELECT COUNT(jos_vote_log.id) AS count
      FROM `jos_vote_log`
      WHERE `jos_vote_log`.`referenceid` = '23'
      AND `jos_vote_log`.`category` = 'wish'
      AND `jos_vote_log`.`helpful` = 'yes'
  27. SELECT COUNT(jos_vote_log.id) AS count
      FROM `jos_vote_log`
      WHERE `jos_vote_log`.`referenceid` = '23'
      AND `jos_vote_log`.`category` = 'wish'
      AND `jos_vote_log`.`helpful` = 'no'
  28. 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'
      AND `jos_tags_object`.`objectid` = '23'
      AND `jos_tags`.`admin` NOT IN ('1')
      GROUP BY jos_tags_object.label,jos_tags.id
  29. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  30. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`item_id` = '23'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`parent` = '0'
      AND `jos_item_comments`.`state` IN ('1','3')
  31. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '2446'
  32. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2446';
  33. SELECT *
      FROM `jos_wish_attachments`
      WHERE `jos_wish_attachments`.`comment_id` = '65'
  34. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  35. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`parent` = '65'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`item_id` = '23'
      AND `jos_item_comments`.`state` IN ('1','3')
  36. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '2613'
  37. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2613';
  38. SELECT *
      FROM `jos_wish_attachments`
      WHERE `jos_wish_attachments`.`comment_id` = '104'
  39. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`parent` = '104'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`item_id` = '23'
      AND `jos_item_comments`.`state` IN ('1','3')
  40. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '2718'
  41. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2718';
  42. SELECT *
      FROM `jos_wish_attachments`
      WHERE `jos_wish_attachments`.`comment_id` = '134'
  43. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`parent` = '134'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`item_id` = '23'
      AND `jos_item_comments`.`state` IN ('1','3')
  44. 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 08:28:35' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-06-02 08:28:35' )
      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
  45. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  46. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  47. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  48. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  49. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  50. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  51. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1591086515;s:18:\"session.timer.last\";i:1591086515;s:17:\"session.timer.now\";i:1591086515;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:\"190ec7cdde6c9217e2713732c7f63989\";s:12:\"tracker.ssid\";s:32:\"190ec7cdde6c9217e2713732c7f63989\";s:12:\"tracker.rsid\";s:32:\"190ec7cdde6c9217e2713732c7f63989\";s:13:\"session.token\";s:32:\"8ed095bf790850baa75ca2929e74dd2d\";}',`time` = '1591086515',`ip` = '10.111.11.10'
      WHERE `session_id` = '190ec7cdde6c9217e2713732c7f63989'

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:
  1. 12 × SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
  2. 4 × SELECT *
      FROM `jos_item_comments`
  3. 4 × SELECT *
      FROM `jos_xprofiles`
  4. 4 × SELECT *
      FROM `jos_users`
  5. 3 × SELECT *
      FROM `jos_wish_attachments`
  6. 2 × SELECT data
      FROM `jos_session`
  7. 2 × SELECT COUNT(jos_vote_log.id) AS count
      FROM `jos_vote_log`
  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 *
      FROM `jos_wishlist_owners`
  10. 1 × SELECT *
      FROM `jos_wishlist_vote`
  11. 1 × SELECT id AS value,name AS text
      FROM `jos_users`
  12. 1 × SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
  13. 1 × SELECT *
      FROM `jos_wishlist_ownergroups`
  14. 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
  15. 1 × SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
  16. 1 × SELECT *
      FROM `jos_viewlevels
  17. 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
  18. 1 × SELECT session_id
      FROM `jos_session`
  19. 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
  20. 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
  21. 1 × SELECT a.rules
      FROM `jos_assets` AS `a`
  22. 1 × SELECT *
      FROM `jos_wishlist`
  23. 1 × SELECT *
      FROM `jos_wishlist_item`
  24. 1 × SELECT *
      FROM `jos_xgroups`
OTHER Tables:
  1. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1591086515;s:18:\"session.timer.last\";i:1591086515;s:17:\"session.timer.now\";i:1591086515;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:\"190ec7cdde6c9217e2713732c7f63989\";s:12:\"tracker.ssid\";s:32:\"190ec7cdde6c9217e2713732c7f63989\";s:12:\"tracker.rsid\";s:32:\"190ec7cdde6c9217e2713732c7f63989\";s:13:\"session.token\";s:32:\"8ed095bf790850baa75ca2929e74dd2d\";}',`time` = '1591086515',`ip` = '10.111.11.10'
  2. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('190ec7cdde6c9217e2713732c7f63989','0','1591086515','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
  • onContentPrepare Method plgContentLoadmodule::onContentPrepare /core/plugins/content/loadmodule/loadmodule.php:35
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:25
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:35
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:25
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:105
  • onContentPrepare Method plgContentExternalhref::onContentPrepare /core/plugins/content/externalhref/externalhref.php:41
  • 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