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.058 s
cpu time = 0.370 s
real time = 0.581 s
memory increase = 13648 kB
fields = oauth: '1'
service: '/forms/oauth/authorize?client_id=maxxinternal&response_type=code&state=http%3a%2f%2fwww.fmiam.maxx.matrixdev.net%2fdocs%2fdefault-source%2fgr%2ffda-sesame-comments%5f12312018.pdf%3fsfvrsn%3de7a4b6e%5f2&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 = 38 queries

Total TimeCountAvg TimeQuery
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`='hasShowPassword' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0071 call
1 row
0.007 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.0071 call
1 row
0.007 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.0071 call
1 row
0.007 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.0071 call
1 row
0.007 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`='loginText' 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`='existingUserHeaderText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0042 calls
0 rows
0.002 COMMIT
0.0011 call
11 rows
0.001 DESCRIBE Ticket
0.0011 call
0 rows
0.001 UPDATE `PageRequest` SET `mxxUpdated`='2025-12-26 13:18:29',`mxxUpdatedBy`=NULL, `PageRequestId`=0xF56B3D00000002, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='3348600', `requestNum`='3', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='510485', `startTime`='2025-12-26 13:18:29', `sessionId`=0x66488BE4B4063E03, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0004487037658691406', `timeTaken`='0', `dictSize`='0', `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'http://www.fmiam.maxx.matrixdev.net/docs/default-source/gr/fda-sesame-comments_12312018.pdf?sfvrsn=e7a4b6e_2\\'}', `clientIPAddr`='216.73.216.150' WHERE `PageRequestId`=0xF56B3D00000002
0.0012 calls
1 row
0.001 SELECT DISTINCT hex(`Meeting`.`MeetingId`) AS `MeetingId`, `Meeting`.`name`, `Meeting`.`hostName`, `Meeting`.`description`, `Meeting`.`audienceDescription`, `Meeting`.`cosponsors`, `Meeting`.`includes`, `Meeting`.`attire`, `Meeting`.`cancellationPolicy`, `Meeting`.`thankYouText`, `Meeting`.`registrationStarts`, `Meeting`.`registrationEnds`, `Meeting`.`earlybirdCutoff`, `Meeting`.`onlineRegistrationsEnabled`, `Meeting`.`selectSessionsOnRegForm`, `Meeting`.`accountingCode`, `Meeting`.`maximumNumAttendees`, `Meeting`.`type`, `Meeting`.`showPublicSessionSearch`, `Meeting`.`allowSpouseReg`, `Meeting`.`continuingEdUnits`, `Meeting`.`mediaAllowed`, `Meeting`.`travelInfo`, `Meeting`.`hotelBlurb`, `Meeting`.`dateClosed`, `Meeting`.`showFeesOnPublicView`, `Meeting`.`eventId`, `Meeting`.`showPublicSchedule`, `Meeting`.`calendarLinkType`, `Meeting`.`calendarBlurb`, `Meeting`.`retainedEarningsAcctCode`, `Meeting`.`enableHousing`, `Meeting`.`staffNotificationEmail`, `Meeting`.`paymentInstructions`, `Meeting`.`staffCancellationEmail`, `Meeting`.`lowRoomTrigger`, `Meeting`.`continuingEdNumber`, `Meeting`.`enableRSVP`, `Meeting`.`micrositePath`, `Meeting`.`bgcolor`, `Meeting`.`accentColor`, `Meeting`.`tabTitleColor`, `Meeting`.`bodyTextColor`, `Meeting`.`linkTextColor`, `Meeting`.`rightNavTextColor`, `Meeting`.`fontTitleSize`, `Meeting`.`fontBodySize`, `Meeting`.`fontName`, `Meeting`.`navbarColor`, `Meeting`.`sidebarColor`, `Meeting`.`highlightedTabTextColor`, `Meeting`.`headlineColor`, `Meeting`.`highlightedTabColor`, `Meeting`.`inSiteAccentColor`, `Meeting`.`inSiteBodyTextColor`, `Meeting`.`inSiteHeadlineColor`, `Meeting`.`inSiteHighlightedTabColor`, `Meeting`.`inSiteHighlightedTabTextColor`, `Meeting`.`inSiteLinkTextColor`, `Meeting`.`inSiteNavbarColor`, `Meeting`.`inSiteRightNavTextColor`, `Meeting`.`inSiteSidebarColor`, `Meeting`.`inSiteTabTitleColor`, `Meeting`.`inSiteFontBodySize`, `Meeting`.`inSiteFontName`, `Meeting`.`inSiteFontTitleSize`, `Meeting`.`useBadges`, `Meeting`.`staffNotificationRevisitedEmail`, `Meeting`.`anticipatedRegistrations`, `Meeting`.`_budgetedRevenue`, `Meeting`.`groupRegistrationOn`, `Meeting`.`allowPlaceholders`, `Meeting`.`feesPageTopText`, `Meeting`.`badgesPageTopText`, `Meeting`.`questionsPageTopText`, `Meeting`.`eventsPageTopText`, `Meeting`.`reviewPageTopText`, `Meeting`.`paymentPageTopText`, `Meeting`.`micrositeTemplate`, `Meeting`.`inSiteTemplate`, `Meeting`.`isWebinar`, `Meeting`.`housingPageTopText`, `Meeting`.`attendeesPageTopText`, `Meeting`.`shortCalDescription`, `Meeting`.`allowAddToCalendar`, `Meeting`.`campaignCode`, `Meeting`.`recordOrigin`, `Meeting`.`additionalFeesPageTopText`, `Meeting`.`apptScheduler`, `Meeting`.`hasReferrals`, `Meeting`.`referralText`, `Meeting`.`wwwRegistrationsEditAlwaysApprove`, `Meeting`.`thankYouFullyPaidText`, `Meeting`.`venue`, `Meeting`.`sendToLMS`, `Meeting`.`showSponsorLogos`, `Meeting`.`confSponsorText`, `Meeting`.`isArchived` FROM (Meeting) WHERE `Meeting`.`MeetingId`=0x334A0000034E
0.0012 calls
1 row
0.001 SELECT DISTINCT `CalendarItem`.`type`, `CalendarItem`.`startDate`, `CalendarItem`.`endDate`, `CalendarItem`.`location`, hex(`CalendarItem`.`CalendarItemId`) AS `CalendarItemId`, `CalendarItem`.`name`, `CalendarItem`.`status`, `CalendarItem`.`contactName`, `CalendarItem`.`contactPhone`, `CalendarItem`.`contactEmail`, `CalendarItem`.`description`, `CalendarItem`.`URL`, `CalendarItem`.`URLDescription`, `CalendarItem`.`handOut`, `CalendarItem`.`handOutDescription`, `CalendarItem`.`minutesUpload`, `CalendarItem`.`minutes`, `CalendarItem`.`phone`, `CalendarItem`.`fax`, `CalendarItem`.`line1`, `CalendarItem`.`line2`, `CalendarItem`.`city`, `CalendarItem`.`province`, `CalendarItem`.`zip`, `CalendarItem`.`state`, `CalendarItem`.`country`, `CalendarItem`.`attendeeNames` FROM (Meeting, CalendarItem) WHERE `CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x334A0000034E ORDER BY `CalendarItem`.`startDate`
0.0015 calls
1 row
0.000 SELECT version from databasemap;
0.0012 calls
1 row
0.000 SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Address, Meeting) WHERE `Meeting`.`MeetingId`=0x334A0000034E AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0012 calls
1 row
0.000 SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (Timezone, CalendarItem) WHERE `CalendarItem`.`CalendarItemId`=0x334A00000357 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`
0.0011 call
0 rows
0.001 INSERT INTO `Ticket` SET `mxxCreated`='2025-12-26 13:18:29',`mxxCreatedBy`=NULL, `TicketId`=0xF56B3D00000004, `type`='2', `value`='LT-1766773109-tMsgKPC5mVuVPCflZK94NkMpmf6GRPrE', `expires`='2025/12/26 14:48:29.8032 US/Eastern', `username`=NULL, `service`='/forms/oauth/authorize?client_id=maxxinternal&response_type=code&state=http%3a%2f%2fwww.fmiam.maxx.matrixdev.net%2fdocs%2fdefault-source%2fgr%2ffda-sesame-comments%5f12312018.pdf%3fsfvrsn%3de7a4b6e%5f2&redirect_uri=https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/', `isPrimary`='2'
0.0001 call
173 rows
0.000 SELECT * FROM webselect
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-26 13:18:29',`mxxCreatedBy`=NULL, `PageRequestId`=0xF56B3D00000002, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='3348600', `requestNum`='3', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='510485', `startTime`='2025-12-26 13:18:29', `sessionId`=0x66488BE4B4063E03, `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\\':\\'http://www.fmiam.maxx.matrixdev.net/docs/default-source/gr/fda-sesame-comments_12312018.pdf?sfvrsn=e7a4b6e_2\\'}', `clientIPAddr`='216.73.216.150'
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-26 13:18:29',`mxxCreatedBy`=NULL, `PageRequestId`=0xF56B3D00000003, `path`='forms/cas/login', `formName`='fmiam_cas', `site`='www', `clientAcronym`='FMI', `pid`='3348600', `requestNum`='4', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='510485', `startTime`='2025-12-26 13:18:29', `sessionId`=0x66488BE4B4063E03, `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=http%3a%2f%2fwww.fmiam.maxx.matrixdev.net%2fdocs%2fdefault-source%2fgr%2ffda-sesame-comments%5f12312018.pdf%3fsfvrsn%3de7a4b6e%5f2&redirect_uri=https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\'}', `clientIPAddr`='216.73.216.150'
0.0002 calls
0 rows
0.000 SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0x33BF00000002 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2025-12-26 13:10:49',`mxxUpdatedBy`=NULL, `PageRequestId`=0xF56B3D00000000, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3348600', `requestNum`='1', `objectId`='334A0000034E', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='510485', `startTime`='2025-12-26 13:10:49', `sessionId`=0x6277840E3012C6C8, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.006597757339477539', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'334A0000034E\\'}', `clientIPAddr`='216.73.216.150' WHERE `PageRequestId`=0xF56B3D00000000
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-26 13:10:49',`mxxCreatedBy`=NULL, `PageRequestId`=0xF56B3D00000000, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3348600', `requestNum`='1', `pageDictSize`=NULL, `objectId`='334A0000034E', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='510485', `startTime`='2025-12-26 13:10:49', `sessionId`=0x6277840E3012C6C8, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'334A0000034E\\'}', `clientIPAddr`='216.73.216.150'
0.0002 calls
0 rows
0.000 START TRANSACTION
0.0001 call
0 rows
0.000 UPDATE `PageRequest` SET `mxxUpdated`='2025-12-26 13:12:20',`mxxUpdatedBy`=NULL, `PageRequestId`=0xF56B3D00000001, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3348600', `requestNum`='2', `objectId`='334A0000034E', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='510485', `startTime`='2025-12-26 13:12:20', `sessionId`=0x21462AE8ABC9E7FC, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0018758773803710938', `timeTaken`='0', `dictSize`='0', `fields`='{\\'id\\':\\'334A0000034E\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.150' WHERE `PageRequestId`=0xF56B3D00000001
0.0001 call
0 rows
0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-12-26 13:12:20',`mxxCreatedBy`=NULL, `PageRequestId`=0xF56B3D00000001, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3348600', `requestNum`='2', `pageDictSize`=NULL, `objectId`='334A0000034E', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='510485', `startTime`='2025-12-26 13:12:20', `sessionId`=0x21462AE8ABC9E7FC, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'334A0000034E\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.150'
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE