Compliance Issues & Expectations of Storage Facilities for Non-perishable Items

Monday, February 12, 2024
2:00 pm ET / 1:00 pm CT / 12:00 pm MT/ 11:00 am PT

 

Description: 

Join Hilary Thesmar, Chief Science Officer and Senior Vice President of Food Safety Programs at FMI and Tracynda Davis, Marti Myrick, Erik Mettler and Michael Dutchner, representatives from the FDA, to discuss compliance for ambient storage holding facilities.

FMI Digital Seminars

Compliance Issues and Expectations of Storage Facilities for Non-Perishable Items

Virtual

Debugging Info
pagedictsize=0
sqltime = 0.196 s
cpu time = 0.140 s
real time = 0.372 s
memory increase = 18852 kB
fields =
templates =
/data/fmiam/current/generic/themes/shared/vue-apps/maxx-theme/dist/.vite/manifest.json
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_footer.html
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header_pixel
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header_responsive.html
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_index_responsive.html
dg = [] | []
extra debug info =
queries = 38 queries

Total TimeCountAvg TimeQuery
0.0861 call
0 rows		0.086 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Meeting, Website) WHERE `Website`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x837FF100000001
0.0281 call
1 row		0.028 SELECT DISTINCT hex(`MicrositeTabComponent`.`MicrositeTabComponentId`) AS `MicrositeTabComponentId`, `MicrositeTabComponent`.`type`, `MicrositeTabComponent`.`text`, `MicrositeTabComponent`.`orderindex` FROM (MicrositeTab, MicrositeTabComponent) WHERE `MicrositeTabComponent`.`MicrositeTabId`=`MicrositeTab`.`MicrositeTabId` AND `MicrositeTab`.`MicrositeTabId`=0x837FF100000006 ORDER BY `MicrositeTabComponent`.`orderindex`
0.0161 call
1 row		0.016 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`='StorageFacilities'
0.0151 call
6 rows		0.015 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`=0x837FF100000001
0.0101 call
1 row		0.010 SELECT DISTINCT hex(`FeeDateRange`.`FeeDateRangeId`) AS `FeeDateRangeId`, `FeeDateRange`.`name`, `FeeDateRange`.`startDate`, `FeeDateRange`.`endDate` FROM (Meeting, FeeDateRange) WHERE `FeeDateRange`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x837FF100000001
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`='personalProfile_editPhoto' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)
0.0062 calls
1 row		0.003 SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration, Invoice) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND IFNULL(`Invoice`.`_SABalance`, 0)>0) AND `Registration`.`MeetingId`=0x837FF100000001) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2026-02-11 22:25:48')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x837FF100000001)
0.0056 calls
1 row		0.001 SELECT version from databasemap;
0.0045 calls
2 rows		0.001 SELECT * FROM YesNo ORDER BY orderindex, id
0.0041 call
0 rows		0.004 COMMIT
0.0031 call
2 rows		0.003 SELECT * FROM MaleOrFemale ORDER BY orderindex, id
0.0021 call
1 row		0.002 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`=0x837FF100000001 ORDER BY `CalendarItem`.`startDate`
0.0021 call
1 row		0.002 SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration, Invoice) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND IFNULL(`Invoice`.`_SABalance`, 0)<=0) AND `Registration`.`MeetingId`=0x837FF100000001) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2026-02-11 22:25:48')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x837FF100000001)
0.0021 call
1 row		0.002 SELECT DISTINCT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (CalendarItem, Timezone) WHERE `CalendarItem`.`CalendarItemId`=0x837FF100000014 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`
0.0021 call
1 row		0.002 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`=0x837FF100000001
0.0021 call
173 rows		0.002 SELECT * FROM webselect
0.0011 call
2 rows		0.001 SELECT * FROM StaffLevel ORDER BY orderindex, id
0.0011 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 (Meeting, MyMeeting) WHERE `MyMeeting`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x837FF100000001
0.0011 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 (Address, Individual) WHERE `Address`.`AddressId`=0x837FF100000005 AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0011 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`=0x837FF100000001 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0011 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`=0x837FF100000001
0.0011 call
0 rows		0.001 INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 22:25:48',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB984D00000000, `path`='forms/meeting/Microsite/StorageFacilities', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='3957920', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752146', `startTime`='2026-02-11 22:25:48', `sessionId`=0x1DCA1448B64ACFC0, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.107'
0.0011 call
2 rows		0.001 SELECT * FROM EmailType ORDER BY orderindex, id
0.0011 call
3 rows		0.001 SELECT * FROM JobLevel ORDER BY orderindex, id
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`=0x837FF100000005 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`
0.0001 call
10 rows		0.000 SELECT * FROM MemberCommunicationType ORDER BY orderindex, id
0.0001 call
1 row		0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
0 rows		0.000 START TRANSACTION