User-friendly tools for your social research

making social media data, analytics, and visualization tools accessible to researchers and students of all levels of expertise

75250450

The Social Media Macroscope is a project by University of Illinois Technology Services and the National Center for Supercomputing Applications (NCSA) with the goal of making social media data, analytics, and visualization tools accessible to researchers and students of all levels of expertise. More information about this project can be found at: https://srtilab.techservices.illinois.edu/projects/

Our tools

SMILE – Social Media Intelligence and Learning Environment

SMILE is an open-source social media analytics tool that allows researchers to collect and analyze social media data. SMILE can perform functions such as text-preprocessing, phrase mining, sentiment analysis, network analysis, and machine learning text classification.

Check it out

BAE – Brand Analytics Environment

BAE helps practitioners to gain insight into how individuals and groups may interact with brands and various organizations. You may find an organization’s perfect “bae” through this tool.

Check it out

Debug Console

Close16 MBRequestSessionTimelineDatabase26Events23
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( USER => apache, HOME => /var/www, FCGI_ROLE => RESPONDER, SCRIPT_URL => /, SCRIP... Array(
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
SCRIPT_URL => /,
SCRIPT_URI => https://socialmediamacroscope.org/,
HTTPS => on,
SSL_TLS_SNI => socialmediamacroscope.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 => Wed, 24 Jul 2019 06:53:00 GMT,
HTTP_HOST => socialmediamacroscope.org,
HTTP_CONNECTION => Keep-Alive,
HTTP_ACCEPT_ENCODING => gzip,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.2.15 (Red Hat),
SERVER_NAME => socialmediamacroscope.org,
SERVER_ADDR => 10.65.128.109,
SERVER_PORT => 443,
REMOTE_ADDR => 3.226.251.81,
DOCUMENT_ROOT => /var/www/smm,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/smm/index.php,
REMOTE_PORT => 36094,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1566254856.6933,
REQUEST_TIME => 1566254856
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 468e67e0c08260011e2e8f4a558cc937
tracker.ssid 468e67e0c08260011e2e8f4a558cc937
tracker.rsid 468e67e0c08260011e2e8f4a558cc937
  • site 0.046 seconds (+0.046); 9.25 MB (+9.250) - afterInitialise
  • site 0.062 seconds (+0.016); 10.75 MB (+1.500) - afterRoute
  • site 0.098 seconds (+0.036); 14.00 MB (+3.250) - beforeRenderModule mod_toptags (Browse Content by Tags)
  • site 0.106 seconds (+0.009); 14.50 MB (+0.500) - afterRenderModule mod_toptags (Browse Content by Tags)
  • site 0.110 seconds (+0.003); 14.75 MB (+0.250) - afterDispatch
  • site 0.115 seconds (+0.005); 15.00 MB (+0.250) - beforeRenderModule mod_search (Search)
  • site 0.117 seconds (+0.002); 15.00 MB (0.000) - afterRenderModule mod_search (Search)
  • site 0.117 seconds (+0.000); 15.00 MB (0.000) - beforeRenderModule mod_googleanalytics (Google Analytics)
  • site 0.118 seconds (+0.001); 15.00 MB (0.000) - afterRenderModule mod_googleanalytics (Google Analytics)
  • site 0.118 seconds (+0.000); 15.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.120 seconds (+0.001); 15.50 MB (+0.500) - afterRenderModule mod_collect (Collect)
  • site 0.120 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_custom (Home: Tools)
  • site 0.121 seconds (+0.001); 15.50 MB (0.000) - afterRenderModule mod_custom (Home: Tools)
  • site 0.121 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_custom (Home intro text)
  • site 0.121 seconds (+0.000); 15.50 MB (0.000) - afterRenderModule mod_custom (Home intro text)
  • site 0.121 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_custom (Home hero)
  • site 0.122 seconds (+0.000); 15.50 MB (0.000) - afterRenderModule mod_custom (Home hero)
  • site 0.122 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.127 seconds (+0.005); 15.50 MB (0.000) - afterRenderModule mod_menu (Main Menu)
  • site 0.127 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.129 seconds (+0.003); 15.50 MB (0.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.132 seconds (+0.003); 15.50 MB (0.000) - onAfterRender
  • site 0.134 seconds (+0.002); 15.50 MB (0.000) - sessionStore
16 MB

26 Queries Logged: 0.010925531387329 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '23dfbaa07211f7fa71fc92b041141b9b'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '23dfbaa07211f7fa71fc92b041141b9b'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '468e67e0c08260011e2e8f4a558cc937'
  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` = '468e67e0c08260011e2e8f4a558cc937'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('468e67e0c08260011e2e8f4a558cc937','0','1566254856','3.226.251.81')
  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_content'
  14. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_categories'
  15. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  16. 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_content'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  17. SELECT a.*,a.id,a.asset_id,a.title,a.alias,a.title_alias,a.introtext,a.fulltext,
      CASE WHEN badcats.id IS NULL THEN a.state ELSE 0 END AS state,a.mask,a.catid,a.created,a.created_by,a.created_by_alias,
      CASE WHEN a.modified IS NULL THEN a.created ELSE a.modified END AS modified,a.modified_by,a.checked_out,a.checked_out_time,a.publish_up,a.publish_down,a.images,a.urls,a.attribs,a.version,a.parentid,a.ordering,a.metakey,a.metadesc,a.access,a.hits,a.metadata,a.featured,a.language,a.xreference,c.title AS category_title,c.alias AS category_alias,c.access AS category_access,u.name AS author,parent.title AS parent_title,parent.id AS parent_id,parent.path AS parent_route,parent.alias AS parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating,v.rating_count AS rating_count
      FROM `jos_content` AS `a`
      LEFT JOIN jos_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      LEFT
      OUTER JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published <= 0
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE `a`.`id` = '1'
      AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= '2019-08-19 22:47:36' )
      AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= '2019-08-19 22:47:36' )
      AND `a`.`state` IN ('1','2')
  18. SELECT c.*,
      CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
      FROM `jos_categories` AS `c`
      LEFT JOIN jos_categories AS s
      ON (s.lft <= c.lft
      AND s.rgt >= c.rgt) OR (s.lft > c.lft
      AND s.rgt < c.rgt)
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (`c`.`extension` = 'com_content' OR `c`.`extension` = 'system' )
      AND `c`.`access` IN ('1','1','4')
      AND `c`.`published` = '1'
      AND `s`.`id` = '2'
      AND badcats.id is null
      GROUP BY c.id,c.asset_id,c.access,c.alias,c.checked_out,c.checked_out_time,c.created_time,c.created_user_id,c.description,c.extension,c.hits,c.language,c.level,c.lft,c.metadata,c.metadesc,c.metakey,c.modified_time,c.note,c.params,c.parent_id,c.path,c.published,c.rgt,c.title,c.modified_user_id
      ORDER BY `c`.`lft` ASC
  19. 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` <= '2019-08-19 22:47:36' )
      AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= '2019-08-19 22:47:36' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '100' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  20. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  21. SELECT *
      FROM `jos_tags`
      WHERE `jos_tags`.`admin` = '0'
      ORDER BY `objects` DESC
      LIMIT 25
  22. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  23. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  25. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_media'
  26. UPDATE `jos_session`
      SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1566254856;s:18:\"session.timer.last\";i:1566254856;s:17:\"session.timer.now\";i:1566254856;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:\"468e67e0c08260011e2e8f4a558cc937\";s:12:\"tracker.ssid\";s:32:\"468e67e0c08260011e2e8f4a558cc937\";s:12:\"tracker.rsid\";s:32:\"468e67e0c08260011e2e8f4a558cc937\";}',`time` = '1566254856',`ip` = '3.226.251.81'
      WHERE `session_id` = '468e67e0c08260011e2e8f4a558cc937'
  • 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 plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:21
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:21
  • 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
  • onContentBeforeDisplay Method plgContentPagenavigation::onContentBeforeDisplay /core/plugins/content/pagenavigation/pagenavigation.php:25
  • onContentBeforeDisplay Method plgContentVote::onContentBeforeDisplay /core/plugins/content/vote/vote.php:32
  • onAfterDispatch Method plgSystemMobile::onAfterDispatch /core/plugins/system/mobile/mobile.php:22
  • 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