Support

Support Options

Submit a Support Ticket

Workspace

Development workspace

Launch Tool

You must login before you can run this tool.

Version 1.3 - published on 16 Dec 2016

This tool is closed source.

View All Supporting Documents

Debug Console

Close26 MBRequestSessionTimelineDatabase89
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( REDIRECT_SCRIPT_URL => /resources/1, REDIRECT_SCRIPT_URI => http://chemistryhub.org/re... Array(
REDIRECT_SCRIPT_URL => /resources/1,
REDIRECT_SCRIPT_URI => http://chemistryhub.org/resources/1,
REDIRECT_nokeepalive => ,
REDIRECT_STATUS => 200,
SCRIPT_URL => /resources/1,
SCRIPT_URI => http://chemistryhub.org/resources/1,
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 => 33924,
REDIRECT_URL => /resources/1,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.0,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /resources/1,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1506158887.25,
REQUEST_TIME => 1506158887
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid a195163072108786adfe44b933a1b8f5
tracker.ssid a195163072108786adfe44b933a1b8f5
tracker.rsid a195163072108786adfe44b933a1b8f5
securiy_code0 69f93
session.token 9ff350fa671fd549036b15d33628f196
  • site 0.051 seconds (+0.051); 9.75 MB (+9.750) - afterInitialise
  • site 0.073 seconds (+0.022); 11.50 MB (+1.750) - afterRoute
  • site 0.258 seconds (+0.185); 23.50 MB (+12.000) - afterDispatch
  • site 0.267 seconds (+0.010); 23.50 MB (0.000) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.271 seconds (+0.004); 24.00 MB (+0.500) - afterRenderModule mod_custom (Hub Footer)
  • site 0.272 seconds (+0.001); 24.00 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.275 seconds (+0.003); 24.25 MB (+0.250) - afterRenderModule mod_collect (Collect)
  • site 0.276 seconds (+0.000); 24.25 MB (0.000) - beforeRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.280 seconds (+0.004); 24.25 MB (0.000) - afterRenderModule mod_breadcrumbs (Breadcrumbs)
  • site 0.280 seconds (+0.000); 24.25 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 0.306 seconds (+0.026); 24.50 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 0.306 seconds (+0.000); 24.50 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 0.308 seconds (+0.002); 24.75 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 0.308 seconds (+0.000); 24.75 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 0.325 seconds (+0.017); 25.75 MB (+1.000) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 0.329 seconds (+0.003); 25.75 MB (0.000) - onAfterRender
  • site 0.331 seconds (+0.002); 25.75 MB (0.000) - sessionStore
26 MB

89 Queries Logged: 0.04275107383728 seconds

  1. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '369b04f5945e6429357c47cff8d3c6b5'
  2. DELETE
      FROM `jos_session`
      WHERE `session_id` = '369b04f5945e6429357c47cff8d3c6b5'
  3. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = 'a195163072108786adfe44b933a1b8f5'
  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` = 'a195163072108786adfe44b933a1b8f5'
  6. INSERT INTO `jos_session` (`session_id`, `client_id`, `time`, `ip`)
      VALUES ('a195163072108786adfe44b933a1b8f5', 0, '1506158887', '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_resources'
  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_resources`
  16. SELECT *
      FROM jos_resources
      WHERE `id` = '1'
  17. SHOW FULL COLUMNS
      FROM `jos_resource_types`
  18. SELECT *
      FROM jos_resource_types
      WHERE category='27'
      ORDER BY type
  19. SHOW TABLES
  20. SHOW FULL COLUMNS
      FROM `jos_tool_version`
  21. SHOW FULL COLUMNS
      FROM `jos_tool_authors`
  22. SELECT v.*, d.*
      FROM jos_tool_version as v
      LEFT JOIN jos_doi_mapping as d
      ON d.alias = v.toolname
      AND d.local_revision=v.revision
      WHERE v.toolname = 'workspace'
      ORDER BY v.state DESC, v.revision DESC
  23. SELECT DISTINCT a.uid as uidNumber
      FROM jos_tool_authors as a
      WHERE a.version_id='1'
      ORDER BY a.ordering
  24. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_tools'
  25. SELECT *
      FROM `jos_resource_ratings`
      WHERE `jos_resource_ratings`.`resource_id` = '1'
      AND `jos_resource_ratings`.`state` IN ('1','3')
      ORDER BY `created` DESC
  26. SHOW TABLES
  27. SHOW FULL COLUMNS
      FROM `jos_resource_stats_tools`
  28. SELECT id, users, sessions, simulations, jobs, avg_wall, tot_wall, avg_cpu, tot_cpu, avg_view, tot_view, avg_wait, tot_wait, avg_cpus, tot_cpus, period,
      LEFT(datetime,7) as datetime
      FROM jos_resource_stats_tools
      WHERE `period`='14'
      AND `resid`='1'
      ORDER BY `datetime` DESC
      LIMIT 1
  29. SHOW FULL COLUMNS
      FROM `jos_resource_stats_clusters`
  30. SELECT COUNT(DISTINCT uidNumber, username) AS users, COUNT(DISTINCT cluster) AS classes
      FROM jos_resource_stats_clusters
      WHERE resid='1'
  31. SHOW FULL COLUMNS
      FROM `jos_citations`
  32. SHOW FULL COLUMNS
      FROM `jos_citations_assoc`
  33. SELECT DISTINCT r.*, CS.sec_cits_cnt AS sec_cnt, CS.search_string, u.username
      FROM jos_citations AS r
      LEFT JOIN `jos_users` AS u
      ON u.id = r.uid
      LEFT JOIN `jos_citations_secondary` as CS
      ON r.id=CS.cid, jos_citations_assoc AS a
      WHERE r.published=1
      AND a.tbl='resource'
      AND a.oid='1'
      AND a.cid=r.id
      ORDER BY affiliated ASC, year DESC
  34. SELECT jos_answers_questions.*
      FROM `jos_answers_questions`
      INNER JOIN jos_tags_object
      ON jos_tags_object.objectid = jos_answers_questions.id
      INNER JOIN jos_tags
      ON jos_tags.id = jos_tags_object.tagid
      WHERE `jos_tags_object`.`tbl` = 'answers'
      AND `jos_tags`.`tag` IN ('toolworkspace')
      AND `jos_answers_questions`.`state` < '2'
  35. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  36. SHOW FULL COLUMNS
      FROM `jos_wishlist`
  37. SHOW FULL COLUMNS
      FROM `jos_wishlist_item`
  38. SHOW FULL COLUMNS
      FROM `jos_wishlist_owners`
  39. SELECT id
      FROM jos_wishlist
      WHERE referenceid='1'
      AND category='resource'
      ORDER BY id DESC
      LIMIT 1
  40. SELECT w.*
      FROM jos_wishlist AS w
      WHERE w.id='1'
  41. SELECT r.title, r.type, r.alias, r.introtext, t.type as typetitle
      FROM `jos_resources` AS r
      LEFT JOIN `jos_resource_types` AS t
      ON t.id=r.type
      WHERE r.id='1'
  42. SHOW FULL COLUMNS
      FROM `jos_wishlist_ownergroups`
  43. SELECT g.cn
      FROM `jos_tool_groups` AS g JOIN `jos_xgroups` AS xg
      ON g.cn=xg.cn JOIN `jos_tool` AS t
      ON g.toolid=t.id JOIN `jos_resources` as r
      ON r.alias = t.toolname
      WHERE r.id = '1'
      AND g.role=1
  44. SELECT o.groupid
      FROM `jos_wishlist_ownergroups` AS o
      WHERE o.wishlist='1'
  45. SELECT o.userid
      FROM `jos_wishlist_owners` AS o
      WHERE o.wishlist='1'
      AND o.type!=2
  46. SELECT ws.id
      FROM `jos_wishlist_item` AS ws
      WHERE 1=1
      AND ws.wishlist='1'
      AND ws.status!=2
      AND ws.private='0'
  47. SELECT a.authorid, a.name, n.name AS xname, a.ordering, a.organization AS org, n.organization AS xorg, a.role, n.uidNumber AS id, n.givenName, n.middleName, n.surname
      FROM jos_author_assoc AS a
      LEFT JOIN jos_xprofiles AS n
      ON n.uidNumber=a.authorid
      WHERE a.subtable='resources'
      AND a.subid=1
      ORDER BY ordering, surname, givenName, middleName
  48. SELECT n.uidNumber AS id, t.name AS name, n.name AS xname, n.organization AS xorg, n.givenName, n.givenName AS firstname, n.middleName, n.middleName AS middlename, n.surname, n.surname AS lastname, t.organization AS org, t.*, a.role
      FROM jos_tool_authors AS t JOIN jos_xprofiles AS n
      ON n.uidNumber=t.uid JOIN jos_tool_version AS v
      ON v.id=t.version_id
      LEFT JOIN jos_author_assoc AS a
      ON a.authorid=t.uid
      AND a.subtable='resources'
      AND a.subid=1
      WHERE t.toolname='workspace'
      AND v.state<>3
      AND t.revision='3'
      ORDER BY t.ordering
  49. SELECT r.*, r.logical_type AS logicaltype, t.type AS logicaltitle, rt.type AS typetitle, a.grouping, (SELECT n.surname
      FROM jos_xprofiles AS n, jos_author_assoc AS aa
      WHERE n.uidNumber=aa.authorid
      AND aa.subtable='resources'
      AND aa.subid=r.id
      ORDER BY ordering
      LIMIT 1) AS author
      FROM jos_resource_types AS rt, jos_resources AS r JOIN jos_resource_assoc AS a
      ON r.id=a.child_id
      LEFT JOIN jos_resource_types AS t
      ON r.logical_type=t.id
      WHERE r.published=1
      AND a.parent_id=1
      AND r.type=rt.id
      ORDER BY a.ordering ASC, a.grouping ASC
  50. SELECT a.rules
      FROM jos_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id, a.rules, a.lft
  51. 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_tools.1')
      GROUP BY b.id, b.rules, b.lft
      ORDER BY b.lft
  52. SHOW FULL COLUMNS
      FROM `jos_assets`
  53. SELECT id
      FROM jos_assets
      WHERE parent_id = 0
  54. SELECT rules
      FROM jos_assets
      WHERE id = '1'
  55. 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
  56. SHOW TABLES
  57. SELECT *
      FROM jos_tool_version
      WHERE instance='workspace_r3';
  58. SELECT alias
      FROM jos_tool_version_alias AS aux
      WHERE aux.tool_version_id='1'
      ORDER BY alias ASC;
  59. SELECT middleware
      FROM jos_tool_version_middleware AS aux
      WHERE aux.tool_version_id='1'
      ORDER BY middleware ASC;
  60. SELECT hostreq
      FROM jos_tool_version_hostreq AS aux
      WHERE aux.tool_version_id='1'
      ORDER BY hostreq ASC;
  61. SELECT uid
      FROM jos_tool_authors
      WHERE version_id='1'
      ORDER BY ordering ASC;
  62. SELECT cn
      FROM jos_tool_groups
      WHERE role='0'
      AND toolid='1'
      ORDER BY cn ASC;
  63. SELECT cn
      FROM jos_tool_groups
      WHERE (role='1' OR role='2')
      AND toolid='1'
      ORDER BY cn ASC;
  64. SELECT id,toolname,title,registered,registered_by,state_changed,ticketid,published,state,priority
      FROM jos_tool
      WHERE id='1';
  65. SELECT instance
      FROM jos_tool_version AS aux
      WHERE aux.toolid='1'
      ORDER BY version ASC;
  66. SELECT tv.toolname, tg.cn
      FROM jos_tool_groups AS tg, jos_tool_version AS tv
      WHERE tg.toolid = tv.toolid
      AND tg.toolid=1
      AND role=0
      AND tv.instance='workspace_r3'
      AND tv.toolaccess='@
      GROUP'
  67. SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE m.gidNumber=g.gidNumber
      AND m.uidNumber=0
      ORDER BY description, cn
  68. SELECT r.id, r.title, r.introtext, r.type, r.logical_type AS logicaltype, r.created, r.created_by, r.published, r.publish_up, r.path, r.access, r.standalone, r.rating, r.times_rated, r.attribs, r.params, t.type AS logicaltitle, rt.type AS typetitle, a.grouping, a.ordering
      FROM jos_resource_types AS rt, jos_resources AS r JOIN jos_resource_assoc AS a
      ON r.id=a.child_id
      LEFT JOIN jos_resource_types AS t
      ON r.logical_type=t.id
      WHERE r.published=1
      AND a.parent_id=1
      AND r.type=rt.id
      ORDER BY a.ordering, a.grouping
  69. SELECT k.*
      FROM ((SELECT v.id, v.page_id AS pageid, MAX(v.version) AS version, w.title, w.pagename AS alias, v.pagetext AS introtext, NULL AS type, NULL AS published, NULL AS publish_up, w.scope, w.rating, w.times_rated, w.ranking, 'Topic' AS section
      FROM `jos_wiki_pages` AS w JOIN `jos_wiki_versions` AS v
      ON w.id=v.page_id JOIN `jos_wiki_links` AS wl
      ON wl.page_id=w.id
      WHERE v.approved=1
      AND wl.scope='resource'
      AND wl.scope_id='1'
      AND w.access!=1
      GROUP BY pageid
      ORDER BY ranking DESC, title
      LIMIT 10) UNION (SELECT DISTINCT r.id, NULL AS pageid, NULL AS version, r.title, r.alias, r.introtext, r.type, r.published, r.publish_up, NULL AS scope, r.rating, r.times_rated, r.ranking, rt.type AS section
      FROM `jos_resource_types` AS rt, `jos_resources` AS r JOIN `jos_resource_assoc` AS a
      ON r.id=a.parent_id
      LEFT JOIN `jos_resource_types` AS t
      ON r.logical_type=t.id
      WHERE r.published=1
      AND a.child_id='1'
      AND r.type=rt.id
      AND r.type!=8
      AND r.access=0
      ORDER BY r.ranking
      LIMIT 10)) AS k
      ORDER BY ranking DESC
      LIMIT 10
  70. SELECT *
      FROM `jos_resource_sponsors`
      WHERE `jos_resource_sponsors`.`state` = '1'
  71. SELECT jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'resources'
      AND `jos_tags_object`.`objectid` = '1'
      GROUP BY jos_tags.id
  72. 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:28:07')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-09-23 09:28:07')
      AND m.access IN (1,1,4)
      AND m.client_id = 0
      AND (mm.menuid = 88 OR mm.menuid <= 0)
      ORDER BY m.position, m.ordering
  73. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  74. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  75. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  76. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  77. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  78. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  79. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  80. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_citations'
  81. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_events'
  82. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_store'
  83. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_forum'
  84. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_groups'
  85. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  86. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  87. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_newsletter'
  88. SELECT extension_id AS id, element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  89. UPDATE `jos_session`
      SET `data` = '__default|a:11:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1506158887;s:18:\"session.timer.last\";i:1506158887;s:17:\"session.timer.now\";i:1506158887;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":1:{s:9:\"Resources\";O:8:\"stdClass\":1:{s:7:\"Reviews\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:6:\"Review\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:4:\"desc\";}}}}}}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:\"a195163072108786adfe44b933a1b8f5\";s:12:\"tracker.ssid\";s:32:\"a195163072108786adfe44b933a1b8f5\";s:12:\"tracker.rsid\";s:32:\"a195163072108786adfe44b933a1b8f5\";s:13:\"securiy_code0\";s:5:\"69f93\";s:13:\"session.token\";s:32:\"9ff350fa671fd549036b15d33628f196\";}' , `time` = '1506158887' , `ip` = '54.81.8.73'
      WHERE `session_id` = 'a195163072108786adfe44b933a1b8f5'