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

1 call
0 rows

0.091

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

0.003

1 call
0 rows

0.003

COMMIT

0.002

16 calls
1 row

0.000

SELECT version from databasemap;

0.001

1 call
244 rows

0.001

SELECT * FROM Country ORDER BY orderindex, id

0.001

2 calls
1 row

0.000

select max(returnOrder) from Stack where sessionId = 5296890825449698223

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

0.001

1 call
0 rows

0.001

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

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
0 rows

0.000

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

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 (Batch, Payment) WHERE `Payment`.`PaymentId`=0x22AC5C0000000C AND `Payment`.`BatchId`=`Batch`.`BatchId` ORDER BY `Batch`.`dateOfPayments`, `Batch`.`batchNumber`

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`=0x22AC5C0000000A

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

0.000

1 call
158 rows

0.000

SELECT * FROM webselect

0.000

2 calls
5 rows

0.000

SELECT * FROM ShipType ORDER BY orderindex, id

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`=0x22AC5C0000000A

0.000

1 call
0 rows

0.000

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`=0x22AC5C00000001

0.000

1 call
54 rows

0.000

SELECT * FROM StateProvince 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
3 rows

0.000

SELECT * FROM PriceType ORDER BY orderindex, id

0.000

2 calls
1 row

0.000

select count(*) c from ProcessorAccount

0.000

1 call
4 rows

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`=0x22AC5C00000001 AND `Purchase`.`ShipMethodId`=`ShipMethod`.`ShipMethodId` ORDER BY orderIndex

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 (Sponsor, Invoice) WHERE `Sponsor`.`InvoiceId`=`Invoice`.`InvoiceId` AND `Invoice`.`InvoiceId`=0x22AC5C0000000A

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`=0x22AC5C0000000A

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(`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`=0x22AC5C00000002 AND `OrderItem`.`OrderId`=`Purchase`.`PurchaseId` ORDER BY `Purchase`.`dateSubmitted` DESC, `Purchase`.`mxxCreated` 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 (Committee, MailingList) WHERE `MailingList`.`CommitteeId`=`Committee`.`CommitteeId` AND `MailingList`.`MailingListId`=0x22AC5C00000009 ORDER BY `Committee`.`name`

0.000

1 call
8 rows

0.000

SELECT * FROM PurchaseSource ORDER BY orderindex, id

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(`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, Invoice) WHERE `Purchase`.`InvoiceId`=`Invoice`.`InvoiceId` AND `Invoice`.`InvoiceId`=0x22AC5C0000000A ORDER BY `Purchase`.`dateSubmitted` DESC, `Purchase`.`mxxCreated` DESC

0.000

1 call
0 rows

0.000

1 call
3 rows

0.000

SELECT * FROM PaymentStatus 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`=0x22AC5C00000001 AND `Purchase`.`ShippingAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2025-08-17 00:18:23',`mxxCreatedBy`=NULL, `PageRequestId`=0x22AC5C00000000, `path`='forms/store/ShoppingCartFormPublic/view', `formName`='ShoppingCartFormPublic', `site`='www', `clientAcronym`='FACT', `pid`='2044786', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.fact.maxx.matrixdev.net', `dbThreadId`='166896', `startTime`='2025-08-17 00:18:23', `sessionId`=0x4982562440F473AF, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.186'

0.000

1 call
7 rows

0.000

SELECT * FROM PaymentType 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 (Pledge, Invoice) WHERE `Pledge`.`InvoiceId`=`Invoice`.`InvoiceId` AND `Invoice`.`InvoiceId`=0x22AC5C0000000A 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 (Payment, Address) WHERE `Payment`.`PaymentId`=0x22AC5C0000000C AND `Payment`.`billingAddressId`=`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 (Purchase, Address) WHERE `Purchase`.`PurchaseId`=0x22AC5C00000001 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`=0x22AC5C0000000E AND `Address`.`BranchId`=`Branch`.`BranchId` ORDER BY `Branch`.`isMain`, `Branch`.`name`

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

519646 function calls (511685 primitive calls) in 0.666 seconds Ordered by: cumulative time List reduced from 2366 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 0.666 0.666 /data/fact/current/libs/framework/WebManager.py:136(_newRequest) 1 0.000 0.000 0.417 0.417 /data/fact/current/libs/framework/WebSite.py:168(processRequest) 1 0.000 0.000 0.386 0.386 /data/fact/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 0.386 0.386 /data/fact/current/generic/sites/www/forms/store/ShoppingCartFormPublic.py:176(view) 1 0.000 0.000 0.285 0.285 /data/fact/current/libs/framework/WebForm.py:190(view) 1 0.000 0.000 0.240 0.240 /data/fact/current/libs/framework/WebManager.py:90(createNewHandler) 1 0.000 0.000 0.240 0.240 /data/fact/current/libs/framework/WebSite.py:92(__init__) 1 0.000 0.000 0.189 0.189 /data/fact/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 1 0.000 0.000 0.189 0.189 /data/fact/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 84 0.001 0.000 0.177 0.002 /data/fact/current/libs/framework/DGEAttribute.py:139(getBBTDictionary) 6/4 0.000 0.000 0.171 0.043 /data/fact/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 345/161 0.004 0.000 0.148 0.001 {built-in method builtins.exec} 200/127 0.001 0.000 0.146 0.001 :1165(_find_and_load) 200/127 0.001 0.000 0.143 0.001 :1120(_find_and_load_unlocked) 209/135 0.001 0.000 0.137 0.001 :666(_load_unlocked) 208/136 0.000 0.000 0.132 0.001 :934(exec_module) 88 0.000 0.000 0.129 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 88 0.000 0.000 0.129 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 1 0.004 0.004 0.127 0.127 /data/fact/current/libs/framework/BaseHandler.py:452(_loadDisplayGroups) 435/257 0.000 0.000 0.121 0.000 :233(_call_with_frames_removed) 88 0.000 0.000 0.115 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 88 0.115 0.001 0.115 0.001 {function Connection.query at 0xf9e07b40fa60} 4/1 0.000 0.000 0.114 0.114 /data/fact/current/libs/framework/DGEAssocList.py:380(getBBTDictionary) 6/1 0.000 0.000 0.114 0.114 /data/fact/current/libs/framework/DGEAssocList.py:452(getDataDictionary) 27 0.000 0.000 0.100 0.004 /data/fact/current/libs/PLayer/PersistentBroker.py:267(processSqlList) 63 0.000 0.000 0.098 0.002 /data/fact/current/libs/framework/DGEAttribute.py:58(getEditHTML) 3 0.000 0.000 0.094 0.031 /data/fact/current/libs/PLayer/PersistentBroker.py:770(processCriteria) 1 0.000 0.000 0.092 0.092 /data/fact/current/generic/sites/www/forms/store/ShoppingCartFormPublic.py:269(getPO) 1 0.000 0.000 0.091 0.091 /data/fact/current/libs/framework/WebApp.py:277(writeHTMLWithWrap) 1 0.000 0.000 0.090 0.090 /data/fact/current/libs/framework/WebApp.py:213(wrapHTML) 174 0.001 0.000 0.081 0.000 /data/fact/current/libs/framework/DTWrapper.py:47(__call__) 174 0.001 0.000 0.080 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 16 0.000 0.000 0.078 0.005 /data/fact/current/libs/utils/htmlTools.py:100(cleanHTML) 3545/3111 0.002 0.000 0.078 0.000 /data/fact/current/libs/framework/BaseHandler.py:1458(mxxImporter) 3568/3115 0.003 0.000 0.076 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.074 0.037 /data/fact/current/libs/framework/BaseHandler.py:977(checkAndReloadOptionsFromXML) 8 0.005 0.001 0.072 0.009 /data/fact/current/libs/framework/BaseHandler.py:1150(loadSettingsFromFile) 249 0.001 0.000 0.072 0.000 /data/fact/current/libs/framework/DGEAttribute.py:207(getValue) 48 0.000 0.000 0.072 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 49 0.000 0.000 0.072 0.001 /usr/lib/python3.11/re/__init__.py:272(_compile) 36 0.000 0.000 0.071 0.002 /usr/lib/python3.11/re/_compiler.py:740(compile) 63 0.000 0.000 0.071 0.001 /data/fact/current/libs/framework/DGEAttribute.py:45(massageDictForEditHTML) 8 0.054 0.007 0.067 0.008 /data/fact/current/libs/utils/maxxConfigHelper.py:58(extractSiteSettingsLXML) 46 0.000 0.000 0.065 0.001 /data/fact/current/libs/framework/DGEInput.py:29(massageDictForEditHTML) 1 0.000 0.000 0.057 0.057 /data/fact/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 548/174 0.001 0.000 0.054 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 959/174 0.009 0.000 0.053 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 36 0.000 0.000 0.051 0.001 /usr/lib/python3.11/re/_compiler.py:573(_code) 1 0.000 0.000 0.050 0.050 /data/fact/current/libs/framework/DGEMethodList.py:240(getBBTDictionary) 1 0.000 0.000 0.050 0.050 /data/fact/current/libs/framework/DGEMethodList.py:257(getDataDictionary) 5928 0.042 0.000 0.046 0.000 /data/fact/current/libs/framework/LazyDict.py:71(__setitem__) 109 0.041 0.000 0.042 0.000 /usr/lib/python3.11/re/_compiler.py:243(_optimize_charset) 1 0.000 0.000 0.041 0.041 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 14 0.001 0.000 0.039 0.003 /data/fact/current/libs/framework/DGESelect.py:36(getEditHTML) 1 0.000 0.000 0.037 0.037 /data/fact/current/libs/framework/DGEEmail.py:1() 1 0.000 0.000 0.037 0.037 /data/fact/current/libs/framework/WebManInterface.py:92(createBroker) 91/73 0.000 0.000 0.036 0.000 /data/fact/current/libs/PLayer/PersistentBroker.py:78(__new__) 1 0.000 0.000 0.035 0.035 /data/fact/current/libs/framework/baseScrapeAndDrape.py:268(scrape) 1 0.000 0.000 0.035 0.035 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/email_validator/__init__.py:1() 1 0.000 0.000 0.035 0.035 /data/fact/current/libs/framework/baseScrapeAndDrape.py:243(getStubFromCache) 1 0.000 0.000 0.034 0.034 /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/bs4/__init__.py:115(__init__) 1 0.000 0.000 0.034 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 1 0.000 0.000 0.034 0.034 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 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/bleach/linkifier.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() 798/36 0.004 0.000 0.033 0.001 /usr/lib/python3.11/re/_compiler.py:37(_compile) 1 0.000 0.000 0.033 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 1 0.000 0.000 0.033 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 1 0.001 0.001 0.033 0.033 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 1 0.000 0.000 0.033 0.033 /data/fact/current/libs/framework/baseScrapeAndDrape.py:714(process) 1 0.011 0.011 0.033 0.033 /data/fact/current/libs/PLayer/PersistentBroker.py:442(retrieveClassMaps) 356/314 0.000 0.000 0.031 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) 208 0.002 0.000 0.025 0.000 :1007(get_code) 14 0.000 0.000 0.021 0.002 /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.021 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:385(cook) 111/13 0.001 0.000 0.020 0.002 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:177(parse) 1 0.000 0.000 0.020 0.020 /data/fact/current/libs/framework/WebApp.py:399(getHeaderDict) 1232 0.003 0.000 0.019 0.000 /data/fact/current/libs/framework/MaxxDTML.py:29(render) 36 0.000 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:979(parse) 115/36 0.001 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:456(_parse_sub) 714/36 0.007 0.000 0.019 0.001 /usr/lib/python3.11/re/_parser.py:516(_parse) 36 0.000 0.000 0.017 0.000 /usr/lib/python3.11/re/_compiler.py:511(_compile_info) 199 0.002 0.000 0.016 0.000 :1054(_find_spec) 2437 0.002 0.000 0.016 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:373(__getitem__) 17720 0.016 0.000 0.016 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:350(__getattribute__) 1 0.000 0.000 0.016 0.016 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/html5lib_shim.py:1() 34 0.000 0.000 0.015 0.000 /data/fact/current/libs/framework/BaseHandler.py:1327(importModule) 2 0.000 0.000 0.015 0.008 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:30(clean) 28 0.001 0.000 0.015 0.001 /data/fact/current/libs/framework/BaseHandler.py:311(getTemplate) 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__) 282/281 0.005 0.000 0.014 0.000 {built-in method builtins.__build_class__} 1714/1702 0.002 0.000 0.014 0.000 /data/fact/current/libs/framework/LazyDict.py:186(__getitem__) 815 0.002 0.000 0.014 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 7878 0.006 0.000 0.014 0.000 /data/fact/current/libs/utils/maxxConfigHelper.py:39(_extractSetting)

Shopping Cart

Services

About

Help and Advice

Phone

Address

fact@factglobal.org