Support

Support Options

Submit a Support Ticket

Collections

No posts available at this time.

Debug Console

Close18 MBRequestSessionTimelineDatabase39
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /collections/posts, REDIRECT_SCRIPT_URI => http://chemistryhub.... Array(
REDIRECT_SCRIPT_URL => /collections/posts,
REDIRECT_SCRIPT_URI => http://chemistryhub.org/collections/posts,
REDIRECT_nokeepalive => ,
REDIRECT_STATUS => 200,
SCRIPT_URL => /collections/posts,
SCRIPT_URI => http://chemistryhub.org/collections/posts,
nokeepalive => ,
HTTP_HOST => chemistryhub.org,
HTTP_ACCEPT_ENCODING => x-gzip, gzip, deflate,
HTTP_USER_AGENT => CCBot/2.0 (http://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.2.15 (CentOS),
SERVER_NAME => chemistryhub.org,
SERVER_ADDR => 206.221.159.27,
SERVER_PORT => 80,
REMOTE_ADDR => 54.81.8.73,
DOCUMENT_ROOT => /var/www/chemistryhub,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/chemistryhub/index.php,
REMOTE_PORT => 45356,
REDIRECT_URL => /collections/posts,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.0,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /collections/posts,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1506159052.041,
REQUEST_TIME => 1506159052
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 6544e0cf40d7eac7294856c857965c36
tracker.ssid 6544e0cf40d7eac7294856c857965c36
tracker.rsid 6544e0cf40d7eac7294856c857965c36
securiy_code0 f3333
session.token f8b5b914fb5f5c1d259507a863b8d83b
  • site 0.051 seconds (+0.051); 9.75 MB (+9.750) - afterInitialise
  • site 0.074 seconds (+0.023); 11.50 MB (+1.750) - afterRoute
  • site 0.104 seconds (+0.030); 14.75 MB (+3.250) - afterDispatch
  • site 0.115 seconds (+0.011); 15.25 MB (+0.500) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.117 seconds (+0.002); 15.25 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.117 seconds (+0.000); 15.25 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.119 seconds (+0.001); 15.50 MB (+0.250) - afterRenderModule mod_collect (Collect)
  • site 0.119 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.123 seconds (+0.004); 15.50 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.123 seconds (+0.000); 15.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.155 seconds (+0.032); 16.00 MB (+0.500) - afterRenderModule mod_menu (Main Menu)
  • site 0.155 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.157 seconds (+0.002); 16.00 MB (0.000) - afterRenderModule mod_search (Search)
  • site 0.157 seconds (+0.000); 16.00 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.172 seconds (+0.015); 17.25 MB (+1.250) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.174 seconds (+0.002); 17.50 MB (+0.250) - onAfterRender
  • site 0.176 seconds (+0.002); 17.50 MB (0.000) - sessionStore
18 MB

39 Queries Logged: 0.018506765365601 seconds

  1. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '70b8db5a7327617d47695a28ee82d6f9'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '70b8db5a7327617d47695a28ee82d6f9'
  3. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '6544e0cf40d7eac7294856c857965c36'
  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` = '6544e0cf40d7eac7294856c857965c36'
  6. INSERT INTO `jos_session` (`session_id`, `client_id`, `time`, `ip`)
      VALUES ('6544e0cf40d7eac7294856c857965c36', 0, '1506159052', '54.81.8.73')
  7. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  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 id, rules
      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
  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 m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.client_id = 0
      ORDER BY m.lft
  13. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  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. SHOW FULL COLUMNS
      FROM `jos_collections`
  16. SHOW FULL COLUMNS
      FROM `jos_collections_posts`
  17. SELECT COUNT(*)
      FROM jos_collections_posts AS p
      INNER JOIN jos_collections AS c
      ON c.id=p.collection_id
      INNER JOIN jos_collections_items AS i
      ON p.item_id=i.id
      LEFT JOIN jos_users AS u
      ON p.created_by=u.id
      WHERE i.state='1'
      AND c.state='1'
      AND i.access='0'
      AND c.access='0'
  18. SELECT p.*, c.alias, c.title, c.object_type, c.object_id, u.name, i.title AS item_title, i.description AS item_description, i.url AS item_url, i.created AS item_created, i.created_by AS item_created_by, i.positive AS item_positive, i.state AS item_state, i.access AS item_access, i.negative AS item_negative, i.type AS item_type, i.object_id As item_object_id, (SELECT COUNT(*)
      FROM `jos_collections_posts` AS s
      WHERE s.item_id=p.item_id
      AND s.original=0) AS item_reposts, (SELECT COUNT(*)
      FROM `jos_item_comments` AS ct
      WHERE ct.item_id=p.item_id
      AND ct.item_type='collection'
      AND ct.state IN (1, 3)) AS item_comments
      FROM jos_collections_posts AS p
      INNER JOIN jos_collections AS c
      ON c.id=p.collection_id
      INNER JOIN jos_collections_items AS i
      ON p.item_id=i.id
      LEFT JOIN jos_users AS u
      ON p.created_by=u.id
      WHERE i.state='1'
      AND c.state='1'
      AND i.access='0'
      AND c.access='0'
      ORDER BY p.created DESC
      LIMIT 0,25
  19. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.access='0'
  20. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_help'
  21. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  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 = '0000-00-00 00:00:00' OR m.publish_up <= '2017-09-23 09:30:52')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-23 09:30:52')
      AND m.access IN (1,1,4)
      AND m.client_id = 0
      AND (mm.menuid = 142 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  23. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  24. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  25. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  26. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  27. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  28. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  29. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  30. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_events'
  31. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_store'
  32. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  33. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  34. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  35. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  36. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  37. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  38. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  39. UPDATE `jos_session`
      SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1506159052;s:18:\"session.timer.last\";i:1506159052;s:17:\"session.timer.now\";i:1506159052;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:\"6544e0cf40d7eac7294856c857965c36\";s:12:\"tracker.ssid\";s:32:\"6544e0cf40d7eac7294856c857965c36\";s:12:\"tracker.rsid\";s:32:\"6544e0cf40d7eac7294856c857965c36\";s:13:\"securiy_code0\";s:5:\"f3333\";s:13:\"session.token\";s:32:\"f8b5b914fb5f5c1d259507a863b8d83b\";}' , `time` = '1506159052' , `ip` = '54.81.8.73'
      WHERE `session_id` = '6544e0cf40d7eac7294856c857965c36'