FMI State Issues Retreat 2019: State Issues Retreat

The FMI State Issues Retreat is an annual event that brings together food retail grocery associations and grocery company professionals from each state to discuss state legislative issues of interest to the food industry. This year's State Issues Retreat will take place at the Four Seasons Hotel in Denver, Colorado, August 12 to August 14.

As more and more policymaking occurs at the state and local level, this meeting provides an important opportunity to learn the lessons of 2019 and strategize for 2020. While the agenda is still being developed, topics will include CBD, Emerging Issues, Plastics, Taxes, Wage & Labor and much more. Please make your reservation directly with the hotel online using the code FMI0919 or by calling 303-389-3300 and referencing your affiliation with the group "FMI State Issues Retreat" to receive the negotiated room rate of $269. The hotel block cut-off date is July 19, 2019. More details are available on the "hotel information" page.

UPDATE: The FMI0919 Room Block is SOLD OUT! Click here for information on alternative area hotels.

PRELIMINARY AGENDA

Monday, August 12, 2019

3:15 p.m. – 4:00 p.m. Federal Issues Update

5:30 p.m. Meet in Lobby for Bus Departure

6:00 p.m. – 9:00 p.m. Reception and Dinner (Denver

Country Club)

Tuesday, August 13, 2019

7:00 a.m. – 8:00 a.m. Continental Breakfast (Aspen Room)

8:00 a.m. – 3:45 p.m. BUSINESS SESSIONS (All business

sessions in Cottonwood Ballroom)

8:10 a.m. - 9:00 a.m. Executive Overview of 2019 Trends

Leslie Sarasin, FMI President & CEO

3:45 p.m. – 6:00 p.m. Networking/Free Time

6:00 p.m. – 7:00 p.m. Reception (Pool Terrace)

7:00 p.m. – 9:00 p.m Dinner (Pool Terrace)

Confirmed Speakers for Tuesday, August 13:

Regulatory Landscape for Hemp-Derived Products, Samantha Dietle, Esq. Hogan Lovells US LLP
SNAP Chat 2019: Latest Updates on SNAP, Andrea Gold, Director, Retailer and Issuance Policy, USDA FNS SNAP

Wednesday, August 14, 2019

7:30 a.m. – 8:30 a.m. Continental Breakfast (Aspen Room)

8:30 a.m. – 12:00 p.m. BUSINESS SESSIONS CONTINUED

12:00 p.m. Meeting Adjourns

Thank you to our Sponsors!

Coca Cola

Consumer Healthcare Products Association

General Mills

Pepsico

Plant Based Foods Association

Total Time

Count

Avg Time

Query

0.159

1 call
0 rows

0.159

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

0.033

1 call
1 row

0.033

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

0.022

1 call
1 row

0.022

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`.`micrositePath`='state-issues-retreat-2019'

0.020

1 call
6 rows

0.020

SELECT DISTINCT hex(`MicrositeTab`.`MicrositeTabId`) AS `MicrositeTabId`, `MicrositeTab`.`title`, `MicrositeTab`.`orderindex`, `MicrositeTab`.`enabled`, `MicrositeTab`.`isInSite` FROM (MicrositeTab, Meeting) WHERE `MicrositeTab`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x7CDC2200000004

0.019

1 call
6 rows

0.019

0.012

1 call
1 row

0.012

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

0.009

10 calls
1 row

0.001

SELECT version from databasemap;

0.007

1 call
0 rows

0.007

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

0.006

1 call
1 row

0.006

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 (CalendarItem, Meeting) WHERE `CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x7CDC2200000004 ORDER BY `CalendarItem`.`startDate`

0.005

1 call
1 row

0.005

0.004

1 call
2 rows

0.004

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

0.004

1 call
1 row

0.004

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`=0x7CDC2200000004 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.004

1 call
0 rows

0.004

COMMIT

0.004

1 call
173 rows

0.004

SELECT * FROM webselect

0.003

1 call
1 row

0.003

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

0.003

1 call
0 rows

0.003

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`=0x57812600000456 AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.003

1 call
1 row

0.003

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`=0x7F6DC500000001 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.003

1 call
1 row

0.003

0.002

1 call
0 rows

0.002

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 17:24:06',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFAEF800000000, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2674652', `requestNum`='1', `objectId`='7F6DC500000001', `growth`='1024', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1531204', `startTime`='2025-09-09 17:24:06', `sessionId`=0x47C41010145C9C4C, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.016777515411376953', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'7F6DC500000001\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFAEF800000000

0.002

1 call
1 row

0.002

1 call
0 rows

0.002

START TRANSACTION

0.002

1 call
54 rows

0.002

select id, abbreviation from StateProvince

0.001

1 call
0 rows

0.001

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 17:24:06',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFAEF800000002, `path`='forms/meeting/Microsite/state-issues-retreat-2019', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2674652', `requestNum`='3', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1531204', `startTime`='2025-09-09 17:24:06', `sessionId`=0x47C41010145C9C4C, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.31'

0.001

1 call
54 rows

0.001

SELECT * FROM StateProvince ORDER BY orderindex, id

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 (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x7CDC2200000016 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

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`=0x57812600000452 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

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 (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x57812600000464 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`

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`=0x7F6DC500000004 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
1 row

0.000

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

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 17:24:06',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFAEF800000000, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2674652', `requestNum`='1', `pageDictSize`=NULL, `objectId`='7F6DC500000001', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1531204', `startTime`='2025-09-09 17:24:06', `sessionId`=0x47C41010145C9C4C, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'7F6DC500000001\\'}', `clientIPAddr`='216.73.216.31'

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 17:24:06',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFAEF800000001, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2674652', `requestNum`='2', `pageDictSize`=NULL, `objectId`='7CDC2200000004', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1531204', `startTime`='2025-09-09 17:24:06', `sessionId`=0x47C41010145C9C4C, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'7CDC2200000004\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.31'

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`=0x57812600000456 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.000

1 call
0 rows

0.000

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 17:24:06',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFAEF800000001, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2674652', `requestNum`='2', `objectId`='7CDC2200000004', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1531204', `startTime`='2025-09-09 17:24:06', `sessionId`=0x47C41010145C9C4C, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.03489947319030762', `timeTaken`='0', `dictSize`='0', `fields`='{\\'id\\':\\'7CDC2200000004\\', \\'outlook2007\\':\\'1\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFAEF800000001

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`=0x7CDC2200000007 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

124412 function calls (120066 primitive calls) in 0.724 seconds Ordered by: cumulative time List reduced from 1388 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.724 0.724 /data/fmiam/current/libs/framework/WebManager.py:136(_newRequest) 1 0.000 0.000 0.712 0.712 /data/fmiam/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.685 0.685 /data/fmiam/current/libs/framework/BaseHandler.py:269(_safeCall) 1 0.000 0.000 0.685 0.685 /data/fmiam/current/generic/sites/www/forms/meeting/Microsite.py:24(index) 4/3 0.000 0.000 0.620 0.207 /data/fmiam/current/libs/framework/MakoTemplate.py:48(__call__) 4 0.000 0.000 0.620 0.155 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:461(render) 4 0.000 0.000 0.620 0.155 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:860(_render) 4 0.000 0.000 0.619 0.155 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:912(_render_context) 4 0.000 0.000 0.619 0.155 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:927(_exec_template) 1 0.000 0.000 0.527 0.527 /tmp/mako_modules_1011/fmiam/www/25.1.1/data/fmiam/current/generic/themes/www/mako/meetings/microsite_index_responsive.html.py:31(render_body) 1 0.000 0.000 0.485 0.485 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:244(render_microsite_sidebar) 32 0.000 0.000 0.295 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 32 0.000 0.000 0.294 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 32 0.000 0.000 0.293 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 32 0.293 0.009 0.293 0.009 {function Connection.query at 0xe3777a0b6980} 2 0.000 0.000 0.283 0.141 /data/fmiam/current/generic/classes/Address.py:297(getPrintPlain) 2 0.000 0.000 0.283 0.141 /data/fmiam/current/generic/classes/Address.py:340(generatePrettyHTML) 1 0.000 0.000 0.281 0.281 /tmp/mako_modules_1011/fmiam/www/25.1.1/helpers/meetingHelpers.html.py:57(render_addToCalendarWidget) 1 0.000 0.000 0.276 0.276 /data/fmiam/current/generic/classes/Meeting.py:3270(getYahooLink) 1 0.000 0.000 0.276 0.276 /data/fmiam/current/libs/utils/calendarUtils.py:13(getYahooLink) 1 0.000 0.000 0.275 0.275 /data/fmiam/current/generic/classes/Meeting.py:3274(getAddress) 5 0.000 0.000 0.275 0.055 /data/fmiam/current/libs/utils/htmlTools.py:100(cleanHTML) 15 0.000 0.000 0.269 0.018 /data/fmiam/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 12/10 0.000 0.000 0.264 0.026 /data/fmiam/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 100/33 0.000 0.000 0.259 0.008 /data/fmiam/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 634/310 0.001 0.000 0.248 0.001 /data/fmiam/current/libs/framework/BaseHandler.py:1471(mxxImporter) 668/310 0.001 0.000 0.247 0.001 {built-in method builtins.__import__} 57/10 0.000 0.000 0.247 0.025 :1165(_find_and_load) 64/20 0.000 0.000 0.246 0.012 :934(exec_module) 57/10 0.000 0.000 0.246 0.025 :1120(_find_and_load_unlocked) 156/22 0.000 0.000 0.243 0.011 :233(_call_with_frames_removed) 56/11 0.000 0.000 0.242 0.022 :666(_load_unlocked) 5 0.000 0.000 0.235 0.047 /data/fmiam/current/libs/PLayer/PersistentObject.py:2855(_loadListAssoc) 5 0.000 0.000 0.235 0.047 /data/fmiam/current/libs/PLayer/PersistentObject.py:2901(_loadAssocListSQL) 64/20 0.005 0.000 0.226 0.011 {built-in method builtins.exec} 95/48 0.000 0.000 0.161 0.003 :1207(_handle_fromlist) 1 0.000 0.000 0.143 0.143 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 1 0.000 0.000 0.124 0.124 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 49 0.000 0.000 0.123 0.003 /usr/lib/python3.11/re/__init__.py:272(_compile) 35 0.000 0.000 0.123 0.004 /usr/lib/python3.11/re/__init__.py:225(compile) 21 0.000 0.000 0.122 0.006 /usr/lib/python3.11/re/_compiler.py:740(compile) 1 0.000 0.000 0.107 0.107 /data/fmiam/current/libs/framework/WebApp.py:298(writeHTMLWithMicrosite) 1 0.000 0.000 0.092 0.092 /tmp/mako_modules_1011/fmiam/www/25.1.1/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header_responsive.html.py:28(render_body) 1 0.000 0.000 0.083 0.083 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:82(render_responsive_microsite_startOfContent) 1 0.000 0.000 0.083 0.083 /data/fmiam/current/generic/classes/Meeting.py:2839(getBannerWidth) 1 0.000 0.000 0.082 0.082 /data/fmiam/current/generic/classes/File.py:63(getImageSize) 2 0.000 0.000 0.073 0.036 /data/fmiam/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS) 7 0.073 0.010 0.073 0.010 /data/fmiam/current/libs/utils/htmlTools.py:53(init) 21 0.000 0.000 0.071 0.003 /usr/lib/python3.11/re/_compiler.py:573(_code) 1 0.000 0.000 0.060 0.060 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1() 5 0.000 0.000 0.058 0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 5 0.000 0.000 0.055 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/sanitizer.py:87(__init__) 5 0.000 0.000 0.054 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:410(__init__) 5 0.000 0.000 0.054 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:93(__init__) 21 0.000 0.000 0.051 0.002 /usr/lib/python3.11/re/_parser.py:979(parse) 707/21 0.024 0.000 0.049 0.002 /usr/lib/python3.11/re/_compiler.py:37(_compile) 5 0.000 0.000 0.047 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/__init__.py:39(getTreeBuilder) 75/21 0.001 0.000 0.047 0.002 /usr/lib/python3.11/re/_parser.py:456(_parse_sub) 656/21 0.023 0.000 0.046 0.002 /usr/lib/python3.11/re/_parser.py:516(_parse) 1 0.000 0.000 0.042 0.042 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/etree.py:1() 1 0.000 0.000 0.041 0.041 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/__init__.py:1() 1 0.000 0.000 0.041 0.041 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/_ihatexml.py:1() 58 0.039 0.001 0.040 0.001 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 64 0.001 0.000 0.040 0.001 :1007(get_code) 1 0.000 0.000 0.037 0.037 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:65(build_email_re) 1 0.000 0.000 0.032 0.032 /data/fmiam/current/generic/classes/Meeting.py:2163(getIsAcceptingOnlineRegistrations) 1 0.000 0.000 0.032 0.032 /data/fmiam/current/generic/classes/Meeting.py:2120(getNoOnlineRegistrationsReason) 1 0.000 0.000 0.032 0.032 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/Image.py:3081(open) 64 0.000 0.000 0.030 0.000 :727(_compile_bytecode) 64 0.030 0.000 0.030 0.000 {built-in method marshal.loads} 7/5 0.000 0.000 0.029 0.006 /data/fmiam/current/libs/PLayer/PersistentObject.py:2912(_loadAssoc) 7/5 0.000 0.000 0.029 0.006 /data/fmiam/current/libs/PLayer/PersistentObject.py:2978(_loadAssocSQL) 125 0.013 0.000 0.028 0.000 {built-in method builtins.__build_class__} 1 0.000 0.000 0.027 0.027 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/Image.py:311(preinit) 2 0.000 0.000 0.026 0.013 /data/fmiam/current/generic/classes/Meeting.py:1976(getDateRegistrationStarts) 1 0.000 0.000 0.025 0.025 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:32(build_url_re) 1 0.000 0.000 0.024 0.024 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/Image.py:1() 8 0.000 0.000 0.023 0.003 /data/fmiam/current/libs/framework/BaseHandler.py:312(getTemplate) 56 0.001 0.000 0.023 0.000 :1054(_find_spec) 21 0.000 0.000 0.023 0.001 /usr/lib/python3.11/re/_compiler.py:511(_compile_info) 1 0.000 0.000 0.022 0.022 /data/fmiam/current/generic/classes/Meeting.py:3336(getMeetingByMicrositePath) 1 0.000 0.000 0.022 0.022 /data/fmiam/current/libs/PLayer/PersistentBroker.py:770(processCriteria) 1 0.000 0.000 0.021 0.021 /data/fmiam/current/generic/classes/File.py:231(isImage) 1 0.000 0.000 0.021 0.021 /usr/lib/python3.11/mimetypes.py:293(guess_type) 1 0.000 0.000 0.021 0.021 /usr/lib/python3.11/mimetypes.py:366(init) 1 0.000 0.000 0.021 0.021 /usr/lib/python3.11/mimetypes.py:207(read) 1 0.006 0.006 0.021 0.021 /usr/lib/python3.11/mimetypes.py:218(readfp) 6 0.000 0.000 0.021 0.003 /data/fmiam/current/libs/framework/BaseHandler.py:596(getTemplateDefaults) 10 0.000 0.000 0.020 0.002 /data/fmiam/current/generic/classes/Meeting.py:3350(getTabs) 1 0.000 0.000 0.019 0.019 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:1() 1 0.012 0.012 0.018 0.018 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/serializer.py:1() 1 0.004 0.004 0.017 0.017 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/packaging/version.py:1() 56 0.000 0.000 0.016 0.000 :1499(find_spec) 56 0.000 0.000 0.016 0.000 :1467(_get_spec) 77 0.001 0.000 0.015 0.000 :1607(find_spec) 7 0.000 0.000 0.014 0.002 /data/fmiam/current/libs/framework/Auth.py:414(getValidSessionRecord) 1 0.003 0.003 0.014 0.014 /data/fmiam/current/libs/framework/WebSite.py:420(outputDebugTable) 731/48 0.008 0.000 0.011 0.000 /usr/lib/python3.11/re/_parser.py:178(getwidth) 6 0.000 0.000 0.011 0.002 /data/fmiam/current/libs/framework/WebSite.py:1076(getImpersonatingUser) 15/14 0.000 0.000 0.010 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2950(_createObjectFromRow)