FACT Apheresis Collection and Processing Accreditation Virtual Workshop

Coming Soon!

Debugging Info
pagedictsize=0
sqltime = 0.024 s
cpu time = 0.130 s
real time = 0.158 s
memory increase = 17852 kB
fields =
templates =
/data/fact/current/generic/themes/www/mako/meetings/microsite_footer.html
/data/fact/current/generic/themes/www/mako/meetings/microsite_header_pixel
/data/fact/current/generic/themes/www/mako/meetings/microsite_header_responsive.html
/data/fact/current/generic/themes/www/mako/meetings/microsite_index_responsive.html
dg = [] | []
extra debug info =
queries = 24 queries

Total TimeCountAvg TimeQuery
0.0061 call
0 rows
0.006 INSERT INTO PageRequest SET mxxCreated='2025-05-13 09:57:27',mxxCreatedBy=NULL, PageRequestId=0x21226500000000, path='forms/meeting/Microsite/factcollectionprocessingvirtual,3', formName='Microsite', site='www', clientAcronym='FACT', pid='678421', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='8451', startTime='2025-05-13 09:57:27', sessionId=0x15CC64AB3587389D, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='216.73.216.109'
0.0061 call
0 rows
0.006 COMMIT
0.0031 call
0 rows
0.003 SELECT DISTINCT hex(Website.WebsiteId) AS WebsiteId, Website.description, Website.address FROM (Meeting, Website) WHERE Website.MeetingId=Meeting.MeetingId AND Meeting.MeetingId=0x1B0663000003B7
0.0021 call
1 row
0.002 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.showPublicSchedule, Meeting.calendarLinkType, Meeting.calendarBlurb, Meeting.retainedEarningsAcctCode, Meeting.enableHousing, Meeting.eventId, 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.referralText, Meeting.hasReferrals, Meeting.wwwRegistrationsEditAlwaysApprove, Meeting.thankYouFullyPaidText, Meeting.venue, Meeting.sendToLMS, Meeting.showSponsorLogos, Meeting.confSponsorText, Meeting.isArchived FROM (Meeting) WHERE Meeting.micrositePath='factcollectionprocessingvirtual'
0.0011 call
2 rows
0.001 SELECT DISTINCT hex(FeeDateRange.FeeDateRangeId) AS FeeDateRangeId, FeeDateRange.name, FeeDateRange.startDate, FeeDateRange.endDate FROM (Meeting, FeeDateRange) WHERE FeeDateRange.MeetingId=Meeting.MeetingId AND Meeting.MeetingId=0x1B0663000003B7
0.0011 call
6 rows
0.001 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=0x1B0663000003B7
0.0011 call
1 row
0.001 SELECT DISTINCT hex(MicrositeTabComponent.MicrositeTabComponentId) AS MicrositeTabComponentId, MicrositeTabComponent.type, MicrositeTabComponent.text, MicrositeTabComponent.orderindex FROM (MicrositeTab, MicrositeTabComponent) WHERE MicrositeTabComponent.MicrositeTabId=MicrositeTab.MicrositeTabId AND MicrositeTab.MicrositeTabId=0x1B0663000003D3 ORDER BY MicrositeTabComponent.orderindex
0.0011 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=0x1B0663000003B7
0.0016 calls
1 row
0.000 SELECT version from databasemap;
0.0011 call
0 rows
0.001 SELECT DISTINCT hex(Individual.IndividualId) AS IndividualId, Individual.EthnicityId, Individual.firstName, Individual.lastName, Individual.prefix, Individual.suffix, Individual.title, Individual.mxxUpdatedBy, Individual.enteredBy, Individual.gender, Individual.SalaryId, Individual.ssn, Individual.middleInitial, Individual.email, Individual.alternateEmail, Individual.emailFromThirdPartyId, Individual.mxxUpdated, Individual.fax, Individual.homePhone, Individual.workPhone, Individual.secondaryPhone, Individual.mobilePhone, Individual.pager, Individual.IndividualTypeId, Individual.paidDues, hex(Individual.VotingId) AS VotingId, Individual.aliases, Individual.personalStatus, Individual.salutation, Individual.homeFax, Individual.visionsId, Individual.emailSent, Individual.personalBackground, Individual.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.recordOrigin, Individual.source, Individual.sourceOther, Individual.dontSnailmail, Individual.prospectStatus, Individual.canSpamSet, hex(Individual.mxxCreatedBy) AS mxxCreatedBy, Individual.criticalNotes, Individual.emergencyContact, Individual.signedForms, Individual.affiliatedWithBank, Individual.affiliatedWithOrg, Individual.affiliatedWithOrgName, Individual.affiliatedWithBankName, Individual.inspectionAgencyNumber, Individual.otherProfessionalSocieties, Individual.membershipNumberASBMT, Individual.membershipNumberISCT, Individual.readConfidentialityPolicy, Individual.conflictOfInterests, Individual.medicalLicenseExpiration, Individual.professionalLiabilityUploaded, Individual.professionalHistoryRestrictions, Individual.professionalLiabilityCase, Individual.professionalLiabilityReasonToDeny, Individual.appropriateAffiliation, Individual.affiliationComments, Individual.cellularTherapyWorkshopDate, Individual.cordBloodWorkshopDate, Individual.cellularTherapyTestDate, Individual.cordBloodTestDate, Individual.professionalInspectionWebinarDate, Individual.trainingInspectionWebinarDate, Individual.trainingInspectionDate, Individual.satisfactoryEvaluationReport, Individual.satisfactoryInspectionReport, Individual.isInspectorPending, Individual.accreditationEndDate, Individual.accreditationStartDate, Individual.congresspersonFor, Individual.factWebAssessmentDate, Individual.factWebEventDate, Individual.congressParty, Individual.mailChimpMergeCache, Individual.otherMemberships, Individual.dateCVReceived, Individual.iieCTTestDate, Individual.anniversaryVideoDate, Individual.iecTutorialDate, Individual.accredPortalTrainingDate, Individual.annualComplianceReceived, Individual.medicalLicenseExpDate, Individual.createdOnWWW, Individual.lastCheckedNotifications, Individual.SAIsBoard, Individual.delinquentSince FROM (Address, Individual) WHERE Address.AddressId=0x1B0663000003C2 AND Address.IndividualId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial
0.0011 call
5 rows
0.001 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=0x1B0663000003B7
0.0011 call
158 rows
0.001 SELECT * FROM webselect
0.0011 call
1 row
0.001 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=0x1B0663000003B7 ORDER BY CalendarItem.startDate
0.0001 call
1 row
0.000 SELECT DISTINCT hex(Address.AddressId) AS AddressId, Address.line1, Address.line2, Address.city, Address.CountryId, Address.AddressTypeId, Address.StateProvinceId, Address.province, Address.zip, Address.isPrimary, Address.name, Address.mainPhone, Address.fax, Address.tollFree, Address.zip5, Address.isZipVerified, Address.congressionalDistrict, Address.latitude, Address.longitude, Address.jsonResult, Address.countyFips, Address.countyName, Address.stateFips FROM (Meeting, Address) WHERE Meeting.MeetingId=0x1B0663000003B7 AND Meeting.locationAddressId=Address.AddressId ORDER BY Address.zip
0.0001 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=0x1B0663000003D7 AND CalendarItem.TimezoneId=Timezone.TimezoneId ORDER BY Timezone.orderindex
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 (Address, Branch) WHERE Address.AddressId=0x1B0663000003C2 AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0001 call
1 row
0.000 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=0x1B0663000003B7
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
0 rows
0.000 START TRANSACTION