Sign In

Log In with Password

Username:


Password:


Show password:

Keep me logged in:

Create New Account

First Name: *
Last Name: *
Email: *
Debugging Info
pagedictsize=0
sqltime = 0.081 s
cpu time = 0.380 s
real time = 0.957 s
memory increase = 13512 kB
fields = oauth: '1'
service: '/forms/oauth/authorize?client_id=maxxinternal&response_type=code&state=https%3a%2f%2fwww.fmiam.maxx.matrixdev.net%2fgovernment-affairs%2fstate-affairs%2fissue-papers%2fview%2fstate-affairs-issue-papers%2f2022%2f09%2f23%2fstate-inform-act-laws&redirect_uri=https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/'
templates =
/data/fmiam/current/generic/themes/shared/mako/login/caslogin
scrapeAndDrape (CACHED) stub: https://www.fmiam.maxx.matrixdev.net/scrape.axd?target=https://www.fmiam.maxx.matrixdev.net/utility-pages/login-page-stub (/data/fmiam/current/fmiam_org/cachedFiles//cachedStub___forms__cas__login)
dg = [] | []
extra debug info =
queries = 24 queries

Total TimeCountAvg TimeQuery
0.0121 call
1 row		0.012 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.0101 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`='loginText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0101 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`='loginText_bottom' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0101 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`='existingUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0081 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`='hideNewUser' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0081 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`='forgotPasswordLinkText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0081 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`='newUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0061 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.0041 call
0 rows		0.004 INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-08 12:28:19',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA53E00000003, `path`='forms/cas/login', `formName`='fmiam_cas', `site`='www', `clientAcronym`='FMI', `pid`='2476122', `requestNum`='4', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1420407', `startTime`='2025-09-08 12:28:19', `sessionId`=0x14BF039604EB611, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'oauth\\':\\'1\\', \\'service\\':\\'/forms/oauth/authorize?client_id=maxxinternal&response_type=code&state=https%3a%2f%2fwww.fmiam.maxx.matrixdev.net%2fgovernment-affairs%2fstate-affairs%2fissue-papers%2fview%2fstate-affairs-issue-papers%2f2022%2f09%2f23%2fstate-inform-act-laws&redirect_uri=https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\'}', `clientIPAddr`='216.73.216.129'
0.0032 calls
0 rows		0.002 COMMIT
0.0031 call
0 rows		0.003 UPDATE `PageRequest` SET `mxxUpdated`='2025-09-08 12:28:19',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFA53E00000002, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='2476122', `requestNum`='3', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1420407', `startTime`='2025-09-08 12:28:19', `sessionId`=0x14BF039604EB611, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0018551349639892578', `timeTaken`='1', `dictSize`='0', `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'https://www.fmiam.maxx.matrixdev.net/government-affairs/state-affairs/issue-papers/view/state-affairs-issue-papers/2022/09/23/state-inform-act-laws\\'}', `clientIPAddr`='216.73.216.129' WHERE `PageRequestId`=0xCFA53E00000002
0.0021 call
1 row		0.002 SELECT version from databasemap;
0.0021 call
0 rows		0.002 INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-08 12:28:19',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA53E00000002, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='2476122', `requestNum`='3', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1420407', `startTime`='2025-09-08 12:28:19', `sessionId`=0x14BF039604EB611, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'https://www.fmiam.maxx.matrixdev.net/government-affairs/state-affairs/issue-papers/view/state-affairs-issue-papers/2022/09/23/state-inform-act-laws\\'}', `clientIPAddr`='216.73.216.129'
0.0012 calls
0 rows		0.001 START TRANSACTION
0.0011 call
11 rows		0.001 DESCRIBE Ticket
0.0011 call
173 rows		0.001 SELECT * FROM webselect
0.0001 call
0 rows		0.000 UPDATE `PageRequest` SET `mxxUpdated`='2025-09-08 12:28:07',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFA53E00000001, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='2476122', `requestNum`='2', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1420407', `startTime`='2025-09-08 12:28:07', `sessionId`=0xAABF7C6CFD00D23, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.00030040740966796875', `timeTaken`='0', `dictSize`='0', `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'https://www.fmiam.maxx.matrixdev.net/government-affairs/state-affairs/issue-papers/view/state-affairs-issue-papers/2022/03/16/minimum-recycled-content\\'}', `clientIPAddr`='216.73.216.129' WHERE `PageRequestId`=0xCFA53E00000001
0.0001 call
0 rows		0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-08 12:28:05',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA53E00000000, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='2476122', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1420407', `startTime`='2025-09-08 12:28:05', `sessionId`=0xAABF7C6CFD00D23, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'https://www.fmiam.maxx.matrixdev.net/government-affairs/state-affairs/issue-papers/view/state-affairs-issue-papers/2021/07/15/state-and-local-limits-on-facial-recognition-technology\\'}', `clientIPAddr`='216.73.216.129'
0.0001 call
0 rows		0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-08 12:28:07',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA53E00000001, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='2476122', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1420407', `startTime`='2025-09-08 12:28:07', `sessionId`=0xAABF7C6CFD00D23, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'https://www.fmiam.maxx.matrixdev.net/government-affairs/state-affairs/issue-papers/view/state-affairs-issue-papers/2022/03/16/minimum-recycled-content\\'}', `clientIPAddr`='216.73.216.129'
0.0001 call
0 rows		0.000 INSERT INTO `Ticket` SET `mxxCreated`='2025-09-08 12:28:19',`mxxCreatedBy`=NULL, `TicketId`=0xCFA53E00000004, `type`='2', `value`='LT-1757348899-oiidlXImQXM1VRl6xhblIyEwLmhXJ3VN', `expires`='2025/09/08 13:58:19.657 US/Eastern', `username`=NULL, `service`='/forms/oauth/authorize?client_id=maxxinternal&response_type=code&state=https%3a%2f%2fwww.fmiam.maxx.matrixdev.net%2fgovernment-affairs%2fstate-affairs%2fissue-papers%2fview%2fstate-affairs-issue-papers%2f2022%2f09%2f23%2fstate-inform-act-laws&redirect_uri=https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/', `isPrimary`='2'
0.0001 call
0 rows		0.000 UPDATE `PageRequest` SET `mxxUpdated`='2025-09-08 12:28:05',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFA53E00000000, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='2476122', `requestNum`='1', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1420407', `startTime`='2025-09-08 12:28:05', `sessionId`=0xAABF7C6CFD00D23, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0038318634033203125', `timeTaken`='0', `dictSize`='0', `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'https://www.fmiam.maxx.matrixdev.net/government-affairs/state-affairs/issue-papers/view/state-affairs-issue-papers/2021/07/15/state-and-local-limits-on-facial-recognition-technology\\'}', `clientIPAddr`='216.73.216.129' WHERE `PageRequestId`=0xCFA53E00000000
0.0001 call
1 row		0.000 SELECT * FROM uuid FOR UPDATE