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.010

1 call
1 row

0.010

SELECT DISTINCT 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.009

1 call
1 row

0.009

SELECT DISTINCT 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.008

2 calls
0 rows

0.004

START TRANSACTION

0.008

1 call
1 row

0.008

SELECT DISTINCT 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.006

1 call
1 row

0.006

SELECT DISTINCT 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.006

1 call
1 row

0.006

SELECT DISTINCT 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.005

1 call
1 row

0.005

SELECT version from databasemap;

0.005

1 call
0 rows

0.005

INSERT INTO `PageRequest` SET `mxxCreated`='2026-06-15 12:43:49',`mxxCreatedBy`=NULL, `PageRequestId`=0x60176C00000001, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='EBRI', `pid`='1809889', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='838769', `startTime`='2026-06-15 12:43:49', `sessionId`=0x221A2D0EA7736757, `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%2ffast-facts%2fcontent%2ffull%2fputting-numbers-to-the-shifting-private-sector-retirement-landscape&redirect_uri=https://www.ebri.org/mxt/authservice/callback/\\'}', `clientIPAddr`='216.73.216.187'

0.004

1 call
1 row

0.004

SELECT DISTINCT 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.004

1 call
0 rows

0.004

UPDATE `PageRequest` SET `mxxUpdated`='2026-06-15 12:43:49',`mxxUpdatedBy`=NULL, `PageRequestId`=0x60176C00000000, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='1809889', `requestNum`='1', `growth`='0', `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='838769', `startTime`='2026-06-15 12:43:49', `sessionId`=0x766D4964B9EE982F, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.012425422668457031', `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/health/publications/fast-facts/content/full/significant-differences-in-stop-loss-coverage-by-firm-size-among-employees-in-self-insured-plans\\'}', `clientIPAddr`='216.73.216.187' WHERE `PageRequestId`=0x60176C00000000

0.004

1 call
1 row

0.004

SELECT * FROM uuid FOR UPDATE

0.004

1 call
1 row

0.004

SELECT DISTINCT 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.004

1 call
0 rows

0.004

INSERT INTO `PageRequest` SET `mxxCreated`='2026-06-15 12:43:49',`mxxCreatedBy`=NULL, `PageRequestId`=0x60176C00000000, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='1809889', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='838769', `startTime`='2026-06-15 12:43:49', `sessionId`=0x766D4964B9EE982F, `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/health/publications/fast-facts/content/full/significant-differences-in-stop-loss-coverage-by-firm-size-among-employees-in-self-insured-plans\\'}', `clientIPAddr`='216.73.216.187'

0.003

2 calls
0 rows

0.002

COMMIT

0.003

1 call
159 rows

0.003

SELECT * FROM webselect

0.003

1 call
0 rows

0.003

INSERT INTO `Ticket` SET `mxxCreated`='2026-06-15 12:43:49',`mxxCreatedBy`=NULL, `TicketId`=0x60176C00000002, `type`='2', `value`='LT-1781541829-YBKYTCcQEF5IidWnZY5bD4bQzPTq1av9', `expires`='2026/06/15 14:13:49.8524 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%2ffast-facts%2fcontent%2ffull%2fputting-numbers-to-the-shifting-private-sector-retirement-landscape&redirect_uri=https://www.ebri.org/mxt/authservice/callback/', `isPrimary`='2'

0.003

1 call
1 row

0.003

SELECT DISTINCT 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.002

1 call
1 row

0.002

SELECT DISTINCT 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.002

1 call
1 row

0.002

SELECT DISTINCT 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.001

1 call
11 rows

0.001

DESCRIBE Ticket

221976 function calls (217494 primitive calls) in 1.236 seconds Ordered by: cumulative time List reduced from 1507 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.236 1.236 /data/ebri/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 1.210 1.210 /data/ebri/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 1.177 1.177 /data/ebri/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.177 1.177 /data/ebri/current/generic/sites/www/forms/cas.py:198(login) 1 0.000 0.000 1.177 1.177 /data/ebri/current/generic/sites/www/forms/cas.py:84(_presentLoginPage) 1 0.000 0.000 0.454 0.454 /data/ebri/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 1 0.000 0.000 0.454 0.454 /data/ebri/current/libs/framework/WebApp.py:212(wrapHTML) 11 0.008 0.001 0.398 0.036 /data/ebri/current/libs/utils/htmlTools.py:100(cleanHTML) 2543/2369 0.011 0.000 0.295 0.000 /data/ebri/current/libs/framework/BaseHandler.py:1471(mxxImporter) 2557/2369 0.014 0.000 0.284 0.000 {built-in method builtins.__import__} 35/6 0.000 0.000 0.276 0.046 :1165(_find_and_load) 85/11 0.000 0.000 0.276 0.025 :233(_call_with_frames_removed) 35/6 0.000 0.000 0.276 0.046 :1120(_find_and_load_unlocked) 35/7 0.000 0.000 0.267 0.038 :666(_load_unlocked) 36/8 0.000 0.000 0.266 0.033 :934(exec_module) 1 0.000 0.000 0.266 0.266 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 36/8 0.000 0.000 0.260 0.032 {built-in method builtins.exec} 1 0.000 0.000 0.255 0.255 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 1 0.000 0.000 0.254 0.254 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:247(getStubFromCache) 1 0.000 0.000 0.254 0.254 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.254 0.254 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.254 0.254 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.247 0.247 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.247 0.247 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.013 0.013 0.246 0.246 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 1 0.000 0.000 0.237 0.237 /data/ebri/current/generic/classes/Ticket.py:42(create) 1 0.000 0.000 0.236 0.236 /data/ebri/current/libs/PLayer/PersistentObject.py:956(save) 1 0.000 0.000 0.209 0.209 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 1 0.000 0.000 0.189 0.189 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:718(process) 1 0.183 0.183 0.183 0.183 {built-in method gc.collect} 1 0.000 0.000 0.175 0.175 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 59 0.007 0.000 0.173 0.003 /usr/lib/python3.11/re/__init__.py:272(_compile) 54 0.000 0.000 0.173 0.003 /usr/lib/python3.11/re/__init__.py:225(compile) 24 0.000 0.000 0.158 0.007 /usr/lib/python3.11/re/_compiler.py:740(compile) 96/64 0.008 0.000 0.138 0.002 :1207(_handle_fromlist) 10 0.000 0.000 0.095 0.010 /data/ebri/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS) 21 0.095 0.005 0.095 0.005 /data/ebri/current/libs/utils/htmlTools.py:53(init) 21 0.000 0.000 0.094 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 21 0.000 0.000 0.094 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 21 0.000 0.000 0.093 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 21 0.093 0.004 0.093 0.004 {function Connection.query at 0xf4106ba42b60} 10 0.000 0.000 0.090 0.009 /data/ebri/current/generic/classes/ClientSetting.py:97(getClientSettingValue) 919 0.020 0.000 0.089 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 1 0.000 0.000 0.087 0.087 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1() 11 0.000 0.000 0.085 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 9 0.000 0.000 0.083 0.009 /data/ebri/current/libs/framework/BaseHandler.py:831(getClientSetting) 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.079 0.003 /usr/lib/python3.11/re/_parser.py:979(parse) 79/24 0.001 0.000 0.079 0.003 /usr/lib/python3.11/re/_parser.py:456(_parse_sub) 660/24 0.037 0.000 0.079 0.003 /usr/lib/python3.11/re/_parser.py:516(_parse) 24 0.000 0.000 0.078 0.003 /usr/lib/python3.11/re/_compiler.py:573(_code) 10 0.000 0.000 0.074 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all) 10 0.006 0.001 0.074 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all) 1 0.000 0.000 0.069 0.069 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:707(_drape) 6 0.000 0.000 0.069 0.011 /data/ebri/current/libs/framework/WebApp.py:723(getClientSetting) 262 0.001 0.000 0.067 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 10 0.008 0.001 0.066 0.007 /data/ebri/current/generic/classes/ClientSetting.py:33(getClientSetting) 13 0.000 0.000 0.065 0.005 /data/ebri/current/libs/PLayer/PersistentBroker.py:266(processSqlList) 11 0.000 0.000 0.065 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/sanitizer.py:87(__init__) 1 0.000 0.000 0.064 0.064 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/__init__.py:1() 1 0.000 0.000 0.063 0.063 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__) 1 0.000 0.000 0.063 0.063 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 263/1 0.005 0.000 0.063 0.063 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 263/1 0.011 0.000 0.063 0.063 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 2133 0.002 0.000 0.062 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2043(search) 11 0.000 0.000 0.059 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:410(__init__) 11 0.000 0.000 0.058 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:93(__init__) 10 0.000 0.000 0.057 0.006 /data/ebri/current/libs/PLayer/PersistentBroker.py:769(processCriteria) 1 0.000 0.000 0.054 0.054 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:640(doPostScrapeStuff) 716/24 0.016 0.000 0.053 0.002 /usr/lib/python3.11/re/_compiler.py:37(_compile) 11 0.000 0.000 0.050 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/__init__.py:39(getTreeBuilder) 836 0.020 0.000 0.050 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1980(search_tag) 263 0.004 0.000 0.049 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:152(elementClass) 1 0.000 0.000 0.049 0.049 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/etree.py:1() 1 0.000 0.000 0.049 0.049 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/_ihatexml.py:1() 36403/36291 0.040 0.000 0.048 0.000 {built-in method builtins.isinstance} 1 0.000 0.000 0.045 0.045 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:32(build_url_re) 105 0.018 0.000 0.042 0.000 {built-in method builtins.__build_class__} 1 0.041 0.041 0.041 0.041 {built-in method gc.get_referrers} 57 0.039 0.001 0.040 0.001 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 412 0.001 0.000 0.040 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText) 1 0.000 0.000 0.039 0.039 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:1() 412 0.011 0.000 0.039 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:354(insertText) 1 0.000 0.000 0.036 0.036 /data/ebri/current/ebri_org/classes/ebri_ScrapeAndDrape.py:17(_makeBreadCrumbs) 1 0.000 0.000 0.036 0.036 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:378(getElm) 1 0.000 0.000 0.036 0.036 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 1 0.000 0.000 0.036 0.036 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 1 0.000 0.000 0.036 0.036 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 2 0.000 0.000 0.036 0.018 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 2 0.000 0.000 0.036 0.018 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 331 0.000 0.000 0.035 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1009(processSpaceCharactersNonPre) 1 0.000 0.000 0.033 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:65(build_email_re) 684 0.002 0.000 0.032 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild) 596/579 0.001 0.000 0.029 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2076(_matches) 679 0.007 0.000 0.028 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:576(object_was_parsed) 36 0.000 0.000 0.028 0.001 :1007(get_code) 855 0.008 0.000 0.027 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/formatter.py:75(substitute) 24 0.000 0.000 0.026 0.001 /usr/lib/python3.11/re/_compiler.py:511(_compile_info) 1 0.000 0.000 0.025 0.025 /data/ebri/current/libs/framework/baseScrapeAndDrape.py:447(_addToHead) 36 0.000 0.000 0.025 0.001 :727(_compile_bytecode)