2013 Schedule

Saturday, November 16th
9:00 am – 7:00 pm	Registration - Walden Room
9:00 am – 7:00 pm	Chairman’s Club - Walden Room
10:00 am – 6:00 pm	BCS Appointments - Individual Hospitality Suites
11:30 am - 1:30 pm	Lunch in the Chairman's Club - Walden Room
6:00 pm - 7:00 pm	Private Brands Opening Networking Reception in the Chairman's Club - Walden Room
7:00 pm – 9:00 pm	Private Brands Opening Gathering - Dinner and Speaker Featuring Doug Rauch, former president of Trader Joe's Company Grand Ballroom, Salon A-D
Sunday, November 17th
6:00 am – 2:00 pm	Registration - Walden Room
6:00 am – 2:00 pm	Chairman’s Club - Walden Room
6:00 am - 8:00 am	Breakfast in the Chairman's Club - Walden Room
7:00 am – 2:00 pm	BCS Appointments - Individual Hospitality Suites
11:30 am - 1:30 pm	Lunch in the Chairman's Club - Walden Room

PARTICIPATING COMPANIES

Look at the participating Suppliers and Retailer/Wholesaler companies committed* to the 2013 Private Brands Business Conference.

PRIVATE BRANDS NETWORKING AND DINNER GATHERING*

Bring your team for an evening of networking and camaraderie to kick off your week of Private Brands in Chicago. Dinner speaker will be Doug Rauch, former president of Trader Joe’s Company.

Doug spent 31 years with Trader Joe's Company, the last 14 years as President, growing the business from a small, nine-store chain in Southern California, to a nationally acclaimed retail success story with more than 340 stores in 30 states. He developed their prized buying philosophy, created their unique private label food program, and wrote and executed the Business Plan for expanding Trader Joe’s nationally. Doug championed the development and execution of Trader Joe’s University, and their prized customer experience orientation.

*Reception, dinner and speaker are included in registration package for companies participating in the Private Brands Business Conference and registered participants.

For those individuals or companies NOT participating in the Private Brands Business Conference, we welcome you to attend the reception, dinner and speaker for a separate cost of $125 per person. Space is limited so please make your reservations now.

How to Register for the Private Brands Networking and Dinner Gathering ONLY:

Select "Register Now" in the upper right corner
Create New Registration
Under Attendee Line - Add Registration
Registration Fee - Select Private Brands Networking and Dinner ONLY
Proceed through the registration process and payments

**All individuals participating in the Private Brands Business Conference are required to register for the conference.

Total Time

Count

Avg Time

Query

0.195

1 call
0 rows

0.195

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

0.062

1 call
1 row

0.062

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

0.043

1 call
1 row

0.043

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`='PrivateBrands2013'

0.039

1 call
6 rows

0.039

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

0.035

1 call
6 rows

0.035

1 call
6 rows

0.035

0.028

12 calls
1 row

0.002

SELECT version from databasemap;

0.014

1 call
1 row

0.014

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

0.014

1 call
1 row

0.014

0.011

1 call
0 rows

0.011

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:36:41',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB0F300000002, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='3', `pageDictSize`=NULL, `objectId`='2ED98B000001AD', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:41', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'2ED98B000001AD\\'}', `clientIPAddr`='216.73.216.31'

0.011

1 call
173 rows

0.011

SELECT * FROM webselect

0.010

1 call
0 rows

0.010

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:36:40',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB0F300000000, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='1', `objectId`='4FD65D0000028D', `growth`='1024', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:40', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.03336453437805176', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'4FD65D0000028D\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB0F300000000

0.009

1 call
0 rows

0.009

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:36:41',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB0F300000002, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='3', `objectId`='2ED98B000001AD', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:41', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.07189822196960449', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'2ED98B000001AD\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB0F300000002

0.008

1 call
1 row

0.008

1 call
1 row

0.008

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

0.007

1 call
0 rows

0.007

UPDATE `PageRequest` SET `mxxUpdated`='2025-09-09 21:36:41',`mxxUpdatedBy`=NULL, `PageRequestId`=0xCFB0F300000001, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='2', `objectId`='7095890000006D', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:40', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.07212448120117188', `timeTaken`='1', `dictSize`='0', `fields`='{\\'id\\':\\'7095890000006D\\'}', `clientIPAddr`='216.73.216.31' WHERE `PageRequestId`=0xCFB0F300000001

0.007

1 call
0 rows

0.007

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

0.007

1 call
0 rows

0.007

START TRANSACTION

0.006

1 call
1 row

0.006

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

0.006

1 call
54 rows

0.006

select id, abbreviation from StateProvince

0.006

1 call
54 rows

0.006

SELECT * FROM StateProvince ORDER BY orderindex, id

0.006

1 call
1 row

0.006

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

0.005

1 call
1 row

0.005

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

0.005

1 call
1 row

0.005

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

0.005

1 call
1 row

0.005

1 call
0 rows

0.005

COMMIT

0.005

1 call
1 row

0.005

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

0.005

1 call
1 row

0.005

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

0.004

1 call
0 rows

0.004

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:36:41',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB0F300000003, `path`='forms/meeting/Microsite/PrivateBrands2013,5', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='4', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:41', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.31'

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

0.004

1 call
0 rows

0.004

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

0.004

1 call
0 rows

0.004

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

0.004

1 call
1 row

0.004

1 call
1 row

0.004

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

0.003

1 call
1 row

0.003

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

0.003

1 call
0 rows

0.003

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

0.002

1 call
0 rows

0.002

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

0.002

1 call
1 row

0.002

0.001

1 call
1 row

0.001

1 call
1 row

0.001

SELECT * FROM uuid FOR UPDATE

0.001

1 call
0 rows

0.001

INSERT INTO `PageRequest` SET `mxxCreated`='2025-09-09 21:36:40',`mxxCreatedBy`=NULL, `PageRequestId`=0xCFB0F300000001, `path`='forms/meeting/MeetingFormPublic/ical', `formName`='fmiam_MeetingFormPublic', `site`='www', `clientAcronym`='FMI', `pid`='2694863', `requestNum`='2', `pageDictSize`=NULL, `objectId`='7095890000006D', `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='1540889', `startTime`='2025-09-09 21:36:40', `sessionId`=0x41D55D131B1F0195, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{\\'id\\':\\'7095890000006D\\'}', `clientIPAddr`='216.73.216.31'

0.000

1 call
0 rows

0.000

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

116284 function calls (112310 primitive calls) in 1.038 seconds Ordered by: cumulative time List reduced from 1283 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.038 1.038 /data/fmiam/current/libs/framework/WebManager.py:136(_newRequest) 1 0.000 0.000 1.027 1.027 /data/fmiam/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.971 0.971 /data/fmiam/current/libs/framework/BaseHandler.py:269(_safeCall) 1 0.000 0.000 0.971 0.971 /data/fmiam/current/generic/sites/www/forms/meeting/Microsite.py:24(index) 4/3 0.000 0.000 0.844 0.281 /data/fmiam/current/libs/framework/MakoTemplate.py:48(__call__) 4 0.000 0.000 0.844 0.211 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/template.py:461(render) 4 0.000 0.000 0.844 0.211 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:860(_render) 4 0.000 0.000 0.844 0.211 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:912(_render_context) 4 0.000 0.000 0.844 0.211 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/mako/runtime.py:927(_exec_template) 1 0.000 0.000 0.757 0.757 /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.677 0.677 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:244(render_microsite_sidebar) 1 0.000 0.000 0.466 0.466 /tmp/mako_modules_1011/fmiam/www/25.1.1/helpers/meetingHelpers.html.py:57(render_addToCalendarWidget) 30 0.000 0.000 0.454 0.015 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 30 0.000 0.000 0.454 0.015 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 30 0.000 0.000 0.453 0.015 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 30 0.452 0.015 0.452 0.015 {function Connection.query at 0xe3777a0b6980} 2 0.000 0.000 0.423 0.211 /data/fmiam/current/generic/classes/Address.py:297(getPrintPlain) 2 0.000 0.000 0.423 0.211 /data/fmiam/current/generic/classes/Address.py:340(generatePrettyHTML) 1 0.000 0.000 0.422 0.422 /data/fmiam/current/generic/classes/Meeting.py:3270(getYahooLink) 1 0.000 0.000 0.422 0.422 /data/fmiam/current/libs/utils/calendarUtils.py:13(getYahooLink) 1 0.000 0.000 0.415 0.415 /data/fmiam/current/generic/classes/Meeting.py:3274(getAddress) 5 0.000 0.000 0.410 0.082 /data/fmiam/current/libs/utils/htmlTools.py:100(cleanHTML) 13 0.000 0.000 0.384 0.030 /data/fmiam/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 87/21 0.000 0.000 0.362 0.017 /data/fmiam/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 10/8 0.000 0.000 0.362 0.045 /data/fmiam/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 484/275 0.001 0.000 0.330 0.001 /data/fmiam/current/libs/framework/BaseHandler.py:1471(mxxImporter) 48/15 0.009 0.000 0.330 0.022 :934(exec_module) 503/275 0.001 0.000 0.330 0.001 {built-in method builtins.__import__} 41/5 0.000 0.000 0.329 0.066 :1165(_find_and_load) 41/5 0.000 0.000 0.329 0.066 :1120(_find_and_load_unlocked) 109/17 0.000 0.000 0.328 0.019 :233(_call_with_frames_removed) 40/6 0.000 0.000 0.328 0.055 :666(_load_unlocked) 48/15 0.005 0.000 0.319 0.021 {built-in method builtins.exec} 3 0.000 0.000 0.304 0.101 /data/fmiam/current/libs/PLayer/PersistentObject.py:2855(_loadListAssoc) 3 0.000 0.000 0.304 0.101 /data/fmiam/current/libs/PLayer/PersistentObject.py:2901(_loadAssocListSQL) 1 0.000 0.000 0.237 0.237 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 1 0.000 0.000 0.204 0.204 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 75/39 0.006 0.000 0.196 0.005 :1207(_handle_fromlist) 43 0.003 0.000 0.163 0.004 /usr/lib/python3.11/re/__init__.py:272(_compile) 29 0.000 0.000 0.163 0.006 /usr/lib/python3.11/re/__init__.py:225(compile) 19 0.000 0.000 0.160 0.008 /usr/lib/python3.11/re/_compiler.py:740(compile) 1 0.000 0.000 0.114 0.114 /data/fmiam/current/libs/framework/WebApp.py:298(writeHTMLWithMicrosite) 2 0.000 0.000 0.108 0.054 /data/fmiam/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS) 7 0.108 0.015 0.108 0.015 /data/fmiam/current/libs/utils/htmlTools.py:53(init) 1 0.000 0.000 0.097 0.097 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1() 1 0.000 0.000 0.086 0.086 /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) 19 0.000 0.000 0.082 0.004 /usr/lib/python3.11/re/_compiler.py:573(_code) 19 0.000 0.000 0.078 0.004 /usr/lib/python3.11/re/_parser.py:979(parse) 73/19 0.001 0.000 0.077 0.004 /usr/lib/python3.11/re/_parser.py:456(_parse_sub) 1 0.000 0.000 0.077 0.077 /tmp/mako_modules_1011/fmiam/www/25.1.1/meetings/microsite_helpers.html.py:82(render_responsive_microsite_startOfContent) 654/19 0.039 0.000 0.077 0.004 /usr/lib/python3.11/re/_parser.py:516(_parse) 1 0.000 0.000 0.077 0.077 /data/fmiam/current/generic/classes/Meeting.py:2839(getBannerWidth) 1 0.000 0.000 0.075 0.075 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/__init__.py:1() 1 0.000 0.000 0.072 0.072 /data/fmiam/current/generic/classes/File.py:63(getImageSize) 48 0.001 0.000 0.066 0.001 :1007(get_code) 8 0.000 0.000 0.065 0.008 /data/fmiam/current/libs/framework/BaseHandler.py:312(getTemplate) 3 0.000 0.000 0.064 0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 703/19 0.004 0.000 0.062 0.003 /usr/lib/python3.11/re/_compiler.py:37(_compile) 3 0.000 0.000 0.062 0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/sanitizer.py:87(__init__) 3 0.000 0.000 0.061 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:410(__init__) 3 0.000 0.000 0.061 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:93(__init__) 7/5 0.000 0.000 0.058 0.012 /data/fmiam/current/libs/PLayer/PersistentObject.py:2912(_loadAssoc) 7/5 0.000 0.000 0.058 0.012 /data/fmiam/current/libs/PLayer/PersistentObject.py:2978(_loadAssocSQL) 6 0.000 0.000 0.057 0.009 /data/fmiam/current/libs/framework/BaseHandler.py:596(getTemplateDefaults) 3 0.000 0.000 0.053 0.018 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/__init__.py:39(getTreeBuilder) 1 0.000 0.000 0.053 0.053 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/treebuilders/etree.py:1() 48 0.000 0.000 0.051 0.001 :727(_compile_bytecode) 48 0.051 0.001 0.051 0.001 {built-in method marshal.loads} 1 0.000 0.000 0.051 0.051 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:32(build_url_re) 53 0.048 0.001 0.049 0.001 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 1 0.000 0.000 0.048 0.048 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:65(build_email_re) 7 0.000 0.000 0.046 0.007 /data/fmiam/current/libs/framework/Auth.py:414(getValidSessionRecord) 1 0.003 0.003 0.046 0.046 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/_ihatexml.py:1() 1 0.000 0.000 0.043 0.043 /data/fmiam/current/generic/classes/Meeting.py:3336(getMeetingByMicrositePath) 1 0.000 0.000 0.043 0.043 /data/fmiam/current/libs/PLayer/PersistentBroker.py:770(processCriteria) 1 0.000 0.000 0.043 0.043 /data/fmiam/current/generic/classes/Meeting.py:3266(getGoogleLink) 1 0.000 0.000 0.043 0.043 /data/fmiam/current/libs/utils/calendarUtils.py:10(getGoogleLink) 6 0.000 0.000 0.043 0.007 /data/fmiam/current/libs/framework/WebSite.py:1076(getImpersonatingUser) 10 0.000 0.000 0.036 0.004 /data/fmiam/current/generic/classes/Meeting.py:3350(getTabs) 1 0.000 0.000 0.034 0.034 /data/fmiam/current/generic/classes/File.py:231(isImage) 1 0.000 0.000 0.034 0.034 /usr/lib/python3.11/mimetypes.py:293(guess_type) 4142 0.033 0.000 0.033 0.000 /usr/lib/python3.11/re/_parser.py:168(__getitem__) 89 0.001 0.000 0.033 0.000 {built-in method builtins.__build_class__} 1 0.000 0.000 0.032 0.032 /usr/lib/python3.11/mimetypes.py:366(init) 2 0.000 0.000 0.032 0.016 /data/fmiam/current/generic/classes/Meeting.py:3234(getIcalStart) 1 0.000 0.000 0.031 0.031 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/html5parser.py:1() 1 0.000 0.000 0.029 0.029 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/packaging/version.py:1() 1 0.000 0.000 0.028 0.028 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/PIL/Image.py:1() 1 0.000 0.000 0.026 0.026 /usr/lib/python3.11/mimetypes.py:207(read) 1 0.015 0.015 0.026 0.026 /usr/lib/python3.11/mimetypes.py:218(readfp) 1 0.000 0.000 0.025 0.025 /data/fmiam/current/libs/framework/WebSite.py:420(outputDebugTable) 8 0.000 0.000 0.024 0.003 /data/fmiam/current/libs/PLayer/PersistentBroker.py:336(processSql) 1 0.023 0.023 0.024 0.024 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/_vendor/html5lib/serializer.py:1() 11 0.000 0.000 0.021 0.002 /data/fmiam/current/libs/PLayer/SQLStatement.py:482(buildForCriteria) 11 0.000 0.000 0.020 0.002 /data/fmiam/current/libs/PLayer/SQLStatement.py:342(buildForObject) 1 0.000 0.000 0.020 0.020 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/packaging/version.py:159(Version) 19 0.000 0.000 0.019 0.001 /usr/lib/python3.11/re/_compiler.py:511(_compile_info) 67 0.000 0.000 0.018 0.000 /data/fmiam/current/libs/framework/WebSite.py:1285(debugHTML) 13/12 0.000 0.000 0.018 0.001 /data/fmiam/current/libs/PLayer/PersistentObject.py:2950(_createObjectFromRow) 1 0.000 0.000 0.017 0.017 /data/fmiam/current/libs/framework/WebForm.py:94(__init__)