Member Directory: FMI

Regular Members

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

A

A-Gas
A.J. Letizio Sales & Marketing, Inc.
A.T. Kearney GmbH
Accenture
Acosta
Action Food Sales, Inc.
AdAdapted
Advanced Fresh Concepts Franchise Corp.
Advanced Refrigeration Systems
Advantage Solutions
Affinity Group
Afresh Technologies
AHT Cooling Systems GmbH
AHT Cooling Systems USA Inc.
Ainsworth Pet Nutrition
Air-Row Fans
AKI Technologies
Alexia Foods, Inc.
AlixPartners LLP
ALL-TAG Corporation
Alliance Marketing, LLC
ALTO
ALTO S.A.
Amcor Flexibles North America
American Egg Board
American Heart Association
AmeriCold Logistics, LLC
Amerlux, LLC
Anthony
Aperion Solutions
Applegate
Aptaris
Aqua Star
ARC by ChargeItSpot
Armasan Ambalaj A.S
Armour Food Company
Ase International-Navidul
Audit Technology Group
Auror
Australian Trade & Investment Commission
Australis Aquaculture
Avery Dennison
Avery Dennison
Axiom Energy Solutions
Axis Communications
AZ Gems

B

The Bel Group
Bernatello's Foods
BGJ Group
Big Heart Pet Brands
Birdzi Inc.
Bitcoin Depot
Bitzer Canada, Inc.
Bitzer US, Inc.
Blackhawk Network Holdings, Inc.
Blue Yonder
Bluegrass Ingredients
BLUEOCO
BMO
BMO Capital Markets
Boar's Head Provisions Co., Inc.
BODYARMOR | POWERADE
Boulder Brands, Inc.
Brain Corp
BRdata
Bristol Bay Regional Seafood Development Association
Brynwood Partners L.P.
BUENO
Buitoni Food Company
Bumble Bee Foods, LLC
Bush Brothers & Company

C

C.A. Ferolie
C.A. Fortune
CA Carlin
Capango
Carel USA, Inc.
Cargill Human Health & Nutrition
Cargill Incorporated
Cargill Protein
Carlson AirFlo Merchandising Systems
Carlyle Compressor Company
Cascades SPG
Catalina
Catalina Snacks
Catania Oils
Cellhub
Center for Advancing Retail & Technology
Century Foods International
Channel Fish Processing
Chemours Company
CHEP
CHEP Australia
CHEP Canada
Chernoff Newman
Chilean Salmon Marketing Council
Choice Canning Company
Chomps
Circana
Cisaplast USA
City Building Engineering Services (CBES)
CKF Foods, Inc.
Claire's
Clear Demand
Clearwater Fine Foods, Inc.
Climate Pros LLC
Clougherty Packing Company (Farmer John)
Clover Leaf Seafoods, L.P.
Club Demonstration Services
CMI Orchards
Coca-Cola Beverages Florida
Cognira
Colgate-Palmolive Company
Collective Bias
Commercial Refrigeration Specialist
Completely Fresh Foods Inc.
CMX
Conagra Brands
CoolSys
CoolSys Energy Design
CoolSys Energy Solutions
Copeland
Copeland Canada
Coresight Research
Cotiviti, Inc.
Country Fresh
crisp
CROSSMARK
CROSSMARK Canada
Cuhaci & Peterson, Architects Engineers Planners
Custom Designed Power & Controls, LLC

D

Dan's Prize
Danfoss
Datasembly
Daymon
Dearing & Company
DecisionNext, Inc
DEEM LLC
Deloitte Consulting LLP
Deloitte, LLP
Designer Greetings
DFA
Diamond Crystal Brands
Dietz & Watson
Digital Wave Technology
Diversey - A Solenis Company
DNR Sales & Marketing Strategy Advisors
Dorin USA LLC
Dover Corporation
Drive Wheel
dunnhumby

E

Eagle Eye Solutions Group
Eagle Family Foods Group LLC
Eastern Fish Company
ebm Industrial S de RL de CV
ebm-papst Inc.
ebm-papst Canada Inc.
ECR Software Corporation (ECRS)
Eggs Unlimited
eGrowcery
Emerge Strategic Solutions
Emerson Automation Solutions
Emerson Grind2Energy
Empire Foods
Empire Marketing Strategies
Empire Packing Company, L.P.
Ephex Partners
Epic Sales Partners, Inc.
Eurpac Service Inc.
Everseen Limited
Eversight, Inc.

F

Fabric
FaceFirst, Inc.
Facilio
Faegre Drinker Biddle & Reath LLP
Far East Brokers & Consultants, Inc.
Farmer Focus
Ferrero NA, Inc.
Ferrero UK
Fetch Rewards
FHI
Fieldale Farms Corporation
FirstShift Inc
FishWise
Flashfood Inc.
Flo Energy Solutions Inc.
Flora Food US Inc.
FMS Solutions
Focal Systems Inc.
FOODMatch
Foster Farms
Fountain
Freshpet, Inc.
FrontLine Marketing
Furlani Foods

G

Garelick Farms
GBC Food Services, LLC
Genera
George's Inc
George's Inc.
Georgia-Pacific
The Gillette Company
Glanbia
GlaxoSmithKline Inc.
Golden Flake Snack Foods, Inc.
Golden West Food Group
Google Cloud
Google, Inc.
GoSpotCheck by FORM
GreenBox Logistics
Greenstone LLC
Grobest Seafood Global, Inc.
GS1 US
Guac
Guntner US, LLC

H

H&N GROUP INC.
Haleon
Hallmark Cards, Inc.
Hans Kissle Co.,Inc.
Hans Kissle Company
Hanshow America Inc.
Harmonya
The Hartman Group
Haynes and Boone LLP
Healthy Snacks Holdco LLC
Hearthside Foods
Heartland Coca-Cola
Heat Seal, LLC
HTPG- Heat Transfer Products Group
Heatcraft Refrigeration Products LLC
High Liner Foods Inc.
Hillphoenix - Display Case Division
Hillphoenix - Refrigeration Systems
Hillphoenix - Walk-Ins Division
Hillphoenix AMS Group
Hillphoenix, A Dover Company
Hogan Lovells US LLP
Homesome, Inc.
Hometown Food Company
Honeywell International Inc.
Honeywell MultiSite
Horizon Organic Dairy
Hormel Foods Corporation
Hormel Foods International Corporation
Hostess Brands LLC
HRG
HS&R Sales and Marketing Solutions
Hudson Technologies
Hussmann Canada Inc.
Hussmann Corporation
Hussmann Europe Ltd.

I

The Iams Company
Ibotta, Inc.
ICC-ES
Idahoan Foods
Ideal by Design House
IFB Agro Industries Limited
IFCO
IMI Global
Impossible Foods
InContext Solutions
Inland Seafood Corporation
Inmar Inc.
InMarket
Instacart
InstaKey Security Systems

J

The J.M. Smucker Company
Jacob Leinenkugel Brewing Co.
Jennie-O Turkey Store
JETRO Chicago
JOH
Johnsonville Sausage, LLC
Jolt Software
JSI Store Fixtures, Inc.
JTM Foods, LLC

K

Kearney
KeepRite Refrigeration
Kemps LLC
Kentucky Center for Agriculture and Rural Development (KCARD)
Keurig Dr Pepper
Kies Consulting, LLC
KIND Snacks
Klockner Pentaplast Food & Consumer Products
Knott's Berry Farm Foods
KPI Solutions
KPS Global
Kruger Products USA
KSS Retail
Kurt Salmon, part of Accenture Strategy

L

L&R Distributors
Label Insight
Lakeview Farms, Inc
Lavazza North America Inc.
Liquid Remedy
LK Packaging
Locus Traxx Worldwide
Lowe Rental

M

Mama's Creations, Inc.
Maple Leaf Farms Inc.
Marketing By Design
Marketing Management, Inc.
Mars Food
Mars Wrigley Confectionery
Mars, Incorporated
Marsh & McLennan, Inc.
Mastercard
Mastercard Data and Services
Mayfield Dairy Farms
McAlpine Hussmann Ltd.
McCall Farms, Inc.
McCormick & Company, Inc. - Private Label
McCormick & Company, Inc.
McKinsey & Company
Meatable
Mercatus
MIC Food Group
Microsoft Corporation
Mistica Foods
Mizuho Bank, Ltd.
Molson Coors Beverage Company
Mountaire Farms, Inc.
Movista, Inc.
MSA Safety
Multisorb Filtration Group
Murphy Brown, LLC
Musco Family Olive Co.
Muscolino Inventory

N

Naddif Sales & Marketing
National Pork Board
National Refrigerants, Inc. (NRI)
Natural Insight
Nature Fresh Farm Sales Inc
Nature's Way
Navajo Manufacturing Company Incorporated
NETUNO USA
New Zealand Trade + Enterprise
Newly Weds Foods Inc.
Nielsen Catalina Solutions
Nielsen Perishables Group
NielsenIQ
Nippon Shokken U.S.A Inc.
North American Commercial Business
North American Dixie Business
North American Retail Business
Northeast Food Marketing
Numerator

O

Ocean Strategies, Inc.
Officine Mario Dorin
Oliver Wyman Group
OSMG Cincinnati, LLC.

P

Panasonic Corporation
Parasense, Inc.
Paul Piazza & Son, Inc.
pb2 architecture + engineering
Pensa Systems
Phillips Foods, Inc.
Phoenix Energy Technologies
Phononic, Inc.
PICO
PICS Inventory
Pilgrim Capital Partners, LLC
Pine Manor/Miller Poultry
Pinion Global
Planalytics, Inc.
Postelsia Holdings Ltd
Potatoes USA
Precima
Primo Brands
The Procter & Gamble Distributing Company LLC
Procurant
Prodx
PromoWorks
Proviniti llc
Pure Flavor

Q

Quad
Quri, Inc.

R

R Squared Solutions; a division of Advantage Solutions
Rapid Recovery
Red Gold, Inc.
RefPlus, Inc.
Refresco
Refrigeration Solutions, Inc.
Reiter Dairy
Relex Solutions
Renaissance Capital Alliance, LLC
Respect Foods, Inc.
Retail Insight
Reynolds Consumer Products
RSi
RSM US LLP
Rudolph Foods Co.

S

S. C. Johnson & Son Argentina
S. C. Johnson & Son, Inc.
S. C. Johnson Commercial Markets, Inc.
Sanhua International, Inc.
Sargento Cheese Inc.
Schraad Sales & Marketing
Sealed Air Corporation
Seasons 4, Inc.
SellEthics Marketing Group, Inc.
Shipt, Inc.
Shuman Farms, Inc
Sifter Solutions
Simbe Robotics
Simek's
Simpactful LLC
Simplista
Singh360 Inc.
Smithfield Farmland Sales Corp.
Smithfield Foods Inc.
Soda Health
Solomon Partners
Source Refrigeration & HVAC, Inc.
Southeast Produce Council
Southern Glazer's Wine & Spirits
Spins LLC
Spoiler Alert
StarKist
STAT Recovery Services
Steakhouse Elite
the Stores Consulting Group
Stores Services Group LLC
Strategic Audit Solutions, Inc.
Styleline Glass Display Doors
Superfridge
SupplyPike, Inc.
Swiftly Systems Inc.
SymphonyAI
Synergy Systems Inc.

T

T.G. Lee Dairy
Tactiq
Taylor Farms
Taylor Farms (Mexico)
Taylor Farms Foodservice
TCC Retail Marketing Inc.
Tenth and Blake Beer Company
Teys USA Inc.
TGW Systems Inc.
The Advantage Group International, Inc.
The Allan Sullivan Company
The Best Dressed Chicken
The Food Law Firm
The Maker Group
The Wonderful Company
Think Blue Consulting LLC
ThinkLP
Threads Uniform Agency
Tom's of Maine, Inc.
Too Good To Go
Topline Farms
Trace Register Inc.
trakref®
Transnational Foods
Trax Retail
Trident Seafood Corporation
TRS-SESCO, LLC.
Truco Enterprises LP
Trustwell
TryAngle Food Brokers, Inc.
TSG Empire
Twinlode Automation

U

Uber Technologies, Inc.
United Against Poverty
United Egg Producers
Upshop
Upside Services, Inc.
Utz Quality Foods, LLC

V

Vector
Vestcom International, Inc.
Visscher Seafood Group
VusionGroup

W

Wasteless Inc.
Webstop
West Madison Foods
Where Food Comes From, Inc.
Wholechain
Willard Bishop, LLC, an Inmar Analytics Company
WIS International
Wisner Marketing Group, Inc.
Wynshop

Y

Yerecic Label

Z

Zatarain's, Inc.
Zero Zone, Inc.

Total Time

Count

Avg Time

Query

0.017

1 call
482 rows

0.017

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`.`numDistr...8239498617, 1942398959629387, 24727964969075186, 30954357583249646, 56229630234853408, 34737330417828005, 25877147893629655, 5299800664703052, 43492651315494917, 19329805258326193, 497945623396397, 34967012383916120, 2513238767961361, 37698693188550661, 36440761692061702, 55905905664851974, 52529627578499073, 19898476108186045, 49938254765490177, 30510172065497133, 48193828117628, 33491351815323714, 53586863843180549, 1338281744664875, 13259483165753354, 48193828137581, 12338388774420541, 48193828132778, 1006637254968090, 7533312507642203, 37030288903110843, 11631153689657352, 36485747179594, 48193828041120, 26716560596926921, 48193828168626, 29168849483989679, 50773750458613790, 32244905061384197, 42398289353506818, 48193828089272, 12584322896756763, 44210585163792389, 350705554554900, 247110943375361, 31843089396007122, 36644660969472, 48193828116662, 25533653589164697, 1850439414841446, 9016128491749984, 19918967397154824, 2237823990106114, 32170091026055180, 48193828137648, 1221269655650309, 26684266737827931, 20814618402226228, 1213457110139030, 48193828102677, 48193828173712, 31898988395364375, 6135665725014066, 6839357461758145, 3374353941004984, 48193828126031, 19313703425933361, 30102931856424972, 52709260290686977, 31274938237190161, 29949068948014049, 31223956975386648, 1689738918494615, 48193828126386, 48193828173822, 504645772378185, 48193828141183, 48193828090342, 48193828116853, 404478545100818, 48193828175248, 48193828091242, 48193828065333, 48193828101465, 48193828089129, 48193828039978, 48193828087692, 48193828132401, 48193828141943, 48193828068788, 1996438238134291, 9266396236087321, 32167836168224792, 19038632245464243, 22713973199601713, 42128247579738119, 48193828085738, 1443177730934316, 48193828144873, 24637040511418567, 25985978069942357, 2379510666232342, 29399411918372882, 30444154123191057, 26072152293770128, 504697311985704, 2074683952333797, 1850426529939601, 1859819623416431, 1859712249234065, 21161699004383324, 12323274784505881, 1732289159496124, 23531790807335365, 10229753105613620, 31897931833409647, 21894884281548824, 839305329115152, 48193828089518, 19532102512935291, 48193828107007, 545705659727916, 309302069821452, 32167836168224770, 32781050123911267, 238993455185922, 1302040810618962, 520979533004802, 520975238037544, 48193828178903, 31268242383175723, 25996019703480352, 31107589131469433, 48193828178153, 48193828116604, 1200847086158543, 48193828172848, 48193828170058, 1153641100610648, 494123102502915, 48193828174006, 48193828169991, 930959931211902, 22115456622002887, 48193828108501, 2240839057145929, 196430329282596, 12451913349988364, 1562393138169783, 26425048281645137, 18465026478178403, 48193828158243, 24883365475778564, 930968521146399, 48193828174656, 550451598590010, 21137930655367191, 2513453516325017, 29949056063111619, 19377062783483987, 4377318998933880, 48193828178870, 48193828178877, 48193828178863, 24194684649734982, 32698951824048137, 12937876014629562, 48193828050094, 2513453516324875, 17878552988876802, 32967116697108561, 1551380842022110, 19530715238498903, 9313323048763396, 48193828049266, 5823971358408736, 25959649920418040, 19974277985992711, 48193828169314, 8594126480081276, 48193828039880, 17987593618587653, 1258086115313481, 48193828078226, 48193828105659, 48193828092607, 1359348559250531, 48193828039901, 48193828039942, 352505145851904, 963739121614854, 19742835083313177, 5550154308386821, 10102398735351865, 12732945945068085, 44208085492826118, 48193828118436, 123892626620441, 21415763499810847, 1222476541464962, 44147646713036806, 25796716041077333, 48193828089505, 35051588879908871, 48193828137026, 990591257149450, 48193828124230, 48193828109981, 404474250133534, 48193828175906, 48193828175918, 48193828175912, 48193828169418, 48193828169412) AND IFNULL(`Company`.`silent`, "2")!=\'1\') AND `Company`.`companyStatusId`=0x1) AND `Company`.`CompanyId`=`Website`.`CompanyId`) AND IFNULL(`Website`.`address`, "")!=\'\') ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.005

1 call
354 rows

0.005

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND (`Membership`.`MembershipTypeId` IN (10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 1) AND `Membership`.`status`=1)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.005

1 call
1 row

0.005

SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Company, Website) WHERE `Website`.`CompanyId`=`Company`.`CompanyId` AND `Company`.`CompanyId`=0x2BD500012DAC

0.004

1 call
2 rows

0.004

1 call
1 row

0.004

1 call
163 rows

0.004

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (19919349649244311, 245242632601614, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828176126, 79555679223869, 8851828812808688, 48193828144644, 34857658221592682, 30753756840722523, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 48193828146886, 36519509917433862, 38152417828667406, 1298282714234933, 30629649465737354, 31091959745479408, 3434208605241371, 1252180535284400, 895328882524194, 36430647044079617, 19439588917380619, 1816543532941880, 14298504474132520, 9254580781056506, 30133065346973697, 48193828140612, 1918733689816147, 48193828142940, 36946777559007238, 30636860715827315, 46325598859034629, 1984773106958416, 330965884862469, 25808595920619027, 32594399...545282072780, 18112353828601932, 24500164198663339, 32457037791100932, 676757996830731, 51281613161496581, 52919206882050052, 37185826848768049, 26410681616039945, 35725537968129, 31948878735474750, 4611347471925841, 236416474808341, 36554771598934041, 51659961125568517, 24537955615899649, 29270335266226192, 36070419547029531, 1788888238522422, 34226633036529710, 828310212837378, 48193828069290, 48193828069830, 36864820993064962, 30534717803593767, 48193828102569, 29676222560600260, 52184385222344708, 49486260997193730, 51624050904006663, 48193828107479, 42393066673274885, 106923210833949, 991372941197384, 35403415420929, 2083441390649367, 36643222155427915, 290241004961796, 48146901215739905, 43241730736914, 33678032568844489, 2388800680493130, 13674544510271835, 35493609734158, 8578565813567858, 27561724261433349, 1029495070916815, 27197502444798162, 39247582949539852, 17465012062781767, 26059808557760540, 9310827672764419, 2209515860656133, 48193828126529, 48193828134687, 9280221735813777, 693229196410987, 48193828114532, 37823045376671751, 188467459915805, 48193828118745, 55387670615949317, 48193828136874, 279808529399812, 1073797658575013, 8443978718380143, 48193828067205, 34716220653594, 24416987862009354, 31580550930104487, 100248831655972, 1327948053349495, 30257413240127697, 1604303429044977, 30526020494820025, 33191155076169741, 13051301805949782, 24101389370130561, 52182671530393604, 20985145783746780, 12328381500620971, 48193828109268, 20256702150476236, 177201760698408, 953164912132131, 34763465293827, 2173257746744348, 53343721449586689, 5148484671897731, 26218554843988163, 37095632535553, 53239126111027205, 19477706752131157, 43237435769834, 986249045213280, 27786428360425547, 2146371251470427, 36618135251451916, 48193828145838, 32905574110724097, 48193828136340, 48193828044264, 52818116236804097, 48193828118515, 21734183785201766, 22623688692072483, 37309925633818630, 29540355565158645, 19982889395421300, 35515084570628, 37482789477548039, 227951094267906, 24122765422362672, 25639885310263699, 48193828085199, 12224310148071565, 7684963507897137, 30389268736115441, 109474421407761, 13354028280841235, 30040221038937604, 905318976454657, 678394379370591, 34313709203488776, 48193828131395, 25006755591225351, 326353089986574, 35205846925312, 25202064934044054, 26168411100807461, 41305263126347781, 28287049748447241, 26116317442474599, 535024076062826, 6385650001510582, 48193828034135, 19471195581710446, 44958532243554310, 1040107935105372, 18111748238213292, 23316179154108434, 2469296957555049, 30374313659990327, 37306085933056, 12329992113356956, 48193828113885, 48193828058562, 48193828105499, 48193828156908, 196486163857424, 19599791197520009, 33825354242064388, 24964128040813598, 25809437734208084, 1602800190489369, 32769131589664794, 26047752584561380, 2214287569324644, 48193828114522, 32064799902793729, 3326095688467149, 20191040690454691, 34905027415900176, 17037890450096234, 18362179191309061, 38395268164485132, 1845903929376935, 36542213114560514, 26388558239498617, 1942398959629387, 24727964969075186, 30954357583249646, 56229630234853408, 34737330417828005, 25877147893629655, 5299800664703052, 43492651315494917, 19329805258326193, 497945623396397, 34967012383916120, 2513238767961361, 37698693188550661, 36440761692061702, 55905905664851974, 52529627578499073, 19898476108186045, 49938254765490177, 30510172065497133, 48193828117628, 33491351815323714, 53586863843180549, 1338281744664875, 13259483165753354, 48193828137581, 12338388774420541, 48193828132778, 1006637254968090, 7533312507642203, 37030288903110843, 11631153689657352, 36485747179594, 48193828041120, 26716560596926921, 48193828168626, 29168849483989679, 50773750458613790, 32244905061384197, 42398289353506818, 48193828089272, 12584322896756763, 44210585163792389, 350705554554900, 247110943375361, 31843089396007122, 36644660969472, 48193828116662)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.004

1 call
1 row

0.004

1 call
170 rows

0.004

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (19919349649244311, 245242632601614, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828176126, 79555679223869, 8851828812808688, 48193828144644, 34857658221592682, 30753756840722523, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 48193828146886, 36519509917433862, 38152417828667406, 1298282714234933, 30629649465737354, 31091959745479408, 3434208605241371, 1252180535284400, 895328882524194, 36430647044079617, 19439588917380619, 1816543532941880, 14298504474132520, 9254580781056506, 30133065346973697, 48193828140612, 1918733689816147, 48193828142940, 36946777559007238, 30636860715827315, 46325598859034629, 1984773106958416, 330965884862469, 25808595920619027, 32594399...752584561380, 2214287569324644, 48193828114522, 32064799902793729, 3326095688467149, 20191040690454691, 34905027415900176, 17037890450096234, 18362179191309061, 38395268164485132, 1845903929376935, 36542213114560514, 26388558239498617, 1942398959629387, 24727964969075186, 30954357583249646, 56229630234853408, 34737330417828005, 25877147893629655, 5299800664703052, 43492651315494917, 19329805258326193, 497945623396397, 34967012383916120, 2513238767961361, 37698693188550661, 36440761692061702, 55905905664851974, 52529627578499073, 19898476108186045, 49938254765490177, 30510172065497133, 48193828117628, 33491351815323714, 53586863843180549, 1338281744664875, 13259483165753354, 48193828137581, 12338388774420541, 48193828132778, 1006637254968090, 7533312507642203, 37030288903110843, 11631153689657352, 36485747179594, 48193828041120, 26716560596926921, 48193828168626, 29168849483989679, 50773750458613790, 32244905061384197, 42398289353506818, 48193828089272, 12584322896756763, 44210585163792389, 350705554554900, 247110943375361, 31843089396007122, 36644660969472, 48193828116662, 25533653589164697, 1850439414841446, 9016128491749984, 19918967397154824, 2237823990106114, 32170091026055180, 48193828137648, 1221269655650309, 26684266737827931, 20814618402226228, 1213457110139030, 48193828102677, 48193828173712, 31898988395364375, 6135665725014066, 6839357461758145, 3374353941004984, 48193828126031, 19313703425933361, 30102931856424972, 52709260290686977, 31274938237190161, 29949068948014049, 31223956975386648, 1689738918494615, 48193828126386, 48193828173822, 504645772378185, 48193828141183, 48193828090342, 48193828116853, 404478545100818, 48193828175248, 48193828091242, 48193828065333, 48193828101465, 48193828089129, 48193828039978, 48193828087692, 48193828132401, 48193828141943, 48193828068788, 1996438238134291, 9266396236087321, 32167836168224792, 19038632245464243, 22713973199601713, 42128247579738119, 48193828085738, 1443177730934316, 48193828144873, 24637040511418567, 25985978069942357, 2379510666232342, 29399411918372882, 30444154123191057, 26072152293770128, 504697311985704, 2074683952333797, 1850426529939601, 1859819623416431, 1859712249234065, 21161699004383324, 12323274784505881, 1732289159496124, 23531790807335365, 10229753105613620, 31897931833409647, 21894884281548824, 839305329115152, 48193828089518, 19532102512935291, 48193828107007, 545705659727916, 309302069821452, 32167836168224770, 32781050123911267, 238993455185922, 1302040810618962, 520979533004802, 520975238037544, 48193828178903, 31268242383175723, 25996019703480352, 31107589131469433, 48193828178153, 48193828116604, 1200847086158543, 48193828172848, 48193828170058, 1153641100610648, 494123102502915, 48193828174006, 48193828169991, 930959931211902, 22115456622002887, 48193828108501, 2240839057145929, 196430329282596, 12451913349988364, 1562393138169783, 26425048281645137, 18465026478178403, 48193828158243, 24883365475778564, 930968521146399, 48193828174656, 550451598590010, 21137930655367191, 2513453516325017, 29949056063111619, 19377062783483987, 4377318998933880, 48193828178870, 48193828178877, 48193828178863, 24194684649734982, 32698951824048137, 12937876014629562, 48193828050094, 2513453516324875, 17878552988876802, 32967116697108561, 1551380842022110, 19530715238498903, 9313323048763396, 48193828049266, 5823971358408736, 25959649920418040, 19974277985992711, 48193828169314, 8594126480081276, 48193828039880, 17987593618587653, 1258086115313481, 48193828078226, 48193828105659, 48193828092607, 1359348559250531, 48193828039901, 48193828039942, 352505145851904, 963739121614854, 19742835083313177, 5550154308386821, 10102398735351865, 12732945945068085, 44208085492826118, 48193828118436, 123892626620441, 21415763499810847, 1222476541464962, 44147646713036806, 25796716041077333, 48193828089505, 35051588879908871, 48193828137026, 990591257149450, 48193828124230)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.004

1 call
170 rows

0.004

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (19919349649244311, 245242632601614, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828176126, 79555679223869, 8851828812808688, 48193828144644, 34857658221592682, 30753756840722523, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 48193828146886, 36519509917433862, 38152417828667406, 1298282714234933, 30629649465737354, 31091959745479408, 3434208605241371, 1252180535284400, 895328882524194, 36430647044079617, 19439588917380619, 1816543532941880, 14298504474132520, 9254580781056506, 30133065346973697, 48193828140612, 1918733689816147, 48193828142940, 36946777559007238, 30636860715827315, 46325598859034629, 1984773106958416, 330965884862469, 25808595920619027, 32594399...15900176, 17037890450096234, 18362179191309061, 38395268164485132, 1845903929376935, 36542213114560514, 26388558239498617, 1942398959629387, 24727964969075186, 30954357583249646, 56229630234853408, 34737330417828005, 25877147893629655, 5299800664703052, 43492651315494917, 19329805258326193, 497945623396397, 34967012383916120, 2513238767961361, 37698693188550661, 36440761692061702, 55905905664851974, 52529627578499073, 19898476108186045, 49938254765490177, 30510172065497133, 48193828117628, 33491351815323714, 53586863843180549, 1338281744664875, 13259483165753354, 48193828137581, 12338388774420541, 48193828132778, 1006637254968090, 7533312507642203, 37030288903110843, 11631153689657352, 36485747179594, 48193828041120, 26716560596926921, 48193828168626, 29168849483989679, 50773750458613790, 32244905061384197, 42398289353506818, 48193828089272, 12584322896756763, 44210585163792389, 350705554554900, 247110943375361, 31843089396007122, 36644660969472, 48193828116662, 25533653589164697, 1850439414841446, 9016128491749984, 19918967397154824, 2237823990106114, 32170091026055180, 48193828137648, 1221269655650309, 26684266737827931, 20814618402226228, 1213457110139030, 48193828102677, 48193828173712, 31898988395364375, 6135665725014066, 6839357461758145, 3374353941004984, 48193828126031, 19313703425933361, 30102931856424972, 52709260290686977, 31274938237190161, 29949068948014049, 31223956975386648, 1689738918494615, 48193828126386, 48193828173822, 504645772378185, 48193828141183, 48193828090342, 48193828116853, 404478545100818, 48193828175248, 48193828091242, 48193828065333, 48193828101465, 48193828089129, 48193828039978, 48193828087692, 48193828132401, 48193828141943, 48193828068788, 1996438238134291, 9266396236087321, 32167836168224792, 19038632245464243, 22713973199601713, 42128247579738119, 48193828085738, 1443177730934316, 48193828144873, 24637040511418567, 25985978069942357, 2379510666232342, 29399411918372882, 30444154123191057, 26072152293770128, 504697311985704, 2074683952333797, 1850426529939601, 1859819623416431, 1859712249234065, 21161699004383324, 12323274784505881, 1732289159496124, 23531790807335365, 10229753105613620, 31897931833409647, 21894884281548824, 839305329115152, 48193828089518, 19532102512935291, 48193828107007, 545705659727916, 309302069821452, 32167836168224770, 32781050123911267, 238993455185922, 1302040810618962, 520979533004802, 520975238037544, 48193828178903, 31268242383175723, 25996019703480352, 31107589131469433, 48193828178153, 48193828116604, 1200847086158543, 48193828172848, 48193828170058, 1153641100610648, 494123102502915, 48193828174006, 48193828169991, 930959931211902, 22115456622002887, 48193828108501, 2240839057145929, 196430329282596, 12451913349988364, 1562393138169783, 26425048281645137, 18465026478178403, 48193828158243, 24883365475778564, 930968521146399, 48193828174656, 550451598590010, 21137930655367191, 2513453516325017, 29949056063111619, 19377062783483987, 4377318998933880, 48193828178870, 48193828178877, 48193828178863, 24194684649734982, 32698951824048137, 12937876014629562, 48193828050094, 2513453516324875, 17878552988876802, 32967116697108561, 1551380842022110, 19530715238498903, 9313323048763396, 48193828049266, 5823971358408736, 25959649920418040, 19974277985992711, 48193828169314, 8594126480081276, 48193828039880, 17987593618587653, 1258086115313481, 48193828078226, 48193828105659, 48193828092607, 1359348559250531, 48193828039901, 48193828039942, 352505145851904, 963739121614854, 19742835083313177, 5550154308386821, 10102398735351865, 12732945945068085, 44208085492826118, 48193828118436, 123892626620441, 21415763499810847, 1222476541464962, 44147646713036806, 25796716041077333, 48193828089505, 35051588879908871, 48193828137026, 990591257149450, 48193828124230, 48193828109981, 404474250133534, 48193828175906, 48193828175918, 48193828175912, 48193828169418, 48193828169412)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.003

1 call
0 rows

0.003

COMMIT

0.003

1 call
1 row

0.003

1 call
2 rows

0.003

1 call
1 row

0.003

1 call
2 rows

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
2 rows

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
2 rows

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
1 row

0.003

1 call
2 rows

0.003

1 call
2 rows

0.003

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
3 rows

0.002

1 call
3 rows

0.002

1 call
1 row

0.002

1 call
2 rows

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
2 rows

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
2 rows

0.002

1 call
3 rows

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
2 rows

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
2 rows

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
3 rows

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

1 call
1 row

0.002

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

1 call
1 row

0.001

3 calls
1 row

0.000

SELECT version from databasemap;

0.001

1 call
1 row

0.001

1 call
173 rows

0.001

SELECT * FROM webselect

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
4 rows

0.000

1 call
2 rows

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
5 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-07 18:39:05',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFA08400000000, `path`='forms/MemberDirectory/viewMemberDirectory', `formName`='fmiam_MemberDirectory', `site`='www', `clientAcronym`='FMI', `pid`='2339888', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1356805', `startTime`='2025-09-07 18:39:05', `sessionId`=0x65C0741BCF09AEDC, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'reportType\\':\\'associationcouncil\\'}', `clientIPAddr`='216.73.216.129'

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
3 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
2 rows

0.000

1 call
2 rows

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

START TRANSACTION

940593 function calls (927118 primitive calls) in 1.212 seconds Ordered by: cumulative time List reduced from 1943 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.212 1.212 /data/fmiam/current/libs/framework/WebManager.py:136(_newRequest) 1 0.000 0.000 0.955 0.955 /data/fmiam/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.911 0.911 /data/fmiam/current/libs/framework/BaseHandler.py:269(_safeCall) 1 0.000 0.000 0.911 0.911 /data/fmiam/current/generic/sites/www/forms/MemberDirectory.py:85(viewMemberDirectory) 1 0.001 0.001 0.911 0.911 /data/fmiam/current/generic/sites/www/forms/MemberDirectory.py:111(_listMemberDirectory) 1 0.000 0.000 0.470 0.470 /data/fmiam/current/libs/framework/MakoTemplate.py:48(__call__) 1 0.000 0.000 0.470 0.470 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:461(render) 1 0.000 0.000 0.469 0.469 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:860(_render) 1 0.000 0.000 0.469 0.469 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:912(_render_context) 1 0.000 0.000 0.469 0.469 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:927(_exec_template) 1 0.008 0.008 0.469 0.469 /tmp/mako_modules_1011/fmiam/www/25.1.1/data/fmiam/current/fmiam_org/themes/www/mako/membership/viewMemberDirectory.html.py:18(render_body) 3860/3378 0.002 0.000 0.458 0.000 /data/fmiam/current/generic/classes/Company.py:365(__getattr__) 6849/3382 0.010 0.000 0.456 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 482 0.001 0.000 0.451 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 482 0.003 0.000 0.449 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2855(_loadListAssoc) 482 0.004 0.000 0.440 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2901(_loadAssocListSQL) 508 0.002 0.000 0.395 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 508 0.002 0.000 0.392 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 489 0.005 0.000 0.385 0.001 /data/fmiam/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 508 0.001 0.000 0.361 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 508 0.359 0.001 0.359 0.001 {function Connection.query at 0xecafa2b2a980} 1 0.000 0.000 0.340 0.340 /data/fmiam/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.340 0.340 /data/fmiam/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 0.247 0.247 /data/fmiam/current/libs/framework/WebManager.py:90(createNewHandler) 1 0.000 0.000 0.247 0.247 /data/fmiam/current/libs/framework/WebSite.py:92(__init__) 1 0.000 0.000 0.218 0.218 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:714(process) 316/140 0.004 0.000 0.179 0.001 {built-in method builtins.exec} 186/118 0.001 0.000 0.178 0.002 :1165(_find_and_load) 186/118 0.001 0.000 0.142 0.001 :1120(_find_and_load_unlocked) 188/119 0.001 0.000 0.134 0.001 :666(_load_unlocked) 187/120 0.000 0.000 0.130 0.001 :934(exec_module) 1 0.004 0.004 0.128 0.128 /data/fmiam/current/libs/framework/BaseHandler.py:464(_loadDisplayGroups) 1 0.000 0.000 0.121 0.121 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.121 0.121 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.120 0.120 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:243(getStubFromCache) 1 0.000 0.000 0.120 0.120 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.120 0.120 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 399/233 0.000 0.000 0.120 0.001 :233(_call_with_frames_removed) 1 0.000 0.000 0.119 0.119 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.118 0.118 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.118 0.118 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.004 0.004 0.118 0.118 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 1079 0.006 0.000 0.116 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:2950(_createObjectFromRow) 1 0.000 0.000 0.111 0.111 /data/fmiam/current/libs/framework/DisplayGroup.py:311(initialize) 1 0.000 0.000 0.103 0.103 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:402(_applyTitle) 5/1 0.000 0.000 0.096 0.096 /data/fmiam/current/libs/PLayer/PersistentBroker.py:770(processCriteria) 17208/16846 0.010 0.000 0.092 0.000 /data/fmiam/current/libs/framework/BaseHandler.py:1471(mxxImporter) 17230/16850 0.010 0.000 0.080 0.000 {built-in method builtins.__import__} 1 0.000 0.000 0.080 0.080 /data/fmiam/current/libs/utils/htmlTools.py:100(cleanHTML) 2645/1081 0.005 0.000 0.078 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:108(new_init) 2 0.001 0.000 0.078 0.039 /data/fmiam/current/libs/framework/BaseHandler.py:990(checkAndReloadOptionsFromXML) 8 0.005 0.001 0.076 0.010 /data/fmiam/current/libs/framework/BaseHandler.py:1163(loadSettingsFromFile) 4 0.000 0.000 0.074 0.019 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:374(getElm) 4 0.000 0.000 0.074 0.019 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 4 0.000 0.000 0.074 0.019 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 4 0.000 0.000 0.073 0.018 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 6 0.000 0.000 0.073 0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 6 0.001 0.000 0.073 0.012 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 45 0.000 0.000 0.072 0.002 /usr/lib/python3.11/re/__init__.py:225(compile) 46 0.001 0.000 0.072 0.002 /usr/lib/python3.11/re/__init__.py:272(_compile) 8 0.057 0.007 0.071 0.009 /data/fmiam/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 37 0.000 0.000 0.071 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 1081 0.010 0.000 0.062 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:348(__init__) 1 0.001 0.001 0.060 0.060 /data/fmiam/current/libs/PLayer/PersistentBroker.py:601(buildObjectsFromRS) 482 0.001 0.000 0.059 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:2908() 37 0.000 0.000 0.051 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 2871 0.003 0.000 0.051 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 2737 0.008 0.000 0.050 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 1 0.000 0.000 0.043 0.043 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 109 0.041 0.000 0.042 0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 1 0.000 0.000 0.040 0.040 /data/fmiam/current/libs/framework/WebManInterface.py:92(createBroker) 538/520 0.000 0.000 0.039 0.000 /data/fmiam/current/libs/PLayer/PersistentBroker.py:78(__new__) 1 0.000 0.000 0.038 0.038 /data/fmiam/current/fmiam_org/classes/fmiam_ScrapeAndDrape.py:27(_manipulateLogin) 2871 0.004 0.000 0.038 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 1 0.000 0.000 0.038 0.038 /data/fmiam/current/libs/framework/DGEEmail.py:1() 1 0.012 0.012 0.036 0.036 /data/fmiam/current/libs/PLayer/PersistentBroker.py:442(retrieveClassMaps) 190 0.000 0.000 0.036 0.000 :169(__enter__) 1 0.000 0.000 0.035 0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 1 0.000 0.000 0.035 0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.py:1() 10 0.000 0.000 0.035 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1767(find_all) 10 0.005 0.000 0.035 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:738(_find_all) 597 0.001 0.000 0.035 0.000 /data/fmiam/current/generic/classes/WebAddress.py:6(__init__) 216 0.001 0.000 0.035 0.000 :179(_get_module_lock) 1 0.000 0.000 0.035 0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/validate_email.py:1() 736/717 0.001 0.000 0.034 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 1 0.000 0.000 0.034 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/syntax.py:1() 190 0.000 0.000 0.034 0.000 :71(__init__) 382 0.034 0.000 0.034 0.000 {built-in method _thread.allocate_lock} 1 0.000 0.000 0.034 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/rfc_constants.py:1() 780/37 0.004 0.000 0.034 0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile) 368/326 0.000 0.000 0.033 0.000 :1207(_handle_fromlist) 2871 0.002 0.000 0.031 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 1 0.002 0.002 0.029 0.029 /data/fmiam/current/libs/framework/WebSite.py:420(outputDebugTable) 1 0.000 0.000 0.028 0.028 /data/fmiam/current/libs/framework/baseScrapeAndDrape.py:703(_drape) 487 0.001 0.000 0.027 0.000 /data/fmiam/current/libs/PLayer/SQLStatement.py:482(buildForCriteria) 1 0.000 0.000 0.027 0.027 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1494(__unicode__) 1 0.000 0.000 0.027 0.027 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:730(decode) 719/1 0.005 0.000 0.027 0.027 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1536(decode) 719/1 0.003 0.000 0.027 0.027 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1666(decode_contents) 487 0.005 0.000 0.027 0.000 /data/fmiam/current/libs/PLayer/SQLStatement.py:342(buildForObject)

A

B

C

D

E

F

G

H

I

J

K

L

M

N

O

P

Q

R

S

T

U

V

W

Y

Z

Mega Menu

Sign Up for the