2012 Financial Executive Conference

 

Thank You

 

We would like to personally thank you everyone who attended the 2012 Financial Executive Conference in Orlando. Your participation played a huge part in making this event a success. We hope your experience was both personally and professionally rewarding and that you will make the most of the sessions, education and connections you made.
 
We hope to see you at our next conference. Date and location to be determined. Until then, please feel free to contact us with comments and suggestions.
 
- The FMI Education Team

Debugging Info
pagedictsize=0
sqltime = 0.402 s
cpu time = 0.030 s
real time = 0.489 s
memory increase = 0 kB
fields =
templates =
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_footer.html
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header.html
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_header_pixel
/data/fmiam/current/generic/themes/www/mako/meetings/microsite_index.html
dg = [] | []
extra debug info =
queries = 21 queries

Total TimeCountAvg TimeQuery
0.2241 call
0 rows
0.224 SELECT DISTINCT hex(`Website`.`WebsiteId`) AS `WebsiteId`, `Website`.`description`, `Website`.`address` FROM (Meeting, Website) WHERE `Website`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x7F7E9000001D1
0.0631 call
1 row
0.063 SELECT DISTINCT hex(`MicrositeTabComponent`.`MicrositeTabComponentId`) AS `MicrositeTabComponentId`, `MicrositeTabComponent`.`type`, `MicrositeTabComponent`.`text`, `MicrositeTabComponent`.`orderindex` FROM (MicrositeTab, MicrositeTabComponent) WHERE `MicrositeTabComponent`.`MicrositeTabId`=`MicrositeTab`.`MicrositeTabId` AND `MicrositeTab`.`MicrositeTabId`=0x7F805000000F3 ORDER BY `MicrositeTabComponent`.`orderindex`
0.0281 call
6 rows
0.028 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`=0x7F7E9000001D1
0.0221 call
2 rows
0.022 SELECT DISTINCT hex(`FeeDateRange`.`FeeDateRangeId`) AS `FeeDateRangeId`, `FeeDateRange`.`name`, `FeeDateRange`.`startDate`, `FeeDateRange`.`endDate` FROM (FeeDateRange, Meeting) WHERE `FeeDateRange`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x7F7E9000001D1
0.0221 call
1 row
0.022 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`, `Meeting`.`hideIntranetSummary` FROM (Meeting) WHERE `Meeting`.`micrositePath`='2012FinExec'
0.0116 calls
1 row
0.002 SELECT version from databasemap;
0.0071 call
1 row
0.007 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`=0x7F7E9000001D1
0.0061 call
1 row
0.006 SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Meeting, File) WHERE `Meeting`.`bannerFileId`=`File`.`FileId` AND `Meeting`.`MeetingId`=0x7F7E9000001D1
0.0051 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`=0x7F7E9000001F0 AND `CalendarItem`.`TimezoneId`=`Timezone`.`TimezoneId` ORDER BY `Timezone`.`orderindex`
0.0041 call
0 rows
0.004 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`=0x7F7E9000001E1 AND `Address`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`
0.0041 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 (Meeting, Address) WHERE `Meeting`.`MeetingId`=0x7F7E9000001D1 AND `Meeting`.`locationAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`
0.0031 call
0 rows
0.003 UPDATE `PageRequest` SET `mxxUpdated`='2026-02-12 02:43:01',`mxxUpdatedBy`=NULL, `PageRequestId`=0xFB99ED00000002, `path`='forms/meeting/Microsite/AP2012,2', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='3999551', `requestNum`='3', `growth`='0', `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='783134', `startTime`='2026-02-12 02:43:01', `sessionId`=0x3BA4A9D881A9A92C, `userId`=0x0, `userName`='public', `result`='0', `sqltime`='0.21603989601135254', `timeTaken`='1', `dictSize`='0', `fields`='{}', `clientIPAddr`='216.73.216.107' WHERE `PageRequestId`=0xFB99ED00000002
0.0031 call
17 rows
0.003 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 (Meeting, Fee) WHERE `Fee`.`itemId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x7F7E9000001D1
0.0031 call
1 row
0.003 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 (Meeting, CalendarItem) WHERE `CalendarItem`.`MeetingId`=`Meeting`.`MeetingId` AND `Meeting`.`MeetingId`=0x7F7E9000001D1 ORDER BY `CalendarItem`.`startDate`
0.0021 call
0 rows
0.002 INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-12 02:43:01',`mxxCreatedBy`=NULL, `PageRequestId`=0xFB99ED00000003, `path`='forms/meeting/Microsite/2012FinExec,0', `formName`='Microsite', `site`='www', `clientAcronym`='FMI', `pid`='3999551', `requestNum`='4', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fmiam.maxx.matrixdev.net', `dbThreadId`='783134', `startTime`='2026-02-12 02:43:01', `sessionId`=0x3BA4A9D881A9A92C, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.107'
0.0001 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 (Branch, Address) WHERE `Address`.`AddressId`=0x7F7E9000001E1 AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`