Member Log In

If your organization is an EBRI member (please check here) and you do not have your credentials, fill in the information in "I'm New Here" to get your user name and login. Still unable to login? Contact EBRI Member Relations.

I'm New Here

Not a Member? Join today, your support is appreciated! EBRI is a nonprofit funded by individual and organization membership. Contact EBRI Member Relations for more information.

Total Time

Count

Avg Time

Query

0.033

1 call
0 rows

0.033

INSERT INTO `Ticket` SET `mxxCreated`='2026-06-15 17:40:14', `mxxCreatedBy`=NULL, `TicketId`=0x60195000000002, `type`='2', `value`='LT-1781559614-9se7OmXWDXfz3wxvUtQnuC4f7MeaGbbM', `expires`='2026/06/15 19:10:14.0249 US/Eastern', `username`=NULL, `service`='/forms/oauth/authorize?response_type=code&client_id=d3a0d9cba1eb4bed9434057b584d2b00&scope=scope&state=https%3a%2f%2fwww.ebri.maxx.matrixdev.net%2fpublications%2fresearch-publications%2fissue-briefs%2fcontent%2ffull%2fafter-years-of-erosion-more-employers-are-offering-health-coverage-worker-eligibility-higher&redirect_uri=https://www.ebri.org/mxt/authservice/callback/', `isPrimary`='2'

0.022

1 call
0 rows

0.022

INSERT INTO `PageRequest` SET `mxxCreated`='2026-06-15 17:40:13', `mxxCreatedBy`=NULL, `PageRequestId`=0x60195000000000, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='1861220', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='889150', `startTime`='2026-06-15 17:40:13', `sessionId`=0x32B77881DCA2FBA5, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'client_id\\':\\'d3a0d9cba1eb4bed9434057b584d2b00\\', \\'redirect_uri\\':\\'https://www.ebri.org/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'scope\\':\\'scope\\', \\'state\\':\\'https://www.ebri.maxx.matrixdev.net/publications/research-publications/issue-briefs/content/full/after-years-of-erosion-more-employers-are-offering-health-coverage-worker-eligibility-higher\\'}', `clientIPAddr`='216.73.216.187'

0.017

1 call
1 row

0.017

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='recaptcha_secret_key' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.013

1 call
1 row

0.013

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='forgotPasswordLinkText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.012

1 call
1 row

0.012

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.012

1 call
1 row

0.012

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='recaptcha_site_key' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.012

2 calls
0 rows

0.006

COMMIT

0.012

1 call
1 row

0.012

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='newUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.010

1 call
0 rows

0.010

INSERT INTO `PageRequest` SET `mxxCreated`='2026-06-15 17:40:14', `mxxCreatedBy`=NULL, `PageRequestId`=0x60195000000001, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='EBRI', `pid`='1861220', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='889150', `startTime`='2026-06-15 17:40:14', `sessionId`=0x32B77881DCA2FBA5, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'oauth\\':\\'1\\', \\'service\\':\\'/forms/oauth/authorize?response_type=code&client_id=d3a0d9cba1eb4bed9434057b584d2b00&scope=scope&state=https%3a%2f%2fwww.ebri.maxx.matrixdev.net%2fpublications%2fresearch-publications%2fissue-briefs%2fcontent%2ffull%2fafter-years-of-erosion-more-employers-are-offering-health-coverage-worker-eligibility-higher&redirect_uri=https://www.ebri.org/mxt/authservice/callback/\\'}', `clientIPAddr`='216.73.216.187'

0.009

1 call
1 row

0.009

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='existingUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.009

2 calls
0 rows

0.004

START TRANSACTION

0.007

1 call
1 row

0.007

SELECT * FROM uuid FOR UPDATE

0.007

1 call
1 row

0.007

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginText_bottom' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.005

1 call
1 row

0.005

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='loginText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.005

1 call
1 row

0.005

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='hideNewUser' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.005

1 call
1 row

0.005

SELECT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='hasShowPassword' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.004

1 call
11 rows

0.004

DESCRIBE Ticket

0.003

1 call
159 rows

0.003

SELECT * FROM webselect

0.002

1 call
1 row

0.002

SELECT version from databasemap;

0.001

1 call
0 rows

0.001

UPDATE `PageRequest` SET `mxxUpdated`='2026-06-15 17:40:13', `mxxUpdatedBy`=NULL, `PageRequestId`=0x60195000000000, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='1861220', `requestNum`='1', `growth`='0', `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='889150', `startTime`='2026-06-15 17:40:13', `sessionId`=0x32B77881DCA2FBA5, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.03965187072753906', `timeTaken`='0', `dictSize`='0', `fields`='{\\'client_id\\':\\'d3a0d9cba1eb4bed9434057b584d2b00\\', \\'redirect_uri\\':\\'https://www.ebri.org/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'scope\\':\\'scope\\', \\'state\\':\\'https://www.ebri.maxx.matrixdev.net/publications/research-publications/issue-briefs/content/full/after-years-of-erosion-more-employers-are-offering-health-coverage-worker-eligibility-higher\\'}', `clientIPAddr`='216.73.216.187' WHERE `PageRequestId`=0x60195000000000

219323 function calls (214841 primitive calls) in 1.315 seconds Ordered by: cumulative time List reduced from 1490 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.315 1.315 /data/ebri/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 1.301 1.301 /data/ebri/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 1.269 1.269 /data/ebri/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.269 1.269 /data/ebri/current/generic/sites/www/forms/cas.py:198(login) 1 0.000 0.000 1.269 1.269 /data/ebri/current/generic/sites/www/forms/cas.py:84(_presentLoginPage) 1 0.000 0.000 0.458 0.458 /data/ebri/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 1 0.000 0.000 0.458 0.458 /data/ebri/current/libs/framework/WebApp.py:212(wrapHTML) 1 0.000 0.000 0.415 0.415 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.403 0.403 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 1 0.000 0.000 0.402 0.402 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:247(getStubFromCache) 1 0.000 0.000 0.402 0.402 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.402 0.402 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.402 0.402 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.384 0.384 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.384 0.384 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.002 0.002 0.384 0.384 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 11 0.000 0.000 0.342 0.031 /data/ebri/current/libs/utils/htmlTools.py:100(cleanHTML) 1 0.000 0.000 0.339 0.339 /data/ebri/current/generic/classes/Ticket.py:42(create) 1 0.000 0.000 0.338 0.338 /data/ebri/current/libs/PLayer/PersistentObject.py:956(save) 36/8 0.000 0.000 0.306 0.038 :934(exec_module) 35/7 0.005 0.000 0.301 0.043 :666(_load_unlocked) 35/6 0.000 0.000 0.288 0.048 :1165(_find_and_load) 85/11 0.000 0.000 0.288 0.026 :233(_call_with_frames_removed) 35/6 0.000 0.000 0.288 0.048 :1120(_find_and_load_unlocked) 2493/2319 0.004 0.000 0.287 0.000 /data/ebri/current/libs/framework/BaseHandler.py:1480(mxxImporter) 1 0.285 0.285 0.285 0.285 {built-in method gc.collect} 2507/2319 0.006 0.000 0.283 0.000 {built-in method builtins.__import__} 36/8 0.000 0.000 0.274 0.034 {built-in method builtins.exec} 1 0.000 0.000 0.260 0.260 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 1 0.000 0.000 0.213 0.213 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 919 0.021 0.000 0.183 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 21 0.000 0.000 0.174 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 21 0.000 0.000 0.173 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 21 0.000 0.000 0.172 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 21 0.172 0.008 0.172 0.008 {function Connection.query at 0xe655a32289a0} 83/51 0.000 0.000 0.167 0.003 :1207(_handle_fromlist) 1 0.000 0.000 0.151 0.151 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1() 13 0.000 0.000 0.144 0.011 /data/ebri/current/libs/PLayer/PersistentBroker.py:266(processSqlList) 10 0.000 0.000 0.133 0.013 /data/ebri/current/generic/classes/ClientSetting.py:97(getClientSettingValue) 9 0.000 0.000 0.128 0.014 /data/ebri/current/libs/framework/BaseHandler.py:832(getClientSetting) 1 0.000 0.000 0.113 0.113 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/__init__.py:1() 43 0.001 0.000 0.112 0.003 /usr/lib/python3.11/re/__init__.py:272(_compile) 38 0.000 0.000 0.111 0.003 /usr/lib/python3.11/re/__init__.py:225(compile) 24 0.000 0.000 0.111 0.005 /usr/lib/python3.11/re/_compiler.py:740(compile) 10 0.000 0.000 0.103 0.010 /data/ebri/current/generic/classes/ClientSetting.py:33(getClientSetting) 10 0.000 0.000 0.102 0.010 /data/ebri/current/libs/PLayer/PersistentBroker.py:847(processCriteria) 412 0.001 0.000 0.102 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText) 412 0.017 0.000 0.101 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:354(insertText) 36 0.000 0.000 0.089 0.002 :1007(get_code) 331 0.000 0.000 0.086 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1009(processSpaceCharactersNonPre) 6 0.000 0.000 0.084 0.014 /data/ebri/current/libs/framework/WebApp.py:722(getClientSetting) 684 0.065 0.000 0.082 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild) 279/263 0.001 0.000 0.081 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 24 0.000 0.000 0.075 0.003 /usr/lib/python3.11/re/_parser.py:979(parse) 79/24 0.005 0.000 0.075 0.003 /usr/lib/python3.11/re/_parser.py:456(_parse_sub) 660/24 0.045 0.000 0.075 0.003 /usr/lib/python3.11/re/_parser.py:516(_parse) 1 0.000 0.000 0.069 0.069 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:1() 1030 0.019 0.000 0.061 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:887(attributeNameState) 262 0.001 0.000 0.056 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 105 0.039 0.000 0.053 0.001 {built-in method builtins.__build_class__} 36 0.000 0.000 0.048 0.001 :727(_compile_bytecode) 3 0.000 0.000 0.048 0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 36 0.047 0.001 0.047 0.001 {built-in method marshal.loads} 6324 0.043 0.000 0.043 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_inputstream.py:234(char) 1 0.000 0.000 0.043 0.043 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:718(process) 900 0.001 0.000 0.041 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:256(dataState) 1 0.000 0.000 0.041 0.041 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:32(build_url_re) 36 0.000 0.000 0.039 0.001 :1127(get_data) 957 0.036 0.000 0.036 0.000 {method 'translate' of 'str' objects} 24 0.000 0.000 0.035 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 418 0.008 0.000 0.035 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:494(new_string) 3 0.000 0.000 0.033 0.011 /data/ebri/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS) 6 0.033 0.006 0.033 0.006 /data/ebri/current/libs/utils/htmlTools.py:53(init) 1 0.000 0.000 0.033 0.033 /data/ebri/current/libs/PLayer/PersistentObject.py:795(flushSaveSqlQueue) 430 0.017 0.000 0.032 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:890(__new__) 2 0.000 0.000 0.031 0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/_trie/py.py:10(__init__) 4 0.013 0.003 0.031 0.008 {built-in method builtins.all} 3 0.000 0.000 0.031 0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/sanitizer.py:153(clean) 1 0.000 0.000 0.030 0.030 /data/ebri/current/libs/utils/recaptcha.py:15(__init__) 1 0.029 0.029 0.030 0.030 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/serializer.py:1() 716/24 0.010 0.000 0.030 0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile) 1337 0.013 0.000 0.029 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_inputstream.py:314(charsUntil) 77 0.000 0.000 0.028 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1041(startTagCloseP) 34 0.000 0.000 0.027 0.001 :1054(_find_spec) 36 0.026 0.001 0.026 0.001 {method 'read' of '_io.BufferedReader' objects} 62 0.016 0.000 0.026 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:957(addFormattingElement) 57 0.000 0.000 0.026 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1098(startTagA) 34 0.000 0.000 0.026 0.001 :1499(find_spec) 34 0.000 0.000 0.026 0.001 :1467(_get_spec) 1 0.000 0.000 0.025 0.025 /data/ebri/current/libs/framework/BaseHandler.py:311(getTemplate) 1 0.000 0.000 0.023 0.023 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/packaging/version.py:1() 1 0.000 0.000 0.020 0.020 /data/ebri/current/libs/framework/MakoTemplate.py:48(__call__) 1262 0.002 0.000 0.020 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:434(tagNameState) 1 0.000 0.000 0.020 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:461(render) 1 0.000 0.000 0.020 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:860(_render) 1 0.000 0.000 0.020 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:912(_render_context) 1 0.000 0.000 0.020 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:927(_exec_template) 1 0.000 0.000 0.020 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:65(build_email_re) 1 0.000 0.000 0.020 0.020 /tmp/mako_modules_1011/ebri/www/26.1.1/data/ebri/current/generic/themes/shared/mako/login/caslogin.html.py:18(render_body) 1 0.000 0.000 0.019 0.019 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/_inputstream.py:1()