Private Brands Washington Summit: Hotel & Logistics

FMI PRIVATE BRANDS WASHINGTON SUMMIT HOTEL

HOTEL INFORMATION

Hilton Alexandria Mark Center
5000 Seminary Road
Alexandria, VA 22311
Main Phone: (703) 845-1010

Check-in time: 3:00pm (local hotel time)
Check-out time: 12:00pm (local hotel time)

HOTEL RESERVATIONS

FMI Group Room Rate - $189.00 Single or Double (plus tax)

Reservation Cut-off Date = Monday, September 19, 2016.
Any reservations received after the cut-off date will be accepted on a space and rate available basis. The FMI discounted group rate is not guaranteed after the cut-off date.

Online Reservations:
1. Click on the hotel link Hilton Alexandria Mark Center
2. Enter desired Arrival and Departure dates
3. Click “Find” to check available rooms and complete a reservation

Call-in Reservations:
1. Call Hilton Alexandria Mark Center Reservations at 888-871-3451 and follow the phone prompts
2. Reference “Food Marketing Institute” or Group Code “IND” to reserve a room in the FMI block with the discounted group rate

RESERVATIONS CANCELLATIONS AND CHANGES

The hotel must receive notice of hotel cancellations no later than 24 hours prior to the date of arrival or guest will be billed for one night’s room rate plus all applicable taxes. All hotel changes, substitutions, and/or cancellations must be made directly with the hotel.

Total Time

Count

Avg Time

Query

0.178

1 call
0 rows

0.178

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

0.057

1 call
1 row

0.057

SELECT DISTINCT hex(`MicrositeTabComponent`.`MicrositeTabComponentId`) AS `MicrositeTabComponentId`, `MicrositeTabComponent`.`type`, `MicrositeTabComponent`.`text`, `MicrositeTabComponent`.`orderindex` FROM (MicrositeTab, MicrositeTabComponent) WHERE `MicrositeTabComponent`.`MicrositeTabId`=`MicrositeTab`.`MicrositeTabId` AND `MicrositeTab`.`MicrositeTabId`=0x2EDABE00000260 ORDER BY `MicrositeTabComponent`.`orderindex`

0.037

1 call
6 rows

0.037

SELECT DISTINCT hex(`MicrositeTab`.`MicrositeTabId`) AS `MicrositeTabId`, `MicrositeTab`.`title`, `MicrositeTab`.`orderindex`, `MicrositeTab`.`enabled`, `MicrositeTab`.`isInSite` FROM (Meeting, MicrositeTab) WHERE `MicrositeTab`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2EDABE00000250

0.028

1 call
1 row

0.028

SELECT DISTINCT hex(`Meeting`.`MeetingId`) AS `MeetingId`, `Meeting`.`name`, `Meeting`.`hostName`, `Meeting`.`description`, `Meeting`.`audienceDescription`, `Meeting`.`cosponsors`, `Meeting`.`includes`, `Meeting`.`attire`, `Meeting`.`cancellationPolicy`, `Meeting`.`thankYouText`, `Meeting`.`registrationStarts`, `Meeting`.`registrationEnds`, `Meeting`.`earlybirdCutoff`, `Meeting`.`onlineRegistrationsEnabled`, `Meeting`.`selectSessionsOnRegForm`, `Meeting`.`accountingCode`, `Meeting`.`maximumNumAttendees`, `Meeting`.`type`, `Meeting`.`showPublicSessionSearch`, `Meeting`.`allowSpouseReg`, `Meeting`.`continuingEdUnits`, `Meeting`.`mediaAllowed`, `Meeting`.`travelInfo`, `Meeting`.`hotelBlurb`, `Meeting`.`dateClosed`, `Meeting`.`showFeesOnPublicView`, `Meeting`.`eventId`, `Meeting`.`showPublicSchedule`, `Meeting`.`calendarLinkType`, `Meeting`.`calendarBlurb`, `Meeting`.`retainedEarningsAcctCode`, `Meeting`.`enableHousing`, `Meeting`.`staffNotificationEmail`, `Meeting`.`paymentInstructions`, `Meeting`.`staffCancellationEmail`, `Meeting`.`lowRoomTrigger`, `Meeting`.`continuingEdNumber`, `Meeting`.`enableRSVP`, `Meeting`.`micrositePath`, `Meeting`.`bgcolor`, `Meeting`.`accentColor`, `Meeting`.`tabTitleColor`, `Meeting`.`bodyTextColor`, `Meeting`.`linkTextColor`, `Meeting`.`rightNavTextColor`, `Meeting`.`fontTitleSize`, `Meeting`.`fontBodySize`, `Meeting`.`fontName`, `Meeting`.`navbarColor`, `Meeting`.`sidebarColor`, `Meeting`.`highlightedTabTextColor`, `Meeting`.`headlineColor`, `Meeting`.`highlightedTabColor`, `Meeting`.`inSiteAccentColor`, `Meeting`.`inSiteBodyTextColor`, `Meeting`.`inSiteHeadlineColor`, `Meeting`.`inSiteHighlightedTabColor`, `Meeting`.`inSiteHighlightedTabTextColor`, `Meeting`.`inSiteLinkTextColor`, `Meeting`.`inSiteNavbarColor`, `Meeting`.`inSiteRightNavTextColor`, `Meeting`.`inSiteSidebarColor`, `Meeting`.`inSiteTabTitleColor`, `Meeting`.`inSiteFontBodySize`, `Meeting`.`inSiteFontName`, `Meeting`.`inSiteFontTitleSize`, `Meeting`.`useBadges`, `Meeting`.`staffNotificationRevisitedEmail`, `Meeting`.`anticipatedRegistrations`, `Meeting`.`_budgetedRevenue`, `Meeting`.`groupRegistrationOn`, `Meeting`.`allowPlaceholders`, `Meeting`.`feesPageTopText`, `Meeting`.`badgesPageTopText`, `Meeting`.`questionsPageTopText`, `Meeting`.`eventsPageTopText`, `Meeting`.`reviewPageTopText`, `Meeting`.`paymentPageTopText`, `Meeting`.`micrositeTemplate`, `Meeting`.`inSiteTemplate`, `Meeting`.`isWebinar`, `Meeting`.`housingPageTopText`, `Meeting`.`attendeesPageTopText`, `Meeting`.`shortCalDescription`, `Meeting`.`allowAddToCalendar`, `Meeting`.`campaignCode`, `Meeting`.`recordOrigin`, `Meeting`.`additionalFeesPageTopText`, `Meeting`.`apptScheduler`, `Meeting`.`hasReferrals`, `Meeting`.`referralText`, `Meeting`.`wwwRegistrationsEditAlwaysApprove`, `Meeting`.`thankYouFullyPaidText`, `Meeting`.`venue`, `Meeting`.`sendToLMS`, `Meeting`.`showSponsorLogos`, `Meeting`.`confSponsorText`, `Meeting`.`isArchived` FROM (Meeting) WHERE `Meeting`.`micrositePath`='FMIPBMeeting_2015'

0.026

1 call
1056 rows

0.026

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 48193828148563, 17730380912132588, 48193828148644, 48193828148752, 12982827142...8677, 48193828039901, 21934621318972139, 820519142162437, 48193828178133, 46931979521753093, 26768972082839870, 48193828114824, 48193828181044, 232705623064577, 48193828172710, 48193828039942, 6494166645211253, 16714552427152370, 48193828180507, 48193828046827, 48193828168925, 48193828179567, 48193828181171, 48193828181114, 48193828175198, 48193828170847, 29932387295036192, 352505145851904, 2367686621267257, 963739121614854, 48193828181149, 11654509721813007, 22346650416578855, 19742835083313177, 5550154308386821, 10102398735351865, 11654595621158943, 12732945945068085, 31494307986813511, 31547625710813191, 11608003815931980, 395094041559119, 11608020995801612, 48193828176527, 13976446351442335, 1196749687360400, 11608347413315835, 10339992031200030, 43635312949198850, 48193828169740, 48193828169084, 48193828169747, 48193828174991, 14394827705681521, 48193828169091, 27829979328807200, 48193828169761, 12844271497379859, 48193828169098, 12844340216856577, 22748461786988584, 48193828169754, 520936583331890, 48193828082760, 169599668584518, 11651382985621637, 44208085492826118, 2125025264010334, 11608373183120110, 48193828168083, 2367463282967448, 16207935264786321, 11608437607628896, 1931670131311152, 48193828170195, 48193828118436, 48193828053809, 50381108843380737, 48193828169006, 337236537114633, 48193828175227, 48193828100436, 11608480557301859, 11608519212007472, 35013797462671527, 123892626620441, 21415763499810847, 1222476541464962, 48193828174977, 21934513944791811, 44147646713036806, 12101847745560744, 25796716041077333, 414739221970981, 26727018842292338, 48193828087893, 48193828089452, 48193828160827, 393655227514936, 328122616512512, 329187768401923, 235991273046034, 48193828142537, 48193828114343, 48193828086447, 48193828066930, 19726239329681866, 11608557866713256, 48193828168508, 33925160692088852, 2367441808130103, 21674981955994359, 29822182729187342, 11608557866713413, 48193828087091, 16714642621464593, 48193828111458, 16186481903141066, 11628761392874584, 48193828089505, 48193828179267, 48193828177112, 48193828181186, 11629053450649660, 2367334433948613, 9513468524757634, 55074666284318722, 48193828181193, 48193828100758, 25587125931999246, 48193828098193, 9282987694751952, 2420531898876098, 48193828066482, 48193828061562, 159162898055178, 991385826099214, 48193828107615, 159244502433792, 16511533618037046, 48193828169586, 48193828029378, 27577057294680072, 48193828041510, 21268609330317140, 11629019090912518, 35051588879908871, 11629143644962994, 11629019090912668, 11629251019145338, 530930972229716, 48193828067640, 13979998289396119, 233096465088530, 48193828029015, 16714642621464778, 48193828029025, 2366522685128791, 48193828137026, 13980217332727991, 48193828081570, 32620237958414344, 16497416060534815, 990591257149450, 11629401343000624, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070, 48193828094345, 48193828109981, 1257046733226076, 48193828056206, 1176915528385066, 48193828174253, 48193828152434, 48193828030938, 48193828175548, 404474250133534, 48193828176366, 48193828180258, 48193828175906, 48193828174963, 48193828179532, 26075888915316967, 14937810356142734, 48193828175541, 335930867056662, 48193828179965, 6575393066713768, 48193828171416, 27616004058122552, 48193828169035, 48193828179733, 48193828175918, 48193828041953, 25847040172884507, 48193828175912, 1181562682999371, 48193828169418, 945726028775460, 1359095156179060, 653852936241226, 48193828180955, 48193828180709, 48193828174267, 48193828174274, 48193828181135, 48193828167784, 48193828169412, 28810666391371790, 48193828179985, 295815872512008, 1257076797997057, 48193828180751, 48193828139453, 21418026947576481, 48193828169566, 48193828169463, 21418048422412672, 21418014062674292, 21418026947576467, 48193828170960, 21418018357642330, 21418048422412554, 48193828170005, 48193828170578, 21418039832478106)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.025

1 call
997 rows

0.025

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 48193828148563, 17730380912132588, 48193828148644, 48193828148752, 12982827142...833, 2018711938532289, 25639885310263699, 48193828031956, 48193828114575, 48193828150198, 48193828150249, 48193828150261, 48193828085199, 48193828030128, 48193828150706, 48193828148359, 48193828169182, 2238249191866945, 48193828150986, 12224310148071565, 7684963507897137, 48193828153216, 48193828031909, 51599737094162, 48193828123819, 30389268736115441, 48193828146093, 21627011466264588, 9147876613554279, 109474421407761, 13354028280841235, 30040221038937604, 905318976454657, 48193828033854, 678394379370591, 34313709203488776, 48193828131395, 979480176754798, 48193828165752, 25006755591225351, 326353089986574, 35205846925312, 25202064934044054, 32389366286385159, 26168411100807461, 41305263126347781, 48193828122683, 48193828154699, 31232349341483315, 28287049748447241, 48193828036661, 47540404588904453, 26116317442474599, 22621545503392792, 499775279464571, 149413322293248, 96546569846812, 535024076062826, 6385650001510582, 48193828034135, 19471195581710446, 44958532243554310, 1040107935105372, 581250809069571, 48193828148840, 18111748238213292, 23316179154108434, 48193828159432, 48193828159465, 48193828159577, 48193828031484, 48193828112847, 48193828160240, 48193828161028, 2469296957555049, 30374313659990327, 37306085933056, 48193828138111, 48193828065993, 12329992113356956, 48193828113885, 48193828174888, 48193828180919, 48193828030496, 48193828166948, 48193828058562, 29588102716589010, 48193828105499, 48193828031179, 48193828156908, 48193828167047, 196486163857424, 19599791197520009, 33825354242064388, 24964128040813598, 25809437734208084, 1602800190489369, 32769131589664794, 26047752584561380, 2214287569324644, 48193828167195, 48193828114522, 48193828167304, 32064799902793729, 3326095688467149, 682749476208642, 48193828167352, 20191040690454691, 48193828029109, 34905027415900176, 55057185767613, 48193828147656, 48193828167390, 17037890450096234, 18362179191309061, 48193828135845, 38395268164485132, 1845903929376935, 36542213114560514, 48193828167527, 26388558239498617, 1942398959629387, 24727964969075186, 30954357583249646, 56229630234853408, 48193828167645, 34737330417828005, 25877147893629655, 5299800664703052, 48193828150461, 43492651315494917, 48193828142520, 2142054809340137, 19329805258326193, 497945623396397, 48193828167998, 48193828168001, 48193828030451, 48193828168035, 34967012383916120, 2513238767961361, 37698693188550661, 36440761692061702, 34673270980626, 55905905664851974, 48193828061517, 52529627578499073, 27359512906170458, 48193828046932, 19898476108186045, 49938254765490177, 37697898619600925, 30510172065497133, 48193828117628, 33491351815323714, 48193828168176, 53586863843180549, 48193828168209, 1338281744664875, 13259483165753354, 48193828137581, 12338388774420541, 1419332072507548, 26420607285461439, 48193828132778, 1006637254968090, 7533312507642203, 37030288903110843, 24515003310670200, 48193828035598, 38534446579712, 51425872523034627, 11631153689657352, 36485747179594, 48193828143774, 11791497703719022, 48193828041120, 26716560596926921, 30601281206747889, 8264552164622941, 48193828168620, 48193828168626, 48193828031364, 29168849483989679, 48193828168721, 26759883932041694, 48193828168743, 113060719099907, 48193828114313, 26173758335090698, 48193828168632, 48193828168635, 28008903371390978, 50773750458613790, 30677486811480090, 32244905061384197, 55485093359124485, 48193828028740, 48193828040756, 48193828167566, 48193828028816, 48193828028813, 42398289353506818, 48193828039007, 48193828089272, 48193828028880, 48193828028888, 48193828028935, 48193828059861, 48193828028939, 48193828028954, 12584322896756763, 44210585163792389, 350705554554900, 37242172524724231, 48193828029106, 48193828029117, 247110943375361, 34916434849038337, 35178217400696841, 31843089396007122, 48193828029217, 26786078937579533, 36644660969472, 48193828033206, 48193828032167, 48193828116662, 363891104153613, 48193828032234)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.023

1 call
1056 rows

0.023

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 48193828148563, 17730380912132588, 48193828148644, 48193828148752, 12982827142...9581, 48193828169663, 431094457434192, 48193828167127, 11852383160108192, 48193828174539, 48193828170987, 48193828169112, 48193828169175, 48193828180667, 48193828114377, 2367772520612339, 2367622196756881, 2367815470284875, 21934286311522621, 48193828167248, 48193828180999, 48193828092607, 2367755340743310, 48193828176737, 48193828176744, 48193828176751, 1073789068640293, 1359348559250531, 32429571475243022, 11654093109985289, 11654157534495182, 11654226253971512, 11654294973448260, 687723048337421, 48193828176599, 687710163435647, 48193828176606, 29210257263689844, 27724585126330911, 27723081887779584, 27723236506599430, 44973762197585921, 25849604268359851, 44974045665427457, 535127155277873, 16715089298063361, 535152925081607, 48193828169077, 16715089298063541, 16715011988653234, 535161515016213, 535152925081638, 535114270375999, 55057185767705, 13980127138414836, 2367686621267365, 11654325038219327, 11654436707368961, 2367755340742739, 156641752252510, 48193828181029, 48193828168677, 48193828039901, 21934621318972139, 820519142162437, 48193828178133, 46931979521753093, 26768972082839870, 48193828114824, 48193828181044, 232705623064577, 48193828172710, 48193828039942, 6494166645211253, 16714552427152370, 48193828180507, 48193828046827, 48193828168925, 48193828179567, 48193828181171, 48193828181114, 48193828175198, 48193828170847, 29932387295036192, 352505145851904, 2367686621267257, 963739121614854, 48193828181149, 11654509721813007, 22346650416578855, 19742835083313177, 5550154308386821, 10102398735351865, 11654595621158943, 12732945945068085, 31494307986813511, 31547625710813191, 11608003815931980, 395094041559119, 11608020995801612, 48193828176527, 13976446351442335, 1196749687360400, 11608347413315835, 10339992031200030, 43635312949198850, 48193828169740, 48193828169084, 48193828169747, 48193828174991, 14394827705681521, 48193828169091, 27829979328807200, 48193828169761, 12844271497379859, 48193828169098, 12844340216856577, 22748461786988584, 48193828169754, 520936583331890, 48193828082760, 169599668584518, 11651382985621637, 44208085492826118, 2125025264010334, 11608373183120110, 48193828168083, 2367463282967448, 16207935264786321, 11608437607628896, 1931670131311152, 48193828170195, 48193828118436, 48193828053809, 50381108843380737, 48193828169006, 337236537114633, 48193828175227, 48193828100436, 11608480557301859, 11608519212007472, 35013797462671527, 123892626620441, 21415763499810847, 1222476541464962, 48193828174977, 21934513944791811, 44147646713036806, 12101847745560744, 25796716041077333, 414739221970981, 26727018842292338, 48193828087893, 48193828089452, 48193828160827, 393655227514936, 328122616512512, 329187768401923, 235991273046034, 48193828142537, 48193828114343, 48193828086447, 48193828066930, 19726239329681866, 11608557866713256, 48193828168508, 33925160692088852, 2367441808130103, 21674981955994359, 29822182729187342, 11608557866713413, 48193828087091, 16714642621464593, 48193828111458, 16186481903141066, 11628761392874584, 48193828089505, 48193828179267, 48193828177112, 48193828181186, 11629053450649660, 2367334433948613, 9513468524757634, 55074666284318722, 48193828181193, 48193828100758, 25587125931999246, 48193828098193, 9282987694751952, 2420531898876098, 48193828066482, 48193828061562, 159162898055178, 991385826099214, 48193828107615, 159244502433792, 16511533618037046, 48193828169586, 48193828029378, 27577057294680072, 48193828041510, 21268609330317140, 11629019090912518, 35051588879908871, 11629143644962994, 11629019090912668, 11629251019145338, 530930972229716, 48193828067640, 13979998289396119, 233096465088530, 48193828029015, 16714642621464778, 48193828029025, 2366522685128791, 48193828137026, 13980217332727991, 48193828081570, 32620237958414344, 16497416060534815, 990591257149450, 11629401343000624, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070)) AND `Relationship`.`relationType` IN (1, 2, 100, 101)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.019

1 call
6 rows

0.019

0.016

1 call
1 row

0.016

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

0.015

1 call
700 rows

0.015

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND `Membership`.`status`=1) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.014

1 call
25 rows

0.014

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company, Membership) WHERE (`Company`.`MembershipId`=`Membership`.`MembershipId` AND (((((`Company`.`companyStatusId`=0x1 AND (`Company`.`alphaSort` LIKE 'H%' AND `Company`.`CompanyId` IN (48193828062135, 19919349649244311, 245242632601614, 54028309171798022, 48193828071038, 48193828134590, 120048630890497, 48193828058387, 36483101479665669, 46669114638504, 176553220636726, 21021167674458139, 21423949707477446, 48193828120721, 48193828176126, 79555679223869, 48193828151121, 48193828044148, 48193828035391, 569770361487421, 48193828042345, 48193828046527, 48193828154614, 8851828812808688, 48193828144644, 5899257840140381, 34857658221592682, 30753756840722523, 48193828117193, 10563626683334660, 48193828117367, 235123689652241, 1804942826274912, 48193828138036, 35064113004585, 48193828146886, 36519509917433862, 992562647138405, 48193828158615, 48193828029632, 306926952906752, 38152417828667406, 48193828148383, 4819382814856...7, 48193828172710, 48193828039942, 6494166645211253, 16714552427152370, 48193828180507, 48193828046827, 48193828168925, 48193828179567, 48193828181171, 48193828181114, 48193828175198, 48193828170847, 29932387295036192, 352505145851904, 2367686621267257, 963739121614854, 48193828181149, 11654509721813007, 22346650416578855, 19742835083313177, 5550154308386821, 10102398735351865, 11654595621158943, 12732945945068085, 31494307986813511, 31547625710813191, 11608003815931980, 395094041559119, 11608020995801612, 48193828176527, 13976446351442335, 1196749687360400, 11608347413315835, 10339992031200030, 43635312949198850, 48193828169740, 48193828169084, 48193828169747, 48193828174991, 14394827705681521, 48193828169091, 27829979328807200, 48193828169761, 12844271497379859, 48193828169098, 12844340216856577, 22748461786988584, 48193828169754, 520936583331890, 48193828082760, 169599668584518, 11651382985621637, 44208085492826118, 2125025264010334, 11608373183120110, 48193828168083, 2367463282967448, 16207935264786321, 11608437607628896, 1931670131311152, 48193828170195, 48193828118436, 48193828053809, 50381108843380737, 48193828169006, 337236537114633, 48193828175227, 48193828100436, 11608480557301859, 11608519212007472, 35013797462671527, 123892626620441, 21415763499810847, 1222476541464962, 48193828174977, 21934513944791811, 44147646713036806, 12101847745560744, 25796716041077333, 414739221970981, 26727018842292338, 48193828087893, 48193828089452, 48193828160827, 393655227514936, 328122616512512, 329187768401923, 235991273046034, 48193828142537, 48193828114343, 48193828086447, 48193828066930, 19726239329681866, 11608557866713256, 48193828168508, 33925160692088852, 2367441808130103, 21674981955994359, 29822182729187342, 11608557866713413, 48193828087091, 16714642621464593, 48193828111458, 16186481903141066, 11628761392874584, 48193828089505, 48193828179267, 48193828177112, 48193828181186, 11629053450649660, 2367334433948613, 9513468524757634, 55074666284318722, 48193828181193, 48193828100758, 25587125931999246, 48193828098193, 9282987694751952, 2420531898876098, 48193828066482, 48193828061562, 159162898055178, 991385826099214, 48193828107615, 159244502433792, 16511533618037046, 48193828169586, 48193828029378, 27577057294680072, 48193828041510, 21268609330317140, 11629019090912518, 35051588879908871, 11629143644962994, 11629019090912668, 11629251019145338, 530930972229716, 48193828067640, 13979998289396119, 233096465088530, 48193828029015, 16714642621464778, 48193828029025, 2366522685128791, 48193828137026, 13980217332727991, 48193828081570, 32620237958414344, 16497416060534815, 990591257149450, 11629401343000624, 48193828041329, 2366466850555276, 11629401343000700, 48193828124230, 21098648884478070, 48193828094345, 48193828109981, 1257046733226076, 48193828056206, 1176915528385066, 48193828174253, 48193828152434, 48193828030938, 48193828175548, 404474250133534, 48193828176366, 48193828180258, 48193828175906, 48193828174963, 48193828179532, 26075888915316967, 14937810356142734, 48193828175541, 335930867056662, 48193828179965, 6575393066713768, 48193828171416, 27616004058122552, 48193828169035, 48193828179733, 48193828175918, 48193828041953, 25847040172884507, 48193828175912, 1181562682999371, 48193828169418, 945726028775460, 1359095156179060, 653852936241226, 48193828180955, 48193828180709, 48193828174267, 48193828174274, 48193828181135, 48193828167784, 48193828169412, 28810666391371790, 48193828179985, 295815872512008, 1257076797997057, 48193828180751, 48193828139453, 21418026947576481, 48193828169566, 48193828169463, 21418048422412672, 21418014062674292, 21418026947576467, 48193828170960, 21418018357642330, 21418048422412554, 48193828170005, 48193828170578, 21418039832478106))) AND IFNULL(`Company`.`silent`, 2)!='1') AND `Company`.`MembershipId`=`Membership`.`MembershipId`) AND `Membership`.`status`=1) AND `Membership`.`MembershipTypeId` IN (10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 1))) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.013

10 calls
1 row

0.001

SELECT version from databasemap;

0.010

2 calls
244 rows

0.005

SELECT * FROM Country ORDER BY orderindex, id

0.009

1 call
1 row

0.009

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

0.008

1 call
1 row

0.008

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

0.007

1 call
0 rows

0.007

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:42:55',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB10F00000012, `path`='forms/meeting/Microsite/FMIPBMeeting_2015,1', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2695638', `requestNum`='6', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1541201', `startTime`='2025-09-09 21:42:55', `sessionId`=0x1B602511B419073C, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.31'

0.007

1 call
1 row

0.007

SELECT DISTINCT `CalendarItem`.`type`, `CalendarItem`.`startDate`, `CalendarItem`.`endDate`, `CalendarItem`.`location`, hex(`CalendarItem`.`CalendarItemId`) AS `CalendarItemId`, `CalendarItem`.`name`, `CalendarItem`.`status`, `CalendarItem`.`contactName`, `CalendarItem`.`contactPhone`, `CalendarItem`.`contactEmail`, `CalendarItem`.`description`, `CalendarItem`.`URL`, `CalendarItem`.`URLDescription`, `CalendarItem`.`handOut`, `CalendarItem`.`handOutDescription`, `CalendarItem`.`minutesUpload`, `CalendarItem`.`minutes`, `CalendarItem`.`phone`, `CalendarItem`.`fax`, `CalendarItem`.`line1`, `CalendarItem`.`line2`, `CalendarItem`.`city`, `CalendarItem`.`province`, `CalendarItem`.`zip`, `CalendarItem`.`state`, `CalendarItem`.`country`, `CalendarItem`.`attendeeNames` FROM (CalendarItem, Meeting) WHERE `CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2EDABE00000250 ORDER BY `CalendarItem`.`startDate`

0.005

1 call
0 rows

0.005

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:42:55',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB10F00000004, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2695638', `requestNum`='5', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1541201', `startTime`='2025-09-09 21:42:48', `sessionId`=0x1B602511B419073C, `userId`=0x0, `userName`='public', `result`='302', `sqltime`='0.11862301826477051', `timeTaken`='3', `dictSize`='0', `fields`='{\\'Company_alphaSort\\':\\'H*\\', \\'action\\':\\'find\\', \\'submit\\':\\'Create PDF\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB10F00000004

0.005

1 call
0 rows

0.005

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

0.005

1 call
21 rows

0.005

SELECT * FROM MembershipType ORDER BY orderindex, id

0.004

1 call
1 row

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 (Address, Meeting) WHERE `Meeting`.`MeetingId`=0x1CF2A60000027B AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.004

1 call
1 row

0.004

1 call
0 rows

0.004

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:42:48',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB10F00000003, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2695638', `requestNum`='4', `objectId`='1CF2A60000027B', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1541201', `startTime`='2025-09-09 21:42:48', `sessionId`=0x1B602511B419073C, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.03317379951477051', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'1CF2A60000027B\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB10F00000003

0.003

1 call
8 rows

0.003

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (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, 2074683952333797, 545705659727916, 238993455185922, 1302040810618962, 12937876014629562, 17878552988876802, 48193828039901)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.003

3 calls
54 rows

0.001

SELECT * FROM StateProvince ORDER BY orderindex, id

0.003

1 call
0 rows

0.003

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:42:48',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB10F00000004, `path`='forms/CompanyFormPublic/search', `formName`='fmiam_CompanyFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2695638', `requestNum`='5', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1541201', `startTime`='2025-09-09 21:42:48', `sessionId`=0x1B602511B419073C, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'Company_alphaSort\\':\\'H*\\', \\'action\\':\\'find\\', \\'submit\\':\\'Create PDF\\'}', `clientIPAddr`='216.73.216.31'

0.003

1 call
1 row

0.003

0.002

1 call
4 rows

0.002

SELECT * FROM MinorityType ORDER BY orderindex, id

0.002

1 call
0 rows

0.002

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:42:48',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB10F00000002, `path`='forms/meeting/Microsite/2020powerseafood,0', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2695638', `requestNum`='3', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1541201', `startTime`='2025-09-09 21:42:47', `sessionId`=0x1B602511B419073C, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.20563077926635742', `timeTaken`='2', `dictSize`='0', `fields`='{}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB10F00000002

0.002

1 call
2 rows

0.002

SELECT DISTINCT hex(`Fee`.`FeeId`) AS `FeeId`, `Fee`.`expirationDate`, `Fee`.`amount`, hex(`Fee`.`itemId`) AS `itemId`, `Fee`.`name`, `Fee`.`description`, `Fee`.`minGroupSize`, `Fee`.`isEarlyDiscount`, `Fee`.`membersOnly`, `Fee`.`guestsOnly`, `Fee`.`availableToGuests`, `Fee`.`accountingCode`, `Fee`.`availableToSpouses`, `Fee`.`feeCode`, `Fee`.`published`, `Fee`.`rateCategory`, `Fee`.`showOnWWW`, `Fee`.`showMembershipTypesAsMembersOnWWW`, `Fee`.`membershipTypesLabelForWWW`, `Fee`.`groupSizeRule`, `Fee`.`specialDealType`, `Fee`.`recordOrigin`, `Fee`.`confirmationText` FROM (Fee, Meeting) WHERE `Fee`.`itemId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2EDABE00000250

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

0.002

1 call
7 rows

0.002

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (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)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`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 (Address, Individual) WHERE `Address`.`AddressId`=0x2EDABE00000254 AND `Address`.`IndividualId`=`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`=0x1CF2A600000289 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

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

0.001

1 call
1 row

0.001

SELECT DISTINCT hex(`MyMeeting`.`MyMeetingId`) AS `MyMeetingId`, `MyMeeting`.`published`, `MyMeeting`.`description`, `MyMeeting`.`mxxCreated`, hex(`MyMeeting`.`mxxCreatedBy`) AS `mxxCreatedBy`, `MyMeeting`.`mxxUpdated`, hex(`MyMeeting`.`mxxUpdatedBy`) AS `mxxUpdatedBy`, `MyMeeting`.`rule`, `MyMeeting`.`introText`, `MyMeeting`.`embedCode` FROM (Meeting, MyMeeting) WHERE `MyMeeting`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x2EDABE00000250

0.001

1 call
1 row

0.001

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

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

0.001

1 call
8 rows

0.001

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Relationship, Company) WHERE ((`Company`.`CompanyId`=`Relationship`.`childCompanyId` AND `Relationship`.`parentCompanyId` in (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, 2074683952333797, 545705659727916, 238993455185922, 1302040810618962, 12937876014629562, 17878552988876802, 48193828039901, 48193828109981)) AND `Relationship`.`relationType` IN (2)) ORDER BY `Company`.`alphaSort`, `Company`.`name`

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

0.001

1 call
33 rows

0.001

SELECT DISTINCT hex(`Company`.`CompanyId`) AS `CompanyId` FROM (Company) WHERE `Company`.`CompanyId` IN (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, 2074683952333797, 545705659727916, 238993455185922, 1302040810618962, 12937876014629562, 17878552988876802, 48193828039901, 48193828109981) ORDER BY `Company`.`alphaSort`, `Company`.`name`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:42:48',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB10F00000003, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2695638', `requestNum`='4', `pageDictSize`=NULL, `objectId`='1CF2A60000027B', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1541201', `startTime`='2025-09-09 21:42:48', `sessionId`=0x1B602511B419073C, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'1CF2A60000027B\\'}', `clientIPAddr`='216.73.216.31'

0.000

1 call
1 row

0.000

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

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(`Branch`.`BranchId`) AS `BranchId`, `Branch`.`name`, `Branch`.`isMain`, `Branch`.`mainPhone`, `Branch`.`secondaryPhone`, `Branch`.`tollFree`, `Branch`.`fax` FROM (Address, Branch) WHERE `Address`.`AddressId`=0xCFB10F0000000D 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`=0xCFB10F00000010 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

23362 function calls (23005 primitive calls) in 0.467 seconds Ordered by: cumulative time List reduced from 895 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.467 0.467 /data/fmiam/current/libs/framework/WebManager.py:136(_newRequest) 1 0.000 0.000 0.457 0.457 /data/fmiam/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.418 0.418 /data/fmiam/current/libs/framework/BaseHandler.py:269(_safeCall) 1 0.000 0.000 0.418 0.418 /data/fmiam/current/generic/sites/www/forms/meeting/Microsite.py:24(index) 31 0.000 0.000 0.412 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 31 0.000 0.000 0.412 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 31 0.000 0.000 0.410 0.013 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 31 0.410 0.013 0.410 0.013 {function Connection.query at 0xe3777a0b6de0} 15 0.000 0.000 0.361 0.024 /data/fmiam/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 12/10 0.000 0.000 0.335 0.033 /data/fmiam/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 103/31 0.000 0.000 0.332 0.011 /data/fmiam/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 4/3 0.000 0.000 0.308 0.103 /data/fmiam/current/libs/framework/MakoTemplate.py:48(__call__) 4 0.000 0.000 0.307 0.077 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:461(render) 4 0.000 0.000 0.307 0.077 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:860(_render) 4 0.000 0.000 0.307 0.077 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:912(_render_context) 4 0.000 0.000 0.307 0.077 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:927(_exec_template) 5 0.000 0.000 0.294 0.059 /data/fmiam/current/libs/PLayer/PersistentObject.py:2855(_loadListAssoc) 5 0.000 0.000 0.293 0.059 /data/fmiam/current/libs/PLayer/PersistentObject.py:2901(_loadAssocListSQL) 1 0.000 0.000 0.293 0.293 /tmp/mako_modules_1011/fmiam/www/25.1.1/data/fmiam/current/generic/themes/www/mako/meetings/microsite_index_responsive.html.py:31(render_body) 1 0.000 0.000 0.232 0.232 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:244(render_microsite_sidebar) 1 0.000 0.000 0.045 0.045 /data/fmiam/current/libs/framework/WebApp.py:298(writeHTMLWithMicrosite) 8 0.000 0.000 0.045 0.006 /data/fmiam/current/libs/framework/BaseHandler.py:312(getTemplate) 6 0.000 0.000 0.042 0.007 /data/fmiam/current/libs/framework/BaseHandler.py:596(getTemplateDefaults) 7/5 0.000 0.000 0.041 0.008 /data/fmiam/current/libs/PLayer/PersistentObject.py:2912(_loadAssoc) 7/5 0.000 0.000 0.041 0.008 /data/fmiam/current/libs/PLayer/PersistentObject.py:2978(_loadAssocSQL) 10 0.000 0.000 0.038 0.004 /data/fmiam/current/generic/classes/Meeting.py:3350(getTabs) 7 0.000 0.000 0.033 0.005 /data/fmiam/current/libs/framework/Auth.py:414(getValidSessionRecord) 1 0.000 0.000 0.030 0.030 /data/fmiam/current/generic/classes/Meeting.py:2163(getIsAcceptingOnlineRegistrations) 1 0.000 0.000 0.030 0.030 /data/fmiam/current/generic/classes/Meeting.py:2120(getNoOnlineRegistrationsReason) 6 0.000 0.000 0.029 0.005 /data/fmiam/current/libs/framework/WebSite.py:1076(getImpersonatingUser) 1 0.000 0.000 0.029 0.029 /data/fmiam/current/generic/classes/Meeting.py:3336(getMeetingByMicrositePath) 1 0.000 0.000 0.029 0.029 /data/fmiam/current/libs/PLayer/PersistentBroker.py:770(processCriteria) 2 0.000 0.000 0.026 0.013 /data/fmiam/current/generic/classes/Meeting.py:1976(getDateRegistrationStarts) 74 0.000 0.000 0.021 0.000 /data/fmiam/current/libs/framework/MaxxRequestWrapper.py:53(write) 74 0.000 0.000 0.021 0.000 /data/fmiam/current/libs/framework/wsgiapp.py:286(write) 1 0.000 0.000 0.021 0.021 /data/fmiam/current/libs/framework/WebSite.py:420(outputDebugTable) 73 0.000 0.000 0.019 0.000 /data/fmiam/current/libs/framework/WebSite.py:1285(debugHTML) 73 0.000 0.000 0.019 0.000 /data/fmiam/current/libs/framework/WebSite.py:925(writeHTML) 1 0.000 0.000 0.016 0.016 /tmp/mako_modules_1011/fmiam/www/25.1.1/helpers/meetingHelpers.html.py:57(render_addToCalendarWidget) 73 0.000 0.000 0.015 0.000 /data/fmiam/current/libs/framework/wsgiapp.py:272(getSetting) 1 0.000 0.000 0.014 0.014 /tmp/mako_modules_1011/fmiam/www/25.1.1/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header_responsive.html.py:28(render_body) 1 0.000 0.000 0.014 0.014 /data/fmiam/current/generic/classes/Meeting.py:3266(getGoogleLink) 1 0.000 0.000 0.014 0.014 /data/fmiam/current/libs/utils/calendarUtils.py:10(getGoogleLink) 7 0.000 0.000 0.014 0.002 /data/fmiam/current/libs/PLayer/PersistentBroker.py:336(processSql) 2 0.000 0.000 0.013 0.007 /data/fmiam/current/generic/classes/Meeting.py:3328(getLocation) 6 0.000 0.000 0.011 0.002 /data/fmiam/current/libs/framework/BaseHandler.py:590(getDevDataTime) 1 0.000 0.000 0.011 0.011 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:82(render_responsive_microsite_startOfContent) 1 0.000 0.000 0.010 0.010 /data/fmiam/current/generic/classes/Meeting.py:2839(getBannerWidth) 2 0.000 0.000 0.010 0.005 /data/fmiam/current/libs/framework/WebSite.py:698(_logPageRequest) 2 0.000 0.000 0.010 0.005 /data/fmiam/current/libs/PLayer/PersistentObject.py:679(saveWithoutABS) 73 0.009 0.000 0.009 0.000 /data/fmiam/current/libs/PLayer/PersistentBroker.py:147(getInstance) 1 0.000 0.000 0.009 0.009 /data/fmiam/current/libs/framework/WebForm.py:94(__init__) 16/15 0.000 0.000 0.009 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2950(_createObjectFromRow) 1 0.000 0.000 0.008 0.008 /data/fmiam/current/libs/framework/WebSite.py:559(logBeginRequest) 1 0.000 0.000 0.007 0.007 /data/fmiam/current/libs/framework/Auth.py:85(getUserAndSession) 1 0.000 0.000 0.007 0.007 /data/fmiam/current/generic/classes/Meeting.py:3520(shouldShowMeetingDocuments) 1 0.000 0.000 0.007 0.007 /data/fmiam/current/libs/framework/Auth.py:367(hasValidSession) 13 0.000 0.000 0.007 0.001 /data/fmiam/current/libs/PLayer/SQLStatement.py:482(buildForCriteria) 13 0.000 0.000 0.007 0.001 /data/fmiam/current/libs/PLayer/SQLStatement.py:342(buildForObject) 1 0.000 0.000 0.007 0.007 /data/fmiam/current/generic/sites/www/forms/meeting/Microsite.py:18(getFooter) 1 0.000 0.000 0.007 0.007 /data/fmiam/current/libs/framework/WebApp.py:638(getFooter) 36/17 0.000 0.000 0.006 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:108(new_init) 13 0.000 0.000 0.006 0.000 /data/fmiam/current/libs/PLayer/SQLStatement.py:772(__init__) 13 0.000 0.000 0.006 0.000 /data/fmiam/current/libs/PLayer/PersistentCriteria.py:135(getTables) 12 0.006 0.001 0.006 0.001 /data/fmiam/current/libs/PLayer/PersistentCriteria.py:1295(getTables) 161 0.005 0.000 0.006 0.000 /data/fmiam/current/libs/framework/BaseHandler.py:848(getSetting) 74 0.005 0.000 0.005 0.000 {uwsgi_write} 1 0.000 0.000 0.005 0.005 /data/fmiam/current/libs/framework/WebApp.py:183(writeHTML) 1 0.000 0.000 0.005 0.005 /data/fmiam/current/generic/classes/Address.py:87(__init__) 2 0.000 0.000 0.003 0.002 /data/fmiam/current/generic/classes/Address.py:297(getPrintPlain) 2 0.000 0.000 0.003 0.002 /data/fmiam/current/generic/classes/Address.py:340(generatePrettyHTML) 1 0.000 0.000 0.003 0.003 /data/fmiam/current/libs/framework/Auth.py:871(updateLastValidatedTimeInDB) 32 0.000 0.000 0.003 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DateTimeBackup.py:31(__init__) 1 0.000 0.000 0.003 0.003 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:406(render_responsive_footer) 1 0.000 0.000 0.003 0.003 /data/fmiam/current/generic/classes/Meeting.py:3279(getSingleLineAddress) 1 0.000 0.000 0.003 0.003 /data/fmiam/current/generic/classes/Address.py:323(getPrintPlainSingleLine) 74 0.002 0.000 0.003 0.000 /data/fmiam/current/libs/framework/MaxxRequestWrapper.py:19(send_http_header) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/libs/framework/BaseHandler.py:1215(WSKey2Value) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/libs/framework/WebManInterface.py:57(getWebSelectByName) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/libs/framework/WebManInterface.py:37(readWebSelect) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/libs/framework/WebSite.py:603(logEndRequest) 22 0.000 0.000 0.002 0.000 /data/fmiam/current/libs/framework/BaseHandler.py:370(_loadTemplate) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/libs/framework/WebApp.py:549(isProtected) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/libs/framework/Auth.py:523(checkAccess) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/libs/framework/Auth.py:552(getPermissions) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/libs/framework/Auth.py:638(getGroups) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/generic/sites/www/forms/meeting/Microsite.py:12(getHeader) 1 0.000 0.000 0.002 0.002 /data/fmiam/current/generic/classes/CalendarItem.py:59(processAfterRetrieve) 5 0.000 0.000 0.002 0.000 /data/fmiam/current/libs/utils/htmlTools.py:100(cleanHTML) 10 0.000 0.000 0.002 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/dateutil/parser/_parser.py:1270(parse) 10 0.000 0.000 0.002 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/dateutil/parser/_parser.py:572(parse) 3 0.000 0.000 0.002 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 4 0.000 0.000 0.001 0.000 /data/fmiam/current/libs/framework/MakoTemplate.py:37(__init__) 4 0.000 0.000 0.001 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:239(__init__) 21 0.000 0.000 0.001 0.000 /data/fmiam/current/libs/utils/dateutils.py:146(MakeDateTime) 10 0.000 0.000 0.001 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/dateutil/parser/_parser.py:666(_parse) 1 0.000 0.000 0.001 0.001 /data/fmiam/current/generic/classes/Meeting.py:3270(getYahooLink) 1 0.000 0.000 0.001 0.001 /data/fmiam/current/libs/utils/calendarUtils.py:13(getYahooLink) 17 0.000 0.000 0.001 0.000 /data/fmiam/current/libs/PLayer/PersistentObject.py:348(__init__) 4 0.000 0.000 0.001 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:403(_compile_from_file)