Search for an FMI Associate Member

Want your organization included in this directory?

Take advantage of FMI's Associate Member Directory. Please use the form below to find and contact an FMI Associate Member. The more criteria you select, the more targeted/narrow your search results will be.

You may also click here to view a list of all Associate Members or click here to download the full directory as a PDF.

Alphabetical Listing: (Click to see all companies beginning with that letter)

| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z |

Organization Name:
(Please input at least three letters of the organization name. We will search for matches in the Organization Name, Trade Name, and Brands.)

Brands:

Company Description:
You may search the company description by keyword or phrase. Ex. searching for "ginger snaps" will return all companies with "ginger" immediately followed by "snaps" in the description field.

City:

State:

Country:

Product/Service Category(ies):
(Please check all that apply.)

Advertising/Marketing and Design
Agricultural
Association
Baby Care
Bakery
Baking/Roasting Equipment
Beverages
Biotechnology
Brokers
Co-Packer
Confectionery
Construction
Consulting Services
Dairy
Deli
Employment
Energy Management
Equipment
Financial Services
Fixtures/Shelving/Floors
Floral
Food Products/Snacks
Food Safety
Fresh
Frozen
Nonfoods
Hard Goods
Health & Beauty Care
Household Products/Cleaning/Supplies
Human Resources/Training
Ingredients

Legal Services
Maintenance
Meat/Poultry
Merchandising Services
Natural/Organic
OTC Drugs
Packaging
Payments
Perishables
Pet Health & Nutrition
Petroleum
Pharmaceuticals
Point-of-Sale Equipment
Private Brands
Produce
Refrigeration
Research
Seafood
Security Systems & Products
Spices
Store Design
Supplements
Supply Chain
Technology Services
Transportation/Distribution Services
Uniforms
Unsaleables
Utilities
Other
Sustainability

Total Time

Count

Avg Time

Query

0.012

20 calls
21 rows

0.001

SELECT * FROM MembershipType ORDER BY orderindex, id

0.007

2 calls
61 rows

0.004

SELECT `Service`.`description`, hex(`Service`.`ServiceId`) AS `ServiceId` FROM (Service) ORDER BY orderindex

0.007

9 calls
1 row

0.001

SELECT version from databasemap;

0.006

2 calls
54 rows

0.003

SELECT hex(`StateProvince`.`StateProvinceId`) AS `StateProvinceId`, `StateProvince`.`description`, `StateProvince`.`description`, `StateProvince`.`fullName`, `StateProvince`.`abbreviation` FROM (StateProvince) ORDER BY `StateProvince`.`description`

0.005

2 calls
244 rows

0.003

SELECT * FROM Country ORDER BY orderindex, id

0.005

2 calls
244 rows

0.002

SELECT `Country`.`orderindex`, `Country`.`description`, hex(`Country`.`CountryId`) AS `CountryId` FROM (Country) ORDER BY orderindex

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAB4600000020 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

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

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(`Membership`.`MembershipId`) AS `MembershipId`, `Membership`.`MembershipTypeId`, `Membership`.`joined`, `Membership`.`expires`, `Membership`.`billingCycle`, `Membership`.`billingStart`, `Membership`.`renewalNoticeSent`, `Membership`.`dateRenewed`, `Membership`.`dateRenewallLetterSent`, `Membership`.`lastRenewallLentDate`, `Membership`.`dateCanncelled`, `Membership`.`cancelReason`, `Membership`.`enteredBy`, `Membership`.`updatedBy`, `Membership`.`dateofPaymeny`, `Membership`.`balanceDue`, `Membership`.`renewalAmount`, `Membership`.`paidDues`, `Membership`.`renewalStatus`, `Membership`.`memberSinceDate`, `Membership`.`status`, `Membership`.`marketingCode`, `Membership`.`mxxUpdated`, `Membership`.`memberRecordComment` FROM (Company, Membership) WHERE `Company`.`MembershipId`=`Membership`.`MembershipId` AND `Company`.`CompanyId`=0xCFAB4600000005

0.004

2 calls
54 rows

0.002

SELECT * FROM StateProvince ORDER BY orderindex, id

0.004

1 call
0 rows

0.004

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAB4600000029 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAB460000001A AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.003

1 call
0 rows

0.003

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

0.003

1 call
0 rows

0.003

SELECT DISTINCT hex(`Address`.`AddressId`) AS `AddressId`, `Address`.`line1`, `Address`.`line2`, `Address`.`city`, `Address`.`CountryId`, `Address`.`AddressTypeId`, `Address`.`StateProvinceId`, `Address`.`province`, `Address`.`zip`, `Address`.`isPrimary`, `Address`.`name`, `Address`.`mainPhone`, `Address`.`fax`, `Address`.`tollFree`, `Address`.`zip5`, `Address`.`isZipVerified`, `Address`.`congressionalDistrict`, `Address`.`latitude`, `Address`.`longitude`, `Address`.`jsonResult`, `Address`.`countyFips`, `Address`.`countyName`, `Address`.`stateFips`, `Address`.`dateVerified` FROM (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAB4600000023 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

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

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 (Individual, Address) WHERE `Individual`.`IndividualId`=0xCFAB4600000009 AND `Individual`.`mainAddressId`=`Address`.`AddressId` 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 (Address, Branch) WHERE `Address`.`AddressId`=0xCFAB460000000D AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.002

1 call
4 rows

0.002

SELECT * FROM MinorityType ORDER BY orderindex, id

0.002

1 call
2 rows

0.002

SELECT * FROM YesNo 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 (Address, Branch) WHERE `Address`.`AddressId`=0xCFAB4600000015 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

0.002

1 call
0 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 (Individual, Company) WHERE `Company`.`CompanyId`=0xCFAB4600000005 AND `Company`.`BillingContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

1 call
0 rows

0.001

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

0.001

1 call
0 rows

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

0.001

1 call
0 rows

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

0.001

1 call
0 rows

0.001

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

0.001

1 call
0 rows

0.001

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

0.001

1 call
0 rows

0.001

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

0.001

1 call
0 rows

0.001

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 12:24:55',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFAB4600000000, `path`='forms/meeting/MeetingFormPublic/search', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2647540', `requestNum`='1', `growth`='16972', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1517480', `startTime`='2025-09-09 12:24:54', `sessionId`=0x750854F05DD23658, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.022428512573242188', `timeTaken`='91', `dictSize`='0', `fields`='{}', `clientIPAddr`='216.73.216.129' WHERE `PageRequestId`=0xCFAB4600000000

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

0.000

1 call
0 rows

0.000

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

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 12:24:56',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFAB4600000004, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2647540', `requestNum`='2', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1517480', `startTime`='2025-09-09 12:24:56', `sessionId`=0x750854F05DD23658, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.129'

0.000

1 call
0 rows

0.000

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

0.000

1 call
0 rows

0.000

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

0.000

1 call
0 rows

0.000

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

0.000

1 call
0 rows

0.000

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

0.000

1 call
0 rows

0.000

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

0.000

1 call
3 rows

0.000

SELECT * FROM AddressType ORDER BY orderindex, id

         2055465 function calls (2038851 primitive calls) in 2.852 seconds

   Ordered by: cumulative time
   List reduced from 1518 to 100 due to restriction <100>

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000    2.852    2.852 /data/fmiam/current/libs/framework/WebManager.py:136(_newRequest)
        1    0.000    0.000    2.848    2.848 /data/fmiam/current/libs/framework/WebSite.py:168(processRequest)
        1    0.000    0.000    2.801    2.801 /data/fmiam/current/libs/framework/BaseHandler.py:269(_safeCall)
        1    0.000    0.000    2.801    2.801 /data/fmiam/current/fmiam_org/sites/www/forms/fmiam_CompanyFormPublic.py:20(search)
        1    0.000    0.000    2.801    2.801 /data/fmiam/current/generic/sites/www/forms/CompanyFormPublic.py:87(search)
        1    0.000    0.000    2.773    2.773 /data/fmiam/current/libs/framework/WebForm.py:1090(search)
        1    0.000    0.000    1.647    1.647 /data/fmiam/current/libs/framework/WebApp.py:277(writeHTMLWithWrap)
        1    0.000    0.000    1.647    1.647 /data/fmiam/current/libs/framework/WebApp.py:213(wrapHTML)
        1    0.000    0.000    1.506    1.506 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:72(__init__)
        1    0.000    0.000    1.506    1.506 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:268(scrape)
        1    0.000    0.000    1.126    1.126 /data/fmiam/current/generic/sites/www/forms/CompanyFormPublic.py:136(getSearchHTML)
        1    0.003    0.003    1.126    1.126 /data/fmiam/current/libs/framework/WebForm.py:1531(getSearchHTML)
        1    0.000    0.000    0.744    0.744 /usr/lib/python3.11/urllib/request.py:139(urlopen)
        1    0.000    0.000    0.744    0.744 /usr/lib/python3.11/urllib/request.py:500(open)
        1    0.000    0.000    0.744    0.744 /usr/lib/python3.11/urllib/request.py:529(_open)
        2    0.000    0.000    0.744    0.372 /usr/lib/python3.11/urllib/request.py:489(_call_chain)
        1    0.000    0.000    0.744    0.744 /usr/lib/python3.11/urllib/request.py:1390(https_open)
        1    0.000    0.000    0.744    0.744 /usr/lib/python3.11/urllib/request.py:1307(do_open)
      312    0.002    0.000    0.724    0.002 /data/fmiam/current/libs/framework/DTWrapper.py:47(__call__)
      312    0.009    0.000    0.720    0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__)
 3516/312    0.008    0.000    0.681    0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks)
 4582/312    0.106    0.000    0.680    0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_)
       36    0.002    0.000    0.673    0.019 {method 'readline' of '_io.BufferedReader' objects}
        1    0.000    0.000    0.671    0.671 /usr/lib/python3.11/http/client.py:1351(getresponse)
        6    0.000    0.000    0.671    0.112 /usr/lib/python3.11/socket.py:704(readinto)
        1    0.000    0.000    0.671    0.671 /usr/lib/python3.11/http/client.py:318(begin)
        6    0.000    0.000    0.671    0.112 /usr/lib/python3.11/ssl.py:1299(recv_into)
        6    0.000    0.000    0.671    0.112 /usr/lib/python3.11/ssl.py:1157(read)
        6    0.671    0.112    0.671    0.112 {method 'read' of '_ssl._SSLSocket' objects}
        1    0.000    0.000    0.671    0.671 /usr/lib/python3.11/http/client.py:285(_read_status)
    44/40    0.024    0.001    0.520    0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_In.py:665(renderwob)
       13    0.000    0.000    0.516    0.040 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__)
       13    0.000    0.000    0.513    0.039 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed)
       13    0.000    0.000    0.513    0.039 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed)
       13    0.000    0.000    0.512    0.039 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse)
       13    0.000    0.000    0.512    0.039 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse)
       13    0.019    0.001    0.509    0.039 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop)
       32    0.012    0.000    0.451    0.014 /data/fmiam/current/libs/framework/DGESelect.py:36(getEditHTML)
      6/5    0.000    0.000    0.378    0.076 /data/fmiam/current/libs/framework/DGEAssoc.py:120(getBBTDictionary)
        1    0.000    0.000    0.377    0.377 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts)
      6/5    0.000    0.000    0.375    0.075 /data/fmiam/current/libs/framework/DGEAssoc.py:42(getEditHTML)
      103    0.001    0.000    0.355    0.003 /data/fmiam/current/libs/framework/DGEAttribute.py:139(getBBTDictionary)
        6    0.012    0.002    0.317    0.053 /data/fmiam/current/libs/framework/DGEObjectMultiSelect.py:53(getEditHTML)
        2    0.000    0.000    0.309    0.155 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup)
        6    0.000    0.000    0.272    0.045 /data/fmiam/current/libs/framework/DGEMethod.py:90(getBBTDictionary)
        6    0.000    0.000    0.272    0.045 /data/fmiam/current/libs/framework/DGEMethod.py:107(getDataDictionary)
        6    0.004    0.001    0.263    0.044 /data/fmiam/current/libs/framework/DGEMethod.py:31(getEditHTML)
     7847    0.048    0.000    0.261    0.000 /data/fmiam/current/libs/framework/MaxxDTML.py:29(render)
        7    0.000    0.000    0.257    0.037 /data/fmiam/current/libs/framework/DisplayGroup.py:571(getBBTDictionary)
        1    0.000    0.000    0.218    0.218 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:473(_includeMaxxCSS)
       10    0.000    0.000    0.208    0.021 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:374(getElm)
       10    0.000    0.000    0.208    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select)
       10    0.000    0.000    0.208    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select)
       10    0.000    0.000    0.208    0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select)
       17    0.000    0.000    0.207    0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect)
       17    0.003    0.000    0.207    0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select)
4677/4665    0.011    0.000    0.205    0.000 /data/fmiam/current/libs/framework/LazyDict.py:186(__getitem__)
     8313    0.049    0.000    0.201    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__)
    13218    0.024    0.000    0.188    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:373(__getitem__)
2248/2192    0.005    0.000    0.177    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag)
7333/6970    0.006    0.000    0.176    0.000 {method 'update' of 'dict' objects}
    87472    0.172    0.000    0.172    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:350(__getattribute__)
        1    0.000    0.000    0.159    0.159 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:494(_includeMaxxJavascript)
     7162    0.008    0.000    0.142    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match)
    13314    0.067    0.000    0.142    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:376(getitem)
        1    0.000    0.000    0.140    0.140 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:714(process)
 1543/759    0.002    0.000    0.127    0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:108(new_init)
      121    0.001    0.000    0.127    0.001 /data/fmiam/current/libs/framework/DGEAttribute.py:58(getEditHTML)
        6    0.001    0.000    0.122    0.020 /data/fmiam/current/libs/PLayer/PersistentBroker.py:566(getAll)
     2161    0.005    0.000    0.120    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal)
       81    0.000    0.000    0.111    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute)
       81    0.000    0.000    0.110    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query)
     7162    0.009    0.000    0.107    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors)
       81    0.000    0.000    0.107    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query)
       81    0.107    0.001    0.107    0.001 {function Connection.query at 0xe3777a0b6980}
      718    0.003    0.000    0.103    0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:2950(_createObjectFromRow)
      759    0.008    0.000    0.099    0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:348(__init__)
        4    0.000    0.000    0.098    0.025 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode)
   2898/4    0.030    0.000    0.098    0.025 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode)
   2898/4    0.013    0.000    0.098    0.025 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents)
     7162    0.005    0.000    0.091    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag)
     5929    0.026    0.000    0.084    0.000 /usr/lib/python3.11/copy.py:66(copy)
     3966    0.004    0.000    0.081    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:349(insertText)
     8834    0.025    0.000    0.081    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:338(_pop)
     3966    0.008    0.000    0.076    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:354(insertText)
329332/328041    0.073    0.000    0.076    0.000 {built-in method builtins.isinstance}
       17    0.000    0.000    0.071    0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all)
       17    0.010    0.001    0.071    0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all)
      579    0.004    0.000    0.070    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1098(startTagA)
     2174    0.008    0.000    0.069    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:152(elementClass)
     6191    0.015    0.000    0.065    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:273(appendChild)
      600    0.001    0.000    0.064    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:957(addFormattingElement)
       33    0.000    0.000    0.064    0.002 /data/fmiam/current/libs/PLayer/PersistentBroker.py:267(processSqlList)
     3080    0.003    0.000    0.063    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:1009(processSpaceCharactersNonPre)
     5726    0.013    0.000    0.063    0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:2675(__getattr__)
        1    0.000    0.000    0.062    0.062 /usr/lib/python3.11/http/client.py:1426(__init__)
        1    0.000    0.000    0.062    0.062 /usr/lib/python3.11/ssl.py:745(create_default_context)
     7172    0.010    0.000    0.062    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:206(get_descendants)
        1    0.000    0.000    0.062    0.062 /usr/lib/python3.11/ssl.py:591(load_default_certs)
     7162    0.008    0.000    0.062    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:689(match_tagname)

Search for an FMI Associate Member

Mega Menu

Sign Up for the