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.

Member Log In

Username:


Password:


I'm New Here

First Name: *
Last Name: *
Email: *
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.

Debugging Info
pagedictsize=0
sqltime = 0.007 s
cpu time = 0.210 s
real time = 0.217 s
memory increase = 12564 kB
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%2fstate-by-state-participation-in-pension-retirement-plans-in-2007&redirect_uri=https://www.ebri.org/mxt/authservice/callback/'
templates =
/data/ebri/current/generic/themes/shared/mako/login/caslogin
scrapeAndDrape (CACHED) stub: https://www.ebri.maxx.matrixdev.net/login/maxx-login-stub (/data/ebri/current/ebri_org/cachedFiles//cachedStub___forms__cas__login)
dg = [] | []
extra debug info =
queries = 30 queries

Total TimeCountAvg TimeQuery
0.0042 calls
0 rows
0.002 COMMIT
0.0041 call
0 rows
0.004 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-17 21:03:11',`mxxCreatedBy`=NULL, `PageRequestId`=0x5FCBE800000002, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='3', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:03:11', `sessionId`=0xE050E4D5FD36F6D, `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/health-insurance-trends-in-availability-and-cost\\'}', `clientIPAddr`='216.73.217.69'
0.0031 call
0 rows
0.003 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-17 21:03:11',`mxxUpdatedBy`=NULL, `PageRequestId`=0x5FCBE800000002, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='3', `growth`='0', `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:03:11', `sessionId`=0xE050E4D5FD36F6D, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0035440921783447266', `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/health-insurance-trends-in-availability-and-cost\\'}', `clientIPAddr`='216.73.217.69' WHERE `PageRequestId`=0x5FCBE800000002
0.0011 call
11 rows
0.001 DESCRIBE Ticket
0.0011 call
1 row
0.001 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.0011 call
1 row
0.001 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.0011 call
1 row
0.001 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.0011 call
1 row
0.001 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.0011 call
1 row
0.001 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.0011 call
1 row
0.001 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.0011 call
1 row
0.001 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.0011 call
1 row
0.001 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.0001 call
159 rows
0.000 SELECT * FROM webselect
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-17 21:02:55',`mxxCreatedBy`=NULL, `PageRequestId`=0x5FCBE800000000, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:02:55', `sessionId`=0x330FBF5645374D8D, `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/benefits-costs-state-and-local-governments-vs.-private-sector\\'}', `clientIPAddr`='216.73.217.69'
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-17 21:03:20',`mxxCreatedBy`=NULL, `PageRequestId`=0x5FCBE800000003, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='4', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:03:20', `sessionId`=0xE050E4D5FD36F6D, `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/expected-age-of-retirement-and-working-in-retirement\\'}', `clientIPAddr`='216.73.217.69'
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-17 21:03:30',`mxxCreatedBy`=NULL, `PageRequestId`=0x5FCBE800000005, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='6', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:03:30', `sessionId`=0xE050E4D5FD36F6D, `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/state-by-state-participation-in-pension-retirement-plans-in-2007\\'}', `clientIPAddr`='216.73.217.69'
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-17 21:02:59',`mxxCreatedBy`=NULL, `PageRequestId`=0x5FCBE800000001, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:02:59', `sessionId`=0x330FBF5645374D8D, `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/where-do-american-workers-expect-to-get-retirement-income\\'}', `clientIPAddr`='216.73.217.69'
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-17 21:03:20',`mxxUpdatedBy`=NULL, `PageRequestId`=0x5FCBE800000003, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='4', `growth`='0', `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:03:20', `sessionId`=0xE050E4D5FD36F6D, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.00037169456481933594', `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/expected-age-of-retirement-and-working-in-retirement\\'}', `clientIPAddr`='216.73.217.69' WHERE `PageRequestId`=0x5FCBE800000003
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-17 21:02:55',`mxxUpdatedBy`=NULL, `PageRequestId`=0x5FCBE800000000, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='1', `growth`='0', `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:02:55', `sessionId`=0x330FBF5645374D8D, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.005109548568725586', `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/benefits-costs-state-and-local-governments-vs.-private-sector\\'}', `clientIPAddr`='216.73.217.69' WHERE `PageRequestId`=0x5FCBE800000000
0.0002 calls
0 rows
0.000 START TRANSACTION
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-17 21:03:30',`mxxUpdatedBy`=NULL, `PageRequestId`=0x5FCBE800000005, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='6', `growth`='0', `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:03:30', `sessionId`=0xE050E4D5FD36F6D, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.00036525726318359375', `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/state-by-state-participation-in-pension-retirement-plans-in-2007\\'}', `clientIPAddr`='216.73.217.69' WHERE `PageRequestId`=0x5FCBE800000005
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-17 21:02:59',`mxxUpdatedBy`=NULL, `PageRequestId`=0x5FCBE800000001, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='2', `growth`='0', `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:02:59', `sessionId`=0x330FBF5645374D8D, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.00035881996154785156', `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/where-do-american-workers-expect-to-get-retirement-income\\'}', `clientIPAddr`='216.73.217.69' WHERE `PageRequestId`=0x5FCBE800000001
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-17 21:03:30',`mxxCreatedBy`=NULL, `PageRequestId`=0x5FCBE800000006, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='7', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:03:30', `sessionId`=0xE050E4D5FD36F6D, `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%2fstate-by-state-participation-in-pension-retirement-plans-in-2007&redirect_uri=https://www.ebri.org/mxt/authservice/callback/\\'}', `clientIPAddr`='216.73.217.69'
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2026-04-17 21:03:25',`mxxCreatedBy`=NULL, `PageRequestId`=0x5FCBE800000004, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='5', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:03:25', `sessionId`=0xE050E4D5FD36F6D, `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/goals-for-reforming-the-u.s.-health-care-system\\'}', `clientIPAddr`='216.73.217.69'
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2026-04-17 21:03:25',`mxxUpdatedBy`=NULL, `PageRequestId`=0x5FCBE800000004, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='EBRI', `pid`='2275219', `requestNum`='5', `growth`='0', `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='734578', `startTime`='2026-04-17 21:03:25', `sessionId`=0xE050E4D5FD36F6D, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0002956390380859375', `timeTaken`='1', `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/goals-for-reforming-the-u.s.-health-care-system\\'}', `clientIPAddr`='216.73.217.69' WHERE `PageRequestId`=0x5FCBE800000004
0.0001 call
0 rows
0.000 INSERT INTO `Ticket` SET `mxxCreated`='2026-04-17 21:03:30',`mxxCreatedBy`=NULL, `TicketId`=0x5FCBE800000007, `type`='2', `value`='LT-1776474210-6Fq9hwKNGK2fsbxis5XtkpDCjeogN9Ln', `expires`='2026/04/17 22:33:30.7152 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%2fstate-by-state-participation-in-pension-retirement-plans-in-2007&redirect_uri=https://www.ebri.org/mxt/authservice/callback/', `isPrimary`='2'
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
1 row
0.000 SELECT version from databasemap;