You can only gain access to certain items and special pricing if you have logged in. Login Now.

How to Read a Chip (NTC 2024)

Format:
Digital

PMPA Members Who Attended NTC 2024 - $0.00

PMPA Members Who Did Not Attend NTC 2024 - $75.00

Description:

Speaker: Miles Free III Fundamentals Track Job functions: engineer, estimator, setup, machinist, operator Creating chips is an essential step in producing first-pass quality parts. In this session, you will be challenged to reexamine your machining practice and what you think you know by learning to see and understand what the chips you make are telling you about your process. Attendees will leave with a richer vocabulary of chip types, conditions, and how to apply this to their work in the shop.

Product Details:

Product ID:	5302066
Publication Year:	2024
Pages, Size, or Length:	1 h 10 min

Total Time

Count

Avg Time

Query

0.006

1 call
0 rows

0.006

COMMIT

0.003

23 calls
1 row

0.000

SELECT version from databasemap;

0.002

1 call
2 rows

0.002

SELECT * FROM ProductStatus ORDER BY orderindex, id

0.002

2 calls
1 row

0.001

select max(returnOrder) from Stack where sessionId = 7189415082240897867

0.002

1 call
1 row

0.002

SELECT 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 (Product) WHERE `Product`.`ProductId`=0xC53BE00000002 ORDER BY `Product`.`name`

0.002

1 call
1 row

0.002

0.001

1 call
4 rows

0.001

SELECT * FROM Language ORDER BY orderindex, id

0.001

2 calls
1 row

0.000

select hex(mxxCreatedBy) as cby, hex(mxxUpdatedBy) as uby from Product where ProductId=0xC53BE00000002

0.000

1 call
2 rows

0.000

SELECT DISTINCT hex(`ProductPrice`.`ProductPriceId`) AS `ProductPriceId`, `ProductPrice`.`amount`, `ProductPrice`.`minQuantity`, `ProductPrice`.`maxQuantity`, `ProductPrice`.`shipType`, `ProductPrice`.`priceType`, `ProductPrice`.`description`, `ProductPrice`.`accountingCode`, `ProductPrice`.`membershipTypesLabelForWWW` FROM (Product, ProductPrice) WHERE `ProductPrice`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0xC53BE00000002 ORDER BY `ProductPrice`.`description`, `ProductPrice`.`minQuantity`

0.000

1 call
1 row

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`.`includeInPrintedMemberDirectory`, `Individual`.`rankInPrintedMemberDirectory`, `Individual`.`criticalNotes`, `Individual`.`congresspersonFor`, `Individual`.`congressParty`, `Individual`.`mailChimpMergeCache`, `Individual`.`createdOnWWW`, `Individual`.`lastCheckedNotifications`, `Individual`.`SAIsBoard`, `Individual`.`delinquentSince`, `Individual`.`isMergeProtected` FROM (User, Individual) WHERE `Individual`.`userId`=`User`.`UserId` AND `User`.`UserId`=0x8496B00000004 ORDER BY `Individual`.`lastName`, `Individual`.`firstName`, `Individual`.`middleInitial`

0.000

1 call
158 rows

0.000

SELECT * FROM webselect

0.000

1 call
0 rows

0.000

INSERT INTO `PageRequest` SET `mxxCreated`='2026-07-29 14:52:27', `mxxCreatedBy`=NULL, `PageRequestId`=0x534F6E00000000, `path`='forms/store/ProductFormPublic/read-chip-2024', `formName`='pmpa_ProductFormPublic', `site`='www', `clientAcronym`='PMPA', `pid`='166259', `requestNum`='1', `pageDictSize`=NULL, `objectId`=NULL, `templateMethod`=NULL, `growth`=NULL, `server`='www.pmpa.maxx.matrixdev.net', `dbThreadId`='36571', `startTime`='2026-07-29 14:52:27', `sessionId`=0x63C5EEED17CDF34B, `userId`=0x0, `userName`='public', `result`=NULL, `sqltime`=NULL, `timeTaken`=NULL, `dictSize`=NULL, `fields`='{}', `clientIPAddr`='216.73.216.111'

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`MailingList`.`MailingListId`) AS `MailingListId`, `MailingList`.`name`, `MailingList`.`shortName`, `MailingList`.`description`, `MailingList`.`shortDescription`, `MailingList`.`joinRule`, `MailingList`.`postRule`, `MailingList`.`deleted`, `MailingList`.`password`, `MailingList`.`welcomeText`, `MailingList`.`goodbyeText`, `MailingList`.`messageFooter`, `MailingList`.`replyDesination`, `MailingList`.`replyDesinationEmail`, `MailingList`.`maxEmailSizeKB`, `MailingList`.`moderated`, `MailingList`.`listVolume`, `MailingList`.`accessRules`, `MailingList`.`dynamic`, `MailingList`.`criteria`, `MailingList`.`ignoreDontEmail`, `MailingList`.`criteriaDict`, `MailingList`.`staffPostingOnly`, `MailingList`.`prepend`, `MailingList`.`criteriaName`, `MailingList`.`showOnMemberParticipationReport`, `MailingList`.`showParticipationOnIndividualView`, `MailingList`.`availableToCMS`, `MailingList`.`numberExcludedByDontEmail`, `MailingList`.`numberExcludedByCriteria`, `MailingList`.`numberIncludedByCriteria`, `MailingList`.`numberSubscribedAsDigest`, `MailingList`.`hasMailingList`, `MailingList`.`numberExcludedByNonMembership`, `MailingList`.`numberExcludedForNoEmail`, `MailingList`.`mailChimpListId`, `MailingList`.`hourlySync`, `MailingList`.`prettyName`, `MailingList`.`frequency`, `MailingList`.`grouping`, `MailingList`.`campaignMonitorListId` FROM (MailingList, MailingList2ProductPrice, ProductPrice) WHERE (0xC53BE00000003=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MailingList2ProductPrice`.`ProductPriceId` AND `MailingList2ProductPrice`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`

0.000

1 call
1 row

0.000

SELECT DISTINCT hex(`Category`.`CategoryId`) AS `CategoryId`, `Category`.`description`, hex(`Category`.`ParentCategoryId`) AS `ParentCategoryId` FROM (Product, Category2Product, Category) WHERE (0xC53BE00000002=`Product`.`ProductId` AND `Product`.`ProductId`=`Category2Product`.`ProductId` AND `Category2Product`.`CategoryId`=`Category`.`CategoryId`) ORDER BY `Category`.`description`

0.000

1 call
6 rows

0.000

SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (MembershipType, ProductPrice, MembershipType2ProductPrice) WHERE (0xC53BE00000003=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MembershipType2ProductPrice`.`ProductPriceId` AND `MembershipType2ProductPrice`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`

0.000

1 call
6 rows

0.000

SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (MembershipType, ProductPrice, MembershipType2ProductPrice) WHERE (0xC53BE00000004=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MembershipType2ProductPrice`.`ProductPriceId` AND `MembershipType2ProductPrice`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`

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 (Product, ProductRelation) WHERE `ProductRelation`.`ProductRelationId`=0x534F6E00000002 AND `ProductRelation`.`ParentProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.000

1 call
5 rows

0.000

SELECT * FROM Folks ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`MailingList`.`MailingListId`) AS `MailingListId`, `MailingList`.`name`, `MailingList`.`shortName`, `MailingList`.`description`, `MailingList`.`shortDescription`, `MailingList`.`joinRule`, `MailingList`.`postRule`, `MailingList`.`deleted`, `MailingList`.`password`, `MailingList`.`welcomeText`, `MailingList`.`goodbyeText`, `MailingList`.`messageFooter`, `MailingList`.`replyDesination`, `MailingList`.`replyDesinationEmail`, `MailingList`.`maxEmailSizeKB`, `MailingList`.`moderated`, `MailingList`.`listVolume`, `MailingList`.`accessRules`, `MailingList`.`dynamic`, `MailingList`.`criteria`, `MailingList`.`ignoreDontEmail`, `MailingList`.`criteriaDict`, `MailingList`.`staffPostingOnly`, `MailingList`.`prepend`, `MailingList`.`criteriaName`, `MailingList`.`showOnMemberParticipationReport`, `MailingList`.`showParticipationOnIndividualView`, `MailingList`.`availableToCMS`, `MailingList`.`numberExcludedByDontEmail`, `MailingList`.`numberExcludedByCriteria`, `MailingList`.`numberIncludedByCriteria`, `MailingList`.`numberSubscribedAsDigest`, `MailingList`.`hasMailingList`, `MailingList`.`numberExcludedByNonMembership`, `MailingList`.`numberExcludedForNoEmail`, `MailingList`.`mailChimpListId`, `MailingList`.`hourlySync`, `MailingList`.`prettyName`, `MailingList`.`frequency`, `MailingList`.`grouping`, `MailingList`.`campaignMonitorListId` FROM (MailingList, MailingList2ProductPrice, ProductPrice) WHERE (0xC53BE00000004=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`MailingList2ProductPrice`.`ProductPriceId` AND `MailingList2ProductPrice`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`

0.000

1 call
2 rows

0.000

SELECT * FROM ProductActivationStatus ORDER BY orderindex, id

0.000

1 call
7 rows

0.000

SELECT DISTINCT hex(`MembershipType`.`id`) AS `id`, `MembershipType`.`description`, `MembershipType`.`campaignCode` FROM (Product, MembershipType, MembershipType2Product) WHERE (0xC53BE00000002=`Product`.`ProductId` AND `Product`.`ProductId`=`MembershipType2Product`.`ProductId` AND `MembershipType2Product`.`id`=`MembershipType`.`id`) ORDER BY `MembershipType`.`orderindex`

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 (Product, ProductRelation) WHERE `ProductRelation`.`ProductRelationId`=0x534F6E00000002 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.000

1 call
0 rows

0.000

SELECT 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 (Product) WHERE ProductId=(select PreviousProductId from Product where ProductId = 0xC53BE00000002) ORDER BY `Product`.`name`

0.000

1 call
12 rows

0.000

SELECT * FROM Month ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Site`.`SiteId`) AS `SiteId`, `Site`.`dateDeleted`, `Site`.`face`, `Site`.`name`, `Site`.`storeFront`, `Site`.`howToOrder`, `Site`.`url` FROM (Product, Site, Product2Site) WHERE (0xC53BE00000002=`Product`.`ProductId` AND `Product`.`ProductId`=`Product2Site`.`ProductId` AND `Product2Site`.`SiteId`=`Site`.`SiteId`)

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 (Product, ProductRelation) WHERE `ProductRelation`.`ProductRelationId`=0x534F6E00000006 AND `ProductRelation`.`ParentProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.000

1 call
3 rows

0.000

SELECT * FROM PriceType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`MailingList`.`MailingListId`) AS `MailingListId`, `MailingList`.`name`, `MailingList`.`shortName`, `MailingList`.`description`, `MailingList`.`shortDescription`, `MailingList`.`joinRule`, `MailingList`.`postRule`, `MailingList`.`deleted`, `MailingList`.`password`, `MailingList`.`welcomeText`, `MailingList`.`goodbyeText`, `MailingList`.`messageFooter`, `MailingList`.`replyDesination`, `MailingList`.`replyDesinationEmail`, `MailingList`.`maxEmailSizeKB`, `MailingList`.`moderated`, `MailingList`.`listVolume`, `MailingList`.`accessRules`, `MailingList`.`dynamic`, `MailingList`.`criteria`, `MailingList`.`ignoreDontEmail`, `MailingList`.`criteriaDict`, `MailingList`.`staffPostingOnly`, `MailingList`.`prepend`, `MailingList`.`criteriaName`, `MailingList`.`showOnMemberParticipationReport`, `MailingList`.`showParticipationOnIndividualView`, `MailingList`.`availableToCMS`, `MailingList`.`numberExcludedByDontEmail`, `MailingList`.`numberExcludedByCriteria`, `MailingList`.`numberIncludedByCriteria`, `MailingList`.`numberSubscribedAsDigest`, `MailingList`.`hasMailingList`, `MailingList`.`numberExcludedByNonMembership`, `MailingList`.`numberExcludedForNoEmail`, `MailingList`.`mailChimpListId`, `MailingList`.`hourlySync`, `MailingList`.`prettyName`, `MailingList`.`frequency`, `MailingList`.`grouping`, `MailingList`.`campaignMonitorListId` FROM (Product, MailingList, Product2MailingList) WHERE (0xC53BE00000002=`Product`.`ProductId` AND `Product`.`ProductId`=`Product2MailingList`.`ProductId` AND `Product2MailingList`.`MailingListId`=`MailingList`.`MailingListId`) ORDER BY `MailingList`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (Product, SpecialOffer, ProductPrice, ProductPrice2SpecialOffer) WHERE ((`ProductPrice`.`ProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0xC53BE00000002 AND (`ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)) AND `SpecialOffer`.`expires`>'2026-07-29 14:52:27')

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 (Product, ProductRelation) WHERE `ProductRelation`.`ProductRelationId`=0x534F6E00000006 AND `ProductRelation`.`ChildProductId`=`Product`.`ProductId` ORDER BY `Product`.`name`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`ProductRelation`.`ProductRelationId`) AS `ProductRelationId` FROM (Product, ProductRelation) WHERE `ProductRelation`.`ParentProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0xC53BE00000002

0.000

2 calls
1 row

0.000

select mxxCreated, mxxUpdated from Product where ProductId=0xC53BE00000002;

0.000

1 call
18 rows

0.000

SELECT * FROM ProductType ORDER BY orderindex, id

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

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (ProductPrice, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0xC53BE00000003=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`ProductRelation`.`ProductRelationId`) AS `ProductRelationId` FROM (Product, ProductRelation) WHERE `ProductRelation`.`ChildProductId`=`Product`.`ProductId` AND `Product`.`ProductId`=0xC53BE00000002

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`File`.`FileId`) AS `FileId`, `File`.`filename`, `File`.`description`, `File`.`caption`, `File`.`altTag`, hex(`File`.`parentId`) AS `parentId` FROM (Product, File) WHERE `Product`.`downloadFileId`=`File`.`FileId` AND `Product`.`ProductId`=0xC53BE00000002

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`Site`.`SiteId`) AS `SiteId`, `Site`.`dateDeleted`, `Site`.`face`, `Site`.`name`, `Site`.`storeFront`, `Site`.`howToOrder`, `Site`.`url` FROM (Product, ProductFeaturedOn2Site, Site) WHERE (0xC53BE00000002=`Product`.`ProductId` AND `Product`.`ProductId`=`ProductFeaturedOn2Site`.`ProductId` AND `ProductFeaturedOn2Site`.`SiteId`=`Site`.`SiteId`)

0.000

2 calls
0 rows

0.000

SELECT hex(`ReportingType`.`ReportingTypeId`) AS `ReportingTypeId`, `ReportingType`.`description`, `ReportingType`.`orderindex` FROM (ReportingType) ORDER BY `ReportingType`.`orderindex` LIMIT 0, 700

0.000

1 call
5 rows

0.000

SELECT * FROM ShipType ORDER BY orderindex, id

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`SpecialOffer`.`SpecialOfferId`) AS `SpecialOfferId`, `SpecialOffer`.`discount`, `SpecialOffer`.`expires`, `SpecialOffer`.`month`, `SpecialOffer`.`description` FROM (ProductPrice, SpecialOffer, ProductPrice2SpecialOffer) WHERE (0xC53BE00000004=`ProductPrice`.`ProductPriceId` AND `ProductPrice`.`ProductPriceId`=`ProductPrice2SpecialOffer`.`ProductPriceId` AND `ProductPrice2SpecialOffer`.`SpecialOfferId`=`SpecialOffer`.`SpecialOfferId`)

0.000

1 call
1 row

0.000

SELECT hex(`User`.`UserId`) AS `UserId`, `User`.`username`, `User`.`password`, `User`.`encoding`, hex(`User`.`VotingId`) AS `VotingId`, `User`.`lastSearchType`, `User`.`oneTimeKey`, `User`.`recoverPasswordKey`, `User`.`recoverPasswordTimeout`, `User`.`disableAllNotifications`, `User`.`otCodeTime`, `User`.`otCode`, `User`.`holyGrailSections`, `User`.`emailLoginToken`, `User`.`emailLoginTokenTime` FROM (User) WHERE `User`.`UserId`=0x8496B00000004

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(`FileProtectionType`.`FileProtectionTypeId`) AS `FileProtectionTypeId`, `FileProtectionType`.`name`, `FileProtectionType`.`description`, `FileProtectionType`.`path`, `FileProtectionType`.`prefix` FROM (FileProtectionType, File) WHERE `File`.`FileId`=0x534F6E00000015 AND `File`.`fileProtectionTypeId`=`FileProtectionType`.`FileProtectionTypeId`

0.000

1 call
0 rows

0.000

SELECT DISTINCT hex(`ReportingType`.`ReportingTypeId`) AS `ReportingTypeId`, `ReportingType`.`description`, `ReportingType`.`orderindex` FROM (Product, ReportingType) WHERE `Product`.`ProductId`=0xC53BE00000002 AND `Product`.`reportingTypeId`=`ReportingType`.`ReportingTypeId` ORDER BY `ReportingType`.`orderindex`

0.000

1 call
1 row

0.000

SELECT * FROM uuid FOR UPDATE

0.000

1 call
0 rows

0.000

START TRANSACTION

1235112 function calls (1223301 primitive calls) in 1.258 seconds Ordered by: cumulative time List reduced from 2662 to 100 due to restriction <100> ncalls tottime percall cumtime percall filename:lineno(function) 1 0.000 0.000 1.258 1.258 /data/pmpa/current/libs/framework/WebManager.py:135(_newRequest) 1 0.000 0.000 1.114 1.114 /data/pmpa/current/libs/framework/WebSite.py:167(processRequest) 1 0.000 0.000 1.095 1.095 /data/pmpa/current/libs/framework/BaseHandler.py:268(_safeCall) 1 0.000 0.000 1.095 1.095 /data/pmpa/current/generic/sites/www/forms/store/ProductFormPublic.py:31(index) 1 0.000 0.000 1.092 1.092 /data/pmpa/current/libs/framework/WebForm.py:189(view) 1 0.000 0.000 0.830 0.830 /data/pmpa/current/libs/framework/WebApp.py:276(writeHTMLWithWrap) 1 0.000 0.000 0.830 0.830 /data/pmpa/current/libs/framework/WebApp.py:212(wrapHTML) 1 0.000 0.000 0.729 0.729 /data/pmpa/current/libs/framework/baseScrapeAndDrape.py:72(__init__) 1 0.000 0.000 0.729 0.729 /data/pmpa/current/libs/framework/baseScrapeAndDrape.py:272(scrape) 1 0.000 0.000 0.474 0.474 /usr/lib/python3.11/urllib/request.py:139(urlopen) 1 0.000 0.000 0.473 0.473 /usr/lib/python3.11/urllib/request.py:500(open) 1 0.000 0.000 0.473 0.473 /usr/lib/python3.11/urllib/request.py:529(_open) 2 0.000 0.000 0.473 0.237 /usr/lib/python3.11/urllib/request.py:489(_call_chain) 1 0.000 0.000 0.473 0.473 /usr/lib/python3.11/urllib/request.py:1390(https_open) 1 0.000 0.000 0.473 0.473 /usr/lib/python3.11/urllib/request.py:1307(do_open) 16 0.000 0.000 0.425 0.027 /usr/lib/python3.11/socket.py:704(readinto) 16 0.000 0.000 0.425 0.027 /usr/lib/python3.11/ssl.py:1299(recv_into) 16 0.000 0.000 0.425 0.027 /usr/lib/python3.11/ssl.py:1157(read) 16 0.425 0.027 0.425 0.027 {method 'read' of '_ssl._SSLSocket' objects} 1 0.000 0.000 0.424 0.424 /usr/lib/python3.11/http/client.py:1371(getresponse) 1 0.000 0.000 0.424 0.424 /usr/lib/python3.11/http/client.py:323(begin) 84 0.000 0.000 0.424 0.005 {method 'readline' of '_io.BufferedReader' objects} 1 0.000 0.000 0.424 0.424 /usr/lib/python3.11/http/client.py:290(_read_status) 7/1 0.000 0.000 0.183 0.183 /data/pmpa/current/libs/framework/DGEGroup.py:53(getBBTDictionary) 10/1 0.000 0.000 0.183 0.183 /data/pmpa/current/libs/framework/DisplayGroup.py:571(getBBTDictionary) 12 0.000 0.000 0.170 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:115(__init__) 12 0.000 0.000 0.169 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/__init__.py:427(_feed) 12 0.000 0.000 0.169 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/builder/_html5lib.py:76(feed) 12 0.000 0.000 0.168 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:262(parse) 12 0.000 0.000 0.168 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:124(_parse) 12 0.006 0.000 0.167 0.014 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:195(mainLoop) 128 0.001 0.000 0.164 0.001 /data/pmpa/current/libs/framework/DGEAttribute.py:171(getBBTDictionary) 215/146 0.001 0.000 0.159 0.001 :666(_load_unlocked) 1 0.000 0.000 0.145 0.145 /data/pmpa/current/libs/framework/baseScrapeAndDrape.py:539(_addStylesAndScripts) 1 0.000 0.000 0.135 0.135 /data/pmpa/current/libs/framework/WebManager.py:89(createNewHandler) 1 0.001 0.001 0.135 0.135 /data/pmpa/current/libs/framework/WebSite.py:91(__init__) 14 0.000 0.000 0.126 0.009 /data/pmpa/current/libs/framework/baseScrapeAndDrape.py:378(getElm) 14 0.000 0.000 0.126 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/bs4/element.py:1839(select) 14 0.000 0.000 0.126 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/__init__.py:111(select) 2 0.000 0.000 0.124 0.062 /data/pmpa/current/libs/framework/baseScrapeAndDrape.py:362(rebuildSoup) 14 0.000 0.000 0.123 0.009 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1518(select) 22 0.000 0.000 0.123 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1523(iselect) 22 0.002 0.000 0.123 0.006 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1391(select) 355/174 0.003 0.000 0.113 0.001 {built-in method builtins.exec} 200/129 0.001 0.000 0.113 0.001 :1165(_find_and_load) 200/129 0.001 0.000 0.111 0.001 :1120(_find_and_load_unlocked) 218/149 0.000 0.000 0.104 0.001 :934(exec_module) 1 0.000 0.000 0.101 0.101 /data/pmpa/current/libs/framework/baseScrapeAndDrape.py:727(process) 441/273 0.000 0.000 0.096 0.000 :233(_call_with_frames_removed) 6631 0.005 0.000 0.094 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1422(match) 31886/31482 0.013 0.000 0.087 0.000 /data/pmpa/current/libs/framework/BaseHandler.py:1498(mxxImporter) 4503 0.013 0.000 0.077 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/_tokenizer.py:55(__iter__) 88 0.000 0.000 0.074 0.001 /data/pmpa/current/libs/framework/DGEAttribute.py:119(getViewHTMLFormxxView) 1 0.000 0.000 0.073 0.073 /data/pmpa/current/libs/framework/baseScrapeAndDrape.py:507(_includeMaxxJavascript) 1 0.000 0.000 0.072 0.072 /data/pmpa/current/libs/framework/baseScrapeAndDrape.py:486(_includeMaxxCSS) 6669/6631 0.007 0.000 0.072 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:1307(match_selectors) 31911/31486 0.010 0.000 0.071 0.000 {built-in method builtins.__import__} 12 0.000 0.000 0.070 0.006 /data/pmpa/current/libs/framework/DGEText.py:39(formatForViewing) 12 0.000 0.000 0.070 0.006 /data/pmpa/current/libs/framework/DGEText.py:14(formatLineBreaks) 2655/2630 0.002 0.000 0.068 0.000 /data/pmpa/current/libs/framework/LazyDict.py:186(__getitem__) 1 0.002 0.002 0.067 0.067 /data/pmpa/current/libs/framework/BaseHandler.py:463(_loadDisplayGroups) 51 0.000 0.000 0.067 0.001 /data/pmpa/current/libs/framework/BaseHandler.py:1367(importModule) 27 0.000 0.000 0.066 0.002 /data/pmpa/current/libs/framework/WebSite.py:1134(_loadModule) 1 0.000 0.000 0.065 0.065 /data/pmpa/current/libs/framework/WebForm.py:2854(getViewDG) 1 0.000 0.000 0.065 0.065 /data/pmpa/current/generic/sites/www/forms/store/ProductFormPublic.py:76(_getDGByName) 1 0.000 0.000 0.065 0.065 /data/pmpa/current/libs/framework/WebSite.py:973(getDGByName) 2 0.000 0.000 0.065 0.033 /data/pmpa/current/libs/framework/LazyDict.py:172(get) 23/1 0.000 0.000 0.065 0.065 /data/pmpa/current/libs/framework/BaseHandler.py:481(_createDisplayGroup) 114/1 0.000 0.000 0.065 0.065 /data/pmpa/current/libs/framework/DisplayGroup.py:631(_createDGE) 6/1 0.000 0.000 0.065 0.065 /data/pmpa/current/libs/framework/DisplayGroup.py:835(_createDGEGroup) 266 0.001 0.000 0.063 0.000 /data/pmpa/current/libs/framework/DTWrapper.py:47(__call__) 27 0.000 0.000 0.063 0.002 /usr/lib/python3.11/imp.py:220(load_module) 50 0.000 0.000 0.063 0.001 /data/pmpa/current/libs/framework/BaseHandler.py:1341(getModuleFromBase) 27 0.000 0.000 0.063 0.002 /usr/lib/python3.11/imp.py:166(load_source) 27 0.000 0.000 0.063 0.002 :711(_load) 266 0.002 0.000 0.062 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/DocumentTemplate/DT_String.py:408(__call__) 188 0.001 0.000 0.059 0.000 /usr/lib/python3.11/re/__init__.py:272(_compile) 23 0.000 0.000 0.058 0.003 /data/pmpa/current/libs/framework/BaseHandler.py:443(getDGClass) 23 0.000 0.000 0.058 0.003 /data/pmpa/current/libs/framework/BaseHandler.py:440(getDGModule) 66 0.000 0.000 0.058 0.001 /usr/lib/python3.11/re/__init__.py:225(compile) 18/13 0.000 0.000 0.058 0.004 /data/pmpa/current/libs/framework/DisplayGroup.py:766(_createDGEAssoc) 49 0.000 0.000 0.058 0.001 /usr/lib/python3.11/re/_compiler.py:740(compile) 218 0.000 0.000 0.057 0.000 :566(module_from_spec) 218 0.001 0.000 0.056 0.000 :493(_init_module_attrs) 436 0.001 0.000 0.055 0.000 :437(cache_from_source) 1 0.000 0.000 0.054 0.054 /data/pmpa/current/libs/framework/DisplayGroup.py:311(initialize) 436 0.000 0.000 0.054 0.000 :392(cached) 218 0.000 0.000 0.054 0.000 :567(_get_cached) 17/10 0.000 0.000 0.054 0.005 /data/pmpa/current/libs/framework/DGEAssocList.py:451(getDataDictionary) 110 0.000 0.000 0.054 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:171(execute) 6669 0.004 0.000 0.053 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/soupsieve/css_match.py:698(match_tag) 466 0.000 0.000 0.053 0.000 :132(_path_split) 12 0.000 0.000 0.053 0.004 /data/pmpa/current/libs/utils/emailTools.py:20(regexpEmailAndURLs) 1 0.000 0.000 0.053 0.053 /data/pmpa/current/libs/framework/baseScrapeAndDrape.py:672(addMetaTags) 1172 0.052 0.000 0.053 0.000 {built-in method builtins.max} 110 0.000 0.000 0.053 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/MySQLdb/cursors.py:316(_query) 1 0.000 0.000 0.052 0.052 /data/pmpa/current/libs/framework/WebManInterface.py:93(createBroker) 97/79 0.000 0.000 0.052 0.001 /data/pmpa/current/libs/PLayer/PersistentBroker.py:77(__new__) 8/5 0.000 0.000 0.050 0.010 /data/pmpa/current/libs/framework/DGEAssocList.py:379(getBBTDictionary) 1552/1462 0.001 0.000 0.049 0.000 /home/maxx/lib/matrixmaxx3/lib/python3.11/site-packages/html5lib/html5parser.py:454(processStartTag)