Shopping Cart

Below is your shopping cart containing products you have selected.

Please check the items and the quantities to make sure that they are correct. To keep shopping, click on the "Keep Shopping" button. To remove a product from your shopping cart, click the "Remove" link next to a specific product. When you are ready to make your purchase, click the "Proceed to Checkout" button.

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

Title	Qty	Unit Price	Price
		Sub-total:	$0.00

Total Time

Count

Avg Time

Query

0.099

1 call
0 rows

0.099

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=4945879423227475277 AND Purchase.IndividualId is NULL) AND Purchase.orderStatus=1) ORDER BY Purchase.dateSubmitted DESC

0.036

1 call
3 rows

0.036

SELECT * FROM PriceType ORDER BY orderindex, id

0.025

1 call
8 rows

0.025

SELECT * FROM PurchaseSource ORDER BY orderindex, id

0.024

1 call
4 rows

0.024

SELECT * FROM CreditCardType ORDER BY orderindex, id

0.018

1 call
0 rows

0.018

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=0x21107400000002 AND OrderItem.ProductId=Product.ProductId ORDER BY Product.name

0.017

2 calls
4 rows

0.008

SELECT * FROM ShipType ORDER BY orderindex, id

0.014

1 call
0 rows

0.014

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=0x21107400000002 AND OrderItem.PriceId=ProductPrice.ProductPriceId ORDER BY ProductPrice.description, ProductPrice.minQuantity

0.013

2 calls
1 row

0.007

select max(returnOrder) from Stack where sessionId = 4945879423227475277

0.011

1 call
3 rows

0.011

SELECT * FROM PaymentStatus ORDER BY orderindex, id

0.011

1 call
0 rows

0.011

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=0x2110740000000A

0.011

1 call
2 rows

0.011

SELECT * FROM FulfillmentStatus ORDER BY orderindex, id

0.010

1 call
0 rows

0.010

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=0x2110740000000A

0.010

1 call
0 rows

0.010

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=0x2110740000000C AND Payment.BatchId=Batch.BatchId ORDER BY Batch.dateOfPayments, Batch.batchNumber

0.010

1 call
8 rows

0.010

SELECT * FROM ProductType ORDER BY orderindex, id

0.009

1 call
0 rows

0.009

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=0x2110740000000A

0.008

1 call
0 rows

0.008

INSERT INTO PageRequest SET mxxCreated='2025-05-09 00:41:14',mxxCreatedBy=NULL, PageRequestId=0x21107400000000, path='forms/store/ShoppingCartFormPublic/view', formName='ShoppingCartFormPublic', site='www', clientAcronym='FACT', pid='226061', requestNum='1', pageDictSize=NULL, objectId=NULL, templateMethod=NULL, growth=NULL, server='www.fact.maxx.matrixdev.net', dbThreadId='62807', startTime='2025-05-09 00:41:14', sessionId=0x44A34B218B63354D, userId=0x0, userName='public', result=NULL, sqltime=NULL, timeTaken=NULL, dictSize=NULL, fields='{}', clientIPAddr='18.217.93.250'

0.008

1 call
13 rows

0.008

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.007

1 call
0 rows

0.007

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

0.006

1 call
0 rows

0.006

COMMIT

0.006

1 call
7 rows

0.006

SELECT * FROM PaymentType ORDER BY orderindex, id

0.005

1 call
0 rows

0.005

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=0x2110740000000A

0.004

2 calls
1 row

0.002

select count(*) c from ProcessorAccount

0.003

1 call
0 rows

0.003

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=0x21107400000001

0.002

16 calls
1 row

0.000

SELECT version from databasemap;

0.002

1 call
0 rows

0.002

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=0x2110740000000A ORDER BY Application.applicationDate

0.001

1 call
0 rows

0.001

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=0x2110740000000A ORDER BY Purchase.dateSubmitted DESC

0.001

1 call
4 rows

0.001

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.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(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=0x21107400000001 AND Purchase.IndividualId=Individual.IndividualId ORDER BY Individual.lastName, Individual.firstName, Individual.middleInitial

0.000

1 call
158 rows

0.000

SELECT * FROM webselect

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(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=0x2110740000000A ORDER BY dateOfPledge DESC

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=0x21107400000001 AND Purchase.ShippingAddressId=Address.AddressId ORDER BY Address.zip

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=0x2110740000000C AND Payment.billingAddressId=Address.AddressId ORDER BY Address.zip

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=0x21107400000002 AND OrderItem.OrderId=Purchase.PurchaseId ORDER BY Purchase.dateSubmitted DESC

0.000

1 call
0 rows

0.000

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=0x21107400000009 ORDER BY Committee.name

0.000

1 call
0 rows

0.000

1 call
2 rows

0.000

SELECT * FROM YesNo 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=0x21107400000001 AND Purchase.BillingAddressId=Address.AddressId ORDER BY Address.zip

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 (Address, Branch) WHERE Address.AddressId=0x2110740000000E AND Address.BranchId=Branch.BranchId ORDER BY Branch.isMain, Branch.name

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

START TRANSACTION

752380 function calls (742620 primitive calls) in 1.695 seconds Ordered by: cumulative time List reduced from 2554 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.696 1.696 /data/fact/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 1.446 1.446 /data/fact/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 1.222 1.222 /data/fact/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.222 1.222 /data/fact/current/generic/sites/www/forms/store/ShoppingCartFormPublic.py:176(view) 1 0.000 0.000 1.104 1.104 /data/fact/current/libs/framework/WebForm.py:191(view) 1 0.000 0.000 0.794 0.794 /data/fact/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.794 0.794 /data/fact/current/libs/framework/WebApp.py:213(wrapHTML) 1 0.000 0.000 0.761 0.761 /data/fact/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 2 0.000 0.000 0.560 0.280 /usr/lib/python3.11/urllib/request.py:139(urlopen) 3/2 0.000 0.000 0.559 0.280 /usr/lib/python3.11/urllib/request.py:500(open) 7/5 0.000 0.000 0.559 0.112 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 3 0.000 0.000 0.559 0.186 /usr/lib/python3.11/urllib/request.py:529(_open) 3 0.000 0.000 0.559 0.186 /usr/lib/python3.11/urllib/request.py:1307(do_open) 1 0.000 0.000 0.519 0.519 /data/fact/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 88 0.000 0.000 0.404 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 88 0.000 0.000 0.403 0.005 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 88 0.000 0.000 0.390 0.004 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 88 0.390 0.004 0.390 0.004 {function Connection.query at 0xe18dc3e38680} 2 0.000 0.000 0.376 0.188 /usr/lib/python3.11/urllib/request.py:1390(https_open) 77 0.008 0.000 0.329 0.004 {method 'readline' of '_io.BufferedReader' objects} 3 0.000 0.000 0.322 0.107 /usr/lib/python3.11/http/client.py:1351(getresponse) 3 0.000 0.000 0.322 0.107 /usr/lib/python3.11/http/client.py:318(begin) 15 0.000 0.000 0.321 0.021 /usr/lib/python3.11/socket.py:704(readinto) 3 0.000 0.000 0.321 0.107 /usr/lib/python3.11/http/client.py:285(_read_status) 14 0.000 0.000 0.296 0.021 /usr/lib/python3.11/ssl.py:1299(recv_into) 14 0.000 0.000 0.296 0.021 /usr/lib/python3.11/ssl.py:1157(read) 14 0.296 0.021 0.296 0.021 {method 'read' of '_ssl._SSLSocket' objects} 1 0.000 0.000 0.282 0.282 /data/fact/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 1 0.000 0.000 0.282 0.282 /data/fact/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 6/4 0.000 0.000 0.241 0.060 /data/fact/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 1 0.000 0.000 0.237 0.237 /data/fact/current/libs/framework/WebApp.py:399(getHeaderDict) 1 0.000 0.000 0.232 0.232 /data/fact/current/libs/framework/WebManager.py:89(createNewHandler) 1 0.000 0.000 0.232 0.232 /data/fact/current/libs/framework/WebSite.py:92(__init__) 84 0.001 0.000 0.220 0.003 /data/fact/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 27 0.000 0.000 0.214 0.008 /data/fact/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 1 0.000 0.000 0.211 0.211 /data/fact/current/libs/framework/WebApp.py:494(getSupportCenterContent) 1 0.000 0.000 0.206 0.206 /data/fact/current/libs/utils/supportCenter.py:9(getSupportCenterArticles) 1 0.000 0.000 0.182 0.182 /usr/lib/python3.11/urllib/request.py:1376(http_open) 1 0.000 0.000 0.181 0.181 /data/fact/current/libs/framework/WebForm.py:95(__init__) 1721/1709 0.002 0.000 0.180 0.000 /data/fact/current/libs/framework/LazyDict.py:186(__getitem__) 3 0.000 0.000 0.177 0.059 /usr/lib/python3.11/http/client.py:1300(request) 3 0.000 0.000 0.177 0.059 /usr/lib/python3.11/http/client.py:1305(_send_request) 2 0.000 0.000 0.177 0.089 /data/fact/current/libs/framework/WebForm.py:2883(getViewDG) 2 0.000 0.000 0.177 0.089 /data/fact/current/generic/sites/www/users_only/store/ShoppingCartForm.py:369(_getDGByName) 1 0.000 0.000 0.177 0.177 /data/fact/current/libs/framework/WebForm.py:149(getDGGreedyAssocs) 2 0.000 0.000 0.177 0.089 /data/fact/current/libs/framework/WebSite.py:973(getDGByName) 2 0.000 0.000 0.177 0.089 /data/fact/current/libs/framework/LazyDict.py:172(get) 12/1 0.000 0.000 0.177 0.177 /data/fact/current/libs/framework/BaseHandler.py:470(_createDisplayGroup) 3 0.000 0.000 0.177 0.059 /usr/lib/python3.11/http/client.py:1287(endheaders) 3 0.000 0.000 0.177 0.059 /usr/lib/python3.11/http/client.py:1049(_send_output) 3 0.000 0.000 0.177 0.059 /usr/lib/python3.11/http/client.py:988(send) 3/2 0.000 0.000 0.175 0.087 /usr/lib/python3.11/urllib/request.py:628(http_response) 1 0.000 0.000 0.175 0.175 /usr/lib/python3.11/urllib/request.py:544(error) 1 0.000 0.000 0.175 0.175 /usr/lib/python3.11/urllib/request.py:691(http_error_302) 84/1 0.000 0.000 0.171 0.171 /data/fact/current/libs/framework/DisplayGroup.py:631(_createDGE) 1 0.000 0.000 0.171 0.171 /data/fact/current/libs/framework/DisplayGroup.py:835(_createDGEGroup) 36 0.000 0.000 0.169 0.005 /data/fact/current/libs/PLayer/PersistentBroker.py:336(processSql) 209/135 0.001 0.000 0.162 0.001 :666(_load_unlocked) 3 0.000 0.000 0.162 0.054 /usr/lib/python3.11/http/client.py:959(connect) 3 0.000 0.000 0.162 0.054 /usr/lib/python3.11/socket.py:821(create_connection) 200/127 0.001 0.000 0.159 0.001 :1165(_find_and_load) 4/1 0.000 0.000 0.159 0.159 /data/fact/current/libs/framework/DGEAssocList.py:380(getBBTDictionary) 6/1 0.000 0.000 0.159 0.159 /data/fact/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 3 0.000 0.000 0.159 0.053 /usr/lib/python3.11/socket.py:957(getaddrinfo) 3 0.159 0.053 0.159 0.053 {built-in method _socket.getaddrinfo} 344/160 0.004 0.000 0.158 0.001 {built-in method builtins.exec} 207/135 0.000 0.000 0.157 0.001 :934(exec_module) 200/127 0.001 0.000 0.157 0.001 :1120(_find_and_load_unlocked) 72 0.000 0.000 0.143 0.002 /data/fact/current/libs/framework/DisplayGroup.py:707(_createDGEAttribute) 12 0.000 0.000 0.143 0.012 /data/fact/current/libs/framework/WebManInterface.py:57(getWebSelectByName) 12 0.000 0.000 0.143 0.012 /data/fact/current/libs/framework/WebManInterface.py:37(readWebSelect) 63 0.000 0.000 0.134 0.002 /data/fact/current/libs/framework/DGEAttribute.py:58(getEditHTML) 10/3 0.000 0.000 0.132 0.044 /data/fact/current/libs/framework/DisplayGroup.py:766(_createDGEAssoc) 434/256 0.000 0.000 0.131 0.001 :233(_call_with_frames_removed) 1 0.004 0.004 0.122 0.122 /data/fact/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 3 0.000 0.000 0.110 0.037 /data/fact/current/libs/PLayer/PersistentBroker.py:770(processCriteria) 249 0.001 0.000 0.106 0.000 /data/fact/current/libs/framework/DGEAttribute.py:207(getValue) 63 0.000 0.000 0.105 0.002 /data/fact/current/libs/framework/DGEAttribute.py:45(massageDictForEditHTML) 12 0.000 0.000 0.101 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.100 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 9772/9337 0.006 0.000 0.100 0.000 /data/fact/current/libs/framework/BaseHandler.py:1458(mxxImporter) 12 0.000 0.000 0.100 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 1 0.000 0.000 0.100 0.100 /data/fact/current/generic/sites/www/forms/store/ShoppingCartFormPublic.py:269(getPO) 12 0.000 0.000 0.098 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 0.098 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 12 0.004 0.000 0.097 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 264/261 0.000 0.000 0.097 0.000 /data/fact/current/libs/PLayer/PersistentObject.py:2675(__getattr__) 21 0.000 0.000 0.097 0.005 /data/fact/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 20 0.000 0.000 0.096 0.005 /data/fact/current/libs/PLayer/PersistentObject.py:2912(_loadAssoc) 175 0.001 0.000 0.096 0.001 /data/fact/current/libs/framework/DTWrapper.py:47(__call__) 20 0.000 0.000 0.096 0.005 /data/fact/current/libs/PLayer/PersistentObject.py:2978(_loadAssocSQL) 175 0.002 0.000 0.095 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 9795/9341 0.006 0.000 0.094 0.000 {built-in method builtins.__import__} 1 0.000 0.000 0.087 0.087 /data/fact/current/libs/framework/baseScrapeAndDrape.py:526(_addStylesAndScripts) 16 0.000 0.000 0.077 0.005 /data/fact/current/libs/utils/htmlTools.py:100(cleanHTML) 9042/8857 0.004 0.000 0.074 0.000 {built-in method builtins.getattr} 1 0.000 0.000 0.072 0.072 /data/fact/current/libs/framework/DisplayGroup.py:311(initialize) 2 0.001 0.000 0.072 0.036 /data/fact/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 2 0.000 0.000 0.071 0.036 /data/fact/current/libs/framework/baseScrapeAndDrape.py:358(rebuildSoup) 8 0.004 0.001 0.070 0.009 /data/fact/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile)

Shopping Cart

Services

About

Help and Advice

Phone

Address

fact@factglobal.org