Debugging Info
pagedictsize=0
sqltime = 0.093 s
cpu time = 0.170 s
real time = 0.822 s
memory increase = 6660 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%2frecent-trends-in-self-insurance&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 = 20 queries

Total TimeCountAvg TimeQuery
0.0102 calls
0 rows		0.005 START TRANSACTION
0.0101 call
1 row		0.010 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.0091 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`='loginHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0081 call
1 row		0.008 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.0081 call
1 row		0.008 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.0082 calls
0 rows		0.004 COMMIT
0.0081 call
1 row		0.008 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.0071 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`='newUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0061 call
1 row		0.006 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.0051 call
1 row		0.005 SELECT version from databasemap;
0.0041 call
0 rows		0.004 INSERT INTO `Ticket` SET `mxxCreated`='2026-06-15 16:15:25', `mxxCreatedBy`=NULL, `TicketId`=0x6018D900000001, `type`='2', `value`='LT-1781554525-feAtXpv03o5bvLPQl4cenu9TWCxiwyV5', `expires`='2026/06/15 17:45:25.7456 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%2frecent-trends-in-self-insurance&redirect_uri=https://www.ebri.org/mxt/authservice/callback/', `isPrimary`='2'
0.0031 call
1 row		0.003 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.0021 call
1 row		0.002 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.0021 call
1 row		0.002 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.0021 call
159 rows		0.002 SELECT * FROM webselect
0.0011 call
0 rows		0.001 INSERT INTO `PageRequest` SET `mxxCreated`='2026-06-15 16:15:25', `mxxCreatedBy`=NULL, `PageRequestId`=0x6018D900000000, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='EBRI', `pid`='1846479', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.ebri.maxx.matrixdev.net', `dbThreadId`='876059', `startTime`='2026-06-15 16:15:25', `sessionId`=0x6838A81CC2A73B12, `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%2frecent-trends-in-self-insurance&redirect_uri=https://www.ebri.org/mxt/authservice/callback/\\'}', `clientIPAddr`='216.73.216.187'
0.0011 call
11 rows		0.001 DESCRIBE Ticket
0.0001 call
1 row		0.000 SELECT * FROM uuid FOR UPDATE