FACT Cord Blood Inspector Training Course

Coming Soon!

Debugging Info
pagedictsize=660
sqltime = 0.024 s
cpu time = 0.050 s
real time = 0.074 s
memory increase = 4096 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 = 23 queries

Total TimeCountAvg TimeQuery
0.0061 call
1 row
0.006 SELECT DISTINCT hex(MicrositeTabComponent.MicrositeTabComponentId) AS MicrositeTabComponentId, MicrositeTabComponent.type, MicrositeTabComponent.text, MicrositeTabComponent.orderindex FROM (MicrositeTab, MicrositeTabComponent) WHERE MicrositeTabComponent.MicrositeTabId=MicrositeTab.MicrositeTabId AND MicrositeTab.MicrositeTabId=0x1B05A0000005BA ORDER BY MicrositeTabComponent.orderindex
0.0041 call
1 row
0.004 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='FACTInspectorTrainingISCTParis'
0.0041 call
0 rows
0.004 UPDATE PageRequest SET mxxUpdated='2025-05-09 14:50:45',mxxUpdatedBy=NULL, PageRequestId=0x21142900000000, path='forms/store/ProductFormPublic/common-fact-citations', formName='fact_ProductFormPublic', site='www', clientAcronym='FACT', pid='319891', requestNum='1', growth='15304', server='www.fact.maxx.matrixdev.net', dbThreadId='104342', startTime='2025-05-09 14:50:44', sessionId=0x10579F95BD978DA7, userId=0x0, userName='public', result='0', sqltime='0.03624987602233887', timeTaken='54', dictSize='660', fields='{}', clientIPAddr='18.219.8.51' WHERE PageRequestId=0x21142900000000
0.0031 call
2 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=0x1B05A0000005A7
0.0022 calls
244 rows
0.001 SELECT * FROM Country ORDER BY orderindex, id
0.0021 call
0 rows
0.002 INSERT INTO PageRequest SET mxxCreated='2025-05-09 14:52:45',mxxCreatedBy=NULL, PageRequestId=0x2114290000001B, path='forms/meeting/Microsite/FACTInspectorTrainingISCTParis,2', formName='Microsite', site='www', clientAcronym='FACT', pid='319891', requestNum='2', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='104342', startTime='2025-05-09 14:52:45', sessionId=0x6FEC30F67B35C7CC, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='3.15.25.60'
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=0x1B05A0000005A7 ORDER BY CalendarItem.startDate
0.0016 calls
1 row
0.000 SELECT version from databasemap;
0.0011 call
1 row
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=0x1B05A0000005A7
0.0011 call
0 rows
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=0x1B05A0000005A7
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=0x1B05A0000005A7
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=0x1B05A0000005AB AND Address.IndividualId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial
0.0001 call
1 row
0.000 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=0x1B05A0000005A7
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=0x1B05A0000005A7 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 (Timezone, CalendarItem) WHERE CalendarItem.CalendarItemId=0x1B05A0000005C0 AND CalendarItem.TimezoneId=Timezone.TimezoneId ORDER BY Timezone.orderindex
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=0x1B05A0000005A7
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=0x1B05A0000005AB AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name