FMI Midwest Regional Meeting: Hotel Information

Hyatt Centric Magnificent Mile

January 7, 2020 - Chicago, IL

633 N. St. Clair St.

Chicago, IL 60611

Phone: 312-787-1234

Room Rate: $110

Hotel Block Cut-Off Date: December 10, 2019

Click here to make your reservation

Total Time

Count

Avg Time

Query

0.055

1 call
0 rows

0.055

SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Website, Meeting) WHERE `Website`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x5B7F99000000E7

0.012

1 call
1 row

0.012

SELECT DISTINCT hex(`MicrositeTabComponent`.`MicrositeTabComponentId`) AS `MicrositeTabComponentId`, `MicrositeTabComponent`.`type`, `MicrositeTabComponent`.`text`, `MicrositeTabComponent`.`orderindex` FROM (MicrositeTab, MicrositeTabComponent) WHERE `MicrositeTabComponent`.`MicrositeTabId`=`MicrositeTab`.`MicrositeTabId` AND `MicrositeTab`.`MicrositeTabId`=0x5B7F99000000F0 ORDER BY `MicrositeTabComponent`.`orderindex`

0.011

24 calls
1 row

0.000

SELECT version from databasemap;

0.008

1 call
1 row

0.008

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`, `Meeting`.`hideIntranetSummary` FROM (Meeting) WHERE `Meeting`.`micrositePath`='midwest-regional-meeting-2020'

0.007

1 call
6 rows

0.007

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`=0x5B7F99000000E7

0.004

1 call
0 rows

0.004

COMMIT

0.004

1 call
1 row

0.004

SELECT DISTINCT hex(`FeeDateRange`.`FeeDateRangeId`) AS `FeeDateRangeId`, `FeeDateRange`.`name`, `FeeDateRange`.`startDate`, `FeeDateRange`.`endDate` FROM (Meeting, FeeDateRange) WHERE `FeeDateRange`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x5B7F99000000E7

0.003

1 call
1 row

0.003

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`=0x38723A00000368 ORDER BY `CalendarItem`.`startDate`

0.003

1 call
1 row

0.003

0.002

1 call
0 rows

0.002

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 23:57:42',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB993500000001, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='2', `objectId`='38723A00000368', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:42', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0043792724609375', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'38723A00000368\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB993500000001

0.002

1 call
1 row

0.002

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 (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x395180000036D AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.002

1 call
1 row

0.002

SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (Timezone, CalendarItem) WHERE `CalendarItem`.`CalendarItemId`=0x3951800000375 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x3951800000370 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.002

1 call
173 rows

0.002

SELECT * FROM webselect

0.001

1 call
0 rows

0.001

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 23:57:44',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB993500000006, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='7', `objectId`='395180000036D', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:44', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.010232210159301758', `timeTaken`='0', `dictSize`='0', `fields`='{\\'id\\':\\'395180000036D\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB993500000006

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (Timezone, CalendarItem) WHERE `CalendarItem`.`CalendarItemId`=0x1EA3A600000555 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Branch, Address) WHERE `Address`.`AddressId`=0x1EA3A600000552 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.001

1 call
1 row

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`MyMeeting`.`MyMeetingId`) AS `MyMeetingId`, `MyMeeting`.`published`, `MyMeeting`.`description`, `MyMeeting`.`mxxCreated`, hex(`MyMeeting`.`mxxCreatedBy`) AS `mxxCreatedBy`, `MyMeeting`.`mxxUpdated`, hex(`MyMeeting`.`mxxUpdatedBy`) AS `mxxUpdatedBy`, `MyMeeting`.`rule`, `MyMeeting`.`introText`, `MyMeeting`.`embedCode` FROM (MyMeeting, Meeting) WHERE `MyMeeting`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x5B7F99000000E7

0.001

1 call
2 rows

0.001

SELECT DISTINCT hex(`Fee`.`FeeId`) AS `FeeId`, `Fee`.`expirationDate`, `Fee`.`amount`, hex(`Fee`.`itemId`) AS `itemId`, `Fee`.`name`, `Fee`.`description`, `Fee`.`minGroupSize`, `Fee`.`isEarlyDiscount`, `Fee`.`membersOnly`, `Fee`.`guestsOnly`, `Fee`.`availableToGuests`, `Fee`.`accountingCode`, `Fee`.`availableToSpouses`, `Fee`.`feeCode`, `Fee`.`published`, `Fee`.`rateCategory`, `Fee`.`showOnWWW`, `Fee`.`showMembershipTypesAsMembersOnWWW`, `Fee`.`membershipTypesLabelForWWW`, `Fee`.`groupSizeRule`, `Fee`.`specialDealType`, `Fee`.`recordOrigin`, `Fee`.`confirmationText` FROM (Meeting, Fee) WHERE `Fee`.`itemId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x5B7F99000000E7

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
0 rows

0.001

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 23:57:42',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB993500000000, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='1', `pageDictSize`=NULL, `objectId`='1EA3A60000054F', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:42', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'1EA3A60000054F\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107'

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
54 rows

0.001

SELECT * FROM StateProvince ORDER BY orderindex, id

0.001

1 call
1 row

0.001

1 call
1 row

0.001

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 (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x5B7F99000000E7 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Individual`.`IndividualId`) AS `IndividualId`, `Individual`.`EthnicityId`, `Individual`.`firstName`, `Individual`.`lastName`, `Individual`.`prefix`, `Individual`.`suffix`, `Individual`.`title`, `Individual`.`mxxUpdatedBy`, `Individual`.`enteredBy`, `Individual`.`gender`, `Individual`.`SalaryId`, `Individual`.`ssn`, `Individual`.`middleInitial`, `Individual`.`email`, `Individual`.`alternateEmail`, `Individual`.`emailFromThirdPartyId`, `Individual`.`mxxUpdated`, `Individual`.`fax`, `Individual`.`homePhone`, `Individual`.`workPhone`, `Individual`.`secondaryPhone`, `Individual`.`mobilePhone`, `Individual`.`pager`, `Individual`.`IndividualTypeId`, `Individual`.`paidDues`, hex(`Individual`.`VotingId`) AS `VotingId`, `Individual`.`aliases`, `Individual`.`personalStatus`, `Individual`.`salutation`, `Individual`.`homeFax`, `Individual`.`visionsId`, `Individual`.`emailSent`, `Individual`.`personalBackground`, `Individual`.`isTrainer`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`ageGroup`, `Individual`.`degreeLevel`, `Individual`.`maritalStatus`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`otherJobFunction`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`schoolAttended`, `Individual`.`SACompanyName`, `Individual`.`preferredEmailType`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`dontSnailmail`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`criticalNotes`, `Individual`.`originalemail`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`staffLevel`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`doNotEmailFromSharpspring`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Individual, Address) WHERE `Address`.`AddressId`=0x5B7F99000000EA AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Meeting, File) WHERE `Meeting`.`bannerFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x5B7F99000000E7

0.000

1 call
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`=0x5B7F99000000F9 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 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`, `Address`.`dateVerified` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0xD35DA00000116 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 23:57:44',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB993500000006, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='7', `pageDictSize`=NULL, `objectId`='395180000036D', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:44', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'395180000036D\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107'

0.000

1 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`, `Address`.`dateVerified` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x1EA3A60000054F AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
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`=0xD35DA00000119 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.000

1 call
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`=0x38723A0000036D AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.000

1 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`, `Address`.`dateVerified` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x795E100000A76 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
54 rows

0.000

select id, abbreviation from StateProvince

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 23:57:43',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB993500000003, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='4', `objectId`='D35DA00000116', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:43', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.002687692642211914', `timeTaken`='0', `dictSize`='0', `fields`='{\\'id\\':\\'D35DA00000116\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB993500000003

0.000

1 call
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`=0x795E100000A7A AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 23:57:42',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB993500000000, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='1', `objectId`='1EA3A60000054F', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:42', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.010017871856689453', `timeTaken`='2', `dictSize`='0', `fields`='{\\'id\\':\\'1EA3A60000054F\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB993500000000

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 23:57:43',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB993500000002, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='3', `objectId`='795E100000A76', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:43', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0025010108947753906', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'795E100000A76\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB993500000002

0.000

1 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`, `Address`.`dateVerified` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x39A1700000368 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x5B7F99000000EA AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 23:57:42',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB993500000001, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='2', `pageDictSize`=NULL, `objectId`='38723A00000368', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:42', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'38723A00000368\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107'

0.000

1 call
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`=0x39A1700000374 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.000

1 call
0 rows

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 (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x38723A00000368 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 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`, `Address`.`dateVerified` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x3BB3900000382 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
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`=0x3BB39000003EA AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 23:58:31',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB993500000009, `path`='forms/meeting/Microsite/midwest-regional-meeting-2020,1', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='10', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:58:31', `sessionId`=0x7C3F413FEA47A516, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.107'

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 23:57:43',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB993500000003, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='4', `pageDictSize`=NULL, `objectId`='D35DA00000116', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:43', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'D35DA00000116\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107'

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 23:57:43',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB993500000002, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='3', `pageDictSize`=NULL, `objectId`='795E100000A76', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:43', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'795E100000A76\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107'

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 23:57:44',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB993500000005, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='6', `pageDictSize`=NULL, `objectId`='39A1700000368', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:44', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'39A1700000368\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107'

0.000

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0xD35DA00000118 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 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`, `Address`.`dateVerified` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x3DD8B000006D1 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 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`, `Address`.`dateVerified` FROM (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x3CA320000004C AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
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`=0x3DD8B000006D9 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 23:57:44',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB993500000005, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='6', `objectId`='39A1700000368', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:44', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.002377033233642578', `timeTaken`='0', `dictSize`='0', `fields`='{\\'id\\':\\'39A1700000368\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB993500000005

0.000

1 call
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`=0x3CA3200000058 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 23:57:44',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB993500000007, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='8', `objectId`='3CA320000004C', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:44', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0019953250885009766', `timeTaken`='0', `dictSize`='0', `fields`='{\\'id\\':\\'3CA320000004C\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB993500000007

0.000

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x795E100000A78 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 23:57:43',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB993500000004, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='5', `objectId`='3BB3900000382', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:43', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.0023016929626464844', `timeTaken`='0', `dictSize`='0', `fields`='{\\'id\\':\\'3BB3900000382\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB993500000004

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 23:57:44',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB993500000008, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='9', `objectId`='3DD8B000006D1', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:44', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.002004861831665039', `timeTaken`='0', `dictSize`='0', `fields`='{\\'id\\':\\'3DD8B000006D1\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB993500000008

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 23:57:44',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB993500000007, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='8', `pageDictSize`=NULL, `objectId`='3CA320000004C', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:44', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'3CA320000004C\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107'

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 23:57:43',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB993500000004, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='5', `pageDictSize`=NULL, `objectId`='3BB3900000382', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:43', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'3BB3900000382\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107'

0.000

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x39A1700000375 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 23:57:44',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB993500000008, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3966966', `requestNum`='9', `pageDictSize`=NULL, `objectId`='3DD8B000006D1', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='756106', `startTime`='2026-02-11 23:57:44', `sessionId`=0x1E3A68FBA53FA703, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'3DD8B000006D1\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.107'

0.000

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x3DD8B000006D4 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x3BB39000003A3 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 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 (Branch, Address) WHERE `Address`.`AddressId`=0x3CA3200000059 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

START TRANSACTION

127827 function calls (123440 primitive calls) in 0.297 seconds Ordered by: cumulative time List reduced from 1389 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.297 0.297 /data/fmiam/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 0.293 0.293 /data/fmiam/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 0.270 0.270 /data/fmiam/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 0.270 0.270 /data/fmiam/current/generic/sites/www/forms/meeting/Microsite.py:24(index) 4/3 0.000 0.000 0.245 0.082 /data/fmiam/current/libs/framework/MakoTemplate.py:48(__call__) 4 0.000 0.000 0.245 0.061 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:461(render) 4 0.000 0.000 0.245 0.061 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:860(_render) 4 0.000 0.000 0.245 0.061 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:912(_render_context) 4 0.000 0.000 0.245 0.061 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:927(_exec_template) 1 0.000 0.000 0.215 0.215 /tmp/mako_modules_1011/fmiam/www/25.2.1/data/fmiam/current/generic/themes/www/mako/meetings/microsite_index_responsive.html.py:31(render_body) 1 0.000 0.000 0.200 0.200 /tmp/mako_modules_1011/fmiam/www/25.2.1/meetings/microsite_helpers.html.py:244(render_microsite_sidebar) 1 0.000 0.000 0.131 0.131 /tmp/mako_modules_1011/fmiam/www/25.2.1/helpers/meetingHelpers.html.py:57(render_addToCalendarWidget) 2 0.000 0.000 0.123 0.062 /data/fmiam/current/generic/classes/Address.py:297(getPrintPlain) 5 0.000 0.000 0.123 0.025 /data/fmiam/current/libs/utils/htmlTools.py:100(cleanHTML) 2 0.000 0.000 0.123 0.062 /data/fmiam/current/generic/classes/Address.py:340(generatePrettyHTML) 1 0.000 0.000 0.123 0.123 /data/fmiam/current/generic/classes/Meeting.py:3270(getYahooLink) 1 0.000 0.000 0.123 0.123 /data/fmiam/current/libs/utils/calendarUtils.py:13(getYahooLink) 1 0.000 0.000 0.122 0.122 /data/fmiam/current/generic/classes/Meeting.py:3274(getAddress) 31 0.000 0.000 0.099 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 31 0.000 0.000 0.099 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 31 0.000 0.000 0.097 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 31 0.097 0.003 0.097 0.003 {function Connection.query at 0xe5e98d401c60} 680/356 0.001 0.000 0.096 0.000 /data/fmiam/current/libs/framework/BaseHandler.py:1471(mxxImporter) 714/356 0.001 0.000 0.096 0.000 {built-in method builtins.__import__} 64/20 0.000 0.000 0.095 0.005 :934(exec_module) 57/10 0.000 0.000 0.095 0.009 :1165(_find_and_load) 57/10 0.000 0.000 0.094 0.009 :1120(_find_and_load_unlocked) 156/22 0.000 0.000 0.094 0.004 :233(_call_with_frames_removed) 15 0.000 0.000 0.094 0.006 /data/fmiam/current/libs/PLayer/PersistentBroker.py:266(processSqlList) 56/11 0.000 0.000 0.093 0.008 :666(_load_unlocked) 64/20 0.001 0.000 0.090 0.004 {built-in method builtins.exec} 12/10 0.000 0.000 0.090 0.009 /data/fmiam/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 100/33 0.000 0.000 0.088 0.003 /data/fmiam/current/libs/PLayer/PersistentObject.py:2704(__getattr__) 5 0.000 0.000 0.082 0.016 /data/fmiam/current/libs/PLayer/PersistentObject.py:2884(_loadListAssoc) 5 0.000 0.000 0.082 0.016 /data/fmiam/current/libs/PLayer/PersistentObject.py:2930(_loadAssocListSQL) 95/48 0.000 0.000 0.060 0.001 :1207(_handle_fromlist) 1 0.000 0.000 0.057 0.057 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 49 0.000 0.000 0.045 0.001 /usr/lib/python3.11/re/__init__.py:272(_compile) 35 0.000 0.000 0.045 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 21 0.000 0.000 0.044 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 1 0.000 0.000 0.043 0.043 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 2 0.000 0.000 0.041 0.021 /data/fmiam/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS) 7 0.041 0.006 0.041 0.006 /data/fmiam/current/libs/utils/htmlTools.py:53(init) 1 0.000 0.000 0.035 0.035 /data/fmiam/current/libs/framework/WebApp.py:297(writeHTMLWithMicrosite) 1 0.000 0.000 0.029 0.029 /tmp/mako_modules_1011/fmiam/www/25.2.1/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header_responsive.html.py:28(render_body) 1 0.000 0.000 0.026 0.026 /tmp/mako_modules_1011/fmiam/www/25.2.1/meetings/microsite_helpers.html.py:82(render_responsive_microsite_startOfContent) 1 0.000 0.000 0.026 0.026 /data/fmiam/current/generic/classes/Meeting.py:2839(getBannerWidth) 1 0.000 0.000 0.025 0.025 /data/fmiam/current/generic/classes/File.py:63(getImageSize) 5 0.000 0.000 0.024 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 21 0.000 0.000 0.024 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 5 0.000 0.000 0.022 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/sanitizer.py:87(__init__) 1 0.000 0.000 0.022 0.022 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1() 5 0.000 0.000 0.021 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:410(__init__) 5 0.000 0.000 0.021 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:93(__init__) 5 0.000 0.000 0.020 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/__init__.py:39(getTreeBuilder) 21 0.000 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:979(parse) 75/21 0.001 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:456(_parse_sub) 656/21 0.008 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:516(_parse) 1 0.000 0.000 0.019 0.019 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/etree.py:1() 1 0.001 0.001 0.018 0.018 /data/fmiam/current/libs/framework/WebSite.py:419(outputDebugTable) 1 0.000 0.000 0.018 0.018 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/_ihatexml.py:1() 707/21 0.006 0.000 0.017 0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile) 64 0.001 0.000 0.017 0.000 :1007(get_code) 108 0.000 0.000 0.014 0.000 /data/fmiam/current/libs/framework/WebSite.py:1284(debugHTML) 58 0.013 0.000 0.014 0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 1 0.000 0.000 0.014 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/__init__.py:1() 125 0.002 0.000 0.014 0.000 {built-in method builtins.__build_class__} 108 0.000 0.000 0.013 0.000 /data/fmiam/current/libs/framework/WebSite.py:924(writeHTML) 64 0.000 0.000 0.011 0.000 :727(_compile_bytecode) 64 0.011 0.000 0.011 0.000 {built-in method marshal.loads} 1 0.000 0.000 0.011 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/packaging/version.py:1() 1 0.000 0.000 0.011 0.011 /data/fmiam/current/generic/classes/Meeting.py:2163(getIsAcceptingOnlineRegistrations) 1 0.000 0.000 0.011 0.011 /data/fmiam/current/generic/classes/Meeting.py:2120(getNoOnlineRegistrationsReason) 1 0.000 0.000 0.010 0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/Image.py:3081(open) 109 0.000 0.000 0.010 0.000 /data/fmiam/current/libs/framework/MaxxRequestWrapper.py:53(write) 1 0.000 0.000 0.010 0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/Image.py:311(preinit) 109 0.000 0.000 0.010 0.000 /data/fmiam/current/libs/framework/wsgiapp.py:285(write) 1 0.000 0.000 0.009 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:65(build_email_re) 9 0.000 0.000 0.009 0.001 /data/fmiam/current/libs/framework/BaseHandler.py:311(getTemplate) 56 0.001 0.000 0.009 0.000 :1054(_find_spec) 1 0.000 0.000 0.009 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:32(build_url_re) 10 0.000 0.000 0.008 0.001 /data/fmiam/current/generic/classes/Meeting.py:3352(getTabs) 1 0.000 0.000 0.008 0.008 /data/fmiam/current/generic/classes/Meeting.py:3338(getMeetingByMicrositePath) 1 0.000 0.000 0.008 0.008 /data/fmiam/current/libs/PLayer/PersistentBroker.py:769(processCriteria) 2 0.000 0.000 0.008 0.004 /data/fmiam/current/generic/classes/Meeting.py:1976(getDateRegistrationStarts) 1 0.000 0.000 0.008 0.008 /data/fmiam/current/generic/classes/Meeting.py:3266(getGoogleLink) 1 0.000 0.000 0.008 0.008 /data/fmiam/current/libs/utils/calendarUtils.py:10(getGoogleLink) 56 0.000 0.000 0.007 0.000 :1499(find_spec) 56 0.000 0.000 0.007 0.000 :1467(_get_spec) 1 0.000 0.000 0.007 0.007 /data/fmiam/current/generic/classes/File.py:231(isImage) 1 0.000 0.000 0.007 0.007 /usr/lib/python3.11/mimetypes.py:293(guess_type) 1 0.000 0.000 0.007 0.007 /usr/lib/python3.11/mimetypes.py:366(init) 21 0.000 0.000 0.007 0.000 /usr/lib/python3.11/re/_compiler.py:511(_compile_info) 7/5 0.000 0.000 0.007 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2941(_loadAssoc) 7/5 0.000 0.000 0.007 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:3007(_loadAssocSQL) 1 0.000 0.000 0.007 0.007 /usr/lib/python3.11/mimetypes.py:207(read) 1 0.004 0.004 0.007 0.007 /usr/lib/python3.11/mimetypes.py:218(readfp) 1 0.000 0.000 0.007 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/packaging/version.py:159(Version) 77 0.001 0.000 0.007 0.000 :1607(find_spec) 1 0.000 0.000 0.007 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:1()