FACT Virtual Quality Boot Camp focused on quality principles for Apheresis Collection, Processing, and Cord Blood Banking

Download agenda

Debugging Info
pagedictsize=0
sqltime = 0.029 s
cpu time = 0.130 s
real time = 0.162 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.0081 call
0 rows
0.008 COMMIT
0.0061 call
0 rows
0.006 INSERT INTO PageRequest SET mxxCreated='2025-05-09 13:43:32',mxxCreatedBy=NULL, PageRequestId=0x2113C900000000, path='forms/meeting/Microsite/Virtualqualitybootcamp2023,2', formName='Microsite', site='www', clientAcronym='FACT', pid='315720', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='103128', startTime='2025-05-09 13:43:32', sessionId=0x65574FE973B21FF6, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='3.148.113.158'
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=0x1B080F00000002
0.0021 call
1 row
0.002 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=0x1B080F00000002 ORDER BY CalendarItem.startDate
0.0021 call
3 rows
0.002 SELECT DISTINCT hex(FeeDateRange.FeeDateRangeId) AS FeeDateRangeId, FeeDateRange.name, FeeDateRange.startDate, FeeDateRange.endDate FROM (FeeDateRange, Meeting) WHERE FeeDateRange.MeetingId=Meeting.MeetingId AND Meeting.MeetingId=0x1B080F00000002
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='Virtualqualitybootcamp2023'
0.0021 call
6 rows
0.002 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=0x1B080F00000002
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=0x1B080F0000001C 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=0x1B080F00000002
0.0016 calls
1 row
0.000 SELECT version from databasemap;
0.0011 call
1 row
0.001 SELECT DISTINCT hex(Timezone.TimezoneId) AS TimezoneId, Timezone.description, Timezone.tzname, hex(Timezone.orderindex) AS orderindex FROM (Timezone, CalendarItem) WHERE CalendarItem.CalendarItemId=0x1B080F00000022 AND CalendarItem.TimezoneId=Timezone.TimezoneId ORDER BY Timezone.orderindex
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=0x1B080F0000000D AND Address.IndividualId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial
0.0011 call
7 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=0x1B080F00000002
0.0001 call
158 rows
0.000 SELECT * FROM webselect
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=0x1B080F00000002 AND Meeting.locationAddressId=Address.AddressId ORDER BY Address.zip
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 (File, Meeting) WHERE Meeting.bannerFileId=File.FileId AND Meeting.MeetingId=0x1B080F00000002
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=0x1B080F0000000D AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name
0.0001 call
1 row
0.000 SELECT * FROM uuid FOR UPDATE
0.0001 call
0 rows
0.000 START TRANSACTION