LOG IN

Log In

To access our some of our exclusive contents and features, we'll need you to login so we can verify who you are! If you've been here before or we've sent you an email, you've got an account. New to our awesomeness? Then you probably need to create a profile and tell us a little bit about yourself. ...

Already have a login?

Username:


Password:


Show password:

I'm New Here

First Name: *
Last Name: *
Email: *
Pssst. Having issues? Need to talk to a real human for some help? Call us at 555-555-5555!
Debugging Info
pagedictsize=0
sqltime = 0.032 s
cpu time = 0.250 s
real time = 0.565 s
memory increase = 12468 kB
fields = service: '/users_only/membership/PrimaryContactManagementPublic/view'
templates =
/data/demo/current/generic/themes/shared/mako/login/caslogin
scrapeAndDrape (CACHED) stub: https://www.demo.matrixmaxx.com/default-mx-stub/ (/data/demo/current/demo_org/cachedFiles//cachedStub___forms__cas__login)
dg = [] | []
extra debug info =
queries = 28 queries

Total TimeCountAvg TimeQuery
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.0051 call
1 row		0.005 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
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`='forgotPasswordLinkText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0041 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`='loginText' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0031 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.0022 calls
0 rows		0.001 COMMIT
0.0021 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.0021 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`='hideNewUser' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0022 calls
0 rows		0.001 START TRANSACTION
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
11 rows		0.001 DESCRIBE Ticket
0.0011 call
6 rows		0.001 SELECT DISTINCT hex(`MicrositeTab`.`MicrositeTabId`) AS `MicrositeTabId`, `MicrositeTab`.`title`, `MicrositeTab`.`orderindex`, `MicrositeTab`.`enabled`, `MicrositeTab`.`isInSite` FROM (Meeting, MicrositeTab) WHERE `MicrositeTab`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x4376000000D8
0.0013 calls
1 row		0.000 SELECT version from databasemap;
0.0011 call
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`.`showPublicSchedule`, `Meeting`.`calendarLinkType`, `Meeting`.`calendarBlurb`, `Meeting`.`retainedEarningsAcctCode`, `Meeting`.`enableHousing`, `Meeting`.`eventId`, `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`.`referralText`, `Meeting`.`hasReferrals`, `Meeting`.`wwwRegistrationsEditAlwaysApprove`, `Meeting`.`thankYouFullyPaidText`, `Meeting`.`venue`, `Meeting`.`sendToLMS`, `Meeting`.`CEU_frac`, `Meeting`.`showSponsorLogos`, `Meeting`.`confSponsorText`, `Meeting`.`isArchived` FROM (Meeting) WHERE `Meeting`.`MeetingId`=0x4376000000D8
0.0001 call
1 row		0.000 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`=0x4376000000D8 ORDER BY `CalendarItem`.`startDate`
0.0001 call
155 rows		0.000 SELECT * FROM webselect
0.0001 call
0 rows		0.000 INSERT INTO `Ticket` SET `mxxCreated`='2025-08-21 22:56:56',`mxxCreatedBy`=NULL, `TicketId`=0x1F4EDC00000002, `type`='2', `value`='LT-1755831416-deONl9hU5RV9brQ3Wi1sUEb0pMssxNE0', `expires`='2025/08/22 00:26:56.1649 US/Eastern', `username`=NULL, `service`='/users_only/membership/PrimaryContactManagementPublic/view', `isPrimary`='2'
0.0001 call
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` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x4376000000D8 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0001 call
0 rows		0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-21 22:56:56',`mxxCreatedBy`=NULL, `PageRequestId`=0x1F4EDC00000001, `path`='forms/cas/login', `formName`='cas', `site`='www', `clientAcronym`='DEMO', `pid`='2998214', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.demo.maxx.matrixdev.net', `dbThreadId`='655393', `startTime`='2025-08-21 22:56:56', `sessionId`=0x63D60CFC8FEAF981, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'service\\':\\'/users_only/membership/PrimaryContactManagementPublic/view\\'}', `clientIPAddr`='216.73.216.122'
0.0001 call
0 rows		0.000 INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-21 22:55:09',`mxxCreatedBy`=NULL, `PageRequestId`=0x1F4EDC00000000, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='MeetingFormPublic', `site`='www', `clientAcronym`='DEMO', `pid`='2998214', `requestNum`='1', `pageDictSize`=NULL, `objectId`='4376000000D8', `templateMethod`=NULL, `growth`=NULL, `server`='www.demo.maxx.matrixdev.net', `dbThreadId`='655393', `startTime`='2025-08-21 22:55:09', `sessionId`=0x36D93C3B5B32DE7C, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'4376000000D8\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.122'
0.0001 call
0 rows		0.000 UPDATE `PageRequest` SET `mxxUpdated`='2025-08-21 22:55:09',`mxxUpdatedBy`=NULL, `PageRequestId`=0x1F4EDC00000000, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='MeetingFormPublic', `site`='www', `clientAcronym`='DEMO', `pid`='2998214', `requestNum`='1', `objectId`='4376000000D8', `growth`='0', `server`='www.demo.maxx.matrixdev.net', `dbThreadId`='655393', `startTime`='2025-08-21 22:55:09', `sessionId`=0x36D93C3B5B32DE7C, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.00587773323059082', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'4376000000D8\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.122' WHERE `PageRequestId`=0x1F4EDC00000000
0.0001 call
1 row		0.000 SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x4376000000E4 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`
0.0001 call
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`=0x4376000000E6 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
1 row		0.000 SELECT * FROM uuid FOR UPDATE