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

1 call
0 rows

0.041

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

0.032

2 calls
244 rows

0.016

SELECT * FROM Country ORDER BY orderindex, id

0.023

1 call
0 rows

0.023

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

0.020

2 calls
54 rows

0.010

SELECT * FROM StateProvince ORDER BY orderindex, id

0.011

1 call
0 rows

0.011

COMMIT

0.011

1 call
4 rows

0.011

SELECT * FROM MinorityType ORDER BY orderindex, id

0.010

2 calls
61 rows

0.005

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

0.009

1 call
1 row

0.009

SELECT * FROM uuid FOR UPDATE

0.004

20 calls
21 rows

0.000

SELECT * FROM MembershipType ORDER BY orderindex, id

0.004

1 call
3 rows

0.004

SELECT * FROM AddressType ORDER BY orderindex, id

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`=0xF569E100000005 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.002

13 calls
1 row

0.000

SELECT version from databasemap;

0.002

2 calls
244 rows

0.001

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

0.001

2 calls
54 rows

0.001

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

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`=0xF569E100000001 AND `Company`.`DirectoryContactId`=`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`=0xF569E100000001 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`=0xF569E100000001 AND `Company`.`BillingContactId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

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`=0xF569E100000019 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`=0xF569E100000008 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

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`=0xF569E10000001F AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

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`=0xF569E100000016 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

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`=0xF569E100000025 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

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`=0xF569E100000022 AND `Individual`.`mainAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
173 rows

0.000

SELECT * FROM webselect

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

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`=0xF569E10000001C 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`=0xF569E100000017 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-12-26 08:45:18',`mxxCreatedBy`=NULL, `PageRequestId`=0xF569E100000000, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='3315266', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='494641', `startTime`='2025-12-26 08:45:18', `sessionId`=0x5A1B10576580932D, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.150'

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

0.000

1 call
0 rows

0.000

START TRANSACTION

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`=0xF569E100000009 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`=0xF569E100000026 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`=0xF569E10000000F 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`=0xF569E100000020 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`=0xF569E10000000C 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`=0xF569E10000001D AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

         2299117 function calls (2277391 primitive calls) in 3.859 seconds

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

   ncalls  tottime  percall  cumtime  percall filename:lineno(function)
        1    0.000    0.000    3.860    3.860 /data/fmiam/current/libs/framework/WebManager.py:134(_newRequest)
        1    0.000    0.000    3.474    3.474 /data/fmiam/current/libs/framework/WebSite.py:167(processRequest)
        1    0.000    0.000    3.327    3.327 /data/fmiam/current/libs/framework/BaseHandler.py:268(_safeCall)
        1    0.000    0.000    3.327    3.327 /data/fmiam/current/fmiam_org/sites/www/forms/fmiam_CompanyFormPublic.py:19(search)
        1    0.000    0.000    3.327    3.327 /data/fmiam/current/generic/sites/www/forms/CompanyFormPublic.py:87(search)
        1    0.000    0.000    3.270    3.270 /data/fmiam/current/libs/framework/WebForm.py:1089(search)
        1    0.000    0.000    2.661    2.661 /data/fmiam/current/libs/framework/WebApp.py:276(writeHTMLWithWrap)
        1    0.000    0.000    2.661    2.661 /data/fmiam/current/libs/framework/WebApp.py:212(wrapHTML)
        1    0.000    0.000    2.503    2.503 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:72(__init__)
        1    0.001    0.001    2.502    2.502 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:272(scrape)
        1    0.000    0.000    1.826    1.826 /usr/lib/python3.11/urllib/request.py:139(urlopen)
        1    0.000    0.000    1.825    1.825 /usr/lib/python3.11/urllib/request.py:500(open)
        1    0.000    0.000    1.825    1.825 /usr/lib/python3.11/urllib/request.py:529(_open)
        2    0.000    0.000    1.825    0.913 /usr/lib/python3.11/urllib/request.py:489(_call_chain)
        1    0.000    0.000    1.825    1.825 /usr/lib/python3.11/urllib/request.py:1390(https_open)
        1    0.000    0.000    1.825    1.825 /usr/lib/python3.11/urllib/request.py:1307(do_open)
       41    0.006    0.000    1.789    0.044 {method 'readline' of '_io.BufferedReader' objects}
        1    0.000    0.000    1.783    1.783 /usr/lib/python3.11/http/client.py:1351(getresponse)
        1    0.000    0.000    1.783    1.783 /usr/lib/python3.11/http/client.py:318(begin)
        6    0.000    0.000    1.782    0.297 /usr/lib/python3.11/socket.py:704(readinto)
        6    0.000    0.000    1.782    0.297 /usr/lib/python3.11/ssl.py:1299(recv_into)
        1    0.000    0.000    1.782    1.782 /usr/lib/python3.11/http/client.py:285(_read_status)
        6    0.000    0.000    1.782    0.297 /usr/lib/python3.11/ssl.py:1157(read)
        6    1.782    0.297    1.782    0.297 {method 'read' of '_ssl._SSLSocket' objects}
        1    0.000    0.000    0.609    0.609 /data/fmiam/current/generic/sites/www/forms/CompanyFormPublic.py:136(getSearchHTML)
        1    0.001    0.001    0.609    0.609 /data/fmiam/current/libs/framework/WebForm.py:1530(getSearchHTML)
       13    0.000    0.000    0.450    0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__)
       13    0.000    0.000    0.449    0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed)
       13    0.000    0.000    0.449    0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed)
       13    0.000    0.000    0.447    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse)
       13    0.000    0.000    0.447    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse)
       13    0.017    0.001    0.446    0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop)
        1    0.000    0.000    0.374    0.374 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:530(_addStylesAndScripts)
        1    0.000    0.000    0.373    0.373 /data/fmiam/current/libs/framework/WebManager.py:88(createNewHandler)
        1    0.000    0.000    0.373    0.373 /data/fmiam/current/libs/framework/WebSite.py:91(__init__)
      312    0.002    0.000    0.334    0.001 /data/fmiam/current/libs/framework/DTWrapper.py:47(__call__)
      312    0.003    0.000    0.332    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__)
        2    0.000    0.000    0.321    0.161 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:362(rebuildSoup)
 3516/312    0.004    0.000    0.296    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks)
 4582/312    0.043    0.000    0.295    0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_)
       99    0.000    0.000    0.287    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute)
       99    0.001    0.000    0.286    0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query)
    44/40    0.008    0.000    0.231    0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_In.py:665(renderwob)
       99    0.000    0.000    0.231    0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query)
       99    0.231    0.002    0.231    0.002 {function Connection.query at 0xfd2ae62ad940}
  348/159    0.006    0.000    0.218    0.001 {built-in method builtins.exec}
  205/128    0.001    0.000    0.215    0.002 :1165(_find_and_load)
  213/134    0.001    0.000    0.213    0.002 :666(_load_unlocked)
  205/128    0.001    0.000    0.212    0.002 :1120(_find_and_load_unlocked)
  211/134    0.001    0.000    0.207    0.002 :934(exec_module)
       32    0.004    0.000    0.207    0.006 /data/fmiam/current/libs/framework/DGESelect.py:36(getEditHTML)
       10    0.000    0.000    0.199    0.020 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:378(getElm)
       10    0.000    0.000    0.199    0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select)
       10    0.000    0.000    0.199    0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select)
       10    0.000    0.000    0.196    0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select)
       17    0.000    0.000    0.196    0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect)
       17    0.003    0.000    0.195    0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select)
        1    0.000    0.000    0.192    0.192 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:498(_includeMaxxJavascript)
      6/5    0.000    0.000    0.187    0.037 /data/fmiam/current/libs/framework/DGEAssoc.py:42(getEditHTML)
        1    0.000    0.000    0.183    0.183 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:477(_includeMaxxCSS)
     8313    0.030    0.000    0.180    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__)
4677/4665    0.005    0.000    0.177    0.000 /data/fmiam/current/libs/framework/LazyDict.py:186(__getitem__)
      6/5    0.000    0.000    0.168    0.034 /data/fmiam/current/libs/framework/DGEAssoc.py:120(getBBTDictionary)
      103    0.001    0.000    0.165    0.002 /data/fmiam/current/libs/framework/DGEAttribute.py:138(getBBTDictionary)
        1    0.000    0.000    0.158    0.158 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:718(process)
        6    0.003    0.001    0.156    0.026 /data/fmiam/current/libs/framework/DGEObjectMultiSelect.py:52(getEditHTML)
        1    0.004    0.004    0.150    0.150 /data/fmiam/current/libs/framework/BaseHandler.py:463(_loadDisplayGroups)
41979/41538    0.026    0.000    0.149    0.000 /data/fmiam/current/libs/framework/BaseHandler.py:1471(mxxImporter)
  444/255    0.000    0.000    0.144    0.001 :233(_call_with_frames_removed)
2248/2192    0.003    0.000    0.137    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag)
     7162    0.007    0.000    0.135    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match)
        1    0.000    0.000    0.130    0.130 /data/fmiam/current/libs/framework/DisplayGroup.py:311(initialize)
 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.122    0.001 /data/fmiam/current/libs/framework/DGEAttribute.py:57(getEditHTML)
        1    0.000    0.000    0.121    0.121 /data/fmiam/current/libs/framework/WebManInterface.py:92(createBroker)
    85/67    0.000    0.000    0.120    0.002 /data/fmiam/current/libs/PLayer/PersistentBroker.py:77(__new__)
        6    0.000    0.000    0.118    0.020 /data/fmiam/current/libs/framework/DGEMethod.py:90(getBBTDictionary)
        6    0.000    0.000    0.118    0.020 /data/fmiam/current/libs/framework/DGEMethod.py:107(getDataDictionary)
        1    0.012    0.012    0.117    0.117 /data/fmiam/current/libs/PLayer/PersistentBroker.py:441(retrieveClassMaps)
     7847    0.020    0.000    0.116    0.000 /data/fmiam/current/libs/framework/MaxxDTML.py:29(render)
42003/41542    0.022    0.000    0.115    0.000 {built-in method builtins.__import__}
        7    0.000    0.000    0.113    0.016 /data/fmiam/current/libs/framework/DisplayGroup.py:571(getBBTDictionary)
        6    0.000    0.000    0.106    0.018 /data/fmiam/current/libs/framework/DGEMethod.py:31(getEditHTML)
        1    0.000    0.000    0.104    0.104 /data/fmiam/current/libs/framework/WebForm.py:93(__init__)
        2    0.001    0.000    0.101    0.050 /data/fmiam/current/libs/framework/BaseHandler.py:990(checkAndReloadOptionsFromXML)
     2161    0.009    0.000    0.101    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal)
        3    0.000    0.000    0.101    0.034 /data/fmiam/current/libs/framework/WebForm.py:2886(getSearchDG)
        3    0.000    0.000    0.101    0.034 /data/fmiam/current/generic/sites/www/forms/CompanyFormPublic.py:176(_getDGByName)
        3    0.000    0.000    0.101    0.034 /data/fmiam/current/libs/framework/WebSite.py:972(getDGByName)
        4    0.000    0.000    0.101    0.025 /data/fmiam/current/libs/framework/LazyDict.py:172(get)
     11/1    0.000    0.000    0.101    0.101 /data/fmiam/current/libs/framework/BaseHandler.py:481(_createDisplayGroup)
     7162    0.009    0.000    0.100    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors)
        8    0.006    0.001    0.099    0.012 /data/fmiam/current/libs/framework/BaseHandler.py:1163(loadSettingsFromFile)
       44    0.001    0.000    0.096    0.002 /data/fmiam/current/libs/PLayer/PersistentBroker.py:335(processSql)
        8    0.074    0.009    0.093    0.012 /data/fmiam/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML)
    62/18    0.000    0.000    0.090    0.005 /data/fmiam/current/libs/framework/DisplayGroup.py:631(_createDGE)
       33    0.000    0.000    0.089    0.003 /data/fmiam/current/libs/PLayer/PersistentBroker.py:266(processSqlList)
    13218    0.009    0.000    0.089    0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:373(__getitem__)
        4    0.000    0.000    0.088    0.022 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode)
   2898/4    0.020    0.000    0.088    0.022 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode)

Search for an FMI Associate Member

Mega Menu

Sign Up for the