Wish List - Wish List: Wish #6

<Member picture

0 Like 0 Dislike

Ali Irmak Ozdagli

from sql db to dataview

obviously,  dataview is one huge relational database. So, are there any research team who are collecting data in relational DBs?

are you somehow going to support SQL/noSQL to datacenterhub conversion/injection?

Comments (2)

  1. Chambers 03224990573 Chambers

    Its looking very nice.I am really big admirer of your posting style and whenever submit essay writing help work must prefer to visit this link for more updates.

    Reply Report abuse

    Please login to comment.

  2. Chambers 03224990573 Chambers

    Its looking very nice.I am really big admirer of your posting style and whenever submit essay writing help work must prefer to visit this link for more updates.

    Reply Report abuse

    Please login to comment.

Debug Console

Close20 MBRequestSessionTimelineDatabase46Events21
$_GET
Array( ) Array(

)
$_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/wish/6,
REDIRECT_SCRIPT_URI => https://datacenterhub.org/wishlist/general/1/wish/6,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => datacenterhub.org,
REDIRECT_STATUS => 200,
HTTP_AUTHORIZATION => ,
SCRIPT_URL => /wishlist/general/1/wish/6,
SCRIPT_URI => https://datacenterhub.org/wishlist/general/1/wish/6,
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, 25 Jan 2020 20:01:48 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 => 3.228.11.9,
DOCUMENT_ROOT => /var/www/datacenterhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/datacenterhub/index.php,
REMOTE_PORT => 40908,
REDIRECT_URL => /wishlist/general/1/wish/6,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /wishlist/general/1/wish/6,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1596947928.3609,
REQUEST_TIME => 1596947928,
argv => Array(

)
,
argc => 0
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid ffe6f1677f49cdd18c1a2cb28cdc674b
tracker.ssid ffe6f1677f49cdd18c1a2cb28cdc674b
tracker.rsid ffe6f1677f49cdd18c1a2cb28cdc674b
session.token 8ccced38ce4ee17542508eb4aeef55e0
  • site 0.048 seconds (+0.048); 12.25 MB (+12.250) - afterInitialise
  • site 0.070 seconds (+0.021); 13.50 MB (+1.250) - afterRoute
  • site 0.134 seconds (+0.064); 19.50 MB (+6.000) - afterDispatch
  • site 0.141 seconds (+0.007); 19.50 MB (0.000) - beforeRenderModule mod_custom (Footer: info and navigation)
  • site 0.143 seconds (+0.002); 19.50 MB (0.000) - afterRenderModule mod_custom (Footer: info and navigation)
  • site 0.143 seconds (+0.000); 19.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.159 seconds (+0.016); 19.75 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.163 seconds (+0.004); 20.25 MB (+0.500) - onAfterRender
  • site 0.165 seconds (+0.002); 20.25 MB (0.000) - sessionStore
20 MB

46 Queries Logged: 0.011632919311523 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'cb95ede347c4b892e7e426adefeba2ee'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = 'cb95ede347c4b892e7e426adefeba2ee'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = 'ffe6f1677f49cdd18c1a2cb28cdc674b'
  4. DELETE
      FROM `jos_session`
      WHERE `time` < '1596944328'
  5. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  6. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = 'ffe6f1677f49cdd18c1a2cb28cdc674b'
      LIMIT 1
  7. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('ffe6f1677f49cdd18c1a2cb28cdc674b','0','1596947928','3.228.11.9')
  8. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  9. 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'
  10. SELECT *
      FROM `jos_viewlevels`
  11. 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
  12. 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
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  14. 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
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  16. SELECT *
      FROM `jos_wishlist_item`
      WHERE `jos_wishlist_item`.`id` = '6'
  17. SELECT *
      FROM `jos_wishlist`
      WHERE `jos_wishlist`.`id` = '1'
  18. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  19. 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
  20. SELECT *
      FROM `jos_xgroups`
      WHERE cn = 'hubdev';
  21. SELECT *
      FROM `jos_wishlist_ownergroups`
      WHERE `jos_wishlist_ownergroups`.`wishlist` = '1'
  22. SELECT *
      FROM `jos_wishlist_owners`
      WHERE `jos_wishlist_owners`.`wishlist` = '1'
      AND `jos_wishlist_owners`.`type` != '2'
  23. SELECT *
      FROM `jos_wishlist_vote`
      WHERE `jos_wishlist_vote`.`wishid` = '6'
  24. SELECT id AS value,name AS text
      FROM `jos_users`
      WHERE `block` = '0'
      AND `id` IN ('')
      ORDER BY `name` ASC
  25. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1059'
  26. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1059';
  27. SELECT COUNT(jos_vote_log.id) AS count
      FROM `jos_vote_log`
      WHERE `jos_vote_log`.`referenceid` = '6'
      AND `jos_vote_log`.`category` = 'wish'
      AND `jos_vote_log`.`helpful` = 'yes'
  28. SELECT COUNT(jos_vote_log.id) AS count
      FROM `jos_vote_log`
      WHERE `jos_vote_log`.`referenceid` = '6'
      AND `jos_vote_log`.`category` = 'wish'
      AND `jos_vote_log`.`helpful` = 'no'
  29. 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` = '6'
      AND `jos_tags`.`admin` NOT IN ('1')
      GROUP BY jos_tags_object.label,jos_tags.id
  30. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  31. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`item_id` = '6'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`parent` = '0'
      AND `jos_item_comments`.`state` IN ('1','3')
  32. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '2418'
  33. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '2418';
  34. SELECT *
      FROM `jos_wish_attachments`
      WHERE `jos_wish_attachments`.`comment_id` = '45'
  35. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  36. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`parent` = '45'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`item_id` = '6'
      AND `jos_item_comments`.`state` IN ('1','3')
  37. SELECT *
      FROM `jos_wish_attachments`
      WHERE `jos_wish_attachments`.`comment_id` = '46'
  38. SELECT *
      FROM `jos_item_comments`
      WHERE `jos_item_comments`.`parent` = '46'
      AND `jos_item_comments`.`item_type` = 'wish'
      AND `jos_item_comments`.`item_id` = '6'
      AND `jos_item_comments`.`state` IN ('1','3')
  39. 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 04:38:48' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2020-08-09 04:38:48' )
      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
  40. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  41. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  42. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  43. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_usage'
  44. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  45. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_feedback'
  46. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1596947928;s:18:\"session.timer.last\";i:1596947928;s:17:\"session.timer.now\";i:1596947928;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:\"ffe6f1677f49cdd18c1a2cb28cdc674b\";s:12:\"tracker.ssid\";s:32:\"ffe6f1677f49cdd18c1a2cb28cdc674b\";s:12:\"tracker.rsid\";s:32:\"ffe6f1677f49cdd18c1a2cb28cdc674b\";s:13:\"session.token\";s:32:\"8ccced38ce4ee17542508eb4aeef55e0\";}',`time` = '1596947928',`ip` = '3.228.11.9'
      WHERE `session_id` = 'ffe6f1677f49cdd18c1a2cb28cdc674b'

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. 3 × SELECT *
      FROM `jos_item_comments`
  3. 2 × SELECT *
      FROM `jos_users`
  4. 2 × SELECT data
      FROM `jos_session`
  5. 2 × SELECT *
      FROM `jos_xprofiles`
  6. 2 × SELECT COUNT(jos_vote_log.id) AS count
      FROM `jos_vote_log`
  7. 2 × SELECT *
      FROM `jos_wish_attachments`
  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. 2 × DELETE
      FROM `jos_session`
  2. 1 × UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1596947928;s:18:\"session.timer.last\";i:1596947928;s:17:\"session.timer.now\";i:1596947928;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:\"ffe6f1677f49cdd18c1a2cb28cdc674b\";s:12:\"tracker.ssid\";s:32:\"ffe6f1677f49cdd18c1a2cb28cdc674b\";s:12:\"tracker.rsid\";s:32:\"ffe6f1677f49cdd18c1a2cb28cdc674b\";s:13:\"session.token\";s:32:\"8ccced38ce4ee17542508eb4aeef55e0\";}',`time` = '1596947928',`ip` = '3.228.11.9'
  3. 1 × INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('ffe6f1677f49cdd18c1a2cb28cdc674b','0','1596947928','3.228.11.9'
  • 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