Store

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

1 call
0 rows

0.020

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`.`numFTEmployees`, `Application`.`numPTEmployees`, `Application`.`numberOfPayments`, `Application`.`otherIssues`, `Application`.`annualSales`, `Application`.`isPubliclyTraded`, `Application`.`brands`, `Application`.`otherProductCategory`, `Application`.`yearEstablished`, `Application`.`totalEnrollment`, `Application`.`enroll_P`, `Application`.`enroll_K`, `Application`.`enroll_1`, `Application`.`enroll_2`, `Application`.`enroll_3`, `Application`.`enroll_4`, `Application`.`enroll_5`, `Application`.`enroll_6`, `Application`.`enroll_7`, `Application`.`enroll_8`, `Application`.`enroll_9`, `Application`.`enroll_10`, `Application`.`enroll_11`, `Application`.`enroll_12`, `Application`.`enroll_PG`, `Application`.`sepIncorp`, `Application`.`studentBodyGender`, `Application`.`dayBoarding`, `Application`.`accreditedBy`, `Application`.`has_1`, `Application`.`has_2`, `Application`.`has_3`, `Application`.`has_4`, `Application`.`has_5`, `Application`.`has_6`, `Application`.`has_7`, `Application`.`has_8`, `Application`.`has_9`, `Application`.`has_10`, `Application`.`has_11`, `Application`.`has_12`, `Application`.`has_P`, `Application`.`has_K`, `Application`.`has_PG`, `Application`.`staffing`, `Application`.`pctEpiscopal`, `Application`.`percentMale`, `Application`.`percentFemale`, `Application`.`percentCauc`, `Application`.`percentAfAm`, `Application`.`percentAsAm`, `Application`.`percentNatAm`, `Application`.`percentHisp`, `Application`.`percentOtherRace`, `Application`.`percentFinAid`, `Application`.`FPercentEpi`, `Application`.`FPercentMale`, `Application`.`FPercentFemale`, `Application`.`FpercentCauc`, `Application`.`FpercentAfAm`, `Application`.`FpercentAsAm`, `Application`.`FpercentNatAm`, `Application`.`FpercentHisp`, `Application`.`FpercentOtherRace`, `Application`.`totalFinAid`, `Application`.`companyStruct`, `Application`.`source`, `Application`.`sourceOther`, `Application`.`howHeardAboutOther`, `Application`.`hasNonDiscriminationPolicy`, `Application`.`hasDiversityPolicy`, `Application`.`nonDiscriminationPolicyDate`, `Application`.`diversityPolicyDate`, `Application`.`isUnapproved`, `Application`.`dateCancelled`, hex(`Application`.`_suggestedDues`) AS `_suggestedDues`, `Application`.`dateSubmitted`, `Application`.`_optionalMembershipFeeCustom`, `Application`.`dateEmailSent`, `Application`.`numAdditionalMembers`, `Application`.`FpercentPacIslander`, `Application`.`percentPacIslander`, `Application`.`totalValueOfNonSchoolAid`, `Application`.`totalValueOfTuitionRemission`, `Application`.`totalValueOfCashAid`, `Application`.`aidPercentTuition`, `Application`.`hasTuitionRemissionForFaculty`, `Application`.`hasTuitionDiscountForParishChildren`, `Application`.`dateBalanceDueEmailSent`, `Application`.`datePaymentReceivedEmailSent`, `Application`.`finePrint`, `Application`.`priorYearNetTuitionRevenue`, `Application`.`duesBudget`, `Application`.`dateWelcomeEmailSent`, `Application`.`dateCancellationEmailSent`, `Application`.`marketingCode`, `Application`.`dateActivatedMembership`, `Application`.`hasActivatedMembership`, `Application`.`categoryOfSchool`, `Application`.`mxxCreated`, `Application`.`isAuthorizedBySchool`, `Application`.`overrideAddressText`, `Application`.`overrideCompanyName`, `Application`.`chargeEUSADues` FROM (Invoice, Application) WHERE `Application`.`InvoiceId`=`Invoice`.`InvoiceId` AND `Invoice`.`InvoiceId`=0x67968D0000000A ORDER BY `Application`.`applicationDate`

0.016

15 calls
1 row

0.001

SELECT version from databasemap;

0.014

1 call
0 rows

0.014

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

0.011

1 call
0 rows

0.011

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`.`fedExNumber`, `Purchase`.`isInternal`, `Purchase`.`dateSentToTASCO`, `Purchase`.`dateSentToVideoFiles`, `Purchase`.`tax`, `Purchase`.`shipping`, `Purchase`.`shippingName`, `Purchase`.`shipToCompany`, `Purchase`.`shipToTitle`, `Purchase`.`otherShipSpecs`, `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`=4535363582689983513 AND `Purchase`.`IndividualId` is NULL) AND `Purchase`.`orderStatus`=1) ORDER BY `Purchase`.`dateSubmitted` DESC, `Purchase`.`mxxCreated` DESC

0.011

1 call
0 rows

0.011

SELECT DISTINCT hex(`Pledge`.`PledgeId`) AS `PledgeId`, `Pledge`.`dateOfPledge`, `Pledge`.`donorSalutation`, `Pledge`.`arrangerSalutation`, `Pledge`.`anonumous`, `Pledge`.`pledgeType`, `Pledge`.`donorType`, `Pledge`.`year`, `Pledge`.`amount`, `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`.`dateCancelled`, `Pledge`.`source`, `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`=0x67968D0000000A ORDER BY dateOfPledge DESC

0.009

1 call
0 rows

0.009

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

0.009

1 call
0 rows

0.009

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

0.008

1 call
0 rows

0.008

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`.`dateCancelled`, `Exhibit`.`isWaitlisted`, `Exhibit`.`marketingCode`, `Exhibit`.`dateBalanceDueEmailSent`, `Exhibit`.`datePaymentReceivedEmailSent`, `Exhibit`.`dateCancelEmailLastSent`, `Exhibit`.`mxxCreated` FROM (Invoice, Exhibit) WHERE `Exhibit`.`InvoiceId`=`Invoice`.`InvoiceId` AND `Invoice`.`InvoiceId`=0x67968D0000000A

0.008

1 call
0 rows

0.008

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

0.007

2 calls
1 row

0.003

select max(returnOrder) from Stack where sessionId = 4535363582689983513

0.006

1 call
0 rows

0.006

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

0.006

1 call
0 rows

0.006

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`=0x67968D00000002 AND `OrderItem`.`PriceId`=`ProductPrice`.`ProductPriceId` ORDER BY ProductPrice.description NOT LIKE 'Member%', ProductPrice.description NOT LIKE '%Corporate%', ProductPrice.description NOT LIKE '%Guest%', minQuantity IS NOT NULL, minQuantity, maxQuantity

0.006

2 calls
1 row

0.003

select count(*) c from ProcessorAccount

0.005

1 call
3 rows

0.005

SELECT * FROM PaymentStatus ORDER BY orderindex, id

0.005

2 calls
6 rows

0.002

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

0.005

1 call
0 rows

0.005

COMMIT

0.004

1 call
0 rows

0.004

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`.`executiveSummary`, `Product`.`TASCOId`, `Product`.`author`, `Product`.`shortDescription`, `Product`.`miniImageAltTag`, `Product`.`isFeature`, `Product`.`miniImage`, `Product`.`isTaxable`, `Product`.`WebSiteDirectory`, `Product`.`WebSiteExpirationDuration`, `Product`.`WebSiteDirectoryURL`, `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`=0x67968D00000002 AND `OrderItem`.`ProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.004

1 call
9 rows

0.004

SELECT * FROM PaymentType ORDER BY orderindex, id

0.004

1 call
0 rows

0.004

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`.`fedExNumber`, `Purchase`.`isInternal`, `Purchase`.`dateSentToTASCO`, `Purchase`.`dateSentToVideoFiles`, `Purchase`.`tax`, `Purchase`.`shipping`, `Purchase`.`shippingName`, `Purchase`.`shipToCompany`, `Purchase`.`shipToTitle`, `Purchase`.`otherShipSpecs`, `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`=0x67968D0000000A ORDER BY `Purchase`.`dateSubmitted` DESC, `Purchase`.`mxxCreated` DESC

0.004

1 call
4 rows

0.004

SELECT * FROM ProductType ORDER BY orderindex, id

0.004

1 call
3 rows

0.004

SELECT * FROM CreditCardType ORDER BY orderindex, id

0.003

1 call
2 rows

0.003

SELECT * FROM FulfillmentStatus ORDER BY orderindex, id

0.003

1 call
0 rows

0.003

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

0.002

2 calls
5 rows

0.001

SELECT * FROM ShipType ORDER BY orderindex, id

0.002

1 call
8 rows

0.002

SELECT * FROM PurchaseSource ORDER BY orderindex, id

0.002

1 call
3 rows

0.002

SELECT * FROM PriceType ORDER BY orderindex, id

0.002

1 call
0 rows

0.002

1 call
2 rows

0.002

SELECT * FROM YesNo ORDER BY orderindex, id

0.002

1 call
0 rows

0.002

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`.`fedExNumber`, `Purchase`.`isInternal`, `Purchase`.`dateSentToTASCO`, `Purchase`.`dateSentToVideoFiles`, `Purchase`.`tax`, `Purchase`.`shipping`, `Purchase`.`shippingName`, `Purchase`.`shipToCompany`, `Purchase`.`shipToTitle`, `Purchase`.`otherShipSpecs`, `Purchase`.`comments`, `Purchase`.`internalComments`, `Purchase`.`site`, `Purchase`.`dateCancelled`, `Purchase`.`dateLetterSent`, `Purchase`.`dateFulfillmentConfirmationSent`, `Purchase`.`dateCancellationEmailSent`, `Purchase`.`dateBalanceDueEmailSent`, `Purchase`.`datePaymentReceivedEmailSent`, `Purchase`.`createdOnWWW`, `Purchase`.`mxxCreated` FROM (Purchase, OrderItem) WHERE `OrderItem`.`OrderItemId`=0x67968D00000002 AND `OrderItem`.`OrderId`=`Purchase`.`PurchaseId` ORDER BY `Purchase`.`dateSubmitted` DESC, `Purchase`.`mxxCreated` DESC

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`.`SADateCancelled`, `Invoice`.`_SABalance`, `Invoice`.`_SAAmountAR`, `Invoice`.`_SAAmountAP`, `Invoice`.`_SAAmountPaid`, `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`=0x67968D00000001

0.001

1 call
241 rows

0.001

SELECT * FROM Country ORDER BY orderindex, id

0.001

1 call
54 rows

0.001

SELECT * FROM StateProvince 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`.`isTrainer`, `Individual`.`dontEmail`, `Individual`.`preferredMethodOfComm`, `Individual`.`mxxCreated`, `Individual`.`jobLevel`, `Individual`.`publishInDirectory`, `Individual`.`individualNum`, `Individual`.`birthDay`, `Individual`.`maritalStatus`, `Individual`.`hasChildren`, `Individual`.`degreeLevel`, `Individual`.`designations`, `Individual`.`yearJoined`, `Individual`.`interestInMentoring`, `Individual`.`availableToSpeak`, `Individual`.`ageGroup`, `Individual`.`officeType`, `Individual`.`otherJobFunction`, `Individual`.`formalSalutation`, `Individual`.`numberOfChildren`, `Individual`.`namesOfChildren`, `Individual`.`groupAffiliations`, `Individual`.`donorInterests`, `Individual`.`episcopalianSchoolAlumnus`, `Individual`.`schoolAttended`, `Individual`.`relatedToStudent`, `Individual`.`schoolStudentAttends`, `Individual`.`religiousAffiliation`, `Individual`.`networkFormat`, `Individual`.`SACompanyName`, `Individual`.`dontSnailmail`, `Individual`.`recordOrigin`, `Individual`.`source`, `Individual`.`sourceOther`, `Individual`.`prospectStatus`, `Individual`.`canSpamSet`, hex(`Individual`.`mxxCreatedBy`) AS `mxxCreatedBy`, `Individual`.`orderOfMinistry`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`muhlenbergSocietyDonor`, `Individual`.`congressParty`, `Individual`.`donorSalutation`, `Individual`.`donorEnvelopeName`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`includeOnMemberOnlyComms`, `Individual`.`ancestryEthnicitiesOther`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (Purchase, Individual) WHERE `Purchase`.`PurchaseId`=0x67968D00000001 AND `Purchase`.`IndividualId`=`Individual`.`IndividualId` ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.001

1 call
0 rows

0.001

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

0.001

1 call
175 rows

0.001

SELECT * FROM webselect

0.001

1 call
0 rows

0.001

INSERT INTO `PageRequest` SET `mxxCreated`='2026-02-27 20:12:02',`mxxCreatedBy`=NULL, `PageRequestId`=0x67968D00000000, `path`='forms/store/ShoppingCartFormPublic/view', `formName`='ShoppingCartFormPublic', `site`='www', `clientAcronym`='NAES', `pid`='3360529', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.naes.maxx.matrixdev.net', `dbThreadId`='53193', `startTime`='2026-02-27 20:12:02', `sessionId`=0x3EF0D926297ABC19, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.211'

0.001

1 call
0 rows

0.001

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

0.001

1 call
0 rows

0.001

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 (Address, Payment) WHERE `Payment`.`PaymentId`=0x67968D0000000C 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`=0x67968D00000001 AND `Purchase`.`BillingAddressId`=`Address`.`AddressId` ORDER BY `Address`.`zip`

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

START TRANSACTION

1084627 function calls (1072505 primitive calls) in 4.535 seconds Ordered by: cumulative time List reduced from 2575 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 4.536 4.536 /data/naes/current/libs/framework/WebManager.py:134(_newRequest) 1 0.000 0.000 4.201 4.201 /data/naes/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 4.091 4.091 /data/naes/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 4.091 4.091 /data/naes/current/generic/sites/www/forms/store/ShoppingCartFormPublic.py:176(view) 1 0.000 0.000 4.062 4.062 /data/naes/current/libs/framework/WebForm.py:189(view) 1 0.000 0.000 3.377 3.377 /data/naes/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 1 0.000 0.000 3.377 3.377 /data/naes/current/libs/framework/WebApp.py:212(wrapHTML) 1 0.000 0.000 3.208 3.208 /data/naes/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 3.207 3.207 /data/naes/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 1 0.000 0.000 2.348 2.348 /usr/lib/python3.11/urllib/request.py:139(urlopen) 2/1 0.000 0.000 2.347 2.347 /usr/lib/python3.11/urllib/request.py:500(open) 5/3 0.000 0.000 2.347 0.782 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 2 0.000 0.000 2.346 1.173 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 2.346 1.173 /usr/lib/python3.11/urllib/request.py:1390(https_open) 2 0.000 0.000 2.346 1.173 /usr/lib/python3.11/urllib/request.py:1307(do_open) 65 0.011 0.000 2.072 0.032 {method 'readline' of '_io.BufferedReader' objects} 11 0.000 0.000 2.069 0.188 /usr/lib/python3.11/socket.py:704(readinto) 11 0.000 0.000 2.069 0.188 /usr/lib/python3.11/ssl.py:1299(recv_into) 11 0.000 0.000 2.069 0.188 /usr/lib/python3.11/ssl.py:1157(read) 11 2.069 0.188 2.069 0.188 {method 'read' of '_ssl._SSLSocket' objects} 2 0.000 0.000 2.062 1.031 /usr/lib/python3.11/http/client.py:1351(getresponse) 2 0.000 0.000 2.062 1.031 /usr/lib/python3.11/http/client.py:318(begin) 2 0.000 0.000 2.061 1.031 /usr/lib/python3.11/http/client.py:285(_read_status) 2/1 0.000 0.000 1.572 1.572 /usr/lib/python3.11/urllib/request.py:628(http_response) 1 0.000 0.000 1.572 1.572 /usr/lib/python3.11/urllib/request.py:544(error) 1 0.000 0.000 1.572 1.572 /usr/lib/python3.11/urllib/request.py:691(http_error_302) 1 0.000 0.000 0.657 0.657 /data/naes/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 1 0.000 0.000 0.657 0.657 /data/naes/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 12 0.000 0.000 0.643 0.054 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.642 0.053 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 12 0.002 0.000 0.642 0.053 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 12 0.000 0.000 0.633 0.053 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 0.633 0.053 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 12 0.023 0.002 0.632 0.053 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 6/4 0.000 0.000 0.602 0.150 /data/naes/current/libs/framework/DGEAssoc.py:120(getBBTDictionary) 84 0.001 0.000 0.546 0.007 /data/naes/current/libs/framework/DGEAttribute.py:138(getBBTDictionary) 1 0.000 0.000 0.470 0.470 /data/naes/current/libs/framework/baseScrapeAndDrape.py:530(_addStylesAndScripts) 2 0.000 0.000 0.421 0.211 /data/naes/current/libs/framework/baseScrapeAndDrape.py:362(rebuildSoup) 4/1 0.000 0.000 0.352 0.352 /data/naes/current/libs/framework/DGEAssocList.py:379(getBBTDictionary) 6/1 0.000 0.000 0.352 0.352 /data/naes/current/libs/framework/DGEAssocList.py:451(getDataDictionary) 202/128 0.003 0.000 0.330 0.003 :1165(_find_and_load) 345/161 0.005 0.000 0.329 0.002 {built-in method builtins.exec} 202/128 0.001 0.000 0.325 0.003 :1120(_find_and_load_unlocked) 1 0.000 0.000 0.315 0.315 /data/naes/current/libs/framework/WebManager.py:88(createNewHandler) 1 0.002 0.002 0.315 0.315 /data/naes/current/libs/framework/WebSite.py:91(__init__) 4267 0.042 0.000 0.300 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 209/135 0.001 0.000 0.292 0.002 :666(_load_unlocked) 208/136 0.001 0.000 0.290 0.002 :934(exec_module) 63 0.001 0.000 0.288 0.005 /data/naes/current/libs/framework/DGEAttribute.py:57(getEditHTML) 20760/20328 0.018 0.000 0.260 0.000 /data/naes/current/libs/framework/BaseHandler.py:1471(mxxImporter) 437/258 0.000 0.000 0.259 0.001 :233(_call_with_frames_removed) 84 0.001 0.000 0.254 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 84 0.001 0.000 0.253 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 1 0.000 0.000 0.251 0.251 /data/naes/current/libs/framework/baseScrapeAndDrape.py:498(_includeMaxxJavascript) 15 0.000 0.000 0.244 0.016 /data/naes/current/libs/utils/htmlTools.py:100(cleanHTML) 2 0.000 0.000 0.237 0.118 /usr/lib/python3.11/http/client.py:1426(__init__) 2 0.000 0.000 0.234 0.117 /usr/lib/python3.11/ssl.py:745(create_default_context) 20784/20332 0.018 0.000 0.231 0.000 {built-in method builtins.__import__} 2 0.000 0.000 0.226 0.113 /usr/lib/python3.11/ssl.py:591(load_default_certs) 2 0.226 0.113 0.226 0.113 {method 'set_default_verify_paths' of '_ssl._SSLContext' objects} 249 0.003 0.000 0.224 0.001 /data/naes/current/libs/framework/DGEAttribute.py:206(getValue) 84 0.000 0.000 0.223 0.003 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/connections.py:250(query) 84 0.223 0.003 0.223 0.003 {function Connection.query at 0xfe4ffce1dbc0} 63 0.003 0.000 0.222 0.004 /data/naes/current/libs/framework/DGEAttribute.py:44(massageDictForEditHTML) 1 0.000 0.000 0.220 0.220 /data/naes/current/libs/framework/baseScrapeAndDrape.py:477(_includeMaxxCSS) 46 0.000 0.000 0.215 0.005 /data/naes/current/libs/framework/DGEInput.py:28(massageDictForEditHTML) 173 0.001 0.000 0.211 0.001 /data/naes/current/libs/framework/DTWrapper.py:47(__call__) 173 0.007 0.000 0.209 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 1513/1450 0.004 0.000 0.199 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag) 9 0.000 0.000 0.192 0.021 /data/naes/current/libs/framework/baseScrapeAndDrape.py:378(getElm) 9 0.000 0.000 0.192 0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 9 0.000 0.000 0.192 0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 9 0.000 0.000 0.188 0.021 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 17 0.000 0.000 0.188 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 17 0.004 0.000 0.187 0.011 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 1611 0.010 0.000 0.170 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/treebuilders/base.py:323(insertElementNormal) 1 0.000 0.000 0.169 0.169 /data/naes/current/libs/framework/baseScrapeAndDrape.py:718(process) 50 0.000 0.000 0.163 0.003 /usr/lib/python3.11/re/__init__.py:225(compile) 51 0.001 0.000 0.163 0.003 /usr/lib/python3.11/re/__init__.py:272(_compile) 40 0.000 0.000 0.162 0.004 /usr/lib/python3.11/re/_compiler.py:740(compile) 541/173 0.001 0.000 0.154 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:141(render_blocks) 1 0.000 0.000 0.153 0.153 /data/naes/current/libs/framework/DGEMethodList.py:240(getBBTDictionary) 1 0.000 0.000 0.153 0.153 /data/naes/current/libs/framework/DGEMethodList.py:257(getDataDictionary) 950/173 0.017 0.000 0.153 0.001 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/_DocumentTemplate.py:154(render_blocks_) 4796 0.008 0.000 0.148 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 1 0.005 0.005 0.140 0.140 /data/naes/current/libs/framework/BaseHandler.py:463(_loadDisplayGroups) 25 0.000 0.000 0.129 0.005 /data/naes/current/libs/PLayer/PersistentBroker.py:266(processSqlList) 1 0.000 0.000 0.126 0.126 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/__init__.py:1() 1 0.000 0.000 0.121 0.121 /data/naes/current/libs/framework/DisplayGroup.py:311(initialize) 208/205 0.000 0.000 0.118 0.001 /data/naes/current/libs/PLayer/PersistentObject.py:2704(__getattr__) 21 0.000 0.000 0.117 0.006 /data/naes/current/libs/PLayer/PersistentObject.py:2039(loadAssoc) 20 0.000 0.000 0.117 0.006 /data/naes/current/libs/PLayer/PersistentObject.py:2941(_loadAssoc) 20 0.000 0.000 0.117 0.006 /data/naes/current/libs/PLayer/PersistentObject.py:3007(_loadAssocSQL) 14 0.001 0.000 0.115 0.008 /data/naes/current/libs/framework/DGESelect.py:36(getEditHTML) 4796 0.009 0.000 0.115 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 1 0.000 0.000 0.107 0.107 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bleach/linkifier.py:1() 8538/8353 0.017 0.000 0.103 0.000 {built-in method builtins.getattr} 40 0.000 0.000 0.096 0.002 /usr/lib/python3.11/re/_compiler.py:573(_code) 490/450 0.001 0.000 0.091 0.000 :1207(_handle_fromlist) 1 0.000 0.000 0.091 0.091 /data/naes/current/libs/framework/WebManInterface.py:92(createBroker)