About Us
- About Us
- History
- Leadership
- Staff
- Policy Statements
- Contact Us
- Careers
  - Job Listings
- Year in Review
Join FMI
Careers
- Job Listings
Newsroom
- Latest News
- News Archive
  - 2025
  - 2024
  - 2023
  - 2022
  - 2021
  - 2020
  - 2019
  - 2018
  - 2017
  - 2016
  - 2015
  - 2014
  - 2013
  - 2012
  - 2011
  - 2010
  - 2009
  - 2008
  - 2007
  - 2006
  - 2005
  - 2004
  - 2003
  - 2002
  - 2001
  - 2000
  - 1999
  - 1998
- Press Credentials
- Voice of The Food Industry Blog
Store

The HIPAA Privacy Rule and Refill Reminders- What Supermarket Pharmacies Need to Know

Tuesday, October 29, 2013 (1pm - 3pm US/Eastern)
FMI Webinar
Arlington, VA

The registration period for this meeting has ended.

Please join FMI and Larry Kocot of Epstein, Becker & Green PC on a webinar to discuss the recently issued guidance by the Department of Health and Human Services (HHS) Office for Civil Rights (OCR) entitled “The HIPAA Privacy Rule and Refill Reminders and Other Communications about a Drug or Biologic Currently Being Prescribed for the Individual”.

The webinar will provide FMI members with information on the guidance - including clarification on permitted communications, reasonable costs, direct and indirect costs - for sponsored “refill reminder” patient-specific communications programs.

We look forward to your participation.

Related Web Pages and Sites:
Larry's Bio

251 18th Street S, Suite 1200, Arlington, VA 22202 | phone: 202-452-8444 | fax: 202-429-4519

Website design by Matrix Group International, Inc. ®

Sign Up for the

FREE daily briefing on top stories in food retailing.

fmi-icon-frozen-goods
fmi-icon-newsroom force-icon-3
fmi-icon-workforce
fmi-icon-certificate
fmi-icon-cybersecurity1
fmi-icon-pharmacy
fmi-icon-food-safety
fmi-icon-asset-protection
fmi-icon-education force-icon-3
fmi-icon-research
fmi-icon-government-affairs
fmi-icon-get-involved
fmi-icon-industry-topic force-icon-3
fmi-icon-labeling
fmi-icon-corporate-social-responsibility
fmi-icon-payments
fmi-icon-crisis-management
fmi-icon-private-brands
fmi-icon-food-assistance
fmi-icon-supplier-diversity
fmi-icon-fresh-foods
fmi-icon-supply-chain
fmi-icon-general-merchandise
fmi-icon-technology
fmi-icon-health-wellness
fmi-icon-total-store-collaboration
fmi-icon-Health-Reform
fmi-icon-wage-labor
fmi-icon-independent-operator
fmi-icon-wholesaler-topic
fmi-icon-newsroom force-icon-3
fmi-icon-tax-reform
fmi-icon-about_icon force-icon-4
fmi-icon-about_icon
fmi-icon-cart
fmi-icon-blog_icon force-icon-5
fmi-icon-cart
fmi-icon-Communications
fmi-icon-omnichannel
fmi-icon-biotechnology-topic

Total Time

Count

Avg Time

Query

0.191

1 call
1 row

0.191

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

0.062

1 call
0 rows

0.062

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

0.059

27 calls
2 rows

0.002

SELECT * FROM YesNo ORDER BY orderindex, id

0.046

1 call
0 rows

0.046

SELECT DISTINCT hex(`RegistrationQuestion`.`RegistrationQuestionId`) AS `RegistrationQuestionId`, `RegistrationQuestion`.`text`, `RegistrationQuestion`.`options`, `RegistrationQuestion`.`publishToWWW`, `RegistrationQuestion`.`type`, `RegistrationQuestion`.`required`, `RegistrationQuestion`.`orderindex` FROM (Meeting, RegistrationQuestion) WHERE `RegistrationQuestion`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x18377F00000173 ORDER BY `RegistrationQuestion`.`orderindex`, `RegistrationQuestion`.`RegistrationQuestionId`

0.030

9 calls
1 row

0.003

SELECT version from databasemap;

0.026

1 call
6 rows

0.026

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

0.025

1 call
1 row

0.025

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

0.022

3 calls
54 rows

0.007

SELECT * FROM StateProvince ORDER BY orderindex, id

0.021

1 call
1 row

0.021

SELECT DISTINCT hex(`FeeDateRange`.`FeeDateRangeId`) AS `FeeDateRangeId`, `FeeDateRange`.`name`, `FeeDateRange`.`startDate`, `FeeDateRange`.`endDate` FROM (FeeDateRange, Fee2FeeDateRange, Fee) WHERE (0x18377F00000174=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2FeeDateRange`.`FeeId` AND `Fee2FeeDateRange`.`FeeDateRangeId`=`FeeDateRange`.`FeeDateRangeId`)

0.017

1 call
1 row

0.017

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration, Invoice) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND IFNULL(`Invoice`.`_SABalance`, 0)<=0) AND `Registration`.`MeetingId`=0x18377F00000173) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2026-02-11 22:32:49')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x18377F00000173)

0.014

1 call
1 row

0.014

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

0.013

2 calls
4 rows

0.007

SELECT * FROM QuestionType ORDER BY orderindex, id

0.010

1 call
2 rows

0.010

SELECT * FROM MaleOrFemale ORDER BY orderindex, id

0.010

1 call
1 row

0.010

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.010

1 call
1 row

0.010

SELECT DISTINCT hex(`ClientSetting`.`ClientSettingId`) AS `ClientSettingId`, `ClientSetting`.`name`, `ClientSetting`.`value`, `ClientSetting`.`parentClass`, hex(`ClientSetting`.`parentId`) AS `parentId` FROM (ClientSetting) WHERE ((`ClientSetting`.`name`='meetings_WWWreg_noRegMsg_reg_ended' AND `ClientSetting`.`parentClass` is null) AND `ClientSetting`.`parentId` is null)

0.009

1 call
4 rows

0.009

SELECT hex(`Timezone`.`TimezoneId`) AS `TimezoneId`, `Timezone`.`description`, `Timezone`.`tzname`, hex(`Timezone`.`orderindex`) AS `orderindex` FROM (Timezone) ORDER BY `Timezone`.`orderindex` LIMIT 0, 700

0.008

1 call
1 row

0.008

0.007

1 call
0 rows

0.007

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (MailingList, Committee) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xB82EA00000323 ORDER BY `Committee`.`category`, `Committee`.`name`

0.007

1 call
17 rows

0.007

SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (Fee2MembershipType, Fee, MembershipType) WHERE (0x18377F00000174=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2MembershipType`.`FeeId` AND `Fee2MembershipType`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`

0.007

1 call
1 row

0.007

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

0.006

1 call
0 rows

0.006

SELECT DISTINCT hex(`SpecialDeal`.`SpecialDealId`) AS `SpecialDealId`, `SpecialDeal`.`numFeesToQualify`, `SpecialDeal`.`numSpecialFees` FROM (SpecialDeal, Fee) WHERE `SpecialDeal`.`FeeId`=`Fee`.`FeeId` AND `Fee`.`FeeId`=0x18377F00000174

0.006

1 call
0 rows

0.006

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 22:32:48',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB989F00000007, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='7', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:48', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.003488779067993164', `timeTaken`='0', `dictSize`='0', `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'/users_only/meeting/MyMeetingFormPublic/viewMeetingDocuments?meetingId=13D48D00000055\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB989F00000007

0.006

2 calls
1 row

0.003

SELECT `MetaMeeting`.`cancellationPolicy`, hex(`MetaMeeting`.`MetaMeetingId`) AS `MetaMeetingId`, `MetaMeeting`.`thankYouText`, `MetaMeeting`.`attire`, `MetaMeeting`.`defaultBlurb`, `MetaMeeting`.`feesPageTopText`, `MetaMeeting`.`badgesPageTopText`, `MetaMeeting`.`questionsPageTopText`, `MetaMeeting`.`eventsPageTopText`, `MetaMeeting`.`reviewPageTopText`, `MetaMeeting`.`paymentPageTopText`, `MetaMeeting`.`housingPageTopText`, `MetaMeeting`.`attendeesPageTopText`, `MetaMeeting`.`emailFromContact`, `MetaMeeting`.`prominentComments`, `MetaMeeting`.`thankYouFullyPaidText`, `MetaMeeting`.`additionalFeesPageTopText` FROM (MetaMeeting)

0.006

1 call
0 rows

0.006

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 22:32:48',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB989F00000006, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='6', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:48', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.006150484085083008', `timeTaken`='0', `dictSize`='0', `fields`='{\\'target\\':\\'/users_only/meeting/MyMeetingFormPublic/viewMeetingDocuments?meetingId=13D48D00000055\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB989F00000006

0.006

1 call
0 rows

0.006

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 22:32:48',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB989F00000009, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='9', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:48', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.004546403884887695', `timeTaken`='0', `dictSize`='0', `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'/users_only/meeting/MyMeetingFormPublic/viewMeetingDocuments?meetingId=DFF8B0000000F\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB989F00000009

0.006

1 call
3 rows

0.006

SELECT * FROM EventRegisterOption ORDER BY orderindex, id

0.006

1 call
0 rows

0.006

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 22:32:48',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB989F00000006, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='6', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:48', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'target\\':\\'/users_only/meeting/MyMeetingFormPublic/viewMeetingDocuments?meetingId=13D48D00000055\\'}', `clientIPAddr`='216.73.216.107'

0.006

1 call
0 rows

0.006

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 (MeetingHotel, Address) WHERE `MeetingHotel`.`MeetingHotelId`=0xFB989F00000025 AND `MeetingHotel`.`AddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.006

1 call
0 rows

0.006

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 22:32:49',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB989F0000000A, `path`='forms/meeting/MeetingFormPublic/view', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='10', `pageDictSize`=NULL, `objectId`='18377F00000173', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:49', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'18377F00000173\\'}', `clientIPAddr`='216.73.216.107'

0.006

1 call
0 rows

0.006

1 call
0 rows

0.006

SELECT DISTINCT hex(`Hotel`.`HotelId`) AS `HotelId`, `Hotel`.`reservationsPhone`, `Hotel`.`reservationsFax` FROM (Company, Hotel) WHERE `Hotel`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0xFB989F00000028

0.006

1 call
1 row

0.006

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`.`MeetingId`=0x18377F00000173

0.006

1 call
0 rows

0.006

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 22:32:48',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB989F00000005, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='5', `objectId`='A1608000000001', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:48', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.05409431457519531', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'A1608000000001\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB989F00000005

0.006

1 call
1 row

0.006

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 (Meeting, Individual) WHERE `Meeting`.`MeetingId`=0x18377F00000173 AND `Meeting`.`contactIndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.006

2 calls
1 row

0.003

select max(returnOrder) from Stack where sessionId = 6588574203179362093

0.005

1 call
1 row

0.005

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration, Invoice) WHERE ((((((`Registration`.`InvoiceId`=`Invoice`.`InvoiceId` AND IFNULL(`Invoice`.`_SABalance`, 0)>0) AND `Registration`.`MeetingId`=0x18377F00000173) AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2026-02-11 22:32:49')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x18377F00000173)

0.005

1 call
1 row

0.005

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

0.005

1 call
0 rows

0.005

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (MailingList, Committee) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xFB989F00000054 ORDER BY `Committee`.`category`, `Committee`.`name`

0.005

1 call
0 rows

0.005

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 22:32:48',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB989F00000008, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='8', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:48', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.0046007633209228516', `timeTaken`='0', `dictSize`='0', `fields`='{\\'target\\':\\'/users_only/meeting/MyMeetingFormPublic/viewMeetingDocuments?meetingId=DFF8B0000000F\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB989F00000008

0.005

2 calls
1 row

0.002

select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Meeting where MeetingId=0x18377F00000173

0.005

1 call
0 rows

0.005

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`.`inSiteBannerFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x18377F00000173

0.005

1 call
2 rows

0.005

SELECT * FROM StaffLevel ORDER BY orderindex, id

0.005

1 call
0 rows

0.005

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (MailingList, Committee) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xFB989F0000004E ORDER BY `Committee`.`category`, `Committee`.`name`

0.005

1 call
0 rows

0.005

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Branch, Company) WHERE `Branch`.`BranchId`=0xFB989F0000002F AND `Branch`.`CompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.005

1 call
0 rows

0.005

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 22:32:48',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB989F00000008, `path`='forms/login/login', `formName`='login', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='8', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:48', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'target\\':\\'/users_only/meeting/MyMeetingFormPublic/viewMeetingDocuments?meetingId=DFF8B0000000F\\'}', `clientIPAddr`='216.73.216.107'

0.005

1 call
0 rows

0.005

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 22:32:48',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB989F00000009, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='9', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:48', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'/users_only/meeting/MyMeetingFormPublic/viewMeetingDocuments?meetingId=DFF8B0000000F\\'}', `clientIPAddr`='216.73.216.107'

0.005

1 call
1 row

0.005

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration) WHERE (((`Registration`.`dateSubmitted` is not null AND (`Registration`.`dateCancelled` is not null AND `Registration`.`dateCancelled`<'2026-02-11 22:32:49')) AND `Registration`.`dateRejected` is null) AND `Registration`.`MeetingId`=0x18377F00000173)

0.004

1 call
1 row

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

0.004

1 call
0 rows

0.004

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`.`logoFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x18377F00000173

0.004

1 call
3 rows

0.004

SELECT * FROM JobLevel ORDER BY orderindex, id

0.004

1 call
0 rows

0.004

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

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(`MeetingHotel`.`MeetingHotelId`) AS `MeetingHotelId`, `MeetingHotel`.`distance`, `MeetingHotel`.`deadline`, `MeetingHotel`.`hotelCode`, `MeetingHotel`.`compRate`, `MeetingHotel`.`description`, `MeetingHotel`.`comments`, `MeetingHotel`.`allowReservationsFromWWW`, `MeetingHotel`.`enableWWWReservations`, `MeetingHotel`.`inventoryComments`, `MeetingHotel`.`inventoryUpdatedOn`, `MeetingHotel`.`dateDeleted`, `MeetingHotel`.`cancellationPolicy`, `MeetingHotel`.`lowInventoryThreshold` FROM (Meeting, MeetingHotel) WHERE `MeetingHotel`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x18377F00000173

0.004

1 call
0 rows

0.004

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 (EventStaff, Individual) WHERE `EventStaff`.`EventStaffId`=0xFB989F00000018 AND `EventStaff`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.004

1 call
0 rows

0.004

UPDATE `PageRequest` SET `mxxUpdated`='2026-02-11 22:32:47',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB989F00000003, `path`='forms/cas/login', `formName`='fmiam_cas', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='4', `growth`='620', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:46', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.07322454452514648', `timeTaken`='31', `dictSize`='0', `fields`='{\\'oauth\\':\\'1\\', \\'service\\':\\'/forms/oauth/authorize?client_id=maxxinternal&response_type=code&state=%2fusers%5fonly%2fmeeting%2fMyMeetingFormPublic%2fviewMeetingDocuments%3fmeetingId%3d48E9D700000001&redirect_uri=https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\'}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB989F00000003

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (MailingList, Committee) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xFB989F00000042 ORDER BY `Committee`.`category`, `Committee`.`name`

0.003

1 call
0 rows

0.003

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 22:32:48',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB989F00000007, `path`='forms/oauth/authorize', `formName`='oauth', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='7', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:48', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'client_id\\':\\'maxxinternal\\', \\'redirect_uri\\':\\'https://www.fmiam.maxx.matrixdev.net/mxt/authservice/callback/\\', \\'response_type\\':\\'code\\', \\'state\\':\\'/users_only/meeting/MyMeetingFormPublic/viewMeetingDocuments?meetingId=13D48D00000055\\'}', `clientIPAddr`='216.73.216.107'

0.003

1 call
0 rows

0.003

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

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Branch, Company) WHERE `Branch`.`BranchId`=0xFB989F00000027 AND `Branch`.`CompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.003

1 call
10 rows

0.003

SELECT * FROM MemberCommunicationType ORDER BY orderindex, id

0.003

1 call
1 row

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 (User, Individual) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x20FF0000000B ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.003

1 call
1 row

0.003

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration) WHERE ((((`Registration`.`dateApproved` is null AND (`Registration`.`dateCancelled` is null OR `Registration`.`dateCancelled`>'2026-02-11 22:32:49')) AND `Registration`.`dateRejected` is null) AND `Registration`.`dateSubmitted` is not null) AND `Registration`.`MeetingId`=0x18377F00000173)

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`Event`.`EventId`) AS `EventId`, `Event`.`name`, `Event`.`description`, `Event`.`date`, `Event`.`price`, `Event`.`accountingCode`, `Event`.`selectOnRegForm`, `Event`.`maximumNumAttendees`, `Event`.`location`, `Event`.`startTime`, `Event`.`endTime`, `Event`.`notes`, `Event`.`useSignups`, `Event`.`showOnMeetingView`, `Event`.`publishToCalendar`, `Event`.`publishToSchedule` FROM (Meeting, Event) WHERE `Event`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x18377F00000173 ORDER BY `Event`.`startTime`, `Event`.`name`

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (MailingList, Committee) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xFB989F0000000D ORDER BY `Committee`.`category`, `Committee`.`name`

0.003

1 call
0 rows

0.003

1 call
0 rows

0.003

1 call
1 row

0.003

1 call
1 row

0.003

SELECT COUNT(DISTINCT `Registration`.`RegistrationId`) AS count FROM (Registration) WHERE (`Registration`.`dateRejected` is not null AND `Registration`.`MeetingId`=0x18377F00000173)

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

0.002

1 call
1 row

0.002

SELECT DISTINCT hex(`MailingList`.`MailingListId`) AS `MailingListId`, `MailingList`.`name`, `MailingList`.`shortName`, `MailingList`.`description`, `MailingList`.`shortDescription`, `MailingList`.`joinRule`, `MailingList`.`postRule`, `MailingList`.`deleted`, `MailingList`.`password`, `MailingList`.`welcomeText`, `MailingList`.`goodbyeText`, `MailingList`.`messageFooter`, `MailingList`.`replyDesination`, `MailingList`.`replyDesinationEmail`, `MailingList`.`maxEmailSizeKB`, `MailingList`.`moderated`, `MailingList`.`listVolume`, `MailingList`.`accessRules`, `MailingList`.`dynamic`, `MailingList`.`criteria`, `MailingList`.`ignoreDontEmail`, `MailingList`.`criteriaDict`, `MailingList`.`staffPostingOnly`, `MailingList`.`prepend`, `MailingList`.`criteriaName`, `MailingList`.`showOnMemberParticipationReport`, `MailingList`.`showParticipationOnIndividualView`, `MailingList`.`availableToCMS`, `MailingList`.`numberExcludedByDontEmail`, `MailingList`.`numberExcludedByCriteria`, `MailingList`.`numberIncludedByCriteria`, `MailingList`.`numberSubscribedAsDigest`, `MailingList`.`hasMailingList`, `MailingList`.`numberExcludedByNonMembership`, `MailingList`.`numberExcludedForNoEmail`, `MailingList`.`mailChimpListId`, `MailingList`.`showNewsletterMemberParticipationReport`, `MailingList`.`hourlySync`, `MailingList`.`prettyName`, `MailingList`.`frequency`, `MailingList`.`grouping`, `MailingList`.`campaignMonitorListId` FROM (MailingList, Fee, Fee2MailingList) WHERE (0x18377F00000174=`Fee`.`FeeId` AND `Fee`.`FeeId`=`Fee2MailingList`.`FeeId` AND `Fee2MailingList`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`

0.002

1 call
3 rows

0.002

SELECT * FROM AddressType ORDER BY orderindex, id

0.002

1 call
0 rows

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 (Address, Individual) WHERE `Address`.`IndividualId`=`Individual`.`IndividualId` AND `Individual`.`IndividualId`=0x15E41E0000000C ORDER BY `Address`.`zip`

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

0.002

1 call
2 rows

0.002

SELECT * FROM FeeGroupSizeRule ORDER BY orderindex, id

0.002

2 calls
244 rows

0.001

SELECT * FROM Country ORDER BY orderindex, id

0.002

1 call
0 rows

0.002

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-11 22:32:48',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB989F00000005, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3958658', `requestNum`='5', `pageDictSize`=NULL, `objectId`='A1608000000001', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='752575', `startTime`='2026-02-11 22:32:48', `sessionId`=0x5B6F51547CCEE72D, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'A1608000000001\\'}', `clientIPAddr`='216.73.216.107'

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

0.002

2 calls
1 row

0.001

select mxxCreated, mxxUpdated from Meeting where MeetingId=0x18377F00000173;

0.002

1 call
0 rows

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`ReportingType`.`ReportingTypeId`) AS `ReportingTypeId`, `ReportingType`.`description`, `ReportingType`.`orderindex` FROM (Meeting, ReportingType) WHERE `Meeting`.`MeetingId`=0x18377F00000173 AND `Meeting`.`reportingTypeId`=`ReportingType`.`ReportingTypeId` ORDER BY `ReportingType`.`orderindex`

0.002

1 call
0 rows

0.002

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (MailingList, Committee) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xFB989F0000003C ORDER BY `Committee`.`category`, `Committee`.`name`

0.002

1 call
21 rows

0.002

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 (MetaMeeting, MetaMeetingContact2Individual, Individual) WHERE (0x2C74000000CE=`MetaMeeting`.`MetaMeetingId` AND `MetaMeeting`.`MetaMeetingId`=`MetaMeetingContact2Individual`.`MetaMeetingId` AND `MetaMeetingContact2Individual`.`IndividualId`=`Individual`.`IndividualId`) ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.002

1 call
8 rows

0.002

SELECT * FROM MeetingType ORDER BY orderindex, id

0.002

1 call
2 rows

0.002

SELECT * FROM EmailType ORDER BY orderindex, id

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

0.001

1 call
1 row

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 (User, Individual) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x15E41E0000000D ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId`, `Company`.`name`, `Company`.`companyTypeId`, `Company`.`description`, `Company`.`logo`, `Company`.`enteredBy`, `Company`.`lastUpdatedBy`, `Company`.`taxId`, `Company`.`staffing`, `Company`.`email`, `Company`.`article`, `Company`.`revenue`, `Company`.`paidDues`, `Company`.`lastUpdated`, `Company`.`isComplementary`, `Company`.`name2`, `Company`.`aliases`, hex(`Company`.`companyStatusId`) AS `companyStatusId`, `Company`.`isPubliclyTraded`, `Company`.`annualSales`, `Company`.`brands`, `Company`.`hasSubsidiaries`, `Company`.`visionsId`, `Company`.`otherProductCategory`, `Company`.`prospectStatus`, `Company`.`isParentCompany`, `Company`.`womanOwned`, `Company`.`minorityOwned`, `Company`.`alphaSort`, `Company`.`isGMA`, `Company`.`exhibitorType`, `Company`.`numRetailStores`, `Company`.`numCoOwnedStores`, `Company`.`numFTEmployees`, `Company`.`numPTEmployees`, `Company`.`primaryWholesaler`, `Company`.`numPharmacies`, `Company`.`numDistriCenters`, `Company`.`numWarehouses`, `Company`.`companyStruct`, `Company`.`retailSales`, `Company`.`wholesaleSales`, `Company`.`adjustments`, `Company`.`otherIssues`, `Company`.`includeInSupplierDiversity`, `Company`.`denoteDiversity`, `Company`.`yearEstablished`, `Company`.`owner`, `Company`.`customer1`, `Company`.`customer2`, `Company`.`customer3`, `Company`.`customer4`, `Company`.`customer5`, `Company`.`isCongress`, `Company`.`companyNum`, `Company`.`ticker`, `Company`.`numTotalStores`, `Company`.`matchString`, `Company`.`howHeardAboutOther`, `Company`.`sponsorshipOther`, `Company`.`silent`, `Company`.`mxxCreated`, `Company`.`isNationwide`, `Company`.`numGasStations`, `Company`.`additionalRosterSlots`, `Company`.`criticalNotes`, `Company`.`riskAssessment`, `Company`.`riskRating`, `Company`.`congressofficeFor`, `Company`.`congresspersonFor`, `Company`.`numFilledSlots`, `Company`.`congressSenators`, `Company`.`congressSenator1`, `Company`.`congressSenator2`, `Company`.`congressRep`, `Company`.`congressionalDistrict`, `Company`.`emailDomains`, `Company`.`duesBudget`, `Company`.`invoiceInformation`, `Company`.`numFacilities`, `Company`.`totalSales`, `Company`.`mxxUpdated`, `Company`.`createdOnWWW`, `Company`.`hasFoundation`, `Company`.`foundationDescription`, `Company`.`foundationUrl`, `Company`.`myFMIStaffContact`, `Company`.`isSQFTrainingCenter`, `Company`.`isSQFLicensed`, `Company`.`dateOfSQFLicense`, `Company`.`principalCountry`, `Company`.`FMIMemberPlus`, `Company`.`IncludeInTechDirectory`, `Company`.`techDirectoryContactEmail`, `Company`.`featuredVideoTitle`, `Company`.`featuredVideoDescription`, `Company`.`featuredVideoLink`, `Company`.`sizeOfCompany`, `Company`.`SAIsBoard`, `Company`.`delinquentSince`, `Company`.`otherBillingEmails`, `Company`.`RealActiveMembershipStatus`, `Company`.`isMergeProtected` FROM (Company, MeetingHotel) WHERE `MeetingHotel`.`MeetingHotelId`=0xFB989F00000025 AND `MeetingHotel`.`CompanyId`=`Company`.`CompanyId` ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (MailingList, Committee) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xFB989F00000037 ORDER BY `Committee`.`category`, `Committee`.`name`

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`User`.`UserId`) AS `UserId`, `User`.`username`, `User`.`password`, `User`.`encoding`, hex(`User`.`VotingId`) AS `VotingId`, `User`.`lastSearchType`, `User`.`oneTimeKey`, `User`.`recoverPasswordKey`, `User`.`recoverPasswordTimeout`, `User`.`disableAllNotifications`, `User`.`otCodeTime`, `User`.`otCode`, `User`.`holyGrailSections` FROM (User) WHERE `User`.`UserId`=0x15E41E0000000D

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 (Address, Individual) WHERE `Address`.`AddressId`=0x18377F00000176 AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

1 call
1 row

0.001

SELECT DISTINCT `Calendar`.`name`, `Calendar`.`type`, hex(`Calendar`.`CalendarId`) AS `CalendarId` FROM (Calendar, CalendarToCalendarItem, CalendarItem) WHERE (0x18377F00000177=`CalendarItem`.`CalendarItemId` AND `CalendarItem`.`CalendarItemId`=`CalendarToCalendarItem`.`CalendarItemId` AND `CalendarToCalendarItem`.`CalendarId`=`Calendar`.`CalendarId`)

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (MailingList, Committee) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0xFB989F00000013 ORDER BY `Committee`.`category`, `Committee`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Committee`.`CommitteeId`) AS `CommitteeId`, `Committee`.`description`, `Committee`.`startDate`, `Committee`.`endDate`, `Committee`.`status`, `Committee`.`deleted`, `Committee`.`type`, `Committee`.`category`, `Committee`.`name`, `Committee`.`reportsTo`, `Committee`.`lifespan`, `Committee`.`hidden`, `Committee`.`showParticipationOnIndividualView`, `Committee`.`showOnMemberParticipationreport`, `Committee`.`recordOrigin`, `Committee`.`isBoard`, `Committee`.`myCommitteeNotes`, `Committee`.`inceptionYear`, `Committee`.`notes` FROM (Meeting2Committee, Meeting, Committee) WHERE (0x18377F00000173=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=`Meeting2Committee`.`MeetingId` AND `Meeting2Committee`.`CommitteeId`=`Committee`.`CommitteeId`) ORDER BY `Committee`.`category`, `Committee`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Category, Meeting, Meeting2Category) WHERE (0x18377F00000173=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=`Meeting2Category`.`MeetingId` AND `Meeting2Category`.`CategoryId`=`Category`.`CategoryId`) ORDER BY `Category`.`description`

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 (Address) WHERE `Address`.`AddressId`=0x18377F00000176 ORDER BY `Address`.`zip`

0.000

1 call
28 rows

0.000

SELECT hex(`ReportingType`.`ReportingTypeId`) AS `ReportingTypeId`, `ReportingType`.`description`, `ReportingType`.`orderindex` FROM (ReportingType) ORDER BY `ReportingType`.`orderindex` LIMIT 0, 700

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 (Address, Individual) WHERE `Individual`.`IndividualId`=0x15E41E0000000C AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

SELECT * FROM SpecialDealType ORDER BY orderindex, id

0.000

1 call
0 rows

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

0.000

1 call
0 rows

0.000

834343 function calls (829948 primitive calls) in 2.207 seconds Ordered by: cumulative time List reduced from 1743 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 2.207 2.207 /data/fmiam/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 2.192 2.192 /data/fmiam/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 1.930 1.930 /data/fmiam/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.930 1.930 /data/fmiam/current/libs/webform/meeting/baseMeetingForm.py:317(view) 1 0.001 0.001 1.930 1.930 /data/fmiam/current/libs/webform/PhatForm.py:420(view) 1 0.000 0.000 1.929 1.929 /data/fmiam/current/libs/framework/WebForm.py:189(view) 1 0.000 0.000 0.955 0.955 /data/fmiam/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 1 0.000 0.000 0.955 0.955 /data/fmiam/current/libs/framework/WebApp.py:212(wrapHTML) 1 0.000 0.000 0.852 0.852 /data/fmiam/current/libs/framework/DGEGroup.py:43(getDataDictionary) 46/1 0.000 0.000 0.852 0.852 /data/fmiam/current/libs/framework/DisplayGroup.py:552(getDataDictionary) 135 0.008 0.000 0.766 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 135 0.001 0.000 0.758 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 135 0.001 0.000 0.750 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 135 0.750 0.006 0.750 0.006 {function Connection.query at 0xea75359c1c60} 1 0.000 0.000 0.644 0.644 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:718(process) 47/29 0.003 0.000 0.551 0.019 /data/fmiam/current/libs/framework/DGEAssocList.py:451(getDataDictionary) 63 0.001 0.000 0.550 0.009 /data/fmiam/current/libs/PLayer/PersistentBroker.py:266(processSqlList) 56/54 0.006 0.000 0.534 0.010 /data/fmiam/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 1048/891 0.006 0.000 0.526 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2704(__getattr__) 9 0.000 0.000 0.475 0.053 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:378(getElm) 9 0.000 0.000 0.475 0.053 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 9 0.000 0.000 0.475 0.053 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 9 0.000 0.000 0.470 0.052 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 12 0.000 0.000 0.470 0.039 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 12 0.004 0.000 0.469 0.039 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 10688/9990 0.016 0.000 0.463 0.000 {built-in method builtins.getattr} 20 0.000 0.000 0.395 0.020 /data/fmiam/current/libs/PLayer/PersistentObject.py:2884(_loadListAssoc) 15 0.000 0.000 0.395 0.026 /data/fmiam/current/libs/PLayer/PersistentObject.py:2930(_loadAssocListSQL) 6116 0.022 0.000 0.336 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 1 0.000 0.000 0.311 0.311 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.310 0.310 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 1 0.000 0.000 0.308 0.308 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:247(getStubFromCache) 1 0.000 0.000 0.307 0.307 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.307 0.307 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.307 0.307 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.307 0.307 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.307 0.307 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.007 0.007 0.306 0.306 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 1 0.000 0.000 0.280 0.280 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:663(addMetaTags) 27/20 0.001 0.000 0.258 0.013 /data/fmiam/current/libs/framework/DGEAssoc.py:93(getDataDictionary) 6116 0.019 0.000 0.252 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 1 0.000 0.000 0.228 0.228 /data/fmiam/current/libs/framework/WebForm.py:93(__init__) 2669/2618 0.007 0.000 0.226 0.000 /data/fmiam/current/libs/framework/LazyDict.py:186(__getitem__) 8 0.000 0.000 0.220 0.027 /data/fmiam/current/libs/framework/LazyDict.py:172(get) 2 0.000 0.000 0.218 0.109 /data/fmiam/current/libs/framework/WebForm.py:2881(getViewDG) 2 0.000 0.000 0.218 0.109 /data/fmiam/current/libs/webform/PhatForm.py:188(_getDGByName) 1 0.000 0.000 0.218 0.218 /data/fmiam/current/libs/framework/WebForm.py:147(getDGGreedyAssocs) 2 0.000 0.000 0.218 0.109 /data/fmiam/current/libs/framework/WebSite.py:972(getDGByName) 46/1 0.001 0.000 0.218 0.218 /data/fmiam/current/libs/framework/BaseHandler.py:481(_createDisplayGroup) 240/1 0.001 0.000 0.217 0.217 /data/fmiam/current/libs/framework/DisplayGroup.py:631(_createDGE) 1 0.000 0.000 0.217 0.217 /data/fmiam/current/libs/framework/DisplayGroup.py:835(_createDGEGroup) 62 0.001 0.000 0.201 0.003 /data/fmiam/current/libs/PLayer/PersistentBroker.py:335(processSql) 387 0.006 0.000 0.194 0.001 /data/fmiam/current/libs/framework/DGEAttribute.py:206(getValue) 6116 0.005 0.000 0.192 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 272 0.001 0.000 0.190 0.001 /data/fmiam/current/libs/framework/DGEAttribute.py:110(getDataDictionary) 43/17 0.000 0.000 0.181 0.011 /data/fmiam/current/libs/framework/DisplayGroup.py:766(_createDGEAssoc) 44 0.001 0.000 0.137 0.003 /data/fmiam/current/libs/framework/WebManInterface.py:37(readWebSelect) 36/34 0.000 0.000 0.132 0.004 /data/fmiam/current/libs/PLayer/PersistentObject.py:2941(_loadAssoc) 36/34 0.001 0.000 0.132 0.004 /data/fmiam/current/libs/PLayer/PersistentObject.py:3007(_loadAssocSQL) 6125 0.020 0.000 0.129 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:206(get_descendants) 393/172 0.001 0.000 0.122 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:108(new_init) 2585 0.022 0.000 0.122 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 6116 0.019 0.000 0.120 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname) 34098/34078 0.062 0.000 0.117 0.000 /data/fmiam/current/libs/framework/BaseHandler.py:1471(mxxImporter) 189 0.009 0.000 0.110 0.001 /data/fmiam/current/libs/framework/DisplayGroup.py:707(_createDGEAttribute) 696/678 0.002 0.000 0.108 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 34 0.000 0.000 0.105 0.003 /data/fmiam/current/libs/framework/WebManInterface.py:57(getWebSelectByName) 23184 0.029 0.000 0.104 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:95(is_tag) 10 0.000 0.000 0.100 0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all) 10 0.008 0.001 0.100 0.010 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all) 46 0.011 0.000 0.099 0.002 /data/fmiam/current/libs/framework/BaseHandler.py:443(getDGClass) 1 0.000 0.000 0.093 0.093 /data/fmiam/current/fmiam_org/classes/fmiam_ScrapeAndDrape.py:27(_manipulateLogin) 12490 0.060 0.000 0.089 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/util.py:42(lower) 58 0.000 0.000 0.088 0.002 /data/fmiam/current/libs/framework/BaseHandler.py:1314(getModuleFromBase) 46 0.000 0.000 0.087 0.002 /data/fmiam/current/libs/framework/BaseHandler.py:440(getDGModule) 5 0.000 0.000 0.086 0.017 /data/fmiam/current/libs/PLayer/PersistentBroker.py:1005(countCriteria) 59 0.000 0.000 0.085 0.001 /data/fmiam/current/libs/framework/BaseHandler.py:1340(importModule) 75 0.001 0.000 0.085 0.001 /data/fmiam/current/libs/framework/DGESelect.py:120(getDataDictionary) 46 0.001 0.000 0.085 0.002 /data/fmiam/current/libs/framework/WebSite.py:1133(_loadModule) 7681 0.031 0.000 0.081 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:2043(search) 1 0.000 0.000 0.074 0.074 /data/fmiam/current/fmiam_org/classes/fmiam_ScrapeAndDrape.py:82(doPostScrapeStuff) 1 0.000 0.000 0.074 0.074 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:640(doPostScrapeStuff) 677 0.008 0.000 0.072 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 78 0.001 0.000 0.069 0.001 /data/fmiam/current/libs/PLayer/PersistentBroker.py:159(createPO) 6116 0.022 0.000 0.067 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:648(match_namespace) 1 0.000 0.000 0.064 0.064 /data/fmiam/current/generic/classes/Meeting.py:1814(getNumPaidRegistrations) 1 0.000 0.000 0.064 0.064 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:707(_drape) 77 0.000 0.000 0.063 0.001 /data/fmiam/current/libs/framework/BaseHandler.py:1543(createPOClassByName) 1 0.000 0.000 0.063 0.063 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:406(_applyTitle) 166 0.002 0.000 0.062 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:348(__init__) 1 0.000 0.000 0.061 0.061 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__) 1 0.000 0.000 0.061 0.061 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 684/1 0.010 0.000 0.061 0.061 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 684/1 0.005 0.000 0.061 0.061 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 117361/116685 0.053 0.000 0.056 0.000 {built-in method builtins.isinstance} 1 0.000 0.000 0.055 0.055 /data/fmiam/current/fmiam_org/classes/fmiam_ScrapeAndDrape.py:88(_makeBreadCrumbs) 1960 0.009 0.000 0.053 0.000 /usr/lib/python3.11/copy.py:66(copy) 46 0.000 0.000 0.053 0.001 /usr/lib/python3.11/imp.py:220(load_module) 46 0.000 0.000 0.053 0.001 /usr/lib/python3.11/imp.py:166(load_source) 46 0.000 0.000 0.051 0.001 :711(_load)

The HIPAA Privacy Rule and Refill Reminders- What Supermarket Pharmacies Need to Know

Mega Menu

Sign Up for the