Shopping Cart

Login Now to see if you qualify for any special pricing.

You currently have no items in your shopping cart.

Total Time

Count

Avg Time

Query

0.092

1 call
0 rows

0.092

SELECT DISTINCT hex(Purchase.PurchaseId) AS PurchaseId, Purchase.orderNumber, Purchase.subtotal, Purchase.taxPercent, Purchase.phone, Purchase.fax, Purchase.email, Purchase.orderStatus, Purchase.isFulfilled, Purchase.dateSubmitted, Purchase.sessionId, Purchase.dateFulfilled, Purchase.trackingNumber, Purchase.fulfilledBy, Purchase.source, Purchase.marketingCode, Purchase.vendorId, Purchase.department, Purchase.productionNotes, Purchase.isInternal, Purchase.tax, Purchase.shipping, Purchase.shippingName, Purchase.shipToCompany, Purchase.shipToTitle, Purchase.comments, Purchase.internalComments, Purchase.site, Purchase.dateCancelled, Purchase.dateLetterSent, Purchase.dateFulfillmentConfirmationSent, Purchase.dateCancellationEmailSent, Purchase.dateBalanceDueEmailSent, Purchase.datePaymentReceivedEmailSent, Purchase.createdOnWWW, Purchase.mxxCreated FROM (Purchase) WHERE ((Purchase.sessionId=6035554625513746786 AND Purchase.IndividualId is NULL) AND Purchase.orderStatus=1) ORDER BY Purchase.dateSubmitted DESC

0.006

1 call
0 rows

0.006

INSERT INTO PageRequest SET mxxCreated='2025-06-30 22:41:58',mxxCreatedBy=NULL, PageRequestId=0x21DFF300000000, path='forms/store/ShoppingCartFormPublic/view', formName='ShoppingCartFormPublic', site='www', clientAcronym='FACT', pid='2745157', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='378801', startTime='2025-06-30 22:41:58', sessionId=0x53C298F444367162, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='216.73.216.125'

0.006

1 call
0 rows

0.006

COMMIT

0.002

16 calls
1 row

0.000

SELECT version from databasemap;

0.001

2 calls
1 row

0.001

select max(returnOrder) from Stack where sessionId = 6035554625513746786

0.001

1 call
244 rows

0.001

SELECT * FROM Country ORDER BY orderindex, id

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(Application.ApplicationId) AS ApplicationId, Application.status, Application.applicationDate, Application.isPaid, Application.isMailed, Application.applicationType, Application.companyApplicationType, Application.individualMembershipType, Application.isEmailed, Application.dateKitSent, Application.application_year, Application.recievedOnlinePayment, Application.datePaidOnline, Application.isVerified, Application.enteredByKeyContact, Application.yearEstablished, Application.companyStruct, Application.source, Application.sourceOther, Application.howHeardAboutOther, Application.isUnapproved, Application.numberOfPayments, hex(Application._suggestedDues) AS _suggestedDues, Application.dateSubmitted, Application._optionalMembershipFeeCustom, Application.dateCancelled, Application.dateEmailSent, Application.numAdditionalMembers, Application.otherProfessionalSocieties, Application.numYearsCellularTherapy, Application.experience, Application.previousEmployment, Application.everExplanation, Application.insuranceCompanyDenied, Application.insuranceProceduresExcluded, Application.everSuspended, Application.everWithdrawn, Application.everDisciplined, Application.everTerminatedInsurance, Application.everDeniedInsurance, Application.everExcludedInsurance, Application.priorInsuranceCarrier, Application.professionalReferences, Application.professionalSuitsFiled, Application.professionalSuitsPending, Application.professionalJudgments, Application.professionalSuitsExplanation, Application.emergencyContact, Application.signedForms, Application.affiliatedWithBank, Application.affiliatedWithOrg, Application.numYearsBoneMarrow, Application.numYearsCellularProcessing, Application.numYearsCordBloodBank, Application.numYearsCordBloodCollection, Application.numYearsCordBloodProcessing, Application.numYearsApheresisCollection, Application.insurancePolicyExpiration, Application.medicalLicenseRestrictions, Application.medicalLicenseExpiration, Application.medicalLicenseType, Application.previousEmployer1, Application.previousEmployer2, Application.previousEmployer3, Application.previousEmployerOther, Application.membershipNumberISCT, Application.membershipNumberASBMT, Application.readConfidentialityPolicy, Application.accreditationEndDate, Application.accreditationStartDate, Application.dateBalanceDueEmailSent, Application.datePaymentReceivedEmailSent, Application.finePrint, Application.duesBudget, Application.dateWelcomeEmailSent, Application.dateCancellationEmailSent, Application.marketingCode, Application.dateActivatedMembership, Application.hasActivatedMembership, Application.otherMemberships, Application.numYearsClinicalImmune, Application.numYearsClinicalRegenerative, Application.numYearsCellProcessingMajor, Application.mxxCreated, Application.overrideAddressText, Application.overrideCompanyName FROM (Invoice, Application) WHERE Application.InvoiceId=Invoice.InvoiceId AND Invoice.InvoiceId=0x21DFF30000000A ORDER BY Application.applicationDate

0.001

1 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 (Purchase, Individual) WHERE Purchase.PurchaseId=0x21DFF300000001 AND Purchase.IndividualId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.001

1 call
158 rows

0.001

SELECT * FROM webselect

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(Invoice.InvoiceId) AS InvoiceId, Invoice.dateOfInvoice, Invoice.invoiceNumber, Invoice.amount, Invoice.isPaid, Invoice.invoiceNum, Invoice.comments, Invoice._SAAmountPaid, Invoice.SADateCancelled, Invoice._SABalance, Invoice._SAAmountAR, Invoice._SAAmountAP, Invoice.mxxCreated, hex(Invoice.mxxCreatedBy) AS mxxCreatedBy, Invoice.mxxUpdated, hex(Invoice.mxxUpdatedBy) AS mxxUpdatedBy, Invoice.refNumber FROM (Purchase, Invoice) WHERE Purchase.InvoiceId=Invoice.InvoiceId AND Purchase.PurchaseId=0x21DFF300000001

0.001

1 call
0 rows

0.001

SELECT DISTINCT hex(Committee.CommitteeId) AS CommitteeId, Committee.description, Committee.startDate, Committee.endDate, Committee.status, Committee.deleted, Committee.type, Committee.category, Committee.name, Committee.reportsTo, Committee.lifespan, Committee.hidden, Committee.showParticipationOnIndividualView, Committee.showOnMemberParticipationreport, Committee.recordOrigin, Committee.isBoard, Committee.myCommitteeNotes, Committee.inceptionYear, Committee.notes FROM (MailingList, Committee) WHERE MailingList.CommitteeId=Committee.CommitteeId AND MailingList.MailingListId=0x21DFF300000006 ORDER BY Committee.name

0.001

1 call
13 rows

0.001

SELECT DISTINCT hex(WebTab.WebTabId) AS WebTabId, WebTab.name, WebTab.link, WebTab.description, hex(WebTab.parent) AS parent, WebTab.requiredSetting, WebTab.defaultSubTab FROM (WebTab) WHERE WebTab.parent is null ORDER BY WebTab.WebTabId

0.000

1 call
54 rows

0.000

SELECT * FROM StateProvince ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Batch.BatchId) AS BatchId, Batch.batchNumber, Batch.batchDate, Batch.isClosed, Batch.dateOfPayments, Batch.total, Batch.totalMCVisa, Batch.totalAmex, Batch.totalDiners, Batch.totalCheck, Batch.categories, Batch.type FROM (Payment, Batch) WHERE Payment.PaymentId=0x21DFF30000000C AND Payment.BatchId=Batch.BatchId ORDER BY Batch.dateOfPayments, Batch.batchNumber

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Product.ProductId) AS ProductId, Product.name, Product.ProductTypeId, Product.govRelations, Product.training, Product.laborRelations, Product.MembersOnlyId, Product.description, Product.size, Product.weight, Product.year, Product.memberPrice, Product.nonMemberPrice, Product.bookStorePrice, Product.governmentPrice, Product.retiredPrice, Product.uploadCover, Product.imageAltTag, Product.fullDocument, Product.fileType, Product.fileSize, Product.submitted, Product.toc, Product.productNumber, Product.electronic, Product.print, Product.language, Product.coverSize, Product.tocSize, Product.vendorId, Product.department, Product.productionNotes, Product.shipType, Product.author, Product.shortDescription, Product.miniImageAltTag, Product.isFeature, Product.miniImage, Product.isTaxable, Product.WebSiteDirectory, Product.WebSiteDirectoryURL, Product.WebSiteExpirationDuration, Product.WebSiteExpirationDate, Product.expirationDuration, Product.activationStatus, Product.orderindex, Product.mxxCreated, Product.mxxUpdated, Product.recordOrigin, Product.slug, Product.specialNotes, Product.campaignCode, Product.originalImage, Product.publishStartDate, Product.publishEndDate, Product.imageOverlayText, Product.embedCode, Product.featuredExpirationDate, Product.externalContentLink FROM (OrderItem, Product) WHERE OrderItem.OrderItemId=0x21DFF300000002 AND OrderItem.ProductId=Product.ProductId ORDER BY Product.name

0.000

1 call
0 rows

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 (Purchase, Address) WHERE Purchase.PurchaseId=0x21DFF300000001 AND Purchase.ShippingAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ProductPrice.ProductPriceId) AS ProductPriceId, ProductPrice.amount, ProductPrice.minQuantity, ProductPrice.maxQuantity, ProductPrice.shipType, ProductPrice.priceType, ProductPrice.description, ProductPrice.accountingCode, ProductPrice.membershipTypesLabelForWWW FROM (OrderItem, ProductPrice) WHERE OrderItem.OrderItemId=0x21DFF300000002 AND OrderItem.PriceId=ProductPrice.ProductPriceId ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Pledge.PledgeId) AS PledgeId, Pledge.dateOfPledge, Pledge.donorSalutation, Pledge.arrangerSalutation, Pledge.anonumous, Pledge.pledgeType, Pledge.donorType, Pledge.amount, Pledge.year, Pledge.installment, Pledge.acknowledged, Pledge.inHonor, Pledge.honoreeText, Pledge.prefix, Pledge.firstName, Pledge.middleName, Pledge.lastName, Pledge.title, Pledge.company, Pledge.address1, Pledge.address2, Pledge.city, Pledge.state, Pledge.country, Pledge.zip, Pledge.phone, Pledge.province, Pledge.isArrangerDifferent, Pledge.pledgeLatterSent, Pledge.giftLatterSent, Pledge.honoreeLatterSent, Pledge.reminderLatterSent, Pledge.inKind, Pledge.isCanceled, Pledge.donorReportedName, Pledge.donorLabelName, Pledge.suffix, Pledge.fund, Pledge.restrictions, Pledge.source, Pledge.dateCancelled, Pledge.dateEmailSent, Pledge.mxxCreated, Pledge.reportRequired, Pledge.reportDueDate, Pledge.dateCancellationEmailSent, Pledge.dateBalanceDueEmailSent, Pledge.datePaymentReceivedEmailSent FROM (Invoice, Pledge) WHERE Pledge.InvoiceId=Invoice.InvoiceId AND Invoice.InvoiceId=0x21DFF30000000A ORDER BY dateOfPledge DESC

0.000

2 calls
5 rows

0.000

SELECT * FROM ShipType ORDER BY orderindex, id

0.000

2 calls
5 rows

0.000

SELECT hex(ShipMethod.ShipMethodId) AS ShipMethodId, ShipMethod.description, ShipMethod.costFactor, ShipMethod.shipViaCode FROM (ShipMethod) ORDER BY orderIndex LIMIT 0, 700

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Registration.RegistrationId) AS RegistrationId, Registration.status, Registration.dateSubmitted, Registration.dateCancelled, Registration.dateApproved, Registration.dateLetterSent, Registration.dateEmailSent, Registration.dateCancellationLetterSent, Registration.source, Registration.marketingCode, Registration.dateRejected, Registration.mxxUpdated, Registration.registrationNum, Registration.dateCancellationEmailSent, Registration.wantsHousing, Registration.dateStaffNotificationEmailSent, Registration.dateStaffCancellationEmailSent, Registration.notes, Registration.whoToEmail, Registration.mxxCreated, Registration.dateBalanceDueEmailSent, Registration.datePaymentReceivedEmailSent, Registration.dateAttendeeSubstitutionEmailSent, Registration.housingChoice, Registration.excludeFromAttendeeRoster, hex(Registration.lmsId) AS lmsId FROM (Invoice, Registration) WHERE Registration.InvoiceId=Invoice.InvoiceId AND Invoice.InvoiceId=0x21DFF30000000A

0.000

1 call
4 rows

0.000

2 calls
1 row

0.000

select count(*) c from ProcessorAccount

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Exhibit.ExhibitId) AS ExhibitId, Exhibit.type, Exhibit.source, Exhibit.description, Exhibit.brands, Exhibit.logo, Exhibit.preferredLocation, Exhibit.width, Exhibit.depth, Exhibit.sqft, Exhibit.requirements, Exhibit.submitDate, Exhibit.reviewDate, Exhibit.contractDate, Exhibit.contractSignedBy, Exhibit.contractSignedByTitle, Exhibit.deletedDate, Exhibit.competitorPublic, Exhibit.webaddress, Exhibit.contractLanguage, Exhibit.cancelled, Exhibit.canceledDate, Exhibit.exhibitorRulesUrl, Exhibit.returningExhibitor, Exhibit.directoryVerifyDate, Exhibit.dateSubmitEmailLastSent, Exhibit.dateBoothEmailLastSent, Exhibit.dateReceived, Exhibit.dateReviewerEmailLastSent, Exhibit.datePaymentMgrEmailLastSent, Exhibit.dateBoothMgrEmailLastSent, Exhibit.isWaitlisted, Exhibit.dateCancelled, Exhibit.marketingCode, Exhibit.dateBalanceDueEmailSent, Exhibit.datePaymentReceivedEmailSent, Exhibit.dateCancelEmailLastSent, Exhibit.mxxCreated FROM (Invoice, Exhibit) WHERE Exhibit.InvoiceId=Invoice.InvoiceId AND Invoice.InvoiceId=0x21DFF30000000A

0.000

1 call
3 rows

0.000

SELECT * FROM PriceType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Sponsor.SponsorId) AS SponsorId, Sponsor.isArrangerDifferent, Sponsor.amount, Sponsor.inKind, Sponsor.dateSubmitted, Sponsor.comments, Sponsor.status, Sponsor.dateCancelled, Sponsor.source, Sponsor.dateEmailSent, Sponsor.datePaymentEmailSent, Sponsor.dateCancellationEmailSent, Sponsor.dateBalancedueEmailSent, Sponsor.finePrint, Sponsor.description, Sponsor.shortDesc, Sponsor.mxxCreated, Sponsor.createdOnWWW FROM (Invoice, Sponsor) WHERE Sponsor.InvoiceId=Invoice.InvoiceId AND Invoice.InvoiceId=0x21DFF30000000A

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Bill.BillId) AS BillId, Bill.finePrint, Bill.dueDate, Bill.dateCancelled, Bill.source, Bill.status, Bill.dateEmailSent, Bill.mxxCreated, Bill.selectArranger, Bill.dateCancellationEmailSent, Bill.dateBalanceDueEmailSent, Bill.datePaymentReceivedEmailSent FROM (Invoice, Bill) WHERE Bill.InvoiceId=Invoice.InvoiceId AND Invoice.InvoiceId=0x21DFF30000000A

0.000

1 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=0x21DFF30000000E AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Purchase.PurchaseId) AS PurchaseId, Purchase.orderNumber, Purchase.subtotal, Purchase.taxPercent, Purchase.phone, Purchase.fax, Purchase.email, Purchase.orderStatus, Purchase.isFulfilled, Purchase.dateSubmitted, Purchase.sessionId, Purchase.dateFulfilled, Purchase.trackingNumber, Purchase.fulfilledBy, Purchase.source, Purchase.marketingCode, Purchase.vendorId, Purchase.department, Purchase.productionNotes, Purchase.isInternal, Purchase.tax, Purchase.shipping, Purchase.shippingName, Purchase.shipToCompany, Purchase.shipToTitle, Purchase.comments, Purchase.internalComments, Purchase.site, Purchase.dateCancelled, Purchase.dateLetterSent, Purchase.dateFulfillmentConfirmationSent, Purchase.dateCancellationEmailSent, Purchase.dateBalanceDueEmailSent, Purchase.datePaymentReceivedEmailSent, Purchase.createdOnWWW, Purchase.mxxCreated FROM (OrderItem, Purchase) WHERE OrderItem.OrderItemId=0x21DFF300000002 AND OrderItem.OrderId=Purchase.PurchaseId ORDER BY Purchase.dateSubmitted DESC

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(Purchase.PurchaseId) AS PurchaseId, Purchase.orderNumber, Purchase.subtotal, Purchase.taxPercent, Purchase.phone, Purchase.fax, Purchase.email, Purchase.orderStatus, Purchase.isFulfilled, Purchase.dateSubmitted, Purchase.sessionId, Purchase.dateFulfilled, Purchase.trackingNumber, Purchase.fulfilledBy, Purchase.source, Purchase.marketingCode, Purchase.vendorId, Purchase.department, Purchase.productionNotes, Purchase.isInternal, Purchase.tax, Purchase.shipping, Purchase.shippingName, Purchase.shipToCompany, Purchase.shipToTitle, Purchase.comments, Purchase.internalComments, Purchase.site, Purchase.dateCancelled, Purchase.dateLetterSent, Purchase.dateFulfillmentConfirmationSent, Purchase.dateCancellationEmailSent, Purchase.dateBalanceDueEmailSent, Purchase.datePaymentReceivedEmailSent, Purchase.createdOnWWW, Purchase.mxxCreated FROM (Invoice, Purchase) WHERE Purchase.InvoiceId=Invoice.InvoiceId AND Invoice.InvoiceId=0x21DFF30000000A ORDER BY Purchase.dateSubmitted DESC

0.000

1 call
4 rows

0.000

SELECT * FROM CreditCardType ORDER BY orderindex, id

0.000

1 call
8 rows

0.000

SELECT * FROM ProductType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(ShipMethod.ShipMethodId) AS ShipMethodId, ShipMethod.description, ShipMethod.costFactor, ShipMethod.shipViaCode FROM (Purchase, ShipMethod) WHERE Purchase.PurchaseId=0x21DFF300000001 AND Purchase.ShipMethodId=ShipMethod.ShipMethodId ORDER BY orderIndex

0.000

1 call
0 rows

0.000

1 call
8 rows

0.000

SELECT * FROM PurchaseSource ORDER BY orderindex, id

0.000

1 call
0 rows

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 (Payment, Address) WHERE Payment.PaymentId=0x21DFF30000000C AND Payment.billingAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
2 rows

0.000

SELECT * FROM FulfillmentStatus ORDER BY orderindex, id

0.000

1 call
0 rows

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 (Purchase, Address) WHERE Purchase.PurchaseId=0x21DFF300000001 AND Purchase.BillingAddressId=Address.AddressId ORDER BY Address.zip

0.000

1 call
7 rows

0.000

SELECT * FROM PaymentType ORDER BY orderindex, id

0.000

1 call
3 rows

0.000

SELECT * FROM PaymentStatus ORDER BY orderindex, id

0.000

1 call
2 rows

0.000

SELECT * FROM YesNo ORDER BY orderindex, id

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

START TRANSACTION

520213 function calls (512237 primitive calls) in 0.678 seconds Ordered by: cumulative time List reduced from 2370 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.679 0.679 /data/fact/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 0.423 0.423 /data/fact/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.384 0.384 /data/fact/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 0.384 0.384 /data/fact/current/generic/sites/www/forms/store/ShoppingCartFormPublic.py:176(view) 1 0.000 0.000 0.282 0.282 /data/fact/current/libs/framework/WebForm.py:191(view) 1 0.000 0.000 0.238 0.238 /data/fact/current/libs/framework/WebManager.py:89(createNewHandler) 1 0.000 0.000 0.238 0.238 /data/fact/current/libs/framework/WebSite.py:92(__init__) 1 0.000 0.000 0.186 0.186 /data/fact/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 1 0.000 0.000 0.186 0.186 /data/fact/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 84 0.001 0.000 0.175 0.002 /data/fact/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 6/4 0.000 0.000 0.169 0.042 /data/fact/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 88 0.000 0.000 0.147 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 88 0.000 0.000 0.146 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 347/163 0.004 0.000 0.146 0.001 {built-in method builtins.exec} 202/129 0.001 0.000 0.145 0.001 :1165(_find_and_load) 202/129 0.001 0.000 0.142 0.001 :1120(_find_and_load_unlocked) 211/137 0.001 0.000 0.136 0.001 :666(_load_unlocked) 88 0.000 0.000 0.134 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 88 0.133 0.002 0.133 0.002 {function Connection.query at 0xf5fd2db560c0} 210/138 0.000 0.000 0.132 0.001 :934(exec_module) 1 0.004 0.004 0.124 0.124 /data/fact/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 440/260 0.000 0.000 0.121 0.000 :233(_call_with_frames_removed) 4/1 0.000 0.000 0.111 0.111 /data/fact/current/libs/framework/DGEAssocList.py:380(getBBTDictionary) 6/1 0.000 0.000 0.111 0.111 /data/fact/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 27 0.000 0.000 0.111 0.004 /data/fact/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 63 0.000 0.000 0.097 0.002 /data/fact/current/libs/framework/DGEAttribute.py:58(getEditHTML) 3 0.000 0.000 0.095 0.032 /data/fact/current/libs/PLayer/PersistentBroker.py:770(processCriteria) 1 0.000 0.000 0.093 0.093 /data/fact/current/generic/sites/www/forms/store/ShoppingCartFormPublic.py:269(getPO) 1 0.000 0.000 0.089 0.089 /data/fact/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.089 0.089 /data/fact/current/libs/framework/WebApp.py:213(wrapHTML) 174 0.001 0.000 0.080 0.000 /data/fact/current/libs/framework/DTWrapper.py:47(__call__) 174 0.001 0.000 0.079 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 16 0.000 0.000 0.077 0.005 /data/fact/current/libs/utils/htmlTools.py:100(cleanHTML) 3552/3117 0.002 0.000 0.076 0.000 /data/fact/current/libs/framework/BaseHandler.py:1458(mxxImporter) 3576/3122 0.003 0.000 0.075 0.000 {built-in method builtins.__import__} 1 0.000 0.000 0.075 0.075 /data/fact/current/libs/framework/DisplayGroup.py:311(initialize) 2 0.001 0.000 0.073 0.036 /data/fact/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 49 0.000 0.000 0.072 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 50 0.000 0.000 0.072 0.001 /usr/lib/python3.11/re/__init__.py:272(_compile) 8 0.004 0.001 0.071 0.009 /data/fact/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 37 0.000 0.000 0.071 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 249 0.001 0.000 0.071 0.000 /data/fact/current/libs/framework/DGEAttribute.py:207(getValue) 63 0.000 0.000 0.070 0.001 /data/fact/current/libs/framework/DGEAttribute.py:45(massageDictForEditHTML) 8 0.053 0.007 0.067 0.008 /data/fact/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 46 0.000 0.000 0.064 0.001 /data/fact/current/libs/framework/DGEInput.py:29(massageDictForEditHTML) 1 0.000 0.000 0.056 0.056 /data/fact/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 548/174 0.001 0.000 0.053 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 959/174 0.008 0.000 0.053 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 37 0.000 0.000 0.052 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 1 0.000 0.000 0.049 0.049 /data/fact/current/libs/framework/DGEMethodList.py:240(getBBTDictionary) 1 0.000 0.000 0.049 0.049 /data/fact/current/libs/framework/DGEMethodList.py:257(getDataDictionary) 5928 0.040 0.000 0.043 0.000 /data/fact/current/libs/framework/LazyDict.py:71(__setitem__) 110 0.041 0.000 0.043 0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 1 0.000 0.000 0.040 0.040 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 1 0.000 0.000 0.039 0.039 /data/fact/current/libs/framework/WebManInterface.py:92(createBroker) 91/73 0.000 0.000 0.038 0.001 /data/fact/current/libs/PLayer/PersistentBroker.py:78(__new__) 14 0.001 0.000 0.038 0.003 /data/fact/current/libs/framework/DGESelect.py:36(getEditHTML) 1 0.000 0.000 0.038 0.038 /data/fact/current/libs/framework/DGEEmail.py:1() 1 0.000 0.000 0.036 0.036 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.py:1() 1 0.011 0.011 0.035 0.035 /data/fact/current/libs/PLayer/PersistentBroker.py:442(retrieveClassMaps) 1 0.000 0.000 0.035 0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/validate_email.py:1() 1 0.000 0.000 0.034 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/syntax.py:1() 1 0.000 0.000 0.034 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/rfc_constants.py:1() 1 0.000 0.000 0.034 0.034 /data/fact/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 801/37 0.004 0.000 0.034 0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile) 1 0.000 0.000 0.034 0.034 /data/fact/current/libs/framework/baseScrapeAndDrape.py:243(getStubFromCache) 1 0.000 0.000 0.033 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.033 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.033 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.033 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 1 0.000 0.000 0.033 0.033 /data/fact/current/libs/framework/baseScrapeAndDrape.py:714(process) 1 0.000 0.000 0.032 0.032 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.032 0.032 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.001 0.001 0.032 0.032 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 359/317 0.000 0.000 0.030 0.000 :1207(_handle_fromlist) 17 0.001 0.000 0.028 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_In.py:665(renderwob) 210 0.002 0.000 0.025 0.000 :1007(get_code) 14 0.000 0.000 0.021 0.001 /data/fact/current/libs/utils/htmlTools.py:83(get_BLEACH_WHITELIST_TAGS) 30 0.021 0.001 0.021 0.001 /data/fact/current/libs/utils/htmlTools.py:53(init) 13 0.000 0.000 0.020 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:385(cook) 1 0.000 0.000 0.019 0.019 /data/fact/current/libs/framework/WebApp.py:399(getHeaderDict) 37 0.000 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:979(parse) 1232 0.003 0.000 0.019 0.000 /data/fact/current/libs/framework/MaxxDTML.py:29(render) 111/13 0.001 0.000 0.019 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:177(parse) 117/37 0.001 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:456(_parse_sub) 716/37 0.007 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:516(_parse) 37 0.000 0.000 0.018 0.000 /usr/lib/python3.11/re/_compiler.py:511(_compile_info) 2 0.000 0.000 0.017 0.009 /data/fact/current/libs/framework/WebSite.py:698(_logPageRequest) 2437 0.002 0.000 0.016 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:373(__getitem__) 201 0.002 0.000 0.016 0.000 :1054(_find_spec) 17720 0.016 0.000 0.016 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:350(__getattribute__) 36 0.000 0.000 0.015 0.000 /data/fact/current/libs/PLayer/PersistentBroker.py:336(processSql) 28 0.001 0.000 0.015 0.001 /data/fact/current/libs/framework/BaseHandler.py:311(getTemplate) 34 0.000 0.000 0.015 0.000 /data/fact/current/libs/framework/BaseHandler.py:1327(importModule) 1 0.000 0.000 0.015 0.015 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1() 2 0.000 0.000 0.015 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 16 0.000 0.000 0.015 0.001 /data/fact/current/libs/framework/WebSite.py:1134(_loadModule) 2 0.000 0.000 0.014 0.007 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/sanitizer.py:87(__init__) 1714/1702 0.002 0.000 0.014 0.000 /data/fact/current/libs/framework/LazyDict.py:186(__getitem__) 1 0.000 0.000 0.014 0.014 /data/fact/current/libs/framework/WebSite.py:559(logBeginRequest)

Shopping Cart

Services

About

Help and Advice

Phone

Address

fact@factglobal.org